#Database

A single command to roll back applied migrations with Flyway Community Edition, no license, no undo command, no crying in the club.

I was pleasantly surprised and happy to see that my article ‘Your executable is a SQLite database’ resonated with people. It is a format I have been thinking about for a while, and the idea seems to have struck a chord with others.

DuckDB v2.0 is coming this fall. In this post, we preview its headline features: DuckDB as a server, triggers, the VARIANT type, asynchronous I/O, a new SQL parser, a new storage format, and much more.

I’ve come to the conclusion that, for me, ORMs are more detriment than benefit. In short, they can be used to nicely augment working with SQL in a program, but they should not replace it.

Hunting a 16-year-old SQLite bug with TLA+: We model the WAL race condition to reproduce the issue, verify the fix, and analyze if dqlite is vulnerable.

Dedicated to the Minnowbrook Analytic Reasoning Seminar with special thanks to Kris Micinski and Michael Ballantyne

ORA-00265: Instance Recovery Required, Cannot Set ARCHIVELOG Mode ORA-00265 occurs when a...

Explore 10 top open-source GitHub repositories for modern databases, analytics, SQL, caching, monitoring, replication, PostgreSQL, SQLite, and AI agent memory.

In today’s fast-paced digital environment, teams are drowning in unstructured information. Manually...

ORA-00203: Using the Wrong Control Files ORA-00203 is a critical Oracle database error...

Introduction For decades, accessing business data has required technical skills. If you wanted to...

AstralDB, a custom RDBMS I've initially began working on last year and picked back up a month and a half ago managed to outperform both DuckDB and SQLite on a torture test query by orders of magnitude with WAL, encryption, and logging still enabled.…

Boost your database skills with our interactive MySQL tutorial. Learn to simplify complex queries using Views and perform powerful data analysis with Window Functions.

A few years ago, I was staring at a red, blinking monitoring dashboard. The system I was looking at...

What determines whether a database is suitable for a production environment is not the fancy...

Happy to announce HeliosProxy !! Far beyond a pooling tool, HeliosProxy ** is a next-gen programmable...