Thema: Datenbanksoftware und Tools diverses ...

[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 connections can now be assigned to a database type (Develop, Test, Staging and Production).
    This improves the transparency of the various databases and encourages careful interaction of (near-)production systems.
    Readability of the generated DML has been improved.
    "orai18n"-jar has been added to the Oracle JDBC driver.

http://jailer.sourceforge.net/

[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: https://www.firebirdsql.org/file/documentation/release_notes/html/en/4_0/rlsnotes40.html

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

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

    Fix exporting dashboard with configured click_behavior (#35913)
    Fixing bad performance due to massive pprint statements (#35895)
    Fix serdes of click_behavior on dashcards (#35717)
    avoid calling fetchCardData in undoRemoveCardFromDashboard for virtual cards (#35545)
    Respect "enable nested queries" setting and database's "nested queries" feature (#35490)
    Add an option in the /admin/settings/email to opt-in to CC recipients (#34293)
    Export throws a Unexpected character ('b' (code 98)) (#35880)
    Export throws a NullPointerException (#35855)
    API returns 500 instead of 404 when visiting an non-existing card (#35692)
    A big warning that if you use CSV uploads in the sample database in the cloud, your data will disappear (#35638)
    Serialization import doesn't remove dashboardcards in the target instance (#35420)
    Filters blink when there are many lines of filters in an embedded context with headers=false (#35078)
    Users with read-only permissions to collections are shown "edit question" option in dashboard cards (#35077)
    Text weirdly wrapped in column dropdown in Polish language (#35047)
    Pivot viz fails on a nested question (#35025)
    '-' sign misplaced in shortened visualization of currency type (#34242)
    Log why Serialization v2 fails when trying to export a dashboard that contains cards in outside collections (#33882)
    Click behavior: dashboard and saved question links are not preserved during export / import (#33699)
    Don't offer to create models or use nested questions on 3rd party drivers which don't support it (#33401)
    e.some is not a function breaks the FE on the filter modal (#32985)
    Linked fiters won't work if you use a question to populate filter values (#31218)
    Disabled "Nested Queries" setting is not always respected (#28908)
    Filter dropdown not showing remapped values on the dashboard (#21528)

[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

    SQL editor:

    Syntax coloring and code completion: smart columns abd aliases recognition was added (experimental)
    Numerous improvements in single-tab results visualization
    Quoting of identifiers with special characters was fixed
    Issue with read-only column in queries with comments was resolved
    COMMIT/ROLLBACK statements are now recognized as transaction state change statements

    Data transfer:

    Issue with unquoted column names was resolved (data import)
    File import toolbar was redesigned
    Library for XLSX export/import was updated, many minor issues were resolved

    Accessibility:

    Screen-readers support was improved (JAWS)
    Editor tab names reading was fixed
    ER diagrams: issues with notation switch were resolved

    General:

    Issue with output file name after multiple executions of data export task was resolved
    Error “Data transfer IO error” was resolved
    Comments in generated DDL now can be disabled (configurable)
    Countdown visualization before auto-close was added for idle transactions
    Extra tips added in connection keep-alive configuration
    Database navigator: click in empty space handle was fixed (thanks to @itsyfx)

    Databases:

    MySQL:

    Driver version was upgraded to 8.
    Legacy MySQL 5.x driver was deprecated and replaced with MySQL 8 driver

    Oracle:

    Materialized views indexes management was supported
    Materialized views permissions and dependencies view was added
    Column alter DDL was fixed (NULL clause)

    PostgreSQL:

    Issue with VARCHAR limit change was fixed
    Function comment delete support was added
    SQL Server: extra dialect keyword were added (thanks to @brunodmartins)

[close]

https://dbeaver.io/

[SiLæncer]

Whats new:>>

A feature for exporting and importing data models and their database connections has been created.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

    Change the CLI so that it uses UTF-16 for console I/O on Windows. This enables proper display of unicode text on old Windows7 machines.
    Other obscure bug fixes.

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

[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 #2821 - Have close buttons on individual panel tabs instead of common.
    Issue #4733 - Allow closing all the tabs, including SQL and Properties.
    Issue #5394 - Changes in the context menu on panel tabs - Add close, close all and close others menu items.

    Housekeeping:

    Issue #6441 - Update app bundle built to use notarytool instead of altool.
    Issue #6479 - Replace the current layout library wcDocker with ReactJS based rc-dock.
    Issue #6850 - Upgrade Flask, Werkzeug and other modules depends on the latest version of Flask.

    Bug fixes:

    Issue #2986 - Fix an issue where the scroll position of panels was not remembered on Firefox.
    Issue #5770 - Add DROP SQL for foreign keys in SQL generated by ERD when using WITH DROP option.
    Issue #5807 - Fixed an issue where psql was not taking the role used to connect in server properties.
    Issue #6017 - Fixed an issue where Geometry Viewer renders geometry incorrectly after trying to view 3D or non-4326 SRID geometry.
    Issue #6459 - Fix the sorting of size on the statistics panel.
    Issue #6487 - Fixed restoration of query tool database connection after dropping and re-creating the database with the same name.
    Issue #6602 - Fix an issue where the default server-group is being deleted if the load-server json file contains no servers.
    Issue #6720 - Fix an issue of the incorrect format (no indent) of SQL stored functions/procedures.
    Issue #6769 - Server config information in the about dialog should be only visible to admin users.
    Issue #6784 - Fixed an issue where Schema Diff does not work when the user language is set to any language other than English in Preferences.
    Issue #6817 - Fixed the query generated when creating subscription where copy_data parameter was missing.
    Issue #6820 - Ensure backup/restore/maintenance works with invalid pgpass file parameter.
    Issue #6835 - Fix an issue where OAUTH_ADDITIONAL_CLAIMS does not recognise AzureAD with > 150 groups.
    Issue #6840 - Fixed circular import error occurring while deploying cloud PostgreSQL instance from pgAdmin.
    Issue #6874 - Fix an issue where the browser window stuck on spinning with an Oauth user without email.
    Issue #6875 - Fix an issue where import/export data is not working for shared servers.
    Issue #6877 - Remove the max length of 255 from password exec command in server configuration dialog.
    Issue #6884 - Remove gettext from empty strings in the title of the storage graph.
    Issue #6902 - Fixed an issue where the change server password is not working in desktop mode.
    Issue #6904 - Fix a crash issue occurring when debugging a function with arguments when using pgAdmin with external config database.
    Issue #6920 - Fix an issue in ERD tool where SQL generated is missing columns for the table.
    Issue #6934 - Clear the password field in the config database on clear saved server password.
    Issue #6962 - Fixed an issue where the data type of the array type was not visible for the column in the Foreign Table dialog.

[close]

https://www.pgadmin.org/

[SiLæncer]

Changelog

    Aggregate functions can now include an ORDER BY clause after their last parameter. The arguments to the function are processed in the order specified. This can be important for functions like string_agg() and json_group_array().
    Add support for the concat() and concat_ws() scalar SQL functions, compatible with PostgreSQL, SQLServer, and MySQL.
    Add support for the string_agg() aggregate SQL function, compatible with PostgreSQL and SQLServer.
    New conversion letters on the strftime() SQL function: %e %F %I %k %l %p %P %R %T %u
    Add new C-language APIs: sqlite3_get_clientdata() and sqlite3_set_clientdata().
    Many errors associated with CREATE TABLE are now raised when the CREATE TABLE statement itself is run, rather than being deferred until the first time the table is actually used.
    The PRAGMA integrity_check command now verifies the consistency of the content in various built-in virtual tables using the new xIntegrity method. This works for the FTS3, FTS4, FTS5, RTREE, and GEOPOLY extensions.
    The SQLITE_DBCONFIG_DEFENSIVE setting now prevents PRAGMA writable_schema from being turned on. Previously writable_schema could be turned on, but would not actually allow the schema to be writable. Now it simply cannot be turned on.
    Tag the built-in FTS3, FTS4, FTS5, RTREE, and GEOPOLY virtual tables as SQLITE_VTAB_INNOCUOUS so that they can be used inside of triggers in high-security deployments.
    The PRAGMA case_sensitive_like statement is deprecated, as its use when the schema contains LIKE operators can lead to reports of database corruption by PRAGMA integrity_check.
    SQLITE_USE_SEH (Structured Exception Handling) is now enabled by default whenever SQLite is built using the Microsoft C compiler. It can be disabled using -DSQLITE_USE_SEH=0
    Query planner optimizations:
        In partial index scans, if the WHERE clause implies a constant value for a table column, replace occurrences of that table column with the constant. This increases the likelihood of the partial index being a covering index.
        Disable the view-scan optimization (added in version 3.42.0 - item 1c) as it was causing multiple performance regressions. In its place, reduce the estimated row count for DISTINCT subqueries by a factor of 8.
    SQLite now performs run-time detection of whether or not the underlying hardware supports "long double" with precision greater than "double" and uses appropriate floating-point routines depending on what it discovered.
    The CLI for Windows now defaults to using UTF-8 for both input and output on platforms that support it. The --no-utf8 option is available to disable UTF8 support.

Prior changes from version 3.44.1 (2023-11-22):

    Change the CLI so that it uses UTF-16 for console I/O on Windows. This enables proper display of unicode text on old Windows7 machines.
    Other obscure bug fixes.

Changes in this specific patch release, version 3.44.2 (2023-11-24):

    Fix a mistake in the CLI that was introduced by the fix (item 15 above) in 3.44.1.
    Fix a problem in FTS5 that was discovered during internal fuzz testing only minutes after the 3.44.1 release was tagged.
    Fix incomplete assert() statements that the fuzzer discovered the day after the previous release.
    Fix a couple of harmless compiler warnings that appeared in debug builds with GCC 16.

    Hashes:
    SQLITE_SOURCE_ID: 2023-11-24 11:41:44 ebead0e7230cd33bcec9f95d2183069565b9e709bf745c9b5db65cc0cbf92c0f
    SHA3-256 for sqlite3.c: bd70b012e2d1b3efa132d905224cd0ab476a69b892f8c6b21135756ec7ffbb13

[close]

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

[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 in SQL editors. [Pro and Enterprise editions]
    Minor bug fixes in table mappings interface. [Enterprise edition]
    Minor changes.

http://www.vlsoftware.net/

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

Changelog

    New features:

    Issue #4580 - Add support for generating ERD for a schema.
    Issue #6854 - Add support for creating a function with custom return type.

    Housekeeping:

    Issue #6991 - Fixed several accessibility-related issues for enhanced usability.

    Bug fixes:

    Issue #5471 - Ensure focus is not changed to ssh tunnel password input when user explicitly focus on server password input.
    Issue #6095 - Provide a way to bypass the SSL cert verification for OAuth2 provider.
    Issue #6488 - Fixed an issue where database name was missing in an error message if name contains any special characters.
    Issue #6717 - Ensure that indexes created by constraints are visible in the object explorer when “Show system objects” is enabled.
    Issue #6803 - Fixed an issue where reading process logs throws an error when DATA_DIR is moved to a networked drive.
    Issue #6814 - Remove the ‘Close Window’ submenu specifically for OSX to prevent unintended closure of the entire application.
    Issue #6842 - Rename all references of ‘Execute query’ to ‘Execute script’ to be more relevant.
    Issue #6887 - Fixed an issue where syntax error was not highlighting in query tool.
    Issue #6921 - Fixed an issue where on entering full screen, the option label is not changed to ‘Exit Full Screen’ in desktop mode.
    Issue #6950 - Ensure that the Authentication Source in the drop-down of the UserManagement dialog aligns with the entries specified for AUTHENTICATION_SOURCES in the configuration file.
    Issue #6958 - Reverse engineer serial columns when generating ERD for database/table.
    Issue #6964 - Fixed an issue where the Schema was not visible in the dropdown for table properties or when creating a new table.
    Issue #6968 - Fixed an issue where option key was not registering in PSQL tool.
    Issue #6984 - Fixed an issue where the Vacuum option INDEX_CLEANUP have an incorrect value (‘AUTO’) for database versions < 14.
    Issue #6989 - Fixed an issue where the pgAdmin page went blank when clicking the delete button in the User Management dialog.
    Issue #7000 - Ensure that correct timezone is set for Docker deployments.
    Issue #7011 - Fixed an issue where all rows and filter rows buttons of object explorer toolbar were disabled for views and other supported nodes.
    Issue #7017 - Fixed an issue where schema diff tool is not loading preferences on start.

[close]

https://www.pgadmin.org/

[SiLæncer]

Changelog

    Enhancements:

    Introduce Metabase analytics Collection (#35434)
    Add Finnish language (#33477)
    Clean up the pulse page (#36811)
    Allow spaces in datetime strings for CSV uploads (#35648)
    Check if inactive tables are being used by questions before deleting them (#35615)
    Make SESSION_COOKIE_SAMESITE a setting (#35021)
    Optimize global search 20% (#35367)
    Auto-wire up dashboard field filters (#35147)
    Add percentage type to metadata (#35124)
    Make MB_AUDIT_MAX_RETENTION_DAYS truncate data from the view_log or audit_log table and enforce new rules (#34985)
    Explain why linked filters don't work and prevent accidentally disabling them (#34604)
    Prevent users from adding questions from personal collections to dashboards in public collections (#34733)
    Let people move cards between dashboard tabs (#34367)
    Allow Linking dashcards to dashboard tabs (#34779)
    Update dashboard performance 48 (#34721)
    Allow users to link dashcard to dashboard tab in Click Behavior sidebar (#34781)
    Add custom warning message when leaving creating a model (#34430)
    Add custom warning message when leaving creating an SQL question (#34429)
    Add custom warning message when leaving editing a notebook question (chill mode only) (#34428)
    Show custom warning message when leaving editing model via Cancel button (#34366)
    Show custom warning message when leaving editing dashboard via Cancel button (#34074)
    Prevent users from losing their changes via “Back” and in-app navigation (#33749)
    Add custom warning message when leaving changing Data Model (segments and metrics) (#33795)
    Add custom warning message when leaving creating/editing a DB connection (#33794)
    Add custom warning message when leaving editing a model (query definition or metadata) (#33793)
    Add custom warning message when leaving editing an existing SQL (#33792)
    Add custom warning message when leaving creating/editing a query action in model details page (#33791)
    Add custom warning message when leaving editing dashboard (#33790)
    Prevent users from losing their changes via “Back” and in-app navigation (#33749)
    Auto-generate primary keys for CSV uploads (#33713)
    Enable “Add all” / “Remove all” behavior in table settings (#33472)
    Provide column ordering / hiding options from table header dropdown (#12494)
    Add "Create new Collection" option to collection picker when duplicating (#32638)
    Allow basic deletes and updates on object detail views (#32320)

    Bug fixes:

    CSV uploads: Can't upload CSV with a column that has boolean and integer values (#36629)
    fix card filter connection (#36657)
    add skip-graph query param to PUT api/permissions/graph (#36724)
    "$regex has to be a string" when using text filters on dashboards on MongoDB (#30136)
    "Add a time" filter in dashboard filters not working (#34615)
    "Don't bin" is not selected on the picker in temporal bucketing (#35550)
    "Enter a default valu" on required filter values in SQL questions (#24988)
    "One of your alerts has stopped working" email should provide more detail (#25693)
    [AuditV2] All items in custom reports collection are read only (#35836)
    [AuditV2] Allow loading instance analytics into h2 (#33280)
    [AuditV2] Feature Branch 2 (#35434)
    [Epic] Add test coverage for Dashboard Click Behavior (#31498)
    [Epic] Allow basic deletes and updates on object detail views (#32320)
    [Epic] Audit v2 (#27792)
    [Epic] Auto-gen CSV PKs (#33713)
    [Epic] Auto-wire up dashboard field filters (#35147)
    [Epic] Enable “Add all” / “Remove all” behavior in table settings (#33472)
    [Epic] Explain why linked filters don't work and prevent accidentally disabling them (#34604)
    [Epic] Let people move cards between dashboard tabs (#34367)
    [Epic] Linking dashcards to dashboard tabs (#34779)
    [Epic] Prevent users from adding questions from personal collections to dashboards in public collections (#34733)
    [Epic] Prevent users from losing their changes via “Back” and in-app navigation (#33749)
    [Epic] Support filtering in global search results (#27982)
    [MLv2] - A question joined on itself can cause FK columns to be displayed twice (#34742)
    [MLv2] - findColumnIndexesFromLegacyRefs can't match Dataset columns to implicit breakouts (#35152)
    [MLv2] [Bug] replace-clause doesn't handle metrics (#32049)
    [MLv2] [Bug] replace-clause is broken with joins (#32026)
    [MLv2] [Bug] Error when calling available-join-strategies (#32081)
    [MLv2] [Bug] Error when joining a saved question (#32758)
    [MLv2] [Bug] Error when using replace-clause with joins (#32454)
    [MLv2] [FE] Add sort drill (#34458)
    [MLv2] Add filterOperator() function to get operator from a filter clause (#32058)
    [MLv2] Add stage-count method (#35719)
    [MLv2] BE - Expose findMatchingColumn (#35675)
    [MLv2] Disambiguate columns: :field ref(:filter drill-thru))))s shouldn't match expressions (#35872)
    [MLv2] Enable access to field IDs from column metadata (#32160)
    [MLv2] Implement functions for available filters (#28703)
    [MLv2] Join conditions should sync temporal units (#32759)
    [Mlv2] Make ambiguous matches a warning in lib.equality (#36197)
    [MLv2] Native query manipulation functions (#31006)
    [MLv2] Need functions like "expressionableColumns" (name?) (#31155)
    [MLv2] Only mark selected columns for aggregations with columns (#36572)
    [MLv2] Selected LHS/RHS column is missing bucket info in join-condition-columns methods (#33082)
    [MLv2] Use MLv2 to display drill-thru controls (#31007)
    [Move dashcard to another tab] milestone 2 - undo logic (#34961)
    [Testing Plan] Linking dashcards to dashboard tabs (#34780)
    More options... button in a boolean filter is not aligned with the previous options (#22253)
    A question opened from a dashboard may look broken (#26849)
    Add "Create new Collection" option to collection picker when duplicating (#32638)
    Add a note in /admin/audit/ that Audit is being replaced by the Metabase analytics collection (#35295)
    Add ability to remove columns from column header settings (#28608)
    Add default delete action to actions dropdown in object detail modal (#32323)
    Add default update action to actions dropdown in object detail modal (#32322)
    Add expression-clause-for-legacy-expression (#35936)
    Add expression-name and with-expression-name (#35932)
    Add Metabase version to card definition (#28387)
    Add Metabase version to revision history (#29167)
    Add more tests that v2 serdes is comprehensive, so new models are not forgotten (#35540)
    Add percentage type to metadata (#35124)
    Add support for conditional formatting on boolean fields (#14939)
    Add test coverage for Dashboard Click Behavior - Line Chart (#35034)
    Add test coverage for Dashboard Click Behavior - Table & Full app embedding (#35035)
    Add test to ensure new driver methods are mentioned in driver changelog (#31736)
    Adding a tab to a dashboard makes the dashboard shows double in collection view (#35351)
    Adding Percent Metadata Type (#36145)
    Alert/Dashboard subscription: render question title as tag (#36220)
    Allow spaces in datetime strings for CSV uploads (#35648)
    Allow users to link dashcard to dashboard tab in Click Behavior sidebar (#34781)
    Attribute input teleports when adding user attributes (#35316)
    Audit db sync cannot happen (#35621)
    Auditv2- FE: hide the archive and move button for the custom reports (#35212)
    auto-adding filter targets on dashboards breaks dashboard (#36275)
    Auto-connecting filter fails when adding a new question (#36469)
    Automatic explorations compare to the rest option fails for questions with joined table data present in the result (#25278)
    BE - expressionClauseForLegacyExpression returns raw mbql instead of ExpressionClause (#36075)
    BE: add an endpoint to fetch default values for an implicit action (#32435)
    breakoutableColumns from MLv2 takes more than 600ms to execute for some questions (#35205)
    Broken UI when adding multiple user attributes if keys start with the same string (#30196)
    Can see move and archive buttons for metabase analytics collection in the root collection (#35700)
    Can't aggregate if the source question is an aggregated question (#24839)
    Can't choose recently viewed link with the mouse when editing dashboard link card (#35037)
    Can't subsequently run actions for different objects from dashboards (#33084)
    Cancel Database Analyze & Sync and Add DB connection check before start (#7526)
    Cannot remove filter defaults on Subscriptions (#24223)
    Changing columns via visualization Settings makes Notebook column list inconsistent (#12044)
    Check if inactive tables are being used by questions before deleting them (#35615)
    Compare to the Rest generates dashboard with failing questions (#32557)
    Composite join keys aren't auto-populated when joining in notebook editor (#34184)
    Compute results of timestamp/current-date functions during query processing (#21518)
    Convert click-behavior utils to TypeScript (#35200)
    Convert to SQL results in SQL error for generated query (#36078)
    Create Admin Setting for MB_SESSION_COOKIE_SAMESITE (#35392)
    CSV uploads use a lot of memory (#31992)

[close]

https://www.metabase.com/

[SiLæncer]

Changelog

    SQL Editor:
        Syntax highlighting was improved
        Highlighting in nested queries and on query editing was fixed
        Scrolling with opened Outline was fixed
        Applying settings to Outline was fixed
        Order by i.* was supported in Outline
        Joined tables presentation in Outline was fixed
    AI: Ability to send object descriptions to OpenAI was added
    Data Editor:
        Scrolling multiple tab result was improved. You can scroll all result sets using Ctrl
        Fetch next page shortcut was changed to CTRL+ALT+N
    ER Diagram: Connections rendering was improved
    Data transfer:
        The Proceed button at the last step became more visible
        On conflict expression was added to INSERT statements
        Crash when importing CSV file was fixed
        Extra space before the semicolon in export to SQL was removed
    General:
        Close idle connection setting saving was fixed
        Application launch was improved
        Unexpected transaction ending was fixed
        Settings are applied to new connections without a restart
        User credential dialog was fixed
        Issue with the background task of the dashboard update was fixed
        Temporary directory creation was fixed
    Security: Added warning when trying to open an encrypted project and risk losing all connection credentials
    New driver:
        StarRocks database support was added
    Databases:
        MariaDB driver was updated to version 3.3.2
        Oracle:
            Keywords and schemes highlighting was improved
            Default subpartition type was added
        PostgreSQL:
            Creating a new table from the user interface was fixed
            Duplication of procedures was fixed
        Snowflake: VIEW keyword highlighting and validation was improved
        SQL Server: syntax highlighting was fixed
        Sybase:
            Stored procedure creation was added
            Using create view instead of Alter view was fixed
            Import with table mapping was fixed
    Localization:
        French translation was updated (thanks to @Jean-BaptisteC)
        Babel version was updated

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

    Add: Allow BLOB data type import processing
    Fix: Fix the problem of Keep Identity losing its function (SQL Server/SQL Azure/SQLCe/Sybase ASE/VistaDB)
    Connection Manager:

    Fix: Fixed the problem that the related functions of the right-click menu of the project after copying the connection are not updated simultaneously

    Update: Improved object deletion and removal enabled status processing (including online browsing)
    Object Explorer:

    Fix: (Firebird) Remove generated() null characters when executing stored procedures without parameters
    Index Designer:

    Fix: (PostgreSQL) Fixed multi-field check display problem

    SQL Editor:

    Update: Single-line batch SQL statement processing adds EXECUTE syntax parsing
    Update: Improve batch SQL statement custom delimiter (DELIMITER, SET TERM) parsing capabilities

    Main program update (Main):

    Add: Support Firebird 5 database system
    Contains support for partial indices, reserved words...etc.
    Upd: SQL Server/SQL Azure component version updated to Microsoft.Data.SqlClient 5.1.5 (2024/01/27)()
    Update: Others include cumulative minor updates, corrections and optimizations

    Database Migration (Pro):

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

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

    Problems regarding the performance of object bindings have been fixed.
    The semantics of the "fetchSize" property in "jaier.json" have been changed. It is now always relevant, not just when it is negative.
    Minor improvements to the user interface.

http://jailer.sourceforge.net/