Sébastien Rigaux

Tech watch

← All links

SQL

Defining and manipulating relational data through queries, schemas and transactions.

Lix graphic on a dark background describing an embeddable repository that combines files, an SQL database, and version control, with JavaScript, Python, Rust, and Go named below.

Lix brings file history and SQL tables together in one repository, so teams can branch, diff, merge, or roll back changes spanning documents and application data. The library embeds in a product and supports storage in memory, on a filesystem, in browser OPFS, or on S3.

Its distinction is versioning SQL rows rather than just the bytes of a SQLite database committed to Git. Tracked writes are recorded automatically, and history and changes can be queried with SQL. Lix is listed as being in alpha.

Screenshot of the drawDB page, showing a database schema diagram beneath the heading and navigation buttons.

drawDB turns relational schema design into a visual workflow: draw tables and relationships, then generate DDL for multiple SQL dialects or export the diagram. The free editor runs in the browser without an account and stores diagrams locally in IndexedDB.

To work from an existing model, import a DDL script to rebuild its diagram; drawDB also offers migration generation and issue detection. The open-source repository can be run on your own infrastructure with Docker, keeping diagrams within your network.

drawDB