The next-gen SQLite won't look like SQLite
https://gist.github.com/radarroark/03a0724484e1111ef4c05d72a935c42c
#HackerNews #nextgenSQLite #SQLite #evolution #database #technology #innovation
TIL that #SQLite doesn't allow union queries when there's a limit applied. That stinks.
Travis F W
boosted
I downloaded my Reddit history archive. It has a giant list of every comment I've ever made, as a CSV file.
I wanted to look at each comment, in context, on #Reddit. (To do that you need to open the URL in your browser with ?context=9 appended to the URL.)
At first, I loaded this behemoth into LibreOffice Calc, but it does not like data that big.
Then I was like, “hey wait, this is basically a database.” So I loaded it into SQLite.
#SQLite has absolutely no problem with data that big. 😌
I downloaded my Reddit history archive. It has a giant list of every comment I've ever made, as a CSV file.
I wanted to look at each comment, in context, on #Reddit. (To do that you need to open the URL in your browser with ?context=9 appended to the URL.)
At first, I loaded this behemoth into LibreOffice Calc, but it does not like data that big.
Then I was like, “hey wait, this is basically a database.” So I loaded it into SQLite.
#SQLite has absolutely no problem with data that big. 😌
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