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:

    Improve homepage experience for embedding users (#40168)
    Highlight the selected data source in the notebook editor (#39542)
    Snowflake alternative hostname implementation (#22133)

    Bug fixes:

    QB header jumps when switching between a simple and a notebook modes (#40334)
    There is an additional border between the notebook and the query builder header (#40333)
    Cannot save a question based on another question after converting to SQL (#40422)
    Add Dimension field error handling (#40300)
    Copying and pasting values from a spreadsheet to a filter and insert a unique value (#40265)
    Allow running native queries with required parameters and no defaults (#40250)
    Wide logos cover the icon to collapse the sidebar (#40153)
    PNG dashboard card download doesn't do anything in MacOS Safari (#40095)
    Inconsistent spacing around table and schema divider (#39999)
    Data source is not initially highlighted for nested questions and models once their source is moved to a different collection (#39812)
    Can't enlarge preview section while creating a model (#39628)
    Getting fields in (Redshift) is slow (#38492)
    Null values applied to filters with empty values in custom url from Click Behavior (#38489)
    Zoom in from dashboard change visualization (#38307)
    Updated native models may lose their result set metadata (#37009)
    Can't use drag bar between editor and result pane while editing a model (#33982)

[close]

https://www.metabase.com/

[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

    Connectivity:

    Shared SSH sessions support was added
    Connection via native proxy was fixed
    Dark theme support on the Connection page was improved

    SQL Editor:

    Highlighting, validation, and outline for INSERT, UPDATE, and DELETE were supported
    Incorrect cursor position during autocomplete was fixed
    QUALIFY keyword was supported (thanks to @ashu7896)
    Metadata editor: automatic reference column creation for a new foreign key was implemented

    Data Editor:

    Opening of a table with empty data was fixed
    SRID editing was fixed

    General:

    SVG icons support was added
    Error when checking checkboxes in the Formatting page in Preferences was fixed
    Disappearance of renamed project was fixed (thanks to @saikotek)
    Databases
    Dameng: Sequence creation was fixed

    DuckDB:

    Sequences, views, and table definitions were supported
    Ability to add comments via UI was added
    MySQL: link to the driver documentation was fixed
    RisingWave: non-working functions and folders were removed
    PostgreSQL: issues with scheduled jobs was resolved
    SQLite: errors when creating table was fixed
    SQL Server: redundant authentication types were hidden
    Sybase: stored procedures support was improved
    Teradata: procedures and functions DDLs reading was enhanced

    Localization:

    Romanian language support was added (thanks to @v613)
    French translation was updated (thanks to @Jean-BaptisteC)

[close]

https://dbeaver.io/

[SiLæncer]

Changelog

    Enhancements:

    Handle invalid file drop (#40690)
    Sort official collections first in API endpoints (#40598)
    Increase rate limit of actions from 1 to 10 per second (#40527)
    Order of collection should be the same as the collection sidebar (#39965)
    Show more billing info on license and billing settings page (#38497)

    Bug fixes:

    LDAP no longer works on OSS (#40704)
    model indexes error when values are removed (#40639)
    Common Metrics gone after Summarising by some other column (#40553)
    Attaching CSV files to a subscription leads to a NullPointerException (#40472)
    If there are new columns in the data source after the question was saved, they are hidden by default (#40435)
    Cannot save a question based on another question after converting to SQL (#40422)
    Field filter breaks native question on dashboard (#40383)
    postgresql tables that are visible through column grants aren't available for simple questions (#40338)
    Specific date filter shifts dates by one day (#40332)
    Group managers cannot view all people (#40328)
    Exporting date values changes the year (#40306)
    Copying and pasting values from a spreadsheet to a filter and insert a unique value (#40265)
    Parameter filter widget jumps and doesn't allow to pick a value (#40232)
    Trend viz might not appear correctly on alerts (#39854)
    Filtering by a Specific Date in Snowflake will bring inaccurate results (#39769)
    Whitespace symbol breaks suggestions (#39622)
    Model Caching stuck in "pending" state not cleared out by next scheduled refresh (#39138)
    Duplicate column name error when exploring results of native query with join (#39098)
    Getting errors in the truncate log task Caused by: java.lang.ClassNotFoundException: metabase.task.truncate_audit_log.TruncateAuditLog (#38235)
    Scrolling issue in sort dropdown with many values (#36074)
    Fix missing columns after query fields update (#40398)
    Fix N+1 in checking write permission for collection (#40345)
    Dashcards from other tabs show up in the first one after entering and leaving editing mode (#40695)
    fix normalized chart crashes when trend lines enabled but there is no insights data (#40624)
    Fix unable to migrate to 49 due to v49.00-059 migration (#40547)
    Often SLO won't be setup on the IdP but we should still delete the session. (#40459)
    Redshfit: sync tables with partial select permission (#40421)
    Restore logo margin (#40417)
    Formatter Gives correct year for dates near start/end of Year (#40410)
    funnel chart does not work in static viz (#39743)
    Include filters when exporting dashboard to PDF (#38231)
    [MLv2] [BE] [Bug] returnedColumns does not handle columns with the same name (#37517)
    Export to PDF should have the filter values that were used on the dashboard (#35475)

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

Added support for ClickHouse. #110

http://jailer.sourceforge.net/

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

Freemium

Whats new:>>

Minor changes and interface improvements.

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

    Issue #5611 - Added support for provider, deterministic, version and RULES parameter while creating collation.
    Issue #7098 - Added support for EDB Job Scheduler.
    Issue #7216 - Added support for viewing Log Based Clusters.
    Issue #7221 - Added support for UNIX socket in entrypoint.sh for Docker implementation.

    Bug fixes:

    Issue #4413 - Fixed an issue in Schema Diff where Columns with sequences get altered unnecessarily.
    Issue #7111 - Fixed an issue where user was unable to share a newly registered server.
    Issue #7116 - Bug fixes and improvements in pgAdmin CLI.
    Issue #7139 - Fixed an issue where the ‘Save Password’ option for SSH tunneling password was consistently disabled.
    Issue #7165 - Fixed schema diff wrong query generation for table, foreign table and sequence.
    Issue #7210 - Fixed an issue where table properties were not updating from properties dialog.
    Issue #7218 - Fixed an issue where maximize icon is missing from query tool panel.
    Issue #7229 - Fix an issue in table dialog where changing column name was not syncing table constraints appropriately.
    Issue #7248 - Fixed rollback and commit button activation on execute button click.
    Issue #7255 - Fixed an issue where taking backup of a shared server was using server owner’s user name.
    Issue #7262 - Fix an issue in editor where replace option in query tool edit menu is not working on non-Mac OS.
    Issue #7268 - Fix an issue in editor where Format SQL shortcut and multiline selection are not working.
    Issue #7269 - Fix an issue in editor where “Use Spaces?” Preference of Editor is not working.
    Issue #7271 - Fixed an issue where Triggers, Rules, Indexes were absent from the Schema Diff when comparing views.
    Issue #7277 - Fix an issue in query tool where toggle case of selected text loses selection.
    Issue #7299 - Fix query tool autocomplete results when cursor is in between the SQL query.
    Issue #7305 - Fix an issue in query tool where custom keyboard shortcuts are not working for some.
    Issue #7304 - Fixed the issue where the update-user CLI command doesn’t change the password.
    Issue #7308 - Fixed issue related to email authentication of Two-factor authentication.
    Issue #7326 - Fixed a remote code execution issue in the validate binary path (CVE-2024-3116).

[close]

https://www.pgadmin.org/

[SiLæncer]

Changelog

    Connectivity:

    Using multiple jumps tunnels when connecting via SSH was supported
    Enable tunnel sharing option was added
    Test connection was fixed

    SQL Editor:

    WHERE TRUE and SELECT UNIQUE support was added
    Error with single quoted string was fixed
    Syntax highlighting after active schema change was fixed

    Data Editor:

    Automatic row count option was added (thanks to @utsav1704)

    Metadata editor:

    Deleting table comments was fixed
    Linking with the editor was fixed

    General:

    Ability to collect log files from the interface was added
    Transaction rollback behavior was fixed
    Metadata changes were removed from the commit counter
    Autocommit in production databases was fixed

    Data transfer:

    Ability to specify header case in the target file was added
    Typo in the confirmation dialog was fixed

    Databases:

    Cubrid: Query plan feature was added (thanks to @rathana-pvs)
    Old MySQL drivers were repacked
    PostgreSQL: Jobs, roles, and system information were hidden in the Hide Folders mode
    SQLite: Deleting columns was fixed

[close]

https://dbeaver.io/

[SiLæncer]

Changelog

    Enhancements:

    Asynchronously load libraries for png and pdf exports

    Bug fixes:

    Fix "instace analytics" typo
    Signed Embedding without Title will remove all the tabs of a dashboard as well
    SQL generated for datetime "is empty" filter on MSSQL is not correct
    Casting integer to Datatime via Table Metadata makes column unusable
    "No method in multimethod 'coerce-temporal' for dispatch value: [nil java.time.LocalDateTime]" when evaluating null datetimes
    Bigquery: Can't search field values for required partition tables
    Iframe embedding overflow widgets issue
    GUI model joining native ones break with column not found error
    Waiting for result tab title contains js code
    State of the FE gets lost on detail views when there are multiple joins to the same tables
    Manually choosing Axis in chart settings will break subscription
    Embedding height is not dynamic
    View Details: "is connected to:" uses wrong PK for query with join

[close]

https://www.metabase.com/

[SiLæncer]

Changelog

    When exporting to CSV (or JSON or XLSX) from an embedded report, the file only contains 'Unknown parameter :format_rows.' (#41240)
    Downloading results of an embedded question (via iframe) fails because of "Unknown parameter :format_rows" (#40959)
    Notebook query preview exists even before the data source is selected (#40608)
    Incorrect results from SQL query referencing saved question with more than 1,048,575 rows (#24969)
    Fix naming a filter offset or limit breaks dashboards (#40821)

[close]

https://www.metabase.com/

[SiLæncer]

Whats new:>>

    Improved data exporting to Excel (XLSX) format.
    Fixed bugs in configuring remote connections to file databases like Firebird, Interbase, Microsoft Access etc.
    Italian UI added.
    Minor changes.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

Enhancements

    CSV upload support for Redshift ( #36166 )
    Add INFO log for each table being fingerprinted ( #41365 )

Bug fixes

    Tab query param not applied in embed ( #41440 )
    Borders not respecting bordered=false parameter for static embedding ( #41393 )
    Progress visualizations don't show, except on dashboards ( #41243 )
    Wrong suggested join condition when joining 2 models ( #41202 )
    Advanced option to turn off syncing field values doesn't work ( #40715 )
    Progress visualisation not working, gives an error ( #40658 )
    Text filters shown as input box in embed instead as dropdown ( #37914 )
    SIGTERM during migration does not cleanly abort migration ( #37866 )

[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. See the timeline for details.

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

[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.3, DISQLite3 v5.48.3.

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

[SiLæncer]

Whats new:>>

    Thanks to the integration of the Liquibase tool, DDL scripts can now be generated to create database objects.
    This makes it possible to create subset databases from scratch using only on-board means.

http://jailer.sourceforge.net/