Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Free multi-platform database tool for developers, database administrators, analysts and all people who need to work with databases. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Apache Hive, Phoenix, Presto, etc.

Apache License 2.0

Changelog

    Data editor:

    Top and bottom action toolbars were redesigned
    Action buttons now show hints
    Data export toolbar button is now configurable
    Image viewer was switched to embedded web-browser mode (configurable)
    The issue with spatial data viewer was fixed (“no more handles” error)
    Errors in virtual column definition now handled properly
    “Count nulls” function was added to the Calc panel

    SQL editor:

    Auto-completion with TAB key was implemented (!)
    Hyperlink navigation was fixed for quoted identifiers and identifiers with spaces
    The issue with keyword case auto-conversion was solved
    Editor tabs now shows connection state icon (connected/failed)
    Client-side commands prefix configuration was fixed
    The issue with cursor position change on mouse right-click was resolved
    Data transfer: tables/column mapping dialog was improved, problems with target column name were fixed

    Database drivers:

    License information was added to the most drivers
    It is no longer need to restart DBeaver after driver settings change (bug in recent versions)

    Connections:

    SSH jump servers support was added for SSHJ implementation
    Network profile edit UI was fixed
    Connection error messages

    General UI:

    Dark theme support was added to XML editor
    Dialog font settings is now applied to most popup dialogs
    Database navigator quick filter now supports composite identifiers (thanks to @plotn)
    Clickhouse: driver version was updated, this resolves many issues with different data types support
    Oracle: DATE data type rendering is now configurable
    PostgreSQL: auth role editor was moved to the database level
    SQL server: it is now possible to disable TOP clause in select queries

[close]

https://dbeaver.io/

[SiLæncer]

Database .NET is a powerful and intuitive multiple database management tool. The program allows the administration of local or remote databases to browse objects, design tables, edit rows, export data, create new databases and run queries with a consistent interface. The program includes table/data editor, index editor, syntax highlighting, SQL profiler, code manager and multiple query tabs.

Supported databases include SQL Server, SQL Azure, Firebird, SQLite, MySQL, PostgreSQL, Oracle, IBM DB2 and Informix, Sybase ASE, MS Access and Excel, dBase IV, FoxPro, Data Sources, ODBC DSN and OData. Can export to CSV, XML, TXT, XLS, or SQL Print Query Results.

License:    Free for personal or non-profit use

Changelog

    Data Browser and Editor:

    Fix: (MySQL) Fix (8166) the problem that the Decimal data type cannot be handled normally (8360)
    Upd: (SQLite) When the field has no data type, the output is processed as blob type (8360)

    SQL Editor:

    Upd: Added shortcut key setting (Shortcut Keys): Save As: Ctrl+Shift+S(8360)

    Main program update (Main):

    Add: Support PostgreSQL 15.1 latest database system (8360)
    Upd: Update Database .NET Additional Files (64bit) (2022/11/10)(8360)
    Upd: PostgreSQL component version updated to Npgsql 7.0.0 (2022/11/10)()(8360)
    Upd: Firebird component version updated to FirebirdSql.Data.FirebirdClient 9.1.0.0 (2022/11/08)()(8360)
    Upd: SQL Server/SQL Azure component version updated to Microsoft.Data.SqlClient 5.0.1 (2022/10/07)()(8360)
    Upd: IBM DB2/Informix component version updated to IBM.Data.DB2.dll 9.7.4.4 (11.5.8000.4) (2022/10/20)(8360)
    Misc: (IBM DB2/Informix) IBM Data Server Client Packages Version 11.5.8 FP0 (2022/10/20)
    Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 21.8.0 (2022/10/11)()(8360)
    Upd: MySQL component version updated to MySql.Data.dll 8.0.31 (2022/10/11)()(8360)
    Upd: Teradata component version updated to Teradata.Client.Provider.dll 17.20.3.0 (2022/08/19)()(8360)
    Upd: Others include cumulative minor updates, corrections and optimizations (8360)
    Database Migration (Pro):
    Upd: All updates are the same as dbMigration .NET software (8360)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

A powerful and practical software utility specifically built to extract data from databases and improve performance by removing obsolete entries.

Apache License 2.0

Whats new:>>

    The new "Extended Copy" feature allows table data to be copied in a variety of ways,
    both as plain text and as formatted text.
    Some improvements to the user interface of the data browser.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

    The new "Extended Copy" feature allows table data to be copied in a variety of ways, both as plain text and as formatted text.
    Some improvements to the user interface of the data browser.

http://jailer.sourceforge.net/

[SiLæncer]

pgAdmin allows multi-database management through an administration interface for PostgreSQL permitting statement, procedure viewing and more.

License: Open Source

