Heads up! To view this whole video, sign in with your Courses Plus account or enroll in your free 7-day trial. Sign In Enroll

Preview

Start a free Courses trial
to watch this video

Sign up for Treehouse

Rails and PostgreSQL

1:37 with Jay McGavren

When it comes time to release a serious app that will have thousands of users to production, SQLite is no longer sufficient. Only one thing can be written to a SQLite database at a time, meaning slower performance if you have many users trying to save data at once. SQLite also lacks certain features used for performance optimization. Rails can easily be configured to work with a wide variety of other databases. One of the most popular for production use is PostgreSQL. Postgres has more features than SQLite and is more compliant with the standards for SQL. In this workshop, we're going to cover using Postgres with your Rails app.

[MUSIC] 0:00
Rails apps use SQLite as their database by default. 0:04
This is great when you're just starting out because you don't need to install and 0:08
run a separate server process on your development machine. 0:11
Your Rails process is able to use the SQLite libraries to read and 0:14
write the database file that lives right there in your app directory. 0:17
But when it comes time to release a serious app that will have thousands of 0:21
users to production, SQLite is no longer sufficient. 0:25
Only one thing can be written to a SQLite database at the time. 0:28
Meaning slower performance if you have many users trying to save data at once. 0:31
SQLite also lacks certain features used for performance optimization. 0:36
Rails can easily be configured to work with a wide variety of other databases. 0:40
But the two that are most popular for production use are MySQL and PostgreSQL or 0:44
Postgres for short. 0:49
Which of the two is better depends on your needs, but 0:51
the general consensus seems to be. 0:53
That MySQL is easier to use while Postgres has more features and 0:55
is more compliant with the standards for SQL. 0:58
In this workshop, we're going to cover using Postgres with the Rails app. 1:02
By the way in case you're wondering where the crazy name PostgreSQL came from. 1:06
Back to the 1980s, there was a database system called Ingress which used its own 1:10
query language rather than SQL. 1:14
One of the developers split off from that project and 1:15
started work on another database. 1:18
Since it came after his work on Ingress, he called it Postgres. 1:20
It still used its own query language at that point. 1:27
When support for 1:30
SQL was added later, the name was changed to reflect that, PostgreSQL. 1:31

You need to sign up for Treehouse in order to download course files.

Sign up