What is the best app to work with Sql? I already install xampp but now I think maybe Sqlite is better, idk I need help

Answer 1

SQLite is popular in mobile apps for storage in the file system of the mobile device.

MySQL is better for a web application's database. MySQL has more features, scales better, and manages constraints better. These are differences that make MySQL better for web application databases. These features are anywhere from unimportant to being unneeded bloat for mobile applications which is why SQLite is still great for mobile apps.

With a web application's database, you will often want to perform database backups, queries, and migrations remotely instead of hoping that everything is perfectly smooth in the app. You can't do this with SQLite because it doesn't come with a server or network communication features. The limited feature set and no networking is why they call it "Lite".

One other reason SQLite is so popular in mobile apps is that it is available in the standard Android SDK. No additional dependencies need to be installed to use it.

Answer 2

Thanks