Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Database .NET is a simple, uniform and intuitive database management tool for multiple databases. It makes Local and Remote database administration easier without installing anything. With it you can Create databases, Design tables, Edit data, Export data, Generate scripts and run SQL queries.

An innovative, powerful and intuitive multiple database management tool, based on .NET Framework 4.0.

Freeware





Whats new: >>

Code: [Auswählen]

Ver 10.6 (2014/02/17) Stable Version
- Object Browser ( Object Navigator ):
Add: increase VIEWS object data editing functions ( Data Editor for View Objects ) (5161)
Add: Integration of dynamic pop-up menu to the title bar ( Dynamic Context Menu [?] ): With the automatic update selected different objects pop-up menu (with the right to open) (5161)
Add: increase SQLite database VIEWS object deletion function (5161)
- Table Editor ( Table Designer ):
Add: SQLite database editing mode (Design mode), the support of Constraints Editor ( Constraint Designer ) non-native processing (5161)
Fix: fix if SQLite table exists Check Constraints, changing tables may cause problems related to (5161)
- The main program update ( Main ):
Add: Set form when adding the initial use (user interface language and portability mode is set) (5161)
Upd: (SQLite) component version updated to System.Data.SQLite.dll 1.0.91.0 (3.8.3.1) (2014/02/12) (5161)
Upd: optimization of the user interface display: a multiple icons to add and update process, two correction and improvement of several control display problems (5161).
Upd: contains many other minor fixes and updates ... etc. accumulate process optimization (5161)
- SQL editor ( SQL Editor ):
Upd: open in the current tab content without editing SQL files will be opened directly replaced, no other additional new label (5161)
Fix: search and replace function ( Quick Find and Replace ):.. 1 correction (5155) derived the problem 2 when switching to non-SQL editor to automatically close (5161)
- Command-line update (Command-line): :
Add: add a script to open the files without running the command (Open Script file without executing it (-o :)) (5161)
Upd: Open the script file handling with the right-click menu to open the location point, the editing process can be easily re-update (5161)
Upd: Correction in batch mode ( Batch mode ): different labels Close Tab / Timer / Export file settings are not reset issues (5161)

    database4.exe -?
    database4.exe "c: \ 1.mdb"
    database4.exe "c: \ 1.sdf"
    database4.exe 0 "c: \ 1.mdb"
    database4.exe 0 "c: \ 1.mdb" "c: \ 1.sql"-t: 30
    database4.exe 0 "c: \ 1.mdb" "c: \ 1.sql"-ca
    database4.exe 0 "c: \ 1.mdb" "c: \ 1.sql"-f: "c: \ export.sql"-ca
    database4.exe 0 "c: \ 1.mdb" "c: \ 1.sql"-f: "c: \ export.csv"
    database4.exe 0 "c: \ 1.mdb"-o: "c: \ 1.sql"
    database4.exe 6 codelib
    database4.exe 6 codelib "c: \ 1.sql"-ct
    database4.exe 0 "c: \ 1.mdb" "c: \ batch.lst"
    database4.exe 6 codelib "c: \ batch.lst"
        Batch mode: you can create a file 'batch.lst' that includes the following arguments:
        "C: \ 1.sql"
        "C: \ 1.sql",-t: 30
        "C: \ 1.sql",-ct
        "C: \ 1.sql",-f: "c: \ export.sql"
        -O: "c: \ 1.sql"

Support for AutoLogin (MySQL / SQL Server / SQL Azure / PostgreSQL / Oracle / IBM DB2/Informix/Sybase ASE)
Export formats:-f: "x:. \ Xxx [csv / xml / txt / xlsx / xls / sql / htm / json]"
http://fishcodelib.com/Database.htm

[SiLæncer]

Pretty Database Explorer is a useful and easy-to use application designed to explore various databases. With its intuitive interface, it will remember your queries, your scripts and created tables. You have the possibility to connect to various databases such as Firebird, Interbase, MySQL or Oracle.

Freeware

http://www.pretty-software.com/prettydbexplorer.htm

