Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Changelog

THE MAIN PROGRAM UPDATED ( the Main ):
Add: increase MySQL 8.0 support database system to solve PROCEDURE / FUNCTION / INDEX and other compatibility issues (6176)
Add: Browse items increased sub-function key when a message prompts (Tooltip) process, facilitate more aware of their functional properties (6176)
Add: increase conversion cursor (Cursor) Object Browser item when dealing with sub-functions, to facilitate more intuitive and precise click-function items (6176)
Upd: remember the last selected database (non-default), next time when you turn directly without further selection switch (see all the same database mode) (6176)
Upd: Updated interface Russian language Russian language (by Alexey Yakovlev) ( 6176)
Fix: Connection settings ( the Connection Profile ): Fixed an exception error message attribute set display problems (6176)
Fix: Problems on the left portion of the tree nodes function can not be displayed under amendments WinXP Environment (6176)
Upd: Improved exception handling starts when you read the settings file (6176)
Upd: Cumulative contain other minor updates, fixes and optimization (6176)
MANAGEMENT CODE:
Upd: SQL File Version Control Manager ( Version Control Manager ): Save the original function LOG log file, change the Save selected to replace SQL log file (6176)
Fix: Fixed file name contains (...) issues when characters not properly handle related functions (including the title name, save files, etc ...) (6176)
Fix: Fixed Code Treeview is not completed before reading can not be performed in the SQL Editor [Save] or [renamed] Problems (6176)
SQL EDITOR:
Add: increase the automatic recognition ( Auto the Commit ) to the right-click menu (6176)
Add: increase automatically recognized shortcuts ( the Toggle AutoCommit the On / Off : the Ctrl +. 9) (6176)
DATA EXPORT:
Add: Export format INSERT statement scripts (* .sql) to increase the output page features a new query ( Generating INSERTs to new new Query window ) (6176)
DATABASE MIGRATION:
Upd: Updated with all dbMigration .NET Software (6176)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Object editor: many fixes in properties editor/refresh
Results editor: row data refresh after insert/update
ERD: refresh action was fixed
SQL queries execution was fixed (multiple statements, params binding)
SQL completion was fixed
Generic: auto-increment columns creation support (H2, Derby, Teradata, MSSQL)
H2: new database extension (supports views source, sequences)
MySQL: dump/restore wizard fixed
PostgreSQL: local client home configuration fixed
PostgreSQL: triggers properties improved
Oracle: triggers caching fixed (performance)
Cassandra: SSH tunnel support added
MongoDB: support of replica servers
Secure passwords storage support (EE)
Misc minor UI fixes

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

Multiple bug fixes to the row value logic that was introduced in version 3.15.0.
Fix a NULL pointer dereference in ATTACH/DETACH following a maliciously constructed syntax error. Ticket 2f1b168ab4d4844.
Fix a crash that can occur following an out-of-memory condition in the built-in instr() function.
In the JSON extension, fix the JSON validator so that it correctly rejects invalid backslash escapes within strings.

[close]

https://www.sqlite.org/

[SiLæncer]

Whats new:>>

