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

    Revamped Subscriptions and Alerts:

    We've heard your asks, and it's finally here: completely redesigned Dashboard Subscriptions and Alerts. Now they look and feel more like their in-Metabase counterparts, but easy to view in email or Slack.
    We're also giving everyone much more control over the Subscriptions and Alerts they receive, by letting you manage them from your account settings.
    For Pro and Enterprise plans, Admins can now see all subscriptions and alerts set up in their instance. Plus, Admins in these plans can now restrict the domains to which Subscriptions and Alerts can be emailed.
    Because Dashboard subscriptions are that much better, we're going to remove Pulses in favor of Dashboard Subscriptions in the next release (0.42). Pulses will still work in this release (and they look so much nicer!), but 0.41 will be Pulses’ final release. Don’t worry, when we release 0.42, we’ll provide you with tools to help migrate your existing Pulses to dashboard subscriptions, so you won't miss a beat.

    Fully redesigned permissions page (and a new permission level):

    We’ve revamped the Permissions section of the Admin Panel to make it easy to manage permissions in Metabases with lots of people and groups.
    Pro and Enterprise plans also now include a new Block Access permission, which ensures certain groups absolutely can not view content from specific databases, even if they have access to a collection with questions that use that database.

    Stay organized at scale:

    The flip-side of making it easy to ask questions is that your Metabase can fill up with a lot of questions. Pro and Enterprise plans now include tools to help large-scale organizations keep it all straight. To help you separate the data-team-blessed content from the ad hoc explorations from other folks, Admins can now mark collections as Official (they even get a ribbon!) and questions as Verified (they get a blue checkmark ?).
    Official and Verified items are clearly distinguishable throughout Metabase and get prioritized in search, so you can make sure people use the right dashboards and questions to make their decisions.

    Fully-formatted result downloads:

    Now, when you download the results of a question as Excel, Metabase honors all of the formatting you've defined in the question. Things like date and currency formats are kept throughout, as well as column ordering and visibility. Columns will even automatically resize in XLSX! And renamed columns are now honored in CSV and JSON as well.
    Since we were in that part of the code, we made sure filenames include a slug of the question title, so it's easier to distinguish between multiple, similar downloads.

    A better experience for questions with errors:

    We've improved the way we display SQL errors in the queries for many databases, so you can more easily debug them.
    In Pro and Enterprise plans, Admins can now go to one place ("Tools" in the Admin UI) to see all questions which returned as an error when last run, find the most viewed ones and go fix them. This is particularly useful after making schema changes.

    Find slow queries and optimize them:

    Sometimes queries are simply slow and heavy, but we want to help you make them faster (and help you save some big data warehouse bucks!).
    Pro and Enterprise plans now include tools to keep your Metabase lightweight and nimble. Now Admins in these plans can define precise result caching durations for individual questions and dashboards, and even at the database level. (which is great if you only load data into your warehouse once a day, for example.)
    And to figure out which queries need better caching (or rewriting), we built tools into the Audit experience to help you find slow and frequently used questions (you can also see if the cache for certain questions is being overridden too frequently).

    JOINs with multiple columns:

    You can now create more advanced queries while sticking to the Custom Question editor by using multiple column conditions for your JOINs. And now you can define the granularity of the JOIN criteria for dates—previously limited to just month and year.

    Lots of database driver improvements:

    We have a new, JDBC-based Presto driver, which supports Kerberos as an authentication scheme. If you're using Presto today, you'll see a message guiding you to upgrade.
    We also included a new, GCP-client-based BigQuery driver, which is faster and more stable than our previous one.
    More advanced authentications mechanisms are now supported for Oracle.

    And other improvements:

    If you have a chart with many series (e.g. monthly sales over time for every country in Central America), you'll now get a cleaner, scrollable legend, properly displaying the names for each series. And you can still hover them to highlight and click on them to drill down.
    Continuing on the improvements to dashboards in 41, when using filters, they stick to the top. So now when you scroll down, you can still see—and change—filter parameters without having to scroll up and down.

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

