Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Changelog

Fixed the per-server theme feature
Fixed several compatibility issues with PHP 7.2
Fixed copy results to clipboard
Improved error handling on corrupted tables

[close]

https://www.phpmyadmin.net/

[SiLæncer]

Changelog

Fix a potential memory leak in the new sqlite3_result_pointer() interface.

Changes carried forward from version 3.20.0 (2017-08-01):

Update the text of error messages returned by sqlite3_errmsg() for some error codes.
Add new pointer passing interfaces.
Backwards-incompatible changes to some extensions in order to take advantage of the improved security offered by the new pointer passing interfaces: a. Extending FTS5 → requires sqlite3_bind_pointer() to find the fts5_api pointer.
carray(PTR,N) → requires sqlite3_bind_pointer() to set the PTR parameter.
remember(V,PTR) → requires sqlite3_bind_pointer() to set the PTR parameter.
Added the SQLITE_STMT virtual table extension.
Added the COMPLETION extension - designed to suggest tab-completions for interactive user interfaces. This is a work in progress. Expect further enhancements in future releases.
Added the UNION virtual table extension.
The built-in date and time functions have been enhanced so that they can be used in CHECK constraints, in indexes on expressions, and in the WHERE clauses of partial indexes, provided that they do not use the 'now', 'localtime', or 'utc' keywords. Futher information.
Added the sqlite3_prepare_v3() and sqlite3_prepare16_v3() interfaces with the extra "prepFlags" parameters.
Provide the SQLITE_PREPARE_PERSISTENT flag for sqlite3_prepare_v3() and use it to limit lookaside memory misuse by FTS3, FTS5, and the R-Tree extension.
Added the PRAGMA secure_delete=FAST command. When secure_delete is set to FAST, old content is overwritten with zeros as long as that does not increase the amount of I/O. Deleted content might still persist on the free-page list but will be purged from all b-tree pages.
Enhancements to the command-line shell: a. Add support for tab-completion using the COMPLETION extension, for both readline and linenoise.
Add the ".cd" command.
Enhance the ".schema" command to show the schema of all attached databases.
Enhance ".tables" so that it shows the schema names for all attached if the name is anything other than "main".
The ".import" command ignores an initial UTF-8 BOM.
Added the "--newlines" option to the ".dump" command to cause U+000a and U+000d characters to be output literally rather than escaped using the replace() function.
Query planner enhancements: a. When generating individual loops for each ORed term of an OR scan, move any constant WHERE expressions outside of the loop, as is done for top-level loops.
The query planner examines the values of bound parameters to help determine if a partial index is usable.
When deciding between two plans with the same estimated cost, bias the selection toward the one that does not use the sorter.
Evaluate WHERE clause constraints involving correlated subqueries last, in the hope that they never have be evaluated at all.
Do not use the flattening optimization for a sub-query on the RHS of a LEFT JOIN if that subquery reads data from a virtual table as doing so prevents the query planner from creating automatic indexes on the results of the sub-query, which can slow down the query.
Add SQLITE_STMTSTATUS_REPREPARE, SQLITE_STMTSTATUS_RUN, and SQLITE_STMTSTATUS_MEMUSED options for the sqlite3_stmt_status() interface.
Provide PRAGMA functions for PRAGMA integrity_check, PRAGMA quick_check, and PRAGMA foreign_key_check.
Add the -withoutnulls option to the TCL interface eval method.
Enhance the sqlite3_analyzer.exe utility program so that it shows the number of bytes of metadata on btree pages.
The SQLITE_DBCONFIG_ENABLE_QPSG run-time option and the SQLITE_ENABLE_QPSG compile-time option enable the query planner stability guarantee. See also ticket 892fc34f173e99d8
Miscellaneous optimizations result in a 2% reduction in CPU cycles used.

Bug Fixes:

