Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Changelog

- bug #4899 [security] CSRF vulnerability in setup

[close]

Download : Klick

http://www.phpmyadmin.net/

[SiLæncer]

Changelog

AutoComplete and perception ( AutoComplete and IntelliSense * ):

Upd: support the project list window automatically scale and optimize the display processing
Upd: increasing the mouse is moved, where the project selection process
Upd: Improved Cross-Database (Cross-database) data table field sensing process
Fix: Fixed (5609) led to the problem (SQL Server / Sybase ASE) SCHEMA repeat display
Add: item list of icons combine my favorite item display ( My favorite Objects )
Add: New Item Shortcut ( Shortcut Keys: F1 ~ F12 ): can be inserted directly specified item, eliminating selection process
Upd: exclude use shortcut keys F5 to avoid treatment effects of rapid input (5614)
Add: All servo version SCHEMA database objects are added to the display, including Procedures / Functions / Sequences / Packages / Macros (with Tables / Views)
Upd: Improved and Correction Sub-Select aware processing capacity
Fix: Fixed (5606) led to automate processing part Keywords useless

SQL editor ( SQL Editor ):

Add: Add the contents of the file attached to the statement additional commands ( Append File contents to the statement:: r )
Upd: Updated search and replace function ( Quick Find and Replace ) supports search and replace windows around the zoom function

The tying SQL statement variables ( Binding SQL variables ):

Upd: when improved when the field name of the first character of tying character, to be interpreted as tying variable processing (5614)
Column editing and browsing data ( Data Editor and Viewer ), double-click the data grid strengthening process:
Add: Information column editing mode, double-click to enter edit data grid data grid, you can open the data grid edit functions (read-only when the Cell Editor * )
Add: Information column browse mode, double-click to open data grid data grid can browse function ( Cell Viewer )

My favorite ( My Favorites ):

Upd: after the original selected display to direct all displayed (5610)
Upd: support for direct click, without having to first select after treatment

Main program update ( Main ):

Upd: after dramatically Teradata connection [object loading speed], from the 24s to the original cost can be completed in just 0.1s read (5614)
Upd: Improved handling Message dialog box (MsgBox): 1. increased replication error message handling, 2. progress dialog automatically restore the original processing, 3. 120DPI correction under Display Problems
Upd: Data Export ( Data Export ): Memory archive type (Save as type) settings, eliminating the need for the next issue of the open reselect
Upd: Accumulated other contains minor updates, corrections and optimization

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

- bug #4876 Settings issues (Favorite tables shown twice in Settings)
- bug #4896 Non-styled error page when following results link
- bug #4894 Deleting without confirmation
- bug #4858 Issues with SQL autocomplete
- bug #4897 Column hint in SQL autocomplete is sometimes not shown
- bug #4898 JS error after selecting a field and press Enter
- bug       Honor proxy settings when getting Git commit information
- bug       Missing title on link
- bug #4512 ForceSSL Redirect Check
- bug       Undefined index collation_connection
- bug       Error when the reporting server is down
- bug       Escape database and table names for partition maintenance
- bug       Invalid value for CURLOPT_SSL_VERIFYPEER
- bug #4367 Import status infinite loop
- bug #4902 Designer: Loading does not work
- bug #4904 Setup: Overview > Display does not work
- bug #4906 Designer: pages from all databases

[close]

Download : Klick

http://www.phpmyadmin.net/

[SiLæncer]

Exportizer is a free database export tool. It allows you to export data to a file, clipboard, or printer. Exportizer works via BDE or ADO. It can convert DB, DBF, text, CSV to text, CSV, XLS, RTF, XML, HTML, DBF, and INSERT statements. Many export options ensure full control over output. There is an ability to specify the source-to-target field mappings. Export operations can be performed either via the program interface or via command line with large number of parameters. You can easily generate needed command line directly from the GUI. It is possible to copy data to the clipboard or print it. There are several utility functions for data manipulating and bookmarking.

Features:

Opening tables from multi-table database files like XLS, XLSX, XLSM, XLSB, MDB, ACCDB, HTML, GDB, IB, FDB, UDL, and other multi-table databases like ODBC data sources etc.
Exporting data from all files, which are located in one folder, or all tables from a multi-table data source, at once (from interface or via command line).
Ability to specify custom increment number for Increment Field Value function.
Exporting data to Excel (XML-based) and DATABASE formats.
Using extra command line line options like /Silent, /LogFile, /CloseOnError etc.
Using extra export modes like Append and Empty+Insert.

