Getting SQLite metadata with Ruby
In this part of the SQLite Ruby tutorial, we work with database metadata.
Working with images
In this part of the SQLite Ruby tutorial, we work with images. We insert an image to the database and retrieve it back.
SQLite Ruby
This is SQLite Ruby tutorial. In this tutorial, you will learn the basics of database programming in SQLite using the Ruby language.
SQLite views, triggers, transactions
In this part of the SQLite tutorial, we will cover views, triggers, trasactions.
The sqlite3 command line tool
In this chapter of the SQLite tutorial, we cover the sqlite3 command line tool. We mention various meta commands, shown how to dump tables, and read SQL from files.
Creating, dropping, and altering tables in SQLite
In this part of the SQLite tutorial, we will be creating, dropping, and altering tables. We use SQL statements that define the database schema.
SQLite functions
In this part of the SQLite tutorial, we will cover functions. We work with core, aggregate, and date & time function.