Softpedia >Windows >Portable Software >Database Utils >SQLite GUI >  Changelog

SQLite GUI Changelog

What's new in SQLite GUI 1.9.0

Mar 7, 2024
  • Improve UI for non-100% scales (issue #144)
  • Extension manager
  • Attach external sources as a schema through ODBC interface
  • Execute the current line by F12 (issue #152)
  • Auto-complete in row dialog (issue #153)
  • Modify help
  • Remove "Database diagram"-tool
  • Up SQLite to 3.45.1
  • Many other changes

New in SQLite GUI 1.8.2 (Nov 6, 2023)

  • Improve autocomplete
  • Ctrl + Mouse wheel to change font size
  • Duplicate table data
  • Up SQLite to 3.44.0
  • Minor changes (inc. issue #148)

New in SQLite GUI 1.8.1 (Sep 22, 2023)

  • Up SQLite to 3.43.1
  • Import public Google Spreadsheets
  • UI improvements
  • Fix minor bugs

New in SQLite GUI 1.8.0 (Jun 6, 2023)

  • Fix critical issue
  • Fix bug for a resultset with an error
  • Ctrl + P to show/hide a preview area
  • Minor UI improvements

New in SQLite GUI 1.7.9 (Jun 2, 2023)

  • Save and restore pinned resultsets
  • New CLI options: --profile, --readonly (issue #142)
  • Ctrl + I to invert selected rows in a dataset
  • Improve UI (issues #143, #145)

New in SQLite GUI 1.7.8 (Mar 4, 2023)

  • URI db path support (issue #139)
  • Up SQLite to 3.41.0
  • Fix issues #128, #130, #131, #134
  • Appy PR #132, #136, #137, #138
  • Minor changes

New in SQLite GUI 1.7.7 (Aug 19, 2022)

  • Ability to create desktop shortcuts
  • New option to commit autocomplete by TAB
  • Value selector by Alt + Space for FK in Edit data dialog (issue #126)
  • Fix issues #124, #125, #127, #128, #129

New in SQLite GUI 1.7.6 (Jul 31, 2022)

  • Pinned tables and views.
  • Up SQLite to 3.39.2.
  • Minor changes.

New in SQLite GUI 1.7.5 (Jul 3, 2022)

  • Up SQLite to 3.39.0
  • Resultset heatmap
  • inja: add raise_error(msg)

New in SQLite GUI 1.7.4 (Jun 19, 2022)

  • Support scripting in terminal mode (issue #116)
  • Fix crushes (issue #117)

New in SQLite GUI 1.7.3 (May 21, 2022)

  • Pinned result sets
  • Improve charts (issue #106)
  • Up SQLite to 3.38.5
  • Fix issues #104, #105, #107, #110, #111, #112, #114, #115

New in SQLite GUI 1.7.2 (Apr 24, 2022)

  • Resultset search by Ctrl + F
  • Resultset transposition
  • Compare an query (diff) with clipboard by Ctrl + D
  • Alt + Double Click in a resultset for drill-down by references
  • Drag-n-drop into a tree to open db or import csv/sql file
  • Improve text formatting (issues #101, #103)
  • Improve Edit data dialog
  • Help for pragmas
  • Minor changes
  • Fix bugs

New in SQLite GUI 1.7.1 (Apr 4, 2022)

  • Schema selector (issue #99)
  • Filter by value
  • Up SQLite to 3.38.2
  • Change comment/uncomment behaviour (issue #100)
  • Improve scripting
  • Fix bugs

New in SQLite GUI 1.7.0 (Feb 24, 2022)

  • Up SQLite to 3.38.0
  • Column filters for resultset
  • Jinja scripting
  • Improve BLOB handling + issue #98

New in SQLite GUI 1.6.6 (Feb 11, 2022)

  • Up SQLite to 3.37.2
  • Custom scalar functions
  • Fix issues #86, #88, #89, #90, #91, #93, #95
  • Fix minor bugs

New in SQLite GUI 1.6.5 (Dec 8, 2021)

  • Up SQLite to 3.37.0
  • bit version
  • Migrate to mingw64
  • Set font size for all controls
  • Fix bugs

New in SQLite GUI 1.6.4 (Nov 21, 2021)

  • Value preview (image, text or hex) of an query result
  • Recompile sqlite3 with math functions (issue #81)
  • Improve auto-detection for pasted text (issue #79)
  • Fix minor bugs

New in SQLite GUI 1.6.3 (Sep 20, 2021)

  • Export/Import CSV via CLI/terminal
  • Minor improvements
  • Fix minor bugs

New in SQLite GUI 1.6.2 (Aug 23, 2021)

  • Add a new tool for check foreign key
  • Add Index wizzard
  • Raise CSV import wizzard if a pasted text contains CSV data
  • Double-click selection: hold Ctrl to get an entire quoted text
  • Fix query formatter
  • Fix issues #63, #73

New in SQLite GUI 1.6.1 (Aug 15, 2021)

  • Improve resizing (issue #71)
  • Improve BLOB exports
  • Drag-n-drop files to editor (issue #73)
  • Export table or query result to Excel
  • Rough query formatter by Ctrl + T
  • Fix CSV import (issue #72)
  • Fix bugs

New in SQLite GUI 1.6.0 (Aug 4, 2021)

  • Query shortcuts Alt+F1, Ctrl + 1, Ctrl + 2, ...
  • Show help by Ctrl + Space
  • Name for result tab (use -- before an query)
  • Remove transform and math extensions
  • Minor changes
  • Fix minor bugs

New in SQLite GUI 1.5.9 (Jul 25, 2021)

  • Import/Export JSON
  • Built-in REST API web server
  • fileio extension
  • Fix bugs (issues #65, #67, #68, #69)
  • Fix "Add table" dialog
  • Minor changes

New in SQLite GUI 1.5.8 (Jul 16, 2021)

  • Alt + F8/F9 to get plan/execute an query under cursor
  • Save query result as a table
  • Query results comparison
  • Ora-extension: levenshtein distance
  • Add replacement to Find dialog
  • Fix issues #63, #64

New in SQLite GUI 1.5.7 (Jul 11, 2021)

  • Highlight all occurrences of selected word in editor
  • Ctrl + Space allows to select one of column values in Data editor
  • Export query result to CSV when row limit is exceeded (issue #58)
  • Show a result row number in the statusbar (issue #59)
  • Add vsv extension (issue #56)
  • Popup menu in terminal output
  • Fix minor bugs (issues #57, #61)

New in SQLite GUI 1.5.6 (Jun 21, 2021)

  • Automatic check for updates
  • Autocomplete column names (issue #52)
  • Copy an query result as csv with header (issue #53)
  • Up SQLite to 3.36.0
  • Fix minor bugs (issues #50, #51)

New in SQLite GUI 1.5.5 (Jun 7, 2021)

  • Drag-n-drop tree items to an editor (with Ctrl to generate statement)
  • Static colors for columns in Chart
  • Fix issues: #47, #48
  • Minor changes
  • Fix minor bugs

New in SQLite GUI 1.5.4 (May 31, 2021)

  • Add histogram and areas to charts
  • Improve history/saved queries lists (issue #44)
  • Fix issues: #37, #38, #41, #42, #43, #45

New in SQLite GUI 1.5.3 (May 26, 2021)

  • Ctrl + / in Editor to comment/uncomment block (issue #33)
  • Shift + F3 in Editor to change text case
  • Ctrl + A/Backspace/Del in small inputs (issue #35, #36)
  • + .set and .get commands in terminal
  • Fix an error line number (issue #31)
  • Fix save to file behaviour (issue #32, #34)
  • Improve charts (issue #11)
  • Fix bugs

New in SQLite GUI 1.5.2 (May 19, 2021)

  • "Save as" for database (issue #29)
  • Line number in a status bar (issue #22)
  • Line number in an error message (issue #23)
  • Fix editor's bug in Win10 (issue #25)
  • Fix issues: #18, #20, #21, #24, #26, #27, #28

New in SQLite GUI 1.5.1 (May 13, 2021)

  • Popup menu in History and User queries dialogs
  • .clear and .last N commands in Terminal
  • Improve charts: export to .png, scrolling for Bars chart, turn off/on lines in plot, dates support in plot.
  • Update SQLite Multiple Ciphers
  • Fix minor bugs

New in SQLite GUI 1.5.0 (Apr 22, 2021)

  • Support of encrypted database using by SQLite3 Multiple Ciphers
  • Ability to open in-memory database (issue #9)
  • Fix extension functions: XML.xml_each and ora.strpart
  • Fix insertion a number as numeric in a text column
  • Fix quick references in a single table mode
  • Up SQLite to 3.35.5

New in SQLite GUI 1.4.9 (Apr 12, 2021)

  • Ctrl + Click to view a cell value in an query result
  • XML-extension
  • Fix minor bugs

New in SQLite GUI 1.4.8 (Apr 8, 2021)

  • Hold Ctrl to open database read-only
  • Add conv(num, base_from, base_to) to ora-extension
  • Fix issue #7: attached databases must use the same text encoding as main database
  • Fix autostart of a transaction if an imported sql file has own transaction
  • Fix the single table mode
  • Fix the main toolbar color for non-classic Windows theme
  • Fix an error on open non-SQLite file

New in SQLite GUI 1.4.7 (Apr 5, 2021)

  • Add F2, Space and Ctrl + Tab hot keys in a Data editor
  • Colorize data grid by value types
  • Add < and > column filters
  • Up SQLite to 3.35.4 and recompile with FTS4, FTS5, RTREE and GEOPOLY support
  • Fix incorrect NULL-marks on sorting

New in SQLite GUI 1.4.6 (Apr 1, 2021)

  • Mark NULL-values in blue color
  • Improve Row dialog: hot key, Clear-option and a scroll (if columns are more than 20)
  • Ctrl + Alt + (Left or Rigth) to toggle between tables
  • Add options: Ask on row deletion and default a word wrap mode
  • Preventing clipboard clearing on exit
  • Up SQLite to 3.35.3
  • Fix bugs

New in SQLite GUI 1.4.5 (Mar 26, 2021)

  • Ctrl + W toggles a word wrap mode in an any editor
  • Ctrl + C and Ctrl + Shift + C for the navigation tree
  • Fix critical bug: parallel queries don't work

New in SQLite GUI 1.4.4 (Mar 25, 2021)

  • Single table mode: sqlite-gui <dbpath> <tblname>
  • BLOB size
  • Ora-extension: tosize
  • Row dialog updates only changed values
  • Fix buffer overflow bugs

New in SQLite GUI 1.4.3 (Mar 23, 2021)

  • Tab reorder
  • Modeless Add/Edit dialog
  • Up SQLite to 3.35.2
  • Fix bugs

New in SQLite GUI 1.4.2 (Mar 16, 2021)

  • Modeless "Edit data" dialog to edit multiple tables at the same time
  • Edit a view data if "instead of"-triggers are defined
  • Generated columns support
  • Delete a table column
  • Change word wrap mode in an editor by Ctrl + W
  • Show "instead of" triggers in DDL for a view
  • Up SQLite to 3.35.0
  • Fix Tab-key indent in an editor
  • Fix issue #6 ("Execute on a database connection" doesn't work)
  • Fix null arg e.g. md5(null) in ora extension
  • Fix bugs

New in SQLite GUI 1.4.1 (Feb 10, 2021)

  • Search on a database diagram
  • Export/Import table(s) via ODBC
  • SHARED in-memory schema instead TEMP
  • Move all extensions from sqlite-wf to sqlite-gui
  • Remove Workflow Manager
  • Fix issue #5 (pragma journal_mode=wal)
  • Fix minor bugs

New in SQLite GUI 1.4.0 (Feb 1, 2021)

  • Executing queries in parallel on different tabs (multi-threading mode)
  • Edit data dialog: support exactly match "=" and regexp "/" column filters
  • Ora-extension: base64_encode, base64_decode
  • Ora-extension: support negative index in strpart
  • Recompile sqlite3.dll with -O3 and -DSQLITE_THREADSAFE=2
  • Up SQLite to 3.34.1
  • Fix minor bugs