Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Changelog

Data viewer:

New UI for view switching (grid/text, record)
Columns search was added in data filter settings
Numeric data types rendering was fixed
Plaintext mode renderer was fixed

SQL Editor:

Action toolbar design was improved
Context menu was simplified
“Find paired bracket” command was added
Databse navigator: double-click behavior config was fixed
Quick object search dialog UI redesign (object types selector)

Data transfer:

Export from multiple SQL queries was added
Export into single file from multiple tables was added
Target file name generation was improved
Transaction log: history loading was fixed
Dark theme support was improved
Optional extensions install was fixed (Eclipse 2018-09 support)
Stored procedures calling was fixed for most databases
Auto-completion was added to selector controls (comboboxes)

New databases:

Apache Ignote driver was added
MapD (OmniSci) driver was added
Dremio database driver was added
PostgreSQL: sequences DDL was fixed
Greenplum: (thanks to GP team)
External tables create/edit support was added
GP functions DDL was improved
SQL Server: better support of SQL Server 2008 and earlier
Oracle: materialized view create/edit/refresh was added
DB2 iSeries: driver config was fixed (object descriptions read enabled)
SQLite: table DDL reading was fixed (indexes)
Eclipse plugin: older Eclipse versions (4.4-4.6) support was fixed
Interface localization was improved
Many minor UI bugfixes

[close]

https://dbeaver.io/

[SiLæncer]

Database Browser is an easy to use tool allows you to connect to any database (Oracle, MS-SQL, MySQL, Firebird, etc) and browse or modify data, run sql scripts, export and print data.

Features

    * Works directly with Oracle, MS Sql Server, ODBC, MySql, PostgreSQL, Interbase and Firebird
    * Support for ODBC connection strings
    * Unlimited number of connections
    * One click switching from one connection to another
    * One click table browsing
    * Data browsing
    * Data exports into CSV, Excel, Html files
    * Execution history
    * SQL Builder with wide range of supported databases
    * Execution Log
    * Incremental Table Search

http://www.etl-tools.com/database-editors/database-browser/overview.html

[SiLæncer]

Exportizer is a free database export tool. It allows you to export data to a file, clipboard, or printer. Exportizer works via BDE or ADO. It can convert DB, DBF, text, CSV to text, CSV, XLS, RTF, XML, HTML, DBF, and INSERT statements. Many export options ensure full control over output. There is an ability to specify the source-to-target field mappings. Export operations can be performed either via the program interface or via command line with large number of parameters. You can easily generate needed command line directly from the GUI. It is possible to copy data to the clipboard or print it. There are several utility functions for data manipulating and bookmarking.

Features:

Opening tables from multi-table database files like XLS, XLSX, XLSM, XLSB, MDB, ACCDB, HTML, GDB, IB, FDB, UDL, and other multi-table databases like ODBC data sources etc.
Exporting data from all files, which are located in one folder, or all tables from a multi-table data source, at once (from interface or via command line).
Ability to specify custom increment number for Increment Field Value function.
Exporting data to Excel (XML-based) and DATABASE formats.
Using extra command line line options like /Silent, /LogFile, /CloseOnError etc.
Using extra export modes like Append and Empty+Insert.

Whats new: >>

New command line option to create the target folder: /CreateTargetContainer.
64-bit version is available.
Minor changes.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

Added the VACUUM INTO command
Issue an SQLITE_WARNING message on the error log if a double-quoted string literal is used.
The sqlite3_normalized_sql() interface works on any prepared statement created using sqlite3_prepare_v2() or sqlite3_prepare_v3(). It is no longer necessary to use sqlite3_prepare_v3() with SQLITE_PREPARE_NORMALIZE in order to use sqlite3_normalized_sql().
Added the remove_diacritics=2 option to FTS3 and FTS5.
Added the SQLITE_PREPARE_NO_VTAB option to sqlite3_prepare_v3(). Use that option to prevent circular references to shadow tables from causing resource leaks.

Enhancements to the sqlite3_deserialize() interface:

Add the SQLITE_FCNTL_SIZE_LIMIT file-control for setting an upper bound on the size of the in-memory database created by sqlite3_deserialize. The default upper bound is 1GiB, or whatever alternative value is specified by sqlite3_config(SQLITE_CONFIG_MEMDB_MAXSIZE) and/or SQLITE_MEMDB_DEFAULT_MAXSIZE.
Honor the SQLITE_DESERIALIZE_READONLY flag, which was previously described in the documentation, but was previously a no-op.
Enhance the "deserialize" command of the TCL Interface to give it new "--maxsize N" and "--readonly BOOLEAN" options.

