geol now supports exporting to sqlite.

[adriens]

Hi guys, it is now easier than ever to get endoflife.date database as a SQLite database from a single geol command :

geol export sqlite

Full YT demo here, see issue for more :

• 📤 Add export and SQLite sub-command : geol export sqlite opt-nc/geol#97

[captn3m0]

Is the schema well-documented?

[adriens]

Feature	DuckDB	SQLite
PRIMARY KEYS, FOREIGN KEYS, CHECK CONSTRAINTS	✔️	✔️
COMMENTS on tables and columns as metadatas	✔️ See video	❌ See issue

📸 Demo on duckdb

[adriens]

@captn3m0 , you may like this :

• 🍺 Consider deliver as a brew package schemacrawler/SchemaCrawler-Installers#23 (comment)

[adriens]

Documentation automatin w. schemacrawler

geol_duckdb_doc.html

geol_doc.html