Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Changelog

Fix a backwards compatibility problem in version 3.12.0 and 3.12.1: Columns declared as "INTEGER" PRIMARY KEY (with quotes around the datatype keyword) where not being recognized as an INTEGER PRIMARY KEY, which resulted in an incompatible database file. Ticket 7d7525cb01b68
Fix a bug (present since version 3.9.0) that can cause the DELETE operation to miss rows if PRAGMA reverse_unordered_selects is turned on. Ticket a306e56ff68b8fa5
Fix a bug in the code generator that can causes incorrect results if two or more virtual tables are joined and the virtual table used in outer loop of the join has an IN operator constraint.
Correctly interpret negative "PRAGMA cache_size" values when determining the cache size used for sorting large amounts of data.

Hashes:

SQLITE_SOURCE_ID: "2016-04-18 17:30:31 92dc59fd5ad66f646666042eb04195e3a61a9e8e"
SHA1 for sqlite3.c: de5a5898ebd3a3477d4652db143746d008b24c83

[close]

https://www.sqlite.org/

[SiLæncer]

Changelog

The primary goals for Firebird 3.0 were to unify the server architecture and to improve support for SMP and multiple-core hardware platforms. Parallel objectives were to improve threading of engine processes and the options for sharing page cache across thread and connection boundaries.

Alongside these aims came new strategies to improve performance, query optimization, monitoring and scalability and to address the demand for more security options. A number of popular features were introduced into the SQL language, including the long-awaited support for the Boolean data type and the associated logical predications.

BUGS FIXED:

Core Engine:

An assertion would occur in the cloop dispatcher when trying to save exception information in the status interface.
Failure to find a record on re-fetch would produce inconsistent effects on subsequent statement execution.
Unique key violation on a BOOLEAN column was returning an erroneous message.
HAVING COUNT(*) NOT IN ( ) would erroneously exclude a record from the outer result set. ( represents a result set without nulls)
It was possible to create a unique index on non-unique data.
Regression: the engine could throw transliteration errors when running from a non-ASCII system path.
The server could go into an infinite loop when data was being sent from a client to the server in small packets.
Regression: LEFT JOIN was incorrectly pushing COALESCE into the inner stream, causing wrong results.
CREATE TRIGGER was failing with the error "Ambiguous field name between table B and table A".
Join order was sub-optimal if one table had a selective predicate and MIN was calculated for the other one.
Deadlock could occur when a database was being encrypted or decrypted under high parallel load.
ALTER SEQUENCE RESTART WITH was failing to change the initial value.
Minor regression: wrong error message was being returned on an attempt to compile a view with both a subquery and the WITH CHECK OPTION clause in its definition—an illegal combination.
The optimizer could avoid using an expression index if the query was running in a different connection character set to the one that was in effect when the index was created.
Internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375) would occur if too many transactions were created for one connection to a read-only database. This was a very old bug, dating back to InterBase 6.

Server Crashes:

Regression: The server would crash when aggregate functions were used together with the NOT IN predicate.

Utilities:

gbak: gbak restore could fail when there was some SQL function accessing a table while the switch -O(NE_AT_A_TIME) was in use.
gfix: An attempt to set the number of page buffers to a non-supported value would return the wrong error message.
isql: An invalid COMPUTED BY definition was being generated by the 'extract metadata' operation.
Monitoring: Database-level statistics (MON$STAT_GROUP = 0) could contain multiple rows under concurrent load.
User Management: The codes of operation for user management plug-ins were missing from the public API.
User Management: Users with the same name can co-exist in the security database if they are created by different plug-ins. However, tags or attributes for a user created using one plug-in were being displayed in the SEC$ virtual tables for the same-name user created by the other plug-in.
User Management: [CREATE OR] ALTER USER statement would fail if the PASSWORD parameter was present and was not specified immediately after the USER parameter.

Builds:

The build would fail if HAVE_MMAP was not defined.
Root rights were unnecessarily required to build a Linux package.
The samples of dbcrypt-related plug-ins contained references to internal files.