Enhancements to the CLI, mostly to support testing and debugging of the SQLite library itself:

Add support for ".open --hexdb". The "dbtotxt" utility program used to generate the text for the "hexdb" is added to the source tree.
Add support for the "--maxsize N" option on ".open --deserialize".
Add the "--memtrace" command-line option, to show all memory allocations and deallocations.
Add the ".eqp trace" option on builds with SQLITE_DEBUG, to enable bytecode program listing with indentation and PRAGMA vdbe_trace all in one step.
Add the ".progress" command for accessing the sqlite3_progress_handler() interface.
Add the "--async" option to the ".backup" command.
Add options "--expanded", "--normalized", "--plain", "--profile", "--row", "--stmt", and "--close" to the ".trace" command.
Omit deprecated PRAGMA statements when compiling with SQLITE_OMIT_DEPRECATED.
Increased robustness against malicious SQL that is run against a maliciously corrupted database.

Bug fixes:

Do not use a partial index to do a table scan on an IN operator. Ticket 1d958d90596593a774.
Fix the query flattener so that it works on queries that contain subqueries that use window functions. Ticket 709fcd17810f65f717
Ensure that ALTER TABLE modifies table and column names embedded in WITH clauses that are part of views and triggers.
Fix a parser bug that prevented the use of parentheses around table-valued functions.
Fix a problem with the OR optimization on indexes on expressions. Ticket d96eba87698a428c1d.
Fix a problem with the LEFT JOIN strength reduction optimization in which the optimization was being applied inappropriately due to an IS NOT NULL operator. Ticket 5948e09b8c415bc45d.
Fix the REPLACE command so that it is no longer able to sneak a NULL value into a NOT NULL column even if the NOT NULL column has a default value of NULL. Ticket e6f1f2e34dceeb1ed6
Fix a problem with the use of window functions used within correlated subqueries. Ticket d0866b26f83e9c55e3
Fix the ALTER TABLE RENAME COLUMN command so that it works for tables that have redundant UNIQUE constraints. Ticket bc8d94f0fbd633fd9a
Fix a bug that caused zeroblob values to be truncated when inserted into a table that uses an expression index. Ticket bb4bdb9f7f654b0bb9

Hashes:

SQLITE_SOURCE_ID: "2019-02-07 17:02:52 97744701c3bd414e6c9d7182639d8c2ce7cf124c4fce625071ae65658ac61713 "
SHA3-256 for sqlite3.c: ca011a10ee8515b33e5643444b98ee3d74dc45d3ac766c3700320def52bc6aba

[close]

https://www.sqlite.org/index.html

[SiLæncer]

Whats new:>>

Fix a bug in the query optimizer: an adverse interaction between the OR optimization and the optimization that tries to use values read directly from an expression index instead of recomputing the expression.

https://www.sqlite.org/index.html

[SiLæncer]

Database .NET is a powerful and intuitive multiple database management tool. The program allows the administration of local or remote databases to browse objects, design tables, edit rows, export data, create new databases and run queries with a consistent interface. The program includes table/data editor, index editor, syntax highlighting, SQL profiler, code manager and multiple query tabs.

Supported databases include SQL Server, SQL Azure, Firebird, SQLite, MySQL, PostgreSQL, Oracle, IBM DB2 and Informix, Sybase ASE, MS Access and Excel, dBase IV, FoxPro, Data Sources, ODBC DSN and OData. Can export to CSV, XML, TXT, XLS, or SQL Print Query Results.

License:    Free for personal or non-profit use

Changelog