A patch-level release which fixes an issue with exporting certain character sequences including a backslash (),
such as rn..
Because this issue [#12765](https://github.com/phpmyadmin/phpmyadmin/issues/12765) affects export functionality, we do recommend updating when possible.

http://www.phpmyadmin.net/

[SiLæncer]

Changelog

THE MAIN PROGRAM UPDATE ( the Main ):

Upd: optimized database object loaded into the processing speed of the tree nodes can improve the overall 30% (6185)
Add: increase in heavy brush all child objects option ( the Refresh All Objects ) (6185)
Add: Add the heavy brush and database schema list right-click menu ( the Refresh Database Schema and List ) (6185)
Fix: (Teradata) correction analysis query (Parse Query) after executing object resource release problems (including Binding dialog box test) (6185)
Fix: (SQL Server / SQLAzure / SybaseASE) amended [schema using the object name as the object of the preposition] settings, with the exception of characters deal with related issues (6185) (.)
Fix: (Pro 64bit) removed no longer supported (32bit) library function menu (6185)
Upd: Cumulative contain other minor updates, fixes and optimization (6185)

ROW EDITING AND BROWSING ( the Data Editor and Browser ):

Add: Added full windows showed ( Full Screen Results ) (6185)
Upd: Add the full prompt message shortcut keys: Contains (Filter this column / Select this column / Open cell and row / Edit cell) (6185)
Fix: Display should return data shows the number of rows exceeds ( the Maximum Number of rows to answer the display ): Fixed issues with progress dialog window displayed simultaneously (6185)

TEXT OF THE PLAN OF IMPLEMENTATION ( Plain the Execution Plan ):

Upd: (Pro 64bit) SQL Server 2000 to change the execution plan text display process (6185)
Fix: Fixed return contains two-character language (DBCS) characters, the program can not proceed normally cause problems processing (6185)

SQL EDITOR ( the SQL Editor ):

Upd: Optimizing Queries tab (Query Tab) and new switching processing speed, significantly reducing the impact of a relatively large amount of time objects (6185)
Upd: Fixed jump to the next word shortcuts (Char Right: Ctrl + Right) : If we are to resolve when clicking will continue to repeat the last line of questions at the end of (6185)
Upd: Change the execution plan shows the shortcut keys (Execution Plan: Ctrl + F6) : Shortcuts to resolve duplication (6185)

DATA EXPORT ( the Data the Export ):

Upd: Improved JSON export file format Changduoxianzhi (> 4MB) Issues (6185)

THE CONNECTION SETTINGS ( the Connection Profile ):

Upd: resolve when IBM DATA SERVER DRIVER under execution connection (DB2 / Informix) is not installed, the program leads to abnormal exit problem (6185)

[close]

http://fishcodelib.com/Database.htm

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

Freeware

Whats new: >>

Minor GUI improvements.
Minor bug fixes.

http://www.vlsoftware.net/

[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

What's new: >>

– Fixed : Issues with updating data via table browser
+ Improved : Third party componets update

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

[SiLæncer]

Release Notes

# MySQL Enterprise Notes
- Enterprise Encryption for MySQL Enterprise Edition now enables server administrators to impose limits on maximum key length by setting environment variables. These can be used to prevent clients from using excessive CPU resources by passing very long key lengths to key-generation operations. For more information, see Enterprise Encryption Usage and Examples.
# Security Notes
* Incompatible Change: These changes were made to mysqld_safe:
- Unsafe use of rm and chown in mysqld_safe could result in privilege escalation. chown now can be used only when the target directory is /var/log. An incompatible change is that if the directory for the Unix socket file is missing, it is no longer created; instead, an error occurs. Due to these changes, /bin/bash is required to run mysqld_safe on Solaris. /bin/sh is still used on other Unix/Linux platforms.
- The --ledir option now is accepted only on the command line, not in option files.
- mysqld_safe ignores the current working directory.
# Other related changes:
- Initialization scripts that invoke mysqld_safe pass --basedir explicitly.
- Initialization scripts create the error log file only if the base directory is /var/log or /var/lib.
- Unused systemd files for SLES were removed.
- MySQL Server now includes a plugin library that enables administrators to introduce an increasing delay in server response to clients after a certain number of consecutive failed connection attempts. This capability provides a deterrent that slows down brute force attacks that attempt to access MySQL user accounts. For more information, see The Connection-Control Plugin.
- OpenSSL is ending support for version 1.0.1 in December 2016; Consequently, MySQL Commercial Server builds now use version 1.0.2 rather than version 1.0.1, and the linked OpenSSL library for the MySQL Commercial Server has been updated from version 1.0.1 to version 1.0.2j. For a description of issues fixed in this version, This change does not affect the Oracle-produced MySQL Community build of MySQL Server, which uses the yaSSL library instead.
# Functionality Added or Changed
- InnoDB: By default, InnoDB reads uncommitted data when calculating statistics. In the case of an uncommitted transaction that deletes rows from a table, InnoDB excludes records that are delete-marked when calculating row estimates and index statistics, which can lead to non-optimal execution plans for other transactions that are operating on the table concurrently using a transaction isolation level other than READ UNCOMMITTED. To avoid this scenario, a new configuration option, innodb_stats_include_delete_marked, can be enabled to ensure that InnoDB includes delete-marked records when calculating persistent optimizer statistics.
- Unit testing now uses Google Mock 1.8.
# Bugs Fixed
- Incompatible Change: A change made in MySQL 5.6.32 for handling of multibyte character sets by LOAD DATA was reverted due to the replication incompatibility
- InnoDB: The GCC mach_parse_compressed function should load one to five bytes depending on the value of the first byte. Due to a GCC bug, GCC 5 and 6 emit code to load four bytes before the first byte value is checked . A workaround prevents this behavior.
- InnoDB: Due to a glibc bug, short-lived detached threads could exit before the caller had returned from pthread_create(), causing a server exit.
- InnoDB: An error during a table-rebuilding operation on a table with only a generated clustered index (GEN_CLUST_INDEX) raised and assertion due to an error called with an invalid key name.
- InnoDB: On a table without an explicitly defined primary key, InnoDB did not replace the implicit clustered index (GEN_CLUST_INDEX) when a unique key was defined on a NOT NULL column.
- InnoDB: InnoDB failed to free memory used by the full-text optimizer thread.
- InnoDB: SHOW ENGINE INNODB STATUS output showed a “cleaning up” state for an idle thread. Thread state information was not reset after statement execution.
- InnoDB: After a server restart, concurrent INSERT operations a table with an auto-increment primary key resulted in a duplicate entry error. The current auto-increment value was not changed after auto_increment_increment and auto_increment_offset settings were modified.
- Replication: Tables with special DEFAULT columns, such as DEFAULT CURRENT_TIMESTAMP, that existed only on a slave were not being updated when using row-based replication (binlog_format=ROW).
- Replication: Enabling semisynchronous replication when a server was during the commit stage could cause the master to stop unexpectedly.
- Replication: The fix for Bug #81657 was correctly merged into MySQL 5.6.
- Some Linux startup scripts did not process the datadir setting correctly.
- CREATE TABLE with a DATA DIRECTORY clause could be used to gain extra privileges.
- OEL RPM packages now better detect which platforms have multilib support (for which 32-bit and 64-bit libraries can be installed). Thanks to Alexey Kopytov for the patch.
- Compiling MySQL using Microsoft Visual Studio 2015 Version 14.0.25420.1 in relwithdebinfo mode failed with linking errors.
- Warnings occurring during CREATE TABLE ... SELECT could cause a server exit.
- For segmentation faults on FreeBSD, the server did not generate a stack trace.
- The .mylogin.cnf option file is intended for use by client programs, but the server was reading it as well. The server no longer reads it.
- If mysqladmin shutdown encountered an error determining the server process ID file, it displayed an error message that did not clearly indicate the error was nonfatal. It now indicates that execution continues.
- The data structure used for ZEROFILL columns could experience memory corruption, leading eventually to a server exit.
- Use of very long subpartition names could result in a server exit. Now partition or subpartition names larger than 64 characters produce an ER_TOO_LONG_IDENT error.
- On Solaris, gettimeofday() could return an invalid value and cause a server shutdown.
- A union query resulting in tuples larger than max_join_size could result in a server exit.
- The optimizer could choose ref access on a secondary index rather than range access on the primary key, even when the cost was higher.
- For some deeply nested expressions, the optimizer failed to detect stack overflow, resulting in a server exit.
- When taking the server offline, a race condition within the Performance Schema could lead to a server exit.
- The Performance Schema events_statements_summary_by_digest table could contain multiple rows for the same statement digest and schema combination, rather than the expected single (unique) row.
- For debug builds: Adding a unique index to a POINT NOT NULL column triggered a warning and the key was not promoted to a primary key. Creating a unique index on a different non-NULL column in the same table then raised an assertion.
- Compiling using Clang 3.5 or higher with AddressSanitizer (ASAN) enabled caused the gen_lex_hash utility to abort on Clang LeakSanitizer memory leak check failures.
- Miscalculation of memory requirements for qsort operations could result in stack overflow errors in situations with a large number of concurrent server connections.

[close]

http://www.mysql.com/

[SiLæncer]

Changelog

Hierarchical connection folders support added
New folders browser was added
Object (table, schema, etc) editor activation (after restart) was improved
SSH tunnel invalidation fix
SSH keep-alive config was fixed
Connections copy/paste was fixed
Metadata search results UI fixed
Data export wizard was fixed (bad performance for long SQL queries)
Results viewer: total row count action added
Results editor: drop-down editor fixed, activation on key-down fixed
PostgreSQL: JSON support (value copy, array view) fixed
PostgreSQL: extra keywords & data types highlighting
Firebird: SQL delimiter redefine support added
Oracle: procedures/packages
check compile status on save
Oracle: PL/SQL blocks execution was fixed
DB2: session manager UI was fixed
DB2: tools (runstats, reorg, etc) UI was fixed
Teradata: JSON support
Exasol: views/tables descriptions, misc fixes
Exasol: now uses Maven repository for driver download
Cassandra: new rows edit was fixed
Cassandra: date/time values edit fixed
Misc UI fixes

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

MAIN PROGRAM UPDATE:

Upd: configuration changes to improve the security of software compatibility (6199)
Upd: (Informix) updated Boolean field detection method, processing is performed to optimize the efficiency of SQL statements (6199)
Upd: Improved exception handling Message: Upon completion of the implementation of the object release but failed (6199)
Upd: Cumulative contain other minor updates, fixes and optimization (6199)
Upd: SQLite element updated to System.Data.SQLite.dll 1.0.104.0 (3.15.2) (2016/12/16) (6199)
Upd: Firebird element updated to FirebirdSql.Data.FirebirdClient.dll 5.7.0.0 (2016/12/12) (6199)
Misc: the with Compatible the MySQL 8.0.0 (2016/09/12) / the MySQL 5.7.17 (2016/11/29) / the MySQL 5.6.35 (2016/11/29) / the MySQL 5.5.54 (2016 / 11/29)

DATA EXPORT:

Upd: Export optimization approach: boost export processing speed while reducing memory consumption (6199)
Add: execution results Archive (Results to File): supports multiple outputs the result (Multiple Results) (6199)
Add: execution results Archive (Results to File): increase the display message tab (Messages Tab) (6199)
Add: file format export process, support interrupt handling (6199)
Upd: File format export process, changed to specify in advance the export file name before handling (6199)
Fix: (Informix) export format INSERT statement scripts (* .sql) Fixed Boolean data type generation problems (6199)

BROWSE ROW:

Add: Support Export Processing Data Grid View next ( the Cell Viewer: the Export to File ) (6199)

THE CONNECTION SETTINGS:

Upd: adding different bits (32 / 64bit) Oracle Instant Client version detection, avoid improper use causes an exception occurs (6199)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new: >>

Improvements in exporting to SQL Script.
Minor changes.

http://www.vlsoftware.net/

[SiLæncer]

ESEDatabaseView reads and displays the data stored inside Extensible Storage Engine (ESE) database (Also known as 'Jet Blue' or .edb file). It displays a list of all tables available in the opened database file, allows you to choose the desired table to view, and then when you choose a table, it displays all records found in the selected table.

ESEDatabaseView also allows you to easily choose one or more records, and then export them into comma-delimited/tab-delimited/html/xml file, or copy the records to the clipboard (Ctrl+C) and then paste them into Excel or other spreadsheet application.

License:    Freeware

Whats new: >>

Added 'Save All Items' (Shift+Ctrl+S).

http://www.nirsoft.net/utils/ese_database_view.html

[SiLæncer]

Changelog

- The main program update ( the Main ):

Add: (64bit) Full support for VistaDB (6211)
Add: (ODBC / OleDB) Object Name Add Structure Description Name Display ( Objects with schema name ) (6211)
Add: (Access / SQLite / SQLCe / VistaDB) Creating an encrypted database directly (with SQLCe) (6211)
Upd: (DB2 / Informix) Add Library Loading Process AccessViolationException Exception Retry Processing (6211)
Fix: Fix some problems in the connection list if connection is not established after connection type is established (6211)
Upd: Optimize connection resource detection and release processing after interruption (6211)
Upd: IBM DB2 / Informix component version is updated to IBM.Data.DB2.dll 9.7.4.4 (11.1.1010.4) (2016/12/16) (6211)
Misc: (IBM DB2 / Informix) IBM Data Server Client Packages Version 11.1 Fix Pack 1 (2016/12/16)
Upd: Other Includes Cumulative Minor Updates, Fixes, and Optimization (6211)

- Data Editor and Browser :

Fix: (ODBC) Resolves the problem of slow inputting when the data of the [Text Type] field is read (including export and other related processing) (6211)
Upd: Optimize data update processing , when no primary key (PKs) and the field is defined as NOTNULL (6211)

- Table Designer :

Add: New Syntax Validation for creating a new table (6211)
Upd: When the data table is being reconstructed, detection processing of [REFERENCES ] is added (6211)

- Generating Scripts :

Fix: (Oracle) Fixes (6) Causes Problems Showing Unnecessary OR REPLACE Keywords When Generating Table Definitions (6211)
Fix: External Index Key Syntax NONE to NO ACTION Auto Convert (6211)


- Data Export :

Updating (6199) File Format Export Processing: Subsequent processing is not performed when the specified export file name is canceled (6211)

- AutoComplete and IntelliSense * :

Update: (Oracle) View [All] Structure Descriptions Supports View Table (V $ VIEWS) under Prescribed SYS Structure Description Automatic Perception Processing (6211)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Fix a bug concerning the use of row values within triggers (see ticket 8c9458e7) that was in version 3.15.0 but was not reported until moments after the 3.16.0 release was published.

[close]

https://www.sqlite.org/

[SiLæncer]

Changelog

Metadata viewer: columns are configurable
Navigator filters toggle command
SSH tunnel auth (password/public key) fix
SSH tunnel invalidate fix
SQL templates formatting fixed
SQL script execution fixed (blank lines)
SQL editor: empty files delete fix
Data viewer UI improved (column description in header)
Date editor: include combo-box editor was fixed
Connection wizard UI improved
Keep connection user name in secured storage
Connection properties edit/save fixed
MySQL: zero date/time value support
MySQL: drop index fix
PostgreSQL: procedure parameter names reading fix
PostgreSQL: sequence properties reading fix
PostgreSQL: CHECK constraints support
Teradata: JSON editor
Exasol: maven driver added
Eclipse Marketplace support added (EE version)
Many minor UI fixes

[close]

http://dbeaver.jkiss.org/