[SiLæncer]

4.1.8.0 (2014-02-22)

- bug #4276 Login loop on session expiry
- bug #4249 Incorrect number of result rows for SQL with subqueries
- bug #4275 Broken Link to php extension manual
- bug #4053 List of procedures is not displayed after executing with Enter
- bug #4081 Setup page content shifted to the right edge of its tabs
- bug #4284 Reordering a column erases comments for other columns
- bug #4286 Open "Browse" in a new tab
- bug #4287 Printview - Always one column too much
- bug #4288 Expand database (+ icon) after timeout doesn't do anything
- bug #4285 Fixed CSS for setup
- Fixed altering table to DOUBLE/FLOAT field
- bug #4292 Success message and failure message being shown together
- bug #4293 opening new tab (using selflink) for import.php based actions results in error and logout

http://www.phpmyadmin.net/

[SiLæncer]

Database .NET is a simple, uniform and intuitive database management tool for multiple databases. It makes Local and Remote database administration easier without installing anything. With it you can Create databases, Design tables, Edit data, Export data, Generate scripts and run SQL queries.

An innovative, powerful and intuitive multiple database management tool, based on .NET Framework 4.0.

Freeware



Whats new: >>

Code: [Auswählen]

The main program update ( Main ):
Add: Added support for OData v4 latest version of the file format (5173)
Add: New Connection Time Display ( Connection time: 'Days Hours:. Minutes: Seconds' ) (5173)
Upd: SQL History ( SQL History ): trading patterns shift to the writing process to improve the efficiency of batch processing (5173)
Upd: (IBM DB2/Informix) component version updated to IBM.Data.DB2.dll 9.7.4.4 (10.5.3.4) (2014/02/18) (5173)
Misc: (IBM DB2/Informix) IBM Data Server Client Packages Version 10.5 Fix Pack 3 (2014/02/18)
Misc: Compatible with PostgreSQL 9.3.3 / 9.2.7 / 9.1.12 / 9.0.16 / 8.4.20 (2014/02/20)
Upd: (PostgreSQL) components updated to version 2.1.0-rc1 Npgsql.dll ( ) (2014/02/09) (5173)
Upd: contains many other minor fixes and updates ... etc. accumulate process optimization (5173)
Row Editing ( Data Editor ):
Upd: Updated context menu: 1 increase Copy with Headers (with the browse mode), 2 update options enable the state with the selected (5173).
Fix: Correction Select the row and click Copy, the exception is causing the problem occurred (5173)
Script generation ( Data Definition Language ):
Upd: (PostgreSQL) update INDEXES script generated content that supports all attributes and conditions set (5173)
Upd: (PostgreSQL) update SEQUENCES script-generated content, and increase the CACHE attribute display (5173)
Upd: (Firebird) update INDEX script generation, support COMPUTED BY condition display (5173)
Fix: (MySQL) correction INDEX type FULLTEXT / SPATIAL script generation issues (5173)
Fix: Correction INDEX to [the primary key PK] and the database does not support script generated CLUSTERED / NONCLUSTERED when the problem (5173)
Index editing ( Index Designer ):
Add: (DB2) increase in the index Clustered cluster setup options (including the Object Browser and script generation) (5173)
Add: (Firebird) increase in the index Descending sorting setting options (5173)
Object Browser ( Object Navigator ):
Upd: (PostgreSQL) update INDEXES Object Browser, support for Expression index object type display (5173)
http://fishcodelib.com/Database.htm

[SiLæncer]

4.1.9.0
- bug #4279 CTRL + up or down moves two fields (part one)
- bug #4294 output as text radio clickable for "OpenDocument Text" export
- bug #4297 DROP DATABASE tick box in export no longer works
- bug #4291 Unable to export comments in OpenDocument text format
- bug #4299 Deletion even when the user says "No" to the confirmation message
- bug #4303 "New" link in navi panel is shown even if no privileges
- bug #4302 Some params are being omitted from microhistory
- bug #4298 Missing validation on Import CSV: "Columns enclosed with" and "Columns escaped with"
- bug #4040 Fatal error while resetting settings
- bug #4305 JS error when editing procedure from nav panel
- bug #4308 Edit routine form submitting when pressing enter
- bug #4307 Nav: "Columns" won't expand with specific schema

