last modified July 6, 2020
This is a Ruby programming tutorial for the SQLite database. It covers the basics of SQLite programming with Ruby. It uses the sqlite3 module. The examples were created and tested on Linux.
Table of Contents
SQLite & Ruby
SQLite is an embedded relational database engine. It is a self-contained, serverless, zero-configuration and transactional SQL database engine. SQLite implements most of the SQL-92 standard for SQL. The SQLite engine is not a standalone process. Instead, it is statically or dynamically linked into the application. An SQLite database is a single ordinary disk file that can be located anywhere in the directory hierarchy.
Ruby is a dynamic, reflective, general-purpose object-oriented programming language. Recently it became very popular in web programming, mainly due to the successful Ruby on Rails framework.