Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Changelog

            - Eclipse 2019-03 is now the default platform
            - Embedded editor activation problem fixed (Linux)
            - SQL editor:
                - SQL errors now shown in results panel instead of modal dialog (configurable)
                - Certain long strings visibility problem was fixed
                - Auto completion was fixed for CALL/EXEC keywords
                - Tables/schemas were removed from columns proposals
                - Context menu was improved (redundant items were removed)
                - Numerous NPE errors were fixed
            - Multi-statements scripts formatter was improved (adding statement delimiters)
                - Database-specific named parameters prefix was added
                - SQL formatting was fixed
                - Morph delimited list formatter was fixed (spaces in tokens)
            - Data editor:
                - Unnecessary focus changing was fixed
                - Calc panel: strings/numbers aggregation toggle was added
            - Data transfer: fetch size was added in export settings (may significantly improve performance)
            - ERD (custom diagrams):
                - Additional styles were added for notes (colors, transparency, border, font settings)
                - Notes now can be connected with entities
            - Dashboards:
                - Timeseries dashboards rendering was fixed.
                - New dashboards extraction model was added (statistics reading by intervals)
                - Exasol dashboards were added
            - PostgreSQL:
                - Alpha version of GIS/spatial data viewer (maps) was added
                - Explain for queries with parameters was fixed
                - Database description reading was fixed (PG < 9.4)
            - Greenplum: tables reading for GP 4.x was fixed
            - Oracle:
                - Public synonyms in auto-completion
                - Session manager now shows instance ID (for clusters)
            - MySQL/MariaDB:
                - New database dialog now uses server charset/collation defaults
                - Native client was updated (problems with dump/restore compatibility)
            - MS SQL Server/Azure: driver version was updated, support of AD MSI authentication was added
            - Elasticsearch: metadata reading was fixed (schema/table names escaping)
            - Pervasive SQL driver configuration was added
            - MySQL NDB cluster driver configuration was added
            - Google BigQuery driver was updated
            - Numerous localization bugs were fixed
            - Many minor UI bug fixes

[close]

https://dbeaver.io/

[SiLæncer]

pgAdmin allows multi-database management through an administration interface for PostgreSQL permitting statement, procedure viewing and more.

License: Open Source

Whats new:>>

Ensure that pgAdmin4 should work properly with psycopg2 v2.8.
Fixed 'Change Password' issue for SCRAM authentication.
Ensure that two consecutive SELECT statements should work properly.
Relabel the Save button on the datagrid text editor to avoid confusion with the actual Save button that updates the database.

https://www.pgadmin.org/

