Improved usability for table editor based on user feedback.Redesigned table/view/virtual table editors, using a new recursive-descent SQL parser based on COCO/R.Separate editors for table and column constraints.The change script is available before applying changes to a database object.Experimental SQL formatter on the SQL and DDL tabs.Settings are now stored in a JSON file.Added support for tables without rowid.Added support for virtual tables including RTREE, FTS3 and FTS4.Added option to open multiple SQL tabs.Added keyboard shortcut (CTRL+/) for commenting/uncommenting selected text in SQL and script editors.Added support for custom delimiters when exporting/importing to/from text files.Added option to allow only one instance of the application.Grid rows now resize height with the size of the text.Added option to hide tabs and menu items to prevent bloating the user interface.Added Find/Replace option in SQL/Lua/Pascal script editors. Added option to associate custom file extensions with SQLite Expert.Added ability to generate SELECT, INSERT, UPDATE and DELETE statements based on the visible fields on the current table.Enabled editing triggers and constraints in Personal Edition.Added options to set the selected cells to NULL or to a specific value.Added thumb tracking option for grid scrollbars.Īdded "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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |