· software
UUID’s in Rails + SQLite shouldn’t be this hard (so I built a gem)
TL;DR – UUIDs / ULIDs in a Rails + SQLite app ruby Gemfile gem 'sqlite_crypto' ruby migration create_table :users, id: :uuid do |t| t.string :email t.timestamp...
-
- · software
Bringing True SQLite to the Browser with OPFS 🚀
!Cover image for Bringing True SQLite to the Browser with OPFS 🚀https://media2.dev.to/dynamic/image/width=1000,height=420,fit=cover,gravity=auto,format=auto/ht...
- · software
How SQLite is tested
Article URL: https://sqlite.org/testing.html Comments URL: https://news.ycombinator.com/item?id=46303277 Points: 85 Comments: 8...
- · software
How SQLite Is Tested
Article URL: https://sqlite.org/testing.html Comments URL: https://news.ycombinator.com/item?id=46303277 Points: 27 Comments: 2...
- · software
Short-Circuiting Correlated Subqueries in SQLite
Article URL: https://emschwartz.me/short-circuiting-correlated-subqueries-in-sqlite/ Comments URL: https://news.ycombinator.com/item?id=46300776 Points: 6 Comme...
- · software
High-Performance SQLite Reads in a Go Server
Workload Assumptions These recommendations assume: - Reads dominate writes are rare or offline - A single server process owns the database - Multiple goroutine...
- · software
SQLite JSON at Full Index Speed Using Generated Columns
Article URL: https://www.dbpro.app/blog/sqlite-json-virtual-columns-indexing Comments URL: https://news.ycombinator.com/item?id=46243904 Points: 8 Comments: 1...
- · software
100k TPS over a billion rows: the unreasonable effectiveness of SQLite
Article URL: https://andersmurphy.com/2025/12/02/100000-tps-over-a-billion-rows-the-unreasonable-effectiveness-of-sqlite.html Comments URL: https://news.ycombin...