Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

A database management application with support for MySQL, MS SQL and PostgreSQL, with a built-in query designer and a table and SQL editor.

MIT License

Changelog

    FIXED: Database colors
    CHANGED: Precise work with MongoDB ObjectId
    FIXED: Run macro works on MongoDB collection data editor
    ADDED: Type conversion macros
    CHANGED: Improved UX of import into current database or current archive
    ADDED: Posibility to create string MongoDB IDs when importing into MongoDB collections
    CHANGED: Better crash recovery
    FIXED: Context menu of data editor when using views - some commands didn't work for views
    ADDED: Widget lists (on left side) now supports add operation, where it has sense
    CHANGED: Improved UX of saved data sheets
    ADDED: deploy - preloadedRows: impelemnted onsertOnly columns
    ADDED: Show change log after app upgrade

[close]

https://github.com/dbgate/dbgate

[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

    SQL editor:
        Auto-completion for tables without alias was fixed
        Script file name template support was added
    Data editor: column filters edit dialog UI was improved
    Resource manager: cross-project connection drag-n-drop was fixed
    Task manager: task statistics read was fixed
    SQL query generator: string values quotation was fixed
    Driver manager: Maven artifacts import/edit UI was improved
    Connection lock password support was fixed
    Navigator:
        Object filters now support backslash escape
        Multiple minor UI bugs were fixed
    DB2: table organization property was added
    PostgreSQL, Greenplum, Redshift:
        Permission editor UI was fixed (redundant GRANT/REVOKE commands merge)
        Composite data types support was fixed
        Execution plan rendering was fixed ("Parallel" scan)
        Partition tables statistics read was fixed
    SQL Server: column data type modifiers generator was fixed
    SQLite: table foreign keys editor was added

[close]

https://dbeaver.io/

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

    Fix for "Lack of navigation arrows #74".
    The subsetting results can now be opened directly in the SQL console of the data browser or as a separate window.

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:

    Added support for Two-factor authentication for improving security.
    Added support to disable the auto-discovery of the database servers.

    Housekeeping:

    Replace Flask-BabelEx with Flask-Babel.
    Port Backup Global, Backup Server, and Backup object dialog in React.
    Replaced alertifyjs notifiers with React-based notistack.
    Upgrade Flask to version 2.
    Replace Alertify alert and confirm with React-based model dialog.

    Bug fixes:

    Fixed an issue where tooltip data are not displaying on downloaded graphical explain plan.
    Fixed schema diff owner related issue.
    Fixed an issue where referenced table drop-down should be disabled in foreign key -> columns after one row is added.
    Ensure that sort order should be maintained when renaming a server group.
    Fixed schema diff related some issues.
    Ensure that the user should be allowed to set the schema of an extension while creating it.
    Increase the width of the scrollbars.
    Fixed an issue where the user can’t debug function with timestamp parameter.
    Fixed an issue where the Change Password menu option is missing for internal authentication source when more than one authentication source is defined.
    Fixed an issue where On-demand rows throw an error when any row cell is edited and saved it then scroll to get more rows.
    Ensure that Python 3.10 and the latest eventlet dependency should not break the application.
    Fix an RPM build issue that could lead to a conflict with python3 at installation.
    Fixed an issue where the error is thrown while creating a new server using Add New Server from the dashboard while tree item is not selected.
    Ensure that statue message should not hide the last line of messages when running a long query.
    Fixed an issue where reverse engineering SQL is wrong for Aggregate.
    Correct the SQL definition for function/procedure with the Atomic keyword in PG14.
    Fixed an issue where SQLite database definition is wrong because the USER_ID FK references the table user_old which is not available.
    Add “section” to the Debian package control files.
    Update the dropzone version to 5.9.3 and Flask-SQLAlchemy to 2.5.*.
    Fixed some accessibility issues.
    Fixed unhashable type issue while opening the about dialog.
    Ensure that the Owner should not be disabled while creating the procedure.
    Fixed an issue where confirmation pop-up is hidden behind Reassign/Drop Owned Dialog.

[close]

https://www.pgadmin.org/

[SiLæncer]

Thoroughly organize, analyze and share large datasets with the help of this open-source and quite good-looking piece of software.

License: GPLv3

Changelog

    Bug fixes;

    Upgrade Log4j to 2.16.0 (#19371) - this addresses CVE-2021-45046
    XLSX export does not respect "Separator style" (#19006)
    One cannot change any of the LDAP Settings once it's been initially setup (#18936)
    Custom Expression coalesce is using wrong field reference when nested query (#18513)
    Custom Expression case is using wrong field reference when nested query (#17512)
    Dashboard causes permission error, when "Click Behavior" linking to dashboard/question without access (#15368)
    Site URL validation too strict, doesn't accept underscore (#14491)
    Reverse proxy reset email should use site URL in email body and not localhost (#14028)

[close]

https://www.metabase.com/

[SiLæncer]

Powerful and versatile relational database system that provides a variety of ANSI SQL standard features and cross-platform support.

License: GPL

Changelog

    Improvements:

    6910 — Add way to retrieve statement BLR with Statement::getInfo() and ISQL’s SET EXEC_PATH_DISPLAY BLR.
    6959 — Add getInfo() method to the Batch interface in the API.
    6954 — Add fb_info_protocol_version information request to Attachment::getInfo().
    6929 — Add support of PKCS v.1.5 padding to RSA functions, needed for backward compatibility with old systems.
    6915 — Allow attribute DISABLE-COMPRESSIONS in UNICODE collations.
    6903 — Make it possible to create ICU-based collations with locales keywords.
    6872 — Faster indexed STARTING WITH execution with UNICODE collations.
    6810 — Use precise limit of salt length when signing messages and verifying the sign.
    6809 — Integer hex-literal support for INT128.

    Bug Fixes:

    Core Engine:

    7070 — Error "BLOB is not found" while replication converts INSERT into UPDATE for a conflicting record.
    7064 — Linear regression functions aren’t implemented correctly.
    7062 — Creation of expression index does not release its statement correctly.
    7057 — Client-side positioned updates work wrongly with scrollable cursors.
    7056 — Fetching from a scrollable cursor may overwrite user-specified buffer and corrupt memory.
    7052 — Races between transactions on the primary side may cause update conflicts while applying journals to the replica.
    7048 — Incorrect releasing of user savepoint (older savepoints become inaccessible).
    7043 — Wrong message when user has no access to /tmp/firebird.
    7033 — Replicator is missing sanity checks for user-supplied blocks.
    6998 — Problems with access to RDB$CONFIG table for non-privileged user when he has grant on execution of stored procedure which has necessary access rights (created by SYSDBA with SQL DEFINER clause).
    6995 — "String truncation error" is raised while restoring the database from a v2.5 backup.
    6989 — Invalid message in replication.log (and possibly crash in the case of synchronous replication) when the target DB has no "replica" flag set.
    6976 — Lack of proper clean up after failure to initialize shared memory.
    6963 — The REFERENCES permission does not work.
    6955 — fb_info_creation_timestamp_tz returns a corrupted buffer.
    6935 — SQL SECURITY DEFINER has inconsistent behaviour if the object owner is non-privileged.
    6935 — SQL SECURITY DEFINER does not affect the ownership of created DDL objects.
    6907 — Failed DDL commands can be replicated.
    6900 — IBatch::add() method fails silently when a memory limit is exceeded.
    6893 — Problem with replication of BLOB segments longer than 32KB.
    6887 — Invalid SIMILAR TO patterns may lead memory read beyond string limits.
    6886 — Differerent interfaces behaviour depending upon source of interface.
    6887 — Significant performance regression of SIMILAR TO and SUBSTRING(SIMILAR) when pattern is taken from a variable.
    6874 — Literal 65536 (interpreted as int) cannot be multiplied by itself without cast if result is more than 2^63-1.
    6860 — Create user statement fails with SQLSTATE = HY000 when using DataTypeCompatibility setting.
    6856 — Permission error after replication of DDL commands.
    6853 — Asynchronous replication leaks file handles.
    6850 — Database-level and DDL triggers are executed at the replica side.
    6849 — Conflicting INSERT propagated into a read-write replica may cause duplicate records to appear (and PK/UK violation to happen).
    6848 — Generator values may not replicate after commit.
    6845 — Result type of AVG over BIGINT column results in type INT128.
    6838 — Deleting multiple rows from a view with triggers may cause triggers to fire just once.
    6801 — Error recompiling a package with some combination of nested functions.
    Server Crashes/Hang-ups
    7067 — Deadlock when using not initialized security database.
    7060 — Deadlock when execute test for CORE-4337.
    7034 — Server crashes while fetching from a scrollable cursor in PSQL.
    7018 — Crashes or incorrect results for some windows frames.
    7015 — Replication applier code may crash if the specified block contains no savepoint operations.
    6985 — Application could hang when using new Batch API with blobs over XNET.
    6975 — Crash or hang while shutting down the replica database if segments are being applied.
    6945 — Segfault in the batch interface when gbak restores a database with many blobs over the wire.
    6930 — Segfault when calling cryptographic functions.
    6913 — Buffer overflows in getInfo() APIs.
    6909 — Some updates may crash Firebird server on the replica side.
    6832 — Segfault when using COMMIT RETAINING with Global Temporary Tables.

    API/Remote Interface:

    7068 — Errors in the ChaCha plugin are displayed incorrectly.
    7066 — Server may send incorrect specific data to client when establishing encrypted connection.
    7065 — Connection hangs after delivery of 256GB of data.

    Windows Only:

    6968 — On Windows, engine may hang when works with corrupted database and read after the end of file.

    Builds:

    7037 — Build problem when using both --with-builtin-tommath and --with-builtin-tomcrypt.
    6978 — Firebird 4 fails to build on big-endian platforms.

    Installation Issues:

    6979 — Windows x64 server installer installs an incomplete x86 client.
    6943 — Windows client install is missing some DLLs.
    6917 — Firebird 4 installer asks for SYSDBA password when doing client installation.

[close]

http://www.firebirdsql.org/en/start/

[SiLæncer]

Changelog

    Data editor:

        Auto-completion was fixed in filters panel
        XML auto-format was fixed (elements sort was disabled)
        Filter by column with alias was fixed
        Numeric type transformer was fixed
        Extra tab close action were added (close to the left/right)
        Arrays presentation in record view was fixed
    Files drag-n-drop (between DBeaver and OS file explorer) support was added in the project explorer
    SQL editor: "hippie" auto-completion support was added (beta)
    SSHJ implementation now included in DBeaver Community by default
    Problem with DBeaver crash was fixed (when workspace path contains spaces)

    Driver management:

        New Java11 modules were added to support new JDBC drivers (java.net.http)
        Drivers copying was fixed (keep advanced driver settings)
        Maven artifacts edit dialog was fixed

    Data transfer:

        CSV parser performance was significantly improved
        Identifiers case configuration was added in SQL export format
        Option to append results to an existing file was added
        Date formatting was fixed for JSON format
        Variables support in saved tasks was fixed
        Support of arrays import from CSV was added
        Problem with export wizard buttons enablement was fixed
    Session manager: column grouping was added
    Command line support: default connection now set for opened SQL scripts
    SalesForce driver was added
    AWS Athena: driver version was updated, problem with column filters was resolved

    Babelfish:

        Synonyms, sequences and triggers were removed from metadata navigator
        Cross-database access was disabled, only default database is visible
    Clickhouse: typed arrays support was added
    Derby: check constraints support for remote server driver was fixed
    SAP HANA: public schema presentation was changed (thanks to @kai-morich)
    SQL Server: external tables support was added

[close]

https://dbeaver.io/

[SiLæncer]

Changelog

    Fix a bug introduced by the UPSERT enhancements of version 3.35.0 that can cause incorrect byte-code to be generated for some obscure but valid SQL, possibly resulting in a NULL-pointer dereference.
    Fix an OOB read that can occur in FTS5 when reading corrupt database files.
    Improved robustness of the --safe option in the CLI.
    Other minor fixes to assert() statements and test cases.

[close]

https://www.sqlite.org/

[SiLæncer]

Whats new:>>

    Comprehensive redesign and modernization of the entire user interface.
    "FlatLaf" Look&Feel is now the default. https://github.com/JFormDesigner/FlatLaf

http://jailer.sourceforge.net/

[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

    Object Explorer:

    Add: Add to get the [Data table and view table] data row count (Getting table/view rows count: {*}) (8038)
    Add: Table and View objects list: Add sub-option [GET] to get all objects Rows Count message (8038)
    Upd: Table and View objects list: Rewrite to greatly improve processing efficiency (8038)
    Add: Connection Explorer: Added Last Accessed Time display to connection items (8038)
    Add: Code Manager: Add Last Modified Time display to document items (8038)
    Upd: RowCount/Comment and other information in the title bar of the table object, support cache processing (8038)

    Main program update (Main):

    Add: (SQL Server/SQL Azure) Supports Microsoft.Data.SqlClient/System.Data.SqlClient dual data provider processing at the same time (8038)
    Fix: (SQL Server/SQL Azure) Fix InfoMessage event removal problem (8038)
    Upd: Solve the problem that MariaDB 10.6+ default utf8mb3 can not connect normally (8038)
    Add: Support MariaDB 10.7+ to add UUID data type (8038)
    Fix: Fix (7943) the problem that caused the original connection [last access time] settings to lose update (8038)
    Upd: Improve the opening speed between different versions of the file type database (8038)
    Upd: Improve the processing of the single browse field of the right-click menu, automatically exclude data types that cannot be GROUP BY (8038)
    Fix: (IBM DB2) Fix the version display problem (8038)
    Upd: Multiple improvements in the display interface and user experience (8038)
    Upd: Transaction Mode: Update the initial command processing method (8038)
    Upd: IBM DB2/Informix component version updated to IBM.Data.DB2.dll 9.7.4.4 (11.5.7000.4) (2021/12/08)(8038)
    Misc: (IBM DB2/Informix) IBM Data Server Client Packages Version 11.5.7 FP0 (2021/12/08)
    Upd: Others include cumulative minor updates, corrections and optimization processing (8038)

    Query Tabs:

    Upd: Optimize the processing speed of opening and closing tabs (8038)
    Fix: Fix the problem of title name change (8038)

    AutoComplete and IntelliSense:

    Upd: Optimized completion mode (Completion Mode) processing method (8038)

    PrimaryKey Selector:

    Fix: (SQLCe 3.1/OleDB/ODBC) Fix the database type without the top n keyword processing (including related functions) (8038)

    Database Migration (Pro):

    Upd: All updates are the same as dbMigration .NET software (8038)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

    ADDED: #220 functions, materialized views and stored procedures in code completion
    ADDED: Query result in statusbar
    ADDED: Highlight and execute current query
    CHANGED: Code completion offers objects only from current query
    CHANGED: Big optimalizations of electron app - removed embedded web server, removed remote module, updated electron to version 13
    CHANGED: Removed dependency to electron-store module
    FIXED: #201 fixed database URL definition, when running from Docvker container
    FIXED: #192 Docker container stops in 1 second, ability to stop container with Ctrl+C
    CHANGED: Web app - websocket replaced with SSE technology
    CHANGED: Changed tab order, tabs are ordered by creation time
    ADDED: Reorder tabs with drag & drop
    CHANGED: Collapse left column in datagrid - removed from settings, remember last used state
    ADDED: Ability to select multiple columns in column manager in datagrid + copy column names
    ADDED: Show used filters in left datagrid column
    FIXED: Fixed delete dependency cycle detection (delete didn’t work for some tables)

[close]

https://github.com/dbgate/dbgate

[SiLæncer]

Changelog

    Fix a bug introduced in version 3.35.0 (2021-03-12) that can cause database corruption if a SAVEPOINT is rolled back, other changes are made, and the outer transaction commits.
    Fix a long-standing problem with ON DELETE CASCADE and ON UPDATE CASCADE in which a cache of the bytecode used to implement the cascading change was not being reset following a local DDL change.
    Other minor fixes that should not impact production builds.

[close]

https://www.sqlite.org/

[SiLæncer]

Whats new:>>

    FIXED: MongoId detection
    FIXED: #203 disabled spellchecker
    FIXED: Prevented display filters in form view twice
    FIXED: Query designer fixes

https://github.com/dbgate/dbgate

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

+ Improved: look and feel
+ Added: New themes Office 2016 White, Office 2016 Gray and Office 2016 Black

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

[SiLæncer]

Changelog

    New features:

    Issue #4803 - Added support to import/export server groups and servers from GUI.

    Housekeeping:

    Issue #7018 - Port Restore dialog to React.
    Issue #7019 - Port Maintenance dialog to React.

    Bug fixes:

    Issue #6745 - Fixed an issue where Tablespace is created though an error is shown on the dialog.
    Issue #7003 - Fixed an issue where Explain Analyze shows negative exclusive time.
    Issue #7034 - Fixed an issue where Columns with default value not showing when adding a new row.
    Issue #7075 - Ensure that help should be visible properly for Procedures.
    Issue #7077 - Fixed an issue where the Owner is not displayed in the reverse engineering SQL for Procedures.
    Issue #7078 - Fixed an issue where an operation error message pop up showing the database object’s name incorrectly.
    Issue #7081 - Fixed an issue in SQL generation for PostgreSQL-14 functions.
    Issue #7093 - Fixed an issue where SubPlans may overlap other nodes & make them inaccessible in Graphical EXPLAIN View.
    Issue #7096 - Ensure that Truncate and Reset statistics should work.
    Issue #7102 - Fixed a schema diff issue where generated script adds unwanted line endings for Functions/Procedures/Trigger Functions.

[close]

https://www.pgadmin.org/