30+ years of tech, retired from an identity intelligence company, now part-time with an insurance broker.
Dev community mod - mostly light gardening & weeding out spam :)
True, and you did ask for a 'as a service'. I have seen (and SQLite supports with caveats) SQLite used over a file share, although that brings back horrific memories of Access databases on SMB shares, or worse, Visual Source Safe - shudder.
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.
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.
It is portable but you can't access it over network.
True, and you did ask for a 'as a service'. I have seen (and SQLite supports with caveats) SQLite used over a file share, although that brings back horrific memories of Access databases on SMB shares, or worse, Visual Source Safe - shudder.
What type of network? We use an application that accesses one on a server on a daily basis.
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.