Tootfinder

Opt-in global Mastodon full text search. Join the index!

@lil5@social.linux.pizza
2025-11-18 22:30:31

#sqlite key value in 3 lines of sql

-- Run at startup CREATE TABLE IF NOT EXISTS kv (key TEXT UNIQUE, value TEXT); -- Create or set INSERT INTO kv(key, value) VALUES (?, ?) ON CONFLICT(key) DO UPDATE SET value=?; -- Get SELECT value FROM kv WHERE key = ? LIMIT 1
@michabbb@social.vivaldi.net
2025-08-27 10:01:25

📊 Supports #MySQL #PostgreSQL #SQLite and SQL Server with automatic collations
🛠️ Works with existing Laravel models and database
No complex setup required
⚡ Handles 100 cards…