SQLite

I’ve tried a lot of different databases over the years – majorly for personal apps. But one that has consistently captured my interest is SQLite. since most businesses avoid SQLite, sticking to the more tried and tested databases, I decided to learn it out of curiosity.

SQLite is lightweight, easy to use, and offers a wide range of features that make it perfect for all kinds of applications. With SQLite, you can store and manage your data in a structured way, using tables, columns, and SQL commands. It is used in a wide range of applications, from web browsers and mobile phones to embedded devices and IoT, thanks to its small size, low maintenance, and high performance.

Here’s a list of all the topics that are covered for SQLite till now:

SQLite

SQLite3 on MacOS: How to Use SQLite on macOS

Apt Install SQLite3 on Debian-based Distros

SQLite Alter Table Add Column

SQLite Create Index: Improving Query Performance

SQLite Create Database If Not Exists

SQLite CREATE TABLE IF NOT EXISTS: Conditional Table Creation

SQLite Update from Another Table: A How-To Guide

SQLite INSERT INTO SELECT: Mastering Data Insertion Techniques

SQLite Delete Column: How to Remove a Column

SQLite RETURNING Clause: Retrieving Modified Data