Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Whats new:>>

Main program update ( Main ):

Fix: To solve (6585) in some user's environment, after the start exception error (6586)

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Main program update ( Main ):

Add: Add Duplicating Tables (6593)
Fix: fix the specified database connection failure and then switch [different types] database connection processing problems (6593)
Fix: (IBM DB2) Fixing VIEWS / INDEXES Browse Problems with Identical Names of Objects Different in Different Schemas (6593)
Fix: (Informix) Fixed Problems with TABLES / VIEWS / INDEXES Browse for Objects with Same Name but Different Case in Different SCHEMA (6593)
Fix: (Informix) Fixes for Non-sysmaster Number of Columns Message Unreachable ( Table RowCount ) (6593)
Upd: (Text) No processing will continue when the attached file does not exist (6593)
Upd: Others Including Cumulative Minor Update, Correction and Optimization (6593)

Command Line Processing ( Command-line ):

Upd: rewrite significantly improve the processing speed (6593)
Fix: fixing the problem of missing separator format (6593)

Data Export :

Fix: (VistaDB) export query results column SQL format: Keep Keep Identity keep no effect (6593)

Connection List :

Upd: Improve User Experience: Launch the Last Connection List Automatically After Launch, Eliminate One-Click Processing (6593)
Upd: Improve user experience: Double-click the connection after switching between different database types to avoid the normal processing due to scrolling (6593)

Visual Execution Plan (Pro):

Add: Support Tree node on the right [Click] Display Properties Content Processing (same as click left visual) (6593)
Upd: Automatically switches to [Textual] Plain Execution Plan display (6593) when [Execute Text Output] or Library Version [Visualization Not Supported]

Data Editor :

Add: (PostgreSQL) OID-enabled processing is supported when no columns are updated or deleted by the primary key (PKR) (6593)
Add: (Informix) Supports rowid-based processing when no primary key (PK) updates or deletes a data column (6593)

SQL Editor :

Upd: Save If no folder is selected, the current folder location is saved as the current folder type (6593)

Database Migration (Pro):

Upd: All Updates Same as dbMigration .NET Software (6593)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

SQL editor: query extraction was fixed (trailing delimiter)
SQL editor: variables support was added (${varName}, configurable)
SQL editor: embedded mode was fixed (UI freeze on editor refresh)
Results viewer: column drop-down filter was added
Numeric cell value dialog editor was fixed
Ref cursor cell value dialog viewer was fixed
Main toolbar was fixed (now it is visible only in DBeaver perspective)
UI of checkbox inline editor was fixed
Environment variables substitution now works for all network configurations
External Eclipse extension installer was fixed
Git integration was implemented with Eclipse Git plugin
External plugin repository list was enhanced (Office, SVG, Git, Eclipse Oxygen)
Command line support was fixed (-con + connection properties)
CSV export: value quoting config was added
PostgreSQL: syntax highlighting was improved
MariaDB: default column value editor was fixed
SQL Server: schema list reading was fixed
SQL Server: procedures source reading was fixed
Oracle: view definition (truncated) reading was fixed
Sybase: error handling was fixed (for queries with multiple results)
Firebird: 3.x driver configuration was fixed (default encoding is UTF-8)
Windows installer was improved
“All Users” mode was removed
/S and /D options were fixed
Controls internationalization was improved
Chinese, Russian and French localizations were improved
Many minor UI fixes

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

