Sqlitestudio 3.1.1 import excel12/28/2023 ![]() ![]() CHANGE: #4435 Changed data griv view behavior, so when user clicks once, it will select column/row and if double-clicks, the sorting order is applied.If a user keeps lots of gigabytes in a single table and you plan to query it, the user may want to limit amount of rows you query or display at once. While it served it purpose well, it introduced so many other issues (refer to GitHub issues mentioned for this ChangeLog item), that it was not worth it. CHANGE: #4240 #4458 #4419 #4129 Removed mechanism that limited initial value loaded to a cell to keep the amount of memory used at safe level.CHANGE: #4273 Newer opened database is selected by default in the tree.CHANGE: Unused the help button in title bar are removed.CHANGE: #4300 Db Dialog now has just 1 browse button, but uses Qt file dialog, not native one.Generation of qm files and updating qrc files is now fully automated. CHANGE: Finalized transition to new model of translation files (using Crowdin).CHANGE: #4071 #3437 Data column width has now more configuration options, so that it can retain its width upon entered value, or to have header contents (column name) visible.CHANGE: #4083 Added support for regexp literals and template literals in JS syntax highlighter.CHANGE: #2963 Application state (session) is saved (apart from normal application exit) whenever the state changes and also during critical application crash.Also changed plugin language name from QtScript to JavaScript and icon from Qt icon to JS icon. CHANGE: #3337 QtScript (deprecated module) usage migrated to QML module, using QJSEngine, the EcmaScript compliant implementation.CHANGE: #3272 Named function parameters of Custom SQL functions are now passed to script code as named variables.ADDED: Allow drag and drop a file to the add database dialog.ADDED: #4264 Added svg icon to portable packages.ADDED: #4249 Added tooltips for WITHOUT ROWID and STRICT checkboxes in the Table Window.ADDED: #3942 Added option to SQL Export plugin to add IF NOT EXISTS clause to CREATE statements.Also added single-row adjusting by double-clicking on the row header section on the left. ADDED: #4402 Added context menu option to adjust height of rows according to their contents.ADDED: #4065 Code Snippets - define in dedicated window, use it from the code assistant (hit the assistant hotkey twice).Also renamed 'all but selected' to 'other'. ADDED: #3793 Close windows on the left/right options added to the View menu and Taskbar context menu.ADDED: #4006 Colors configuration for syntax highlighting is reintroduced in a new, improved form.ADDED: #3714 Added highlighter for current query (under cursor, to be executed), to make the user aware which query is actually going to be executed when Execute Query hotkey is used.Default hotkeys: Ctrl+F9 (or Cmd+F9) for single query, Shift+F9 for all queries. ![]() ADDED: #3715 Dedicated hotkeys to execute either single query under cursor or all queries in editor, regardless of default execution mode configured.With version 3.3.0 Windows binaries were upgraded to 64 bit, but it turns out many people still need 32 bit binaries. ADDED: #3291 Filtering in View window (thanks to ADDED: #4103 Windows 32-bit binaries, alongside with 64-bit.ADDED: #4087 The installer packages are back (powered by VMware InstallBuilder), with proper "Start Menu" entries and SQLite file associations - across all 3 platforms!.It's also available in the configuration dialog. ADDED: #3503 #3963 SQL Editor has word wrapping option in context menu.ADDED: #3615 console.log() function for JS scripts.ADDED: #4050 Functions Editor allows marking functions as deterministic (thus using them for GENERATED columns).Requires Python installed in the system to use the plugin. ADDED: #513 Python scripting plugin added, along side with Python syntax highlighting plugin.ADDED: #4058 Added support for RIGHT, FULL OUTER JOIN, IS (NOT) DISTINCT FROM operators that were introduced in SQLite 3.39.ADDED: #4058 Added support for -> and -> operators from SQLite 3.38.ADDED: #4058 Added support for STRICT tables introduced in SQLite 3.37.ADDED: #4058 Added support for RETURNING syntax in INSERT/DELETE/UPDATE and MATERIALIZED syntax in CTE - introduced in SQLite 3.35.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |