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.
The index_info PRAGMA in SQLite: A Complete Guide With Practical Examples
Once you know which indexes exist on a table — which is what the index_list PRAGMA tells you…
The freelist_count PRAGMA in SQLite: A Complete Guide With Practical Examples
There’s a question that comes up sooner or later for anyone managing a SQLite database that’s been through…
The encoding PRAGMA in SQLite: A Complete Guide
If you’ve ever opened a SQLite database and wondered why some text looks garbled, or why a column…
The count_changes PRAGMA in SQLite: A Complete Guide
Every once in a while, you stumble across a SQLite feature that feels like a relic from an…
The case_sensitive_like PRAGMA in SQLite: A Complete Guide
If you’ve spent any time writing search features with SQL, you’ve probably used the LIKE operator to find…
The cache_size PRAGMA in SQLite: A Complete Guide
Performance tuning in SQLite often comes down to a handful of settings that quietly make a huge difference…
The auto_vacuum PRAGMA in SQLite: A Complete Guide
If you’ve ever deleted a large chunk of data from a SQLite database and noticed the file size…
The PRAGMA Statements in SQLite: A Complete Guide
Anyone who’s spent time working with SQLite has run into the word “PRAGMA” sooner or later — usually…
The DISTINCT Keyword in SQLite: A Complete Guide
One of the very first problems you run into when writing SQL queries is duplicate data. You run…
The HAVING Clause in SQLite: A Complete Guide
If you’ve worked with GROUP BY in SQLite, you’ve probably run into a situation where you wanted to…