sqlite expert professional what version of sqlite

Added options to set the selected cells to NULL or to a specific value.Added thumb tracking option for grid scrollbars.Added 'Reindex Table' and 'Reindex All Tables' options.Redesigned the Database tab to display or set pragma properties for all attached databases.Added option to display the 'rowid' on the Data tab.Added option to limit the amount of memory used when displaying results as text.Added ability to generate SELECT, INSERT, UPDATE and DELETE statements based on the visible fields on the current table.Added option to associate custom file extensions with SQLite Expert.Added Find/Replace option in SQL/Lua/Pascal script editors.Added option to hide tabs and menu items to prevent bloating the user interface.Grid rows now resize height with the size of the text.Added option to allow only one instance of the application.

Added support for custom delimiters when exporting/importing to/from text files.Added keyboard shortcut (CTRL+/) for commenting/uncommenting selected text in SQL and script editors.Added option to open multiple SQL tabs.Added support for virtual tables including RTREE, FTS3 and FTS4.Added support for tables without rowid.Settings are now stored in a JSON file.Experimental SQL formatter on the SQL and DDL tabs.The change script is available before applying changes to a database object.Separate editors for table and column constraints.Redesigned table/view/virtual table editors, using a new recursive-descent SQL parser based on COCO/R.Improved usability for table editor based on user feedback.This fixes some issues related to displaying and editing data in the grid, and improves the overall look and feel of the application by replacing the VCL Styles with the DevExpress Skin Library. Due to user feedback, we have decided to bring back the DevExpress components used in version 3.x.Added support for BETWEEN and IN in filter expressions.Added 'Run sqlite3_analyzer.exe' option.Added option to install generic collations on demand.Added 'Max BLOB size' option to limit the size of BLOB values that are loaded in the grid.This page provides a summary of changes to SQLite Expert.

Sqlite expert professional what version of sqlite