Thema: Datenbanksoftware und Tools diverses ...

[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 'New ESEDatabaseView Instance' under the File menu, for opening a new window of ESEDatabaseView.

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

[SiLæncer]

Changelog

# Functionality Added or Changed
- InnoDB: A new InnoDB configuration option, innodb_tmpdir, allows you to configure a separate temporary file directory for online ALTER TABLE operations. This option was introduced to help avoid tmpdir overflows that could occur as a result of large temporary files created during online ALTER TABLE operations. innodb_tmpdir is a SESSION variable and can be configured dynamically using a SET statement.
- yaSSL was upgraded to version 2.3.9. This upgrade corrects an issue in which yaSSL handled only cases of zero or one leading zeros for the key agreement instead of potentially any number, which in rare cases could cause connections to fail when using DHE cipher suites.
- The Valgrind function signature in mysql-test/valgrind.supp was upgraded for Valgrind 3.11.
# Bugs Fixed
- InnoDB: A small InnoDB buffer pool size with a large innodb_stats_persistent_sample_pages setting resulted in a Difficult to find free blocks in the buffer pool warning.
- InnoDB: Starting the server with an empty innodb_data_home_dir entry in the configuration file caused InnoDB to look for the buffer pool file in the root directory, resulting in a startup error.
- InnoDB: A full-text query run under high concurrency caused a server exit due to an invalid memory access.
- InnoDB: With a large innodb_sort_buffer_size setting, adding an index on an empty table performed more slowly than expected.
- Replication: When DML invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column, that DML has to be marked as an unsafe statement. If the tables are locked in the transaction prior to the DML statement (for example by using LOCK TABLES), then the DML statement was not being marked as an unsafe statement. The fix ensures that such DML statements are marked correctly as unsafe.
- Replication: As part of the fix for Bug #16290902, when writing a DROP TEMPORARY TABLE IF EXISTS query into the binary log, the query is no longer preceded by a USE `db` statement. Instead the query uses a fully qualified table name, for example DROP TEMPORARY TABLE IF EXISTS `db`.`t1`;. This changed the application of replicate-rewrite-db filter rules, as they work only on the default database specified in a USE statement. This caused slaves to fail when the resulting CREATE TEMPORARY TABLE was applied. The fix ensures that at the time of writing a DROP TEMPORARY TABLE IF EXISTS query into the binary log, a check is made for the default database. If it exists then the query is written as USE default_db in the binary log. If a default database is not present then the query is logged with the qualified table name.
- Replication: If generating a GTID for a transaction fails, the transaction is not written to the binary log but still gets committed. Although running out of GTIDs is a rare situation, if it did occur an error was written to the binary log as a sync stage error. With binlog_error_action=ABORT_SERVER, the server aborts on such an error, avoiding data inconsistency. When binlog_error_action=IGNORE_ERROR, the server continues binary logging after such an error, potentially leading to data inconsistency between the master and the slave. The fix changes the error to be correctly logged as a flush stage error.
- Replication: When using --gtid-mode=on , --enforce-gtid-consistency , and --binlog-format=row, if a user defined function with multiple DROP TEMPORARY TABLE statements was executed on a master, the resulting binary log caused an error on slaves. The fix ensures that stored functions and triggers are also considered multi-statement transactions, and that when --enforce-gtid-consistency is enabled, functions with CREATE TEMPORARY TABLE or DROP TEMPORARY TABLE statements generate an ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION error.
- Replication: Stored procedure local variables that were used in an ALTER EVENT statement were not being replicated correctly. This was related to the fact that CALL statements are not written into the binary log. Instead each statement executed in a stored procedure is binary logged separately, with the exception that the query string is modified so that uses of stored procedure local variables are replaced with NAME_CONST('spvar_name', 'spvar-value') calls. DDL statements (which are always binary logged in statement binary log mode irrespective of the current binary log format) can also use stored procedure local variables and a clash could cause them to not be replicated correctly. The fix ensures that any stored procedure local variables used in a query are replaced with NAME_CONST(...), except for the case when it is a DML query and the binary log format is ROW.
- Replication: DROP TABLE statements are regenerated by the server before being written to the binary log. If a table or database name contained a non-regular character, such as non-latin characters, the regenerated statement was using the wrong name, breaking replication. The fix ensures that in such a case the regenerated name is correctly converted back to the original character set. Also during work on this bug, it was discovered that in the rare case that a table or database name contained 64 characters, the server was throwing an assert(M_TBLLEN < 128) assertion. The assertion has been corrected to be less than or equal 128.
- Replication: Irrespective of the current binlog_format setting, DDL that changes metadata on a master is always identified and written to the binary log in STATEMENT format. Such DDL could occur from event based SQL statements, such as CREATE EVENT or DROP EVENT, or transactions that had unsafe functions such as sysdate(). When binlog_format=MIXED and attempting to replicate such DDL, it was not being correctly identified and therefore was not being correctly replicated.
- Inserting a token of 84 4-byte characters into a full-text index raised an assertion. The maximum token length was 84 characters up to a maximum of 252 bytes, which did not account for 4-byte characters. The maximum byte length is now 336 bytes.
- If a client attempted to use an unsupported client character set (ucs2, utf16, utf32), the error message reported to the client differed for SSL and non-SSL connections.
- Data corruption or a server exit could occur if a stored procedure had a variable declared as TEXT or BLOB and data was copied to that variable using SELECT ... INTO syntax from a TEXT or BLOB column.
- CREATE TEMPORARY TABLE .. SELECT statements involving BIT columns that resulted in a column type redefinition could cause a server exit or an improperly created table.
- Added Microsoft Visual Studio 2015 support. Changes include using the native (added in VS 2015) timespec library if it exists, renamed lfind/lsearch and timezone/tzname to avoid redefinition problems, set TMPDIR to "" by default as P_tmpdir no longer exists, deprecated std::hash_map in favor of std::unordered_map, and added Wix Toolset 3.10 support
- With character_set_server=utf16le, some values of ft_boolean_syntax could cause a server exit for full-text searches.
- With LOCK TABLES in force, an attempt to open a temporary MERGE table consisting of a view in its list of tables (not the last table in the list) caused a server exit.
- For certain prepared statements, the optimizer could transform join conditions such that it used a pointer to a temporary table field that was no longer available after the initial execution. Subsequent executions caused a server exit.
- Repeated execution of ALTER TABLE v1 CHECK PARTITION as a prepared statement, where v1 is a view, led to a server exit.
- In addition, output for some administrative operations, when they are attempted on a view, changes from “Corrupt” to “Operation failed”. These include ANALYZE TABLE, OPTIMIZE TABLE, and REPAIR TABLE, and ALTER TABLE statements that perform ANALYZE PARTITION, CHECK PARTITION, OPTIMIZE PARTITION, and REPAIR PARTITION operations.
- Valgrind detected some possibly unsafe use of string functions in code used for asymmetric encryption.
- SSL connections ignored any change made by passing the MYSQL_OPT_READ_TIMEOUT option to the mysql_options() C API function.
- Solaris packages failed to note the dependency of the MySQL client library on the libstlport library.
- Using systemd to start mysqld failed if configuration files contained multiple datadir lines. Now the last datadir line is used.
- If server was started with --thread-handling=no-threads, no foreground thread was created for a client connection. The Performance Schema did not account for the possibility of no foreground threads for queries on the session_connect_attrs table, causing an assertion to be raised.
- ALTER TABLE ... CONVERT TO CHARACTER SET operations that used the INPLACE algorithm were ineffective if the table contained only numeric data types. Also, such operations failed to clean up their temporary .frm file.
- Heavy SHOW PROCESSLIST or SELECT ... FROM INFORMATION_SCHEMA.PROCESSLIST activity could result in the server accepting more than max_connections connections.
- When used with the libmysqld embedded server, the mysql_stmt_execute() C API function failed with a malformed communication packet error, even for simple prepared statements.

[close]

www.mysql.com

[SiLæncer]

Changelog

Color results (based on column values)
UI freeze during table data save was fixed
SSH tunnel: password prompt was fixed
Properties editor fixed
Resources (scripts, diagrams, etc) copy/paste support was added
SQL formatter fixed (WHEN .. THEN)
Resultset filter dialog was improved
Data import wizard was fixed
Identifiers (table/column names) quote was fixed
Metadata compare error was fixed
ERD loading (contents) was fixed
MySQL/PostgreSQL/Vertica: SELECT .. LIMIT bug was fixed
Oracle: table rename fixed
Oracle: tnsnames parser was improved
Teradata: default port set
A few minor UI bugs were fixed

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

Main Program Update ( Main ):

Fix: Fixed problem when accessing unspecified Schema Foreign Keys, comprising affect many related functions (5884)
Upd: solve Teradata table fields slow access problems, can significantly improve processing speed (5884)
Upd: Cumulative contain other minor updates, fixes and optimization (5884)
Misc: Compatible with SQL Server 2016 CTP 3.3 (2016/02/01)
Misc: Compatible with MySQL 5.7.11 (2016/02/05) / MySQL 5.6.29 (2016/02/05) / MySQL 5.5.48 (2016/02/05)

Object Browser ( Object Navigator ):

Fix: Fixed (5875) PK DESC unusable when editing filtering (Filter Expression) Issues (5884)

Data definition language ( Data Definition Language (DDL) ):

Fix: Improved TRIGGER script-generated content increases GO command separator ALTER TRIGGER (5884)

Database Migration ( Database Migration ) (Pro):

Upd: Table definition preview ( SQL preview ): Improved copy processing without directly copying the whole election process (5884)

Upd: Improved automatically match the field data types ( Automatically match columns ):

Upd: Improved Unicode Char Char conversion between different combinations of matching process (5884)
Upd: automatic exclusion object database field is not supported by the primary key (PK) data type (5884)
Fix: solve the source text data types of content, if when NullChar contain characters causing the problem can not be properly handled (5884)
Fix: Fixed re-linking of different types of database update QuotedString priorities to avoid affecting the Schema switch (5884)
Upd: (ODBC) databases to increase read retry processing (5884)
Add: (ODBC / OleDB) supports short data types (Short Type Names) automatic matching process (5884)
Upd: compatible ODBC Version

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Fix infinite loops and buffer-overrun problems in regular expressions (Tom Lane)
Very large character ranges in bracket expressions could cause infinite loops in some cases, and memory overwrites in other cases. (CVE-2016-0773)
Fix an oversight that caused hash joins to miss joining to some tuples of the inner relation in rare cases (Tomas Vondra, Tom Lane)
Avoid pushdown of HAVING clauses when grouping sets are used (Andrew Gierth)
Fix deparsing of ON CONFLICT arbiter WHERE clauses (Peter Geoghegan)
Make %h and %r escapes in log_line_prefix work for messages emitted due to log_connections (Tom Lane)
Previously, %h/%r started to work just after a new session had emitted the "connection received" log message; now they work for that message too.
Avoid leaking a token handle during SSPI authentication (Christian Ullrich)
Fix psql's \det command to interpret its pattern argument the same way as other \d commands with potentially schema-qualified patterns do (Reece Hart)
In pg_ctl on Windows, check service status to decide where to send output, rather than checking if standard output is a terminal (Michael Paquier)
Fix assorted corner-case bugs in pg_dump's processing of extension member objects (Tom Lane)
Fix improper quoting of domain constraint names in pg_dump (Elvis Pranskevichus)
Make pg_dump mark a view's triggers as needing to be processed after its rule, to prevent possible failure during parallel pg_restore (Tom Lane)
Install guards in pgbench against corner-case overflow conditions during evaluation of script-specified division or modulo operators (Fabien Coelho, Michael Paquier)
Suppress useless warning message when pg_receivexlog connects to a pre-9.4 server (Marco Nenciarini)
Avoid dump/reload problems when using both plpython2 and plpython3 (Tom Lane)
In principle, both versions of PL/Python can be used in the same database, though not in the same session (because the two versions of libpython cannot safely be used concurrently). However, pg_restore and pg_upgrade both do things that can fall foul of the same-session restriction. Work around that by changing the timing of the check.
Fix PL/Python regression tests to pass with Python 3.5 (Peter Eisentraut)
Prevent certain PL/Java parameters from being set by non-superusers (Noah Misch)
This change mitigates a PL/Java security bug (CVE-2016-0766), which was fixed in PL/Java by marking these parameters as superuser-only. To fix the security hazard for sites that update PostgreSQL more frequently than PL/Java, make the core code aware of them also.
Fix ecpg-supplied header files to not contain comments continued from a preprocessor directive line onto the next line (Michael Meskes)
Such a comment is rejected by ecpg. It's not yet clear whether ecpg itself should be changed.
Fix hstore_to_json_loose()'s test for whether an hstore value can be converted to a JSON number (Tom Lane)
Previously this function could be fooled by non-alphanumeric trailing characters, leading to emitting syntactically-invalid JSON.
In contrib/postgres_fdw, fix bugs triggered by use of tableoid in data-modifying commands (Etsuro Fujita, Robert Haas)
Fix ill-advised restriction of NAMEDATALEN to be less than 256 (Robert Haas, Tom Lane)
Improve reproducibility of build output by ensuring filenames are given to the linker in a fixed order (Christoph Berg)
This avoids possible bitwise differences in the produced executable files from one build to the next.
Ensure that dynloader.h is included in the installed header files in MSVC builds (Bruce Momjian, Michael Paquier)
Update time zone data files to tzdata release 2016a for DST law changes in Cayman Islands, Metlakatla, and Trans-Baikal Territory (Zabaykalsky Krai), plus historical corrections for Pakistan.

[close]

http://www.postgresql.org/

[SiLæncer]

Changelog

SQL Editor ( SQL Editor ):

Add: Added Object inspection ( Inspect Object Ctrl + T): the name of the selected object and click on the editor, you can choose to open a browser or skip to browse the location of objects (5890)
Add: Added additional commands ( : Print 'msg_str' ): send a text message to the message page (5890)
Upd: Improved additional commands ( : r ): When the file does not exist, an error message and continue processing (5890)

Automatically and perceived ( AutoComplete and IntelliSense * ):

Upd: increase SQL keywords + newline \ recognition processing r \ n enhance the automatic processing capacity of perception (5890)

Row editing and browsing ( Data Editor and Browser ):

Add: Support the field data type display process (5890) when the text figures Object (String / Numeric) content
Add: The number of messages in the Status column supports all influence after performing display (Total number of rows affected) (5890)
Batch script generation ( Generating Batch Scripts ):

Add: Increase the separation individual statement Option (Delimit individual statements [GO]) (5890)
Upd: Improved interface designed to simplify the operation process (5890)

Object Browser ( Object Navigator ):

Fix: (Oracle) Correction (5884) PK DESC unusable when editing filtering (Filter Expression) Issues (5890)

Database Migration ( Database Migration ) (Pro):

Add: Added a custom data type corresponding to (Custom Mapping Types): convenience for the entire library of data processing using the corresponding table custom (5890)

Main Program Update ( Main ):

Fix: Browse [all] database / schema mode: Fix Cross-database / schema can not access the object is not pre-loaded questions (comprising impact related functions) (5890)
Upd: Cumulative contain other minor updates, fixes and optimization (5890)
Misc: Compatible with PostgreSQL 9.5.1 / 9.4.6 / 9.3.11 / 9.2.15 / 9.1.20 (2016/02/11)

[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 improvements in data grid.
New Encoding option for SQL Script export format.
Minor changes.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

4.5.5.0
- issue        Undefined index: is_ajax_request
- issue #11855 Fix password change on MariaDB 10.1 and newer
- issue #11874 Validate version information before further processing it
- issue #11881 Full processlist lost on refresh
- issue #11834 Adjust privileges fails if database name contains underscores
- issue #11906 'Loading...' banner shows on login screen
- issue #11930 Fixed changing of table parameters, eg. AUTO_INCREMENT
- issue #11885 Call to undefined function SqlParser\ctype_alnum()
- issue #11879 4.5.3.1 - NOW() function not recognized by parser
- issue #11867 Gracefully handle the DESC statement
- issue #11843 Fractional timestamp causes corrupted SQL export
- issue #11836 Static analysis error for valid WHERE condition with IF keyword
- issue #11800 Syntax Verifier error using REGEXP in SQL statement
- issue #11799 Backslashes in comments are being interpreted as escape characters
- issue #11909 Can't insert row into table that contains generated column
- issue #11677 sql-parser and php-gettext collide.
- issue #11920 Can't disable backquotes in export
- issue #11911 Inserts via tbl_change.php in VARBINARY columns does not allow using HEX() and MD5()
- issue #11939 Correct content type for uploaded error reports
- issue #11940 Silent errors from checking local documentation
- issue #11944 Fixed error on servers with disabled php_uname
- issue #11946 Correctly store and report file upload errors
- issue #11948 Avoid javascript errors on invalid location hash
- issue #11950 Fix PHP warning on configuration errors
- issue #11951 Silent errors on checking for writable folders
- issue #11952 Silent warning on invalid file upload
- issue #11953 Do not fail getting filename with open_basedir limitations
- issue #11956 unrecognized keyword interval
- issue        Field names and aliases are being correctly parsed now.
- issue #11959 Fix javascript error in setup
- issue #11964 Undefined index: TABLE_COMMENT in database structure page
- issue #11967 Fix PHP error on loading invalid XML or ODS file
- issue #11969 Missing confirmation while dropping a view in view_operations.php
- issue #11968 Fix export of index comments in SQL
- issue #11979 DECLARE not accepted as valid SQL

[close]

Download : Klick

http://www.phpmyadmin.net/

[SiLæncer]

Changelog

PostgreSQL: new extension was added (metadata editor, data types, sessions, inheritance, support of arrays, structures, enums, uuids, hstore, etc).
Cassandra: driver was updated to 3.0
DB2: nicknames, temp tables, execution plan
Amazon Redshift driver was added
SQL generation was fixed
Stored procedures/views save was fixed
SQL editor statement highlighting was redesigned
Data transfer fixes (binary data export)
Property viewer was fixed
UI freezes during save were fixed
A lot of minor UI fixes

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Whats new: >>

Minor bug fixes in exporting to SQL Script export format.
Minor changes in data grid.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

UI ( User Interface ):

Add: Added dark color display interface ( TreeView / SQL Editor / Query Results -> Dark Mode )
Add: increase customizations column color (User Interface -> Query Results)

Automatically and perceived ( AutoComplete and IntelliSense * ):

Add: Add to 500ms delay processing fast input has a better display at the same time [completed Mode] under a better user experience )

SQL Editor ( SQL Editor ):

Upd: quoted string [] "" `` consistent color and the default text color process (5903)

Browse row ( Data Browser ):

Add: increase Results column labels renamed processing (Renaming Results tab) (5903)

Database Migration ( Database Migration ):

Fix: Fixed some type of database table column sorting process, when more than> 10 when scheduling problem

Main Program Update ( Main ):

Upd: Cumulative contain other minor updates, fixes and optimization (5903)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

- issue #11971 CREATE UNIQUE INDEX index type is not recognized by parser.
- issue #11982 Row count wrong when grouping joined tables.
- issue #12012 Column definition with default value and comment in CREATE TABLE expoerted faulty.
- issue #12020 New statement but no delimiter and unexpected token with REPLACE.
- issue #12029 Fixed incorrect usage of SQL parser context in SQL export
- issue #12048 Fixed inclusion of gettext library from SQL parser

[close]

Download : Klick

http://www.phpmyadmin.net/

[SiLæncer]

Whats new:>>

PostgreSQL: multi-database support was fixed.
PostgreSQL: Older (

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

Database Migration ( Database Migration ) (Pro):

Upd: Update Settings command execution over (CommandTimeout 600s-> 100000s): avoid timeout problems occurs over a large number of data processing
Upd: Improved user experience: When [selected] table, if the click [Disconnect] When will ask in advance to avoid mis-hits
Fix: Fixed renamed to confirm the selection (Rename Confirmation Option) After execution, wait for the progress of the restoration of windows is not shown

Row editing and browsing ( Data Editor and Browser ):

Upd: The results are shown in the menu to change the export format manner, so that the operation more simple and intuitive (that contains the main menu and taskbar, etc. Export) (5910)
Fix: (MySQL) can not solve the second update without primary keys editing, field contains ON UPDATE CURRENT_TIMESTAMP definition (5910)

File version of SQL Control Manager ( Version Control Manager ):

Upd: Check out file (Checkout) / delete items (Delete) work with the right-column menu disable status update

Database Chart ( Database Diagram):

Upd: supports automatic scaling the initial display window, and can not be amended [Up / Down] window scaling problems

Main Program Update ( Main ):

Fix: Fixed MySQL / PostgreSQL backup and restore the designation of a non-default Port can not be processed normally
Upd: problem solving MySQL user account password if it is empty, you can not handle backup and restore functions
Upd: Cumulative contain other minor updates, fixes and optimization

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new: >>

Slovenian GUI added.
Minor changes.

http://www.vlsoftware.net/