Which Databases Use SQL?

SQL is just a query language. You typically use it to interact with a specific database technology. For example:

Although many different databases use the SQL language, most of them will have their own dialect. It's critical to understand that not all databases are created equal. Just because one SQL-compatible database does things a certain way, doesn't mean every SQL-compatible database will follow those exact same patterns.

We're Using SQLite

In this course, we'll be using SQLite specifically. SQLite is great for embedded projects, web browsers, and toy projects. It's lightweight, but has limited functionality compared to the likes of PostgreSQL or MySQL – two of the more common production SQL technologies.

We'll point out to you whenever some functionality we're working with is unique to SQLite!

Assignment

One way in which SQLite is a bit different is that it stores Boolean values as integers – the integers 0 and 1.

0 = false
1 = true

Our users table has a Boolean is_admin column to store whether a user is an admin or not. Write a query to see how this boolean field is actually represented in the results.

Select all of the ids, names, and is_admin flags from the users table.