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

    Bug fixes:

    We should never run get-field-values on a dashboard load if the field does not have field values in the metabase_fieldvalues table (#38826)
    Date filtering change between v0.48.3 and v0.48.4. looks timezone related (#38248)
    Relative date filter with time works in Field Filters different for SQL variables than for GUI (#38037)
    Change native SQL datetime range field filters to be inclusive of the end minute (#33492)
    Date filters giving inconsistent results, depends on filter mode (#30454)
    Update group-by-week-test to use database timezone id (#38805)

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

Whats new:>>

Update the built-in database engine to SQLite 3.45.1, DISQLite3 v5.48.1.

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

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

After manually canceling a transaction in the SQL console, a misleading error message in some cases was displayed. This has been corrected.

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:

    Nested CASE statements were supported
    Deleting queries from Outline was fixed
    Type casts support was improved
    Handling of right-click on collapsed query was fixed
    Expanding collapsed group after the code execution was fixed

Metadata editor: changing the key name when a constraint is changed
Data Editor: SRID switching in the Spatial data viewer was fixed
ER Diagram:

    Missing connection lines were fixed
    Mikami-Tabuchi routing type was disabled

AI:

    Comment presentation was improved
    Sending unique keys and indexes was fixed

Data Transfer:

    Export statistic was fixed
    Import blocking in case of table creation restriction was fixed
    Stack overflow on Linux was fixed

Connectivity: closing timeout for an idle connection was increased and disabled for embedded drivers
Security:

    Vulnerabilities display in Elasticsearch was fixed
    PosgtreSQL driver was upgraded due to CVE-2024-1597

General:

    Smart commit mode was enhanced: if the manual commit mode was enabled and just after it the query failed, the smart commit mode is enabled again
    Links between preference pages were fixed
    Issue with not found tables was fixed
    Release note display was corrected
    Driver libraries download was fixed
    Previous workspace format was supported
    Usage statistics popup was redesigned

Databases:

    DuckDB: WSL paths handling was fixed
    Greenplum: STRICT keyword was added to function definition
    Hana: Switch to the Kerberos authentication in the Connection page was fixed
    MariaDB: The exported JSON format was fixed
    MySQL and MariaDB:
        “Disable Triggers” option was added to the Context menu
        “Case-sensitive” option was added to the metadata search
        Databases with the same name but different name case are considered as different databases
    Oracle: generating DDL for triggers was fixed
    SQL Server: additional table properties were added for tables and views in the properties editor
    Yellowbricks icons and link to the website were changed

[close]

https://dbeaver.io/

[SiLæncer]

Changelog

    Bug fixes:

    Forcefully reload table/card metadata when there are no fields (yet) (#39311)
    Hide the default maps (#39079)
    Add entity-id to Serdes v1 as an optional flag (#38961)
    Allow official collections inside personal collections (#38823)
    Include filters when exporting dashboard to PDF (#38231)
    Export to PDF should have the filter values that were used on the dashboard (#35475)
    Enabling "don't send if there aren't results" in a subscription won't send the text cards (#39190)
    Currency Data Type Is Not Inferred in Summarized Visualizations (#38022)
    Default values are not respected for pinned questions in collections in v48 (#37831)
    Pie chart wedge hover incorrectly displays total for wedges smaller than 0.30% (#33342)
    Minimum slice percentage effects actual values on Pie charts (#32430)
    Subscriptions will fail when parameter doesn't exists (#30100)
    Cannot connect to Snowflake via SSH (#17663)

[close]

https://www.metabase.com/

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

Updated: Excel components

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

[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

Changelog

    Improve UI for non-100% scales (issue #144)
    Extension manager
    Attach external sources as a schema through ODBC interface
    Execute the current line by F12 (issue #152)
    Auto-complete in row dialog (issue #153)
    Modify help
    Remove "Database diagram"-tool
    Up SQLite to 3.45.1
    Many other changes

[close]

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 #6058 - Allow preferences customization using a configuration file.
    Issue #7138 - Add support for JSON log format.
    Issue #7204 - Add –yes option for skipping the confirmation prompt while deleting the user via CLI for scripting purpose.

    Housekeeping:

    Issue #7097 - Upgrade CodeMirror from version 5 to 6.
    Issue #7148 - Added documentation for Dashboard’s System Statistics tab.
    Issue #7187 - Separate the application name, branding & version information from the configuration file.
    Issue #7234 - Upgrade python packages cryptography to 42.0.x and Flask-Security-Too to 5.3.x.

    Bug fixes:

    Issue #6792 - Fix multiple issues where PasswordExecCommand was not working in server mode and PasswordExecCommand was not loaded when importing servers.
    Issue #6808 - Fix the tabbed panel backward/forward shortcut for tabs.
    Issue #7027 - Fixed an issue where dependencies and dependents were not showing if a composite type is used as an attribute in another composite type.
    Issue #7164 - Fix an issue where constraint check control is enabled in the edit table dialog.
    Issue #7165 - Fix an issue where the scripts created by generate script of Schema diff for Table with sequence was not working earlier.
    Issue #7193 - Ensure that the OAuth2 session is logged out when users log out from pgAdmin.
    Issue #7217 - Remove role related checks on the UI dashboard when terminating session/query and let PostgreSQL take care of it.
    Issue #7225 - Fix an issue where type column in dependents/dependencies tab is not showing correct label.
    Issue #7258 - Unsafe Deserialization and Remote Code Execution by an Authenticated user in pgAdmin 4 (CVE-2024-2044).

[close]

https://www.pgadmin.org/

[SiLæncer]

Changelog

    Enhancements:

    Dashboard improvements:

    Add Sections (predefined layout of empty dash cards) to a dashboard (#38209, #38575)
    Add ‘Replace’ button to dashboard edit mode to let creators swap out dashboard questions with a different question (#36497, #36744)
    Let dashboard creators duplicate tabs and cards (#38208)
    Let creators make dashboard and native query filters required (#18097, #36524, #37709, #39159)
    Let creators make dashboard filters global or tab specific (#31621)
    Default dashboards to a fixed-width to give creators a more predictable canvas (#36358, #10364)
    Tightened up visual design of charts (#36991)
    Trend chart improvements (#33411, #9510, #11200, #35551, #8919, #31951, #25670)
    Append data to CSV uploads (#35614, #36640, #37220, #38837, #38435)
    CSV upload support for Redshift (#36166)
    Serialization via API (#36843, #36240, #38804, #38359, #20632)
    Authentication with API key (#2699, #36593, #37234, #37607, #37000, #36999, #36998, #37284, #37085, #37061, #37051, #36347)
    Add connection impersonation to Redshift (#38445, #32388)

    Embedding improvements:

    Let white-labeling admins remove links to metabase.com outside of admin settings, and customize or hide ‘Help’ link (#36966, #35915)
    Setup flow for Static and Public embedding, and embedding feature discoverability (#35961, #36048, #36170)
    Embedding settings cleanup and surface interactive embedding Quick Start guide (#36481)
    Modified setup flow for admins who want to start embedding (#38233)
    Enable public sharing default for new instances (#38609)
    Remove unused global css (#39220, #39020, #39531)
    Add anonymous usage tracking for relevant white-labeling (#37656)
    Add sticky filters on embedded and Public dashboards (#24726)
    Models added to Browse Data (#37707, #38730, #38704, #38560, #38661, #38661, #38635, #38518, #38518, #38126, #38107)
    Sync column index information (#36452, #36462, #36624)
    Let admins disable user provision on SSO (#36371)
    Make dashboard subscription attachment behavior match the user's choice in-product (#36441)
    Add new audit content to Metabase Analytics (#38524, #38474)
    Create a unified rendering pipeline for formatting (#36015, #36559, #36555, #36554, #36327, #36154, #36153, #36323, #36320)
    Honey SQL 2 Migration (#28684, #28396, #28165, #28161, #28156)
    Bigquery: Sync required partition column (#36668, #36677, #36892)

    Metabase Library v2 (#28689):

    Custom columns (#30513, #37173 #36254, #36406, #36717, #36235, #36233, #35982, #35947, #35948, #36710, #36639, #36211, (#36699)
    Computing clauses and columns in the query builder (#36108, #37509, #37507, #37396, #37391, #36978, #37677, #36737, #37629, #37628, #37172, #37171, #37170, #37169, #36736, #37120)
    Filters (#34112, #37369, #36988)
    Notebook steps (#36983, #36516, #36672)
    Add description and fingerprint to displayInfo for columns (#38476)
    Add isTemporalExtraction flag to displayInfo (#37889)
    Add legacy-column->metadata for converting DatasetColumn (#37648)
    Add compatible-type? wrapper that handles JS DatasetColumns (#37609)
    Add aggregation-column and breakout-column (#37873)
    Add tests and fix a special case for FK-filter drills (#38297)
    Add caching for the common case of visible-columns without options (#38409)
    Add display-info for queries (#37675)
    Cache JS <> CLJS metadata conversion (#38375)
    Drop redundant :fields clauses from stages and joins (#36959)
    Drill-through coverage: Add a structured column and fix that case (#38295)
    Ensure :name is unique on returned columns (#39118)
    Fix an edge case where a join-alias is needed on a field ref (#36871)
    Fix pivot drills integration with the FE (#36509)
    Fix white-labeled icon colors of official collections and verified models (#39238)
    fk-filter drills should not appear on native queries (#36660)
    FK-details drill should preserve := filters for other PKs (#38296)
    Fix some edge cases and add more unit tests for zoom in drills (#38275)
    Handle Object.isFrozen() legacy columns as input (#39032)
    Implement automatic-insights drill (#36443)
    joinable-columns on a Join sets source and alias (#39529)
    Look up FK columns in visible-columns, not metadata (#37771)
    Make query= treat missing :base-type as matching (#37727)
    Resolve a string :fk-field-id to a numeric ID if possible (#37079)
    Reorder column filter and distribution drills (#36700)
    Track drill-through unit test coverage (#36601, #38210, #36529)

    More stuff:

    Add a banner to the top of locales.clj (#37877)
    Add align-temporal-unit-with-param-type-and-value multimethod (#37813)
    Add intermittent test solver (#38159)
    Add SegmentedToggle component from mantine (#37007)
    Add Creator Sentiment Email task (#38787)
    Add stress testing workflow for frontend unit tests (#38081)
    Add junit.xml to .gitignore (#36627)
    Add new AWS global bundle certs for RDS (#32017)
    Add percentage type to metadata (#35124)
    Allow toggling of the dashboard subscription sidebar from the icon (#36244)
    Better UX for required missing parameters on dashboards (#5320)
    Compute results of timestamp/current-date functions during query processing for Redshift (#21518)
    Count :model/User, not :core_user (#36985)
    Delete all pruned persisted info records (#39219, #39272)
    Error if DB downgrades are required (#37239)
    Flaky QueryBuilder.unit.spec.tsx (#37184)
    Filter picker search free input (#38907)
    Fix confusion of expressions with the same name as columns (#39526)
    Fix isNavigationAllowed (#38703)
    Fix permissions graph performance (#36610, #36797, #36543)
    Fix confusion of expressions with the same name as columns (#39255)
    Format SQL Query option in the Native Query Editor (#9142)
    Fix TableBrowser flex (#38324)
    Kondo lint to enforce naming convention for thread not safe defn/defmacro in tests (#37126)
    Load analytics only when changed using a checksum (#38280, #38622)
    Migrate the FieldInfo card to Mantine so it can be reused (#38432)
    Make effective use of Snowflake's query result caching (#20988)
    Monger does not support Atlas Serverless (#27385)
    Optimize autocomplete query (#38080)
    Port LastEditInfoLabel (#38109)
    Query metadata within comments leads to cache misses in AWS Athena (#29615)
    Refactor drills unit tests structure, split huge file by drill type (#35883)
    Remove Pulses (#34147, #35841)
    Show more billing info on license and billing settings page (#38497, #38153)
    Specify one more guava more explicitly (#38173)
    Switch back to ring-jetty-adapter to address security issue (#39321)
    Test some modals more semantically (#37028)
    Type routing in State (#38645)
    Unify type of timestamp columns (#33577)
    Update deps with security issues (#39286, #37789)
    Update graalvm (#38218)
    Update required parameter reset icon (#39068)
    Update Enterprise readme to 2024 (#37207)
    Use the alias for unfolded JSON columns from previous stages (#39446)
    Wrap literals around expression refs (#38886)
    When updating an alert, don't also update the question (#36866)

    Bug fixes:

    Autosuggestion in native queries peaks the CPU on instances with > 1M fields (#30588)
    Aurora Serverless v2 fails to verify CA due to RDS Combined CA Bundle not importing all certificate chains (#27790)
    Admin > People header "jumps" when switching from active and deselected users views (#37129)
    Between filter errors out with min > max (#16745)
    Bug when using custom columns to do filters for the past one day/month/year (#37165)
    Bookmark icon should be correct size; and should be filled when an item is bookmarked (#34327)
    Cannot "filter by this column" (#38034)
    Changing groups or databases on data permissions after saving a value causes the client to falsely believe that someone else edited the perm graph (#37811)
    CSV exports of timestamps at midnight (00:00:00) is truncated to date (#14504)
    Custom Column in Models doesn't respect filtering when binning is applied (#26202)
    Canceled Queries are retried with Bigquery Driver (#36623)
    Custom columns that have same name as existing columns cause failure (#39059)
    “contains” and “does-not-contain” returned for the wrong fields (#36856)
    column-filter should come before other column drills (#36674)
    Dashboard Email Subscription seems to cache incorrect settings (#30314)
    drill-thru/pk drill should be returned for query that has multiple PKs on non-PK columns click (#35618)
    Date filter selection from the chart footer is glitchy and results in wrong selection (#22973)
    Datetime filter not working correctly (on mysql) (#8762)
    Date filtering on time-series viz is not available when the second grouping field is not a category type (#34690)
    Date filtering on time-series viz only works if time is added as a first grouping category (#34688)
    Dashboard filters are slow (#37285)
    Extreme slowness while editing parameters on a dashboard (#38225)
    Exports should include formatting everywhere (#17753)
    Error calculating display info on filtering with a model (#36400)
    Export formatting for Longitude & Latitude (#38419)
    Execute an Action on emb...

[close]

https://www.metabase.com/

[SiLæncer]

Whats new:>>

    Fix an error in UPSERT, introduced by enhancement 3a in version 3.35.0 (2021-03-12), that could cause an index to get out-of-sync with its table. Forum thread 919c6579c8.
    Reduce the scope of the NOT NULL strength reduction optimization that was added as item 8e in version 3.35.0 (2021-03-12). The optimization was being attempted in some contexts where it did not work, resulting in incorrect query results. Forum thread 440f2a2f17.
    Other trifling corrections and compiler warning fixes that have come up since the previous patch release.

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

[SiLæncer]

Whats new:>>

    The dialog for entering the database credentials has been improved.
    Minor improvements to the user interface.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

The tab button for creating new SQL consoles did not work properly.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

- Fixed: Issues with viewing/editing very large numbers (MySQL, Postgress, Interbase/Firebird and SQLite)

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

[SiLæncer]

Whats new:>>

    Update the built-in database engine to SQLite 3.45.2, DISQLite3 v5.48.2.
    Fix: The schema treeview did not show generated columns.
    Fix: If a table's pimary key column name contained parameter characters ('?', ':', '@', or '$'), a double click on the schema treeview failed to display the table or showed “0 - deleted” instead of the actual row data.

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

[SiLæncer]

Changelog

    Breakout by an unfolded JSON column now works correctly (#35636, #34930)
    Fix custom columns that have same name as existing columns causing error (#25931 , #39059)
    Chain filters do not respect inactive fields (#39618)
    Enabling "don't send if there aren't results" in a subscription now sends the text cards (#39190)
    Metabase v48+ does not run on Windows on H2 (#39040)
    Interactive embedding dashboard with multiple tabs and parameter header=false will not load (#39002, #38429)
    Custom expression interface will not show in usage pop-ups for unsupported functions (#35156)

[close]

https://www.metabase.com/