DEV Community

Discussion on: Free SQL hosting providers ?

 
sharadcodes profile image
Sharad Raj (He/Him) • Edited

Sqlite is for local storage like in embedded systems. You cannot access it remotely. You need either an API running on that server or some other interface to do database manipulation.

Where as client server based dbms like MySQL can be accessed via a domain, port, username, password. So you don't have db stored on the system where that app or software is running.

Example of such applications are based on the way you implement.

Like you can make a todo app with sqlite but in that case both the db and app will be on same server.
In another case you can use MySQL, MongoDB etc to store db elsewhere and app will be hosted somewhere else.