Freeware

Whats new: >>

Minor export bugs fixed.

http://www.vlsoftware.net/

[SiLæncer]

SQLiteSpy is a fast and compact GUI database manager for SQLite. It reads SQLite 3 files and executes SQL against them. Its graphical user interface makes it very easy to explore, analyze and manipulate SQLite databases.

License:    Freeware for personal and educational use.

Whats new: >>

Update built-in DISQLite3 engine to SQLite 3.8.10.1.
Add DBSTAT virtual table.
The schema tree flags INTEGER PRIMARY KEY columns as "semi not null", using a gray check tick. This indicates that these columns do not allow certain NULL actions (i.e. UPDATE) and raise errors.

http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index

[SiLæncer]

Changelog

Informix database extension was added
Resultset scrolling UI was fixed. Auto-fetch of results next page if now configurable.
Date/time editor was redesigned + nanoseconds support added
Custom SQL delimiter support was added

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

Data Import ( Data Import ):

Add: increase the field data type detection, fully supports import processing field data type (5623)
Add: Support column of type BLOB (Byte ()) binary (0x) data import process (5623)
Add: column heading Data Type Displays ( Displaying Data Types on the column header ) (5623)

Data Export ( Data Export ):

Upd: Update export formats CSV / TSV / TXT / JSON, field data type BLOB (Byte ()) of the Data Export Processing (remove - separator character) (5623)

Data Table Editor ( Table Designer ):

Add: (Teradata) to increase the existing data table field preset value update processing (Modifying Default Value) (5623)
Fix: (Teradata) correction data table field notes the problem can not be displayed (Displaying Column Comment) (including script generation) (5623)
Upd: (Access / FoxPro) increase in data sheets and renamed when a new character-related exception processing (5623) (.)
Fix: (SQLite) Constraint Editor ( Constraint Designer ): Correction (55xx) result can not exist in the new data table processing (5623)

AutoComplete and perception ( AutoComplete and IntelliSense * ):

Add: Support for more cross-repository [data sheet] (Cross-database .) And cross structure description (Cross-schema .) Perception Processing (5623)
Add: Support (SQL Server / Sybase ASE) across databases and structure described in [data sheet] (Cross-database.schema .) Perception Processing (5623)
Fix: exclude (SQL Server / Sybase ASE) database and non-cross structure description database when current [Data Table Field] aware processing (5623)
Add: (OData) to increase data table object and code snippet automate processing (5623)
Upd: 1. Perfection (5614) related to the updating process, 2. Change the perception sheet length limit (30-> 50), 3. Improved Data Sheet multiple choice fields inserting process (5623)

The tying SQL statement variables ( Binding SQL variables ):

Add: increase the tying process variable input values, the impact included: SQL Course Record ( SQL History ), SQL Efficiency Analyzer ( SQL Profiler ) and other functions (5623)

Main program update ( Main ):

Upd: Updated field data type (Byte / SByte) related functions: support include field AutoFilter ( AutoFilter ) and Search Data Sheet Data ( Search Table Data ) and other functions (5623)
Upd: Memory data backup and restore path location of the library (support consists of Firebird / SQLite / MySQL / PostgreSQL) (5623)
Upd: 1. improvements resulting from the use of double-clicking on the click on the node, 2. Improved browse all library mode Click to expand the node Issues (5623)
Add: Support Firebird 3.0 database backup process (Backup database) (5623)
Upd: SQL Course Record ( SQL History ): 1. increased heavy brush handle the task bar, increasing the number of records displayed 2. Title (5623)
Upd: Accumulated other contains minor updates, corrections and optimization (5623)
Misc: Compatible with PostgreSQL 9.4.2 / 9.3.7 / 9.2.11 / 9.1.16 / 9.0.20 (2015/05/22)
Misc: Compatible with SQL Server 2014 SP1 / SQL Server 2014 SP1 Express and LocalDB (2015/05/14)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

- bug       Allow accessing visual query builder when pmadb is not configured
- bug #4893 Nav tree line alignment issue
- bug #4911 Lock page icon is not shown after fresh reload
- bug #4912 "Highlight pointer" and "Row marker" doesn't work properly
- bug       Browse foreigners window goes out of the window
- bug #4918 Date field popup dialog position bug
- bug       In /setup, PMA_messages is not defined
- bug #4924 Recaptcha failure
- bug #4930 Database copy doesn't work for tables with more than one FULLTEXT index
- bug #4929 Edit view structure doesn't load the algorithm

[close]

Download : Klick