Fix the behavior of sqlite3_column_name() for queries that use the flattening optimization so that the result is consistent with other queries that do not use that optimization, and with PostgreSQL, MySQL, and SQLServer. Ticket de3403bf5ae.
Fix the query planner so that it knows not to use automatic indexes on the right table of LEFT JOIN if the WHERE clause uses the IS operator. Fix for ce68383bf6aba.
Ensure that the query planner knows that any column of a flattened LEFT JOIN can be NULL even if that column is labeled with "NOT NULL".
Fix rare false-positives in PRAGMA integrity_check when run on a database connection with attached databases. Ticket a4e06e75a9ab61a12
Fix a bug (discovered by OSSFuzz) that causes an assertion fault if certain dodgy CREATE TABLE declarations are used. Ticket bc115541132dad136

[close]

https://www.sqlite.org/

[SiLæncer]

Changelog

SQL editor:
Add: search and replace support for multi-file processing ( Finding and Replacing Multiple Documents ) (6448)
Add: search and replace the dialog box to join the shortcut key processing ( Shortcut Keys ): (6448)
Replace Next Alt + R , Replace All Alt + A , Match case Alt + C , Match whole word Alt + W , Regular Expressions Alt + E
Main program update:
Upd: (PostgreSQL) The original switch library function to the database tool (DB Tools-> Specify a database) (6448)
Upd: (Oracle) Update TIMESTAMP WITH [LOCAL] TIME ZONE Data Type Default Max (6448)
Upd: (OleDB / ODBC) Add DECIMAL / NUMERIC (precision, scale) Accuracy display (including data table editing and script generation) (6448)
Fix: (NuoDB) Fix and update INTEGER / DECIMAL / CLOB data type and precision display (including data table editing and script generation) (6448)
Upd: Improved Data Table Field Data Type Length (n) Resolution Capability (Impact Contains Multiple Functions) (6448)
Upd: Improved Table Fields Automatically Add Custom Type Processing (6448)
Fix: Data Statistics Update: Removes unsupported library options (6448)
Upd: Other Include Cumulative Small Update, Fix and Optimize (6448)
Data Editor and Browser :
Upd: (Oracle) Support TIMESTAMP WITH TIME ZONE Display and Edit Processing (6448)
Upd: (PostgreSQL) support TIMESTAMPTZ display and edit processing (6448)
Support for databases containing Oracle / PostgreSQL / SQL Server / VistaDB / Teradata / Vertica (including export processing)
Data Export :
Upd: (Oracle) support TIMESTAMP WITH TIME ZONE format export processing (6448)
Upd: (PostgreSQL) support TIMESTAMPTZ format export processing (6448)
Fix: (Oracle) Export Format INSERT statement (* .sql): Fixed BEGIN ... END; The last INSERT unfinished character (6448)
Table Designer :
Fix: (Firebird 3+) Fix Table Fields NULL / NOT NULL Update Processing (6448)
Database Migration (Pro):
Upd: All updates with dbMigration .NET Software (6448)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Search Objects :
Add: Support Content Search ( Search DDL (Data Definition Language) ( Pro ) (6456)
Support includes tables / indexes / triggers / views / procedures / functions / serial / packages / macros / synonyms ... etc etc etc.
Add: Right-click menu item Add sub-option Search all items [ALL] Processing (6456)
Upd: [Browse all database schemas] Change to search for [current Schema] Specifies that the object is no longer all (6456)
Upd: Improved Sub-Objects Search Processing: Contains all library object types (6456)
DateTime Picker :
Add: support time zone ( TimeZone ) automatic conversion processing (6456)
Security Manager :
Add: (Firebird 4+) support System privileges for Roles role system settings (6456)
SQL Profiler :
Add: (Firebird 3+) support 2.5, 3.x and 4.x Global Mode profiling (6456)
Inspect Object :
Add: Add Quick Filter objects (6456)
Data Editor and Browser :
Upd: Optimize the width of the field automatically adjust the processing (for different data types and data formatting ...) (6456)
Main program:
Upd: Improved [Library Object Search Window] and [Database Chart Window] (6456) after [Interrupted Connection] or [Switch between different Schema]
Fix: Clear Quick Filter : Fixes problems that can not be displayed in many states (6456)
Fix: resolving some of the data types with length may affect some of the functional judgment problems (6456)
Upd: Firebird Component Version Update to FirebirdSql.Data.FirebirdClient.dll 5.11.0.0 (2017/08/30) (6456)
Upd: Other Include Cumulative Minor Update, Fix and Optimize (6456)
Misc: Compatible with Compatible with PostgreSQL 9.6.5 / 9.5.9 / 9.4.14 / 9.3.19 / 9.2.23 (2017/08/31)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Sample database was added (SQLite)
New connection create fix (ordering in DB navigator)
Results viewer: local ordering fix (show confirmation about data loss)
Results viewer: copy column names/row numbers configuration dialog
ERD: bring to front and send to back actions
ERD: custom diagram coloring
ERD: diagram export fix (NPE)
ERD: SVG format export (optional extension)
MySQL: SOURCE keyword handler was fixed
MySQL: local client install detection was fixed
PostgreSQL: XML value edit fix
PostgreSQL: default tablespace info
Generic driver: foreign keys loading fix
Redshift: driver version update

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

- Code Manager :

Add: support multi-line search processing (6433)
Add: support result highlighting (6463)
Upd: Support Search Process Interrupt Processing (6463)

- Main program:

Add: add GetColumns alternative processing (support for all database types), when the built-in can not get the data table field automatically switch processing (6463)
Resolve the problem when Excel can not get fields when the table name contains - characters
Fix: (MySQL 5.x) down compatible lower database version update processing:
Upd: (MySQL 5.5.3+) Increased version detection when PROCEDURE AND FUNCTION PARAMETERS is accessed to avoid invalid handling (6463)
Fix: Security Manager : Fixed an issue where older versions (<5.5) were not working properly (6463)
Fix: Fixed an issue where the older version (<5.0.?) Could not normally generate object definition content (DDL) (including TABLES / VIEWS / PROCRDURES / FUNCTIONS) (6463)
Fix: Fix older version (<5.1.21) Problems with object definition content (DDL) that can not be generated properly (including TRIGGERS) (6463)
Fix: Process List : Fixed an issue where the older version (<5.0.?) Could not display the contents of the field (6463)
Upd: Other Include Cumulative Minor Update, Fix and Optimize (6463)
Misc: Compatible with Compatible with NuoDB 3.0 (2017/09)

- Generating Scripts :

Fix: Keep the data type case different display (including data table update and script generation) (6463)
Fix: (Firebird) Fixed DOMAIN data type generation processing (including data table update and script generation) (6463)
Upd: (Firebird) update DOMAIN script generation: increase SEGMENT SIZE, CHARACTER SET, COLLATE and other property display (6463)
Fix: (Firebird) Fix INDEX script generation: Fix the problem of generating Indexing on expressions (6463)
Fix: (SQLite) fixes CHECK constraints parsing processing (including table updates and script generation) (6463)

- Database Migration (Pro):

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

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Main program:

Add: add 64-bit professional version ( Database .NET Standard x64 (w / o Data Migration) ) (6467)
Provide another option for 64-bit and professional users who have all the features but do not need a database conversion feature
Upd: Improved click (+/-) issues associated with double-clicking expand / collapse nodes (6467)
Upd: Optimize ListView Control Display Efficiency, Avoid Unnecessary Heavy Brush Display Processing (6467)
Upd: Other Include Cumulative Small Update, Fix and Optimize (6467)

SQL editor:

Upd: Support Messages Tab Font Size Update (inherited from Text Results) (6467)

Data Browser :

Upd: field [text] data type increase length display (Column Size) (same editor) (6467)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

SQL editor: FK navigation was improved (open reference in new tab)
SQL editor: code folding was added
SQL editor: morph delimited text feature
SQL editor: SQL formatting was fixed (Oracle)
SQL editor: autocompletion was fixed (databases without schemas)
ERD: diagram rendering/nodes selection was fixed
ERD: export to SVG format was fixed
XML editor: code folding was added
Results viewer: CLOB reading was improved
Results viewer: connection name in status bar (optional)
Results viewer: copy column names action was fixed
Results viewer: complex types (structs, arrays, objects) rendering is now configurable
Data edit: big decimal values binding was fixed
Metadata editor: remember editor tab sizes
Database navigator: double-click behavior is now configurable (expand by default)
Database navigator: column data types are visible in tree (optional)
Bootstrap queries can use local variables
Connections config file loading was fixed (make force refresh)
Error handling: extract SQL error chain on client-side
MySQL: DDL read was fixed (non-English identifiers/comments)
MySQL: default driver version was changed to 5.1.44
PostgreSQL: database create/drop support was added
PostgreSQL: LIMIT/OFFSET support (for big tables export)
PostgreSQL: default generic driver version was changed to 9.4.1212
PostgreSQL: block statements processing was fixed
FireBird: domain types support (read-only)
SQLite: full table DDL (with indexes) support
Hive: query limits config was changed
Number of minor UI fixes

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

Eclipse Oxygen (E4.7) is now default base platform. A lot of minor improvements/fixes comes along with it
Chinese, Russian, German localizations are back in beta test
Results viewer: UUID value transformer (from binary) was added
Results viewer: multi-cell paste support was added
Results viewer: aggregate functions for char/varchar columns
Results viewer: filter editor dialog UI was fixed
Connection invalidate timeout was added
Workspace preference page was added in standalone version
Database navigator refresh performance was fixed
Extra command line parameters support (-closeTabs, -disconnectAll)
SQL Editor: delimiters parser was fixed ($$ delimiters)
SQL Editor: unsafe queries (DELETE/UPDATE without WHERE) warning was added
SQL Editor: server-side ouput reading was redesigned (output for scripts was fixed)
SQL Editor: SQL completion preference page was fixed (global search)
SQL Editor: SQL completion for unicode identifiers was fixed
SQL Editor: parameters binding (NULL value) was fixed
SQL Editor: status message update was fixed
ER diagrams: column comments now can be enabled on diagram
ER diagrams: dark theme support was fixed (css)
Object filters was fixed (asterisk in schema names)
Oracle: zero scale for numeric data types
Oracle: REF CURSOR read was fixed (in value view dialog)
PostgreSQL: big table data export was fixed (memory consumption)
PostgreSQL: table indexes DDL was fixed (read from server)
PostgreSQL: sequences were excluded from table list
PostgreSQL: NULL array elements reading was fixed
Firebird: column charsets, binary columns support was added
PrestoDB driver config was added
UI freeze on transactions isolation level detect was fix

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

- Main program:

Add: add or hide left panel Shortcut Keys : (Show or hide the left panel: F12 ) (6488)
Upd: HP Vertica Component Version Update to Vertica.Data.dll 8.1.1.6 (2017/09/27) (6488)
Upd: Other Include Cumulative Small Update, Fix and Optimize (6488)
Upd: Update Database .NET Additional Files ( 32bit / 64bit ) (2017/10/03)
Misc: Compatible with Compatible with PostgreSQL 10 RTM (2017/10/05)
Misc: Compatible with Compatible with SQL Server 2017 RTM (2017/10/02)

- Object Navigator :

Add: (Access) Support System Table Display (6488)

- SQL history:

Updating SQL statements such as INSERT / DELETE / UPDATE SQL performance analyzer (including SQL Profiler 's LOG mode) (6488)

- Data Editor and Browser :

Fix: (PostgreSQL / Oracle) Fixed (6448) caused TIMESTAMPTZ field type, when the data is NULL can not handle the problem (6488)

- Data Browser :

Upd: Update (6467) Field [Text] Data Type Increment Length Display (Column Size) (same as editing) (6488)

- AutoComplete and IntelliSense :

Upd: Optimize SUB-SELECT Sensing Resolution (6488)

- Database Migration (Pro):

Fix: (64bit) Fixed when the main program is minimized when the progress window shows the problem (6488)
Upd: All updates with dbMigration .NET Software (6488)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Java 9 support was fixed
SQL Editor: connection/schema selectors redesign
SQL Editor: divider position save
SQL Editor: BOM for external SQL files support was added
SQL Editor: queries folding was fixed
SQL error chain evaluation was fixed
SQL autocomplete for quoted and/or national identifiers was fixed
Results viewer: cursor reposition on refresh/mode change was fixed
Results viewer: reset all colorings action was added
Results viewer: reflect data changes in transaction monitor
Results viewer: right-aligned cells (numbers/dates) rendering was fixed
Results viewer: columns drag-n-drop was redesigned (now activated on column icon dragging)
Results viewer: multi-cell paste support was added
SQL Editor/results viewer: SELECT COUNT query transformation was fixed (omit order)
Dark theme support was improved
Support of null scale/precision for numeric data types was added
SQL generator: IS NULL/IS NOT NULL support was added
SQL generator: omit schema name feature (configurable)
Object editor: changes save procedure was fixed (+UI fix)
Office (XLSX) export: numeric/boolean cells formatting was fixed
Global schema/tables filters were fixed (MySQL/PostgreSQL)
Connections copy/paste was fixed
MySQL/MariaDB tables read was fixed (quoted identifiers)
Vertica: JDBC URL was fixed (database is optional)
Vertica: current schema detection/update
PostgreSQL: advanced data types (postgis, json, etc) resolution fix
PostgreSQL: procedures fully qualified names fix
DB2: primary key drop/edit fix
Oracle: synonyms read was fixed
Oracle: primary key drop/edit fix
SQL Server: GO delimiters evaluation was fixed
Minor UI fixes

[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 [SKIP] to the import wizard.

http://www.pretty-software.com/prettydbexplorer.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: >>

    Interface improvements.
    Minor bugfixes.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

Main program:

Add: (64bit) Added support for the dBase IV / 5.0 (* .dbf) database (6505)
Upd: Improvements When the login user has no SELECT privilege or can not load Data Types, you can choose to disconnect or continue to connect (6505)
Upd: SQLite component version update to System.Data.SQLite.DLL 1.0.106.0 (3.21.0) (2017/10/17) (6505)
Upd: HP Vertica Component Version Update to Vertica.Data.dll 9.0.0.0 (2017/10/16) (6505)
Updger: IBM DB2 / Informix component version update to IBM.Data.DB2.dll 9.7.4.4 (11.1.2021) (2017/10/10) (6505)
Misc: (IBM DB2 / Informix) IBM Data Server Client Packages 11.1 Fix Pack 2a (2017/10/10)
Upd: EPPlus Component Version Update to EPPlus.dll 4.1.1 (2017/10/08) (6505)
Upd: Other Include Cumulative Small Update, Fix and Optimize (6505)
Misc: Compatible with Compatible with MySQL 5.7.20 (2017/10) / MySQL 5.6.38 (2017/10) / MySQL 5.5.58 (2017/10)
Misc: Compatible with Compatible with Microsoft Windows 10 (1709) ( )

SQL Profiler:

Add: (Vertica) Added support for Vertica 7.x older versions (6505)

Connection Manager:

Fix: (dBase) Fixed list field does not fully display the specified path (6505)

AutoComplete and IntelliSense:

Add: Add Quoted Identifiers (6505) Enable Quoted Identifiers (6505)
Upd: Improved User Experience: Re-Remove Shortcut F5 Insert Project Processing (6505)
Upd: Optimize Field Perceptions (6505)

Data Viewer:

Upd: Browse Schema Original XML / JSON AutoFormat to manual formatting (6505)

Database Migration (Pro):

Add: (64bit) Added support for the dBase IV / 5.0 (* .dbf) database (6505)
Fix: (64bit) Fixed when the problem did not get the focus of the display (6505)
Upd: All updates with dbMigration .NET Software (6505)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Fixed JavaScript error in server monitor
Reload JavaScript translations when changing language
Fixed error when browsing non-SELECT results
Fixed export of table with VIRTUAL columns
Fixed incorrectly selecting the next row when selecting multiple rows
Fixes for input transformations

[close]

https://www.phpmyadmin.net/