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.
Operators in SQLite: A Complete Guide
Every meaningful SQL query I’ve ever written relies on operators — the symbols and keywords that let you…
The SELECT Query in SQLite: A Complete Guide
If you’ve spent any time working with databases, you already know that SELECT is the command you’ll type…
The INSERT Statement in SQLite: A Complete Guide
Every database starts out empty. Before you can query data, sort it, filter it, or build reports out…
The DROP TABLE Command in SQLite: A Complete Guide
There’s a special kind of dread that comes with typing DROP TABLE and hitting enter. Unlike most SQL…
The CREATE TABLE Command in SQLite: A Complete Guide
Every database journey starts with CREATE TABLE. It’s the command that turns an empty database file into something…
SQLite’s ATTACH DATABASE: A Complete Guide
Most tutorials treat SQLite databases as isolated, single-file islands — you open one file, you query it, you…
The .dump Command in SQLite: A Complete Guide
If you’ve worked with SQLite for any length of time from the command-line shell, you’ve probably noticed that…
How to Create a New SQLite Database: A Complete Guide
One of the reasons SQLite has become so widely used — from mobile apps to browsers to desktop…
How SQLite’s Storage Classes Define Internal Data Storage
If you’ve worked with other database systems before coming to SQLite, one of the first things that might…
SQLite Data Types and How They Work
Data types are one of the first things you learn about in any database course, and for most…