22 GB of hacker news in SQLite
https://hackerbook.dosaygo.com
#HackerNews #HackerNews #SQLite #DataAnalysis #DataStorage #TechNews #22GBInsights
Chip Butty
boosted
just updated litehug to include examples for using it from #lua for #sqlite queries
https://git.sr.ht/~technomancy/litehug
not that you couldn't before, but now it's a lot more obvious how it works... feedback welcome!
just updated litehug to include examples for using it from #lua for #sqlite queries
https://git.sr.ht/~technomancy/litehug
not that you couldn't before, but now it's a lot more obvious how it works... feedback welcome!
A local-first memory store for LLM agents (SQLite)
https://github.com/CaviraOSS/OpenMemory
#HackerNews #localfirst #LLM #SQLite #memorystore #OpenMemory #techinnovation
alcinnz
boosted
This is TSQLparser, a complete T-SQL parser written in Go. It's the kind of thing you use when you want to abandon Microsoft SQL Server for good (parser, lexer, and AST builder, to be exact).
And here it is, GPL 3.0 licenced, or email me if you have any other ideas:
h@ual.fi
https://github.com/ha1tch/tsqlparser
#golang #foss #tsql #mssql #mssqlserver #db #database #parser #microsoft #sql #sqlite #postgres
How SQLite Is Tested
https://sqlite.org/testing.html
#HackerNews #SQLite #Testing #Software #Development #Database #Technology #Programming
SQLite JSON at Full Index Speed Using Generated Columns
https://www.dbpro.app/blog/sqlite-json-virtual-columns-indexing
#HackerNews #SQLite #JSON #GeneratedColumns #Indexing #DatabasePerformance
This is TSQLparser, a complete T-SQL parser written in Go. It's the kind of thing you use when you want to abandon Microsoft SQL Server for good (parser, lexer, and AST builder, to be exact).
And here it is, GPL 3.0 licenced, or email me if you have any other ideas:
h@ual.fi
https://github.com/ha1tch/tsqlparser
#golang #foss #tsql #mssql #mssqlserver #db #database #parser #microsoft #sql #sqlite #postgres
Rqlite is a feature-rich, rock-solid, fault-tolerant, distributed relational database built on SQLite. It's lightweight, developer-friendly, and exceptionally easy to operate, offering effortless installation and deployment.
By removing network latency, a major bottleneck for databases like Postgres, SQLite avoids Amdahl's Law. The single writer allows for easy batching, enabling it to handle over 100,000 transactions per second with serializable isolation in benchmarks, outperforming a networked database in this scenario.
Dreamed that someone in #gentoo had put out an announcement about @librecast saying that we used mjolnirdb for our test data, which I'd never heard of.
I just had to check. There is no mjolnirdb. I usually use #lmdb (or #sqlite if we need a SQL interface) 😉
100000 TPS over a billion rows: the unreasonable effectiveness of SQLite
#HackerNews #SQLite #TPS #effectiveness #database #performance #scalability
Building a Durable Execution Engine with SQLite
https://www.morling.dev/blog/building-durable-execution-engine-with-sqlite/
#HackerNews #Building #Durable #Execution #Engine #SQLite #HackerNews #TechBlog #Database
SQLite concurrency and why you should care about it
https://jellyfin.org/posts/SQLite-locking/
#HackerNews #SQLite #Concurrency #SQLite #Performance #Database #Management #Tech #Insights
phildini
boosted
What if Django had an automatic ORM feature matrix — showing which features each database really supports, straight from the code? 🧩
I’ve shared some ideas (with demo data!) on how it could work and why it’d be great for Django’s docs 💡
https://www.paulox.net/2025/10/06/django-orm-comparison/
CC @django
#Django #Python #ORM #OpenSource #Database #PostgreSQL #SQLite #MariaDB #MySQL
What if Django had an automatic ORM feature matrix — showing which features each database really supports, straight from the code? 🧩
I’ve shared some ideas (with demo data!) on how it could work and why it’d be great for Django’s docs 💡
https://www.paulox.net/2025/10/06/django-orm-comparison/
CC @django
#Django #Python #ORM #OpenSource #Database #PostgreSQL #SQLite #MariaDB #MySQL
Eleventy 🎈 v4.0.0-alpha.6
boosted
