# SQL · Tech watch

[Canonical source](<https://sebastien.rigaux.be/en/tech-watch/tags/sql>)

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

## [Lix versions files and SQL tables in one repository](<https://sebastien.rigaux.be/en/tech-watch/links/lix-versions-files-and-sql-tables-in-one-repository>)

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.

2026-11-16 · [Markdown](<https://sebastien.rigaux.be/en/tech-watch/links/lix-versions-files-and-sql-tables-in-one-repository.md>) · [Original resource](<https://lix.dev/>)

## [drawDB: design SQL schemas from ERD to migration](<https://sebastien.rigaux.be/en/tech-watch/links/drawdb-design-sql-schemas-from-erd-to-migration>)

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.

2026-11-08 · [Markdown](<https://sebastien.rigaux.be/en/tech-watch/links/drawdb-design-sql-schemas-from-erd-to-migration.md>) · [Original resource](<https://www.drawdb.app/>)

## [Turn a SQL database into a no-code interface with NocoDB](<https://sebastien.rigaux.be/en/tech-watch/links/turn-a-sql-database-into-a-no-code-interface-with-nocodb>)

NocoDB adds a spreadsheet-like interface to an existing or newly created database, with Kanban, form, and gallery views. SQL and API access connect no-code editing with existing systems.

2026-06-01 · [Markdown](<https://sebastien.rigaux.be/en/tech-watch/links/turn-a-sql-database-into-a-no-code-interface-with-nocodb.md>) · [Original resource](<https://nocodb.com/>)

## [Anyquery: query files and applications with SQL](<https://sebastien.rigaux.be/en/tech-watch/links/anyquery-query-files-and-applications-with-sql>)

Anyquery extends SQLite through plugins that query files and application services. It also offers an MCP connection for making those sources available to AI assistants.

2025-04-22 · [Markdown](<https://sebastien.rigaux.be/en/tech-watch/links/anyquery-query-files-and-applications-with-sql.md>) · [Original resource](<https://github.com/julien040/anyquery>)
