Does SQLite need MySQL?

Question

You need to use mysql or some other server-based RDBMS. Note that MySQL is not the only choice and there are plenty of others which might be better for new applications (for example pgSQL). Sqlite is a very, very nice piece of software, but it has never made claims to do any of these things that RDBMS servers do. 8 нояб. 2011 г.

Does SQLite use MySQL?

MySQL uses a database server to run on a network, which can then be accessed by the client. SQLite, however, is what is known as an embedded database. This means that the structure is stored on the application itself.

Can I use SQLite instead of MySQL?

MySQL has a well-constructed user management system which can handle multiple users and grant various levels of permission. SQLite is suitable for smaller databases. As the database grows the memory requirement also gets larger while using SQLite. Performance optimization is harder when using SQLite.

Should I use SQLite or MySQL?

However, if you require scalability in terms of the number of database queries required, MySQL is the better choice. If you want any real degree of concurrency or require higher levels of security as well as user permissions management, MySQL wins over SQLite.

Expert · Answer