http://www.phpmyadmin.net/

[SiLæncer]

Changelog

- SQL Efficiency Analyzer ( SQL Profiler ):
 Add: Support MySQL (5.6.7+) overall database analytical processing ( Global Mode ), the other an old version remains (Session Mode) (5630)
 Upd: Instant update your browser to keep the last 10 000 pen record, when exceeded will automatically delete the oldest record, to avoid affecting the performance and take up too much memory (5630)
 Upd: a lot of code optimization and improvement process in order to improve the overall efficiency and stability (5630)
- SQL Server Backup and Restore process ( Backup Manager and Restore Manager )::
 Upd: 1. path location memory processing, 2. Restore the database can handle key actuation (5630)
- Search and Replace function ( Quick Find and Replace ):
 Fix: Fixed When changing the size of the main window, you can not move with the issue (5630)
 Fix: Fixed (5614) led to replace the function of the problem can not be opened (5630)
- Object Browser ( Object Navigator ):
 Fix: When (DB2 / Informix) correction data table names are case differ, the problem can not obtain information on the table fields (including script generation) (5630)
 Upd: built-in data type VarChar dBase correct length maximum (255> 254) (5630)
 Upd: Improved use double-click on the click node problem caused when the original (5623) omission to update (5630)
- Main program update ( Main ):
 Upd: Connection Settings Properties (Connection Properties): increase set attributes Description Display (Property Desctiption) (5630)
 Upd: Question dialog box optimization process, leaving the windows did not shut down and then return, be sure to stay in the upper display (5630)
 Upd: SQLite element version update to System.Data.SQLite.dll 1.0.97.0 (3.8.10.2) (2015/05/26) (5630)
 Upd: Accumulated other contains minor updates, corrections and optimization (5630)
 Upd: Update Database .NET Additional Files (  ) (2015/05/30)
 Misc: Compatible with SQL Server 2016 CTP2 (2015/05/29)
 Misc: Compatible with MySQL 5.6.25 (2015/05/29) / MySQL 5.5.44 (2015/05/29)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

