Relational Database Management Systems

Benefits:

Security: Unlike SQLite, MySQL allow multi user management and allows you to specify users access. It comes with its own security script which grants you more control of access to your database and allows you to set password protection. Like SQLite and PostgreSQL, until every change operation of a transaction is successfully completed, that transaction isn’t cleared and the changes aren’t saved. This combined with the other layers of security MySQL provides, makes it a great choice for eCommerce businesses. This is because the money will not be deposited unless the entire process successfully completes. Upon failure all changes are reverted until the entire transaction is successful.

Benefits:

SQL Standard: PostgreSQL follows more closely to the SQL standards and the other two relational database management systems mentioned in this blog. In fact, according to the official site, it meets 170 of the 179 standards of SQL

Benefits:

Lightweight and Portable: In fact, the -lite in SQLite refers to it’s lightweight structure. It takes up little space and is notably -lite in it setup, administration, and it’s required resources. This can mostly be attributed the SQLite not requiring installation of additional dependencies. An SQLite database is stored as one single disk file. This single file is also “cross-platform”. This means you can create a SQL database on one machine and it can be copied and used on a different machine, even if that machine has a different environment or architecture.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store