5 ms·
Why use postgre instead of sqlite?
by jokoon 5y ago
Why use postgre instead of sqlite?
- theandrewbailey 5y agoOff the top of my head: Postgres is a client-server system, with full user access controls and multiple client connections. Postgres has PostGIS (geographic data) and foreign data wrappers. Postgres is more scalable than Sqlite and can work with larger datasets over multiple instances.
- jokoon 5y agoThere's spatialite.
- ben-gy 5y agoHeroku is by far the easiest and cheapest (free for light usage) way to get a Rails app into production. Heroku‘a preference is Postgres over SQLite: https://devcenter.heroku.com/articles/sqlite3 https://devcenter.heroku.com/articles/sqlite3