sqlite3 -header -column <DB_PATH> "YOUR SQL QUERY HERE;"

sqlite3 -json <DB_PATH> "YOUR SQL QUERY HERE;"

sqlite3 -header -column <DB_PATH> "SELECT name FROM sqlite_master WHERE type='table' ORDER BY name;"

sqlite3 <DB_PATH> ".schema tablename"

PGPASSWORD=<password> psql -h <host> -p <port> -U <user> -d <database> -c "YOUR SQL QUERY HERE;"

PGPASSWORD=<password> psql -h <host> -p <port> -U <user> -d <database> -c "SELECT tablename FROM pg_tables WHERE schemaname='public' ORDER BY tablename;"

PGPASSWORD=<password> psql -h <host> -p <port> -U <user> -d <database> -c "\d tablename"

SELECT COUNT(*) AS total FROM downloadhistory;

SELECT title, year, type, torrent_site, date FROM downloadhistory ORDER BY id DESC LIMIT 10;

SELECT id, title, src, errmsg, date FROM transferhistory WHERE status = 0 ORDER BY id DESC LIMIT 10;

SELECT name, year, type, season, state, lack_episode FROM subscribe WHERE state = 'R';

SELECT name, domain, upload, download, ratio, bonus, seeding, user_level FROM siteuserdata ORDER BY upload DESC;

SELECT server, library, COUNT(*) AS count FROM mediaserveritem GROUP BY server, library;

SELECT domain, success, fail, ROUND(success * 100.0 / (success + fail), 1) AS success_rate FROM sitestatistic WHERE success + fail > 0 ORDER BY success_rate DESC;

SELECT plugin_id, key FROM plugindata ORDER BY plugin_id, key;

DELETE FROM downloadhistory WHERE date < '2024-01-01';

UPDATE subscribe SET state = 'S' WHERE id = 123;

DELETE FROM transferhistory WHERE status = 0 AND date < '2024-06-01';