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:

    Dashboard subscriptions should respect dashboard filters' default values (#14291)
    Pivot tables: subtotal rows missing when there are more than 2 fields in the "rows" bucket (#14245)
    Add documentation for using saved questions as CTEs in the native SQL editor (#14198)
    Pivot tables: visual polish (#14177)
    Pivot tables: collapsable/expanding rows (#14171)
    Document changes to collections layout (#14098)
    Update docs with changes to drill-through/actions menus (#14095)
    Write a smarter linter for our Liquibase migrations YAML file (#14092)
    Document pivot tables (#14090)
    Document Waterfall charts (#14074)
    Pull in translations for new strings for 038 release (#14071)
    Sandboxing: peek at metadata for native SQL sandboxing queries by running them as a test user (#13716)
    Restyled drill-through and actions popover (#13695)
    Collections Redesign Implementation (#13660)
    Add timeouts for both configurations (#13568)

    Bug fixes:

    on startup sync, application says refingerprinting rather than fingerprinting (#14411)
    startup logging of database changes has null values in logs (#14409)
    Dashboard subscriptions: broken dropdown when trying to set Slack subscription/pulse to Hourly (#14399)
    It's possible to create multiple dashboard subscriptions if the dashboard is slow due to slow viz types (#14397)
    Dashboard subscription emails shouldn't say "Pulse:" in subject line (#14395)
    Trying to visualize a SQL query's results as a pivot table locks up the UI (#14363)
    Custom expression errors are too verbose now (#14345)
    "Automatically run queries" setting should default to ON when adding a new database (#14334)
    Pivot tables are missing cells when there aren't records(?) (#14243)
    Pivot Table creates failing query and never shows visualization (#14148)
    Can't use a binned numeric dimension as a grouping in a pivot table (#14136)
    The dashboard subscription sidebar should be the full height of the browser's viewport (#14119)
    Results attachment settings for dashboard subscriptions don't persist (#14117)
    Subcollection permissions not working right in sidebar on master (#14114)
    datetime fingerprinters are incorrect for :type/UNIXTimestampSeconds columns (#14067)

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

    The data browser has been revised and improved:
    In particular, an overview panel for the desktop was developed, which simplifies orientation in complex data views.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

    Oracle: dependencies information was enhanced (+dependents)
    SAP HANA: connection editor waa enhanced (port numbers)
    Greenplum: partitions and child tables read was fixed
    Informix: stored procedures DDL formatting was fixed
    Spanish localization was significantly improved (thanks to @ adamantike)
    Several minor UI bugs were fixed

    SQL Editor:

    Server Output and Execution Log panels were redesigned
    Server Output auto-show was added (configurable)
    SQL formatting was fixed (IN clause)

    Data editor:

    Export in TXT (plaintext) format was improved (proper formatting added)
    Documentation for date/time format patterns was added
    Import from file: file selector wizard page was fixed

    Connection editor:

    Password field is disabled when it is not used
    Driver selector page was redesigned
    Driver properties editor was fixed (empty property values save)

    MySQL:

    GIS data types support was fixed
    Table columns mapping was improved in data transfer

    SQL Server:

    Composite indexes metadata read was fixed
    Database delete was improved (close other connections before delete)
    MERGE queries support was improved (erroneous row count limit was removed)

[close]

https://dbeaver.io/

[SiLæncer]

Changelog

    Fix a potential use-after-free bug when processing a a subquery with both a correlated WHERE clause and a "HAVING 0" clause and where the parent query is an aggregate.
    Fix documentation typos
    Fix minor problems in extensions.

[close]

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

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

Whats new:>>

Improvements and bugfixes in Export dialog.

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

    Add: The waiting window supports Countdown time display (7695)
    Fix: Fix the interrupt processing on some databases, which may cause the problem of waiting too long (7695)
    Fix: (PostgreSQL) Fix (7592) There is a problem that some data types cannot be read (7695)
    Upd: (PostgreSQL) When connecting to Amazone Redshift, the compatibility mode is automatically set to avoid the Host can't be null error (7695)
    Upd:Optimized display and control issues under HiDPI high zoom ratio >150 (7695)
    Upd: PostgreSQL component version updated to Npgsql.dll 4.1.8 (2021/01/21)(7695)
    Upd: MySQL component version updated to MySql.Data. dll 8.0.23 (2021/01/18)( )(7695)
    Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 19.10.1 (2021/01/13)(7695)
    Upd: Secure Shell Protocol ( SSH: Secure Shell ) component updated to Renci.SshNet.dll 2020.0.0 (2020/12/31)(7695)
    Upd: Others include cumulative minor updates, corrections and optimizations (7695) -Custom

    SQL file location ( Specifying the location of SQL files ):

    Add:Add settings to the main settings option (Options->Custom SQL files location)(7695)
    Upd: Support resetting to the preset location when re-modifying (7695)
    Upd: Add interruption to restore the preset path processing to avoid incorrect assignment long waits (7695)

    SQL editor ( SQL editor ):

    the Add: keep the original formatting ( Keeping original formatting ): support Compact process ()

    Database migration ( database migration ) (Pro):

    Upd: all updates with dbMigration .NET Software (7695)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

3rd party updates:

    update VCL Styles Utils code
    get latest bugfixes for VirtualTrees component
    upgrade installer compilation to InnoSetup v6.1.2
    plink.exe update to v0.74
    update sqlite3 libraries from v3.30.1 to v3.34.0

New features and enhancements in this version:

    New CSV layout detection for "Import text file" dialog (select <New table>)
    Support for table level check constraints on MariaDB
    New "Rename tab" context menu for query tabs
    New "CREATE code" tab in view editor
    Tab restore feature:
        Gracefully re-create folder if query tab file and its folder was deleted from outside
        restore scroll position
        restore active query tab

    Grid export:

        Convert "Copy rows" context menu item to a submenu, and provide all export formats, with icons
        Support custom hotkeys for each of these grid export actions

    SQL export:

        Prevent "Variable 'sql_notes' can't be set to the value of 'NULL'", via IFNULL() wrap
        Speed up data exports of large MS SQL tables, by introducing ORDER BY .. OFFSET .. FETCH clauses in SELECT's
        Limit rows per exported INSERT to 1000 for MSSQL.
        Auto-create directory path of output file
    Support shortcut Ctrl+F for focus on filter edit on session manager
    Data grid: Prefer SUBSTR() over LEFT() function, unsupported in old PostgreSQL versions
    Support regproc and jsonb column types on PostgreSQL
    Support binary values in "More values" quick filter menu
    Restore minimized main window when user attempts to start a second HeidiSQL process in single-instance mode
    Apply data type colors to column names in completion proposal
    Widen status bar panels for big screens
    Shortcut settings: Prompt user for overwriting an existing shortcut

Bugfixes

    Fix various crash reports uploaded by users via exception dialog
    Accept any whitespace after double-minus comment in MySQL/MariaDB mode
    Add UTF-8 BOM in Excel output only in file-mode, not in copy-mode.
    Fix grid search/replace with scope=selection
    Enable MYSQL_OPT_LOCAL_INFILE, seems still required on some systems for importing local CSV files
    Fix invalid enabled state of "Explain current query" action
    Re-add CURRENT_TIMESTAMP function, removed accidentally in last update
    Fix cleared highlighter's TableNames list in irrelevant events
    Fix empty library drop-down after changing network type for the first selected session.
    Fix wrongly parsed ON UPDATE clause of columns when information_schema is hidden by session setting
    Enable cancel button after setting grid cell to NULL

[close]

http://www.heidisql.com/

[SiLæncer]

Whats new:>>

    The SQL formatting algorithm has been improved.
    Increased responsiveness of the SQL console.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

    Enhancements:

    Add CTA to migrate to MB Cloud in admin panel
    Pivot tables: numbers in cells should be right-aligned, not left:
    Dashboard subscriptions should respect dashboard filters' default values
    Pivot tables: subtotal rows missing when there are more than 2 fields in the "rows" bucket
    Add documentation for using saved questions as CTEs in the native SQL editor
    Pivot tables: visual polish
    Pivot tables should have standard drill-through actions
    Pivot tables: collapsable/expanding rows
    Document changes to collections layout
    Update docs with changes to drill-through/actions menus

    Bug fixes:

    Pivot tables fail in dashboards
    Pivot tables use the wrong public/embed endpoints
    Error when opening child-collections on v0.38.0-rc2
    on startup sync, application says refingerprinting rather than fingerprinting
    startup logging of database changes has null values in logs)
    Pivot tables can't handle pivoting when there's only a single grouping field Dashboard subscriptions: broken dropdown when trying to set Slack subscription/pulse to Hourly
    It's possible to create multiple dashboard subscriptions if the dashboard is slow due to slow viz types.
    Dashboard subscription emails shouldn't say "Pulse:" in subject line
    Sharing icon shouldn't appear on public dashboards
    Trying to visualize a SQL query's results as a pivot table locks up the UI
    App becomes nearly unusable after trying to visualize a pivot table with 3+ metrics and 3+ breakouts
    "Automatically run queries" setting should default to ON when adding a new database
    Moved collections not being correctly included in api/collection/tree API response
    Pivot tables are missing cells when there aren't records(?)
    Pivot Table creates failing query and never shows visualization
    Can't use a binned numeric dimension as a grouping in a pivot table
    The dashboard subscription sidebar should be the full height of the browser's viewport
    Results attachment settings for dashboard subscriptions don't persist
    Subcollection permissions not working right in sidebar on master

[close]

https://www.metabase.com/

[SiLæncer]

Changelog

    Enhancements:

    Pivot tables (#8572)
    Waterfall charts (#11904)
    Dashboard subscriptions (#13671)
    Collections Redesign Implementation (#13660)
    Restyled drill-through and actions popover (#13695)
    Sandboxing: peek at metadata for native SQL sandboxing queries by running them as a test user (#13716)
    Add timeouts for both configurations (#13568)
    Add Swiss number formatting (Localization - Separator Style) (#13348)
    Run metabase helm chart on a kubernetes cluster which has pod security policy (#13147)
    Don't set Site URL on requests from ELB HealthChecker (#12996)
    Request to add Updated timestamp type to data model, or generic timestamp type (#12386)
    Docker image can not run as non-root (#9861)
    Add option to disable user ID/hash remark added to every SQL question (#8539)
    Add field descriptions to lists of fields in the Data Reference (#6316) — thanks to @rthouvenin!
    Support unix timestamps in microseconds (µs) (#1889)
    Add Special Type: DateTime String (ISO) (#1576)
    Write a smarter linter for our Liquibase migrations YAML file (#14092)
    Add a lightweight notify api endpoint (#14634)
    Allow usage of PKCS-12 certificates with Postgres connections (#14626)
    add cmd rotate-encryption-key (#14552)
    fix(rotate-encryption-key) settings-last-updated is not encrypted (#14769)
    Login page should automatically focus on the email input field (#14505)

    Bug fixes:

    Datetime fingerprinters are incorrect for :type/UNIXTimestampSeconds columns (#14067)
    Object Details breaks if Field Type is "Field containing JSON", but data is not JSON (#12600)
    On startup sync, application says refingerprinting rather than fingerprinting (#14411)
    startup logging of database changes has null values in logs (#14409)
    "Automatically run queries" setting should default to ON when adding a new database (#14334)
    on startup sync, application says refingerprinting rather than fingerprinting (#14411)
    Startup logging of database changes has null values in logs (#14409)
    "Automatically run queries" setting should default to ON when adding a new database (#14334)
    Moved collections not being correctly included in api/collection/tree API response (#14280)
    Subcollection permissions not working right in sidebar on master (#14114)
    Advanced Sandboxing ignores Data Model features like Object Detail of FK (#14740)
    Custom GeoJSON files are not sorted in the dropdown (#14696)
    user@password JDBC connection strings for application DB no longer work (#14678)
    Shrunken bubbles shown in question for null values (#14662)
    Drilling down by a Region Map assigns the wrong value to the filter (#14650)
    Using "Reset to defaults" on textbox causes it to become a corrupted card on dashboard (#14644)
    Sandboxing on tables with remapped FK (Display Values) causes query to fail (#14629)
    dump-to-h2 does not return a non-zero exit code on failure (#14614)
    Bar chart x-axis positions can cause different spacing depending on the dates returned (#14605)
    dump-to-h2 with --dump-plaintext should check for presence of MB_ENCRYPTION_SECRET_KEY (#14588)
    Token check retry is too aggressive (#14514)
    Click Behavior with cross-filter sometimes does not list column options (#14473)
    Sandboxed question with case Custom Field doesn't substitute the "else" argument's table (#14859)
    Custom Expression using case() function fails when referencing the same column names (#14854)
    Filtering a Custom Column does not give correct results when using "Not equal to" (#14843)
    Cannot remove columns via QB sidebar, then query fails, but works if being removed via Notebook (#14841)
    Advanced Sandboxing ignores Data Model features like Object Detail of FK (#14740)
    Advanced Sandboxing using questions that return more/other columns than the sandboxed table is not possible anymore, but the errors are not helpful (#14612)

[close]

https://www.metabase.com/

[SiLæncer]

SQLiteSpy is a fast and compact GUI database manager for SQLite. It reads SQLite 3 files and executes SQL against them. Its graphical user interface makes it very easy to explore, analyze and manipulate SQLite databases.

License:    Freeware for personal and educational use.

Changelog

    Update built-in DISQLite3 engine to SQLite 3.34.1.
    Add bytecode*() table-valued function.
    Add tables_used*() table-valued function.
    Add the uint collation sequence.
    Add decimal extension functions for arbitrary-precision decimal arithmetic.

[close]

http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index

[SiLæncer]

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

License: Open Source

Changelog

    Features:

    New Desktop Runtime (Using NWjs):

    The Desktop Runtime is now based on NWjs which integrates a browser and the Python server creating a standalone application. By implementing it using NWjs we get rid of the separate server application and the independent browser. We also get rid of QT and C++ runtime logic.
    There are two minor known issues with this feature (6255 and 6258), both of which are due to bugs in NWjs itself; Users on macOS should use the application menu to exit pgAdmin, rather than quitting from the Dock icon to avoid the first issue. The second issue may cause Windows users to see a red square instead of the normal application icon in some circumstances.

    Logical Replication support:

    Logical replication uses a publish and subscribe model with one or more subscribers subscribing to one or more publications on a publisher node. We have added support for logical replication by introducing new treeview nodes and dialogues with which users can easily create/alter/delete publications and subscriptions. Support is also included in the Schema Diff tool.

    Quick Search functionality:

    Added a quick search option in the Help menu to search menu items and help articles. Type at least three characters to display all the matching possibilities under Menu items and the relevant documents under Help articles.
    Make Statistics, Dependencies, Dependants tabs closable. Users can add them back using the 'Add panel' option on the context menu for the tab strip.
    When running in Docker/Kubernetes, ensure logs are not stored in the container, and only sent to the console.

    Bugs/Housekeeping:

    Use cheroot as the default production server for pgAdmin4.
    Updated Javascript dependencies to the latest versions.
    Fixed an issue where the focus is not properly set on the filter text editor after closing the error dialog.
    Fixed an issue where the dependencies tab shows multiple owners for the objects having shared dependencies.
    Fixed an issue where the Zoom to fit button in the ERD Tool only works if the diagram is larger than the canvas.
    Fixed an issue where the user was unable to change the background color for a server.
    Fixed an issue where external utility jobs (backup, maintenance etc.) are failing when the log level is set to DEBUG.
    Ensure DEB/RPM packages depend on the same version of each other.
    Fixed an autocomplete issue where it is not showing any suggestions if the schema name contains escape characters.

[close]

https://www.pgadmin.org/

[SiLæncer]

Changelog

Main changes since 7.3:

    Big number of improvements in data transfer tool (insert or update, types mapping, ordering, etc)
    Spatial viewer: 3D objects support, custom tiles, SQLite support
    SQL editor panels (log, output, result tabs, toolbars) were significantly redesigned
    MacOS: a lot of UI rendering bugs were fixed, BigSur support added
    A lot of database-specific issues were resolved and new features were added
    All packages now include Java (no need to install it separately)
    New databases: Trino, PostgreSQL for Google Cloud

Changes since 7.3.5:

    MacOS: data grid renderer was fixed (bug with mess coloring)
    Linux: package for ARM arch was added
    Data transfer:
        Multiple tables export ordering was improved
        Tables manual reorder support was added
    MySQL:
        Events editor was added
        mysqldump command line parameters now respect client and server versions
    Oracle: tables statistics calculation was fixed
    PostgreSQL: array data types resolution was fixed
    Firebird: system objects detection was improved
    BigQuery: driver version was upgraded
    Exasol: SQL editor now supports LUA scripts (thanks to @Sargul)
    Clickhouse: driver version was upgraded (SQL parser fix)
    Redshift: bug with data types reading was fixed
    Problem with "Tip of the day" popup was fixed
    ERD: bug with broken notes layout after refresh was fixed
    Action icons rendering was fixed on Linux
    Many minor UI bugs were fixed

[close]

https://dbeaver.io/

[SiLæncer]

Whats new:>>

    More options are available when dragging files to Exportizer with open database.
    Minor bug fixes in command line and action files processing.
    Better processing text and CSV data in 64-bit version.

http://www.vlsoftware.net/

[SiLæncer]

Whats new:>>

    Detection and renewal of invalid database connections (further improvements).
    The inplace editor in the data browser now also supports fields of the "boolean" data type.

http://jailer.sourceforge.net/