[close]

http://www.firebirdsql.org/

[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 bug: On some databases/tables (like Recipient table in store.vol or tbUpdateLocalizedProps table in DataStore.edb) ESEDatabaseView omitted the first 4 characters of a string.
Added 'Select All' and 'Deselect All' buttons to the 'Choose Column' window.

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

[SiLæncer]

Changelog

DATABASE MIGRATION:

Add: Added support purposes table custom field functions ( Adding Custom Columns ) (5959)
Upd: Database for the purpose of removing unnecessary indexes Vertica function generation processing (5959)
Upd: Improved source PostgreSQL database to access the index-related issues (5959)
Upd: automatically exclude unnecessary index generation processing (5959)
Upd: join the state to change the order of the fields after reservation (5959)

EDIT INDEX:

Add: (SQL Server / SQL Azure ) support column index included (Included Columns) your build script process (5959)
Add: (SQLite / Oracle / PostgreSQL ) support expression field index (Expression Columns) display (5959)
Upd: New name field where allowable change process, to facilitate the importation expression field (Expression Columns) (5959)
Upd: Allow UNIQUE set (Firebird) when the new (5959)

DATA DEFINITION LANGUAGE:

Add: (PostgreSQL / Oracle) support expression index (Expression Indexes) script generation processing (5959)

AUTOMATICALLY AND PERCEPTION:

Upd: Improved Sub-Select field auto-sensing capability (5959)
ROW EDITING AND BROWSING:

Upd: a text browser (Text Viewer) support shortcut keys to open a hyperlink (Open Link: Ctrl + click) (5959)

THE MAIN PROGRAM UPDATE:

Fix: (Teradata) execute SQL script file ( the Execute SQL Script File AN ): Fixed CREATE PROCEDURE changed to the built-in process of implementation (5959)
Fix: (Firebird) amended CREATE UNIQUE INDEX unable to respond to the problem in some cases correct the error message (5959)
Upd: SQLite element updated to System.Data.SQLite.dll 1.0.101.0 (3.12.2) (2016/04/19) (5959)
Upd: Cumulative contain other minor updates, fixes and optimization (5959)
Misc: the with Compatible Firebird 3.0.0 the RTM (2016/04/19) (5959)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

RecordEditor is a datafile editor, similar to File-Aid or Net-Cobols Cobol-Editor. It uses a record layout to format the data in the file in to a human readable format. Because it knows the format of fields, it can format binary fields as normal numbers rather than displaying hex equivalent as most hex editors do. The file can be editted in a table (spreadsheet-like format) or in a single record format with fields going down the page.

Freeware

Release Notes

    Cleanup/enhancement of cobol-import screen.
    Added JRecord Code-Generation to the Cobol-Import.
    upgrade to latest cb2xml 0.96.6 (Cobol Copybook analysis software).

[close]

Download hier : https://sourceforge.net/projects/record-editor/files/Test/Version_0.97m/

http://record-editor.sourceforge.net/

[SiLæncer]

Changelog

Column transformers (view numbers in a specified radix, view milliseconds as dates, etc)
MongoDB: editor was fixed
MongoDB: document renderer (JSON) was improved
PostgreSQL: minor metadata fixes
MySQL: database export was fixed
Apache Phoenix driver was added
SQL editor fixes
Ignore broken JDBC drivers (MySQL, MariaDB)

[close]

http://dbeaver.jkiss.org/

[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

Whats new: >>

Added sum for the numeric columns

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

[SiLæncer]

Changelog

- issue #12120 PMA_Util not found in insert_edit.lib.php
- issue #12118 Fixed activation of some languages
- issue #12121 Fixed error in 3NF step of normalization
- issue #12135 Fix offering JSON datatype in incompatible MySQL versions
- issue #12132 Can not open table with JSON field
- issue #12125 Cannot highlight a column if I scroll down from the top of the table
- issue #12154 Fixed possible PHP error in SQL parser
- issue #12029 Fixed SQL quoting in SQL export
- issue #12129 Improve performance of database structure page
- issue #12159 Fix PHP error if user did unpack new version over old one
- issue #12165 Fix parsing of expression 0
- issue #12146 Document setup with Google Cloud SQL
- issue #12197 Fix parsing of queries with double \
- issue #12202 Fixed setting of language from user configuration
- issue #12200 Fixed check for ndb version
- issue #12206 Fixed loading of configuration file
- issue #12204 Check if sessions are working and report failures
- issue #12211 non-clickable initial letter for users / and can't modify users with MySQL 5.7.12
- issue #12215 Fixed config tab persistence errors
- issue #12217 Fixed javascript erros on user creation
- issue #12144 Fixed parsing of some AS clauses
- issue #12205 Fixed parsing of FULL OUTER JOIN queries
- issue #12171 Fixed editing of VIEW structure
- issue #12208 Avoid printing executed queries on import

[close]

Download : Klick

http://www.phpmyadmin.net/

[SiLæncer]

Changelog

MAIN PROGRAM UPDATE:

Fix: (SQLCe) Correction Pro 64bit not installed can not be opened under SQLCe runtime 4.0x64 * .sdf environmental issues repositories
Upd: Remove no longer needed [return results Export Format] setting
Upd: the main menu [Tools Menu] integrated into the taskbar, and replace the original settings and other key services
Upd: automatically excluded name length> 8 when the table (dBase) object loading
Upd: Oracle component version update to Oracle.ManagedDataAccess.dll
Upd: Cumulative contain other minor updates, fixes and optimization

DATA EXPORT:

Add: increase return results Export formats SSV (Semicolon delimited) (* .ssv ) format
Fix: Fixed When specifying export format is TSV / PSV, the settings will continue to [return results Export Format]-based error

AUTOMATICALLY AND PERCEPTION:

Upd: Improved When [fields and objects] also appear in the list, the default will be the beginning of a selected object to match the specified priority project

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

DATA EXPORT ( the Data the Export ):

Upd: rewrite Excel Workbook (* .xlsx) Export Processing
Export processing speed dramatically (5973)
Export processing can be carried out in the absence install MS Office or Access Database Engine environment (5973)
Fix: Fixed (59 ??) cause problems right

Data Export process interrupt button is not shown (5973) DATA VISUALIZATION ( the Data the Visualization ): Fix: Fixed multiple-choice questions generates an exception when switching to Kagi / PointAndFigure / Renko / ThreeLineBreak and other chart types under Y-Axis (5973) BROWSE ROW ( the Data Browser ): Upd: The results are given tag name in the underlying table name substituted (Base TableName -> Result [n ]) (5973) THE MAIN PROGRAM UPDATE ( the Main ): Fix: (Firebird 3) If you do not install the corrected version installed Guardian service will result when the connection is still not displayed FB installation problems (5973) Upd: Cumulative contain other minor updates, fixes and optimization (5973) Automatically and perception ( the AutoComplete and IntelliSense )

[close]

http://fishcodelib.com/Database.htm[/td][/tr][/table]

[SiLæncer]

Changelog

PostgreSQL: function-based indexes support
PostgreSQL: columns search added
PostgreSQL: triggers source viewer fixed
PostgreSQL: foreign key creation fixed (delete/update rules)
MySQL: database dump fixed (command line parameters)
MySQL: stored procedures editor fixed
DB2: unisuq key creation fix
ODBC driver fixed (Java 8 for Windows)
Redis: pre-alpha version of Redis extension in EE version (only for testing)
Table unique key search fixed (do not use nullable columns)
Connection properties dialog was fixed
ResultSet context menu redesigned
SQL editor context menu redesigned
CSV exporter fixed (values escape)
Project create fixed
Binary column encoding was fixed (hex format)
Sound notifications support added
Database navigator refresh error handler added
Many minor UI bugs were fixed

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

The main program update ( the Main ):

Add: Added to browse delimited text file function ( Browsing the Text Delimited Files ) Automatic Identification text file separator character (comma, tab, pipe, semicolon and custom delimiter) the file encoding
Can query SQL commands way to browse and convert other formats
Upd: Cumulative contain other minor updates, fixes and optimization
Misc: the with the PostgreSQL Compatible 9.5.3 / 9.4.8 / 9.3.13 / 9.2.17 / 9.1.22 (2016/05/12)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Postpone I/O associated with TEMP files for as long as possible, with the hope that the I/O can ultimately be avoided completely.
Merged the session extension into trunk.
Added the ".auth ON|OFF" command to the command-line shell.
Added the "--indent" option to the ".schema" and ".fullschema" commands of the command-line shell, to turn on pretty-printing.
Added the ".eqp full" option to the command-line shell, that does both EXPLAIN and EXPLAIN QUERY PLAN on each statement that is evaluated.
Improved unicode filename handling in the command-line shell on Windows.
Improved resistance against goofy query planner decisions caused by incomplete or incorrect modifications to the sqlite_stat1 table by the application.
Added the sqlite3_db_config(db,SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION) interface which allows the sqlite3_load_extension() C-API to be enabled while keeping the load_extension() SQL function disabled for security.
Change the temporary directory search algorithm on Unix to allow directories with write and execute permission, but without read permission, to serve as temporary directories. Apply this same standard to the "." fallback directory.

Bug Fixes:

Fix a problem with the multi-row one-pass DELETE optimization that was causing it to compute incorrect answers with a self-referential subquery in the WHERE clause. Fix for ticket dc6ebeda9396087
Fix a possible segfault with DELETE when table is a rowid table with an INTEGER PRIMARY KEY and the WHERE clause contains a OR and the table has one or more indexes that are able to trigger the OR optimization, but none of the indexes reference any table columns other than the INTEGER PRIMARY KEY. Ticket 16c9801ceba49.
When checking for the WHERE-clause push-down optimization, verify that all terms of the compound inner SELECT are non-aggregate, not just the last term. Fix for ticket f7f8c97e97597.
Fix a locking race condition in Windows that can occur when two or more processes attempt to recover the same hot journal at the same time.

Hashes:

SQLITE_SOURCE_ID: "2016-05-18 10:57:30 fc49f556e48970561d7ab6a2f24fdd7d9eb81ff2"
SHA1 for sqlite3.c: 9b9171b1e6ce7a980e6b714e9c0d9112657ad552

Bug fixes backported into patch release 3.12.2 (2016-04-18):

Fix a backwards compatibility problem in version 3.12.0 and 3.12.1: Columns declared as "INTEGER" PRIMARY KEY (with quotes around the datatype keyword) were not being recognized as an INTEGER PRIMARY KEY, which resulted in an incompatible database file. Ticket 7d7525cb01b68
Fix a bug (present since version 3.9.0) that can cause the DELETE operation to miss rows if PRAGMA reverse_unordered_selects is turned on. Ticket a306e56ff68b8fa5
Fix a bug in the code generator that can cause incorrect results if two or more virtual tables are joined and the virtual table used in outer loop of the join has an IN operator constraint.
Correctly interpret negative "PRAGMA cache_size" values when determining the cache size used for sorting large amounts of data.

Bug fixes backported into patch release 3.12.1 (2016-04-08):

Fix a boundary condition error introduced by version 3.12.0 that can result in a crash during heavy SAVEPOINT usage. Ticket 7f7f8026eda38.
Fix views so that they inherit column datatypes from the table that they are defined against, when possible.
Fix the query planner so that IS and IS NULL operators are able to drive an index on a LEFT OUTER JOIN.

[close]

https://www.sqlite.org/

[SiLæncer]

Whats new: >>

Added 'Align Numeric Columns To Right' option.

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

[SiLæncer]

Whats new: >>

Starts faster.

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