SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 C Sqlite Projects
-
Project mention: The definitive guide to using Django with SQLite in production 💡 | dev.to | 2025-01-18
Turso libSQL: A fork of SQLite that supports distributed databases (django-libsql)
-
CodeRabbit
CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
-
-
-
-
Project mention: Build your own SQLite, Part 4: reading tables metadata | news.ycombinator.com | 2025-02-04
Is translation necessary to port the complete SQLite test suite?
sqlite/sqlite//test: https://github.com/sqlite/sqlite/tree/master/test
tursodatabase/limbo//testing:
-
Project mention: SQLiteStudio: Create, edit, browse SQLite databases | news.ycombinator.com | 2024-11-24
In few days there will be another 3.4.x branch release (3.4.7), which addresses this exact problem - https://github.com/pawelsalawa/sqlitestudio/issues/5119
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
-
-
Project mention: I built an online PDF management platform using open-source software | news.ycombinator.com | 2024-05-12
This is what I use for that
https://github.com/simon987/sist2
-
Checkout https://github.com/OP-Engineering/op-sqlite if you haven't already, it supports a variety of extensions for use with sqlite in react-native.
-
> You can get substantially better performance out of sqlite by using the lower level https://github.com/crawshaw/sqlite, turning on WAL etc, using a connection per goroutine for reads, and sending batches of writes over a buffered channel / queue to a dedicated writer thread. That way you can turn off SQLite’s built in per-connection mutex but still be thread safe since each connection is only used on a single thread at a time.
Would this protect against a row update in the middle of a read? e.g. would a row at least be internally consistent at the time it was read?
-
verneuil
Verneuil is a VFS extension for SQLite that asynchronously replicates databases to S3-compatible blob stores.
That's how https://github.com/backtrace-labs/verneuil 's read replication is meant to be used. There's a command-line tool to recreate a sqlite DB file from a snapshot's manifest, with an optional local cache to avoid fetching unchanged pages, or you can directly use a replica in memory, with pragmas for (async) refreshes.
-
-
-
-
-
-
-
-
Or even better store data as an sqlite file that is full-text-search indexed. Then you can full-text search the torrent on demand: https://github.com/bittorrent/sqltorrent
-
Project mention: SQLite on Rails: The how and why of optimal performance | news.ycombinator.com | 2024-09-11
You can read more discussion here: https://github.com/sparklemotion/sqlite3-ruby/pull/528 and here: https://github.com/digital-fabric/extralite/pull/46 to see how it was validated that simply releases the GVL for every `step` in the SQLite VM majorly hurts single-threaded performance. Finding a middle ground for both single threaded and multi-threaded performance is tricky. In Rails, we know it is multi-threaded because of the connection pool. But the lower level gem is used in many other libraries and tools where it is used in a single threaded environment
-
You can use DuckDB WASM independently of Pyodide and can extend it with SQLite.
Though it seems to be somewhat limited. I couldn't even check what version it has, since sqlite_version() was missing. Version in the repository [1] is 3.38.1, which is from quite a ways ago.
At the moment DuckDB web shell can't load SQLite extension, since that hasn't been released for yesterday's 1.1.2. Earlier version does work using recently updated WASM edition. That can be extended with spatial including GDAL, vector search etc [2]. Making your own "SQL web shell" wasn't too hard, though docs weren't quite complete enough for me.
[1] https://github.com/duckdb/sqlite_scanner/blob/main/src/sqlit...
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
C Sqlite discussion
C Sqlite related posts
-
Craft: A simple Minecraft clone written in C
-
Build your own SQLite, Part 4: reading tables metadata
-
Composable SQL (Functors)
-
In Search of a Faster SQLite
-
LibSQL: Fork of SQLite That Is Both Open Source, and Open Contributions
-
SQLite changed temp file prefix after McAfee users called devs to complain
-
No need to email me about Cisco AnyConnect
-
A note from our sponsor - SaaSHub
www.saashub.com | 9 Feb 2025
Index
What are some of the best open-source Sqlite projects in C? This list will help you:
# | Project | Stars |
---|---|---|
1 | libsql | 13,644 |
2 | WCDB | 10,920 |
3 | Craft | 10,534 |
4 | go-sqlite3 | 8,214 |
5 | SQLite | 7,302 |
6 | sqlitestudio | 5,665 |
7 | dqlite | 3,948 |
8 | sqlite-plus | 3,899 |
9 | sqlite-gui | 1,124 |
10 | sist2 | 938 |
11 | op-sqlite | 675 |
12 | sqlite | 588 |
13 | verneuil | 469 |
14 | stumpless | 460 |
15 | zig-sqlite | 437 |
16 | SQLite3MultipleCiphers | 437 |
17 | sqlite-lines | 394 |
18 | esp32_arduino_sqlite3_lib | 387 |
19 | sqleet | 379 |
20 | go-sqlite-lite | 328 |
21 | sqltorrent | 281 |
22 | extralite | 256 |
23 | duckdb-sqlite | 224 |