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

    New:

    Dashboards are smoother, quicker, and more organized
    Download dashboards to PDF
    Tabbed navigation on dashboards
    Flow between dashboards and questions smoothly
    Guide your team to the most valuable info by setting your home page to dashboard
    Load dashboards faster with the option to turn off auto-apply filters
    More granular grid for more control over dashboard creation
    Keep dashboards organized with full-width headings
    Can hide cards that have no results
    Metabase now keeps track of the dashboards you’re working with
    Upload and analyze data from CSV
    Powered up Pro features
    Unlock git-based workflows with serialization 2.0
    Set table-specific SQL editing permissions with connection impersonation
    Search for specific records, not just tables
    Other things that got better
    Drill-through menus are more intuitive
    Model X-rays
    Fresh icons

    FYI / Breaking changes:

    We’ll soon be limiting the size of log tables (view logs and query execution) on all self-hosted instances in the next release (not this one)
    OSS instances will keep 30 days of log tables
    New Pro/EE instances will keep 720 days of history
    Existing Pro/EE instance won’t be changed but we recommend setting a limit of 720 days
    LDAP will soon only be available on Pro and Enterprise plans.
    The POST "/api/database/:id/sync" endpoint is being removed. If you’re using this endpoint to sync and scan your database, we recommend using POST "/api/notify/db/:id", or POST "/api/database/:id/sync_schema" followed by POST "/api/database/:id/rescan_values".
    The Google Analytics driver is being removed as GA3 will soon be retired and we’ve decided not to build a GA4 driver.
    Data Model in Admin Settings is now Table Metadata. This admin section was often confused with Models, so we renamed it.
    Data reference has been removed. We’re working on putting the relevant metadata into places where data is queried and consumed so it’s available when and where you need it.

    Enhancements:

    Remove POST /api/database/:id/sync endpoint (#31544)
    Adds audit v2 view migrations to liquibase (#31420)
    Allow table prefixes for postgres uploads, update defaults for mysql (#31396)
    Snowplow: Add instrumentation for "Turn into model" option on saved questions (#31381)
    Hydrate root-collection on card and dashboard (#31337)
    Autoload instance analytics content (when EE and avaliable) (#31314)
    [Safety Net] Hold on to query results when you go back-and-forth between dashboards and questions (#31289)
    [Safety Net] Bring consistency and simplicity to the custom expression editor popovers (#31287)
    [Epic] Nudge larger basic instances to Pro (#31264)
    Improve discovery for csv uploads (#31262)
    Force Audit DB sync + fix connection pool caching behavior (#31234)
    Update csv loading status when taking a long time (#31214)
    Force a sync to occur when installing audit-db (#31204)
    Remove /reference pages (#31203)
    Remove task snowplow event (#31156)
    Generically typed item picker (#31099)
    Present an informational toast to users when a homepage dashboard is set (#31097)
    Respect user-defined model metadata when allowing entity-indexing (#31017)
    [Epic] Really encourage admins to add a DB (#31015)
    Make Questions support special instance analytics type (icon) (#31014)

    Bug fixes:

    Fix dashboard description markdown overflow (#31534)
    Adding a DB no longer does a full scan (#31569)
    Dashboard description overflow (#31326)
    Export to PDF just exports the current tab (#31228)
    Application Table implicit_action doesn't have primary key (#31140)
    Moving dashboard to Our analytics collection creates a null revision description (#31109)
    When duplicating a dashboard with tabs, tabs are not brought to the new duplicated dash (#31077)
    Reverting cards doesn't include dashboard_tab_id (#31032)
    Reverting dashboard does not re-add text card properly (#31031)
    Update visualization settings of card does not create revision (#31018)

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

    Preserving manual changes of column width and position in the result view after a reload.
    More minor improvements to the user interface.

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:

    Autocomplete now supports [ ] and ` as quotes for identifiers
    Shortcut confict on macOS was fixed
    JSQLParser was reverted to the version 4.5 and is now faster
    Issue with substitution variables in text with n line feeds was fixed
    Autocomplete case with FROM right after SELECT is now handled
    Autocomplete for SELECT query without FROM was fixed
    ‘Go to Matching Bracket’ shortcut was changed to CTRL+SHIFT+[
    Autocomplete for columns in tables without alias was fixed
    Completion analyze errors are now written to the debug log
    Comment with a tab after a double dash is now handle
    Issue with hiding cursor position after resizing the editor was fixed
    Exeption when updating editor annotations was fixed

    Data Editor:

    Data ordering was improved

    General UI:

    Changing the size and position of the connection dialog is now saved
    Issue with the application freezing when creating a table when the connection hangs was fixed
    Tips of the day were revised

    Connectivity:

    Option to disable SSHJ hostname verification was added (thanks to @ryanc-me)
    Issue when switching from Community to PRO version and vice versa was fixed

    Databases:

    ClickHouse: display of large numbers was fixed
    MariaDB: partition support was added

    Oracle:

    Issue issue with native clients hanging when running SQLPlus scripts was fixed
    Issue with setting the wrong schema after connecting or changing the Data Editor was fixed

    PostgreSQL:

    Issue with an exception when loading attribute information was fixed
    Reading a numeric array was fixed
    Trino: error handling was improved

    Localization:

    German localization was improved (thanks to @hype11)
    Italian localization was improved (thanks to @Gnafu)

    Misc:

    Images for all DBeaver Eclipse extensions were added
    Legacy ODBC driver based on the obsolete Java 7 was deprecated due to many issues

[close]

https://dbeaver.io/

[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 to drop databases using the ‘WITH (FORCE)’ option.
    Add “[ NULLS [ NOT ] DISTINCT ]” option while creating an Index.
    Added ‘OR REPLACE’ clause while creating trigger.
    Added security_invoker option while creating a view.

    Housekeeping:

    Bug fixes:

    Fix an issue where object explorer tree crashes occasionally.
    Ensure that query tool shortcuts are working properly.
    Add Password exec command and Expiration time to server export JSON and also allow them to import.
    When opening pgAdmin the layout should be auto reset if it is corrupted. Reset layout menu should work if layout is corrupted while using pgAdmin.
    Fix an issue where loading more rows indicator will not disappear if connection is lost.
    Fix an encoding error when connecting through Pgbouncer.
    Fix an issue where explain plan details is showing HTML escaped characters.
    Fixed an issue where queries with temporary tables in the same transaction is not working.
    Fixed an issue where preview images for themes were not loading.
    Fix raise notice from func/proc or code blocks are no longer displayed live.
    Fix an issue where PSQL is not working if the database name have quotes or double quotes.
    Fix an issue where all the menus are enabled when pgAdmin is opened and no object is selected in the object explorer.

[close]

https://www.pgadmin.org/

[SiLæncer]

Whats new:>>

    New menu item "Find by: ..." in context menu of the data browser allows to quickly narrow down the result by a column value.
    In the SQL console, statement blocks or the entire script can be executed transactionally. This allows a rollback in case of errors.

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

    Improvements in working with table list in MySQL databases.
    Possibility to export table and column description from/to MySQL databases.
    Minor bug fixes when migrating data between databases.
    Minor bug fixes and improvements in interface.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

    Connections: kerberos support in legacy JDBC drivers (Hive) was fixed
    Data transfer: table information for tasks with broken connection was fixed
    PostgreSQL: enum columns alter was fixed
    Misc: internal app controller server now uses HTTP instead of RMI

    SQL editor:

    Mouse hovering over editor annotations was fixed
    Trailing DDL query delimiter processing was fixed

    Data editor:

    References panel refresh was fixed
    XML presentation was fixed (NULL value handler)

    General UI:

    Settings reset UI and behavior were redesigned
    Editor tab tooltip now contains information abut resource’s project
    CLI parameter for app version print was added
    Objects with mixed case names caching was fixed
    Issue with program launch with wrong Java version was fixed
    Preferences export/import UI was improved
    Maven snapshot repository was added to default configuration

    Databases:

    BigQuery: driver version was upgraded to 1.3.3 (thanks to @fredlegaucher)
    DuckDB: LIST data type support was added
    Firebird: filters and sorting in grouping panel were fixed
    IBM i: driver download was fixed

    Oracle:

    Partitions cache refresh was fixed
    Stored procedures edit/save was fixed

    Snowflake:

    Client application name set was fixed
    Quoted identifiers auto-completion was fixed

[close]

https://dbeaver.io/

[SiLæncer]

Whats new:>>

The dynamic search of the data browser now supports columns of type "UUID".

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

    Improvements in preparing field mappings for exporting data to databases and SQL scripts.
    Minor bug fixes in creating text and CSV tables.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

    Spatial data viewer:

    Geometry object labels were added to the map (configurable)
    Curves rendering was implemented
    Coordinates and viewport bounds copy was implemented
    EWKT format support was added
    Toolbars and lasso visibility toggle was fixed

    Data transfer:

    Import of multiple tables from an XLSX was implemented
    Lazy initialization of configuration pages was implemented
    Issue with duplicated file selector dialog was fixed
    Export in XML format was fixed (doctype section is not optional)
    Issue long filenames on Windows was fixed

    Data Editor:

    Find/Replace dialog and shortcut in the Value view panel were fixed
    Column description was added to the Metadata panel
    Folding in the XML presentation was fixed
    Displaying of images in the the value view panel was fixed on Linux
    Confirmation dialog for the result set filtering was improved

    Accessibility:

    JAWs screen reader can now read data in the Data grid

    General UI:

    Tips of the day were updated
    Creation of objects with mixed-case identifiers was fixed
    DDL generation for sequence was fixed
    Logical project deletion was fixed
    Issue with opening of a local project was fixed

    AI:

    New GPT 3.5 Turbo 16? model was added
    Issue with long metadata information sending was fixed

    Connections:

    Duplicates on driver creation were removed
    Issue with maven artifacts editing was fixed
    Certificate management UI was improved

    New drivers:

    Materialize database driver was added (thanks @bobbyiliev)
    Crate DB via PostgreSQL driver was improved (thanks @proddata)

    Databases:

    DB2: users can see Column Mask Objects
    TimescaleDB branding was updated

    Localization:

    Chinese Simplified localization was improved (thanks @bynyun)
    German localization was improved (thanks @fjf2002)

[close]

https://dbeaver.io/

[SiLæncer]

Whats new:>>

Selection of a single row in the data browser was made possible.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

    New features:

    Added support to detach partitions using concurrently and finalize.
    Added all supported index storage parameters while creating an index.
    Added new/missing parameters to pg_dumpall (Backup Server).
    Added new/missing parameters to pg_dump (Backup Objects).
    Added new/missing parameters to pg_restore.

    Housekeeping:

    Remove Bootstrap and jQuery from authentication pages and rewrite them in ReactJS.
    Enable cluster deployment with gp3 volume for AWS & BigAnimal cloud providers.
    Clarify the LICENSE file to indicate that it is the PostgreSQL Licence.
    Remove unsupported PostgreSQL versions from the container.

    Bug fixes:

    Fix an issue where queries can’t complete execution.
    Fixed an issue where Import Export not working when using pgpassfile.
    Fix an issue where queries longer than 1 minute get stuck - Container 7.1
    Fix an issue where queries get stuck with auto-completion enabled.
    Fixed Query Tool/ PSQL tool tab title not getting updated on database rename.
    Ensure user gets proper error if incorrect credentials are entered while authenticating AWS.
    Fix an issue where the edit server fails in desktop mode if the server password is not stored.
    Ensure that Backup, Restore, and Maintenance should work properly when pgpass file is used.
    Fix the query tool auto-complete issue on the server reconnection.
    Fix the query tool restore connection issue.
    Fix the reconnecton issue if the PostgreSQL server is restarted from the backend.
    Fix the connection and stability issues since v7, possibly related to background schema changes.
    Fixed an issue where the query tool is unable to execute a query on Postgres 10 and below versions.
    Fix the lost connection error in v7.4.
    Fixed an issue where pgAdmin failed to setup role with hyphens in name.
    Fixed an issue where filters are not working and query history shows empty queries.
    Fix an issue where adding a sub-folder inside a folder is not working as expected in File Manager.
    Fix an error ‘list’ object has no attribute ‘strip’ while attempting to populate auto-complete manually the first time.
    Fixed an issue where ERD Tool can’t load the saved pgerd file from Shared Storage.
    Fix an issue where inserting more than 10 rows does not work correctly in View Data; only parts end up in the table.

[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: ROWS COUNT Manually click {*} instead of automatic acquisition to improve the processing efficiency of the overall and related functions (8609)
    Fix: (Pro 64bit) Correct the problem of related shared variables when used with the database migration tool at the same time (8609)
    Fix: (PostgreSQL) Fixed the problem that GetForeignKeys cannot be displayed when the related field is unique (8609)
    Fix: (PostgreSQL) Fixed the related problem that GetForeignKeys affects when different Schema names have the same Table name (8609)
    Upd: The Oracle component version is updated to Oracle.ManagedDataAccess.dll 21.11. 0(2023/07/26)( )(8609)
    Upd: SQLite component version updated to System.Data.SQLite.DLL 1.0.118.0 (3.42.0) (2023/06/10)(8609)
    Upd: Others include cumulative small Updates, fixes and optimizations (8609)

- Filtering Objects :

    Add: Added option to skip loading all objects (Skip loading all objects): Do not load any related objects after database connection (8609)
    Upd : Object filtering added to the database tool menu (Database Tools) (8609)

- Updatable query results ( Updatable query results ):

    Add: Add Edit this table sub-option [E] (8609)
    Add: Data Added shortcut keys for Row Headers (8609)
    Upd: Updated menu function status in database only mode (8609)

- Data Editor):

    Add: (Firebird) support uuid and CHAR(16) CHARACTER SET OCTETS field data type editing and update processing (8609) Add
    : Form Editor ( Form Editor ): support primary key selector ( PrimaryKey Selector ) processing (8609 )

- Data Export ( Data Export ):

    Add: (Firebird) Support uuid and CHAR(16) CHARACTER SET OCTETS column data type SQL format export processing (8609)

- Filtering and Sorting column names ( Filtering and Sorting columns ):

    Upd: Add pk/not null and other information to the field attribute (8609)
    Upd: The not null field can also be hidden in edit mode (8609)

- Form Viewer ( Form Viewer ) / Form Editor ( Form Editor ):

    Fix:Correct the exception that the click does not respond when the first field is an invisible field (8609)

- Constraint Designer : Fix

    : Fix the problem that the automatic naming has no effect when the object name is lowercase (8609)

- Database Migration ( Pro):

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

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

    Data Editor (Data Editor ):
    Fix: Fixed (8609) update causing some functions to lose their function (8613)
    Add: (Firebird) support uuid and CHAR(16) CHARACTER SET OCTETS field data type editing and updating processing (8609)
    Add: Editor Form : Support primary key selector ( PrimaryKey Selector ) processing (8609)
    Main program update ( Main ):
    Upd: Automatically obtain ROWS COUNT and manually click {*} to improve the processing efficiency of the overall and related functions (8609)
    Fix: (Pro 64bit) Fixed the issue of related shared variables when used together with the database migration tool (8609)
    Fix: (PostgreSQL) Fixed the problem that the associated field of GetForeignKeys cannot be displayed when it is unique (8609)
    Fix: (PostgreSQL) Correct the related issue that GetForeignKeys affects when different Schema names have the same Table name (8609)
    Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 21.11.0 (2023/07/26)( )(8609)
    Upd: SQLite component version updated to System.Data.SQLite.DLL 1.0.118.0 (3.42.0) (2023/06/10)(8609)
    Upd: Others include cumulative minor updates, corrections and optimizations (8613)
    Object filtering ( Filtering Objects ):
    Add: Added option to skip loading all objects (Skip loading all objects): Do not load any related objects after database connection (8609)
    Upd: Object filtering added to the Database Tools menu (Database Tools) (8609)
    Updatable query results ( Updatable query results ):
    Add: Add Edit this table sub-option [E] (8609)
    Add: Add shortcut keys to Row Headers (8609)
    Upd: Update the status of the menu function in database only mode (8609)
    Data Export ( Data Export ):
    Add: (Firebird) Support uuid and CHAR(16) CHARACTER SET OCTETS field data type SQL format export processing (8609)
    Filtering and Sorting columns name ( Filtering and Sorting columns ):
    Upd: Add pk/not null and other information to field attributes (8609)
    Upd: The not null field can also be hidden in edit mode (8609)
    Viewer - Form /Form Editor :
    Fix: If the first field is an invisible field, the exception that causes no response when clicking (8609)
    Conditional constraint design ( Constraint Designer ):
    Fix: When the object name is lowercase, the automatic naming has no effect (8609)
    Database Migration ( Pro):
    Upd: All updates same as dbMigration .NET Software(8610)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

The desktop overview view has been improved.

http://jailer.sourceforge.net/