SQLiteSpy is a fast and compact GUI database manager for SQLite. It reads SQLite3 files and executes SQL against them. Its graphical user interface makes it very easy to explore, analyze, and manipulate SQLite3 databases.
SELECT * FROM bytecode('SELECT 1');
SELECT * FROM tables_used('SELECT * FROM sqlite_schema');
uint
collation sequence, which compares strings of digits in numeric order.SELECT decimal_add('2', '3');
returns 5.SELECT decimal_sub('2', '3');
returns -1.SELECT decimal_mul('2', '3');
returns 6.CREATE TABLE t(a blob);
INSERT INTO t VALUES (x'01020304');
SELECT readblob('main', 't', 'a', 1, 0, 4);
SELECT * FROM sqlite_dbdata();
SELECT * FROM sqlite_dbptr();
SELECT delta_apply(x'0102', delta_create(x'0102', x'0304'));
select sqlite3_filename_database('main');
select sqlite3_filename_journal('main');
select sqlite3_filename_wal('main');
SELECT uuid();
SELECT uuid_str(uuid());
SELECT uuid_blob(uuid());
SELECT prefixes('abcdefg');
SELECT prefix_length('abcdxxx', 'abcyy');
yields 3.SELECT IsoWeek('2019-01-01');
SELECT IsoWeekYear('2019-01-01');
CREATE VIRTUAL TABLE t1 USING csv(filename='thefile.csv');
SELECT data FROM sqlite_dbpage('main');
SELECT checkfreelist('main');
SELECT sha3('abc', 256);
SELECT sha1('abc');
SELECT json_extract('{“a”:2,“c”:[4,5,{“f”:7}]}', '$.c[2].f');
SELECT * FROM generate_series(0,100,5);
spellfix
virtual table.:memory:
).ROWID
, OID
, or _ROWID_
) are in use by the table. This sould be very rare, however.Thanks to all who have reported bugs, suggestions and ideas to SQLiteSpy!