14 DATABASES

Database applications, such as MySQL, Oracle, and SQL Server, go hand-in-hand with programming languages. Applications often use directories and files to store information, but more sophisticated data warehousing requires a database. Ruby can use most of the popular database applications through associated gems and other libraries.

This chapter will cover everything you need to know to interact with the SQLite database application (www.sqlite.org). SQLite is a small, fast, sufficiently powerful, and open-source application that runs on most operating systems. While not as feature rich as MySQL, Oracle, and others, SQLite is easy to install and work with, and is perfectly suited for many purposes.

Before getting into the code, I ...

Get Ruby: Visual Quickstart Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.