[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

- Data Editor and Browser :
Add: Supports the sorting process of clicking the Decimal data type field, which can exceed > 28-29 precision sorting processing ( A special feature ) (7044)
Fix: Solve the problem that MySQL can't handle Decimal accuracy > 28-29 (7044)
Upd: Displaying Data Types on the column header (7044)
- Main program update ( Main ):
Add: Optimize automatic connection processing (Auto-Reconnect): Add connection restart (ConnectionReset) detection processing (7044)
Add: Supports the Edge -Slip setting ( Anti-Aliasing setting ) (7044)
Fix: (ODBC/OleDB) Fixed an issue where the execution of the SQL statement was not excluded if the comments were included (7044)
Fix: Improved [automatic] Quoted identifiers processing, adding more exception character processing (7044)
Upd: Improved error message display processing, avoiding the same error repeated display (7044)
Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 18.6.0 (2019/03/18) (7044)
Upd: Others include cumulative small updates, corrections and optimizations (7044)
- Filtering and Sorting columns :
Add: Add a Quick Button to the field display (7044)
Add: Increase Sort Columns Alphabetically (7044)
Upd: If you want to reorganize in the data column edit mode, you can keep the settings without re-screening (7044)
Upd: This function is removed in the data column search mode to avoid conflicts, because the display of the field depends on the search field (7044)
- Grant Manager for Members (64bit):
Fix: (Oracle) Fix user member authorization to the database role (GRANT DATABASE ROLES) (7044)
- Connection Profile :
Upd: (Sybase ASE) Adds the ServerDefault setting (same as the server character set) to the connected character set (7044)
Upd: (Sybase ASE/Firebird) Allows manual entry of character set encoding (CharSet) (7044)
- Database Migration (Pro):
Upd: All updates are the same as dbMigration .NET Software (7044)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

The data browser automatically reconnects when the connection is lost.
Minor bug fixes.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

Enhanced window functions:

Add support the EXCLUDE clause.
Add support for window chaining.
Add support for GROUPS frames.
Add support for "<expr> PRECEDING" and "<expr> FOLLOWING" boundaries in RANGE frames.
Added the new sqlite3_stmt_isexplain(S) interface for determining whether or not a prepared statement is an EXPLAIN.
Enhanced VACUUM INTO so that it works for read-only databases.

New query optimizations:

Enable the LIKE optimization for cases when the ESCAPE keyword is present and PRAGMA case_sensitive_like is on.
In queries that are driven by a partial index, avoid unnecessary tests of the constraint named in the WHERE clause of the partial index, since we know that constraint must always be true.

Enhancements to the TCL Interface:

Added the -returntype option to the function method.
Added the new bind_fallback method.

Enhancements to the CLI:

Added support for bound parameters and the .parameter command.
Fix the readfile() function so that it returns an empty BLOB rather than throwing an out-of-memory error when reading an empty file.
Fix the writefile() function so that when it creates new directories along the path of a new file, it gives them umask permissions rather than the same permissions as the file.
Change --update option in the .archive command so that it skips files that are already in the archive and are unchanged. Add the new --insert option that works like --update used to work.
Added the fossildelta.c extension that can create, apply, and deconstruct the Fossil DVCS file delta format that is used by the RBU extension.
Added the SQLITE_DBCONFIG_WRITABLE_SCHEMA verb for the sqlite3_db_config() interface, that does the same work as PRAGMA writable_schema without using the SQL parser.
Added the sqlite3_value_frombind() API for determining if the argument to an SQL function is from a bound parameter.

Security and compatibilities enhancements to fts3_tokenizer():

The fts3_tokenizer() function always returns NULL unless either the legacy application-defined FTS3 tokenizers interface are enabled using the sqlite3_db_config(SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER) setting, or unless the first argument to fts3_tokenizer() is a bound parameter.
The two-argument version of fts3_tokenizer() accepts a pointer to the tokenizer method object even without the sqlite3_db_config(SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER) setting if the second argument is a bound parameter

Improved robustness against corrupt database files.

Miscellaneous performance enhancements

Established a Git mirror of the offical SQLite source tree. The canonical sources for SQLite are maintained using the Fossil DVCS at https://sqlite.org/src. The Git mirror can be seen at https://github.com/sqlite/sqlite.

[close]

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

[SiLæncer]

Whats new:>>

Flag query editor as modified after pasting text

http://www.heidisql.com/

[SiLæncer]

Changelog

            - Connection/schema selector toolbar was redesigned
            - Create object context menu was redesigned
            - Data viewer:
                - Panels UI was redesigned
                - "Copy As" command was added (CSV, HTML, JSON, etc)
                - IN filter UI was improved (previous selection save)
                - Statistics view was improved (proper view of multiline queries)
            - SQL editor: auto-indent was fixed
            - GIS spatial data viewer beta version (PostgreSQL, MySQL/MariaDB):
                - Viewer panel was redesigned, special results presentation was added
                - Multiple objects viewing support was added
                - Copy/save as picture, print, SRID selector
            - Data transfer:
                - Export progress monitoring was fixed
                - Export from custom SQL queries performance was improved (using fetch size)
                - Split output file feature was added
            - Reset UI settings menu item was added
            - Backup/restore wizards: native client configuration was added in the dialog
            - MacOS X installer was updated (JRE version update)
            - PostgreSQL:
                - Schema/tables backup wizard was fixed
                - Triggers enable/disable tool was added
            - Greenplum: tables reading for GP 4.x was fixed
            - SQL Server:
                - Use TOP to limit queries fetch size
                - Dynamic parameters binding bug was fixed
                - Table triggers enable/disable tool was added
                - Support of special characters in object names was added
            - Oracle:
                - New config option for metadata reading performance fix
                - Subpartitions browser was added
                - PL/SQL blocks parser was improved
                - Configuration of system views usage was added
                - DDL reading was fixed (problem with string truncate with some driver versions)
            - Many minor UI bug fixes

[close]

https://dbeaver.io/

[SiLæncer]

Whats new:>>

Minor grammar fixes, add year into notice.

http://www.heidisql.com/

[SiLæncer]

Changelog

- Data Editor and Browser :
Add: Processing of Boolean data type default value (7058) when adding new data columns
Upd: When the Boolean data type data is allowed to be added when the data column is added (Value IS NULL) (7058)
Upd: Automatically convert text presets to quotes with double quotes (") to single quotes (') (7058)
Fix: Filtering data with a query : Fixed an issue where other data sheets could not be edited after use (7044.2)
- User Interface: Dark Mode :
Upd: Increases Dark Red and Dark Green (7058)
Upd: Optimize custom color display processing while improving restore sync update issues (7058)
- Main program update ( Main ):
Upd: Switching database list : Synchronous re-brushing when adding [Add/Remove/Restore] database (7058)
Add: (PostgreSQL) Increase varbit(bit varying) data type processing (7058)
Upd: Optimize all database version processing (7058)
Upd: NuoDB component version updated to NuoDb.Data.Client.dll 2.3.0.12 (2019/04/09) (7058)
Upd: Others include cumulative small updates, corrections and optimizations (7058)
Misc: Compatible with Compatible with Informix 14.10 (2019/03/20)
- SQL Editor ( SQL Editor ):
Add: Supports all tag names to be displayed in the ToolTip (7058)
- Server Objects (64bit):
Add: Support for inserting text (Insert Text) processing (7058)
- Database Migration (Pro):
Upd: All updates are the same as dbMigration .NET Software (7058)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

View execution plans for DB2 LUW.
Fixed "ERROR: failed to find conversion function from unknown to text"
that could occur with PostgreSQL in connection with the "local database" scope.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

View execution plans for DB2 LUW.
Fixed "ERROR: failed to find conversion function from unknown to text" that could occur with PostgreSQL in connection with the "local database" scope.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

            - Data editor:
                - Value transformers for custom queries and pseudo columns
                - Advanced data coloring configuration
                - Logical entity structure editor
                - Gradient colors for numerical/datetime columns
                - Navigate to FK/references: multiple rows support
                - Extra shortcuts were added
            - Spatial (GIS) viewer:
                - CRS (SRID) transformations support was added
                - Inverted coordinates support was added
                - Support of geography data type was added
                - Support of curved geometries was added
                - Open map in browser command
                - Maximum geometry objects limitation was added
                - Numerous bug fixes (tooltips, actions)
            - SQL editor:
                - Indentation was fixed (keyword-based indents were disabled)
                - Process @set commands in data export
                - "Format" context menu was fixed
            - Schema selector toolbar was fixed (missing database name)
            - Global native clients configuration was added
            - Shortcuts for connection/schema selectors were fixed
            - PostgreSQL:
                - Full schema DDL generation was added
                - Function create was fixed (function body)
                - Trigger create support was added
                - Columns DDL was added
            - MySQL: query metadata extraction was fixed (bug with wrong database name)
            - Oracle: metadata reading was fixed
            - SQL Server:
                - Procedures auto-completion was fixed
                - Support of older Azure versions was added
            - Redshift: external tables (spectrum) data reading was fixed
            - Clickhouse additional array data type support was added
            - Korean localization was added (thanks to Seongbae Chang)
            - Many minor UI bug fixes

[close]

https://dbeaver.io/

[SiLæncer]

Changelog

Data Import:

Upd: Rewrite the input file format (Delimited file format) processing (7065)
Supports native line feed character (CrLf) import processing, and compatibility with old newline character string (rn) import processing
Support for string content when multiple double quotes (") are parsed
Support for file files generated by third-party tools such as Mac/Unix/Dos
Fix: (Oracle) Resolve an issue with ORA-01704 error caused by importing more than 4000 characters (7065)
Fix: Fixed the problem that the statistics of the import data column was successfully counted without deducting the failure count (7065)
Fix: Fix preview window open *.psv file option has no effect (7065)

Data Export:

Add: Supports the native line feed character (CrLf) export processing, and retains the original newline character string (rn) for the preset (7065)
Add: Add Include Column Headings Export Options (7065)

Data Editor:

Upd: Improve and correct new data columns when the default value (Default Value) related problem processing (7065)

Main program update ( Main ):

Add: (SQL Server) Database Tools: Support Library Online/Offline Settings Processing (7065)
Upd: (Firebird) Remove unsupported data types for different database versions (7065)
Upd: Avoid the problem that the contents of the error message dialog box is out of the display range (7065)
Upd: Oracle component version [return] updated to Oracle.ManagedDataAccess.dll 12.2.1100 to resolve 10g compatibility issues (7065)
Upd: Others include cumulative small updates, corrections and optimizations (7065)
Upd: Compatible with Compatible with Microsoft Windows 10 (1903) (7065)

Database Migration (Pro):

Upd: All updates are the same as dbMigration .NET Software (7065)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

View execution plans for DB2 LUW.
Fixed "ERROR: failed to find conversion function from unknown to text"
that could occur with PostgreSQL in connection with the "local database" scope.

http://jailer.sourceforge.net/

[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.

Changelog

Fixed minor bugs in data export interface.
Minor improvements in database opening interface.
Minor bug fixes in exporting to Oracle databases. [Pro and Enterprise editions]
Added a new export option to migrate data to relational databases in batch mode. This increases the speed of exporting drastically. And you can change the speed by playing with the batch size. [Enterprise edition]
New command line option for batch data exporting: /UseBatchMode. [Enterprise edition]

[close]

http://www.vlsoftware.net/