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/

[SiLæncer]

Changelog

    Task management UI was redesigned for data transfer, admin tasks and SQL tasks
    CockroachDB: query results limit was added
    CSV, Athena: database metadata is now read-only
    Redshift: geometry edit support was added
    Snowflake: driver version is now hardcoded (to avoid problems with MFA authentication)
    SQL Server: auto-completion for synonyms was added
    Sybase: database statistics info was added

    Data transfer:

    Bulk load (COPY) support was added for PostgreSQL
    Cross-database data type mapping was improved for PostgreSQL, Oracle and Sybase
    Additional variables were added for file name patterns (${year}, ${month}, ${day}, etc)
    Several fixes in data transfer wizard

    Data editor:

    Geometry values copy-paste operation was fixed
    Gis viewer: object tooltips were fixed
    Problem with invalid SRID was resolved
    Copy from row above/below command was added
    JSON function were added to virtual columns definition
    Image viewer flickering was fixed
    Row count calculation was fixed (bug with distinct select)
    Composite data types support was fixed (arrays of composite type)

    SQL editor:

    New script template was added (configurable)
    Tooltip for execution plan explain tab was fixed
    Shared jar libraries confioguration was added

    Navigator:

    Quick filter value is now saved between application starts
    Command line handler was fixed (problem with -reuseWorkspace)
    Boolean editor UI was fixed (trimmed labels)
    UI freeze during metadata editors re-open was fixed

    Clickhouse:

    Table statistics read was fixed (thanks to @den-crane)
    SQL dialect definition was improved (extra keywords)

[close]

https://dbeaver.io/

[SiLæncer]

Database Browser is an easy to use tool allows you to connect to any database (Oracle, MS-SQL, MySQL, Firebird, etc) and browse or modify data, run sql scripts, export and print data.

Features

    * Works directly with Oracle, MS Sql Server, ODBC, MySql, PostgreSQL, Interbase and Firebird
    * Support for ODBC connection strings
    * Unlimited number of connections
    * One click switching from one connection to another
    * One click table browsing
    * Data browsing
    * Data exports into CSV, Excel, Html files
    * Execution history
    * SQL Builder with wide range of supported databases
    * Execution Log
    * Incremental Table Search

Whats new:>>

    Improved: Third party components update
    Fixed: Installation Issues

http://www.etl-tools.com/database-editors/database-browser/overview.html

[SiLæncer]

Whats new:>>

New and modern user interface look and feel.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

    Bug fixes:

    Frontend crashes when opening admin database permissions page (#18829)
    Cannot access Notebook for questions that uses a Custom Column as joining column (#18818)
    Requests to GET /api/card/123 is making slow queries on larger instances (#18759)
    BigQuery can cause conflict with some column names like source (#18742)
    "Verify this question" button is shown even when content moderation feature is not enabled (#18740)
    New BigQuery driver with "Project ID (override)" defined causes different Field Filter references (#18725)
    Dashboard subscription send by Email fails with xlsx attachements (#18724)
    Textbox markdown links on images difficult to click (#18641)
    Some questions with old field dimensions or changed columns cannot be viewed, because of Javascript loop (#18630)
    Multi-column join interface defaults binning for numeric fields causing incorrect results (#18589)
    Sandboxing queries fails with caching is enabled (#18579)
    Changing redshift db details leads to closed or broken resource pool (#18499)
    Audit visualizations does not show correct information, when there's more than 1000 aggregated dates (#17820)
    "Set up your own alert" text needs padding (#17701)
    Dashboard Subscriptions are not deactivated, when dashboard is archived (#17487)
    ED25519 keys not working for built-in SSH tunnels (#15252)
    Pin Maps with more than 1000 results (LeafletTilePinMap) not working with native queries (#4394)

[close]

https://www.metabase.com/

[SiLæncer]

Whats new:>>

Improved filtering of ad-hoc queries in the SQL console.
Fixed for "User-defined DataTypes (MS SQL Server)".

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

Data editor:

Spatial viewer now saves proper SRID for tables and columns
Find/replace for BLOB/CLOB columns was fixed

Metadata editor:

Navigator refresh was fixed
Schema-level index create was fixed
ERD editor: columns search was implemented

SQL editor:

Files copy into new project was fixed
Backup/restore wizard UI was fixed (MySQL and PostgreSQL)
Task wizard buttons enable/disable was fixed
SQLite: driver updated to version 3.36
Greenplum/Redshift: session and lock managers were added
MariaDB/MySQL: tables metadata load performance was improved

Oracle:

Full-text search for functions and procedures was implemented
Option “show only current schema objects” was implemented

PostgreSQL:

Foreign key settings edit was implemented
Array value parser was fixed
Roles names quote was fixed in grant/revoke commands
Snowflake: driver version was updated (fixes problems with MFA)

[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 Browser and Editor:

Upd: Rewrite GetSchemaTable related code to improve overall processing efficiency

Main program update (Main):

Upd: Related optimization and update processing under Windows 11 operating environment
Upd: Improve related issues such as command interruption and memory release
Upd: (PostgreSQL) Optimize the processing efficiency of the overall SQL query statement execution
Add: (Firebird) Added support for Srp256 authentication login method
Upd: PostgreSQL component version updated to Npgsql 5.0.11
Upd: Firebird component version updated to FirebirdSql.Data.FirebirdClient 8.5.4.0
Upd: SQLite component version updated to System.Data.SQLite.DLL 1.0.115.5 (3.37.0)
Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 19.13.0
Upd: VistaDB component version updated to VistaDB.6.dll 6.2.3
Fix: (PostgreSQL) Solve the problem that npgsql does not automatically update the version number when switching between different database versions on the same source host
Upd: Others include cumulative minor updates, corrections and optimization processing

Displaying Data Types on the column header:

Fix: (Firebird) Fix and update v4 data type display
Fix: (SybaseASE) Fix data type display processing method
Fix: (MySQL/HP Vertica) Solve the problem that the starting value of ColumnOrdinal is non-zero and the related function is abnormal (different from other database bugs?)

Database Migration (Pro):

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

[close]

http://fishcodelib.com/Database.htm