Autor Thema: Datenbanksoftware und Tools diverses ...  (Gelesen 106856 mal)

0 Mitglieder und 2 Gäste betrachten dieses Thema.

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
MySQL 5.6.36
« Antwort #720 am: 11 April, 2017, 13:54 »
Release Notes

Compilation Notes:
Windows builds now use the default runtime libraries (builds use the /MD flag).
CMake support was added for compiling with Developer Studio 12.6.
Configuration Notes:
MySQL failed to compile if -DENABLE_DEBUG_SYNC=OFF AND -DWITH_DEBUG=ON were both given. The ENABLE_DEBUG_SYNC option has been removed and enabling WITH_DEBUG enables Debug Sync.
Packaging Notes:
Changes in RPM package structure require a larger set of packages to be removed to install MySQL Server cleanly.
To avoid potential race conditions, Debian packages now use the GNU install utility rather than a combination of mkdir, touch, and chown.
CMake-generated packaging for Debian/Ubuntu packages was refactored for improved maintainability. The change includes updated logic for correctly replacing native distribution packaging in Debian and Ubuntu.
Reminder: MySQL 5.6 requires the Microsoft Visual C++ 2010 Redistributable Package to run on Windows platforms. Users should make sure the package has been installed on the system before starting the server. The package is available at the Microsoft Download Center.
Security Notes:
The linked OpenSSL library for the MySQL Commercial Server has been updated to version 1.0.2k. 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.
The mysql_options() C API function now supports a MYSQL_OPT_SSL_MODE option. The only permitted option value is SSL_MODE_REQUIRED, to require a secure connection to the server. It causes mysql_real_connect() to fail if an encrypted connection cannot be obtained, without falling back to an unencrypted connection. Thus, mysql_real_connect() returns an error if the server does not support SSL or the client is not configured to use SSL. The client/server exchange terminates immediately after the initial server packet has been received if the server indicates that it does not support SSL.
To require an encrypted connection in MySQL 5.6, the standard MySQL client programs call mysql_options() to set MYSQL_OPT_SSL_MODE if the --ssl-mode=REQUIRED command-line option was specified. Third-party applications that must be able to require encrypted connections can use the same technique. For details, see mysql_ssl_set().
The minor C API version number was not incremented for this change. Application programs compiled for MySQL 5.6 that require MYSQL_OPT_SSL_MODE may fail to operate properly if the dynamic loader provides an older client library without MYSQL_OPT_SSL_MODE. Such applications must be written to handle this possibility by checking whether the mysql_options() call succeeds or fails.
Thread Pool Notes:
To improve thread_pool plugin performance, connection authentication and initialization have been moved from the acceptor thread to the thread pool worker threads that handle client connections. This enables the acceptor thread to handle new connections at a higher rate with reduced latency. The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE table now contains a CONNECT_THREAD_COUNT column that indicates the number of threads that are processing or waiting to process connection initialization and authentication. There can be a maximum of four connection threads per thread group; these threads expire after a period of inactivity.
Functionality Added or Changed:
Replication: When a negative or fractional timeout parameter was supplied to WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS(), the server behaved in unexpected ways. With this fix: A fractional timeout value is read as-is, with no round-off. A negative timeout value is rejected with an error if the server is on a strict SQL mode; if the server is not on a strict SQL mode, the value makes the function return NULL immediately without any waiting and then issue a warning.
The performance of UTF-8 binary collations was improved.
Consistency and maintainability of Debian/Ubuntu packaging maintainer scripts was improved.
mysql_secure_installation is more strict about what it considers valid yes and no responses.
Bugs Fixed:
InnoDB: The restriction that required the first undo tablespace to use space ID 1 was removed. The first undo tablespace may now be assigned a space ID other than 1. Space ID values for undo tablespaces are still assigned in a consecutive sequence.
InnoDB: Compiling the server without the Performance Schema caused a build failure.
InnoDB: The file handle type name for InnoDB file I/O Performance Schema instrumentation was changed from os_pfs_file_t to pfs_os_file_t.
InnoDB: A server exit on restart was caused by missing my_thread_init() and my_thread_exit() functions for background threads that initialize the st_my_thread_var structure.
InnoDB: A memcached read operation with a non-default read batch size configuration resulted in a server exit.
InnoDB: Performance Schema instrumentation for InnoDB file I/O was disabled on Windows.
InnoDB: The row_search_mvcc() function unnecessarily traversed the entire table for a range query, which occurred when the record was not in the transaction read view.
Replication: When using a multi-threaded slave (slave_parallel_workers greater than 0) the value of Seconds_Behind_Master was incorrect when rotating a relay log.
mysqldump failed to properly quote certain identifiers in SQL statements written to the dump output.
Client preauthorization by the server was missing a length check for a length-encoded string.
For Debian/Ubuntu packages, user-defined collation files could be overwritten during MySQL upgrades. Charset files are now marked as conffiles so that user customizations generate a prompt during upgrades whether to overwrite them.
For CREATE TABLE statements that specified the table name with a database qualifier and included a DATA DIRECTORY or INDEX DIRECTORY option, an error occurred if there was no default database.
Starting the server with performance_schema_digests_size=1 caused an abnormal exit.
mysqld_safe did not check whether the directory named by the --basedir option existed.
mysqld_safe failed if the error log file named by the --log-error option was a FIFO.
mysqld_safe could fail if the --datadir option value ended with a / character.
A recent change to mysqld_safe caused the mysql.server script to be unable to start it if the base directory was specified as an absolute path that differed from the compiled-in default absolute path.
The fix for Bug #78777 had different effects depending on whether the Performance Schema is enabled.
The connection_control plugin failed to compile if the Performance Schema was disabled.
For System V init scripts for RPMs, the [mysqld] option-file section was being ignored for some options, such as pid-file.
Init scripts failed to launch mysqld_safe if a non-default base directory was used.
mysqld_safe --no-defaults did not work (inadvertent consequence of an earlier bug fix).
Semicolon (;) characters within or between statements could cause distinct digests to be generated from identical statements.
For a client linked against libmysqlclient, invalid memory access could occur during use of prepared statements.
The fix for Bug #25088048 caused the command used by mysqld_safe to start the MySQL server to no longer include the mysqld path.
Executing a stored procedure containing a query that accessed a view could allocate memory that was not freed until the session ended.
A query could produce incorrect results if the WHERE clause contained a dependent subquery, the table had a secondary index on the columns in the select list followed by the columns in the subquery, and GROUP BY or DISTINCT permitted the query to use a Loose Index Scan.
Creation of a MyISAM temporary table during query processing could fail if the key length in the query was greater than the maximum MyISAM key length, resulting in a server exit.
The DebugPrintTest and DebugPrintDeathTest unit tests did not handle divide-by-zero testing properly on the Aarch64 platform. Thanks to Alexey Kopytov for the patch.
Changes made to mysqld_safe in recent MySQL releases require the --ledir, --mysqld, --mysqld-version options to be specified on the command line; they can no longer be specified in option files. This could cause failure of init scripts that invoke mysqld_safe. Such scripts now pass the value of the MYSQLD_OPTS environment variable as the first command-line argument to mysqld_safe, with the value set to such command line-only mysqld_safe option values as may be required. On platforms that use /etc/sysconfig/mysqld, the MYSQLD_OPTS value can be set in that file with a line such as this: MYSQLD_OPTS=" --ledir=/mysqld_ledir --mysqld=my_wrapper "
The value of MYSQLD_OPTS can also include mysqld options for mysqld_safe to pass to mysqld.
For LOAD DATA used to insert data into an updateable view, the check to verify whether a column is actually updatable was missing.
On Debian/Ubuntu platforms, the systemd startup script for MySQL ignored datadir settings in /etc/mysql/my.cnf.
A regular expression pattern match into a large string could result in a server exit due to memory allocation failure or integer overflow.
An incorrect error was reported for CREATE TABLE statements with a large value for the CONNECTION table option. The value is now limited to 1024 bytes.
MySQL now uses readdir() rather than readdir_r(). The latter has been deprecated since glibc 2.24 and caused debug builds of MySQL and builds using GCC 6.1 to fail.
Additionally, several problems resulting in GCC 6.1 compiler warnings were corrected.
The -DWITH_EDITLINE=system CMake option failed with recent versions of the editline library.
Grant tables with incorrect structure may cause problems in user management operations. As a consequence of the fix for this, for any operation that modifies a grant table, the server now checks whether the table has the expected structure and produces an error if not. mysql_upgrade must be run to update the tables to the expected structure.
The QUOTE() function could allocate excessive memory. A limit of max_allowed_packet bytes is now imposed and returns NULL with a warning for attempts to allocate more.
When attempting to locate the data directory, mysqld_safe incorrectly considered $MY_BASEDIR_VERSION/var as one of the possible locations.
The main.log_tables-big test case could be unstable on highly loaded hosts. Thanks to Laurynas Biveinis for the patch.
Queries that used an aggregate function with DISTINCT could produce incorrect results.
With the use_index_extensions flag of the optimizer_switch system variable disabled, some SELECT DISTINCT queries could return incorrect results.
Debian packages were missing an AppArmor-related include file and incorrectly were marked dependent on AppArmor (making it impossible to disable AppArmor by uninstalling it).
In a replication environment, SET PASSWORD or ALTER USER could fail to execute on the slave due to failure to parse the hash string correctly.
On non-Linux Unix systems, the mysql.server startup script used the Linux command pidof rather than pgrep.
Starting multiple instances of mysqld_safe after an abnormal server exit could result in one mysqld_safe instance killing another. As a consequence of the bug fix, the mysqld_safe.pid file is no longer used.
The --help message for mysqld_safe was corrected to mention that the --no-defaults, --defaults-file, and --defaults-extra-file options, if given, must be the first argument.
The bounds check for the XML parser position stack for each level (which has a fixed depth) used the size of the array as the upper limit, and so was off by one. This is fixed by decreasing the allowable depth by one, which actually matches the maximum number of elements in the position stack.
Timestamps for server-side prepared statements could be written to the binary log up to a second behind timestamps for the corresponding nonprepared statements, leading to time value differences between master and slave servers.

[close]

http://www.mysql.com/

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
Database .NET 21.5.6313.1
« Antwort #721 am: 14 April, 2017, 15:40 »
Changelog

DATA IMPORT:

Add: support for different format date automatic conversion processing (6313)
Add: (Text) support UTF-16 format file import (including browsing) (6313)
Fix: (Text) Fixed UTF-8 File Import Problem (6313)
Upd: (Vertica) Dramatically Optimize and Improve Import Processing (6313)
Fix: Fixed an issue where the import failed to return to the original window (6313)

DATA EDITOR AND BROWSER:

Upd: Optimize Decimal data type display processing (including export processing) (6313)

MAIN PROGRAM UPDATE:

Fix: (Firebird) Fixed Firebird 3.0 In-Line Edition, [Not Initial] Added in the database [Test] function does not work properly (6313)
Fix: (Firebird) Fix Initialization Automatically specify Firebird default path problem (6313)
Upd: HP Vertica Component Version Update to Vertica.Data.dll 8.0.1 (2016/12/16) (6313)
Upd: Other Include Cumulative Minor Update, Fix and Optimize (6313)

[close]

http://fishcodelib.com/Database.htm

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
Database .NET 21.5.6316
« Antwort #722 am: 17 April, 2017, 18:45 »
Changelog

- Main program update:
 Upd: Data Import : Data Export : Increases the overall performance by 30% to 50% (6316)
 Upd: Execute an SQL script file : Dramatically optimize batch processing speed (6316)
 Fix: Improved re-targeting Firebird's path without immediate reboot (6316)
- Data Import :
 Add: After the completion of the import, increase the number of skipped rows (Elipped time) and elapsed time (Elapsed time) and other information display (6316)
- Object Navigator :
 Add: (Firebird 3) support PSQL Stored Functions object browsing / creation and execution functions (6316)
- Database Migration (Pro):
 Upd: All updates with dbMigration .NET  Software (6316)

[close]

http://fishcodelib.com/Database.htm

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
DBeaver 4.0.5
« Antwort #723 am: 18 April, 2017, 10:10 »
Changelog

Transaction locks monitoring (PG and Oracle)
SQL scripts processing fixed (statements delimiter detect)
Transactions monitor UI fix
JSON and XML auto-formatting
SQL execution confirm dialog
Search results page: standard context menu support added
Error message dialog fix (huge messages)
Results viewer: statistics info was fixed
Results viewer: extra shortcuts for tab close/toggle
MySQL/MariaDB: support multiple result sets in single query
PostgreSQL: ERD rendering fix
Oracle: view definition fixed (column list was added)
LOB/XML/JSON cache fixed
Custom drivers configuration was fixed
Temp directory cleanup fix
Minor UI fixes

[close]

http://dbeaver.jkiss.org/

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
Database .NET 21.6.6324.1
« Antwort #724 am: 25 April, 2017, 13:40 »
Changelog

MAIN PROGRAM UPDATE:

Add: Supports all database Asynchronous connection open , allows waiting for interruption processing (6324)
Add: Connection Profile Connection (Connection Profile), support for non-synchronous connection test interrupt processing (6324)
Upd: Data Import : Data Export : Increases the overall performance by 30% to 50% (6316)
Upd: Execute an SQL script file : Dramatically optimize batch processing speed (6316)
Fix: Improved re-targeting Firebird's path without immediate reboot (6316)
Upd: HP Vertica Component Version Update to Vertica.Data.dll 8.1.0 (2017/04/17) (6324)
Updger: IBM DB2 / Informix component version update to IBM.Data.DB2.dll 9.7.4.4 (11.1.1011.4) (2017/04/10) (6324)
Misc: (IBM DB2 / Informix) IBM Data Server Client Packages 11.1 Fix Pack 1a (2017/04/10)
Upd: Other Include Accumulated Small Update, Fix and Optimize (6324)
Misc: Compatible with Compatible with SQL Server 2017 CTP2 (2017/04/19)
Misc: Compatible with Compatible with HP Vertica 8.1 (2017/04)

OBJECT NAVIGATION:

Add: (SQL Server 2017+) Support SQL graph tables Object browsing / creation and deletion (6324)
Fix: (SQL Server 2014 or above) Improved Table Properties Display Problem (6324)
Add: (MariaDB 10.3+) support SEQUENCES object browsing / create and delete functions (6324)
Add: (MariaDB 10.2+) Support CHECK Constraints Object Edit / Browse / Create & Delete (6324)
Add: (Firebird 3) support PSQL Stored Functions object browsing / generation and execution functions (6316)

DATA IMPORT:

Upd: to increase the default value of the overtime, to avoid the problem that the batch setting value is large, the overtime problem occurs (6324)
Upd: Allows custom batch size settings (Options-> BatchSize) (6324)
Add: After the completion of the import, increase the number of skipped rows (Elipped time) and elapsed time (Elapsed time) and other information display (6316)

Displaying informational messages :

Fix: (64bit) (PostgreSQL) Fixed (6309) Problems with Reporting Errors and Messages (6324)

[close]

http://fishcodelib.com/Database.htm

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
DBeaver 4.0.6
« Antwort #725 am: 02 Mai, 2017, 05:41 »
Changelog

Entity editor hyperlinks were redesigned (active with CTRL key down)
SQL editor advanced copy (copy queries in programming languages source code)
Data transfer wizard UI fixed (columns mapping)
Eclipse plugins now can be installed in CE version
Generate SQL: single query for multiple rows
HSQLDB: triggers support
MySQL: index creation wizard was improved
DB2: native timestamp format support
Refresh action was fixed (now works in session/locks viewers)
Multiple result sets fetch was fixed
XML formatting was fixed
Transaction monitor UI was fixed
A few minor UI fixes

[close]

http://dbeaver.jkiss.org/

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
ESEDatabaseView 1.51
« Antwort #726 am: 02 Mai, 2017, 05:50 »
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: >>

Fixed the 'Show Binary URL As String' feature to work properly when the URL string starts in different position.

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

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
Database .NET 21.7.6334.1
« Antwort #727 am: 05 Mai, 2017, 13:39 »
Changelog

Data Export :

Add: Data Column Export Format * .sql Added (Single INSERT: A single INSERT statement) option (6334)
Add: Data Column Export Format * .sql Add (Keep Nulls: Preserve null values) Options (6334)

Main program update:

Add: (Firebird) to create a remote database (6334)
Upd: (Oracle) remove the OCI Driver connection support, the original set automatically turn Managed Driver is not affected (6334)
Upd: Increases the loading speed when clicking on the click list (6334)
Upd: Last query tabs : Update no longer> 1MB tags for content (6334)
Upd: SQL History : The maximum number of days to keep the record increased to 365 days (6334)
Upd: Other Include Cumulative Small Update, Fix and Optimize (6334)

