This lesson's interactive features are locked, please to keep using them
Comparing SQL Databases
Let's talk about some of the well-established SQL database systems and what makes them different from one another. The most popular SQL databases include:
Source: db-engines.com
While all of these Databases use SQL, each database defines specific rules, practices, and strategies that separate them from their competitors.
SQLite vs. PostgreSQL
Personally, SQLite and PostgreSQL are my favorites from the list above. Postgres is a very powerful, open-source, production-ready database. SQLite is a lightweight, embeddable, open-source database. When I need to use SQL, I usually choose between the two depending on the use case.
SQLite is a serverless database management system (DBMS) that has the ability to run within applications, whereas PostgreSQL uses a client-server model and requires a server to be installed and listening on a network, similar to an HTTP server.
See a full comparison here.
Assignment
Let's take a look at how SQLite does not enforce type-checking. Notice that within the CREATE TABLE statement, name is defined as a TEXT field.
To pass the assignment, submit the code in the altered state, where the record with an id of 2 has a name of 1.
Notice how even though we defined name as a TEXT field, SQLite allowed us to use an integer! Like Python and JavaScript, SQLite has a loose type system... You can store any type of data in any field, regardless of how you defined it. But just because you can do something, doesn't mean you should!