- Security Manager :
Add: New database object (DATABASE OBJECTS) management: Support browsing / adding / deleting processing (6981)
Support includes: MySQL/SQL Server/Sybase ASE and other databases
Add: Supports object permissions management such as SQL Server (Server Roles/Database Roles/Application Roles/Users) (6981)
Add: Supports object permission management such as Sybase ASE (Server Roles/Users) (6981)
Add: Increase database switching processing, convenient for different databases (SQL Server) AppRoles/DbRoles/Users, (Sybase ASE) Users and other object management (6981)
Add: Support Sybase ASE login (Logins) password change processing (6981)
Add: Support IBM DB2 structure description (Schemas) [non-empty time] delete processing (6981)
Add: Object property management includes both object attribute content display (6981)
- SQL Editor ( SQL Editor ):
Add: support to open the association. SQL file processing, if the program is associated with the .SQL format, when double-clicked it will be able to open under [same program] (do not open more programs) (6981)
Add: Support for opening .SQL files (6981) without any query page (blank)
Upd: Drop the .SQL file to the editor to directly edit the file mode instead of the content loading process (6981)
- AutoComplete and IntelliSense :
Fix: Avoid automatic processing in Completion Mode when [Field] is automatically perceived (6981)
Upd: Displayed when the right-click menu is enabled (Mode: C/S/None, IntelliSense: On/Off) (6981)
- Table Designer :
Upd: (Sybase ASE) improved data table alter table processing power (6981)
- Secure Shell Agreement ( SSH: Secure Shell ):
Fix: (Teradata) Fixed an issue that was not enabled (SSH) after setting (6981)
- Code Manager :
Fix: Fix some database double-click to open the .SQL file and the label icon update problem (6981)
- Plain Execution Plan :
Upd: (Access) Improves processing speed when SQL syntax errors are raised while avoiding unnecessary external processing (6981)
- Main program update ( Main ):
Fix: Fixed a problem with reconnecting [different types] database after the current database connection failed (6981)
Fix: (Sybase ASE) Fixed a problem with the 'master' database's options cannot be changed when some of the libraries were on the master (6981)
Upd: (Teradata) Modifying the way Reserved Words is obtained, reducing the need for permissions (6981)
Upd: Others include cumulative small updates, corrections and optimizations (6981)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

A powerful and practical software utility specifically built to extract data from databases and improve performance by removing obsolete entries.

Apache License 2.0

Whats new:>>

Undo/Redo functionality.
Fixed an error in the analysis of views.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

Grant Manager for Members (64bit):
New Security Manager with Grant Manager for Members (6988)
Support for database role authorized user members ( GRANT USERS : IBM DB2/Informix/Oracle/SQL Server/SQL Azure/Firebird/Teradata/HP Vertica/NuoDB/MySQL/MariDB/PostgreSQL)
Support for user member authorization to the database role ( GRANT DATABASE ROLES : IBM DB2/Informix/Oracle/SQL Server/SQL Azure/Firebird/Teradata/HP Vertica/NuoDB/MariDB/PostgreSQL)
Support server role authorization login member ( GRANT LOGINS : SQL Server / Sybase ASE)
Support login member authorization to server role ( GRANT SERVER ROLES : SQL Server / Sybase ASE)
Grant Manager for Objects (64bit):
Add: Work column increases the button function that can be switched from [Specified Object] to [All Objects] (6988)
Add: (NuoDB) Join WITH GRANT OPTION Authorization check setting (6988)
Fix: (NuoDB) Fix and update User and Roles display mode and authorization processing (6988)
Security Manager :
Upd: (PostgreSQL) Detailed User and Roles Processing and Display (6988)
Fix: (NuoDB) Fix and update User and Roles display mode (6988)
Add: Support for Generating GRANT ROLE scripts (6988)
Add: Support for SQL Syntax Highlighting display processing (6988)
Upd: Also contains a lot of optimization updates and fixes (6988)
Auto Filter Data :
Add: Shortcut Key: Help F1 , Clear F4 , Execute F5 (6988)
Fix: Fixed an issue where IS NULL/IS NOT NULL could not be processed normally (6988)
SQL Editor ( SQL Editor ):
Fix: Fix and Improve Increase Indent and Reduce Indent Processing (6988)
Fix: Fixed a problem when indenting processing when ConvertTabsToSpaces=True (6988)
AutoComplete and IntelliSense :
Fix: Fixed 32bit under the list of inexplicable checkboxes (6988)
Main program update ( Main ):
Upd: Others include cumulative small updates, corrections and optimizations (6988)
Misc: Compatible with Compatible with PostgreSQL 11.2 / 10.7 / 9.6.11 / 9.5.16 / 9.4.21 (2019/02/14)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new: >>

Minor changes.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

