Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Whats new:>>

One of the performance optimizations added in 3.16.0 caused triggers and foreign keys to malfunction for the REPLACE statement on WITHOUT ROWID tables that lack secondary indexes. This patch release fixes the problem.

https://www.sqlite.org/

[SiLæncer]

Changelog

MAIN PROGRAM UPDATE:

Upd: Execute an SQL script file : Join [non-GO] batch processing to improve processing speed and solve the problem of processing large files failed (6222)
Upd: (32bit) SQLCe v3.5 component version update to SQL Server Compact 3.5 SP2 hotfix (3.5.8109.0) (6222)
Upd: Other Includes Cumulative Minor Updates, Fixes and Optimization (6222)

DATA IMPORT:

Add: Support for importing XML format (6222)
Fix: Fixed the problem of importing processing in [Preview Mode] in [Edit Data Column] (6222)
Fix: Fix display problem when preview mode is finished (6222)

DATA EXPORT:

Add: Support for exporting data to Markdown format (6222)
Upd: Update XML data format export processing: Format BLOB data types (with other format types) (6222)

GENERATING SCRIPTS:

Add: (SQL Server 2014 + / SQL Azure) Support for Memory-Optimized Tables script generation (6222)
(CLUSTERED | NONCLUSTERED) Cluster Type Display (6222) Added : (SQL Server 2012 + / SQL Azure) Added PRIMARY KEY [CLUSTERED |

INDEX DESIGNER:

Add: (SQL Server 2012 + / SQL Azure) Support for rowstore index build and script generation (6222)
Fix: (SQL Server / SQL Azure) Fixes (5959) Included Columns Problem with Initial Order and Field Order (6222)

DATA BROWSER:

Upd: Displaying results in text ( Results to Text ): Displaying output in Markdown format (with textual execution plan) (6222)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Resultsets refresh UI was improved
SQL editor: connection selector was redesigned
SQL editor: auto-indent/completion was fixed
Use virtual keys in generated SQL
Generate SQL UPDATE for resultsets
Connection editor save was fixed
DBeaver identification config added
Maven repositories configuration UI has been improved
Preferences pages were reorganized
German localization (thanks to @Sargul)
PostgreSQL: table/role permissions viewer was added
PostgreSQL: new column create dialog added
PostgreSQL: disable BEGIN/END blocks processing
Exasol: auto-completion was fixed
MS SQL: DDL generation was fixed
Cassandra: NULL values read/write fixed
Data export: JSON format was fixed
Many minor UI fixes/improvements

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

There have been changes in the behavior since previous version:

•Changed the suggested text in the query window for delete queries to avoid accidental data loss
•Re-introduce a page which shows the output of phpinfo()

Aside from the changes and security improvements, many bugs have been fixed including:
•Parsing of SQL queries with the BINARY function
•Syntax error when adding or changing TIMESTAMP columns with default value as NULL
•Broken „Edit“ and „Export“ links in the Routines tab
•Creating a new user on older MariaDB servers
•Format button in the SQL tab broken
•Fixes for PHP 7.1
•Problems with MySQL servers running with lower_case_names=2
•Fixes for several PHP notices/warnings being shown

[close]

http://www.phpmyadmin.net/

[SiLæncer]

Changelog

Main program update:

Upd: Add the `mysql_native_password` failed exception message to resolve the MySQL Connector / NET connection problem
Add: Execute an SQL script file : Add a complete Comments filter
Upd: Improved single-line comment syntax to automatically convert '-' to '-' to conform to partial repositories (eg MySQL) to avoid execution failures
Upd: Improved file output name Exception character conversion '.' To '_' Avoiding the display of the file extension
Upd: Improve the SQLite memory database establishment, the exclusion to the connection list processing
Add: Close Tabs ( Ctrl + W , including the original Ctrl + F4 , Middle-Click )
Upd: Update Custom Font Size Set the maximum value (from 10 to 11)
Upd: Other Includes Cumulative Minor Updates, Fixes and Optimizations

Table and View objects list :

Add: Deleting multiple selected objects
Upd: Support for MySQL 8.0+ Object Comments

SQL Editor :

Add: Join this [non-GO] batch instruction processing to increase processing speed while avoiding oversized issues that cause exceptions
Upd: Fixed an issue that could not be used with the TabIndent setting when setting ConvertTabsToSpaces = True
Fix: Fixed a problem when the file is changed outside the environment after the first save

Security Manager :

Add: (MySQL 8.0 + / MariaDB 10.0.5+) support ROLE role of objects and rights management (v)
Fix: (MySQL) Fix Permission Item CREATE VIEW / SHOW VIEW Problem Setting Unusually

Connection Process Manager ( Connection Process Manager ):

Add: Support for Firebird connection removal (Kill connections)

SQL history records ( SQL History ):

Upd: Exclude Execution Statements for SQL Statements such as INSERT / DELETE / UPDATE SQL Profiler ( with LOG Profiling for SQL Profiler )

Code Manager :

Upd: Improved synchronization of node prompts when file changes

Database Migration (Pro):

Upd: All updates are the same as dbMigration .NET Software

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

SQL editor performance fix (auto-completion)
Export from SQL query fix
Results advanced copy/paste: quote complex cell values
Results viewer: value view panel refresh fixed
Foreign key dialog: schema selector added
Metadata editor: copy/paste in search control fixed
Metadata editor: columns configuration dialog fixed
Generate SQL action fixed
PostgreSQL: schema selector fixed
A few minor UI fixes

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

MAIN PROGRAM UPDATE:

Add: Windows Title Add Object Icon Display (6241)
Add: Support batch processing of [single-row non-GO], enabling batch processing of repositories that do not support batch commands (6241)
Upd: non-fixed date data type to increase the length of the display (including script generation) (6241)
Upd: (Firebird) Adds VIEWS / PROCEDURES without source display (6241)
Upd: (NuoDB) Update data type (Decimal / Numeric) Maximum length setting (6241)
Upd: Auto-zoom the width of the library drop-down menu on the taskbar (6241)
Upd: to improve the right-click menu [main] option and the <sub>option prompt message, switch to avoid the display (6241)
Upd: Other Includes Cumulative Minor Updates, Fixes and Optimization (6241)

GENERATING SCRIPTS:

Add: (SQL Server 2008 + / SQL Azure) Support for Sparse Columns and Column Sets Script generation (6241)
Add: (SQL Server 2016 + / SQL Azure) Support for Generated Always Columns script generation (6241)
Upd: (SQL Server / SQL Azure) Processes encrypted objects instead of generating prompts instead of prompting dialogs (6241)
Fix: (Oracle) Fixed an issue (6241) that caused the table index name (INDEX name) to be incorrectly generated (6241)
Fix: Fixed Expression Columns generation, avoid adding unnecessary QuotedString displays (6241)

DATA EDITOR AND BROWSER:

Upd: (Informix) supports TEXT data type (blob) data type processing (6241)
Upd: (OData) Execution Time to Increase Execution Time (6241)

TABLE AND VIEW OBJECTS LIST:

Upd: Optimizing Exception Handling and Updating Titles after Object Deletion (6241)</sub>

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

MAIN PROGRAM UPDATE:

Add: (PostgreSQL 9.3 + / Oracle) MATERIALIZED VIEW to add Indexes object browsing, build and script generation (6248)
Add: (SQL Server 2005 + / SQL Azure) Add Index View Table (INDEXED VIEW) Browse, Build, and Script Generation Processing (6248)
Add: (Oracle) Browse [All] Database Schema ( Browsing all databases ): Add MATERIALIZED VIEW Object Display (6248)
Upd: (Oracle) Table Object Node Elimination of MATERIALIZED VIEW, USLOG $, etc. Object Display (6248)
Upd: (Oracle) Exclude Self- Generating System Index Displays, Avoiding Duplicate Processing (6248)
Fix: Removes VIEWS object node Unnecessary right-click menu item ( Data Import ) (6248)
(6235) the original '.' To '_' conversion, to avoid the extension of other issues (6248), to avoid the problem,
Upd: VistaDB component version is updated to VistaDB.5.NET40.dll 5.5.3 (2017/02/03) (6248)
Upd: Other Includes Cumulative Minor Updates, Fixes and Tuning (6248)

GENERATING SCRIPTS:

Add: Add objects such as INDEXES / TRIGGERS Right-click menu SCRIPT AS script generation processing (6248)
Fix: (Oracle) Fixed MATERIALIZED VIEW Script Creation (6248)

TABLE DESIGNER:

Upd: Allowed data table Length (Data Type Length) Post-change processing (6248)

DATA EDITOR AND BROWSER:

Upd: (ODBC) Improved access to data table data (DataRow), adding more exception handling (6248)
Upd: Improved access to field data type (DataType), when GetSchemaTable can not return normally (6248)
Upd: (SQL Server / SQL Azure) Update Geography / Geometry / HierarchyId and other data types to read the problem (6248)

SEARCH TABLE DATA:

Upd: Update the data type of searchable fields (6248)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Build corruption with CREATE INDEX CONCURRENTLY:

There existed a race condition if CREATE INDEX CONCURRENTLY was called on a column that had not been indexed before, then rows that were updated by transactions running at the same time as the CREATE INDEX CONCURRENTLY command could have been indexed incorrectly.

If you suspect this may have happened, the most reliable solution is to rebuild affected indexes after installing this update.
This issue is present in the 9.2, 9.3, 9.4, 9.5, and 9.6 series of PostgreSQL.
Fixes for visibility and write-ahead-log stability

These release contains several fixes to improve the stability of visible data and WAL logging that we wish to highlight here.
Prior to this release, data could be prematurely pruned by a vacuum operation when a special snapshot used for catalog scans was presently available. Specifically, the vacuum operation would not be aware of the oldest xmin for this special snapshot. The error would surface with a message such as:

"cache lookup failed for relation 1255"
This release ensures that vacuum operations will account for the catalog scan snapshots.

BUG FIXES AND IMPROVEMENTS:

This update also fixes a number of bugs reported in the last few months. Some of these issues affect only the 9.6 series, but many affect all supported versions.
There are more than 75 fixes provided in this release, including:
Several fixes for operating in hot standby mode
Disallow setting the num_sync field to zero in synchronous_standby_names
Don't count background worker processes against a user's connection limit
Fix check for when an extension member object can be dropped
Fix tracking of initial privileges for extension member objects so that it works correctly with ALTER EXTENSION ... ADD/DROP
Several vacuum and autovacuum fixes
Fix CREATE OR REPLACE VIEW to update the view query before attempting to apply the new view options
Make sure ALTER TABLE preserves index tablespace assignments when rebuilding indexes
Several fixes to the query planner, including fixes for foreign tables and CTEs
Several fixes around the full-text search feature to improve accuracy and performance of the search
Several fixes and performance improvements in several array functions
Several fixes around the interaction of foreign-key constraints with trigger functions around specific ALTER TABLE operations
Remove optimizations for date/time data types that returned incorrect data
Fix incorrect use of view reloptions as regular table reloptions
Fix incorrect "target lists can have at most N entries" complaint when using ON CONFLICT with wide tables
Fix spurious "query provides a value for a dropped column" errors during INSERT or UPDATE on a table with a dropped column
Prevent multicolumn expansion of foo.* in an UPDATE source expression
Ensure that column typmods are determined accurately for multi-row VALUES constructs
Several fixes for the psql command-line tool
Prevent multiple calls of pg_start_backup() and pg_stop_backup() from running concurrently
Several fixes for pg_dump, pg_restore, and pg_basebackup, including a possible pg_basebackup failure on standby server when including WAL files
Several fixes for parallel workers and plans for parallel queries including fixing a crash if the number of workers available to a parallel query decreases during a rescan
Several fixes to PL/pgSQL, PL/Python, and PL/Tcl
Several fixes for contrib modules
Allow DOS-style line endings in ~/.pgpass files, even on Unix
Update time zone data files to tzdata release 2016j for DST law changes in northern Cyprus (adding a new zone Asia/Famagusta), Russia (adding a new zone Europe/Saratov), Tonga, and Antarctica/Casey. Historical corrections for Italy, Kazakhstan, Malta, and Palestine. Switch to preferring numeric zone abbreviations for Tonga.
Updating
All PostgreSQL update releases are cumulative. As with other minor releases, users are not required to dump and reload their database or use pg_upgrade in order to apply this update release; you may simply shut down PostgreSQL and update its binaries.

If you believe you have been affected by the aforementioned CREATE INDEX CONCURRENTLY bug, you will have to rebuild the index. Here is an example of how to rebuild an index in a production system without losing the ability to utilize the index:

CREATE INDEX CONCURRENTLY new_index_name ON table_name (column_name);
DROP INDEX CONCURRENTLY old_index_name;
ALTER INDEX new_index_name RENAME TO old_index_name;

[close]

http://www.postgresql.org/

[SiLæncer]

Changelog

AUTOCOMPLETE AND INTELLISENSE:
Upd: Field Auto Sensing is more intelligent, dramatically reducing unnecessary perceived display processing while improving efficiency (6254)
JOIN + Space Automatically displays external index keys for reference, when displaying problems with no Alias ​​(6254). [FULL / INNER / LEFT / RIGHT / CROSS / NATURAL]
Upd: Improved improvements click on the right side of the space first non-text detection processing (6254)
Upd: Improve the resolution of Table + Alias ​​+ Keyword (6254)
DATA IMPORT:
Upd: Automatically remove the self-incrementing (IdentityColumn), eliminating the need for manual import processing (6254)
Upd: Increase field name Background color Clear distinction (NOT NULL) or not (6254)
Upd: Converts numeric type Decimal symbol: Displays the problem (Decimal symbol:.), Avoids misinterpretation of additional manual processing (same as import) (6254)
Select the query to the query generator ( Selected Text to Query Builder )
Upd: Improved Alias ​​+ Column Resolution (6254)
SQL EDITOR:
Upd: Improved SQL formatting control problem, excluding IF-THEN-ELSE Statement formatting (6254)
MAIN PROGRAM UPDATE:
Add: select the last object when connected after the new connection (6254)
Upd: The object name contains the handling of the exception character () (6254)
Upd: rewrite the system default [expand all nodes] shortcut * processing , only to the object itself is only fully developed (6254)
Upd: (Sybase ASE) Add InitializationString Connection Properties Settings, Script Tab (Script Tab) (6254)
Upd: Other Include Cumulative Small Update, Fix and Optimize (6254)
Misc: Compatible with Compatible with PostgreSQL 9.6.2 / 9.5.6 / 9.4.11 / 9.3.16 / 9.2.20 (2017/02/09)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Approximately 25% better performance from the R-Tree extension.
Uses compiler built-ins (ex: __builtin_bswap32() or _byteswap_ulong()) for byteswapping when available.
Uses the sqlite3_blob key/value access object instead of SQL for pulling content out of R-Tree nodes
Other miscellaneous enhancements such as loop unrolling.
Add the SQLITE_DEFAULT_LOOKASIDE compile-time option.
Increase the default lookaside size from 512,125 to 1200,100 as this provides better performance while only adding 56KB of extra memory per connection. Memory-sensitive applications can restore the old default at compile-time, start-time, or run-time.
Use compiler built-ins __builtin_sub_overflow(), __builtin_add_overflow(), and __builtin_mul_overflow() when available. (All compiler built-ins can be omitted with the SQLITE_DISABLE_INTRINSIC compile-time option.)
Added the SQLITE_ENABLE_NULL_TRIM compile-time option, which can result in significantly smaller database files for some applications, at the risk of being incompatible with older versions of SQLite.
Change SQLITE_DEFAULT_PCACHE_INITSZ from 100 to 20, for improved performance.
Added the SQLITE_UINT64_TYPE compile-time option as an analog to SQLITE_INT64_TYPE.
Perform some UPDATE operations in a single pass instead of in two passes.
Enhance the session extension to support WITHOUT ROWID tables.
Fixed performance problems and potential stack overflows when creating views from multi-row VALUES clauses with hundreds of thousands of rows.
Added the sha1.c extension.
In the command-line shell, enhance the ".mode" command so that it restores the default column and row separators for modes "line", "list", "column", and "tcl".
Enhance the SQLITE_DIRECT_OVERFLOW_READ option so that it works in WAL mode as long as the pages being read are not in the WAL file.
Enhance the LEMON parser generator so that it can store the parser object as a stack variable rather than allocating space from the heap and make use of that enhancement in the amalgamation.
Other performance improvements. Uses about 6.5% fewer CPU cycles.

BUG FIXES:

Throw an error if the ON clause of a LEFT JOIN references tables to the right of the ON clause. This is the same behavior as PostgreSQL. Formerly, SQLite silently converted the LEFT JOIN into an INNER JOIN. Fix for ticket 25e335f802dd.
Use the correct affinity for columns of automatic indexes. Ticket 7ffd1ca1d2ad4ec.
Ensure that the sqlite3_blob_reopen() interface can correctly handle short rows. Fix for ticket e6e962d6b0f06f46e.

[close]

https://www.sqlite.org/

[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

    Minor fixes, Including (hopefully) fixing field-list-scroll issue.
    Move the Numeric = next to the Text = in the find and filter screen.
    New CommitCount and FetchCount parameter options to improve performance with big Layouts
    Enhanced python Code generation
    New Script (macro) functions to edit files.
    New Script functions to process multiple files

[close]

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

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

[SiLæncer]

Changelog

MAIN PROGRAM UPDATE:

Add: (PostgreSQL 9.1+) support exclusion constraint object display, script generation and deletion ... and so on (6260)
Add: (Teradata) to join the MACRO object parameters (Parameters) display processing (6260)
Upd: (VistaDB / Informix) Exclude external index keys Object display with script generation (6260)
Upd: (SQLite / Teradata) Improved Multiple Fields Multiple-column foreign key Object Display Processing (6260)
Fix: (NuoDB) Fixed and updated multiple fields Multiple-column foreign key Object display with script generation (6260)
Upd: Add PACKAGES Object Heavy Brush (6260)
Upd: (SQL Server) How the update database is located (6260)
Upd: Other Include Cumulative Minor Update, Fix and Optimize (6260)
Misc: Compatible with Compatible with Firebird 2.5.7 (2017/02/15)

GENERATING SCRIPTS:

Add: (Teradata) joins MACRO object script generation and execution processing (6260)
Upd: (Teradata) Optimize DDL Format Output Processing (6260)
Upd: Update CHECK CONSTRAINTS Script Generation Issues (6260)

CONSTRAINT DESIGNER:

Fix: (Firebird) Fixed ON UPDATE, ON DELETE Unable to create a RESTRICT type (6260)
Fix: (IBM DB2) Remove ON UPDATE type CASCADE, SET NULL, etc. Invalid type setting (6260)

SQL HISTORY:

Upd: Search Results Synchronization Change SQL Statement Preview Processing (with SQL Profiler ) (6260)
Upd: Update List Content [Display] Processing , SQL Statementless Broken List Display (Contains SQL Profiler ) (6260)
Upd: Improve the list of content [search] processing , you can start the query (including SQL Profiler ) at the current location (6260)
AUTOCOMPLETE AND INTELLISENSE:

Updating Data Table Does Not Contain QuotedString Field Aware Processing Problem (6260)

SQL EDITOR:

Updix (6254) and then improve the SQL format to exclude IF problem (6260)

SQL FILE VERSION CONTROL MANAGEMENT:

Upd: Improved Feature Item Status Update (6260)

MY FAVORITES:

Upd: Add object to detect and exclude memory database and other processing (6260)

INDEX DESIGNER:

Fix: (Teradata) fixes the problem of missing new jobs (6260)

DATABASE MIGRATION:

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

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Transaction monitor
Pending transactions monitor dialog
Commit/Rollback commands are enabled only if transaction is active
SQL editor: performance fixes (CPU usage in idle mode)
SQL editor: tabs switch shortcuts added
SQL editor: memory leaks fixed (multiple result tabs)
SQL completion: quoted identifiers completion has been fixed
Results view: custom coloring fixed (multiple color settings for single column)
Results view: attributes hide/show fixed (visibility change doesn’t require results refresh)
Query manager view: rows coloring was fixed
Data export: execute external process on finish
CSV export: NULL value rendering configuration
Create index: ability to set column ordering
Connection keep alive now reopens failed connections
Status bar: shows current time zone and locale
Connection editor: connection folder settings save was fixed
SSH tunnel config: ask for password if password wasn’t saved in connection settings
BLOB value rendering was fixed
HSQLDB: embedded database shutdown fix
MySQL: SSL support has been improved (certificate private key support, Google Cloud support)
Oracle: PL/SQL packages navigation was improved (navigate from procedures and from SQL editor)
Oracle: fix of metadata reading for version <= 8
PostgreSQL: numeric columns scale/precision are now editable
PostgreSQL: case-insensitive autocompletion was fixed
PostgreSQL: new tables/columns comments save was fixed
SQLite: data editor was improved (SQLite synamic data type system support)
SQLite: read and edit of triggers and sequences
SQLite: native tables/views/triggers DDL
SQLite: tables rename support
Many minor bug fixes

Migration on Eclipse 4.6 platform:

DBeaver now requires Java 8
Support of HighDPI monitor
SQL editor zoom in/out function
Many UI fixes in GTK mode (CPU usage)

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

This is a hotfix version:

Oracle connector was fixed
DB2 for z/OS connector was fixed
ODBC connector was fixed
Commit/Rollback command enablement was fixed
Solaris version build was fixed
A few minor bugfixes

[close]

http://dbeaver.jkiss.org/