Changelog

v2.3, 2024-07-10:

• add command-line interface, with execute, export, import, parse, pragma, search, and stats
• add option to rename SQL window pages
• add support for CREATE TABLE .. STRICT (Python 3.9+)
• add support for empty or whitespacey table and column and constraint names
• add support for column keyword in meta search
• add dark mode toggle to HTML export
• streamline choosing related items when exporting to another database
• include read-only pragmas in PRAGMA SQL
• include original encoding pragma in database recovery
• include current filter/sort/hidden settings in data grid export
• tweak spreadsheet properties content in Excel export, include SQL query
• show pragma SQL in view mode as well
• skip initial blank rows in spreadsheet imports
• change default item action on diagram from opening schema to opening data
• update SQLite keywords from 126 to the latest 147-element list
• use a custom lockfile implementation for single instance check in Linux
• show descriptive error when trying to save view with blank column names
• skip hidden columns in data grid exports
• fix saving nested structures in JSON/YAML data import
• fix auto_vacuum and encoding pragmas not being editable in new databases
• fix updating main page upon removing databases when home-row is also selected
• fix foreign key constraint editor not allowing to add a column in duplicate
• fix entering new value in column/constraint editor editable comboboxes like column type
• fix rows-toggle not toggling data table in single item HTML export
• fix working with exotic characters in value editor
• change strip alphanumeric/non-alphanumeric strip functions to text/non-text
• make "Toggle all" toggle item CREATE SQL statements in combined HTML export
• add program version number and date to HTML export metadata
• fix intermittent mouse event error on diagram
• fix diagram selection rectangle font issues in Linux
• fix data leaks from orphaned background threads and dangling references
• improve handling tables WITHOUT ROWID
• restore program window on unminimizing from tray if window iconized
• ensure dialog windows get destroyed when closed
• tweak export panel buttons and layout
• tweak column/constraint editor layout
• disable automatic update checks and downloads in snaps
• include third-party license texts in snaps and stand-alone exes
• use latest custom-built PyInstaller 6.7 for producing binaries
• use _x86 suffix for 32-bit binaries, drop _x64 suffix from 64-bit binaries

v2.2, 2023-10-09:

• add line number and word-wrap toggles to more controls
• add diagram export to Tools-menu
• add option to export diagram with selected entities
• add refresh-button and copy-button to diagram toolbar
• add option to copy diagram image to clipboard
• add IF NOT EXISTS to schema editor
• add "Go to row" button to data dialog
• add YAML formatting options to value editor
• open databases in autocommit mode
• highlight open databases in database list
• unify context menus in data and schema trees
• retain undo history when loading SQL from file to SQL editor
• improve adding final semicolon to user-entered commented CREATE SQL
• improve compatibility with wxPython 4.2+
• speed up Excel export by improved caching for column width calculation
• speed up populating hex/byte editors in value editor
• fix error on changing column order in trigger/view editor
• fix error on reindexing table from diagram if table has no index
• fix error on checking foreign keys if foreign table has no primary key
• fix error on toolbar actions upon action query results in SQL editor
• fix error on loading SVG image in value editor
• fix user-defined function remaining inactive if saved without explicit compiling
• fix numeric spinctrls in pragma editor having invalid range
• fix detecting multiple statements in user-entered CREATE SQL
• fix ambiguity in parsing INDEX expressions with COLLATE
• fix value editor raising error on program exit
• fix Excel export error, from breaking changes in PIL
• drop step as a vendored library, use from public package index instead

v2.1, 2023-08-27:

• add user-defined functions to value editor
• add button panels to data and schema tabs
• add NULL column icons to schema diagram
• add column and key toggles to schema diagram
• add option to hide data grid columns
• add filter and hide column options in grid row context menu
• add support for multiple item export into any supported output format
• add command-line flag --config-file
• add NULLS FIRST|LAST to SQLite grammar ORDER BY clause
• add splitter to program main page
• add file encoding detection in CSV import, improve CSV dialect detection
• order database categories as table-view-index-trigger
• use uniform icons for schema tree items
• retain schema diagram custom layout on schema change
• support index and trigger keywords in meta search
• support importing structured data from YAML to database
• support importing JSON files containing a single dict
• support TIMESTAMP as date column type in search
• omit comments from JSON export
• underline matched texts in meta search results
• include journal file sizes in database size
• improve compatibility with GTK and Python 3.8+ on Linux.
• update step, the vendored template library
• fix loading user-specific configuration file
• fix schema diagram not loading entity positions from last config
• fix schema diagram adopting custom layout on clicking an entity
• fix collecting related entities on getting all related SQL or exporting to another database
• fix error on canceling a single grid export
• fix error on toggling diagram foreign labels on
• fix diagram in statistics HTML export using current view settings
• fix operating on key columns of BLOB affinity in data grids
• fix encoding errors in running disk usage analyzer
• fix escaping special characters for regex in exported HTML search functions
• fix complex alter ignoring related triggers (SQLite 3.25+ compatibility)
• fix JSON/YAML import not using column names from data
• fix spreadsheet import using same columns for all sheets

v2.0, 2022-04-02:

• add schema diagram, exportable as bitmap or vector
• add data import wizard
• add option to create database from spreadsheet or JSON
• add option to have only single instance running
• add option to clone a table or view
• add option to drop entire schema
• add support for single-user install
• add easy rename options to data & schema tree
• add easy drop column options to data & schema tree
• add spreadsheet file drag-drop support to database page
• add YAML support
• add Dockerfile
• full Python2 / Python3 compatibility
• improve auto-altering related items
• move to src-layout
• many fixes and UI tweaks

v1.2, 2020-09-22:

• add option to have only single instance running
• add support for single-user install
• minor fixes and UI tweaks

v1.1, 2020-08-08:

• add value editor tool
• add transform and date options to column value editor
• use OS- and user-specific config directory where necessary
• bugfixes and UI tweaks

v1.0, 2020-07-07:

• first public release