Database health monitoring dashboards were added (for PostgreSQL, MySQL and MariaDB)
Bookmarks: navigate to object action was added
Content editor (XML, JSON): contents formatting was added (Ctrl+Shift+F)
Charts: copy image to clipboard action was added

SQL editor:

Morph to delimited text action was fixed (spaces processing)
Delete file action was added in tab context menu
Intelligent bracket auto-close was improved
Variables resolution was fixed (mixed letters case)
Script Save As in non-UTF encoding was fixed
Files delete: keep local history by default
Statistics panel rendering was fixed

Data editor:

JSON auto-format was fixed (null values)
Standalone editor of NULL values was fixed
Date-time editor in native format was fixed
Plaintext renderer was fixed (extra spaces)
SSH tunnel: keyboard-interactive AND publickey auth support was added
Open resources in embedded text editor support was added
Dark theme support was improved
Tips of the day dialog font was fixed (HighDPI)

PostgreSQL:

Arrays editor was fixed (new array create)
Indexes statistics was fixed (rel size)
Table dependencies info was added

SQL Server:

SQL errors processing was fixed (error inside stored procedures)

Oracle:

Objects search was fixed (synonyms resolution)
Procedures/packages compile was fixed (trailing delimiter, log error position)

CockroachDB:

Database schema browser was fixed (aggregate functions, rules)
Permissions reading was fixed (CRDB style)
MySQL: database dump without DROP statement option was fixed
Firebird: sequences metadata reading was fixed

Sybase:

Stored procedure reading was fixed (multiple databases)
Query processing was fixed (trailing semicolon issue)
Synonyms tab removed
Many minor UI bugfixes

[close]

https://dbeaver.io/

[SiLæncer]

SQLite Database Browser is a freeware, public domain, open source visual tool used to create, design and edit database files compatible with SQLite. It is meant to be used for users and developers that want to create databases, edit and search data using a familiar spreadsheet-like interface, without the need to learn complicated SQL commands.

Changelog

Highlights:

