New Event Feature in MySQL 5.1.6

Posted Jan 19, 2006 8:34 UTC (Thu) by jwb (guest, #15467)
Parent article: New Event Feature in MySQL 5.1.6

As a MySQL user and paying customer, I know that the top of my wishlist reads "Implement a half-baked buggy featureless version of cron". Thank you MySQL AB for this wonderful contribution to humanity.

I can only assume that somewhere out there exists a version of the cron daemon which stores the crontabs in a MySQL table, making a kind of perfect Escher-like cycle of horror.

New Event Feature in MySQL 5.1.6

Posted Jan 19, 2006 10:59 UTC (Thu) by nix (subscriber, #2304) [Link] (2 responses)

I have a hideous vision of combining this with PostgreSQL's Point-In-Time Recovery feature.

'If the time has moved back to {X time somewhere in the past}...'

New Event Feature in MySQL 5.1.6

Posted Jan 26, 2006 1:18 UTC (Thu) by pimlott (guest, #1535) [Link] (1 responses)

While jwb's post was riotous, the ability to run a query "in the past" would be terribly useful. Imagine you find out today that your database-using application did something wacko yesterday. You want to figure out why, but the data's changed in the meantime. Encoding time-series data yourself is quite tedious, so in a perfect world the DBMS would do it. Of course, this should be an on-line, not recovery, feature.

New Event Feature in MySQL 5.1.6

Posted Jan 26, 2006 20:04 UTC (Thu) by nix (subscriber, #2304) [Link]

And of course having gone back, changes should lead to the creation of a branch! w00t!

(er, OK, perhaps not... although I *have* designed a database-backed filesystem sitting atop FUSE which works like this. Now all I have to do is *implement* the damn thing.)