Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Whats new:>>

Animated desktop layout in the data browser.
Improved row-link rendering quality and performance.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

Zoom in / out using the mouse wheel in the data browser.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

Main program update:

Add: Support for PostgreSQL 11 beta database system
Support for the latest PostgreSQL 11.x Backup and Restore Database backup and restore processing
Need to work with the latest Database .NET Additional Files
Add: Supports the middle mouse button to quickly open the Databases and Tables/Views (Shortcut Key
Upd: (Sybase ASE) Modify the default text size processing (Default Text Size: 32KB->2GB)
Fix: (FoxPro) Fixed (6792) Preset quote string change, causing the problem that the field could not be displayed properly ()
Upd: Allows Firebird Embedded to open a database with different fbembed.dll/fbclient.dll components in the same instance
Upd: Avoid external factors that cause the program to load slowly when the program starts, resulting in an exception
Upd: Others include cumulative small updates, corrections and optimizations

Data Editor :

Add: (Firebird/FoxPro) Ability to update with ROWID without primary key (NoPKs)
Fix: (Oracle/SQLite/Informix/PostgreSQL) Fixed an issue where ROWID update processing was disabled when there was no primary key (NoPKs)
Upd: Default Value synchronization update display when no-keys (NoPKs) are improved

Plain Execution Plan:

Add: (Access) Support for processing display in Windows XP environment
Fix: (Sybase ASE) Fix (37??) causes the original function to be disabled and cannot be displayed

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

HeidiSQL is an easy-to-use interface and a "working-horse" for web-developers using the popular MySQL-Database. It allows you to manage and browse your databases and tables from an intuitive Windows interface. Includes:

    MySQL Server user management
    Database management (modify databases, tables, fields, indexes)
    Data browsing and modification (including search filters, blob editing)
    MySQL session management (can kill queries)
    SQL query execution, including SQL batch scripting (and MySQL function list)
    Import/export of data

Functional in Linux via WINE.

License: GPL

Whats new:>>

Text file import: Support having (one) line feed at end of file.

http://www.heidisql.com/

[SiLæncer]

Changelog

An error where a database is named 0
Fix for NULL as default not being shown
Fix for recent tables list
Fix for slow performance with table filtering
Two-factor authentication (2FA) fails if the GD PHP library is missing
Event scheduler toggle does not work
ERR_BLOCKED_BY_XSS_AUDITOR error when exporting a table
PHP 7.3 warning: "continue" in "switch" is equal to "break"

[close]

https://www.phpmyadmin.net/

[SiLæncer]

Whats new:>>

Data browser improvements:

New layout feature: "align table horizontally with predecessor"
Improved layout strategy in the data browser.
Improved row-to-row-link rendering performance.
Feature Request "Improve the usability of the Data Model Editor" (partially)

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

Generic driver: new objects creation was fixed
Foreign keys creation was fixed
Schema loading was fixed (Generic driver)
Native client download feature was added (MySQL, MariaDB, PostgreSQL)
Database objects search was fixed
Long CLOB value editor was fixed
Configuration for edit toolbar visibility was added (toolbar is disabled by default)
Keyboard shortcuts activation was fixed

Security:

SSH tunnel initialization fix (NPE)
SSH keyboard-interactive method: now use saved password
Advanced security (BouncyCastle) is now used for SSL/SSH cryptography by default (if present)
ed25519 support was updated

SQL editor:

Auto-completion was improved (fully-qualified names)
Source code paste transformer was improved
Indentation was fixed

Redshift:

PostgreSQL driver is used for connection
Data editor was fixed (read-only state)
Vertica: table list loading performance issue was fixed
MySQL: zeroDateTime configuration was fixed (solves performance issue)

PostgreSQL:

Table DDL was fixed (GRANT commands)
Foreign table DDL was fixed (OPTIONS clause)
SQL Server: BIT data type editor was fixed
SQLite: datatime/numbers formatting support was added
Many minor UI fixes
After all we have reverted to Eclipse 4.7 platform. There were too many bugs and problems with latest version. Especially with Linux platforms

[close]

http://dbeaver.jkiss.org/

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

Whats new: >>

Minor changes.

http://www.vlsoftware.net/

[SiLæncer]

A SQL client that supports simultaneous connections to multiple databases, allowing data sharing and team collaboration on running queries.

Freeware

Changelog

    Connection and database lists are redesigned in a tree view to give you more control and information about the triggers, sequences, etc.

    We’ve switched to JDBC for faster and more reliable database connections.

    You are now able to use TeamSQL with Oracle databases as well. Support for more databases are coming soon.

    Horizontal tabs are finally available! Not a fan? You still have access to vertically listed tabs with search function which helps you if you use many open tabs in your workspace.

    We have switched to AppImage format to support major desktop distributions including Ubuntu, Red Hat, Debian, CentOS, Arch Linux, openSUSE and Fedora.

    We have switched to a new architecture which enables faster connections and queries while preserving the stability and reliability.

    We have added a progress bar at the bottom bar to help you see the progresses of the server, database connection and tab execution processes.

    Fixed: Previously, getting an error message on SSL connections with the MySQL, PostgreSQL, Amazon Redshift database engines. We fixed it.

    Fixed: In the Shared Queries section’s filter feature was not working correctly; now you can filter the queries by “shared by me” or “username” options.

    Fixed: There was an error with the connections because of the timezone conflict. Now timezones will be automatically shifted when you add a new connection.

    Fixed: Print output messages added to PostgreSQL connections to help you keep track of your queries.

    Fixed: Saved queries are now listed with a different icon if you search the saved tabs.

    Fixed: Connection explorer filtering was not working with some Redis hashes. We fixed it.

    Fixed: Column type binary(16) was showing up as [object Object], now it’s fixed.

Known issues:

    "Execute as Script" (click on the down caret at the right edge of the Execute button) is available for MySQL, MSSQL and PostgreSQL. You can still see that button will be visible for other databases but won't work. UI will be improved.

[close]

https://teamsql.io/

[SiLæncer]

Changelog

Add: Support for the Oracle 18c database system (6820)
Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 18.3.0 (2018/08/27) (6820)
Fix: (NuoDB 3.x) Resolve the issue that the enable state preset for INDEXES under the latest version may be NULL (6820)
Fix: (NuoDB 3.x) Resolve the problem that the DOMAIN data type cannot be displayed properly in the latest version (6820)
Upd: Others include cumulative small updates, corrections and optimizations (6820)
- Generating Scripts :
Add: (PostgreSQL 9.2+) Support for Collation Name property generation display (6820)
Fix: (PostgreSQL 9.1+) Fixed <10.0 or lower version of Foreign tables syntax generation issue (6820)
Upd: (SQL Server 2016+) Update Temporal Tables data table related attribute generation display (6820)
Fix: (SQL Server 2000) Fixed an issue that CHECK constraints could not generate (6820)
Add: (NuoDB) supports Partitioned tables property generation display (6820)
Upd: (NuoDB) Update DOMAIN object generation processing, length display of non-numeric types (6820)
- Search Table Data :
Add: Supports regular expression search processing, (Note: Fixed (6726) unopened question) (6820)
Support includes MySQL/Oracle/DB2/Informix/PostgreSQL/Firebird/SQLite/Vertica/SQL Server/SQL Azure
- Connection Profile :
Upd: (Sybase ASE) Increase the character set list drop-down option (Character Sets List) to simplify setup issues (6820)
Upd: (Firebird) Removes the Global Connection Profile , individual connections are included and therefore no longer needed (6820)
- Security Manager :
Upd: (SQL Server 2000) Select the login account (LOGINS) to change the attribute display to replace the permission modification (6820)
- Database Migration (Pro):
Upd: All updates are the same as dbMigration .NET Software (6820)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

Database analysis not only finds primary keys and foreign keys for tables,
but also for views and synonyms by analyzing the underlying tables.
Fixed a memory leak in data browser.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new: >>

    Each newly opened database can be registered with a friendly and meaningful name given by the user.
    Redesigned database history window, which now allows you to edit the properties of registered databases.
    Every control with database list shows now quick hints with the most important database properties, so you can easily find the needed database even if you cannot find it by name.
    New command line options which allow to optimize work with field mappings: /FieldMappingsOverride, /FieldMappingsOverrideFile, /FieldSourceToTargetSchema.
    Improved Open Data Source window.
    Ability to create schema for text tables with fixed-length fields.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

Add: (Access) supports user-level security database processing ( Microsoft Access User-Level Security ) ( ) (6827)
Fix: (Access) Resolved an issue where [First] could not open a database file with a password in a [specific] job environment (6827)
Upd: (MySQL) Forces the connection property setting (Old Guids=True) and removes it from the settings, avoiding browsing, editing, and import and export failures (6827)
Fix: (SQLCe 3.1/3.5) Fix database upgrade function ()
Upd: Resolved an issue that caused the program to fail to open when the system environment setting FipsAlgorithmPolicy=Enabled is enabled (6827)
Upd: Improve text display: Includes Database Diagram , Visual Execution Plan (6827)
Upd: Others include cumulative small updates, corrections and optimizations (6827)
- Visual Execution Plan :
Add: (SQLite) supports both SQLite visualization and textual execution plan display (6827)
Fix: (Oracle) Fix (68??) causes the [visualization] execution plan to be invalid (6827)
- Plain Execution Plan :
Upd: (SQLite) Optimized output display: Display textized execution plan content in a hierarchical manner (6827)
Fix: (Oracle) Fix (68??) causes the [textualization] execution plan to be ineffective (6827)
- Form Editor and Viewer :
Add: Form Edit Join: DateTime Picker , GUID Generator (6827)
Upd: Exclude hidden field display to avoid causing related problems (6827)
- Connection Profile :
Fix: Fixed connection timeout setting (ConnectionTimout) can not change the saved problem (6827)
- Database Migration (Pro):
Upd: All updates are the same as dbMigration .NET Software (6827)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Changelist:

New connection wizard was significantly simplified
Database navigator now loads long table lists by segments (configurable)
Problem with data transfer wizard and connection wizard auto-resize was fixed

Results viewer:

Show error when cell value can’t be read from a database (instead of NULL)
Plaintext renderer was fixed (NULL values render)
Actions enable/disable state was fixed
Export to Excel now respects filters and orderings

Mock data:

Wizard was fixed (error with missing native client)
Batch size configuration was added
UUID data type support was added
String generator was fixed

CSV import:

Column mappings were fixed
Support literal for NULL mark

SQL editor:

Problem with procedures/views editor cursor reset on save was fixed
SQL formatter was fixed (spaces after brackets)
Completion of fully-qualified names was fixed
Error position highlight was improved
Long LOB values editor fix
New version check dialog can be suppressed for a particular version
ERD: show table/constraint comments
CockroachDB extension was added

PostgreSQL:

Active database switch was fixed
Native client selector was fixed. Binaries were upgraded to PG 10.5 version.
Improved support of PostgreSQL 7.x and 8.x
Allow to select directory in restore wizard

MySQL:

Problem with zeroDatetimeBehavior property was fixed
Duration data type support
Elasticsearch: driver version updated to 6.4

Redshift:

Native Redshift table DDL generator was added
Driver version update to 1.2.16 (now use Maven artifact)
SQLite: custom unique key editor was fixed
Vertica: SELECT INTO limit problem was fixed
H2: schema browser was fixed
MSSQL and Generic driver: support filters for procedures/packages
Misc minor UI problems were fixed

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

    Add support for window functions
    Use a separate mutex on every inode in the unix VFS, rather than a single mutex shared among them all, for slightly better concurrency in multi-threaded environments.
    Enhance the PRAGMA integrity_check command for improved detection of problems on the page freelist.
    Output infinity as 1e999 in the ".dump" command of the command-line shell.
    Added the SQLITE_FCNTL_DATA_VERSION file-control.
    Added the Geopoly module

    Enhancements the ALTER TABLE command:

    Add support for renaming columns within a table using ALTER TABLE table RENAME COLUMN oldname TO newname.
    Fix table rename feature so that it also updates references to the renamed table in triggers and views.

    Query optimizer improvements:

    Avoid unnecessary loads of columns in an aggregate query that are not within an aggregate function and that are not part of the GROUP BY clause.
    The IN-early-out optimization: When doing a look-up on a multi-column index and an IN operator is used on a column other than the left-most column, then if no rows match against the first IN value, check to make sure there exist rows that match the columns to the right before continuing with the next IN value.
    Use the transitive property to try to propagate constant values within the WHERE clause. For example, convert "a=99 AND b=a" into "a=99 AND b=99".

    Bug fixes:

    The ORDER BY LIMIT optimization might have caused an infinite loop in the byte code of the prepared statement under very obscure circumstances, due to a confluence of minor defects in the query optimizer. Fix for ticket 9936b2fa443fec03ff25
    On an UPSERT when the order of constraint checks is rearranged, ensure that the affinity transformations on the inserted content occur before any of the constraint checks. Fix for ticket 79cad5e4b2e219dd197242e9e.
    Avoid using a prepared statement for ".stats on" command of the CLI after it has been closed by the ".eqp full" logicc. Fix for ticket 7be932dfa60a8a6b3b26bcf76.
    The LIKE optimization was generating incorrect byte-code and hence getting the wrong answer if the left-hand operand has numeric affinity and the right-hand-side pattern is '/%' or if the pattern begins with the ESCAPE character. Fix for ticket c94369cae9b561b1f996d0054b

[close]

https://www.sqlite.org/