Posts tagged with "sqlite"

  • Squongo – How to build a document store in SQLite and Ruby

    Squongo is a ruby gem encapsulating WAL mode sqlite3 databases to provide an alternative to large document stores utilizing the JSON1 extension. It’s migrationless and provides the user with the ability to have many readers without locking the database while providing a save method that will simply enque on the writer process. It was born out of a

  • How to query sqlcipher encrypted databases with Ruby

    Last year I added support for building the sqlite3 ruby gem against sqlcipher allowing ruby apps to access and query sqlcipher encrypted databases. SQLCipher is simply a fork of sqlite, kept up-to-date with upstream, that provides 256 bit AES encrypted sqlite databases. It’s used heavily in mobile apps which was part of the inspiration for adding support as I wanted to be