vatcomply
SQLite
Our great sponsors
vatcomply | SQLite | |
---|---|---|
3 | 39 | |
17 | 5,328 | |
- | - | |
5.9 | 0.0 | |
26 days ago | about 20 hours ago | |
Python | C | |
MIT License | GNU General Public License v3.0 or later |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
vatcomply
-
Ask HN: Have you used SQLite as a primary database?
VATcomply.com has been using SQLite as a primary database for 2 years and is serving ~70 requests per second without a fault.
HTTPS: https://vatcomply.com/
- Ask HN: Those making $500/month on side projects in 2021 – Show and tell
SQLite
-
A SQLite extension that brings column-oriented tables to SQLite
If you are into alternative storage engines for SQLite, there is also an LSM (Log-Structured Merge-tree) extension in the main repository that is not announced nor documented but seems to work. It’s based on the SQLite 4 project.
https://github.com/sqlite/sqlite/tree/master/ext/lsm1
https://www.charlesleifer.com/blog/lsm-key-value-storage-in-...
-
Ask HN: Where do I find good code to read?
The sqlite code base is really well done. Lots of documentation.
-
Show HN: I wrote a RDBMS (SQLite clone) from scratch in pure Python
Especially the VM part: https://github.com/spandanb/learndb-py/blob/master/learndb/v...
Compare it with this: https://github.com/sqlite/sqlite/blob/master/src/vdbe.c
That's said, I'm curious how complete this LearnDB is. SQLite is hard to read not only it's old but also it covers a lot of SQL and following SQL spec makes hings complicated. SQLite has great test suite so it's nice if you run the suit against this implementation.
- Why sqlite3 temp files were renamed 'etilqs_*' (2006)
- SQLite builds for WASI since 3.41.0
-
SQLite VS sqlite_blaster - a user suggested alternative
2 projects | 17 Mar 2023
-
Ask HN: Best book to learn C in 2022?
"C in a Nutshell 2nd Ed" (O'Reilly, Prinz & Craqford, 2015) is a good reference although maybe not the best for a walk-through learning experience. It also has good chapters on tooling (gcc, make, gdb).
There's a recent book out I came across called "Bare Metal C" (No Starch Press, Oualline, 2022) which unpacks embedded programming in a very readable manner. I imagine a lot, if not most, C programming these days is done in the low-level embedded world, and this book clears up a lot of the mysteries.
https://nostarch.com/bare-metal-c
Also it never hurts to look at a good open-source codebase written in C, for example the SQLite code is worth looking at (if a bit overwhelming):
-
SQLite Helps You Do Acid
> After that, 510 bytes are used for the SHARED lock. A byte range is used here to accommodate older Windows versions with mandatory locks.
I was curious how old, and... wow, that code is for Windows versions that predate the NT kernel (Win95/98/ME). I'm surprised that it's still around, but the comment does a great job of explaining it.
https://github.com/sqlite/sqlite/blob/3cf46ee508e97b46736a26...
-
Technical Writing Courses from Google
I wouldn't rely on Google to learn good practices for technical documentation (unless they want to release their complete internal technical documents on how their recommendation algorithms work, that is).
Instead, check out a reliable open source project like SQLITE, they have great documentation:
What are some alternatives?
sqlcipher - SQLCipher is a standalone fork of SQLite that adds 256 bit AES encryption of database files and other security features.
LevelDB - LevelDB is a fast key-value storage library written at Google that provides an ordered mapping from string keys to string values.
RocksDB - A library that provides an embeddable, persistent key-value store for fast storage.
sqlite_orm - ❤️ SQLite ORM light header only library for modern C++
bolt
phpMyAdmin - A web interface for MySQL and MariaDB
Firebird - FB/Java plugin for Firebird
libmdbx - One of the fastest embeddable key-value ACID database without WAL. libmdbx surpasses the legendary LMDB in terms of reliability, features and performance.
stepmania - Advanced rhythm game for Windows, Linux and OS X. Designed for both home and arcade use.
LMDB - Read-only mirror of official repo on openldap.org. Issues and pull requests here are ignored. Use OpenLDAP ITS for issues.
SQLite3MultipleCiphers - SQLite3 encryption extension with support for multiple ciphers
rusqlite - Ergonomic bindings to SQLite for Rust