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

Minor user interface improvements and bug fixes.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

Moving the split-pane in the data browser and SQL console was not possible in rare cases. This has been corrected.

http://jailer.sourceforge.net/

[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

    Models:

    Models are a new fundamental building block in Metabase that let you create metadata-rich derived tables for people to explore. The idea is to make it easier to create starting points for people to ask questions, like a model that pulls together information about customers from multiple tables.
    To create a model, create a question using either the query builder or the native SQL editor, save it, and convert it to a model (from the sidebar). You can add metadata for each column (especially useful for models created from SQL questions), and edit the underlying query. People will be able to select models in the data picker as the starting point for new questions, and you can place models in collections for people to discover.

    Updated Slack integration:

    Metabase now uses the Slack app API to handle its Slack application (Slack had deprecated the previous bot integration).

    Revamped custom expressions editor:

    Writing custom expressions just got a lot snappier: lots of improvements under the hood. Autocomplete suggestions are much faster, and the functions, aggregations, and fields are labeled by type for easy scanning.
    Waterfall, area, progress, and combo charts added for dashboard subscriptions
    Continuing our work on improving dashboards subscriptions, we made two more charts available to email and Slack messages: waterfall and progress charts, and made sure charts with multiple series now display them all. We also added more polish to the formatting, colors, and fonts for the static charts Metabase sends.

    Improved summarize sidebar:

    When you close and reopen the Summarize sidebar in the query builder, it'll keep all of your summarizations and groupings in one place so they're easier to edit. We've also added some small UI touches to field selection that makes adding new summarizations and groupings more intuitive.

    Better revision histories for questions:

    We cleaned up the entries in questions so it's easier to see at a glance how a question has changed over time (and who changed it).

    Refined filters:

    We touched up our calendar date selector as well as the "between" date range selector for our filter widgets, and hardened the security on filters used with questions built with the query builder.

    New database setup interface:

    We spruced up the UI that walks people through connecting Metabase to a data source (like your PostgreSQL database).

    Option to disable animations:

    Animations can cause people with vestibular disorders to experience vertigo, so we made Metabase compatible with the Operating System setting prefers-reduced-motion.
    Connect to a secure PostgreSQL and Oracle database server using a truststore and/or keystore
    You can now provide a keystore and/or a truststore to connect to an Oracle or PostgreSQL database server that someone else (like your database administrator) has secured. Note that some cloud providers only support client authentication with a truststore, so keystores would have no effect. You can also take advantage of PostgreSQL's SSL-mode.

    More control over which BigQuery datasets to sync:

    We have added a new feature that gives more granular control over which BigQuery datasets will (or won’t) be synced.

    We've added Snowplow to help us collect anonymous data:

    For our opt-in anonymous data collection (which helps us improve and troubleshoot Metabase—thanks to those who opt in), we've added Snowplow to capture more in-app events.

    Here is the full list of enhancements and bug fixes:

    Enhancements:

    Add a way to return to previous page from sign in cases (#19476)
    Consolidate first db sync modal and X-ray selection (#19440)
    Migrate Slack implementation from Bot to App (#19435)
    Improve Filters (#19354)
    Clean Up Settings Navigation (#19348)
    Enable users to invite teammates with db credentials in set up (#19247)
    Select no columns in the custom question mode (#19186)
    Remind users to connect their data after set up (#19119)
    Offer contextual help for database connection inputs (#19099)
    Simplify additional options in set up flow db configuration (#19046)
    Support Postgres driver SSL certificates as secrets (#18939)
    Elevate most popular database options in set up (#18918)

    Bug fixes:

    Fix with-temporary-setting-values macro for settings with non-idempotent setters (#18835)
    Waterfall not showing as waterfall in slack static viz (#19025)
    Premature calls to to-sql inside sql.qp/->honeysql methods (#19753)
    defsetting :tag metadata should be on the arglists themselves, not the var (#19627)
    SQLite/Redshift/SQL Server/MySQL queries don't work correctly with multiple column aliases with same name but different case (#19618)
    Archived sub-collections are still showing in Permissions (#19603)
    Disable "Nested queries" not honored in GUI data selector search or on SQL questions (#19341)
    Model query results disappear after cancelling edit (#19180)
    Invalid $project - Path collision.... with mongo >= 4.4 (#19135)
    EMBEDDED_SESSION cookie does not have SameSite=None specified (#18822)
    Fix type of query_cache.results column in MySQL via new changeSet (#18815)

[close]

https://www.metabase.com/

[SiLæncer]

Release Notes

    Security fixes:

    Fix for a user potentially being able to disable their two factor authentication (PMASA-2022-1)
    Add a new configuration directive $cfg['URLQueryEncryption'] to allow encrypting sensitive information in the URL to prevent disclosure. Thanks to Rich Grimes for suggesting this improvement
    Add a new configuration directive $cfg['Servers'][$i]['hide_connection_errors'] to allow hiding the full error message when a log on attempt fails, which can leak hostnames or IP addresses of the target database server. Thanks to Dr. Shuzhe Yang, Manager Security Governance at GLS IT Services for suggesting this improvement
    Fixes for XSS and HTML injection attack in the graphical setup page (PMASA-2022-2)

    Bug fixes:

    Revert a changed to $cfg['CharTextareaRows'] allow values less than 7
    Fix encoding of enum and set values on edit value
    Fixed possible "Undefined index: clause_is_unique" error
    Fixed some situations where a user is logged out when working with more than one server
    Fixed a problem with assigning privileges to a user using the multiselect list when the database name has an underscore
    Enable cookie parameter "SameSite" when the PHP version is 7.3 or newer
    Correctly handle the removal of "innodb_file_format" in MariaDB and MySQL

[close]

https://www.phpmyadmin.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

    Data editor:
        Date/time editor now supports calendar-like UI
        Column names quoting was fixed in filter clauses
        Filter for array columns was fixed
        Gis viewer: SRID switch behavior was fixed
        Save/cancel button are now disabled during data save process
        Column filter now uses exact match for numeric values
        Status message now shows execute timestamp
        Advanced copy now respects quoted column names
    SQL Editor:
        Multiple result tabs refresh was fixed
        Import file now supports multiple files selection
        Client-side commands (@set, @include) parser was fixed
        Auto-completion fix for SELECT .. INTO queries
        Auto-completion now uses “hippie” completion algorithm by default
        Copy as source code: Delphi format was fixed
        “Copy selected query” command was added
        Variables and parameters deletion was improved
        SQL formatting was fixed (redundant empty lines eliminated)
        Tab context menu was improved (additional items were added)
        Code folding restore was fixed
        Multi-cursor edit mode was added
    Data transfer:
        XLSX import was improved (problem with column mapping was fixed)
        Import from CSV now uses approximate column length calculation
        Append to file mode was fixed
    Navigator: tree state loading was fixed
    SSH tunnel:
        Advanced tunnel configuration UI was improved (window auto-resize)
        Tunnel test dialog now supports test interruption
        Private key configuration was fixed for jump servers
    Task execute status now shows more detailed information
    Eclipse plugin: history navigation shortcuts support was fixed
    MacOS: application termination on detached window close was fixed
    Localizations:
        Simplified Chinese localization was significantly updated (thanks to @bianyun1981)
        Italian localization was updated (thanks to @capitanfuturo)
        Japanese localization was fixed and updated (thanks to @yoshinorin)
    Oracle: native quoting parser was fixed
    PostgreSQL:
        Error (NullPointerException) in explain execution plan was fixed
        Role DDL was fixed (connection limit)
    SAP HANA: hyperlink navigation ws fixed
    SQL Server: Database metadata read fix (problem with is_external column)

[close]

https://dbeaver.io/

[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

    ADDED: ER diagrams #118
        Generate diagram from table or for database
        Automatic layout
        Diagram styles - colors, select columns to display, optional displaying data type or nullability
        Export diagram to HTML file
    FIXED: Mac latest build link #204

[close]

https://github.com/dbgate/dbgate

[SiLæncer]

Whats new:>>

    Bug fixes:

    The condition editor had problems with string literals containing non-ascii characters.
    In the SQL console, the filter conditions set by the user were lost after a "reload" in the results panel.
    The pseudo variables "$DISTANCE" and "$IS_SUBJECT" were not taken into account by the SQL formatter.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

    ADDED: Ability to configure SSH tunnel over environment variables #210 (for docker container)
    ADDED: XML export and import
    ADDED: Archive file - show and edit source text file
    ADDED: Window title shows current tab and database
    ADDED: DbGate documentation
    ADDED: Introduced application layers
    ADDED: Virtual foreign key editor
    ADDED: Application commands (SQL scripts related to database)
    ADDED: Theme can be implemented in plugin
    CHANGED: Dictionary description is stored in app
    FIXED: Unique and index editor
    FIXED: Posibility to edit UNIQUE index flag
    CHANGED: UX improvements of table editor

[close]

https://github.com/dbgate/dbgate

[SiLæncer]

Changelog

    Enhancements:

    The Time picker AM and PM color can not be distinguished obviously (#20010)
    Alert Stopped email is Unhelpful (#19814)
    Clean up database guide usability during configuration (#19641)
    Add a way to return to previous page from sign in cases (#19476)
    Consolidate first db sync modal and X-ray selection (#19440)
    Migrate Slack implementation from Bot to App (#19435)
    Improve Filters (#19354)
    Clean Up Settings Navigation (#19348)
    Enable users to invite teammates with db credentials in set up (#19247)

    Bug fixes:

    Pins do not appear on pin map (#20090)
    "Explore results" shown for no-data users resulting in blank screen when clicked (#20044)
    Blank screen when accessing Models with no-data user (#20042)
    Licensing page goes into reload-loop if token is expired (#20020)
    Descriptions missing in search results (#20018)
    Horizontal scroll of pinned table doesn't work on Firefox (#19997)
    Metadata tooltip popup on colum header casues data table to reset for number columns that are all NULLs (#19976)
    Certain visualization_settings can cause empty/missing columns on export (#19889)
    Postgres unnecessarily casts timestamptz and date columns to timestamp inside date_trunc() (#19816)
    Exports ignore column ordering regression in v0.41.6 (#19796)
    Premature calls to to-sql inside sql.qp/->honeysql methods (#19753)
    Visualization "auto-viz" doesn't keep existing settings, when changing fields returned (#19747)
    Can't add a filter if the value isn't in the field filters dropdown (#19685)
    Defsetting :tag metadata should be on the arglists themselves, not the var (#19627)
    SQLite/Redshift/SQL Server/MySQL queries don't work correctly with multiple column aliases with same name but different case (#19618)
    Archived sub-collections are still showing in Permissions (#19603)
    XLSX exports are leaving temporary files, which can block instance from working (#19480)
    Disable "Nested queries" not honored in GUI data selector search or on SQL questions (#19341)

[close]

https://www.metabase.com/

[SiLæncer]

Changelog

    Data editor:

        Row fetch size now can be set to a small value (up to 1 row)
        Search in data grid with enabled numbers formatting now works properly
        Date/time editor calendar presentation now shows proper error messages
        Data loss on resultset scrolling confirmation was added
        Option to highlight selected cell value was added
        Value view panel now supports shortcuts to switch between data formats (configurable)

    SQL editor:

        Bug with missing resultset tab focus was fixed
        Script selector panel now supports "All connections" mode

    Data transfer:

        Export of columns of composite data types support was added
        Popup message boxes were replaced with task bar notifications
    Navigator tree: database object comments render was added (configurable)
    BLOB/binary editor: problem with changes saving in hex editor was fixed
    Dashboard view: problem with memory leaks was resolved
    Auto-close of idle connections option was added (configurable)
    Driver editor: Maven artifacts settings save/load was fixed
    Bug with empty editor tabs after restart was fixed
    Redundant logging during connection context menu opening was fixed

    New database drivers:

        Apache Calcite Avatica
        Apache Druid
        Apache Kylin

    Clickhouse:

        New driver was added. Old driver was renamed to Legacy.
        LIMIT clause support was added for data read queries
    Exasol: execution plan save/load was implemented
    MySQL/MariaDB: permission editor was redesigned, grant option support was fixed

    MariaDB:

        New driver (3.x) support was added
        Packages and sequences support was added

    Oracle:

        Table constraints load performance was significantly increased (thanks to @skybber)
        PL/SQL syntax support was improved (packages and procedures parser was fixed)
        WITH clause parser was improved

    PostgreSQL:

        Identifiers quoting was added for table DDL
        Database backup now supports "drop if exists" option
        Row replace method "ON CONFLICT DO UPDATE" support was fixed

    Redshift:

        New view create was fixed
        Driver version was updated to 2.1
    Generic driver now support sequences and synonyms edit/rename
    Japanese localization was improved (thanks to @yoshinorin)
    Several minor UI bugs were fixed

[close]

https://dbeaver.io/

[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

    Data Export :

    Add: Support Converting SQL INSERTs to different database types (8075)

    Data Import :

    Upd: Significantly improve the processing speed of Excel Workbook (*.xlsx) import (8075)
    Upd: "Whether the first column is a column header" automatic detection process: Exclude virtual column detection (8075)

    Query tab ( Query Tabs ):

    Add: Support Tile Horizontally/Vertically (8075)

    SQL Editor ( SQL Editor ):

    Upd: Update FUNCTIONS syntax highlighting color display is consistent, while removing presets does not support and Duplicate part (8075)

    Main program update ( Main ):

    Upd: The display interface and user experience have been improved in many places (8075)
    Upd: The speed of obtaining data table fields has been improved to avoid repeated processing (affects include multiple places) (8075)
    Upd : Improve the memory release processing immediately after the SQL History declarative record, to avoid the problem of accumulating continuous occupancy (8075)
    Add: (SQLite) Increase the database connection memory release processing to avoid the problem of insufficient resources (influenced in many places) (8075)
    Add: (Oracle) Support User-defined types custom type data display (including related functions) (8075)
    Add:(Oracle) Data table objects are added to Object tables display (8075)
    Upd: (PostgreSQL) Array Types are improved to obtain processing speed (8075)
    Upd: PostgreSQL component version is updated to Npgsql 5.0.12 (2022/02/01)( )(8075)
    Upd: SQL Server/SQL Azure component version updated to Microsoft.Data.SqlClient 4.1.0 (2022/01/31)( )(8075)
    Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 21.5.0 (2021/12) /23)(8075)
    Upd: Others include cumulative minor updates, corrections and optimizations (8075)

    Database Migration (Pro):

    Upd: All updates are the same as dbMigration .NETSoftware (8075)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

ESEDatabaseView reads and displays the data stored inside Extensible Storage Engine (ESE) database (Also known as 'Jet Blue' or .edb file). It displays a list of all tables available in the opened database file, allows you to choose the desired table to view, and then when you choose a table, it displays all records found in the selected table.

ESEDatabaseView also allows you to easily choose one or more records, and then export them into comma-delimited/tab-delimited/html/xml file, or copy the records to the clipboard (Ctrl+C) and then paste them into Excel or other spreadsheet application.

License:    Freeware

Whats new: >>

    When you move the mouse over the column header, you can now see the field type and field ID in the bottom status bar.
    Added /SaveDirect command-line option for using with the other save command-line options (/scomma, /stab, /sxml, and so on...), which allows you to export the database table directly to a file, instead of accumulating all data in memory and then save them to file in the end. It's recommended to use this option if you export a very large table.

http://www.nirsoft.net/utils/ese_database_view.html

[SiLæncer]

Whats new:>>

Full text search over the whole content in the display of a query result.

http://jailer.sourceforge.net/

[SiLæncer]

This compact and minimalist Windows GUI for SQLite will enable its users to perform a wide range of database operations and processes.

License: GPLv2

Whats new:>>

* Up SQLite to 3.37.2
* Custom scalar functions
* Fix issues #86, #88, #89, #90, #91, #93, #95
* Fix minor bugs

https://github.com/little-brother/sqlite-gui

[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 #7139 - Added support to open SQL help, Dialog help, and online help in an external web browser.

Housekeeping

Issue #7016 - Port Dependent, dependencies, statistics panel to React.
Issue #7017 - Port Import/Export dialog to React.
Issue #7163 - Rename the menu ‘Disconnect Server’ to ‘Disconnect from server’.

Bug fixes

Issue #6916 - Added flag in runtime to disable GPU hardware acceleration.
Issue #7035 - Fixed an issue where connections keep open to (closed) connections on the initial connection to the database server.
Issue #7085 - Ensure that Partitioned tables should be visible correctly when creating multiple partition levels.
Issue #7086 - Correct documentation for ‘Add named restore point’.
Issue #7100 - Fixed an issue where the Browser tree gets disappears when scrolling sequences.
Issue #7109 - Make the size blank for all the directories in the file select dialog.
Issue #7110 - Ensure that cursor should be focused on the first options of the Utility dialogs.
Issue #7118 - Ensure that JSON files should be downloaded properly from the storage manager.
Issue #7123 - Fixed an issue where restore generates incorrect options for the schema.
Issue #7126 - Fixed an issue where the F2 Function key removes browser panel contents.
Issue #7127 - Added validation for Hostname in the server dialog.
Issue #7135 - Enforce the minimum Windows version that the installer will run on.
Issue #7136 - Fixed an issue where the query tool is displaying an incorrect label.
Issue #7142 - Fixed an issue where a warning message was shown after database creation/modification.
Issue #7145 - Ensure that owner should be ignored while comparing extensions.
Issue #7146 - Fixed event trigger comparing issue in Schema Diff tool.
Issue #7150 - Fixed an issue when uploading a CSV throwing an error in the Desktop mode.
Issue #7151 - Fixed value error in the restore dialog.
Issue #7154 - Ensure that the layout should not be reset if a query tool is opened and pgAdmin is restarted.

[close]

https://www.pgadmin.org/