Differences

This shows you the differences between two versions of the page.

Link to this comparison view

en:it:catza_net_postgresql_sqlite [2017-10-17 04:19]
127.0.0.1 external edit
en:it:catza_net_postgresql_sqlite [2017-10-19 03:54] (current)
Heikki Siltala
Line 10: Line 10:
 | Type | An open source software library accessing a binary database file within the client process. | A traditional open source relational database server with server processes and network connectivity. | | Type | An open source software library accessing a binary database file within the client process. | A traditional open source relational database server with server processes and network connectivity. |
 | Principle | Clever ultra-lightweight desing. | The most advanced open source relational database server. | | Principle | Clever ultra-lightweight desing. | The most advanced open source relational database server. |
-| Quality | Mature, ready for production use. Runs [[http://​catza.net/​]] in production without issues. | Mature, ready for production use. |+| Quality | Mature, ready for production use. Runs [[https://​catza.net/​]] in production without issues. | Mature, ready for production use. |
 | Reputation | Often strongly underestimated without a real reason. SQLite is not just for embedded mobile solutions. It scales both on size and on concurrent read access. | Often overshadowed by MySQL with no obvious reason. PostgreSQL is a very mature product offering plenty of features. | | Reputation | Often strongly underestimated without a real reason. SQLite is not just for embedded mobile solutions. It scales both on size and on concurrent read access. | Often overshadowed by MySQL with no obvious reason. PostgreSQL is a very mature product offering plenty of features. |
 | Administration work required | None. There still are a couple of parameters to play with if you are fan of database tuning. | Requires some initial tuning and DBA work to run optimally. | | Administration work required | None. There still are a couple of parameters to play with if you are fan of database tuning. | Requires some initial tuning and DBA work to run optimally. |