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.
SQLite’s Core Syntax: A Complete Guide
Every database engine implements SQL slightly differently, and if you’re coming to SQLite from another system, or coming…
Inserting Data Into a Table in SQLite: A Complete Guide
Once you’ve designed a table, the next natural step is getting real data into it. This article focuses…
Creating Tables With CREATE TABLE in SQLite
CREATE TABLE was one of the very first SQL statements I properly learned, and I still think it’s…
Experimenting with SQLite Syntax
One of the things I love most about SQLite is how safe it is to experiment with. There’s…
SQLite standard return codes
The first time one of my SQLite queries failed silently inside a Python script, I learned a hard…
Using sqlite3
sqlite3 is the tool I reach for constantly, whether I’m debugging an app’s local database, exploring a dataset,…
Relational Databases and SQL to the Rescue
Before I really understood relational databases, I stored structured data the way a lot of beginners do —…
The Complete Guide to SQL SELECT Statements: From Basics to Advanced
If there’s one SQL statement I’ve written more than any other, it’s SELECT. It’s the workhorse of every…
SQL Data Languages
For a while, I thought of SQL as just “the language you use to query databases.” It wasn’t…
Building and Installing SQLite
I remember expecting the process of installing SQLite to be complicated, the way installing a full client-server database…