# Bugs Fixed
- InnoDB; Partitioning: The CREATE_TIME column of the INFORMATION_SCHEMA.TABLES table now shows the correct table creation time for partitioned InnoDB tables. The CREATE_TIME column of the INFORMATION_SCHEMA.PARTITIONS table now shows the correct partition creation time for a partition of partitioned InnoDB tables. The UPDATE_TIME column of the INFORMATION_SCHEMA.TABLES table now shows when a partitioned InnoDB table was last updated by an INSERT, DELETE, or UPDATE. The UPDATE_TIME column of the INFORMATION_SCHEMA.PARTITIONS table now shows when a partition of a partitioned InnoDB table was last updated.
- InnoDB: An assertion was raised on shutdown due to XA PREPARE transactions holding explicit locks
- InnoDB: The strict_* forms of innodb_checksum_algorithm settings (strict_none, strict_innodb, and strict_crc32) caused the server to halt when a non-matching checksum was encountered, even though the non-matching checksum was valid. For example, with innodb_checksum_algorithm=strict_crc32, encountering a valid innodb checksum caused the server to halt. Instead of halting the server, a message is now printed to the error log and the page is accepted as valid if it matches an innodb, crc32 or none checksum.
- InnoDB: The memcached set command permitted a negative expire time value. Expire time is stored internally as an unsigned integer. A negative value would be converted to a large number and accepted. The maximum expire time value is now restricted to INT_MAX32 to prevent negative expire time values.
- InnoDB: Removal of a foreign key object from the data dictionary cache during error handling caused the server to exit.
- InnoDB: SHOW ENGINE INNODB STATUS output showed negative reservation and signal count values due to a counter overflow error.
- InnoDB: Failure to check the status of a cursor transaction read-only option before reusing the cursor transaction for a write operation resulted in a server exit during a memcached workload.
- InnoDB: MDL locks taken by memcached clients caused a MySQL Enterprise Backup FLUSH TABLES WITH READ LOCK operation to hang.
- InnoDB: Estimates that were too low for the size of merge chunks in the result sorting algorithm caused a server exit.
- InnoDB: For full-text searches, the optimizer could choose an index that does not produce correct relevancy rankings.
- Partitioning: When creating a partitioned table, partition-level DATA DIRECTORY or INDEX DIRECTORY option values that contained an excessive number of characters were handled incorrectly.
- Partitioning: Executing an ALTER TABLE on a partitioned table on which a write lock was in effect could cause subsequent SQL statements on this table to fail.
- References: See also Bug #19856162, Bug #74451.
- Replication: When binary logging was enabled, using stored functions and triggers resulting in a long running procedure that inserted many records caused the memory use to increase rapidly. This was due to memory being allocated per variable. The fix ensures that in such a situation, memory is allocated once and the same memory is reused.
- Replication: If an error was encountered while adding a GTID to the received GTID set, the log lock was not being correctly released. This could cause a deadlock.
- Replication: A slave running MySQL 5.6.24 or earlier could not connect to a master running MySQL 5.7.6 and later that had gtid_mode=OFF_PERMISSIVE or gtid_mode=ON_PERMISSIVE. The fix ensures that a slave running MySQL 5.6.25 and later can connect to such a master as long as the slave's gtid_mode is compatible. In other words, a slave running MySQL 5.6.25 and later which has gtid_mode=OFF can connect to a master running MySQL 5.7.6 and later which has gtid_mode=OFF_PERMISSIVE, and a slave running MySQL 5.6.25 and later which has gtid_mode=ON can connect to a master running MySQL 5.7.6 and later which has gtid_mode=ON_PERMISSIVE. Other combinations are incompatible.
- Replication: If an error occurred when using a multi-threaded slave, issuing a CHANGE MASTER TO statement which resulted in an ER_MTS_CHANGE_MASTER_CANT_RUN_WITH_GAPS error, and then issuing RESET SLAVE, made it impossible to change master due to repeated ER_MTS_CHANGE_MASTER_CANT_RUN_WITH_GAPS errors. Running the debug version of mysqld caused an unexpected exit in this case. The fix ensures that the recovery process for multi-threaded slaves avoids this.
- Replication: When using semisynchronous replication performance was degrading when the number of threads increased beyond a certain threshold. To improve performance, now only the thread which is committing is responsible for deleting the active transaction node. All other operations do not touch this active transaction list.
- Replication: Using mysqlbinlog to process log events greater than 1.6GB failed with an out of memory error. This was caused by an internal error converting the length variable. The fix upgrades the length variable to avoid overflow in both encoding and decoding functions.
- Replication: When master_info_repository=TABLE the receiver thread stores received event information in a table. The memory used in the process of updating the table was not being freed correctly and this could lead to an out of memory error. The fix ensures that after an event is flushed to the relay log file by a receiver thread, the memory used is freed.
- For small values of the read_rnd_buffer_size system variable, internal caching of temporary results could fail and cause query execution failure.
- The normalize_statement() UDF used by MySQL Enterprise Firewall could cause a server exit for certain password-related statements.
- A failed FLUSH PRIVILEGES statement followed by statements to create or drop accounts could cause a server exit.
- std::stringstream code used by MySQL Enterprise Firewall could cause a server exit.
- SHOW VARIABLES mutexes were being locked twice, resulting in a server exit.
- ull2dec() was modified to avoid a problem with GCC 5 in optimized mode.
- Using GCC 5, debug builds failed due to compiler warnings.
- A Provides rule in RPM .spec files misspelled “mysql-embedded” as “mysql-emdedded”.
- The mysql_firewall_max_query_size system variable should be read only at runtime, but it was possible to modify it.
- MySQL Enterprise Firewall could leak memory in the unlikely event of failure to store information in an INFORMATION_SCHEMA table.
- Using a MySQL 5.6 version of mysqladmin to change the password for an account on a MySQL 5.7.6 installation resulted in an unusable account password.
- AddressSanitizer compilation errors were silenced.
- Under certain conditions, the libedit command-line library could write outside an array boundary and cause a client program crash.
- mysql_config_editor could exit abnormally while encrypting passwords.
- Host value matching for the grant tables could fail to use the most specific of values that contained wildcard characters.
- For MySQL distributions linked against yaSSL, a corrupt client key file could cause clients to exit.
- For join queries with a large number of tables, the server could exit converting the join to a semi-join.
- Deleting rows from mysql.user following by granting privileges to a new account could result in a server exit.
- Renaming the mysql.procs_priv table and executing SHOW GRANTS resulted in a server exit.
- Within a stored procedure, access to view columns after DDL or FLUSH TABLES statements in the procedure could cause a server exit.
- Execution of certain BINLOG statements while temporary tables were open by HANDLER statements could cause a server exit.
- For a prepared statement with an ORDER BY that refers by column number to a GROUP_CONCAT() expression that has an outer reference, repeated statement execution could cause a server exit.
- CMake configuration was adjusted to handle new warnings reported by Clang 3.5, using the -Wpointer-bool-conversion and -Wundefined-bool-conversion compiler options.
- Loading corrupt spatial data into a MyISAM table could cause the server to exit during index building.
- Specifying --general_log_file= (with an empty value) at server startup caused the server to fail and exit.
- CMake configuration was adjusted to handle warnings reported by Clang 3.3.
- Some MySQL Enterprise Firewall diagnostic messages were written outside the control of the log_error_verbosity system variable.
- The server rejected empty COM_SHUTDOWN packets.
- Inappropriate -Werror options could appear in mysql_config --cflags output.
- In the Performance Schema threads table, the PROCESSLIST_STATE and PROCESSLIST_INFO values did not change for the thread/sql/main main thread instrument as the thread state changed.
- Certain queries for the INFORMATION_SCHEMA TABLES and COLUMNS tables could lead to excessive memory use when there were large numbers of empty InnoDB tables.
- Queries that included a HAVING clause based on nondeterministic functions could produce incorrect results.
- For logging of prepared statements to the general query log, the Execute line was logged after statement execution, not before.
- MySQL failed to compile using OpenSSL 0.9.8e.

