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 in Python: A Complete Guide to the sqlite3 Module
If you have ever needed a database for a small project, a prototype, or even a desktop application,…
SQLite C/C++ Interface APIs: A Practical Guide for Developers
SQLite is written entirely in C, which means the C API is the native, original interface to the…
SQLite Built-In Functions: A Complete Walkthrough With Examples
One of the things I appreciate most about SQLite is how much you can accomplish using nothing but…
Preventing SQL Injection in SQLite: A Practical Security Guide
SQL injection remains one of the most common and most dangerous vulnerabilities in software development, and it does…
Date and Time Values in SQLite: A Complete Guide
If there is one topic in SQLite that trips up beginners more than almost anything else, it is…
The AUTOINCREMENT Keyword in SQLite: What It Actually Does and When to Use It
If you have worked with other database systems before coming to SQLite, you have probably used something like…
Types of Subqueries in SQLite: A Complete Guide with Examples
If you’ve spent any real time writing SQL, you’ve probably run into a situation where a single query…
Transaction Syntax in SQLite: A Complete Guide with Examples
If you’ve ever had an application crash halfway through updating several related database rows and ended up with…
Key Features of SQLite Views: A Complete Guide with Examples
Anyone who’s worked with a database for long enough eventually runs into the same problem: a query that…
The TRUNCATE TABLE Command in SQLite: What It Is, Why It Doesn’t Exist, and What to Use Instead
If you’ve come to SQLite from MySQL, PostgreSQL, SQL Server, or Oracle, there’s a good chance you’ve typed…