Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Powerful and versatile relational database system that provides a variety of ANSI SQL standard features and cross-platform support.

License: GPL

Release Notes: http://www.firebirdsql.org/file/documentation/release_notes/html/en/4_0/rlsnotes40.html

http://www.firebirdsql.org/en/start/

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

        Table alias generation was fixed (issue with duplicated aliases)
        Auto-proposals now respect option “empty line is a query delimiter”
        Auto-proposals calculation performance was significantly improved in some cases
        Aliases completion was fixed (issue with redundant spaces)
        Table name completion was fixed for invalid SQL queries
        Spelling errors and other annotations now work in console mode
        @import command behavior is now configurable

    Data editor:

        Filters/orderings/colors reset UI was significantly improved
        Spatial viewer now hides empty labels
        Copying of spatial viewport/selection bounds was fixed
        Drag-n-drop in grouping panel fixed on Linux
    Data transfer: previous export settings loading was fixed

    General:

        Auto-commit mode switch behavior was fixed
        CLI processing was fixed in multi-workspace environment
        “Tip of the day” now shows OS-specific shortcuts corectly
        Redundant logs of SSH tunnel closing were removed
        Logical database structure settings can be disabled or reset in the connection editor dialog
        Driver search UI was fixed on MacOS
        Number of minor UI bugs were resolved

    Database:

        Athena: multi-catalog support was added
        Derby: grouping queries generation fixed
        DuckDB: time/timestamp data types support was added
        MySQL: issue with missing table partitions folder was resolved
        Oracle: table DDL shows permission grants in “full” mode
        PostgreSQL: issue with duplicated tables was resolved
        Redshift: SQL dialect was enhanced with extra keywords
        Yellowbrick: execution plan visualization was fixed

[close]

