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 GROUP BY Clause in SQLite: A Complete Guide
If there’s one SQL clause that marks the transition from “I can write basic queries” to “I can…
The ORDER BY Clause in SQLite: A Complete Guide
If you’ve spent any time working with databases, you already know that raw query results rarely come back…
The LIMIT Clause in SQLite: A Complete Guide
Every time I write a query against a table that might have thousands or millions of rows, one…
The GLOB Clause in SQLite: A Complete Guide
Most people learning SQL get introduced to pattern matching through the LIKE operator, and honestly, for a long…
The LIKE Clause in SQLite: A Complete Guide
If there’s one pattern-matching tool in SQL that I’ve used more than any other, it’s LIKE. Whether I’m…
The DELETE Query in SQLite: A Complete Guide
Deleting data is one of those operations that seems dead simple until the moment you accidentally wipe out…
The UPDATE Query in SQLite: A Complete Guide
Data changes. Prices go up, order statuses move from “pending” to “shipped,” user profiles get edited, typos get…
The AND and OR Operators in SQLite: A Complete Guide
Almost every meaningful query I write involves more than one condition. “Give me all orders that are pending…
The WHERE Clause in SQLite: A Complete Guide
If SELECT is the clause that tells SQLite what data you want to see, WHERE is the clause…
Expressions in SQLite: A Complete Guide
When people first learn SQL, they usually think about it in terms of clauses — SELECT, WHERE, ORDER…