vper.blogg.se

On macOS list the full download history from all applications: $ sqlite3 demo64.db "SELECT * FROM Sales "

Run a select command against database demo64: vfs NAME use NAME as the default VFS Examples stats print memory stats before each finalize separator SEP set output column separator. scratch SIZE N use N slots of SZ bytes each for scratch memory pagecache SIZE N use N slots of SZ bytes each for page cache memory nullvalue TEXT set text string for NULL values. lookaside SIZE N use N entries of SZ bytes for lookaside memory cmd COMMAND run "COMMAND" before reading stdin Sqlite3 FILENAME Ī new database is created if the file does not previously exist. Used by macOS, Firefox web browser, WIndows 10, Dropbox, Skype and many other client programs. SQLite is a public domain zero-configuration, transactional SQL database engine.