Installation & Set-up

One can choose to use SQLite which is web-based, or you can install and set up MySQL Workbench which runs on your server.

All SQL illustrations on this site will be shown via MySQL workbench for windows.

SQLite

SQLite is a server-less database and it runs as part of the app.
No user management and security features.
The size of the SQLite library is about 250 KB.
SQLite is best for smaller databases and to run basic development tests.
There isn’t any specific user management functionality in SQLite and hence, multiple users can’t access it.

MySQL Workbench

MySQL needs a server to run and it will need a client and server architecture for interacting over a network.
MySQL offers a lot of inbuilt security features such as authentication with a username, password, and SSH.
MySQL server is about 600 MB.
MySQL can be easily scaled and is able to handle a bigger database with less effort.
MySQL comprises of a well-constructed user management system wherein multiple users can be given various levels of permission.

MySQL Workbench