SQLite Can Do More Than You Think — Full-Text Search, JSON, Window Functions, and 281TB Databases
python
dev.to
SQLite ships with every Python, every iPhone, every Android, every Mac, and every Linux distro. Yet most developers reach for PostgreSQL or MySQL by default. Here are 5 things SQLite does that might surprise you. 1. Full-Text Search (Built-In) -- Create a full-text search table CREATE VIRTUAL TABLE articles USING fts5(title, body); -- Insert data INSERT INTO articles VALUES('Web Scraping Guide', 'Learn how to scrape websites using Python...'); INSERT INTO articles VALUES('API Tu