Releases · suurjaak/SQLitely

10 Jul 18:52

suurjaak

v2.3

7ba0e4a

v2.3 Latest

Latest

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

Windows binaries available at http://suurjaak.github.io/SQLitely/.

Assets 2

09 Oct 15:09

suurjaak

v2.2

d4c8ddc

v2.2

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

Windows binaries available at http://suurjaak.github.io/SQLitely/.

Assets 2

28 Aug 19:08

suurjaak

v2.1

b869c04

v2.1

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