LibreDB Studio is an open source SQL IDE that runs in the browser. It talks to 42 external engines today: PostgreSQL, MySQL, Oracle, ClickHouse, MongoDB, Redis, Kafka, Kubernetes and a long tail after that.
Every one of those engines has small facts of its own. How it writes a bind placeholder. How it quotes an identifier. Whether a backslash inside a string literal is data or an escape. Which column types lose precision when they pass through JavaScript.
For a long time those facts lived wherever someone first needed them. This post is about how we moved all of them next to the driver that owns them, and the test that keeps them there.
What it looked like
Here is one function from our shared SQL helpers, as it was in October.…