sqlite3-driver Open-Source Projects

go-sqlite3

40 7,471 6.2 C

sqlite3 driver for go using database/sql

Project mention: Show HN: Roast my SQLite encryption at-rest | news.ycombinator.com | 2024-04-30

SQLite encryption at-rest is a hot requested feature of both the “default” CGo driver [1] and the transpiled alternative driver [2]. So, this is a feature I wanted to bring to my own Wasm based Go driver/bindings [3].
Open-source SQLite encryption extensions have had a troubled last few years. For whatever reason, in 2020 the (undocumented) feature that made it easy to offer page-level encryption was removed [4]. Some solutions are stuck with SQLite 3.31.1, but Ulrich Telle stepped up with a VFS approach [5].
Still, their solution seemed harder than something I'd want to maintain, as it requires understanding the structure of what's being written to disk at the VFS layer. So, I looked at full disk encryption for something with less of an impedance mismatch.
Specifically, I'm using the Adiantum tweakable and length-preserving encryption (with 4K blocks, matching the default SQLite page size), and encrypting whole files (rather than page content).
I'm not a cryptographer, so I'd really appreciate some roasting before release.
There is nothing very Go specific about this (apart from the implementation) so if there are no obvious flaws, it may make sense to port it to C/Rust/etc and make it a loadable extension.
[1] https://github.com/mattn/go-sqlite3/pull/1109

InfluxDB

www.influxdata.com featured

Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020).

sqlite3-driver related posts

Replacing Complicated Hashmaps with SQLite

1 project | news.ycombinator.com | 6 Apr 2024
In-memory key value store

2 projects | /r/golang | 2 Apr 2023
GitHub - elgs/gosqlapi: Turns any SQL database into a RESTful API.

2 projects | /r/golang | 21 Feb 2023
Using go run file.go or testing library locks the SQLite database

1 project | /r/golang | 4 Dec 2022
modernc.org/sqlite v1.18.1 upgrades to SQLite 3.39.2

4 projects | /r/golang | 10 Aug 2022
How to handle file writes over HTTP

1 project | /r/golang | 4 Jun 2022
SQLite 3.38 Released

2 projects | news.ycombinator.com | 22 Feb 2022
A note from our sponsor - SaaSHub
www.saashub.com | 4 May 2024

SaaSHub helps you find the best software and product alternatives Learn more →