SQLite

SQL

SELECT 
    m.tbl_name AS table_name,
    p.name AS column_name,
    p.type AS data_type,
    CASE p.pk WHEN 1 THEN 'PRIMARY KEY' ELSE '' END AS key,
    CASE p."notnull" WHEN 0 THEN 'NULL' ELSE 'NOT NULL' END AS nullable
FROM 
    sqlite_master m
    LEFT JOIN pragma_table_info(m.name) p
WHERE 
    m.type = 'table' AND
    m.name NOT LIKE 'sqlite_%'
ORDER BY 
    m.tbl_name,
    p.cid;

Links

Aaron Francis@aarondfrancisJun 28, 2024

🎉 High Performance SQLite is live! This video course covers everything you need to know about SQLite. It's 65 videos across 6 modules, with at least 20 more videos to come. We're launching in early access today, so the price is currently discounted! Y'all go get it! https://t.co/t4JrO4MTD9

check outerbase

Brayden Wilmoth@BraydenWilmothNov 12, 2024

Crazy how quickly a SQLite Durable Object can respond via HTTP request while querying the database. 51ms... https://t.co/tN31DxmZgA

https://blog.sylver.dev/build-your-own-sqlite-part-4-reading-tables-metadata

https://boyter.org/posts/searchcode-bigger-sqlite-than-you (post)

https://pid1.dev/posts/siren-call-of-sqlite-on-the-server/ (hn)

https://github.com/sqliteai/sqlite-js hn

https://github.com/sqliteai/sqlite-js

https://www.reddit.com/r/selfhosted/comments/1lb78z1/trailbase_014_submillisecond_open/

https://github.com/danthegoodman1/gRPSQLite