Object Navigator :

Add: Right-click menu Enabled or Disabling a CHECK Constraint (6334)
Support includes SQL Server / SQL Azure / Oracle and other databases
Add: (NuoDB / Sybase ASE) Right-click menu Enabling or Disabling a Trigger (6334)
Add: (NuoDB) Right-click menu to join the data table Enabled or Disabling an Index (6334)
Add: (NuoDB) Right-click menu to join the data sheet Rebuilding an Index (6334)
AutoComplete and IntelliSense :

Add: join the analysis of the complete table of contents ( Table Hints ) (6334)

SQL editor:

Upd: Improved SET TERM [XY] Custom Split Resolution (XY without spaces) (6334)
Fix: Inspect Object : Fixed (61xx) problem that caused the message to not disappear automatically (6334)

Database Migration (Pro):

Upd: All updates with dbMigration .NET Software (6334)

[close]

http://fishcodelib.com/Database.htm

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
Database .NET 21.8.6341.1
« Antwort #728 am: 12 Mai, 2017, 16:15 »
Changelog

MAIN PROGRAM UPDATE:

Add: Add Read-Only Mode :

Supports libraries such as SQLite / SQLCe / Access / Excel / dBase IV / Text / HP Vertica
Add: Support for IBM DB2 for z / OS database system (6341)
Fix: Improvements and Corrections Partial Database Constraints Generation and Reconstruction Issues (6341)
Upd: to avoid opening the program to force the exit, resulting in an exception (6341)
Upd: Firebird Component Version Update to FirebirdSql.Data.FirebirdClient.dll 5.9.0.1 (2017/05/07) (6341)
Upd: Other Include Cumulative Minor Update, Fix and Optimize (6341)
Misc: Compatible with Compatible with PostgreSQL 9.6.3 / 9.5.7 / 9.4.12 / 9.3.17 / 9.2.21 (2017/05/11)

PLAIN EXECUTION PLAN:

Upd: Execution Plan for MS Access : Optimize output processing Automatically remove portions that are repeatedly displayed (6341)
Upd: (PostgreSQL / MySQL) The original data format is displayed in text (6341)
Upd: (HP Vertica) Optimize content display while excluding unnecessary ( GraphViz Format ) format content (6341)

OBJECT NAVIGATOR:

Fix: (Firebird 1.5.x) Fixed Loading FUNCTIONS Object Field Name Problem (6341)
Fix: (SQLite) Fixed a problem with CHECK Constraints that could not be obtained if the character was included (6341)

DATA EXPORT:

Fix: data column export format * .sql fix Keep Nulls settings also affect the Keep Identity retention or not (6341)

AUTOCOMPLETE AND INTELLISENSE:

Add: support DELETE FROM tab1 WHERE col1 = val data table awareness and field awareness processing (6341)

MY FAVORITES:

Add: increase support for databases such as IBM DB2 / Informix / SQL Azure (6341)

[close]

http://fishcodelib.com/Database.htm

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
Exportizer 6.0.9.4
« Antwort #729 am: 15 Mai, 2017, 12:27 »
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 improvements in export routines.
Minor improvements and bugfixes in GUI.

http://www.vlsoftware.net/

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
DBeaver 4.0.7
« Antwort #730 am: 15 Mai, 2017, 17:45 »
Changelog

Tables/views inline filter (database navigator)
Open database connections from command line
ERD: dark theme support
SQL parameters fixed (param in SQL blocks)
SQL query execute statistics was fixed (fetch time added)
Project resources configuration is now persistent
Property editor behavior was fixed
SQL scripts layout config added
Gnome desktop config was fixed
SSH auth with private key
dialog fixed
Data export from SQL query was fixed (NPE)
UUID data type support was fixed
SnappyData driver has been added
MacOS DMG installer fix (Mac OS Sierra)
Many minor UI fixes

[close]

http://dbeaver.jkiss.org/

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
ESEDatabaseView v1.52
« Antwort #731 am: 16 Mai, 2017, 04:50 »
Whats new: >>

