An extra-lightweight Ruby gem for working with SQLite3 databases

29-May-2021 1242
Extralite is an extra-lightweight (~365 lines of C-code) SQLite3 wrapper for Ruby. It provides a single class with a minimal set of methods to interact with an SQLite3 database.FeaturesA variety of methods for different data access patterns: row as hash, row as array, single single row, single column, single value.Iterate over records with a block, or collect records into an array.Parameter binding.Correctly execute strings with multiple semicolon-separated queries (handy for creating/modifying schemas).Get last insert rowid.Get number of rows changed by last query.Load extensions (loading of extensions is autmatically enabled. You can find some useful extensions here: https://github.com/nalgeon/sqlean.).
Use coupon code:

RUBYONRAILS

to get 30% discount on our bundle!
Prepare for your next tech interview with our comprehensive collection of programming interview guides. Covering JavaScript, Ruby on Rails, React, and Python, these highly-rated books offer thousands of essential questions and answers to boost your interview success. Buy our 'Ultimate Job Interview Preparation eBook Bundle' featuring 2200+ questions across multiple languages. Ultimate Job Interview Preparation eBook Bundle