Awesome

All things around SQLite

Crazy useful SQLite projects

• https://github.com/btrask/sqlheavy - SQLite ported to LevelDB, LMDB, RocksDB, and anything else you can imagine
• https://github.com/slanska/flexilite - SQLite extension library, written in C. Based on EAV/CR storage, implements most of data schema refactoring patterns and more
• https://github.com/DrPaulBrewer/multicoresql - A parallel map/reduce execution framework for sqlite databases
• https://github.com/mlkwok/Graph-Database-API - A C/SQLite application that allows users to store graph data and information.
• https://github.com/unibg-seclab/sesqlite - Mandatory Access Control for SQLite databases
• https://github.com/illarionov/sqlite3-unicodesn - SQLite unicode full-text-search tokenizer with Snowball stemming
• https://github.com/rvianello/chemicalite - A cheminformatic SQLite database extension (WHAT??)
• https://github.com/groue/GRDB.swift
• https://github.com/athlite/sqlite3-to-mysql - Make an Sqlite3 export MySQL readable.

Strings handing

• https://github.com/wangwang4git/SQLite3-ICU - SQLite3 ICU Tokenizer
• https://github.com/mateusza/SQLite-Levenshtein
• https://github.com/haifengkao/SqliteSubstringSearch
• https://git.daplie.com/coolaj86/sqlite3-fts4-rank
• https://github.com/mayflower/sqlite-reverse-string
• https://github.com/abiliojr/fts5-snowball Snowball tokenizer for SQLite FTS5
• https://github.com/cwarden/sqlite-distance
• https://github.com/droe/sqlite-hexhammdist - Hamming distance between hex strings in SQLite
• https://github.com/zhaozg/sqlitext (sqlitext: sqlite with extend feature)

JSON

• https://github.com/gbrault/sqlite3jsonshell - provide json output to reworked sqlite shell

Replications / Client-Server

• https://github.com/Expensify/Bedrock/ - Rock solid distributed database specializing in active/active automatic failover and WAN replication http://bedrockdb.com
• https://github.com/purpleblues/sqlite - Atomic Multi-database Transaction of WAL Journaling Mode in SQLite

Encryption

• https://github.com/sqlcipher/sqlcipher
• https://github.com/shenghe/FreeSQLiteEncryption
• https://github.com/abc34/sqlite_codec - qlite3 with built-in transparent encryption based on mbedtls library
• https://github.com/newsoft/sqlite3-dbx - SQLite3 with encryption support (old original)

Datastructures

• https://github.com/MelleB/sqlite-bloomfilter
• https://github.com/Noctune/sqlite-digest - SHA-1 implementation for SQLite
• https://github.com/benwebber/sqlite3-uuid

Languages

• https://github.com/jbreeden/mruby-sqlite MRuby bindings to SQLite3
• https://github.com/hoelzro/sqlite-lua-extension

Browsers

• https://hyokai.info/#features-plot - great and convenient browser for databases.
• https://github.com/chop-dbhi/sql-agent - HTTP interface for executing ad-hoc SQL queries.

Material:

• https://github.com/Apress/def-guide-to-sqlite-10 - Source code for 'The Definitive Guide to SQLite'
• https://github.com/mikeowens/sqlite-vtable - SQLite Virtual Table Example

Misc

• https://github.com/guardianproject/libsqlfs - a library that implements a POSIX style filesystem on top of an SQLite database https://dev.guardianproject.info/proj…
• https://github.com/mro/librdf.sqlite - improved SQLite RDF triple store for Redland librdf http://purl.mro.name/librdf.sqlite/
• https://github.com/kristapsdz/sqliteconvert - extract documentation from sqlite schemas https://kristaps.bsd.lv/sqliteconvert

Tricks:

Ranking - http://stackoverflow.com/questions/28377210/how-to-retrieve-rank-based-on-total-mark-in-sqlite-table