DBHub.io improvements
CSV import: speed, memory usage, usability, type detection and new default rules
Attach databases
Menu options for filtering
JSON and XML editors
Improvements to the plot UI
Better copy & paste support
Dark theme support on Linux
Dark mode support for windows and macOS isn't working yet. ??
Multi-threaded loading of data
Default quotes changed to double quotes
Add Record dialog
Printing support
The math extensions for SQLite are included in the windows and macOS installers
SilvioGrosso has kindly created a video showing how to load the math extensions on windows
Important Notes
This release includes SQLCipher 4.0.1, providing even stronger encryption than the previous release.
To open a database encrypted with a previous release, make sure to choose the "SQLCipher 3 defaults" in the dialog which asks for the encryption passphrase.
Our project file format has changed, to make it easier to modify with external tools.
Older format files are loaded fine, but all saving of project files is done using the new project file format.
Notes on the windows installers
We've moved to providing MSI based installers, instead of the previous .exe ones. These new installers include both SQLite and SQLCipher (for optional encryption):
DB.Browser.for.SQLite-3.11.1-win32.msi
DB.Browser.for.SQLite-3.11.1-win64.msi
These MSI based installers will automatically detect the previous release of DB4S (3.10.1) and remove it before upgrading. If you're using one of the 3.11.0 alphas/beta, or an older version of DB4S than 3.10.1, you'll need to manually remove it first before the upgrade.
Additionally, there's now a .zip version of each. That's useful for people needing to run DB Browser for SQLite without installing it first.
DB.Browser.for.SQLite-3.11.1-win32.zip
DB.Browser.for.SQLite-3.11.1-win64.zip
If you're not sure which one to get, try the .msi version first. ??
Note on the macOS installer
The macOS installation now includes the SQLite math extensions (math.dylib), located in the Contents/Extensions/ folder inside DB Browser for SQLite.app.
To use it, you'll need to either manually load it (Tools ? Load Extension), or tell DB4S to automatically load it every time (Preferences ? Extensions).
macOS doesn't easily allow going inside .app folders in file selection dialogs. To navigate to the correct folder you'll probably need to press Shift (?)+Command (?)+g when the file selection dialog is open, then give it the path of /Applications/DB Browser for SQLite.app/Contents/Extensions.
Bug fixes and enhancements since 3.11.0
DB Browser Crashes When Importing Its Own .sql dump (#1045)
Updated query optimisations (#1161)
Network inaccessible error when using a WiFi network (#1595)
"determining row count" displays forever in Browse Data tab (#1654)
About Info - display 32bit vs 64bit (#1660)
Allow bottom editor of Execute SQL tab to grow taller (#1670)
TEXT values show as BLOB (#1731)
Error encrypting in 3.11.0 (#1732)
It's not possible to modify some tables (#1733)
Class 'NullLineEdit' lacks Q_OBJECT macro (#1740)
Include SQLite 3.27.1 instead of SQLite 3.26.0

Enhancements:

Add menu option for attaching database and allow usage of attached databases throughout the entire UI (532fcd3, 44eb2d4, fbaf78e, 315019d, 1a3e3d3, ea1659e, a5ca756, 7db96cd, 72d64ed, f01ad40, 3e02420, #1131, #1132, #1133)
Make import of multiple CSV files easier to use (#1121)
Optimise the Import CSV dialog for better usability (#1072)
Improve speed of preview table for large fields in the Import CSV dialog (#720)
Speed up CSV import a lot and reduce its memory usage (6432517, b7a00d3, 6ed8080, 0eb1f65, 659f38e, ed9fda2)
All sorts of improvements for tracking dbhub.io databases and pushing them back to the cloud (8a540a2, fef884a, f18064f, b2ddcdd, f926a67, 8c0e4bf, c692ae0, 64b3341, d738597, 24ee209, a1855d8, eff92c2, #1136, a931699)
Move button for saving Execute SQL results to the toolbar (#1122)
Rearrange display format list for better usability (31e499d)
Add menu option to hide selected columns (and unhide them) in the Browse Data view (#1135, d4e228d)
Add automatic type detection to the CSV import (#1003, #1382)
Improve splitters in Execute SQL tab (#380)
New menu options for using a value as a filter in the Browse Data tab, and support all filter operators for strings (#1182, #1463)
Allow renaming SQL tabs by double clicking their title (#1186)
Add support for filtering for empty strings in the Browse Data tab (#1189)
Add a new menu option for also copying the headers to the clipboard (#1058)
Add a search bar (Ctrl+F) to Execute SQL editors (#191)
Add a find and replace dialog (Ctrl+H) to all SQL editors (#191, #1612)
It's now possible to select points in a plot and the corresponding rows in the table will be selected (e8e5671)
Show number of records to delete in the Delete Record button caption (5fbf5ca)
Add new display formats (46ec019, #1213, #1467)
Add special editor for JSON data in the Edit Cell dialog (#1173)
Add special editor for XML data in the Edit Cell dialog (#1253)
Use HTML when copying table data to the clipboard. This way less data is lost when pasting to spreadsheet applications (e60e9ff)
Some improvements to the plot UI including zooming, dragging and copying the plot to the clipboard (ade5627, #1245, cef1e90, #950, #1258, e34d360, #838, #1271, b2fbf45, #1310, c4109e6)
Some minor improvements to the Execute SQL UI (87e1b9b, 6d44c6d)
Allow pasting a value into multiple cells at once (0d7ca9b)
Allow changing the font of the result view in the Execute SQL tab (#1240)
Add a new button to the Browse Data tab to create a view from the current settings (#1246)
Add two new toolbar for Extra actions and for Project actions and add some more icons to the existing toolbars and menus (#331)
Allow configuration of BLOB text and style for the Browse Data tab (#1263)
Add a new dialog for managing database file extensions (#659)
Add possibility to drag and drop fields from the DB Schema dock to the SQL text editors (#119, #1250)
Add a Delete Record(s) option to the context menu of the table rows in the Browse Data tab(#1283)
Add a new --read-only command line option (#1265)
Allow duplicating multiple records at once (#1090)
Auto complete SQL keywords in upper case and add an option for it in the Preferences dialog (#1238, #1287)
Respect the ORDER BY clause when plotting a table view (#821, #838)
Also auto complete column names when they are not preceded by their table name (#1242)
Add bar charts to the plot dock (#1302)
Allow adding a legend to the plot (#1302)
Add "What's This" popups in some more places (52ae85d, 2c9cf75)
Avoid any hard coded colours and query system colours wherever possible. In practice this adds support for dark themes (#1324)
Add new option for setting the line wrap in editors (#1173)
When clicking the Report Bug menu item some system information are included automatically (#1386)
When an entire row is selected and you press the Delete key, the row is now deleted (#1391)
Change the rules for the CSV import and add a couple of options to override them (#1395)
Add a new menu item to export the current table view with all its settings to a CSV file (#1402)
Add support for deleting rows from views with editing unlocked (#141)
Add menu option to copy selection in table view as SQL statements (#1422)
Move loading of table records into a separate thread for better UI responsiveness (#1394)
Change the quotes for SQL identifiers from grave to double quotes and add an option to the Preferences dialog for it (#1436)
Change Open Database toolbar action to open a popup menu with an extra option to open a database in read-only mode (#1432)
Comments containing filename, line number and results of the executed statements are added to the "User" part of the SQL log dock (#1448)
Look for a dotenv file with a stored password when trying to open an encrypted database (#1404)
Make the Unlock View Editing dialog easier to use (241372e)
Add support for creating and editing in-memory databases (#335, #1492)
Menu restructured, Tools menu added (#1434)
Add case_sensitive_like pragma to the Edit Pragmas tab and save it to the project file (#1494, c9d651c)
When adding an empty row fails open a new Add Record dialog instead in the Browse Data tab. Also make the new dialog available by a new button (#530, #1477)
Store the values of all pragmas which aren't stored in the database in the project files (#1518)
Add schema names to the auto completion list of names and allow completion of schema.table.field (#1433)
Some new configuration options for the drag and drop of item names from the DB Schema dock (#1433, #1534)
Preselect file format filter depending on the current data type when exporting cell contents to a file (#1535)
Allow saving the hex editor contents when exporting binary cell contents to a file and allow copying the same data to the clipboard (#1438, #1485)
Add printing support to text and hex editors, plots, Database Structure tab, Browse Data tab and Execute SQL tabs (#1525)
Add some new menu items for optimising and checking the integrity of the database (#1435)
Save attached databases in the project file (#1532)
Add basic support for window functions (7e23214, 517743f)
Add an optional auto completion popup to the Browse Data tab which shows up when editing a cell (e1101ae, 04f27cc, 88d1cbc, b4b933c)
Some polishing of the main window UI (#420, f42b614)
Automatically preselect correct editor depending on the detected data type in the Edit Cell dialog (#1537)
Change project file format to support multiple sort columns (#1593)
The SQL function load_extension() is only enabled when explicitly requested by the user in a new setting (#1558)
Command line option for running with some setting set to a given value (#1588)

Bug fixes:

Avoid extra spaces when formatting SQL statements (18bcbf1)
Fix dbhub.io bugs (4dc5286)
Fix detection of image data in Edit Cell dialog (#1138, #1159)
Fix Vacuum dialog (c616b39)
Allow selecting text in Edit Cell dialog even if database is read only (#1123, #1461)
Clear filters in Browse Data tab when table structure changes (#1020)
Add support for parsing multiple foreign keys in column constraints (677d360)
Fix memory leaks (28446a4)
Fix input of custom data types in Edit Table dialog so it doesn't require you to hit Enter (#1147)
Don't query foreign key pragma all the time in Edit Table dialog (#1130)
Avoid unnecessary queries in Browse Data tab (#1108, #1187)
Support UTF16 strings in the default collation in DB4S (#1172)
Never override the built-in collations (#1172)
Fix problems when opening a database by drag and drop (9cff69f, #1236)
Fix crash when trying to edit the display format of a view column (9fd4ebe)
Better error and changes detection in Execute SQL tab (#1181, #1185)
Fix parsing of SQL statements on systems with some locales like Turkish (#1194)
Fix some high DPI issues (#1184)
Improve BLOB detection in Browse Data tab (9b30940)
Fix changing table name to a name that only differs in case (#1200)
Fix progress dialog of CSV import for very large files (#1212)
Select current display format when opening the Custom Display Format dialog (#1202)
Only display the horizontal scrollbar in the SQL editor when it's necessary (d8aeae1)
Show keyboard shortcuts in some places where they were missing (9ce4b23)
Fix restoring previous settings in the Export SQL dialog (ccb1fd4)
Never use quotes when copying data from the table view to the text clipboard (#1244)
Fix crash when clicking Save SQL file button when no SQL tab is opened (#1248)
Fix pasting table data from spreadsheet applications which put an extra line break at the end of the text (#1244)
Fix pasting when actually no data is in the clipboard (9db70e0)
Copying and pasting between different tables and copying binary data in the Browse Data tab is now always lossless (47b0749, #1257)
Fix copying binary data (316860a)
Don't ignore possible error messages when duplicating a record (#1255)
Don't truncate data at 32768 characters when editing it in directly in the table widget (#1281)
Fix binary data detection in table views (#1279, 27c6579, c9c848e, feda408)
Allow unsetting the encoding of a table (#1279)
Fix drag and drop of tables from the Schema tab (117af5a)
Fix style of web links in UI (#1286)
Fix execution of some SQL statements with comments and/or line breaks in them (#1270, #1334)
Add support for tables with ON CONFLICT clauses for their primary key (743e798)
Fix crash when pressing Tab at the last cell of a view (#1289)
Fix crash when trying to add an index to a database without any tables (#1293)
Fix problems after drag & drop of tables onto the structure view (#1288)
Copy original statement when clicking the Copy Create Statement menu option (#1300)
Fix updating and deleting from tables without rowid if the primary key value contains a "'" character (#1332)
Don't show "Show Rowid" menu option for tables without rowid (#1332)
Our project file format is now text only. This helps if you want to edit it in a text editor (#1306)
Don't commit the current transaction when trying to change the defer_foreign_keys PRAGMA (aebfc51)
Fix error messages when importing SQL files (431c671)
Show icons in Export SQL dialog (28baba8)
Only allow exporting tables in Export SQL dialog (b384027)
Tweak order of statements in exported SQL file for less import problems (b6c0560)
Fix text of toolbar actions for deleting and modifying objects other than tables (13d9f98)
Remember "primary key" of a view unlocked for editing when changing to another object and back (ea25618)
Only allow powers of two for page size in Cipher Settings dialog and Edit Pragma tab (#1405, 8a07f0e)
Make sure the insert and delete record buttons are only enabled if they can be used (115d1f1)
Suggest correct file extensions when export content of a cell to a file (885f4f7)
Make sure to reset results view even when a query didn't return any rows (#1437)
Auto suggest encodings in Select Encoding dialog (588363b)
Fix parsing of some complex SQL expressions in CREATE statements and fix parsing of CHECK constraints (#1454, c150d1a)
Fix multiple SQL statements in Execute SQL tab being split up at the wrong position (#1470)
Don't allow editing the SQL preview in the Create Index dialog (7a9f310)
When jumping to a row referenced to by a foreign key by using Ctrl+Shift+Click, perform an exact search instead of a LIKE search (d50a27a)
Fix crash when browsing a table, then deleting it in another tab and then switching back to the Browse Data tab (2701223)
Fix string quotes in Custom Display Format dialog (b6f47f9)
Prevent possible data loss when editing table with foreign keys enabled and ON DELETE CASCADE references (#1481)
Fix view when loading a project file while being in the Edit Pragma tab (a23c0a0)
Avoid confusion about the SQLCipher version in the About dialog (#1474)
Don't remove a record from the table view temporarily when deleting it has failed (#1511)
Show better error messages when importing SQL files (#1519)
Defer foreign keys when importing SQL files to avoid import issues for some files (#1519)
Fix editing of auto_vacuum pragma via the UI (#1518)
Fix initial loading of databases which depend on extension functions to be present (f3e6aec)
Fix cursor after SQL import finished (#1526)
Fix completion of quoted identifiers in SQL editor (#1433)
Fix positioning of cursor in Execute SQL tab when there is an error near a multi-byte character (99c53a4)
Fix some possible crashes when loading an invalid project file (717ff07)
Fix auto completion of keyword ROWID (78ae2c3)
Better error messages when editing the definition of a table fails (#1547)
Fix auto completion not working in some cases until you refresh the database (#1549)
Avoid unnecessary queries in the Browse Data tab in some cases (c78c03b)
Fix inserting, deleting and editing of rows in WITHOUT ROWID tables with a primary key of TEXT type (#1559)
Better error handling in import CSV dialog (#1590)

Fix possible resource leaks (#1691)
Platform specific:

Windows
Use MSI installers (#1400)
Make sure the image plugins are loaded properly (#1188, 9016bf6)
Also install license files (12ee94c)
Add version info to Windows executables (#1387)
Fix line breaks in SQL export (#1502) and quoting (041ceba)
macOS
Work around a Qt bug which causes high pings for Wifi connections (#1209, 77a701d)
Add a workaround to improve rendering performance on 4k/5k resolutions (#1233)
Add .sqlite, .db3 and .sqlite3 to the list of file associations (28f6c6e, 3008747)
Fix shortcut name for following a foreign key (#1539)
Linux
Make install paths configurable for qmake build (#1443)
Gnome
Fix problem with switching the workspace on Gnome (#934)

Translations:

Fix call tips in SQL editor for languages with non-Latin scripts (#1107, #1206)
Never translate the name of the pragmas in the Edit Pragma tab (9a30e6c)
Spanish translation updated (#1190, 2b6f0d7, aa82b52, 636136a)
German translation updated (09e170f, #1569)
Korean translation updated (8c85ff9)
Polish translation added (#1456)
French translation updated (b7dbfc8, 5a4df8d)
Italian translation added (#1705)
Czech translation updated (#1710)
Portuguese translation updated (#1707)
Simplified Chinese translation updated (#1594)
Russian translation updated (#1581)
Arabic translation updated (170fb69)
Packaging and Building
Fix code to work with Qt 5.10 and later (e6a4326, 189b750, 39302f5, 72506fb, #1475)
Update the bundled qcustomplot librar to version 2.0.0
Silence some cmake warnings (#635, #1143)
Show the build date of the nightly builds in the About dialog (0bc430b)
Restored Qt 5.2 compatibility (#1298)
SHA256SUMS
DB.Browser.for.SQLite-3.11.1-win32.msi
76076d5c20240479238705f2211cad709f23c31cabe1682e2953bf6a7168b8d0
DB.Browser.for.SQLite-3.11.1-win32.zip
558cb41445f0bdd31605aaeb52264ae9839b9e21aa75369a51352956966700fc
DB.Browser.for.SQLite-3.11.1-win64.msi
ffe1f44f10d49c9d382e66b951125ae1ee10d4bce93e5a32dbb8547d6bf7122f
DB.Browser.for.SQLite-3.11.1-win64.zip
a648b8faffc6da3fcf761f921270de2a2871d4116e2f7baf5e3b0280a538164c
DB.Browser.for.SQLite-3.11.1.dmg
bd4a74540a63a262fc49b816e8fc71fd816e81b215c31572d96b169d980a573e

[close]

http://sqlitebrowser.org/

[SiLæncer]

Whats new:>>

Transactional import did not roll back the transaction in case of an error.
improved HiDPI Support
Minor bug fixes.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

Transactional import did not roll back the transaction in case of an error.
improved HiDPI Support
Minor bug fixes.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

Undo/Redo functionality.
improved HiDPI Support.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

- Main program update ( Main ):
Add: Support for locking query tags ( Locking Query Tabs ) (6995)
Add: Changing the schema of query tabs (6995)
Upd: Last query tabs keeps records from original 100 to 200 (6995)
Upd: Others include cumulative small updates, corrections and optimizations (6995)
- Grant Manager for Objects (64bit):
Add: Increase the script generation display (Generating Scripts) (6995)
Add: (IBM DB2) Increase SEQUENCES permission settings (6995)
Add: (HP Vertica) Increase FUNCTIONS permission settings (6995)
Add: (Firebird) Increase FUNCTIONS/SEQUENCES permission settings (6995)
Upd: (Firebird) Excludes unwanted objects, greatly increasing the speed of member objects (6995)
Fix: Fixed an issue where some databases could not handle VIEWS permission settings (6995)
Fix: Fixed a problem with the permission setting when some databases PROCEDURES/FUNCTIONS did not contain parameters (6995)
Upd: Modify the authorization method to change the processing directly, replace the change and then save the processing (6995)
Upd: Change to exclusive display processing, avoiding the loss of function due to switching between different databases (Databases) or Schemas (6995)
- Grant Manager for Members (64bit):
Fix: Fix and update script generation (Generating scripts) (6995)
Fix: (Informix) Fix user member authorization to the database role (GRANT DATABASE ROLES) (6995)
- Data Export :
Fix: (Sybase ASE) Export SQL format: Fixed issue with date data type quote characters (6995)
- Query Builder ( Query Builder )
Fix: Table Alias ​​keyword AS is replaced by a space to be compatible with different database systems (6995)

[close]

http://fishcodelib.com/Database.htm