Sunday, December 9, 2012

Dark Eclipse Theme

Found this dark eclipse theme that is very easy on the eyes.

Link


Along with the Eclipse Color Themes and Solarized it makes the inner programmer in me very happy.



Monday, November 26, 2012

Tracking Mod-Queries for Mysql Table

Ok, so I needed to track down a ten year old query that is dynamically generated from "who knows!".
  1. Step One!
    1. Find where the database is getting updated from!!!!


You can log all queries via a global general log.
Downfall is that it slows down the database due to the additional operations that are performed.

SET GLOBAL GENERAL_LOG='ON';
SET GLOBAL LOG_OUTPUT='TABLE';

Query the log via…

Select * from mysql.general_log where argument LIKE ‘start of query%’;


Make sure to shut off the log when done!

SET GLOBAL GENERAL_LOG='OFF';

Hope this helps!



This does not work, but if you have an idea of how to improve it, let me know.
This sets up a trigger that will log any queries that modify trackTableName in the DBNAME database.


<<<<<< SQL

create table if not exists DBNAME.trigger_log LIKE INFORMATION_SCHEMA.PROCESSLIST;

delimiter |

DROP TRIGGER IF EXISTS clickTrigger|
CREATE TRIGGER clickTrigger BEFORE INSERT ON DBNAME.trackTableName
  FOR EACH ROW BEGIN
    INSERT INTO DBNAME.trigger_log SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id = CONNECTION_ID();
  END;
|

delimiter ;



delimiter |

DROP TRIGGER IF EXISTS clickTriggerUpdate|
CREATE TRIGGER clickTriggerUpdate BEFORE UPDATE ON DBNAME.trackTableName
  FOR EACH ROW BEGIN
    INSERT INTO DBNAME.trigger_log SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id = CONNECTION_ID();
  END;
|

delimiter ;




delimiter |

DROP TRIGGER IF EXISTS clickTriggerDelete|
CREATE TRIGGER clickTriggerDelete BEFORE Delete ON DBNAME.trackTableName
  FOR EACH ROW BEGIN
    INSERT INTO DBNAME.trigger_log SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE id = CONNECTION_ID();
  END;
|

delimiter ;
>>>>>> /SQL

---- update -----
This is not what I expected.
It is logging the trigger sql, not the query that does the update/insert/delete.

This may work?
http://stackoverflow.com/a/10654126/1267277

Wednesday, November 21, 2012

Systems Administrator at the Broker Exchange Network, LLC, Available Now.





We need another Sys Admin!

   Position responsibilities include networking with Dell and Cisco devices, Astaro and Watchgard firewalls, Barracuda load-balancers. Also systems administration and building for mostly Dell based servers including Fusion-IO cards, DAS, NAS and other solutions for performance. These systems run Linux varieties, primarily CentOS. These include web servers and database servers running Linux, Apache, MySQL, Php (LAMP). Other languages, such as Java, may be used on some of these servers also. There is also a few Microsoft servers in office for file sharing and a few other tasks.




Check out our pages on facebook and our primary websites!





Friday, August 31, 2012

"Call Me" glove, the true power glove

Hi-Fun's call-receiving Bluetooth gloves, hands-in

Hi-Fun's gloves are Bluetooth "hand sets" with the speaker built into the thumb and the mic in the pinky. You then use the "call me" sign language to perform a call.

Pairing and call end buttons are on the top of your wrist. Seems that the only concern is the max volume on the thumb speaker and possibly the quality of the mic in loud settings.  At least you could say "Sorry my thumb can't hear you" or "I cannot hear you through my thumb".


Hi-Call should be out in the beginning of October 2012, just in time for the cold weather.



$4 OFF $40 Sitewide Coupon with code: MB4OFF Valid from: 2012.8.1-2012.8.31
525035_70% Off at SuppliesOutlet.com

Wednesday, August 29, 2012

A RESTful CRUD controller for FuelPHP

A RESTful CRUD controller for FuelPHP


https://github.com/Artistan/FuelPHP-RESTful-CRUD-Controller

For the most part, HTTP verbs map directly to functions (e.g. GET /controllername => function get()). The client can choose the return format by specifying an extension (see the documentation for Controller_Rest in FuelPHP).
GET requests can invoke one of three methods.
  • When one or more arguments are specified, it will try to invoke {Input::method}_{resource1}.
  • Otherwise it will invode {Input::method}_index();
  • When no arguments are specified, it will try to invoke get_list($page) (falling back to get(...) or get_index).
  • When the search GET paramater is populated, it will invoke get_search($query, $page), falling back to get_list($page), and finally get(...) or get_index.



Labor Day Special: 100 Deluxe Custom Pens - only $39 (exp 9/2)
371374_Lennox  Whole House Air Filters

Tuesday, August 28, 2012




Geek Crafts


necklace

Too bad the owner/operator of casstasstrophe shut down the site.  I know some geek gals that would love this necklace.



















Geeks do like shiney things

CarGeek @ http://gizmodo.com/

Pay Per Like has a nice quote about geeks.


None of these are truly good design, they’re just gimmicks. Most geeks tend to be attracted to these shiny things.


CloJure

http://clojure.org

http://clojure.org/

Very interesting language



http://clojure.org/rationale
Why did I write yet another programming language? Basically because I wanted:

  • A Lisp
  • for Functional Programming
  • symbiotic with an established Platform
  • designed for Concurrency
Clojure is a Lisp not constrained by backwards compatibility
  • Extends the code-as-data paradigm to maps and vectors
  • Defaults to immutability
  • Core data structures are extensible abstractions
  • Embraces a platform (JVM)

Short Links

So there are a lot of short url sites.

By short url sites, I mean sites that will save a long url for you and provide a short one that you can use in tweets, blogs, and other things that limit your text. Most of these sites will even provide analysis on who, when, where, and how these links are clicked.

There is also sites that expand the short urls, so you may see what they are linking to.
http://longurl.org/

Tagaroo Tagging

 Tagaroo

For all my WordPress buddies out there.
 
This is a very simple plugin for WordPress that helps bloggers add content tags and images based on the content that they have in their post! Very cool stuff, future of SEO optimizations for bloggers, next they need to provide relevant content additions based on your typed content.

Edit:

Other ways people are using opencalais.com systems...
http://www.opencalais.com/showcase

And you could do it all yourself:
http://www.opencalais.com/documentation/opencalais-documentation

Some sites are using it also...
this forum post states...
 "I don't know about tinyurl but bit.ly is using semantic analysis of every page that goes through its system using Reuters' Open Calais api. It will be able to create meme tracker, geo spatial information, etc. and sell those information to web research farms. It will be able create trend management software using millions of pages that are posted in Twitter. Bit.ly has only 12% market share but its adoption by Twitter will propel it to a higher market share."

Monday, August 27, 2012

Piggy USBy

Piggy USBy
A friend posted this pig (on the right) today and I just had to check it out and see what I could find for USB fun.  I was able to find some funny little memory pigs that allow you to hog some memory. Ha Ha.  Ya, that was lame.  Hopefully this is fun for someone!