I think SQLite and PostgreSQL are significantly different, other than embedded vs server.
SQLite - much less feature-rich; much smaller, suitable for embedded; add functions in the driver of language of your choice
PostgreSQL - more features; write functions into SQL, or that can compile for Postgres; comply to 12-factor app
Some time ago, I was also recommended firebird; but I dropped it, because of no full text search (FTS) support.
If I remembered correctly, at least Firebird, Neo4j and CouchDB have this dual nature.
Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink.
Hide child comments as well
Confirm
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
I think SQLite and PostgreSQL are significantly different, other than embedded vs server.
SQLite - much less feature-rich; much smaller, suitable for embedded; add functions in the driver of language of your choice
PostgreSQL - more features; write functions into SQL, or that can compile for Postgres; comply to 12-factor app
Some time ago, I was also recommended firebird; but I dropped it, because of no full text search (FTS) support.
If I remembered correctly, at least Firebird, Neo4j and CouchDB have this dual nature.