Database-side filtering of ad hoc queries in SQL Console.

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

    New features:

    Added support for OWNED BY Clause for sequences.

    Housekeeping:

    Revisit all the CREATE and DROP DDL’s to add appropriate ‘IF EXISTS’, ‘CASCADE’ and ‘CREATE OR REPLACE’.
    Port browser tree to React.
    Port object nodes and properties dialogs to React.
    Port Grant Wizard to react.
    Remove GPDB support completely.

    Bug fixes:

    Fixed an issue where grant wizard is unresponsive if the database size is huge.
    Added support to create the Partitioned table using COLLATE and opclass.
    Ensure that in the Query History tab, query details should be scrollable.
    Fixed an issue where collapse and expand arrows mismatch in case of nested IF.
    Fixed an issue where the last message is not visible in the Debugger.
    Updated query error row selection color as per dark theme style guide.
    Fixed an issue where the drop cascade button enables for Databases.
    Fixed an issue where Refresh view options are not working for materialized view.
    Fixed keyerror issue in schema diff for ‘attnum’ and ‘edit_types’ parameter.
    Ensure that RLS names should not be editable in the collection node of properties tab.
    Fixed an issue where Execute button of the query tool gets disabled once we change anything in the data grid.
    Ensure that SQL help should work for EPAS servers.

[close]

https://www.pgadmin.org/

[SiLæncer]

Whats new:>>

Fixed NPE in data browser.

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:

        Schema detection for auto-complete was fixed
        Intelli-sense proposals detection was fixed for queries with variables

    Data editor:

        Dark theme support was improved
        Booleans editor rendering was fixed

    Data transfer:

        Data export now respects columns order and visibility
        Exported files are highlighted in OS file explorer
        XML export/import support between Oracle and PostgreSQL was added
        CSV parser was fixed (unexpected input file read termination)
        CSV export format: column header format configuration was added
        CSV export: quotation of NULL values was fixed
        Import from XML: column mapping was improved
        Additional variables were introduced for target file name pattern
        Redundant table name quotation was fixed
        Output files split option was fixed (problem with extra empty file)
        XLSX format: column values are now trimmed to 32kb

    Navigator:

        Create new connection from JDBC URL command was added
        Database metadata refresh was fixed

    ERD:

        Palette icons were updated
        Dark theme support was improved
    CSV driver: aggregated functions support was fixed
    Exasol: geometry data types support was fixed
    ODBC driver: app crash during database connection was fixed for several drivers

    PostgreSQL:

        Composite data types support was improved
        Database backup wizard UI was fixed
    SQL Server: square brackets escape was fixed
    Command-line support: running app instance detection was fixed
    Booleans view was improved (font weight is now configurable)
    SSL encryption algorithms were replaced by BouncyCastle
    TLS 1.0/1.1 support was fixed
    XML-parser related security issues were fixed
    Base platform was changed to Eclipse 2021-09

[close]

https://dbeaver.io/

[SiLæncer]

Release Notes-> https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-27.html

https://www.mysql.com/

[SiLæncer]

Changelog

    New features:

    Issue #4596 - Added support for indent guides in the browser tree.
    Issue #6081 - Added support for advanced table fields like the foreign key, primary key in the ERD tool.
    Issue #6241 - Added support to allow tables to be dragged to ERD Tool.
    Issue #6529 - Added index creation when generating SQL in the ERD tool.
    Issue #6657 - Added support for authentication via the webserver (REMOTE_USER).
    Issue #6794 - Added support to enable/disable rules.

    Housekeeping

    Bug fixes:

    Issue #6719 - Fixed OAuth2 integration redirect issue.
    Issue #6754 - Ensure that query highlighting color in the query tool should be less intensive.
    Issue #6776 - Changed the label ‘Inherits Tables?’ to ‘Is inherited?’ as it misleading in the properties panel.
    Issue #6790 - Fixed an issue where the user is unable to create an index with concurrently keyword.
    Issue #6797 - Remove an extra blank line at the start of the SQL for function, procedure, and trigger function.
    Issue #6802 - Fixed the issue of editing triggers for advanced servers.
    Issue #6828 - Fixed an issue where the tree is not scrolling to the object selected from the search result.
    Issue #6858 - Fixed object delete issue from the properties tab for the collection nodes.
    Issue #6876 - Ensure that the Dashboard should get updated after connecting to the server.
    Issue #6881 - Fixed an issue where the browser tree doesn’t show all contents on changing resolution.
    Issue #6882 - Ensure that columns should be displayed in the order of creation instead of alphabetical order in the browser tree.
    Issue #6890 - Fixed background colour issue in the browser tree.
    Issue #6891 - Added support for composite foreign keys in the ERD tool.
    Issue #6900 - Fixed an issue where exclusion constraint cannot be created from table dialog if the access method name is changed once.
    Issue #6905 - Fixed an issue where the users are unable to load the databases behind an HTTP reverse proxy.
    Issue #6908 - Fixed an issue where each click to refresh the collection node, the number of objects decreasing by tens or more.
    Issue #6912 - Fixed browser tree sort order regression issue.
    Issue #6915 - Fixed an issue where the blank string is stored instead of NULL in the server table of SQLite database.
    Issue #6928 - Ensure that the master password should be prompt when MASTER_PASSWORD_REQUIRED is set to True and AUTHENTICATION_SOURCES is webserver.
    Issue #6929 - Ensure that only the table node should be allowed to drop on the ERD tool.
    Issue #6930 - Fixed an issue where the existing server group is disappeared on rename it.
    Issue #6935 - Fixed an issue where the wrong SQL is generated when deleting and renaming table columns together.

[close]

https://www.pgadmin.org/

[SiLæncer]

Changelog

    Enhancements:

    Tools for fixing errors problems with Postgres semantics of limits (blank display of error table) (#18432)
    Raise MB_DB_CONNECTION_TIMEOUT_MS to 10000 as default (#18354)
    Allow caching of fonts and images (#18239)

    Bug fixes:

    Not all endpoints are called, when doing FullApp embedding (#18552)
    XLSX export of large columns fails because of formatting limitations (#18531)
    Caching on 0.41.0 caches results for very long time (does not respect settings defined) (#18458)
    Exporting large amount of data can result in OutOfMemory (#18455)
    Chart descriptions (except table) is not shown in dashboards (#18454)
    Remapped (display value) columns are dropped in downloads (#18440)
    Filtering null-column via the drill-through action menu causes blank screen (#18386)
    Data Model shows blank page if there are any hidden tables in the database (#18384)
    Columns missing from exports, when viz settings are using older field dimensions (#18382)
    Pulses with rounded floats render a hanging decimal point in 0.41.0 (#18363)
    Pulse/Subscription table cards with two columns (string, integer) fail to render (#18352)
    [Add Database > Presto] Multiple JDBC field options (#18351)
    Impossible to choose fields from different schema on Field Filters (#18349)
    In email subscription, the original question title is shown instead of the curated title (v41) (#18344)
    Audit > Questions > Total runtime displays link instead of an actual time (#18317)
    KeyExchange signature verification failed for key type=ssh-rsa (#18316)
    Export to XLSX can fail, when there's a very high integer value (#18310)
    Questions -> all questions in Audit feature sorts by null values (#18271)
    Dashboard Subscription test email button does not show error messages (#18235)
    EE Audit App frontend does not display error messages if queries fail (#18124)
    Dashboard Textbox does not render links unless using Markdown (#18114)
    Pin map only containing null location results causes the frontend to constantly reload or blank page (#18061)
    X-Rays: Table field is shown as "null" in the title (#15737)
    Custom Column with the same name as a table column returns incorrect results when grouped (#14255)
    Adding data series to dashboard widget lags then sometimes hangs the UI (#13100)

[close]

https://www.metabase.com/