logo
Updated

SQLite

SQL

list all tables

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

https://github.com/trailbaseio/trailbase #now

neat start https://github.com/trailbaseio/trailbase/blob/main/trailbase-cli/src/bin/trail.rs

Aaron Francis
Aaron Francis@aarondfrancis
🎉 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
Brayden Wilmoth@BraydenWilmoth
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)