http://www.phpmyadmin.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: >>

- Addressed some sqlite issues related to working with date

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

[SiLæncer]

Database .NET is a simple, uniform and intuitive database management tool for multiple databases. It makes Local and Remote database administration easier without installing anything. With it you can Create databases, Design tables, Edit data, Export data, Generate scripts and run SQL queries.

An innovative, powerful and intuitive multiple database management tool, based on .NET Framework 4.0.

Freeware

Whats new: >>

Row editing and browsing ( Data Editor and Browser ):

Upd: Row Edit: Allows for the Primary Key field properties, but not change data processing IDENTITY (5191)
Upd: form editor ( Form Editor * ): optimized display, while avoiding large number of fields beyond the display screen (5191)

The main program update ( Main ):

Fix: Search table data ( Search Table Data ): Correction (5161) label when replacing an empty query processing, leading to problems of this feature can not be opened (5191)
Upd: contains many other minor fixes and updates ... etc. accumulate process optimization (5191)

Query Builder ( Query Builder * ):

Upd: selected query ( Selected Text to Query Builder ): selected automatically added to add more processing (Tables, Columns, Alias, Top, Distinct) (5191)

http://fishcodelib.com/Database.htm

[SiLæncer]

Code: [Auswählen]

# Changes
* Fix WAL replay of locking an already-updated tuple
* Restore GIN metapages unconditionally to avoid torn-page risk
* Avoid race condition in checking transaction commit status during receipt of a NOTIFY message
* Allow materialized views to be referenced in UPDATE and DELETE commands
* Allow regular-expression operators to be terminated early by query cancel requests
* Remove incorrect code that tried to allow OVERLAPS with single-element row arguments
* Avoid getting more than AccessShareLock when de-parsing a rule or view
* Improve performance of index endpoint probes during planning
* Use non-default selectivity estimates for value IN (list) and value operator ANY (array) expressions when the righthand side is a stable expression
* Remove the correct per-database statistics file during DROP DATABASE
* Fix walsender ping logic to avoid inappropriate disconnects under continuous load
* Fix walsender's failure to shut down cleanly when client is pg_receivexlog
* Check WAL level and hot standby parameters correctly when doing crash recovery that will be followed by archive recovery
* Fix test to see if hot standby connections can be allowed immediately after a crash
* Add read-only data_checksums parameter to display whether page checksums are enabled
* Prevent interrupts while reporting non-ERROR messages
* Fix memory leak in PL/Perl when returning a composite result, including multiple-OUT-parameter cases
* Fix tracking of psql script line numbers during \copy from out-of-line data
* Fix contrib/postgres_fdw to handle multiple join conditions properly
* Prevent intermittent "could not reserve shared memory region" failures on recent Windows versions
* Update time zone data files to tzdata release 2014a for DST law changes in Fiji and Turkey, plus historical changes in Israel and Ukraine.
www.postgresql.org

[SiLæncer]

4.1.11.0 (2014-03-23)
- bug #4335 reCaptcha problem (4.1.10 regression)

4.1.10.0 (2014-03-22)
- bug #4301 Grid edit: "SELECT" query is replaced by "UPDATE" query after edit
- bug #4278 reCaptcha re-login requires double effort
- bug #4324 Datepicker not showing up on insert page
- bug #3991 Problem selecting item in select boxes with the ENTER keystroke in some browsers
- bug #4323 QueryWindow ignores CodeMirror
- bug       None of the live charts shown on "Status -> Monitor" (Chrome)

http://www.phpmyadmin.net/

[SiLæncer]

Database .NET is a simple, uniform and intuitive database management tool for multiple databases. It makes Local and Remote database administration easier without installing anything. With it you can Create databases, Design tables, Edit data, Export data, Generate scripts and run SQL queries.

