MySQL's TIMESTAMP column runs out at 03:14:07 UTC on 19 January 2038.
That's only a bit over 11 years away. Store a warranty expiry or lease end date further ahead than that and it won't fit.
DATETIME goes to 9999. One old 32-bit limit still lurking in modern schemas.
While adding MySQL support to Hyperdrive, we found a subtle protocol bug when caching query results. Here is how we tracked down a 0.001% rate error and made Hyperdrive MySQL generally available.
Connects to PostgreSQL, MySQL, SQLite, Redis, MongoDB, SQL Server, and ClickHouse through a single native desktop application with a built-in MCP server.
Unifies access to PostgreSQL, MySQL, SQLite, and 15+ additional databases through a single desktop application featuring an internal MCP server for AI agent connectivity.
Moving a WordPress site? Don't run MySQL REPLACE() on the old URL.
Some settings are stored as serialised PHP, with string lengths baked in. Change the URL without updating those lengths and things break.
Use wp search-replace instead. Back up first and try --dry-run.
more codemode fun, doing a large mysql operation and the agent wanted to do it 50K rows at a time
it writes a single codemode script which runs it in a loop
and then you visualize it step by step even though it's code