[close]

www.mysql.com

[SiLæncer]

Changelog

- bug #4920 relation view doesn't list fields of table in other database
- bug #4905 Sorting by an alias
- bug #4931 False error before entering reCAPTCHA
- bug #4909 central column with multiple server
- bug #4937 Custom export with backquotes off is not working
- bug #4908 Reverse proxy: infinite internal redirect (added warning in doc)

[close]

Download : Klick

http://www.phpmyadmin.net/

[SiLæncer]

Changelog

- Avoid failures while fsync'ing data directory during crash restart
- Fix pg_get_functiondef() to show functions' LEAKPROOF property, if set
- Fix pushJsonbValue() to unpack jbvBinary objects.This change does not affect any behavior in the core code as of 9.4, but it avoids a corner case for possible third-party callers.
- Remove configure's check prohibiting linking to a threaded libpython on OpenBSD.The failure this restriction was meant to prevent seems to not be a problem anymore on current OpenBSD versions.

[close]

www.postgresql.org

[SiLæncer]

Changelog

Now DBeaver can create separate connections for each SQL editor (configurable)
Connection invalidate improved
Plain text presentation was fixed
Date/time editor was fixed
Many minor UI bugs were fixed

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

AutoComplete and perception ( AutoComplete and IntelliSense * ):

Upd: Improved and corrected when JOIN multiple data tables, allows you to specify the data sheet (or alias) field sensing process (5638)

Auto braces complete ( Automatic Brace Completion ):

Upd: after the display at the auto-complete and has been selected projects to support first inserted automatically selected project completion process (5638)

Servo Edition database connection settings ( Connection Profile ):

Add: increase exemplified Informix database functionality built (5638)
Fix: Fixed issue new name if the connection is set with a different database of the same name, the original settings will be overwritten (5638)

SQL editor ( SQL Editor ):

Upd: SQL format plug-in command processing switch database link Edition ( SqlFormatterLibrary35 ), while addressing the needs of the environment problems in .NET 3.5 (2.0) in order to use the (5638)

Search and Replace function ( Quick Find and Replace ):

Fix: Fixed in the main window closed under scaling moves not reopen the issue (5638)

Main program update ( Main ):

Upd: (DB2 / Informix) increase DECIMAL (precision, scale) data type precision processing (including browsing the generated object code and instruction) (5638)
Upd: (DB2) updated LONG VARCHAR FOR BIT DATA data type handling (including browsing the generated object code and instruction) (5638)
Fix: (DB2) can not be made ​​to improve the built-in handle DECFLOAT data types of problems (including browsing the generated object code and instruction) (5638)
Upd: (DB2) rewrite data table field approach, while improving read speed (5638)
Upd: (SQLite) data type update Synonym (num-> numeric) (5638)
Upd: Update Browse [all] database mode ( Browsing All databases ), made ​​rootnode of treatment (5638)
Upd: Accumulated other contains minor updates, corrections and optimization (5638)
Upd: Update Database .NET Additional Files ( ) (2015/06/08)
Misc: Compatible with PostgreSQL 9.4.3 / 9.3.8 / 9.2.12 / 9.1.17 / 9.0.21 (2015/06/04)

[close]

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: >>

Fixed the 'Open Locked IE10/IE11 Database' option to work with the latest build of Windows 10/IE11.

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