I would like to know how Sqlite works

Asked

Viewed 101 times

-2

My question is this::

Whether database data is stored in a db file. on my computer. Or externally.

python sqlite

  • Sqlite was not intended to compete with client-server model Dbms. If you want to leave your database on a server to which clients connect there are better options such as: Oracle, Postgrsql, SQL Server, Mysql, etc

  • But so, knowing SQL you can use any of these? Or the syntax will change?

  • The SQL dialect may have slight changes according to the DBMS. Postgresql is one of the most adherent to the SQL standard.

1 answer

0

On your computer, in order to be externally it must be on a suitable server. Here are some examples: Oracle. SQL Server. Mysql. Postgresql. IBM DB2. Nosql.

SQL is the standard ANSI language for handling relational databases. Because it is an industry-accepted standard, it is supported by all relational DBMS - which includes products such as Oracle, Microsoft SQL Server, Mysql, Postgresql, Sqlite and IBM DB2.

Browser other questions tagged python sqlite

You are not signed in. Login or sign up in order to post.