https://dbeaver.io/

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

    Prevent open redirects for JWT/SAML (#32816)
    Certain invalid URL causes error response from Jetty (#23277)
    Migration from H2 to Postgres fails with Command failed with exception: ERROR: insert or update on table "metabase_table" violates foreign key constraint "fk_table_ref_database_id" (#32837)
    Very Inefficient query causing Metabase DB load to go to 100% [v0.46.6.4] (#32737)
    LDAP Attribute sync no longer works (#32243)
    "Expected native source query to be a string, got: clojure.lang.PersistentArrayMap" on nested queries (#32121)
    Snowflake won't sync without password (user using only private key) (#30376)
    Resizing columns in pivot tables in serialization breaks the card on load (#30130)
    :has_question_and_dashboard from api/user/current is always false (#29438)
    Basic actions become unusable if clauses are added to the model later (#28949)
    Cyclic load dependency when loading src/metabase/integrations/ldap.clj (#28751)
    snowplow events for task details can be too large (#28006)
    New interface Laggy and slow (#26534)
    Pulses with Conditional Formatting is displayed with black background, when value is above 999 (#13892)

[close]

https://www.metabase.com/

[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 improvements and bug fixes when working with SQL Server, PostgreSQL and MySQL databases. [Pro and Enterprise editions]
    Minor changes and bug fixes.

http://www.vlsoftware.net/

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

Improved some messy bits in the user interface with native-L&F.

http://jailer.sourceforge.net/

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

    Fixed issue: When copying data to the clipboard or exporting to tab-delimited file, every line contained an empty field in the end of the line.
    Fixed the export to tab-delimited file to work properly when a column value contains CR LF characters.

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

[SiLæncer]

Changelog

    Dashboards are smoother, quicker, and more organized
    Download dashboards to PDF
    Tabbed navigation on dashboards
    Flow between dashboards and questions smoothly
    Guide your team to the most valuable info by setting your home page to dashboard
    Load dashboards faster with the option to turn off auto-apply filters
    More granular grid for more control over dashboard creation
    Keep dashboards organized with full-width headings
    Can hide cards that have no results
    Metabase now keeps track of the dashboards you’re working with
    Upload and analyze data from CSV
    Powered up Pro features
    Unlock git-based workflows with serialization 2.0
    Set table-specific SQL editing permissions with connection impersonation
    Search for specific records, not just tables
    Other things that got better
    Drill-through menus are more intuitive
    Model X-rays
    Fresh icons

    Enhancements:

    Show new syncing tables as greyed out in data reference pane (#32591)
    Enable parameter substitution to Heading text cards (#32341)
    Fade Link Cards in mapping mode (#32264)
    Change number card minimum size to 2x2 (#32206)
    Provide admins with more context as to where they can change their homepage (#32050)

    Bug fixes:

    Update CSV permission check for "Unrestricted" access on the schema rather than any table (#32265)
    Don't allow CSV uploads when sandboxing is enabled (#32263)
    Bugs on People tab (#32451)
    Native parameters defaults change chart type after save or load (#33208)
    X ray cards load bottom to top (#33085)
    Deep copy dashboard with questions appends -- Duplicate with two dashes to duplicated questions (#33080)
    Query actions won't work when the ID dashboard parameter linked with model ID and action parameter get values from the URL (#32974)
    Columns with long names cause the visualization options sidebar to scroll horizontally (#32964)
    Zero on axis not rounded, has many decimal places with single-row chart (#32815)
    Nothing happens when clicking on search results in a link card (#32603)
    Action not found on dashboard on serdes v2 (#32575)
    side_nav=true does not work when going straight to a dashboard (#32542)
    Basic model action names are not translated (#32358)
    Can't clear dashboard description (#32346)
    Metadata column formatting tab stopped working in v0.47.0-RC2 (#32345)
    Custom homepage search errors when previously set within the same session (#32337)
    Cannot read properties of undefined (reading 'name') when adding an incomplete card (#32231)
    Don't offer to add new questions/ask new in a dashboard in a read-only collection (#32227)
    Don't offer to create new items on read only collections (#32224)
    Charts in admin Audit section load infinitely (#32210)
    Cards that are 1-2 grid units tall look broken in dashboard filter mapping mode (#32204)
    Force migration is broken (#32115)
    Adding filter of summarized field grouped by latitude and longitude on a map changes visualization type (#32075)
    “Invalid :expression reference: no expression named …” on stats (#32055)

[close]

https://www.metabase.com/

[SiLæncer]

Changelog

    Data editor:

    Dictionary viewer panel UI was redesigned
    Spatial data types: curved geometries linearizing was fixed
    Issue was result tab close on data save was resolved
    Column tooltips was fixed
    Charts rendering errors visualization was improved

    SQL editor:

    Autocompletion in single-line comments was fixed
    Variable value editor was fixed
    Smart completion for CTE queries (WITH/SELECT) was fixed
    @include command handler was fixed (reuse the console for the same included script)
    INSERT SQL query generation was fixed (identity columns)
    Issue with text search/replace in hidden files was fixed
    ERD editor: grid foreground color was fixed

    General UI:

    Objects sorting in tables now can be reset to the original ordering
    Network handlers (SSH, SSL, etc) UI was redesigned
    New object creation shortcut was added (Alt+Insert)
    External files opening was fixed on MacOS and Linux
    Command line connection opening was fixed
    User name/password prompt dialog as fixed for SSH tunnels
    Issue with preference pages in Eclipse plugin was resolved

    Accessibility:

    JAWS and Narrator support was improved for data editor and vertical tabs
    High contrast theme support was significantly improved

    Databases:

    Clickhouse: map and array data types visualization was added
    Greenplum: tables DDL was fixed (for version 7)
    OpenGauss DB: json data types support was added
    PostgreSQL: default native clients (pgsql, pg_dump) version was changed to 15
    Yellowbrick: stored procedures drop query was fixed

    Localization:

    Chinese localization was updated (thanks to @bianyun)

[close]

https://dbeaver.io/

[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 #2595 - Added Expression to CREATE INDEX.
    Issue #3942 - Added cascade option while creating an extension.
    Issue #5759 - Added ‘Ignore Grants’ option in the schema diff tool.
    Issue #6004 - Added ‘Ignore Tablespace’ option in the schema diff tool.
    Issue #6375 - Added support for ALTER INDEX column statistics.
    Issue #6376 - Added unlogged option while creating a sequence.
    Issue #6377 - Added all like options while creating a table.
    Issue #6381 - Added support for SYSTEM, CONCURRENTLY and TABLESPACE options in REINDEX.
    Issue #6382 - Added WAL option to EXPLAIN ANALYZE command.
    Issue #6397 - Added new/missing options to the VACUUM command.
    Issue #6415 - Added SKIP_LOCKED and BUFFER_USAGE_LIMIT option to Analyze command.
    Issue #6448 - Add support for TRUNCATE trigger in foreign table.
    Issue #6595 - Ensure that Schema Diff comparison results should be displayed in the sorted order.

    Housekeeping:

    Issue #3702 - Generate software bill of materials as part of the package builds.
    Issue #6588 - Added support for PostgreSQL and EPAS 16 to ensure it works without any errors.

    Bug fixes:

    Issue #5454 - Fix incorrect redirection URL after authentication by removing fixed value set to SCRIPT_NAME environment variable in pgAdmin4.wsgi file.
    Issue #6208 - Allow changing the POOL_SIZE and MAX_OVERFLOW config values of the pgAdmin config DB connection pool.
    Issue #6252 - Fix an issue where query tool on shared server is throwing error if the pgAdmin config DB is external.
    Issue #6420 - Fix the query tool issue where raise Notice from func/proc or code blocks are no longer displayed live.
    Issue #6500 - Fix the issue where query tool window turns blank if the user tries to generate a graph on the result.
    Issue #6624 - Fix an issue where changing MFA_SUPPORTED_METHODS breaks the MFA validation.
    Issue #6630 - Fix an issue where pgAdmin 7.5 fails to render table SQL with extension loaded index method.
    Issue #6639 - Fix an issue where cycle syntax was not added in SQL when creating new sequence from UI.
    Issue #6651 - Fix an issue where the SET directive is excluded from the function header in the schema diff tool.
    Issue #6660 - Fix a query tool error ‘pgAdminThread’ object has no attribute ‘native_id’.
    Issue #6664 - Ensure keyboard shortcut for query execution is disabled when query execution is in progress.

[close]

https://www.pgadmin.org/

[SiLæncer]

Changelog

    Add support for Contentless-Delete FTS5 Indexes. This is a variety of FTS5 full-text search index that omits storing the content that is being indexed while also allowing records to be deleted.
    Added the octet_length(X) SQL function.
    Added the sqlite3_stmt_explain() API.
    Performance enhancements to JSON processing results in a 2x performance improvement for some kinds of processing on large JSON strings.
    New makefile target "verify-source" checks to ensure that there are no unintentional changes in the source tree. (Works for canonical source code only - not for precompiled amalgamation tarballs.)
    Added the SQLITE_USE_SEH compile-time option that enables Structured Exception Handling on Windows while working with the memory-mapped shm file that is part of WAL mode processing. This option is enabled by default when building on Windows using Makefile.msc.
    The VFS for unix now assumes that the nanosleep() system call is available unless compiled with -DHAVE_NANOSLEEP=0.

    Enhancements to the date and time functions:

    Added new time shift modifiers of the form ±YYYY-MM-DD HH:MM:SS.SSS.
    Added the timediff() SQL function.

    Query planner enhancements:

    Generalize the LEFT JOIN strength reduction optimization so that it works for RIGHT and FULL JOINs as well. Rename it to OUTER JOIN strength reduction.
    Enhance the theorem prover in the OUTER JOIN strength reduction optimization so that it returns fewer false-negatives.

    Enhancements to the decimal extension:

    New function decimal_pow2(N) returns the N-th power of 2 for integer N between -20000 and +20000.
    New function decimal_exp(X) works like decimal(X) except that it returns the result in exponential notation - with a "e+NN" at the end.
    If X is a floating-point value, then the decimal(X) function now does a full expansion of that value into its exact decimal equivalent.

[close]

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

[SiLæncer]

Whats new:>>

    Support for "Infinity/-Infinity/NaN" for dates and floating point numbers.
    See https://sourceforge.net/p/jailer/discussion/700499/thread/7741dc8aa3
    Canceling the execution of long scripts in the SQLConsole did not work reliably. This has been corrected.
    More minor improvements to the user interface.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

    Changes since 23.1.5:

    Data Editor:

    Spatial values rendering was fixed
    Spatial images capture was fixed
    Special characters rendering was improved
    Grouping panel icons were improved
    ER Diagrams: saved diagrams now can be opened on another computers
    Data transfer: import settings handling was improved

    Accessibility:

    Connection dialog now supports screen readers
    Cell value reading was improved
    Ctrl+Shift/Alt+PageDn: vertical tabs switch
    Ctrl+ALT+6: SQL editor and results tab switch
    Ctrl+Shift+Enter now opens ER diagram entities
    Ctrl+Shift+N: new connection dialog open

    Database drivers:

    Bigquery: DDL for tables, views and stored procedures was added
    Clickhouse: arrays and structures visualization was fixed
    Greenplum: external tables reading was fixed
    Teradata: issue with the missing templates was fixed
    Many minor UI and database issues were resolved

[close]

https://dbeaver.io/

[SiLæncer]

Whats new:>>

Preserving the desktop view position after the maximization of a table browser.

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

    Enhancements:

    Switch pulse email sending to use bcc instead of sending a seperate email
    Show new syncing tables as greyed out in data reference page
    Bottom corner radius on buttons looks weird on new dashboard grid
    Update default and min size constraints for dashboard cards

    Bug fixes:

    Only log session cookie SameSite=None warning when connection is insecure
    Don't delete a connection impersonation policy when non-data perms are updated
    Remove unused "No changes to permissions will be made." confirmation in PermissionsEditBar
    Performance regression in how we parse query_metadata response leads to notebook being unusable
    Subscriptions should send a single email with all recipients in Bcc
    Wrong URL manipulation when configuring GTAPs when running on a sub path
    Change in Snowflake Driver adds a default role ACCOUNTADMIN instead of using user default
    Data Model Field Formatting settings should only show currency settings for currency fields
    Impersonated security: a user who does not have an attribute defined to access the database can see the data
    Role-based security at database level does not work if the role contains special characters such as the dot.
    Pie charts cut off in dashboard
    Link cards in dashboards shouldn't open in a new window unless you command+click them
    Question name not displayed when changing click behavior
    Invalid redirect URL when doing JWT SSO
    Redundant network requests triggered in object detail modal
    Some audit queries return empty results with an H2 application database
    Redundant separator displayed in table filter popup
    Empty column gets treated as series breakout in line chart
    Assert failed: No more than 1024 pending puts are allowed on a single channel
    Inconsistent icon position in pinned dashboard item loading state
    Duplicating a model creates a new model that uses the original model
    Formatting for field in Data Modeling is no longer working
    Keyboard active when object detail modal is open
    Stale UI for the Official collections menu
    Do not prompt non-admin users to configure email or Slack
    Broken added series on dashcard prevents you from editing the card

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

Fixed: Issues with inserting default values within the data grid. (MySQL, Postgress, Interbase/Firebird and SQLite)

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