Browsing Category
SQLite
65 posts
SQLite is a database engine written in the C programming language. It is not a standalone app; rather, it is a library that software developers embed in their apps. As such, it belongs to the family of embedded databases.
ALTER TABLE Command in SQLite: A Complete Guide with Examples
Schemas rarely stay the same forever. At some point you’ll need to add a column you forgot, rename…
INDEXED BY Clause in SQLite: A Complete Guide with Examples
Most of the time, you don’t need to think about which index SQLite uses to run your query…
Indexes in SQLite: A Complete Guide with Examples
There’s a specific moment a lot of developers hit: a query that used to run instantly starts taking…
Triggers in SQLite: A Complete Guide With Practical Examples
If you have spent any real time working with SQLite, you have probably reached a point where you…
ALIAS Syntax in SQLite: A Complete Guide With Practical Examples
Every time I write a query that joins three or four tables together, or one that includes a…
How NULL Values Are Represented in SQLite: A Complete Guide
If there’s one concept in SQL that trips up beginners more than almost anything else, it’s NULL. I…
The UNION Clause in SQLite: A Complete Guide With Practical Examples
There’s a specific moment in almost every SQL developer’s journey when they realize they need to combine results…
Types of JOINS in SQLite: A Complete Guide With Practical Examples
Joins are, without exaggeration, the single most important concept to master once you move past basic single-table queries…
Types of Constraints in SQLite: A Complete Guide With Practical Examples
Every database I’ve ever built has, at some point, needed rules — rules about what data is allowed…
The index_list PRAGMA in SQLite: A Complete Guide With Practical Examples
Every so often I inherit a SQLite database I didn’t build myself, and one of the very first…