Calíope blog
Real problems from my work with databases: how they showed up, how I investigated them and how I solved them, with the SQL for each engine.
I’m a database administration engineer by training, and I’ve worked as a DBA since 2016. I also have an academic background in education, and that is where this blog comes from: what took me a real shift to learn can save someone else that shift. It isn’t a catalog of the app; Calíope only shows up when it really helps solve the problem. And I run the SQL in every entry before publishing it, on every engine it says it works on.
The ways I filled tables to test an application, from the most naive to the one I use today: INSERTs by hand, the table that copies itself, a series generated with SQL and a procedure that reads the columns. With the code for each database engine and the version where it starts to work.
Test dataDevelopmentMySQLMariaDBPostgreSQLSQLiteSQL ServerOracleClickHouse
No entry matches that search.