Hacker News with Generative AI: SQLite

What every developer needs to know about in-process databases (graphgeeks.org)
SQLite, the mother of all in-process (aka embedded, embeddable, or serverless) DBMSs, has been wildly popular for over two decades.
Databases, Software Development, SQLite
10 points by semihs 1 day ago | 1 comments
SQLite transactions and virtual tables (misfra.me)
In my previous post I introduced SQL virtual tables and how to use them in Go—registering modules per connection, defining schemas, and querying external sources as regular tables.
Databases, Go Programming, Virtual Tables, SQLite
103 points by preetamjinka 9 days ago | 9 comments
All Databases Are Just Files (tselai.com)
SQLite and DuckDB have earned their popularity in the data world, and for good reason. I’m a big fan of both. Their appeal is simple: they’re just files. You can see, copy, and move them around like any other file.
Databases, Software, Data, Files, SQLite, DuckDB
6 points by azhenley 9 days ago | 0 comments
SQLite File Format Viewer (pages.dev)
SQLite, Databases, Tools
273 points by ilumanty 12 days ago | 41 comments
Show HN: SQLite? Postgres? Use both with omni_SQLite (omnigres.org)
omni_sqlite is an extension that adds the capability to use SQLite databases as a first-class data type within Postgres. It uses expandable datum technique to ensure no additional serialization overhead for data in-flight.
Databases, PostgreSQL, SQLite, Software, Extensions
12 points by michelpp 25 days ago | 0 comments
Optimizing a large SQLite database for reading (jacobfilipp.com)
I recently needed to speed up a simple read query on a large SQLite file (620Mb), for my grocery price CSV export tool.
Databases, SQLite, Performance Optimization, Data Analysis
5 points by hinkley 53 days ago | 1 comments
Virtual Tables in SQLite with Go (misfra.me)
SQLite’s virtual tables let you expose external data sources as if they were normal tables. The go-sqlite3 package includes an example of how to register a custom module, but it doesn’t cover cases where you need to initialize the module differently per connection.
Databases, Programming, Go, SQLite
4 points by preetamjinka 65 days ago | 0 comments
Build your own SQLite in Rust, Part 5: Evaluating queries (sylver.dev)
In the previous posts, we've explored the SQLite file format and built a simple SQL parser. It's time to put these pieces together and implement a query evaluator!
Rust, Databases, Programming, SQLite, Query Optimization
216 points by todsacerdoti 65 days ago | 27 comments
Searchcode.com’s SQLite database is probably 6 terabytes bigger than yours (boyter.org)
searchcode.com’s SQLite database is probably one of the largest in the world, at least for a public facing website. It’s actual size is 6.4 TB. Which is probably 6 terabytes bigger than yours.
Databases, SQLite, Search Engines, Technology
242 points by polyrand 68 days ago | 95 comments
Show HN: SQLite disk page explorer (github.com/QuadrupleA)
A small GUI application built in redbean that lets you explore your SQLite databases "page by page" the way SQLite sees them.
Software, Databases, SQLite, GUI
288 points by QuadrupleA 79 days ago | 41 comments
Build your own SQLite, Part 4: reading tables metadata (sylver.dev)
As we saw in the opening post, SQLite stores metadata about tables in a special "schema table" starting on page 1. We've been reading records from this table to list the tables in the current database, but before we can start evaluating SQL queries against user-defined tables, we need to extract more information from the schema table.
Databases, SQLite, Programming, Tutorials
135 points by thunderbong 81 days ago | 11 comments
GarminDB (github.com/tcgoetz)
Python scripts for parsing health data into and manipulating data in a SQLite database. SQLite is a light weight database that doesn't require a server.
Python, Databases, Health Data, SQLite
326 points by haltcatchfire 82 days ago | 72 comments
SQLook – A free online SQLite database manager with a Windows 2000 interface (sqlook.com)
SQLook is a modern web-based SQLite database manager with a nostalgic Windows 2000 interface.
Databases, Web Development, User Interfaces, Nostalgic Design, SQLite
178 points by gringow 90 days ago | 72 comments
Supercharge SQLite with Ruby Functions (julik.nl)
An interesting twist in my recent usage of SQLite was the fact that I noticed my research scripts and the database intertwine more. SQLite is unique in that it really lives in-process, unlike standalone database servers. There is a feature to that which does not get used very frequently, but can be indispensable in some situations.
Ruby, SQLite, Databases, Programming, Performance
159 points by julik 92 days ago | 43 comments
We will rewrite SQLite. And we are going all-in (turso.tech)
Two years ago, we made a bet: SQLite, the most successful database in history, could be even better.
Databases, SQLite, Open Source
17 points by mpereira 95 days ago | 3 comments
Show HN: Postgres-SQLite: SQLite as first-class types in Postgres (github.com/michelp)
postgres-sqlite is a PostgreSQL extension that introduces SQLite databases as a first-class data type within PostgreSQL.
Databases, PostgreSQL, SQLite, Extensions
15 points by michelpp 112 days ago | 2 comments
Speeding Up SQLite Inserts (julik.nl)
In my work I tend to reach for SQLite more and more. The type of work I find it useful for most these days is quickly amalgamating, dissecting, collecting and analyzing large data sets. As I have outlined in my Euruko talk on scheduling, a key element of the project was writing a simulator. That simulator outputs metrics - lots and lots of metrics, which resemble what our APM solution collects.
Databases, Performance Optimization, SQLite
14 points by julik 113 days ago | 3 comments
Fun facts about SQLite (avi.im)
SQLite is the most deployed and most used database. There are over one trillion (1000000000000 or a million million) SQLite databases in active use.
Databases, SQLite, Fun Facts
393 points by avinassh 117 days ago | 191 comments
How bloom filters made SQLite 10x faster (avi.im)
This is the fascinating story of how researchers used Bloom filters cleverly to make SQLite 10x faster for analytical queries.
Database, Performance, Optimization, SQLite, Bloom Filters
504 points by avinassh 125 days ago | 121 comments
Show HN: NoSQL, but it's SQLite (github.com)
SQLite-backed key-value store with JS-like object manipulation and automatic JSON serialization.
Databases, NoSQL, JavaScript, SQLite
98 points by vsroy 125 days ago | 39 comments
Cr-SQLite – Multi-writer and CRDT support for SQLite (github.com/vlcn-io)
CR-SQLite is a run-time loadable extension for SQLite and libSQL. It allows merging different SQLite databases together that have taken independent writes.
Databases, SQLite, Software, Open Source
30 points by apitman 130 days ago | 2 comments
Limbo: A complete rewrite of SQLite in Rust (turso.tech)
Today we are announcing a more ambitious experiment: what could we achieve, if we were to completely rewrite SQLite in a memory-safe language (Rust)? With the Limbo project, now available at github.com/tursodatabase/limbo, we are now trying to answer that question.
Rust, Databases, SQLite, Programming Languages, Open Source
373 points by avinassh 137 days ago | 232 comments
Sensible SQLite Defaults (briandouglas.ie)
SQLite is cool now. DHH uses it, Laravel defaults to it. Here is a list of sensible defaults when using sqlite.
Databases, SQLite, Software Development
223 points by thunderbong 141 days ago | 67 comments
SQLite Index Visualization: Search (mrsuh.com)
In the previous post, I explained how to extract data from SQLite Indexes and make it visual. This time, I'll try to show what a search inside an Index looks like.
SQLite, Databases, Visualization, Search
15 points by mrsuh 145 days ago | 0 comments
Big Endian's Guide to SQLite Storage (jabid.in)
I wanted to learn how databases like SQLite store data under the hood, so I decided to write some code to inspect the database file. SQLite famously stores the entire database in a single file, and the file format is very well documented. Here is one diagram1 to get started instead of the roughly 13,848 words in that document.
Databases, SQLite, Programming, Data Storage, Software
38 points by marcobambini 145 days ago | 0 comments
SQLite-utils: a tool for manipulating SQLite databases (datasette.io)
CLI tool and Python library for manipulating SQLite databases
Databases, SQLite, Tools, Python
9 points by mpbart 152 days ago | 0 comments
SQLiteStudio: Create, edit, browse SQLite databases (sqlitestudio.pl)
It's a hotfix release to address urgent problem of "black SQL code line" that appeared in 3.4.5. It also gets two more issues resolved.
SQLite, Databases, Software, Bug Fixes
626 points by thunderbong 152 days ago | 123 comments
Sqlpkg – The SQLite Extension Hub (sqlpkg.org)
Find SQLite extensions using the search box above. You can download and install them manually, or use the sqlpkg package manager.
SQLite, Database, Tools, Package Management
5 points by thunderbong 153 days ago | 0 comments
SQLite’s Use of Tcl (2017) (tcl.tk)
SQLite is a TCL extension that has escaped into the wild.
Databases, Programming Languages, TCL, SQLite
138 points by fanf2 154 days ago | 44 comments
Show HN: Embed an SQLite database in your PostgreSQL table (github.com/frectonz)
Embed an SQLite database in your PostgreSQL table. AKA multitenancy has been solved.
Databases, PostgreSQL, SQLite, Multitenancy, Software
180 points by frectonz 158 days ago | 110 comments