6/24/2023 0 Comments Sqlitestudio databases![]() ![]() ![]() ![]() : #3094 #3095 default FK value preselection when tabbing thrĪDDED : SQLCipher plugin is now free, open source and distributed together with other standard plugins.ĪDDED : #2963 Indexed expressions for CREATE INDEX statements (introduced in SQLite 3.9) are now supported and can be edited in Index Dialog.ĪDDED : View window now supports explicit column names for the view (introduced in SQLite 3.9).ĪDDED : #3056 #3063 Implemented index column ordering in index dialog.ĪDDED : Added shortcut (Ctrl+/ by default) to toggle comment of current line or selected block of code (if any) in SQL editor.ĪDDED : #3040 Added new entry in context menu of data grid to generate SELECT/INSERT/UPDATE/DELETE statement together with WHERE clause containing IN conditions for selected cells.ĪDDED : Added new entry in context menu of database list to generate queries like in #3040 for selected table.ĪDDED : #2975 Information message after successful table/view change.ĪDDED : Introduced "loadByDefault" property for plugin descriptor files.ĪDDED : Added options to have "Data" tab placed as a first tab for Table windows and for View windows. : #3155 crash when confiriming custom FK value with Enter key. : #3126 #3092 problem with database versions in Android plugin. : DbAndroid plugin: 'adb' automatic detection under Linux. : #3118 #3124 #2943 double precision numbers formatting. Now the name is generated automatically by default, unless user starts to edit the name manually. More details in manual on wiki page.ĪDDED : #3127 Added 'select all' and 'deselect all' buttons in tigger's UPDATE OF columns dialog.ĬHANGE : #3135 Re-enabled possibility to database list panel (and reopen it from the View menu entry).ĬHANGE : #2901 Automatically generated database name includes full file name, except for the file extension only (unlike before, when it took only a file name up to the first dot).ĬHANGE : #3140 The "generate name automatically" checkbox has been removed. It's not invoked automatically to avoid performane.ĪDDED : #3136 Added "-master-config" command line option to have a settings file (regular SQLiteStudio config file) that all running SQLiteStudio instances import settings from. All described on SQLiteStudio's wiki (at User Manual page).ĪDDED : #3106 ScriptingTcl has now "tcl_init" command to invoke full interpreter initialization, which creates clock commands and some others. If another instance was requested due to associated file being open, then the first instance will not only be raised, but also the requested file will be added to database list as temporary, volatile database (not addedĪDDED : WxSQLite3 plugin (with encryption support).ĪDDED : plugin (ADO.NET, includes encryption support).ĪDDED : Support for "Row Value" introduced in SQLite 3.15.0.ĪDDED : New option in configuration dialog to decide whether you want to keep NULL values when entering empty strings in cells (new, more intuitive behavior), or overwrite NULLs with empty string values (as it used to be so far).ĪDDED : Editor window has now "Find" and "Replace" toolbar buttons for those functions (which were already there, available under shortcuts).ĪDDED : New built-in functions: import(), import_formats(), import_options() and charset(). If another instance is requested, the first one will be brought to the front of windows stack. NEW : #2651 Only a single instance of SQLiteStudio can be running at the time. NEW : #3224 Added context menu for SQL history tab to delete individual (or a range of selected) entries. NEW : #2798 Added filter inputs per column as an option. When AutoIncrement is enabled, a datatype will be enforced to INTEGER type. NEW : #2659 AutoIncrement option is now always available in PK configuration dialog. Portable (download run, without installation) distribution continues to be available. It also allows for some new features, like automatic file association under Windows. This addresses numerous with automatic updates that SQLiteStudio had. NEW : #3265 Completely new installer for SQLiteStudio is introduced. NEW : #3292 Added possibility to execute huge SQL files directly from disk, without loading them to SQL Editor. NEW : #3349 Added support for UPSERT syntax from SQLite 3.24.0. NEW : #3161 Added support for table-valued functions (). NEW : #3267 Added Extension Manager window, where all SQLite extensions can be registered for loading into databases. NEW : #3268 Query bind parameters are now supported by the query editor while execution - user will be asked for values for these parameters in a dedicated dialog. NEW : #3207 #1444 #2547 Export, Import Populate dialog settings are remembered, even after application restart. NEW : #3188 New plugin to have images stored in database being visible as another tab in the Form View or cell's editor dialog window. ![]()
0 Comments
Leave a Reply. |