mysql - What database to use in production with Rails? -

mysql - What database to use in production with Rails? -

i'm pretty close deploying rails app digital ocean vps using this guide

but there's confusion database part. on development i've used sqlite3 database. guide shows mysql , postgresql. because sqlite3 isn't meant production services? , need convert sqlite3 database mysql database in order transfer tables etc?

if website meant simple data-storage , retrieval can sqlite3, regard mysql or pgsql, lacks back upwards of multiple user, concurrency. in add-on if want insert 10k datas @ time,then perchance need gooogle , comeback reply , on how insert many records in to the lowest degree time. sqlite used mobile games (data storage), browsers (like firefox) store info single users, (mostly)

now if deciding between postrgres , mysql, suggest pgsql because not mysql bad, depending on engine use, may or mayn't have functionalities , kindof dislike way mysql handles not null , default values.

if have application using multitenancy, illustration bank application have single user table , want distinguish user data's 1 on database level, pgsql works best, because of schema support. illustration in college admission application, each college can have separate schema structure.

for switching between databases need modify yor database.yml file , migrate it, answered.

mysql ruby-on-rails database sqlite3