Geek Answers Handbook

Differences between sqlite, SQL, and MYSQL and Learning Tips

I had fully mastered my web programming skills, and now I was thinking about learning database languages.

But I am confused by the difference between sqlite , SQL and MySQL .

So someone can recommend me steps to study the database in the above languages ​​(without knowledge)

+10
database mysql sql-server sqlite
source share
6 answers

Start exploring one engine, and I recommend (Microsoft) SQL Server, and the conversion will be easy.

But it’s important to note that SQL Server and MySQL support stored procedures, but SQLite does not.

SQLite is file-based; SQL Server and MySQL are server based

+18
source share

SQL is a query language. MySQL is a client-server relational database management system (RDBMS). Sqlite is an integrated relational database management system.

+13
source share

SQL - structured query language - (for querying the database)

MySQL - Client-server database - (uses SQL to manage data, has a user interface (UI))

SQLite - a small version of MySQL - (for battery powered devices)

More details:

SQLite:

  • easier to set up

  • great for temporary (database testing)

  • great for quick development

  • great for embedding in an application

  • does not have user management

  • doesn't have many performance features

  • scales poorly.

MySQL:

  • much harder / harder to set up

  • best options for tuning performance

  • can scale well if configured correctly

  • can manage users, permissions, etc.

+5
source share

My best recommendation is to use MySQL first so that you become more familiar with its basic functions, which I suppose you should learn first.

+2
source share

This SO link is like a very detailed comparison of MySQL with SQLite. As @Andrey noted, SQL is a query language. It's best to keep track of any tutorial found on a Google search, at least for starters.

+1
source share

sqlite is a relational database management system that is most widely used in a mobile device as a database for local storage. It is used in an embedded system.

SQL is also known as a relational algebra-based structured query language. sqlite, MySQL, MSSQL, etc. are part of SQL. They use all sql syntax, but each database (sqlite, MySQL, MSSQL) has its own query convention

MySQl is a large-scale business process database, also known as a relational database management system. These databases are highly scalable and can handle huge terabytes of data.

Another database is PostgreSQL, and there are many others ...

0
source share

More articles:


All Articles