An innovative, powerful and intuitive multiple database management tool, based on .NET Framework 4.0.

Freeware

Whats new: >>

Row editing and browsing ( Data Editor and Browser ):

Upd: Quick Edit button ( Quick Button ): to increase the field of type BLOB (Cell Editor) display (5196)
Fix: Edit cell ( Cell Editor * ): Correction to change if changes before the original data, could lead to failure of the update problem (5196)
Fix: Data table's primary key selector ( PrimaryKey Selector ): solve the main table does not exist exception handling (5196)
Upd: Row Editor: When editing can not update and restore the default occurs, support jumped off and restore the edit column processing (Press No to exit), unable to escape avoid causing problems (5196)

Script generation ( Data Definition Language ):

Upd: (SQL Server) to update the script generated content INDEXES: Join Index Options, FileGroup, Disabled scripting message displays (5196)

The main program update ( Main ):

Upd: SQL Performance Analyzer ( SQL Profiler * ) and SQL history ( SQL History ): Selected highlights matching text after processing of all SQL rows (Highlight Search Terms) (5196)
Upd: SQL Performance Analyzer ( SQL Profiler * ) and SQL history ( SQL History ): Built-in SQL format automatically execute SQL Statements treatment (5196)
Upd: (SQLite) component version updated to System.Data.SQLite.dll 1.0.92.0 (3.8.4.1) (2014/03/19) (5196)
Upd: (PostgreSQL) component version updated to Npgsql.dll 2.1.0 (2014/03/14) (5196)
Upd: contains many other minor fixes and updates ... etc. accumulate process optimization (5196)

http://fishcodelib.com/Database.htm

