What base to choose during development and production?

Question

Ruby on Rails

I'm new to ruby, I came from PHP))
I want to start a project on the locale now. By default, it turns out that SLQLite is used, and Heroku postgres.
Is it possible to write a full-fledged project with SLQLite, with searches and other complex queries, and then smoothly switch to postgres? Heroku transition will provide?

Answer 1

You need to use the same base. Example: want to use a JSONB field that is available in PostgreSQL but not in SQLite. Why limit yourself?

Answer 2

По своему опыту, лучше использовать при разработке ту базу которую будешь деплоить в продакшэн съэкономит время при деплое