Added 'Detect UTF-16 Strings In Binary Data'. When it's turned on, ESEDatabaseView displays binary data as string if it detects that the binary data is UTF-16 string (e.g: 'Key' field in MSysLocales table).
Fixed bug: 'Copy Selected Items' worked improperly when setting the 'Unicode/Ascii Save Mode' to 'Always UTF-8'.

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

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
Exportizer 6.1.0.11
« Antwort #732 am: 23 Mai, 2017, 13:42 »
Whats new: >>

Improvements in export routines.
Improvements in data grids.
New environment option: Show Memo (long text) data.

http://www.vlsoftware.net/

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
SQLite 3.19.0
« Antwort #733 am: 23 Mai, 2017, 13:52 »
Changelog

The SQLITE_READ authorizer callback is invoked once with a column name that is an empty string for every table referenced in a query from which no columns are extracted.
When using an index on an expression, try to use expression values already available in the index, rather than loading the original columns and recomputing the expression.
Enhance the flattening optimization so that it is able to flatten views on the right-hand side of a LEFT JOIN.
Use replace() instead of char() for escaping newline and carriage-return characters embedded in strings in the .dump output from the command-line shell.
Avoid unnecessary foreign key processing in UPDATE statements that do not touch the columns that are constrained by the foreign keys.
On a DISTINCT query that uses an index, try to skip ahead to the next distinct entry using the index rather than stepping through rows, when an appropriate index is available.
Avoid unnecessary invalidation of sqlite3_blob handles when making changes to unrelated tables.
Transfer any terms of the HAVING clause that use only columns mentioned in the GROUP BY clause over to the WHERE clause for faster processing.
Reuse the same materialization of a VIEW if that VIEW appears more than once in the same query.
Enhance PRAGMA integrity_check so that it identifies tables that have two or more rows with the same rowid.
Enhance the FTS5 query syntax so that column filters may be applied to arbitrary expressions.
Enhance the json_extract() function to cache and reuse parses of JSON input text.
Added the anycollseq.c loadable extension that allows a generic SQLite database connection to read a schema that contains unknown and/or application-specific collating sequences.

Bug Fixes:

Fix a problem in REPLACE that can result in a corrupt database containing two or more rows with the same rowid. Fix for ticket f68dc596c4e6018d.
Fix a problem in PRAGMA integrity_check that was causing a subsequent VACUUM to behave suboptimally.
Fix the PRAGMA foreign_key_check command so that it works correctly with foreign keys on WITHOUT ROWID tables.
Disallow leading zeros in numeric constants in JSON. Fix for ticket b93be8729a895a528e2.
Disallow control characters inside of strings in JSON. Fix for ticket 6c9b5514077fed34551.
Limit the depth of recursion for JSON objects and arrays in order to avoid excess stack usage in the recursive descent parser. Fix for ticket 981329adeef51011052.

[close]

https://www.sqlite.org/

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
Database .NET Free 21.9.6352.1
« Antwort #734 am: 23 Mai, 2017, 20:30 »
Changelog

SQL Profiler:

Add: (SQL Server 2012+) support for Extended Events , replacing all database versions after 2012+ (6352)
Add: Add SQL to New Query tab (6352)
Upd: multiple optimization and correction related issues (6352)

Main program update:

Upd: (SQLite) Individual distinction INTEGER PRIMARY KEY with AUTOINCREMENT definition processing for easy import and related processing (6352)
Upd: Optimize the connection list display with the increase left click to display the library menu function (6352)
Upd: Firebird Component Version Update to FirebirdSql.Data.FirebirdClient.dll 5.9.1.0 (2017/05/21) (6352)
Upd: SQLite component version update to System.Data.SQLite.DLL 1.0.105.1 (3.18.0) (2017/05/15) (6352)
Upd: Other Include Cumulative Small Update, Fix and Optimize (6352)
Misc: Compatible with Compatible with SQL Server 2017 CTP2.1 (2017/05/16)

Data column editor:

Fix: Fixed a problem where the default value can not be added when the default value is NULL (6352)
Fix: Fix the problem (6352) of the primary key selector ( PrimaryKey Selector ) when the foreign key field is a GUID type

SQL history:

Add: edit right-click menu to add SQL Formatting formatting (6352)

Database Migration (Pro):

Upd: All updates with dbMigration .NET Software (6352)

[close]

http://fishcodelib.com/Database.htm

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )