• Three wishes for a new year

    September 27, 2011

    It's another new year by Jewish calendar. And what do I wish for in the following year? World peace Good health to all Have some way to turn SHOW commands into SELECT statements, server side. I'm fervently trying to hack around this. Stored routines, export/import from file, text manipulation, I don't care! I want to […]

  • common_schema rev. 68: eval(), processlist_grantees, candidate_keys, easter_day()

    September 6, 2011

    Revision 68 of common_schema is out, and includes some interesting features: eval(): Evaluates the queries generated by a given query match_grantee(): Match an existing account based on user+host processlist_grantees: Assigning of GRANTEEs for connected processes candidate_keys: Listing of prioritized candidate keys: keys which are UNIQUE, by order of best-use. easter_day(): Returns DATE of easter day […]

  • MySQL eval()

    September 6, 2011

    I've just implemented an eval() call for MySQL. It is implemented with SQL, using a stored procedure. So this is not some plugin: you can use it from within your normal database server. Just what is an eval() call? In some programming languages it would mean: get some text, and execute it as though it […]

  • You know you've been doing too much SQL when...

    September 1, 2011

    ...you're traveling on family holiday, and each time you wish to suggest you should check up on the tourist information center, you repeatedly come up with: "Let's ask at the INFORMATION_SCHEMA and see what we can get". Also, doing so while wearing an OpenSQL Camp T-shirt doesn't help.

 
Powered by Wordpress and MySQL. Theme by openark.org