Changelog

    New features:

    Housekeeping:

    Issue #5147 - Update the BigAnimal API version to V2.
    Issue #5493 - Remove all traces of Backbone and Underscore.

    Bug fixes:

    Issue #5488 - Fixed an issue where the wrong schema is displayed for a foreign key in the schema diff tool.
    Issue #5495 - Ensure that the query history date format in Desktop mode matches the format of the locale of the pgadmin server.
    Issue #5505 - Fixed an issue where the CSV file would not download if the CSV quote character length exceeded 1.
    Issue #5513 - Ensure that DATA_DIR dependent folders/files are automatically created inside the specified DATA_DIR if they are not specified separately in the configuration file.
    Issue #5539 - Improved error message to make it easier for users to understand.
    Issue #5548 - Fixed an issue where editor position was wrong when editing data from result grid.
    Issue #5575 - Ensure the query tool is launched successfully for the servers registered with the PostgreSQL service.
    Issue #5593 - Ensure that only authorized and authenticated users can validate binary paths (CVE-2022-4223).

[close]

https://www.pgadmin.org/

[SiLæncer]

Changelog

    Data editor:
        Data export button UI was enhanced
        Fetch all data and fetch size controls were returned to status bar
        Lasso tool was added to spatial viewer
        Bug in spatial viewer initialization was fixed
        BLOB contents opening in external editor was fixed for MacOS and Linux
        Browser-based image viewer control was fixed (null or invalid images handle)
    SQL editor:
        Big SQL files support was improved (automatic disablement of syntax validation)
        Table auto-completion tooltips UI was redesigned
        Error on unassociated script opening was fixed
    General:
        Default SSL truststore selection was fixed (it is now configurable)
        Connection edit/create dialog performance was improved
        Database server version is now shown in connections’ tooltip
        Object delete dialog was redesigned
        Database create button was removed from the connection dialog for databases which don’t support it
        Security patch for packaged drivers (additional validation of zip archives was added)
    SSH: tunnel invalidation was fixed for SSHJ
    Tasks: problem with tasks operating with missing (deleted) tables was fixed
    Clickhouse: identifiers quoting was fixed (for non ASCII characters)
    Intersystems Cache: community driver was added again
    MySQL:
        Hyperlinks navigation was fixed for procedures
        Complex identifiers quoting was fixed
    Netezza: columns metadataread ws improved
    PostgreSQL:
        Role create/edit command was fixed
        PostgreSQL 15 support was improved (new data type category)

[close]

https://dbeaver.io/

[SiLæncer]

HeidiSQL lets you see and edit data and structures from computers running one of the database systems MariaDB, MySQL, Microsoft SQL, PostgreSQL and SQLite.

License: GPLv2

Changelog

3rd party updates:

    Update plink binaries to latest v0.78. Closes issue #1430

New stuff:

    Make clicks on grid column headers configurable, so the user may disable it, preventing him from accidental sortings on large tables. See https://www.heidisql.com/forum.php?t=40026
    Issue #1705: Add new network type "MySQL on RDS", to support its different query for killing a process. New icon provided by @Bens-ct.

Bugfixes and enhancements:

    Issue #1616: force update check to overwrite old HeidiSQL_update.exe in temp directory, once through different file size, and by logic when old one is older than 30 days. Fixes still used old updater with bugs.
    SQL export: Calculate a reasonable LIMIT clause when "Get full table status" session setting is disabled, causing AvgRowLen lower than 0. See https://www.heidisql.com/forum.php?t=40058
    Fix too narrow column widths restored with high DPI setting, due to Delphi's Round() function using the nearest even number. Use the better suited "kaufmännisch runden" approach.
    Query helpers tree: sync logic behind "Insert at cursor" with what doubleclick does. Enables that menu item for table columns, keywords, functions and snippets. See https://www.heidisql.com/forum.php?t=40022
    Quote BIT values again, in EscapeString version with data type. Closes issue #1709
    Use rds_kill_query procedure on RDS to kill a running query. Closes issue #1705
    Revert background color of selected text in Material style to its original, again causing unreadable link text on dialogs described in issue #993. Readability of selected text seems more important to me. See https://www.heidisql.com/forum.php?t=40003
    Include application version and path of selected session in the session manager's window caption

[close]

https://www.heidisql.com/

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

Freemium

Whats new:>>

Minor interface improvements and bug fixes.

http://www.vlsoftware.net/

[SiLæncer]

Whats new:>>

Fixed:

A bug in metadata acquisition could cause the GUI to freeze for a short time.

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

Whats new:>>

Added: Support for SSH Connections to MySQL,Postgres and MongoDDB

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

[SiLæncer]