[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 option to export all tables from command-line (Each table in a separated file), for example: ESEDatabaseView.exe /table "C:\temp\WebCacheV01.dat" * /scomma "C:\Temp\export\webcache_*.csv"

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

[SiLæncer]

Whats new: >>

- bug #4334 Add event : datepicker won't open
- bug #4338 Fix missing value error while executing SQL query
- TCPDF library is now optional dependency
- bug #4326 Cannot find the import plugins which start with uppercase 'I'

http://www.phpmyadmin.net/

[SiLæncer]

Code: [Auswählen]

# Functionality Added or Changed
* Incompatible Change: The AES_ENCRYPT() and AES_DECRYPT() functions now permit control of the block encryption mode and take an optional initialization vector argument:
- The new block_encryption_mode system variable controls the mode for block-based encryption algorithms. Its default value is aes-128-ecb, which signifies encryption using a key length of 128 bits and ECB mode.
- An optional init_vector argument provides an initialization vector for encryption modes that require it:
> AES_ENCRYPT(str,key_str[,init_vector])
> AES_DECRYPT(crypt_str,key_str[,init_vector])
- A random string of bytes to use for the initialization vector can be produced by calling the new RANDOM_BYTES() function.
* Incompatible Change: The deprecated ERROR_FOR_DIVISION_BY_ZERO, NO_ZERO_DATE, and NO_ZERO_IN_DATE SQL modes now do nothing. Instead, their previous effects are included in the effects of strict SQL mode (STRICT_ALL_TABLES or STRICT_TRANS_TABLES). In other words, strict mode now means the same thing as the previous meaning of strict mode plus the ERROR_FOR_DIVISION_BY_ZERO, NO_ZERO_DATE, and NO_ZERO_IN_DATE modes. This change reduces the number of SQL modes with an effect dependent on strict mode and makes them part of strict mode itself.
* InnoDB: MySQL now supports rebuilding regular and partitioned InnoDB tables using online DDL (ALGORITHM=INPLACE) for the following operations:
- OPTIMIZE TABLE
- ALTER TABLE ... FORCE
- ALTER TABLE ... ENGINE=INNODB (when run on an InnoDB table)
* On Solaris, mysql_config --libs now includes -R/path/to/library so that libraries can be found at runtime.
* mysql_install_db provides a more informative diagnostic message when required Perl modules are missing.
* The IGNORE clause for ALTER TABLE is now deprecated and will be removed in a future version of MySQL. ALTER IGNORE TABLE causes problems for replication, prevents online ALTER TABLE for unique index creation, and causes problems with foreign keys (rows removed in the parent table).
# Bugs Fixed
* Incompatible Change: Old clients (older than MySQL 5.5.7) failed to parse authentication data correctly if the server was started with the --default-authentication-plugin=sha256_password option.
* Important Change; InnoDB; Partitioning: The FLUSH TABLES statement's FOR EXPORT option is now supported for partitioned InnoDB tables.
* InnoDB: Running a SELECT on a partitioned table caused a memory access violation in memcpy().
* InnoDB: An invalid memmove in fts_query_fetch_document would cause a serious error.
* InnoDB: For full-text queries, a failure to check that num_token is less than max_proximity_item could result in an assertion.
* InnoDB: innodb_ft_result_cache_limit now has a hardcoded maximum value of 4294967295 bytes or (2**32 -1). The maximum value was previously defined as the maximum value of ulong.
* InnoDB: InnoDB would fail to restore a corrupt first page of a system tablespace data file from the doublewrite buffer, resulting in a startup failure.
* InnoDB: An UPDATE resulted in a memory access error in lock_rec_other_trx_holds_expl. The transaction list (trx_sys->rw_trx_list) was traversed without acquiring the transaction subsystem mutex (trx_sys->mutex).
* InnoDB: A regression introduced would result in a performance degradation when a compressed table does not fit into memory.
* InnoDB: The maximum value for innodb_thread_sleep_delay is now 1000000 microseconds. The previous maximum value (4294967295 microseconds on 32-bit and 18446744073709551615 microseconds on 64-bit) was unnecessarily large. Because the maximum value of innodb_thread_sleep_delay is limited by the value set for innodb_adaptive_max_sleep_delay (when set to a non-zero value), the maximum value for innodb_thread_sleep_delay is now the same as the maximum value for innodb_adaptive_max_sleep_delay.
* InnoDB: A full-text tokenizer thread would terminate with an incorrect error message.
* InnoDB: Attempting to uninstall the InnoDB memcached plugin while the InnoDB memcached plugin is still initializing would kill the InnoDB memcached daemon thread. Uninstall should wait until initialization is complete.
* InnoDB: In debug builds, creating a unique index on a binary column, with input data containing duplicate keys, would cause an assertion.
* InnoDB: The srv_monitor_thread would crash in the lock_print_info_summary() function due to a race condition between the srv_monitor_thread and purge coordinator thread.
* InnoDB: Attempting to add an invalid foreign key when foreign key checking is disabled (foreign_key_checks=0) would cause a serious error.
* InnoDB: For debug builds, the table rebuilding variant of online ALTER TABLE, when run on tables with BLOB columns, would cause an assertion in the row_log_table_apply_update function. For normal builds, a DB_PRODUCTION error would be returned.
* InnoDB: When creating a table there are a minimum of three separate inserts on the mysql.innodb_index_stats table. To improve CREATE TABLE performance, there is now a single COMMIT operation instead of one for each insert.
* InnoDB: The server would halt with an assertion in lock_rec_has_to_wait_in_queue(lock) due to a locking-related issue and a transaction being prematurely removed from trx_sys->rw_trx_set.
* InnoDB: Server shutdown would result in a hang with the following message written to the error log: “[NOTE] InnoDB: Waiting for purge thread to be suspended.”
* InnoDB: InnoDB would fail to start when innodb_data_file_path specified the data file size in kilobytes by appending K to the size value.
* InnoDB: An insert buffer merge would cause an assertion error due to incorrectly handled ownership information for externally stored BLOBs.
* InnoDB: Assertion failure in thread thread_num in file ibuf0ibuf.cc line 4080
* InnoDB: Failing assertion: rec_get_deleted_flag(rec, page_is_comp(page))
* InnoDB: Decreasing the auto_increment_increment value would have no affect on the next auto-increment value.
* Partitioning: When the index_merge_intersection flag (enabled by default) or the index_merge_union flag was enabled by the setting of the optimizer_switch system variable, queries returned incorrect results when executed against partitoned tables that used the MyISAM storage engine, as well as partitioned InnoDB tables that lacked a primary key.
* Replication: The MASTER_SSL_CRL and MASTER_SSL_CRLPATH options are not available when using yaSSL; MySQL Replication now sets these to NULL automatically whenever yaSSL is enabled.
* Replication: Setting --slave-parallel-workers to 1 or greater and starting the slave caused the slave SQL thread to use but not release memory until the slave was restarted with STOP SLAVE and START SLAVE.
* Replication: When a slave was configured with replication filters and --log-warnings=2, every statement which was filtered caused an entry to be written in the error log. For busy servers which generated many statements to be filtered, the result was that the error log could quickly grow to many gigabytes in size. Now a throttle is used for such errors, so that an error message is printed only once in a given interval, saying that this particular error occurred a specific number of times during that interval.
* Replication: SHOW SLAVE STATUS used incorrect values when reporting MASTER_SSL_CRL and MASTER_SSL_CRLPATH.
* Replication: Binary log events could be sent to slaves before they were flushed to disk on the master, even when sync_binlog was set to 1. This could lead to either of those of the following two issues when the master was restarted following a crash of the operating system:
- Replication cannot continue because one or more slaves are requesting replicate events that do not exist on the master.
- Data exists on one or more slaves, but not on the master.
* Replication: When running the slave with --slave-parallel-workers at 1 or greater, setting --slave-skip-errors=all caused the error log to be filled with with instances of the warning Slave SQL: Could not execute Query event. Detailed error: ;, Error_code: 0.
* Replication: A number of possible state messages used as values for the PROCESSLIST_STATE column of the Performance Schema threads table were longer than the width of the column (64 characters).
* Replication: The server did not handle correctly the insertion of a row larger than 4 GB when using row-based replication.
* Replication: When using row-based replication, an additional auto-increment column on the slave version of a table was not updated correctly; a zero was inserted instead.
* Replication: Statements involving the Performance Schema tables should not be written to the binary log, because the content of these tables is applicable only to a given MySQL Server instance, and may differ greatly between different servers in a replication topology. The database administrator should be able to configure (INSERT, UPDATE, or DELETE) or flush (TRUNCATE TABLE) performance schema tables on a single server without affecting others. However, when replicating from a MySQL 5.5 master to a MySQL 5.5 or later slave, warnings about unsafe statements updating Performance Schema tables were elevated to errors. For MySQL 5.6 and later slaves, this prevented the simultaneous use of performance_schema and GTIDs
* Replication: Modifying large amounts of data within a transaction can cause the creation of temporary files. Such files are created when the size of the data modified exceeds the size of the binary log cache (max_binlog_cache_size). Previously, such files persisted until the client connection was closed, which could allow them to grow until they exhausted all available disk space in tmpdir. To prevent this from occurring, the size of a temporary file created in this way in a given transaction is now reset to 0 when the transaction is committed or rolled back.
* Replication: The server checks to determine whether semisynchronous replication has been enabled without a lock, and if this is the case, it takes the lock and checks again. If semisynchronous replication was disabled after the first but prior to the second one, this could cause the server to fail.
* Replication: Semisynchronous replication became very slow if there were many dump threads (such as from mysqlbinlog or slave I/O connections) working at the same time. It was also found that semisynchronous master plugin functions were called even when the dump connections did not support semisynchronous replication, which led to locking of the plugin lock as well as wasting time on necessary code.
* After this fix, non-semisynchronous dump threads no longer call semisynchronous master functions to observe binary events.
* mysql_install_db could hang while reading /dev/random to generate a random root password.
* Compilation failed if MySQL was configured with CFLAGS set to include a -Werror option with an argument.
* A shared libmysqld embedded server library was not built on Linux.
* While printing the server version, the mysql client did not check for buffer overflow in a string variable.
* Building MySQL from source on Windows using Visual Studio 2008 would fail with an identifier not found error due to a regression
* On Microsoft Windows, the rw-lock backup implementation for the my_atomic_* functions was always used. Now, the native Microsoft Windows implementation is used, where available.
* When tables are reopened from the table cache and the current thread is not instrumented for the Performance Schema, a table handle was unnecessarily instrumented.
* The audit log plugin could cause a server exit during log file rotation operations when there were many operations happening for multiple connections.
* The SUM_SORT_MERGE_PASSES column value in the Performance Schema events_statements_summary_by_digest table was calculated incorrectly.
* If the Performance Schema events_statements_summary_by_digest table was full when a statement with a new digest was found, the Performance_schema_digest_lost status variable was not incremented.
* The optimizer could push down a condition when the index did not have the key part present in the condition.
* Contraction information in a collation could be mishandled, resulting in incorrect decisions about whether a character is part of a contraction, and miscalculation of contraction weights.
* DROP TRIGGER succeeded even with the read_only system variable enabled.
* If used to process a prepared CALL statement for a stored procedure with OUT or INOUT parameters, mysql_stmt_store_result() did not properly set the flags required to retrieve all the result sets.
* When run by root, mysqld --help --verbose exited with a nonzero error code after displaying the help message.
* MySQL client programs from a Community Edition distribution could not connect using SSL to a MySQL server from an Enterprise Edition. This was due to a difference in certificate handling by yaSSL and OpenSSL (used for Community and Enterprise, respectively). OpenSSL expected a blank certificate to be sent when not all of the --ssl-ca, --ssl-cert, and --ssl-key options were specified, and yaSSL did not do so. To resolve this, yaSSL has been modified to send a blank certificate when an option is missing.
* The mysqladmin, mysqlbinlog, mysqlcheck, mysqldump, mysqlimport, mysqlslap, and mysqlshow programs now support a --secure-auth option that prevents sending passwords to the server in old (pre-4.1) format. This option is enabled by default; use --skip-secure-auth to disable it.
* A deadlock error occurring during subquery execution could cause an assertion to be raised.
* The Performance Schema stage/sql/Waiting to get readlock instrument is no longer used and has been removed.
* A query that creates a temporary table to find distinct values and has a constant value in the projected list could produce incorrect results.
* Messages written by the server to the error log for LDML collation definition problems were missing the collation name.
* mysqlcheck did not correctly handle table names containing dots.
* Aggregating the results of a subquery in the FROM clause could produce incorrect results.
* For system variables that take a string value, SET statements permitted an unquoted value, but values that contained dots were parsed incorrectly and only part of the value was assigned. For example, SET GLOBAL slow_query_log_file = my_slow.log assigned the value my_slow. Now such values must be quoted or an error occurs.
* A temporal literal string without delimiters and more than 14 digits was validated as a TIMESTAMP/DATETIME value with a two-digit precision fractional seconds part. But fractional seconds should always be separated from other parts of a time by a decimal point.
* The msql2mysql, mysql_convert_table_format, mysql_find_rows, mysql_fix_extensions, mysql_setpermission, and mysqlaccess utilities are now deprecated and will be removed in MySQL 5.7.
www.mysql.com

[SiLæncer]

Database .NET is a simple, uniform and intuitive database management tool for multiple databases. It makes Local and Remote database administration easier without installing anything. With it you can Create databases, Design tables, Edit data, Export data, Generate scripts and run SQL queries.

An innovative, powerful and intuitive multiple database management tool, based on .NET Framework 4.0.

Freeware

Whats new: >>

Code: [Auswählen]

Ver 10.9 (2014/03/31) Stable Version
- Object Browser ( Object Navigator ):
Add: full support for all database objects renamed processing (Rename All Objects): (5203)
(SQL Server / SQL Azure) Table / Column / Index / View / Procedure / Function / Sequence and other objects
(PostgreSQL) Table / Column / Index / View / MView / Function / Sequence and other objects
(Sybase ASE) Table / Column / Index / View / Procedure / Function and other objects
(Oracle / MySQL / IBM DB2) Table / Column / Index and other objects
(IBM Informix) Table / Column / Index / Sequence and other objects
(SQLite / SQLCe / Access) Table / Column and other objects
(Firebird / FoxPro) Column object
Fix: amendments delete the object, it will lead to the problem of losing the role of the tab if the current tab to edit the row or rows when searching (5203)
Add: (Access) to increase the stored procedure parameter display (Procedure Parameters) and execute (EXECUTE) script update (5203)
Fix: (SybaseASE) update SYSTABLES Object Browser, exclude unwanted objects display issues (5203)
- Index editing ( Index Designer ):
Add: support for editing FoxPro index ( INDEX ON ) (including script generation and object deletion process) (5203)
- Table Editor ( Table Designer ):
Problem (SQLCe) If a table field contains IDENTITY, can not handle [Field renamed] of (> 3.1) (5203): Upd
- SQL editor ( SQL Editor ):
Upd: Updated tags off sequence: where will return to the previous label off, rather than the first tab position (5203)
- Command-line update (Command-line):
Upd: Export Format For Data (INSERTs) when sql, export options will adopt the default processing is no longer displayed (5203).
- The main program update ( Main ):
Upd: (SQLCe / Sybase ASE) all add prefix N Unicode text handling (with SQL Server / SQL Azure) (5203)
Upd: (PostgreSQL) component version updated to Npgsql.dll 2.1.2 (2014/03/28) (5203)
Upd: contains many other minor fixes and updates ... etc. accumulate process optimization (5203)
Misc: Compatible with MySQL 5.6.17 (2014/03/27) / MySQL 5.5.37 (2014/03/27) / MySQL 5.1.73 (2013/12/03)
Misc: Compatible with SQL Server 2014 RTM (2014/04/01)
http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new: >>

Code: [Auswählen]

- The main program update ( Main ):
Add: Added execute SQL script file ( Execute an SQL script File ): can execute SQL commands in a batch transaction mode, fast, low resources, can be rolled back for a lot of processing (5213)
Add: (PostgreSQL) increase JSON data type data type associated processing (5213)
Upd: SQL History ( SQL History ): In addition to automatically clear beyond> 30 days old records, an additional clear beyond> 100000 Pen previous record deal (5213)
Upd: improvements will retain the newly opened window (New Window) the current (latest) is set, no reloads (5213)
Upd: Updated Italian interface language Italian language (by Paolo Saudin) (5213)
Upd: (PostgreSQL) component version updated to Npgsql.dll 2.1.3 (2014/04/10) (5213)
Upd: contains many other minor fixes and updates ... etc. accumulate process optimization (5213)
Misc: Compatible with Microsoft Windows 8.1 Update (KB2919355) (2014/04/07)
Misc: Compatible with SQL Server 2014 RTM (2014/04/01) / SQL Server 2014 Express and LocalDB (2014/03/25)
- Auto-sensing processing ( AutoComplete * ):
Upd: improvement and optimization fields (COLUMNS) with a table (TABLES) perceptual processing (5213)
Upd: support sub-queries in different locations (Sub-SELECT) field perception and table recognition processing (5213)
Upd: When (PostgreSQL) when the object name contains uppercase characters (Upper Case) automatically quotes identifiers (Quoted Identifiers) (5213)
- Row editing and browsing ( Data Editor and Browser ):
Upd: (MySQL) increased exception handling character (Escape character: \) (contains the table data search and Export) (5213)
- SQL editor ( SQL Editor ):
Fix: When contains Unicode characters to solve problems affecting the horizontal scroll bar (Horizontal Scrollbar) treatment (5213)
Upd: SQL execution history ( SQL Execution History ): 1000 pen to keep the last record, it will automatically remove the old record of more than (5213)
- Query Builder ( Query Builder * ):
Upd: treatment (improvement and optimization of the selected query Selected Text to Query Builder ) (5213)

http://fishcodelib.com/Database.htm