recentpopularlog in

mechazoidal : sqlite   8

GitHub - crawshaw/sqlite: Go SQLite3 driver
Not actually a DB driver, but an attempt to bring some of the SQlite non-db features into the interface via C linking.

See also: https://crawshaw.io/blog/go-and-sqlite
sqlite  golang  repo:github  database  piperesearch 
october 2019 by mechazoidal
GitHub - mozilla/mentat: A persistent, relational store inspired by Datomic and DataScript.
"DataScript asks the question: "What if creating a database would be as cheap as creating a Hashmap?" Mentat is not interested in that. Instead, it's strongly interested in persistence and performance, with very little interest in immutable databases/databases as values or throwaway use."
It's a Rust library that was originally built in Clojurescript, and is still meant to be used for the web via WASM.

(as of late 2018, unmaintained: https://mail.mozilla.org/pipermail/firefox-dev/2018-September/006780.html )
database  repo:github  rust  sqlite  piperesearch  webdev 
april 2018 by mechazoidal
35% Faster Than The Filesystem
Note that it's more like: "Some other SQL database engines advise developers to store blobs in separate files and then store the filename in the database. In that case, where the database must first be consulted to find the filename before opening and reading the file, simply storing the entire blob in the database gives much faster read and write performance with SQLite. See the Internal Versus External BLOBs article for more information."

(aka, it's OK to store binary blobs directly in DB, NOT to have a directory full of separate database files)
sqlite  optimization  database  piperesearch 
june 2017 by mechazoidal
dumblob/mysql2sqlite
Converts MySQL dump to SQLite3 compatible dump (including MySQL KEY xxxxx statements from the CREATE block).
mysql  sqlite  script  unix  repo:github  tools 
may 2016 by mechazoidal
SQL Cipher - Zetetic
an encryption-addon for SQLite files, turning it into a full 256-bit AES-encrypted store
cryptography  library  sqlite  sql  software  security  programming 
may 2016 by mechazoidal
Tweet from Gary Bernhardt (garybernhardt)
"Eight years ago, I was convinced by SQLite's reputation for reliability. Then I saw it corrupt itself in production and was enlightened."
tweet  sqlite 
september 2015 by mechazoidal

Copy this bookmark:





to read