Fix of NSIS installer (install in Program Files with Admin privileges)
Fix of SQL processor for PostgreSQL dialect (NPE)
SQL editor: query extraction was fixed (trailing delimiter)
SQL editor: variables support was added (${varName}, configurable)
SQL editor: embedded mode was fixed (UI freeze on editor refresh)
Results viewer: column drop-down filter was added
Numeric cell value dialog editor was fixed
Ref cursor cell value dialog viewer was fixed
Main toolbar was fixed (now it is visible only in DBeaver perspective)
UI of checkbox inline editor was fixed
Environment variables substitution now works for all network configurations
External Eclipse extension installer was fixed
Git integration was implemented with Eclipse Git plugin
External plugin repository list was enhanced (Office, SVG, Git, Eclipse Oxygen)
Command line support was fixed (-con + connection properties)
CSV export: value quoting config was added
PostgreSQL: syntax highlighting was improved
MariaDB: default column value editor was fixed
SQL Server: schema list reading was fixed
SQL Server: procedures source reading was fixed
Oracle: view definition (truncated) reading was fixed
Sybase: error handling was fixed (for queries with multiple results)
Firebird: 3.x driver configuration was fixed (default encoding is UTF-8)
Windows installer was improved
"All Users" mode was removed
/S and /D options were fixed
Controls internationalization was improved
Chinese, Russian and French localizations were improved
Many minor UI fixes

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

The output of sqlite3_trace_v2() now shows each individual SQL statement run within a trigger.
Add the ability to read from WAL mode databases even if the application lacks write permission on the database and its containing directory, as long as the -shm and -wal files exist in that directory.
Added the rtreecheck() scalar SQL function to the R-Tree extension.
Added the sqlite3_vtab_nochange() and sqlite3_value_nochange() interfaces to help virtual table implementations optimize UPDATE operations.
Added the sqlite3_vtab_collation() interface.
Added support for the "^" initial token syntax in FTS5.

New extensions:

The Zipfile virtual table can read and write a ZIP Archive.
Added the fsdir(PATH) table-valued function to the fileio.c extension, for listing the files in a directory.
The sqlite_btreeinfo eponymous virtual table for introspecting and estimating the sizes of the btrees in a database.
The Append VFS is a VFS shim that allows an SQLite database to be appended to some other file. This allows (for example) a database to be appended to an executable that then opens and reads the database.

Query planner enhancements:

The optimization that uses an index to quickly compute an aggregate min() or max() is extended to work with indexes on expressions.
The decision of whether to implement a FROM-clause subquery as a co-routine or using query flattening now considers whether the result set of the outer query is "complex" (if it contains functions or expression subqueries). A complex result set biases the decision toward the use of co-routines.
The planner avoids query plans that use indexes with unknown collating functions.
The planner omits unused LEFT JOINs even if they are not the right-most joins of a query.

Other performance optimizations:

A smaller and faster implementation of text to floating-point conversion subroutine: sqlite3AtoF().
The Lemon parser generator creates a faster parser.
Use the strcspn() C-library routine to speed up the LIKE and GLOB operators.

Improvements to the command-line shell:

The ".schema" command shows the structure of virtual tables.
Added support for reading and writing SQL Archive files using the .archive command.
Added the experimental .expert command
Added the ".eqp trigger" variant of the ".eqp" command
Enhance the ".lint fkey-indexes" command so that it works with WITHOUT ROWID tables.
If the filename argument to the shell is a ZIP archive rather than an SQLite database, then the shell automatically opens that ZIP archive using the Zipfile virtual table.
Added the edit() SQL function.
Added the .excel command to simplify exporting database content to a spreadsheet.
Databases are opened using Append VFS when the --append flag is used on the command line or with the .open command.
Enhance the SQLITE_ENABLE_UPDATE_DELETE_LIMIT compile-time option so that it works for WITHOUT ROWID tables.
Provide the sqlite_offset(X) SQL function that returns the byte offset into the database file to the beginning of the record holding value X, when compiling with -DSQLITE_ENABLE_OFFSET_SQL_FUNC.

Bug fixes:

Infinite loop on an UPDATE that uses an OR operator in the WHERE clause. Problem introduced with 3.17.0 and reported on the mailing list about one year later. Ticket 47b2581aa9bfecec.
Incorrect query results when the skip-ahead-distinct optimization is used. Ticket ef9318757b152e3a.
Incorrect query results on a join with a ORDER BY DESC. Ticket 123c9ba32130a6c9.
Inconsistent result set column names between CREATE TABLE AS and a simple SELECT. Ticket 3b4450072511e621
Assertion fault when doing REPLACE on an index on an expression. Ticket dc3f932f5a147771
Assertion fault when doing an IN operator on a constant index. Ticket aa98619ad08ddcab

