Thema: Datenbanksoftware und Tools diverses ...

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

    A potential connection leak has been fixed.
    Some UI improvements.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

    Fix for "Ignore generated columns when export data".
    Fix for "liquibase.exception.MigrationFailedException when importing generated XML files with dates".

http://jailer.sourceforge.net/

[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: Optimalized load DB structure for PostgreSQL #451
    ADDED: Auto-closing query connections after configurable (15 minutes default) no-activity interval #468
    ADDED: Set application-name connection parameter (for PostgreSQL and MS SQL) for easier identifying of DbGate connections
    ADDED: Filters supports binary IDs #467
    FIXED: Ctrl+Tab works (switching tabs) #457
    FIXED: Format code supports non-standard letters #450
    ADDED: New logging system, log to file, ability to reduce logging #360 (using https://www.npmjs.com/package/pinomin)
    FIXED: crash on Windows and Mac after system goes in suspend mode #458
    ADDED: dbmodel standalone NPM package (https://www.npmjs.com/package/dbmodel) - deploy database via commandline tool

[close]

https://github.com/dbgate/dbgate

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

    Ability to create a primary key when exporting a table to SQL and Database destination formats.
    Ability to specify column descriptions when exporting a table to SQL and Database destination formats (when the target database type is Oracle or PostgreSQL).
    Minor interface improvements and bug fixes.

http://www.vlsoftware.net/

[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

    Redshift: triggers DDL reading was fixed
    Snowflake: table constraints reading was fixed
    We switched to Java 17 so now DBeaver supports all newest JDBC drivers
    ChatGPT integration for smart completion and code generation (as optional extension)
    Database navigator: issue with rename/refresh was resolved
    Dashboards were fixed for inherited databases
    Project import now sets DBeaver nature (thanks to @froque
    ERD: custom diagram editor was fixed (issue wth missing notes and connections was resolved)
    Databricks: table DDL reading was fixed, extra SQL keywords were added (thanks to @mixam24)
    DB2 BigSQL: table with RID_BIT columns data reading was fixed (thanks to @bkyle)
    MySQL: numeric identifiers quoting was fixed
    Netezza: tables/views search query was improved

    Accessibility:

    Text reader for entity editor was improved
    Text reader for data grid was improved

    SQL editor:

    Query generation from human language text was added
    Server output log levels configuration was improved
    Global metadata search was fixed
    Variables resolution is fixed in strings and comments
    Issue with queries with invalid line feeds was resolved

    Data editor:

    Grouping panel messages were improved
    Datetime calendar editor was fixed (in panel and inline editor)

    PostgreSQL:

    Procedures invocation was improved (thanks to @plotn)
    Filter by enum was fixed (thanks to @plotn)

[close]

https://dbeaver.io/

[SiLæncer]

Whats new:>>

    Added a context menu to the database connection navigation tree.
    Using "New Window" menu item now restores table-arrangement of original browser.
    Improved responsiveness of the user interface.

http://jailer.sourceforge.net/

[SiLæncer]

Release Notes

    Some highlights include:

    issue #17506 Fix error when configuring 2FA without XMLWriter or Imagick
    issue #17519 Fix Export pages not working in certain conditions
    issue #17121 Fix password_hash function incorrectly adding single quotes to password before hashing
    issue #17736 Add utf8mb3 as an alias of utf8 on the charset description page
    issue #17248 Support the UUID data type for MariaDB >= 10.7
    issue #16042 Fixes malformed downloads when using gzip compression type and FireFox browser
    Add `spellcheck="false"` to all password fields and some text fields to avoid spell-jacking data leaks
    Fixes for JavaScript errors when using Designer
    Fixes for PHP 8.2 compatibility

[close]

https://www.phpmyadmin.net/

[SiLæncer]

Whats new:>>

In rare cases, an error message appeared after exporting, indicating an alleged discrepancy between the number of exported rows and the collected ones (false positive). This error has been corrected.

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

Supported Database Servers

PostgreSQL: 10, 11, 12, 13, 14 and 15

EDB Advanced Server: 10, 11, 12, 13, 14 and 15

Bundled PostgreSQL Utilities

psql, pg_dump, pg_dumpall, pg_restore: 15.1

New features

    Issue #4728 - Added support for setting PostgreSQL connection parameters.

Housekeeping

    Issue #4320 - Added bundled PG utilities in the release note.
    Issue #5525 - Upgrade Flask-Migrate to 4.x.
    Issue #5723 - Improve performance by removing signal-based zoom-in, zoom-out, etc functionality from the runtime environment.
    Issue #5794 - Use uplot for Dashboard graphs to reduce CPU usage.

Bug fixes¶

    Issue #5532 - Fixed an issue where the client cert location was not stored on the shared servers.
    Issue #5567 - Fix orphan database connections resulting in an inability to connect to databases.
    Issue #5702 - Fix an issue where role is used as username for newly added servers when opening query tool.
    Issue #5705 - Ensure that all parts of the application recommend and enforce the same length of passwords.
    Issue #5732 - Fixed an issue where Kerberos authentication to the server is not imported/exported.
    Issue #5733 - Ensure that the system columns should not visible in the import/export data.
    Issue #5746 - Increase the length of the value column of the setting table.
    Issue #5748 - Fixed console error while attaching the partition.
    Issue #5751 - Fix failing import servers CLI due to vulnerability fix.
    Issue #5761 - Fix an issue where drag and drop object names is not working.
    Issue #5763 - Ensure that keyboard hotkey to open query tool and search object should work properly.
    Issue #5781 - Fixed an issue where Query history is not getting loaded with external database.
    Issue #5796 - Ensure nested menu items are shown in quick search result.

[close]

https://www.pgadmin.org/

[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

    Main program update (Main):

    Upd: Support the latest version of MariaDB 10.10+ Database: Solve the compatibility problem caused by the new code (8447)
    Upd: If the Server Compatibility Mode=Redshift attribute is not specified when connecting to Redshift, it will automatically add processing (8447)
    Fix: Fix the problem that if the loading of objects fails after the connection is successful, the processing cannot continue (8447)
    Upd: Improve database message content display (8447)
    Upd: Improve error message content display (8447)
    Upd: SSH: Secure Shell component updated to Renci.SshNet.dll 2020.0.2 (2022/05/29)(8447)
    Upd: SQL Server/SQL Azure component version updated to Microsoft.Data.SqlClient 5.1.0 (2023/01/20)()(8447)
    Upd: Firebird component version updated to FirebirdSql.Data.FirebirdClient 9.1.1.0 (2023/01/17)()(8447)
    Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 21.9.0 (2023/01/11)()(8447)
    Upd: Others include cumulative minor updates, corrections and optimizations (8447)

    - Data Editor:

    Fix: After manually clearing the content of the data grid, the error that the display is still NULL (8447)
    Fix: Solve the problem that the content of ENUM data type may not be updated (8447)

    - Database Migration (Pro):

    Upd: All updates same as dbMigration .NET software (8447)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

    ChatGPT smart completion:

    Completion popup UI was improved
    Metadata scope configuration was added
    Redundant config options wer removed

    Data editor:

    Accessibility support was significantly improved (context menu, additional keyboard shortcuts)
    Filtering and ordering icons visibility configuration was added again
    Dictionary viewer was fixed (issue with missing dictionary values)
    “Save filters” button was removed from custom SQL queries results
    App crash on geometry viewer opening was resolved in the latest version of MacOS
    SQL editor: query text extraction was fixed (issue with trailing comment after query text)
    Database backup/restore: issue with external tools running was resolved (Linux)
    Application fonts were unified. Now we have only Main and Monospace fonts configuration
    Data transfer: data type mapping now respects type name case (for databases with different default case)
    Variables support in database tasks was fixed
    Database tools wizard: redundant task configuration page was removed
    SQL generator dialog now show progress to avoid UI freeze on big schemas
    Issue with opening ERD files from disk ws resolved
    Clickhouse: DDL for array columns was fixed
    Databricks: additional metadata was added
    Exasol: default connection parameters were updated (thanks to @allipatev)
    IRIS (ex Cache): driver version was updated
    Oracle: stored procedures invocation syntax was improved
    Snowflake: driver now uses single database connection for all editors (configurable)

    SQL Server:

    Driver version was updated to 11.2.3. Trust server certificate option was moved to the main connection page
    Server messages (printed on raiserror) reading was fixed
    Multiple resultsets reading was fixed (extra error handling was added)
    VARCHAR(MAX) data type support was added
    SQLite: converting binary columns into string representation was fixed

[close]

https://dbeaver.io/

[SiLæncer]

Whats new:>>

When a column filter is defined in the SQL query results window, the query in the console is augmented with the corresponding "where" condition.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

    Query planner improvements:

    Make use of indexed expressions within an aggregate query that includes a GROUP BY clause.
    The query planner has improved awareness of when an index is a covering index and adjusts predicted runtimes accordingly.
    The query planner is more aggressive about using co-routines rather than materializing subqueries and views.
    Queries against the built-in table-valued functions json_tree() and json_each() will now usually treat "ORDER BY rowid" as a no-op.
    Enhance the ability of the query planner to use indexed expressions even if the expression has been modified by the constant-propagation optimization. (See forum thread 0a539c7.)
    Add the built-in unhex() SQL function.
    Add the base64 and base85 application-defined functions as an extension and include that extension in the CLI.
    Add the sqlite3_stmt_scanstatus_v2() interface. (This interface is only available if SQLite is compiled using SQLITE_ENABLE_STMT_SCANSTATUS.)
    In-memory databases created using sqlite3_deserialize() now report their filename as an empty string, not as 'x'.

    Changes to the CLI:

    Add the new base64() and base85() SQL functions
    Enhanced EXPLAIN QUERY PLAN output using the new sqlite3_stmt_scanstatus_v2() interface when compiled using SQLITE_ENABLE_STMT_SCANSTATUS.
    The ".scanstats est" command provides query planner estimates in profiles.
    The continuation prompt indicates if the input is currently inside of a string literal, identifier literal, comment, trigger definition, etc.
    Enhance the --safe command-line option to disallow dangerous SQL functions.
    The double-quoted string misfeature is now disabled by default for CLI builds. Legacy use cases can reenable the misfeature at run-time using the ".dbconfig dqs_dml on" and ".dbconfig dqs_ddl on" commands.
    Enhance the PRAGMA integrity_check command so that it detects when text strings in a table are equivalent to but not byte-for-byte identical to the same strings in the index.
    Enhance the carray table-valued function so that it is able to bind an array of BLOB objects.
    Added the sqlite3_is_interrupted() interface.
    Long-running calls to sqlite3_prepare() and similar now invoke the progress handler callback and react to sqlite3_interrupt().
    The sqlite3_vtab_in_first() and sqlite3_vtab_in_next() functions are enhanced so that they reliably detect if they are invoked on a parameter that was not selected for multi-value IN processing using sqlite3_vtab_in(). They return SQLITE_ERROR instead of SQLITE_MISUSE in this case.
    The parser now ignores excess parentheses around a subquery on the right-hand side of an IN operator, so that SQLite now works the same as PostgreSQL in this regard. Formerly, SQLite treated the subquery as an expression with an implied "LIMIT 1".
    Added the SQLITE_FCNTL_RESET_CACHE option to the sqlite3_file_control() API.

    Makefile improvements:

    The new makefile target "sqlite3r.c" builds an amalgamation that includes the recovery extension.
    New makefile targets "devtest" and "releasetest" for running a quick developmental test prior to doing a check-in and for doing a full release test, respectively.
    Miscellaneous performance enhancements.

[close]

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

[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

    Enhancements:

    Send "threads blocked" via Prometheus exporter (#28014)
    Make educational messaging in native questions less distracting (#27797)
    Fix "Powered by Metabase" badge partially invisible with transparent theme (#27796)

    Bug fixes:

    Pre-existing category filters were not migrated to new ones (#27393)
    Doing "Zoom in" from dashboard drops fields from joined tables (#27380)
    Links for the IDs are showing wrong objects when table join is in place (#27094)
    Column filters not working on Questions using custom columns (#25927)
    Drill-through to questions with add columns (implicit join) causes no filtering to be defined (#23293)
    Data selector not working in FullApp embedding if going directly from location that hasn't loaded /api/database yet (#21511)

[close]

https://www.metabase.com/

[SiLæncer]

Whats new:>>

    The estimation of table sizes could be significantly improved by using row counts from statements and queries.
    The table sizes are now displayed in a better quality.

http://jailer.sourceforge.net/