Human Folly about “SQLite”

index

100000 tps over a billion rows the unreasonable effectiveness of SQLite (andersmurphy.com):
102545 transactions per second #performance with #SQLite on a Macbook Pro M1 using #Clojure. #toread
on 02025-12-02
CPU (sqlite.org):
how #SQLite does #performance optimization with cachegrind, enabling the use of many small optimizations
on 02024-09-05
Visidata (github.com):
"Visidata" is a spreadsheety GPL3 data visualization #TUI program that looks pretty impressive. #infovis in #Python, supporting #TSV, #JSON, #CSV, #SQLite, #Pandas, and #HDF5
on 02024-09-03
Expridx (sqlite.org):
#SQLite supports functional indices since version 3.9.0 from 02015-10-14, but only for deterministic functions.
on 02023-12-04
Datatype3 (sqlite.org):
#SQLite is dynamically typed, but #dates don’t get a storage class of their own; instead you store them as text, real Julian days, or integer Unix epoch timestamps. Separately, columns have a “type affinity” which is drawn from almost the same set as the storage classes. This page explains the type system in detail.
on 02023-12-04
Lang datefunc (sqlite.org):
#SQLite has date calculation functions that seem like the best #calendar #dates calculation language I’ve seen, except for not supporting time zones: “Compute the number of days since the signing of the US Declaration of Independence: SELECT julianday('now') - julianday('1776-07-04'); Compute the date of the first Tuesday in October for the current year: SELECT date('now','start of year','+9 months','weekday 2');.” That’s pretty great! But for getting a local time out of “2023-04-04 09:30:00-04:00” you’re better off using substr(date, 12, 8).
on 02023-12-04
SQLite internals Wal (fly.io):
more about #SQLite’s WAL, with a goofy sandwich shop example
on 02023-02-07
Wal (sqlite.org):
#SQLite can use a write-ahead log (WAL) to use MVCC for #transactional concurrency, which probably ought to be the default. You say PRAGMA journal_mode=WAL; at the command line is all.
on 02023-02-07
Wal (sqlite.org):
#SQLite’s WAL #transactional mode for #MVCC
on 02022-10-12
Exceptions in destructors (deathandthepenguinblog.wordpress.com):
using #SQLite nicely in #C++ with sqlite_modern_cpp, executing queries and throwing exceptions in the destructors of temporaries (!!)
on 02017-05-19
Core (github.com):
a working #SQLite example in #Clojure via JDBC
on 02017-05-09
How do I access an SQLite database in Clojure (stackoverflow.com):
using #SQLite from #Clojure via JDBC
on 02017-05-09
API (github.com):
The most popular API for using #SQLite from node.js, sqlite3 on npm.
on 02017-04-29
(sqlitebrowser.org):
A #database browser for #SQLite aimed at both developers and end users.
on 02016-10-03
(sqlitestudio.pl):
#SQLite Studio is a #database GUI for SQLite with a SQL IDE with autocomplete and on-the-fly syntax checking, grid view, and data generation.
on 02016-10-03
TkSQLite (reddog.s35.xrea.com):
TkSQLite is a #database GUI for #SQLite written in Tcl/Tk; grid views and SQL access but no forms
on 02016-10-03
(blog.regehr.org):
undefined behavior in #SQLite and more on Regehr’s proposal of a “friendly #C”.
on 02016-03-18
(github.com):
#silentbicycle’s Tangram project is a #blob store that stores data with his #content-addressable #storage Jumprope library, which uses #hashsplitting to chunk the data, much like #bup. Written in #Lua on top of #SQLite 3.
on 02015-08-13
Finding bugs in SQLite easy way (lcamtuf.blogspot.com.ar):
Michał Zalewski (#lcamtuf) very quickly found crash bugs in #SQLite with #afl.
on 02015-08-13
SQLite autoconf (sqlite.org):
This is the #SQLite version needed by #Guix 0.8.1.
on 02015-08-10