Thema: Datenbanksoftware und Tools diverses ...

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

    Fix not sending necessary HTTP headers when downloading results (#41633)
    Fix invisible user items in search filters (#41604)
    docs - add redshift to list of dbs that support uploads (#41594)
    Fix Embedded dashboard parameters parse runtime error (#41545)
    Links to metabase URLs should open in the same window in link cards (#41508)

    Bug fixes:

    Date format "January 31, 2018" missing day in csv download (#41639)
    Default (formatted) CSV Export Returns "Week #" instead of Date (#41492)
    Leading zero in filter value in embedded dashboard breaks it (#41483)
    Archived models continue to be cached (#41318)
    Migration doesn't like rows with null characters (#40835)
    Primary Key missing filter options (#40665)
    If a user is a member of multiple groups in the IdP, the user property is comma separated and we default to "all users" (#40517)
    Date Filtering Bug in v0.49.1 Docker Image with Japanese Locale Settings (#40493)
    Metabase renders the result but the query does not finish in the DB (#39018)
    Illegal hex characters in escape (%) pattern - error at index 0 in: R6 (#38966)
    Cannot connect to new MongoDB source or sync existing databases (#38013)
    Overall link situation (#30891)

[close]

https://www.metabase.com/

[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 Issue 113: "Liquibase exception: Invalid string encoding on column.remarks."
    The "Generate DDL" feature now also allows the optional generation of "Drop..." statements.

http://jailer.sourceforge.net/

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

    Better choosing target attributes when exporting data to SQLite databases. [Pro and Enterprise editions]
    Fixed a bug with exporting Unicode characters to databases in memory saving mode. [Pro and Enterprise editions]
    New connection parameters for Interbase and SQLite databases using FD interface. [Enterprise edition]
    Minor changes.

http://www.vlsoftware.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:

    Issue #6728 - Added the new columns “last_seq_scan” and “last_idx_scan” from the pg_stat_all_tables and pg_stat_all_indexes tables respectively to the Statistics tab.
    Issue #7163 - Added support for excluding multiple tables while taking Backup.

    Housekeeping:

    Issue #7213 - Update UI library MUI from v4 to v5, more details here
    Issue #7362 - Upgraded Flask, Flask-Security-Too, Werkzeug, and other dependencies, ensuring compatibility with Python 3.7.

    Bug fixes:

    Issue #2410 - Fixed all input boxes in pgAdmin to show browser auto-fill only where it is relevant.
    Issue #7173 - Install dbus-python, an in-direct dependency of the Keyring package as a system package for Debian platforms.
    Issue #7275 - Fixed an issue where debugger was not scrolling automatically on stepping.
    Issue #7282 - Fixed an XSS vulnerability in the /settings/store endpoint (CVE-2024-4216).
    Issue #7294 - Fixed an issue where double dollar quoted code is treated as string in syntax highlighter.
    Issue #7317 - Fixed an issue where pressing backspace should remove the spaces and not the entire tab width, on enabling ‘Use spaces?’ in the preferences.
    Issue #7334 - Fixed an issue where incorrect select/exec scripts were generated for functions/procedures.
    Issue #7372 - Fixed an issue where connection to the database is not automatically re-established after connectivity drop.
    Issue #7384 - Fixed an issue when closing the view data second tab; it raises the error that the ‘ViewCommand’ object has no attribute ‘auto_commit’.
    Issue #7390 - Fixed violates check constraint issue when creating a pgAgent schedule.
    Issue #7425 - Fixed Multi-Factor Authentication bypass vulnerability (CVE-2024-4215).

[close]

https://www.pgadmin.org/

[SiLæncer]

Changelog

    Enhancements:

    Faster driver/describe-database for Redshift
    Support SAML and JWT logins at the same time

    Bug fixes:

    Snowflake temporal extract operators like hour-of-day do not respect report timezone
    Slack integration uses a deprecated API
    Snowflake always returns times truncated second precision, we should fix this for tests
    Snowflake UNIX timestamps interpreted as being in report timezone rather than UTC
    Issues connecting to Snowflake using RSA Keypair Authentication
    Fix queries being re-run because of broken parameters comparison
    Date format "January 31, 2018" missing day in CSV download
    Uploaded model not showing latest rows appended to the underlying table
    Serialization import should not fail on hidden .yaml files
    Default (formatted) CSV Export Returns "Week #" instead of Date
    Admin checklist indicates more progress than actual due to audit items
    Date Filtering Bug in 49.1 Docker Image with Japanese Locale Settings
    Switching between tabs reruns queries even if filters are not modified
    Google SSO with Interactive Embedding does not allow you to download CSV
    Filtering by a Specific Date in Snowflake will bring inaccurate results
    Use scientific notation on frontend multipliers
    Data mismatch between custom question and raw sql query with Redshift
    Quarterly Date Filter different on Dashboard than on Question
    Snowflake JDBC driver incorrectly converts JDBC dates with a timezone

[close]

https://www.metabase.com/

[SiLæncer]

Whats new:>>

    Enhancements of feature "Exporting SQL including creation of DB schema" #111
    Simplification of the database connection dialogs.

http://jailer.sourceforge.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

    SQL Editor:
        Smart mode for Blank line is statement delimiter setting was fixed
        Vertical button alignment was fixed
    ER Diagrams: Keep layout selection was fixed
    Data transfer:
        Import from CSV with duplicated columns names was fixed
        Parallel data transfer monitoring/cancellation were fixed
    Dashboards:
        Ability to drag and drop charts to another dashboard was added
        Number of minor UI improvements were added
    Connectivity:
        SSH parameters validation on the Connection page was added
        Editing of ‘Local host’ and ‘Remote host’ fields in the Port Forwarding section was fixed
        Database connection timeout notification was fixed
    Development: Redundant tests were disabled
    Databases:
        MariaDB:
            GRANT OPTION privilege persistence was fixed
            Schema privileges representation was fixed
        SQL Server: trigger deletion was fixed
        Teradata: link to the referenced table in the Metadata editor was added
    Localization: French translation was updated (thanks to @Jean-BaptisteC)
    General:
        Language configuration in Windows installer was fixed
        We have migrated to Eclipse 2024/06

[close]

https://dbeaver.io/

[SiLæncer]

Changelog

    Enhancements:

    Adds Key Authentication Option to SSH Tunneling Docs (#42206)
    Allow drivers to not automatically add a PK column for CSV uploads (#42359)
    Upgrade Redshift driver to v26 (#42450)
    Allow using urls from other columns in link templates (#42438)
    Misc documentation improvements

    Bug fixes:

    Async streaming response error when Jetty SSL enabled (#13771, #15806)
    Embedding preview not behaving like Metabase Application when filter is locked and linked (#41635)
    Overflow problem in filter modal sidebar (#42386)
    Upgrade failing from instance using outdated 3rd party drivers (#42319)
    Unable to sync dynamic tables in Snowflake (#42312)
    Azure AD SAML and SLO logout error (#41600)
    Bigquery unable to sync materialized views (#42008)
    Unable to filter on IDs identified as primary key in Mongo (#42010, #40770)
    Fix MySQL with multiple most recent revision (#41374)

[close]

https://www.metabase.com/

[SiLæncer]

Whats new:>>

DDL generation has been integrated into the SQL console.

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

- Main program update ( Main):
   Add:Supports the latest version of Oracle 23ai database system (8897)
      ?? vector and boolean types...etc.
   Add:Support CockroachDB database (PostgreSQL compatible) (8897)
   Upd:Improve control asynchronous processing problem (8897)
   Fix:Fixed the problem that Oracle cannot execute parsing query in non-transaction mode (Parse Query: Ctrl + F5 (8897)
   Add:Support Oracle native asynchronous processing (Asynchronous Processing) (8897)
   Upd:Updated the method of obtaining MySQL/MariaDB database version number to resolve compatibility issues (8897)
   Upd:Oracle component version updated to Oracle.ManagedDataAccess.dll 23.4.0 (2024/05/03)( )(8897)
   Upd:PostgreSQL component version updated to Npgsql 7.0.7 (2024/05/09)( )(8897)
   Upd:Secure Shell Protocol ( SSH: Secure Shell) component updated to Renci.SshNet.dll 2024.0.0 (2024/02/22)(8897)
   Upd:Others include cumulative minor updates, corrections and optimizations (8897)
- Written execution plan ( Plain Execution Plan):
   Fix:Fixed the problem that Access cannot be processed normally in the latest operating environment (8897)
- Database Tools:
   Add:Support VistaDB 6 database backup and restore (8897)
- Data import ( Data Import):
   Add:Added import settings button to taskbar (8897)
   Add:Add preview mode settings (8897)
- Data column browsing and editing (Data Browser and Editor):
   Add:Copy option adds a field to include data types (Copy with Types)(8897)
- Connection Manager ( Connection Manager)
   Upd:Search processing exclude path names (8897)
- Database migration ( Database Migration)(Pro):
   Upd:All updates are the same as dbMigration .NET Software(8897)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

    Enhancements:

    Allow disabling /api/health logging via env var (#35338)
    Documentation improvements (#42481, #42485, #42488, #42492, #42490, #42439, #42522)

    Bug fixes:

    Cannot import dashboards with circular click behavior (#38665)
    Pie chart tooltip "Other" group produces NaN% (#42458)
    Pie chart sometimes disappears when switching from notebook editor (#42367)
    Columns excluded from the unformatted option when downloading (#42500)

[close]

https://www.metabase.com/

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

    Issue #1946: update libmariadb.dll and plugin libraries to latest v3.3.8
    Update regular expression library to v1.181 2023.11.22, supporting \K pattern to set the begin of a reported match.
    Update InnoSetup compiler to v6.2.2
    Update VirtualTrees component code to release v8.0.3 (major version update)
    Issue #1888: Update plink executables to v0.81
    Update madExcept exception handler to v5.1.4
    Issue #1905: Update OpenSSL libraries used by libpq-15.dll to v3.1.5
    Update SQLite libraries to v3.45.3 from 2024-04-15

New stuff:

    Issue #1879: add drop down menu to "Apply filter" button, with an option to overwrite the current filter based on the different input text
    Issue #1512: add basic support for indexes with descending column direction
    Issue #1429: add "SQL INSERT IGNORE" output format to grid export dialog
    Issue #178: add database and table filter boxes above tree view on table tools dialog
    Issue #1917: Support additional UCA collations introduced in MariaDB 10.10.1.
    Issue #1927: display column comments in completion proposal, give that third column more space to the left and italic style
    Table editor: when user runs into the cryptic "constraint is incorrectly formed" message, append a more meaningful line from SHOW ENGINE INNODB STATUS.
    Support naming result tabs per "-- name: xyz" comment. See https://www.heidisql.com/forum.php?t=10493
    Reorder components in grid export dialog, and convert format radio buttons to combobox. Makes the dialog more wide than high, creating space for wider labels and more format options.
    Issue #1930: Grid export: implement JSON Lines format.
    Issue #139: Alternating row background colors in table columns list and most other main tabs, if activated by user.

Bugfixes and enhancements:

    Enhance readability of focused text in result grid using dark styles. TreeOptions.PaintOptions.toGhostedIfUnfocused grays out text otherwise.
    Fix crash in SynCompletionProposalChange, happening when scrolling very fast to the top of the list
    Fix crash in f_() function with invalid format specifiers from some translation. Happened in Japanese recently.
    Issue #1870: support VARCHAR columns with a length of 0, in temporary fake tables for exporting views
    Detect Windows 11 in about dialog, and remove functions only required for the no longer supported Windows Store version
    Fix activated SSH tunnel for a network type which does not support that, after changing the network type from an explicit SSH-tunnel-type to a TCP/IP version.
    Search replace: ignore numbers in static row id column
    Installer: add newly available translations for Hungarian and Bulgarian
    Add item in Tools main menu for resetting panels to their default dimensions. Useful for quite a few people who move their app window between screens with different resolutions.
    Static row id: always use the color of the session the result belongs to
    Performance: call TimerHostUptimeTimer event every 20 seconds only, instead of each second
    SQL export dialog: cut long file list down to 20 latest items
    Issue #520: Fix crash in sort columns dialog when removing the last column, with a non-default theme
    After reformatting SQL code, unify new lines to Windows line feeds, so the selection's end in SynMemo is correct
    Fix retrieving MySQL events from the current database on older servers, work around MySQL bug 41907. See https://bugs.mysql.com/bug.php?id=41907#c360194
    Make pressed state of favorites button more noticeable, by using the gray-scale icon in unpressed state
    Fix emptied "SHOW WARNINGS" pool due to queried @max_error_count in warning dialog. See https://www.heidisql.com/forum.php?t=41753
    Issue #1899: fix wrong column number on column selector above data grid
    Issue #1906: provide a new preference option to turn on color icons on inactive tabs again
    Issue #1910: Fix CURRENT_TIMESTAMP default text detection as an expression, not as an ordinary string literal, on MySQL 8.0.14+.
    Issue #1887: restore old scroll offset in data grid, when refreshing result or paging to the next rows
    Issue #1918: Remove leading timestamp from log message when copying to new query tab.
    Host tab: use session name as tab caption, and show host name as mouse-over hint. See https://www.heidisql.com/forum.php?t=41399
    Hopefully fix slow loading tabs.
    Issue #1923: Fix completion proposal not showing columns of a table alias when table name contains the word "join".
    Issue #355: Fix non-working scrolling with a horizontal mouse wheel in grids, by preferring TWMScroll.Pos over TScrollInfo.nTrackPos (always 0).
    Add functions-mysql8.ini with some newer functions in it, and search for version specific ini file when connecting. See https://www.heidisql.com/forum.php?t=41892
    Fix too small foreign columns dropdown, scale controls on TSetEditorLink DPI aware
    Issue #1247: Fix invalid SQL code for dropping foreign key constraint in PostgreSQL mode.
    Issue #1586: include "COLLATE xyz" clause when applying collation and user checked the "Convert data" option, so the columns do not get the default collation of the new charset
    Issue #1934: fix empty column list in completion proposal when user input starts with a quote character
    Issue #1933: Update list with known MySQL 8 keywords, taken from https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-in-current-series
    Issue #1939: Fix empty CREATE TABLE code and "List index out of bounds" message in log, due to accessing TTableKey.Collations

• without being initialized

    Issue #321: Fix SQL code in TTableKey.SQLCode for PostgreSQL
    Issue #1940: In TSecureShellCmd.Connect, include parallel happened errors in any success dialog. Also, log errors to the log panel when both pipes have content.
    Issue #1942: Reset FClipboardHasNull marker before pasting text which was copied outside the application.
    Issue #1943: Set DbTree.DefaultNodeHeight in FormShow rather than in FormCreate, to respect DPI settings.
    Issue #1931: Support CITEXT columns in Postgres and categorize as text type, so these show up in foreign values pulldown editor of data grid.
    Issue #1868: Reset sort order of data tab grid as well, when user clicks "Clear data tab filter".
    Issue #1936: Fix EAbstractError when closing text editor
    Issue #1947: don't change case of detected column names, in CSV parser

[close]

https://www.heidisql.com/

[SiLæncer]

Changelog

    Enhancements:

    Make JSON parsing more efficient on the JSON unfolding feature

    Bug fixes:

    Fix dashboard subscription's Japanese file name of attachment
    Fix metadata loading issues after tabs
    Fix migration issues related to a missing encryption key
    Realize database transient rows in after-select hook before calling driver.u/features

[close]

https://www.metabase.com/

[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: file menu save and save as not working
    FIXED: query editor on import/export screen overlaps with selector
    FIXED: Fixed inconsistencies in max/unmaximize window buttons
    FIXED: shortcut for select all
    FIXED: download with auth header
    CHANGED: Upgraded database drivers for mysql, postgres, sqlite, mssql, mongo, redis
    CHANGED: Upgraded electron version (now using v30)
    ADDED: Vim keyboard bindings for editor
    FIXED: Correctly select the save folder for dump
    ADDED: enum + set for mysql (#693)
    FIXED: localStorageGabageCollector not working
    FIXED: Encoding error when opening Unicode query files
    ADDED: Add copy/paste to query tab and database list
    ADDED: Add copy name to table list
    FIXED: Make TabControl scrollable (#730)
    ADDED: Add copy to column list
    FIXED: Problems with SQLite + glibc in docker containers
    ADDED: Button for discard/reset changes (#759)
    FIXED: Don't show error dialog when subprocess fails, as DbGate handles this correctly (#751, #746, #542, #272)

[close]

https://github.com/dbgate/dbgate

[SiLæncer]

Changelog

    SQL Editor:

    Smart mode for statement delimiter was improved
    Default option for the setting ‘Blank line is statement delimiter’ was changed to ‘Always’
    Cursor behavior during autocompletion was improved
    Code highlighting issue with a quoted identifier in case of no connection was fixed
    High CPU usage for large script was fixed

    Metadata Editor:

    Highlighting for created entities was changed to green
    Virtual foreign keys: reference table container selector was fixed
    Database Navigator: CTRL+C and other shortcuts behavior after the application startup were fixed
    AI (extension): custom scope performance was improved

    General:

    Opening editors for files with special symbols in names was fixed
    Portable distribution of the application was fixed (config files location)
    Licensing for some source files was fixed
    Eclipse plugin: new database objects create was fix

    Databases:

    DuckDB: Spatial data visualization support was added

    Oracle:

    Partition type display was added
    Materialized view refresh was fixed
    SQL Server: Default IDENTITY was changed to (1,1) (thanks to @Sgierek106)
    Vertica: LOOP/END LOOP as a block and DECLARE were added to the syntax analyzer

[close]

https://dbeaver.io/