Readit Newschmaynard commented on Modernizing Linux swapping: introducing the swap table lwn.net/SubscriberLink/10... · Posted by u/chmaynard
Second installment: https://news.ycombinator.com/item?id=46901662
chmaynard commented on Sqldef: Idempotent schema management tool for MySQL, PostgreSQL, SQLite sqldef.github.io/... · Posted by u/Palmik
This post from 2022 is the one I keep going back to
https://david.rothlis.net/declarative-schema-migration-for-s...
See also: https://www.sqlite.org/sqldiff.html
chmaynard commented on Sqldef: Idempotent schema management tool for MySQL, PostgreSQL, SQLite sqldef.github.io/... · Posted by u/Palmik
Minor quibble: sqlite3 is not a database, it's the CLI for SQLite 3.x
I admire what you are doing. It obviously serves you well and you hope it helps others.
I'm familiar with how to import CSV data with SQLite and I could probably learn how to do it with DuckDB with ease. Your tool introduces a new and rather shallow abstraction layer with commands that work for both databases.
The world needs tools that provide a great deal of utility, are trustworthy, and keep getting more reliable and capable. I'm not sure that yours will qualify.