Rails and Databases
Understand how to connect Rails applications to different databases like SQLite, MySQL, and Postgres. Learn about installing necessary database drivers and setting up your development environment to work efficiently with Rails and your chosen database.
We'll cover the following...
The examples in this course were written using SQLite 3 (version 3.22.0 or thereabouts). If you want to follow along with our code, it’s probably simplest if you use SQLite 3 as well. If you decide to use something else, it won’t be a major problem. You may have to make minor adjustments to any explicit SQL in our code, but Rails pretty much eliminates database-specific SQL from applications.
Connection with database
If you want to connect to a database other than SQLite 3, Rails also works with DB2, MySQL, Oracle Database, Postgres, Firebird, and SQL Server. For all but SQLite 3, you’ll need to install a database driver—a library that Rails can use to connect to and use with ...