[close]

https://www.sqlite.org/

[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

https://www.etl-tools.com/

[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 tables ESEDatabaseView failed to read properly some of the fields.
Added 'Detect Ascii Strings In Binary Data' option. When it's turned on, ESEDatabaseView displays binary data as string if it detects that the binary data is Ascii string. This option is useful for cookies names and values (CookieEntryEx_XX tables) in the database of MS-Edge browser (WebCacheV01.dat).
Added 'Put Icon On Tray' option.

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

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

Improvements in Export dialog.
Minor bugfixes.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

Table Designer :

Fix: Unspecified issue of SCHEMA when correcting data sheet field update or data sheet reconstruction (6603)
Upd: (MySQL) data table to establish the default encoding to Server-side settings encoding to simplify the relevant processing (6603)

Constraint Designer :

Add: (MySQL) to version 5.0 database support (6603)

Connection Profile :

Fix: solve the problem when the focus in the Properties page (Properties), click ENTER can not be saved (6603)

Main program update ( Main ):

Upd: (MySQL) When the server side encoding utf8mb4, if the Client default is automatically modified with the Server side consistent (6603)
Upd: MySQL Component Version Updated to MySql.Data.dll 6.9.11 (2018/01/20) (6603)
Upd: Others Including Cumulative Minor Update, Correction and Optimization (6603)

Grant Manager (Pro):

Add: (MySQL) to join the database version 5.0 to 5.4 support (6603)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new: >>

Minor bugfixes.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

V. 3.0.3 Improvements

(CORE-5727)     Engine response has been improved on cancel/shutdown signals when scanning a long list of pointer pages.

Implemented by V. Khorsun

    ~ ~ ~     

(CORE-5712)     The name of the encryption key is not top secret information. It can be read using the gstat utility or service, for example. However, for working with that name from a program it was desirable to access the key name using the API call Attachment::getInfo(). Hence, this facility is now provided via the information item fb_info_crypt_key.

Implemented by A. Peshkov

    ~ ~ ~     

(CORE-5704)     Some clauses of the ALTER DATABASE statement require updating of the single row in RDB$DATABASE: SET DEFAULT CHARACTER SET, SET LINGER, DROP LINGER. Others, such as BEGIN|END BACKUP, ENCRYPT, DECRYPT, et al., do not need to touch that record.

In previous versions, to prevent concurrent instances of ALTER DATABASE running in parallel transactions, the engine would run an update on the RDB$DATABASE record regardless of the nature of clauses specified by the user. Hence, any other transaction that read the RDB$DATABASE record in READ COMMITTED NO RECORD VERSION mode would be blocked briefly, even by a “dummy update” that in fact did not update the record.

In some cases, such as with an ALTER DATABASE END BACKUP the blockage could last 10 minutes or more. A user would seem to be unable to connect to the database with isql, for example, while ALTER DATABASE END BACKUP was running. In fact, isql would connect successfully, but it would read RDB$DATABASE immediately after attaching, using a READ COMMITTED NO RECORD VERSION WAIT transaction and then just wait until the work of ALTER DATABASE END BACKUP was committed.

From this sub-release forward, the update of the RDB$DATABASE record is avoided when possible and an implicit lock is placed to prevent concurrent runs of the ALTER DATABASE statement.

Implemented by V. Khorsun

    ~ ~ ~     

(CORE-5676)     All queries that are semantically the same should have the same plan. However, until now, the optimizer understood only an explicit reference inside an ORDER BY clause and would ignore sorts derived from equivalent expressions. Now, it will consider equivalence classes for index navigation. Refer to the Tracker ticket for an example.

Implemented by D. Yemanov

    ~ ~ ~     

(CORE-5674)     Common Table Expressions are now allowed to be left unused.

implemented by V. Khorsun

    ~ ~ ~     

(CORE-5660)     Flushing a large number of dirty pages has been made faster.

Implemented by V. Khorsun

    ~ ~ ~     

(CORE-5648)     Measures have been taken to avoid serialization of isc_attach_database calls issued by EXECUTE STATEMENT.

Implemented by V. Khorsun

    ~ ~ ~     

(CORE-5629)     Output from gstat now includes the date and time of analysis.

implemented by A. Peshkov

    ~ ~ ~     

(CORE-5614)     The merge stage of a physical backup stage could run too long, especially with huge page cache. Changes have been made to reduce it.

Implemented by V. Khorsun

    ~ ~ ~     

(CORE-5610)     Message “Error during sweep: connection shutdown” now provides information about the database that was being swept.

Implemented by A. Peshkov

    ~ ~ ~     

(CORE-5602)     Improvement in performance of ALTER DOMAIN when the domain has many dependencies.

Implemented by V. Khorsun

    ~ ~ ~     

(CORE-5601)     Compression details and encryption status of the connection (fb_info_conn_flags) have been added to the getInfo() API call. For more information see notes in the API chapter.

(CORE-5543)     Restoring a pre ODS 11.1 database now correctly populates RDB$RELATION_TYPE field in the metadata.

implemented by D. Yemanov

    ~ ~ ~     

(CORE-4913)     Speed of backup with nBackup when directed to NAS over SMB protocol has been improved.

Implemented by J. Hejda & V. Khorsun

    ~ ~ ~     

(CORE-3295)     The optimizer can now estimate the actual record compression ratio.

Implemented by D. Yemanov

[close]

http://www.firebirdsql.org/

[SiLæncer]

Whats new: >>

minor interface improvement.
During the exporting data to delimited text and CSV files, field values are now quoted if they contain either a field separator or a quoting character (i.e. duble quote). In the latter case, each quoting character inside the field value is doubled.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

Mock data generator extension (beta version)
Import/export/script wizard allows multiple run
SQL formatter was fixed (comments and expressions)
Data export in SQL INSERT format was fixed (auto-increment columns)
SQL generator: JOIN support
Results viewer: “Fetch All” command was fixed
Content editor: value saving/activation was fixed
ERD editor: context menu was enhanced (populated with standard table commands)
SQL Server 2000 and earlier: schema reading was fixed
Sybase: procedure body reading was fixed
Sybase: database metadata reading was fixed
PostgreSQL: database switch support was added
PostgreSQL: identity column support was added
PostgreSQL: sequence management
PostgreSQL: default driver version was updated (42.2.0)
PostgreSQL: permission management was improved (sequences support) and fixed (role name escaping)
PostgreSQL: index comments were added to DDL
PostgreSQL: trigger name column was added
Oracle: view definition reading was fixed
MySQL: table filters were fixed
MySQL: database restore wizard was fixed (UTF encoding)
Firebird: stored procedure execution was fixed
Snowflake driver config was added
A few icons were fixed
Keyboard shortcuts were fixed (commit, rollback, results panels toggle)
Many minor UI fixes

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Whats new: >>

New export option: Trim trailing spaces for char and varchar data (False by default).
New environment option: Trim trailing spaces for char and varchar data (False by default). The option has influence on data aware controls (grids).
New command line export option: /TrimTrailingSpaces.

http://www.vlsoftware.net/

[SiLæncer]

Ermöglicht den modellbasierten Datenexport aus relationalen Datenbanken; extrahiert konsistente, referenziell intakte Daten aus produktiven Datenbanken und fügt sie in Testdatenbanken ein; entfernt zudem alte, nicht mehr benötigte Daten aus der Datenbank, ohne die Integrität der Datenbank zu verletzen; generiert DbUnit-Datasets, strukturiertes XML und sortierte SQL-DML-Statements.

Lizenz: Open Source

Changelog

Added "Columns", "Text" and "Meta" views to SQLConsole.
Added "Copy toClipboard" context menu item.
New feature "Explain Plan" in SQLConsole.

[close]

http://jailer.sourceforge.net/