Thema: Datenbanksoftware und Tools diverses ...

[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 changes and bug fixes.
More convenient notifications about updates.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

Data Export :

Add: new export format MERGE statement (*.sql) : function of proprietary database UPSERT (6715)
Supports databases such as Firebird/SQL Server/SQL Azure/Oracle/IBM DB2/Informix/HP Vertica/Teradata
Add: new export format REPLACE statement (*.sql) : function of proprietary database UPSERT (6715)
Supports SQLite/MySQL/NuoDB and other databases
Add: New export format DELETE+INSERT statement (*.sql) : Implements functions similar to UPSERT, Universal Database (6715)
Fix: Export format UPDATE statement (*.sql): Fix generation process for col=NULL (6715)
Fix: Export format INSERT/DELETE statement (*.sql): Fix condition field name without Quoted Identifiers (6715)
Fix: Export format INSERT/DELETE statement (*.sql): Solve the problem that GetSchemaTable cannot get Oracle/HP Vertica/Sybase ASE/SQLCe primary key (PKs) (6715)

Generating Scripts :

Add: Add SCRIPT AS UPSERT (MERGE/REPLACE) Syntax Definition Generation (6715)
Supports databases such as PostgreSQL/SQLite/MySQL/NuoDB/Oracle/Firebird/SQL Server/SQL Azure/IBM DB2/Informix/Sybase ASE/HP Vertica/Teradata

Data Editor :

Add: Duplicate the current row: Ctrl + D (6715)
Upd: The Problem of Losing the Current Control Focus After Resolving (6715)

Main program update ( Main ):

Fix: (Oracle) Fixed an issue where User-Defined Data Types were not updated synchronously when switching between different SCHEMAs (6715)
Fix: (ODBC/OleDB) Resolve issues associated with the library's absence of a default Quoted Identifiers character (6715)
Fix: Avoid the problem that the main window cannot be focused after waiting for the window to end in some cases (6715)
Upd: Others contain cumulative minor updates, corrections, and optimizations (6715)
Misc: Compatible with PostgreSQL 10.4 / 9.6.9 / 9.5.13 / 9.4.18 / 9.3.23 (2018/05/10)

Database Migration (Pro):

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

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

Fixed statement leak.
Minor GUI Improvements and bug fixes.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

Data Export:

Fix: Fix (6715) Problem with Export Format Caused by [No Export Options] Cannot Be Processed Normally (6717)
Upd: (Oracle) Added automatic recognition TIMESTAMP data type format millisecond dimension .FFx length export processing (6717)
Upd: (Oracle) Joining Automatically Recognize TIMESTAMP and TIMESTAMP WITH TIME ZONE Data Type Format Export Processing (6717)

Data Editor:

Fix: (Oracle) Correct CLOB/NCLOB data type processing when there is no primary key (6717)

Main program update ( Main ):

Upd: Others contain cumulative minor updates, corrections, and optimizations (6717)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

- issue #12772 Fix case where the central columns attributes don't get filled in
- issue #14049 Fix case where the query builder doesn't work when selected column is *
- issue #14029 Revert "Browse" table CSS overflow
- issue #14241 Dropping indexes and foreign keys fail
- issue #14227 Relational linking broken
- issue #14246 Fixed error in configuration storage zero config
- issue #14128 Show 2FA Secret next to QR code
- issue #14212 XML Export from single table throws fatal error
- issue #14239 Line and some other charts ignore result set order of values chosen for the x-axis
- issue #14260 Fixed configuration for DefaultLang and Lang
- issue #14264 Linking for 'Distinct values' broken
- issue #13968 Fix MariaDB 10.2 current_timestamp()
- issue #14249 Fix for missing go button in view edit
- issue #14125 Fix for issues with spatial fields
- issue #14189 Remember table's sorting broken
- issue #14289 Fix multi-column sorting
- issue #14278 Fix central columns in-line edit bug
- issue #14066 Fix AUTO_INCREMENT error when only exporting table structure in database-level exports
- issue #13893 Simulating queries produces unexpected results
- issue #14309 Setup script icons missing

[close]

https://www.phpmyadmin.net/

[SiLæncer]

Changelog

Support of cells edit for queries with joined tables
SSH tunnels: test connection button was added
Results viewer: horizontal scroll with mouse wheel
Results viewer: extra header tooltips were added
PostgreSQL: debugger – fix breakpoints support
PostgreSQL: data types loading performance was greatly increased
PostgreSQL: search_path updating was fixed
PostgreSQL: array data type support was improved
MySQL 8+ support was fixed
Oracle: jobs scheduling (thanks to Neil Crow)
Oracle: schema create dialog improvements
Oracle: error positioning was improved
Oracle: timestamp with timezone support was added
Oracle: CASE statements parser was fixed
SQL Server: triggers reading was fixed
SQL Server: drop trigger feature was added
Vertica: table columns editor (data type, nullability)
Redshift: driver version update
Cassandra: JSON formatter for all text columns
ERD: include nullability in attribute type description
Queries history browser was fixed
Some keyboard shortcuts were changed (results navigation)
Some icons were updated
Spanish localization was added (thanks to Ishibashi Takken)
Japanese localization was added (thanks to faibistes)
Misc minor UI bugfixes

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Whats new:>>

Feature to define the rendering position of a column.
Rendering of row-to-row links as bezier curves.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

Main program update ( Main ):

Add: (HP Vertica/Informix/Teradata/VistaDB) Add Built-in Functions (6726)
Upd: (VistaDB) Improving CHECK constraints Object Browsing Processing (6726)
Fix: (PostgreSQL) Names of Built-In Functions Changed to Lowercase Display (6726)
Upd: (Firebird) Connection Status Enable/Update when Default/Embedded option is switched (6726)
Upd: Optimizing Interface Display (6726)
Upd: IBM DB2/Informix Component Version Updated to IBM.Data.DB2.dll 9.7.4.4 (11.1.3031.4) (2018/05/22) (6726)
Misc: (IBM DB2/Informix) IBM Data Server Client Packages Version 11.1.3 Fix Pack 3a (2018/05/22)
Upd: Others include cumulative minor updates, corrections, and optimizations (6726)

Search Table Data :

Add: Supports regular expression search processing (6726)
Fix: Fixed an issue where PostgreSQL could not search normally (6726)

AutoComplete and IntelliSense :

Add: (HP Vertica/Informix/Teradata/VistaDB) Added built-in functions to automate display processing (6726)
Fix: Fixed (6505) Problems with partial object types were not excluded when quotation mark identification was enabled (6726)
Upd: Improvements to automatically determine if an object name exception character requires quotation mark identification (6726)

Data Editor :

Add: Showing filter expression on the toolbar (6718)
Fix: (Oracle) Correct CLOB/NCLOB data type processing when there is no primary key (6717)

Data Export :

Fix: Fix (6715) Problem with Export Format Caused by [No Export Options] Cannot Be Processed Normally (6717)
Upd: (Oracle) Added automatic recognition TIMESTAMP data type format millisecond dimension .FFx length export processing (6717)
Upd: (Oracle) Joining Automatically Recognize TIMESTAMP and TIMESTAMP WITH TIME ZONE Data Type Format Export Processing (6717)

Binding Function parameters :

Fix: (Teradata) Repeatedly adding Quoted Identifiers characters when correcting text type (Char) (6726)

Database Migration (Pro):

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

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

Data browser: prevented that context menu automatically gets closed if the item doesn't have the focus.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

Results viewer: Groupings panel was added (GROUP BY generator)
Results viewer: Aggregate panel was renamed to Calc
Results viewer: links navigation was fixed (references rendering)
Results viewer: show confirmation if panel data was modified
Results viewer: improved drag-n-drop support for all controls
Results viewer: icons were fixed
Mockdata: template generator was added
SQL editor: show stored procedures/functions in SQL completion
SQL formatting was fixed (single line comments)
XLS export: empty tables export was fixed
Update site management preference page was added
Columns visibility/order configuration dialog was improved
Date/time formatted was fixed (nanoseconds format pattern)
HANA: functions source code reading
Clickhouse: array data types support was added
Oracle: session elapsed time was added
Oracle: timestamp with timezone handler was fixed (check driver version)
PostgreSQL: drop sequence query was fixed
RedShift: driver configuration was fixed
Many minor UI bugfixes

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

Add support for PostgreSQL-style UPSERT.
Add support for auxiliary columns in r-tree tables.
Add C-language APIs for discovering SQL keywords used by SQLite: sqlite3_keyword_count(), sqlite3_keyword_name(), and sqlite3_keyword_check().
Add C-language APIs for dynamic strings based on the sqlite3_str object.
Enhance ALTER TABLE so that it recognizes "true" and "false" as valid arguments to DEFAULT.
Add the sorter-reference optimization as a compile-time option. Only available if compiled with SQLITE_ENABLE_SORTER_REFERENCES.
Improve the format of the EXPLAIN QUERY PLAN raw output, so that it gives better information about the query plan and about the relationships between the various components of the plan.
Added the SQLITE_DBCONFIG_RESET_DATABASE option to the sqlite3_db_config() API.

CLI Enhancements:

Automatically intercepts the raw EXPLAIN QUERY PLAN output and reformats it into an ASCII-art graph.
Lines that begin with "#" and that are not in the middle of an SQL statement are interpreted as comments.
Added the --append option to the ".backup" command.
Added the ".dbconfig" command.

Performance:

UPDATE avoids writing database pages that do not actually change. For example, "UPDATE t1 SET x=25 WHERE y=?" becomes a no-op if the value in column x is already 25. Similarly, when doing UPDATE on records that span multiple pages, only write the subset of pages that contain the changed value(s).
Queries that use ORDER BY and LIMIT now try to avoid computing rows that cannot possibly come in under the LIMIT. This can greatly improve performance of ORDER BY LIMIT queries, especially when the LIMIT is small relative to the number of unrestricted output rows.
The OR optimization is allowed to proceed even if the OR expression has also been converted into an IN expression. Uses of the OR optimization are now also more clearly shown in the EXPLAIN QUERY PLAN output.
The query planner is more aggressive about using automatic indexes for views and subqueries for which it is not possible to create a persistent index.
Make use of the one-pass UPDATE and DELETE query plans in the R-Tree extension where appropriate.
Performance improvements in the LEMON-generated parser.

Bug fixes:

For the right-hand table of a LEFT JOIN, compute the values of expressions directly rather than loading precomputed values out of an expression index as the expression index might not contain the correct value. Ticket 7fa8049685b50b5aeb0c2
Do not attempt to use terms from the WHERE clause to enable indexed lookup of the right-hand table of a LEFT JOIN. Ticket 4ba5abf65c5b0f9a96a7a
Fix a memory leak that can occur following a failure to open error in the CSV virtual table
Fix a long-standing problem wherein a corrupt schema on the sqlite_sequence table used by AUTOINCREMENT can lead to a crash. Ticket d8dc2b3a58cd5dc2918a1
Fix the json_each() function so that it returns valid results on its "fullkey" column when the input is a simple value rather than an array or object.

Hashes:

SQLITE_SOURCE_ID: "2018-06-04 19:24:41 c7ee0833225bfd8c5ec2f9bf62b97c4e04d03bd9566366d5221ac8fb199a87ca"
SHA3-256 for sqlite3.c: 0d384704e1c66026228336d1e91771d295bf688c9c44c7a44f25a4c16c26ab3c

[close]

https://www.sqlite.org/

[SiLæncer]

Changelog

Main program update ( Main ):

Add: Title Column Add Status Show Total Configuration Managed Memory (6733)
Add: Table Properties: Increase Table Dependencies (6733)
Databases such as SQL Server/SQL Azure/Firebird/Oracle/IBM DB2/Informix/Sybase ASE
Upd: After the Splash Form opens and ends, return to the issue of the owning window (6733)
Upd: Others contain cumulative minor updates, corrections, and optimizations (6733)

Generating Scripts :

Fix: (PostgreSQL) Fixed issue where SCHEMA was not specified when generating object annotations (COMMENT) (6733)

AutoComplete and IntelliSense :

Fix: Fix the problem that the screen may not display properly under occasional situations (6733)

Database Migration (Pro):

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

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

Comprehensive usability improvements of the data browser.
Animated row-to-row links.
Increased rendering quality of row-to-row link.

http://jailer.sourceforge.net/

[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

What's new: >>

– Fixed: Issues with exporting very large grids into excel files

http://www.etl-tools.com/database-editors/database-browser/overview.html

[SiLæncer]

Changelog

Results viewer:

Filter text can be expanded (for multi-line filter values)
Filter editor now supports undo/redo and drag-n-drop
Text value editor was fixed (undo/redo commands)
Grouping panel UI was fixed (settings save, dark theme, keys navigation)
Table ordering is saved between foreign keys navigation
Context menu was refactored

SQL Editor:

Parser performance was improved
SQL formatting was improved
Support special characters in table names for auto-completion
Stored procedures execute was improved
Stored procedures names auto-completion was added
Driver manager dialog was fixed

ERD:

Palette is visible by default
Notes edit was fixed (+ undo/redo)
Table/tree editors UI was fixed for MacOS
Ping/keep-alive background jobs visualization was fixed

PostgreSQL:

Use fully qualified data type names in DDL
View default values for procedure parameters
Enum/set values editor was fixed
Revoke all permissions command was fixed
Show template databases

MySQL:

Event DDL was fixed
View DDL was fixed
SQL Server: datetime/datetime2 data types handle was fixed
HSQLDB: synonyms support was added

Data transfer:

CSV values escaping was fixed
Support export in SQL format for custom SQL queries
Finish wizard message can be suppressed
Localization was improved

[close]

http://dbeaver.jkiss.org/