SQLitely

SQLitely is an SQLite database tool, written in Python.

It can:

• detect and manage SQLite databases in bulk
• create new or temporary databases
• create and alter tables, indexes, triggers and views
• modify table data
• free-form search over all database data and metadata
• export data and metadata in various formats (text, HTML, spreadsheet, JSON, SQL)
• import data to tables from spreadsheet or JSON
• view database table and index size statistics
• copy tables from one database to another
• execute direct SQL queries
• manage database PRAGMA directives
• fix database corruption

Using The Program

SQLitely can search over all columns of all tables with a simple query syntax. Keywords can search from specific tables and columns only (table:foo, column:bar), or from certain dates only (date:2012, date:2010..2013-06). Search supports wildcards, exact phrases, grouping, excluding, and either-or queries.

SQLitely can show disk space usage for each table and index, in bytes and overall percentage. (Depending on the size of the database, this analysis can take a while.)

SQLitely offers a convenient way for complex ALTER TABLE operations. Columns and constraints can be changed, reordered, added, dropped; the program automatically performs the multiple steps required for SQLite table modifications while retaining existing data (creating a temporary table, copying data, dropping old table, and renaming temporary table as old). Additionally, when renaming tables or columns, all related tables, indexes, triggers and views are altered automatically.

SQLitely can check database integrity for corruption, and copy as much data as possible over into a new database.

SQLitely has been tested under Windows 10, Windows 7 and Ubuntu Linux. In source code form, it should run wherever Python and the required Python packages are installed.

If running from pip installation, run sqlitely from the command-line. If running straight from source code, launch sqlitely.sh where shell scripts are supported, or sqlitely.bat under Windows, or open a terminal and run python -m sqlitely in SQLitely directory.

Attribution

Includes sqlite_analyzer, a command-line utility for table space analysis, (c) 2000, D. Richard Hipp, www.sqlite.org.

Includes a modified version of SQLite.g4 from sqlite-parser, (c) 2013, Bart Kiers, github.com/bkiers/sqlite-parser.

SQL lexer and parser generated with ANTLR v4.8, (c) 2012 The ANTLR Project, github.com/antlr/antlr4.

Includes several icons from Fugue Icons, (c) 2010 Yusuke Kamiyamane, p.yusukekamiyamane.com.

Includes fonts Carlito Regular and Carlito Bold, fedoraproject.org/wiki/Google_Crosextra_Carlito_fonts.

Includes fonts Open Sans Regular and Open Sans Bold, fonts.google.com/specimen/Open+Sans.

Binaries compiled with PyInstaller, www.pyinstaller.org.

Installers created with Nullsoft Scriptable Install System, nsis.sourceforge.net/.

License

The MIT License

Copyright (c) 2019 by Erki Suurjaak

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

The software is provided "as is", without warranty of any kind, express or implied, including but not limited to the warranties of merchantability, fitness for a particular purpose and noninfringement. In no event shall the authors or copyright holders be liable for any claim, damages or other liability, whether in an action of contract, tort or otherwise, arising from, out of or in connection with the software or the use or other dealings in the software.