Changelog

    Data editor:

    Columns filtering/ordering menu was redesigned
    Virtual key definition behavior was redesigned

    SQL editor:

    Script statistics visualization was fixed
    NullPointer error during new script opening was fixed
    Data transfer: variables resolve in saved tasks was fixed
    Folders drag-n-drop was improved. Drop into root is now possible
    Drag-n-drop from navigator window was fixed for GTK
    Native SQL script execute wizard UI was improved
    Debug log file rotation was added, solves problem with huge log files
    Errors during driver files download are now handled properly
    SSL certificates configuration on Windows was fixed
    Proxy settings are saved between app installations (Windows installer)
    Confirmation dialogs were redesigned
    “Reset UI settings” and “Reset workspace” behavior was redesigned.
    Tasks view now shows tooltips
    Data export in SQL INSERT format now supports custom target table name configuration
    Issue with columns visibility in metadata editor was resolved
    Chinese localization was extended (thanks to @bianyun1981)
    Eclipse plugin now supports the latest Eclipse IDE version
    DBeaver base platform was changed to Eclipse 2022-12
    AWS Athena driver version was upgraded

    PostgreSQL:

    SSL keys automatic conversion was added
    Template databases duplication was fixed
    Object dependencies read query was fixed
    Azure SQL Server driver configuration was fixed (multi-factor authentication support)
    MySQL NDB driver configuration was fixed
    MySQL: user name quoting was fixed
    Multiple minor UI bugs were fixed

[close]

https://dbeaver.io/

[SiLæncer]

Whats new:>>

    Fix the --safe command-line option to the CLI such that it correctly disallows the use of SQL functions like writefile() that can cause harmful side-effects.
    Fix a potential infinite loop in the memsys5 alternative memory allocator. This bug was introduced by a performance optimization in version 3.39.0.
    Various other obscure fixes.

https://www.sqlite.org/index.html

[SiLæncer]

Changelog

- Information Column browsing and editing (Data Browser and Editor ):
    Add: Highlighting Groups of Cells : Support color customization (User Interface->Results Tab->Group Color) (8401)
- Object browsing ( Object Explorer ):
    Upd: (PostgreSQL) Add public global custom data type (UDDT) to all Schemas (affects multiple places) (8401)
    Upd:(PostgreSQL) Improve the alternative processing when the user does not have permission to access information_schema (8401)
    Upd: Improve the processing ability to get the field data type (DataTypeName) (8401)
- Data Import ( Data Import ):
    Upd: Display interface Optimization and Improvement (8401)
- SQL Editor ( SQL Editor ):
    Upd: Automatically jump to the wrong column (or position): Add support for SQLite (8401)
- Main program update ( Main ):
    Fix: (PostgreSQL) Solve Generated Columns If the data type definition is included, the PG itself misses the () problem when returning (8401)
    Fix: (PostgreSQL/MySQL) Corrected the related problem that GetForeignKeys affects when different Schema names have the same Table name (8401)
    Upd: The PostgreSQL component version is updated to Npgsql 7.0.1 (2022/12/17)( )(8401)
    Upd:SQLite component version updated to System.Data.SQLite.DLL 1.0.117.0 (3.40.0) (2022/11/27)(8401)
    Upd: Teradata component version updated to Teradata.Client.Provider.dll 17.20.5.0 (2022/ 11/23)( )(8401)
    Upd: Others include cumulative small updates, corrections and optimizations (8401)
- Database Migration (Pro):
    Upd: All updates are the same as dbMigration .NET software (8401)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

SQLiteStudio is a comprehensive and reliable SQLite database manager that provides you with a simple means of managing the contents of each database, including tables, triggers and views.

License : GPLv3

Changelog

    CHANGE: #4631 Linux binaries are built again back on Ubuntu 20.04 (instead of 22.04) to make it compatible for more Linux machines.
    BUGFIX: #4660 Removed unnecessary linking to curses library in Linux build file.
    BUGFIX: #4658 Fixed crash when SQL parser stack gets overflown.

[close]

http://sqlitestudio.pl/

[SiLæncer]

Changelog

    SQL editor:

    Output logs viewer now respects log levels and supports log search
    Auto-completion for mixed case schema name was fixed
    Result tabs count message was fixed
    Auto-completion of cell values is now configurable
    Query execute time is now populated in statistics (thanks to @bob27aggiustatutto)
    Mixed-case variables resolution was fixed
    Execute statistics UI was fixed (redundant i

    Data editor:

    Column name ordering in record mode was fixed
    Chart type configuration added to the context menu
    Issue with column focus in context menus was fixed

    General UI:

    Database navigator now respects font size customization
    Dashboard graphs now support dark themes
    DB2: client application name population was fixed
    Exasol: privileges reading was fixed for SaaS (thanks to @allipatev)
    MySQ:/MariaDB: schema privileges save was fixed (issue with UI refresh)
    Oracle: complex data types resolution was fixed for resultsets

    PostgreSQL:

    Full backup with roles and groups is now supported
    View triggers DDL was added
    Procedure debugger was fixed
    Issue with URL-baes connections backup was resolved
    Vector data types support was fixed
    Aggregate functions DDL was fixed
    Redshift: incorrect schemas info read in different databases was fixed

    Snowflake:

    Java 17 support has been added
    Complex DDL statements parser was improved
    SQL Server: procedures and functions rename was fixed
    Vertica: comments read can e disabled for all metadata (for performance)

[close]

https://dbeaver.io/