Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Whats new:>>

    Fix a regression in the way that the sum(), avg(), and total() aggregate functions handle infinities.
    Fix a bug in the json_array_length() function that occurs when the argument comes directly from json_remove().
    Fix the omit-unused-subquery-columns optimization (introduced in in version 3.42.0) so that it works correctly if the subquery is a compound where one arm is DISTINCT and the other is not.
    Other minor fixes.

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

[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

    Updatable query results:
    Add: Support PrimaryKey Selector processing (8656)
    Fix: Fixed the problem that the sub-option [E] of Edit this table (Edit this table) cannot obtain node information (8656)
    Object Explorer:
    Add: Advanced browsing (Open->[ADV]) and advanced editing (Edit->[ADV]) of data tables: Support SQL statement preview display (8656)
    Add: Advanced browsing (Open->[ADV]) and advanced editing (Edit->[ADV]) of data tables: Support primary key descending sort (ORDER BY PKs DESC) (8656)
    Database Diagram:
    Upd: Support cross-schema data table processing and improve processing speed (8656)
    Update: Object name adds structure description name display (Schema Name) (8656)
    Security Manager:
    Upd: (SQL Server) Add support for legacy databases (<10) Server Roles (8656)
    Generating Scripts:
    Upd: Foreign Keys support cross-schema definition (8656)
    Connection Profile:
    Fix: Fixed drop-down browsing SCHEMAS/DATABASES control item not supporting SSH enable processing (8656)
    Main program update (Main):
    Upd: Others include cumulative minor updates, corrections and optimizations (8656)
    Database Migration (Pro):
    Update: All updates are the same as dbMigration .NET software (8656)

[close]

http://fishcodelib.com/Database.htm

[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

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

    Clear cache when performing version upgrades (#33457)
    Performance improvement in notebook editor (#33676) (#12378)
    Metabase will not let you update the cert if it was rotated (#33452)
    Some table columns are unable to be rendered (#33279)
    Download results (.csv, .json, .xlsx) request does not include subpath when deploying on subpath (#33244)
    Table column is not visible in object detail view when its visibility is set to "only in detail views" (#32718)
    Not possible to include time when filtering dates in dashboards (#28188)

[close]

https://www.metabase.com/

[SiLæncer]

Changelog

    Update: Others include cumulative minor updates, corrections and optimizations (8662)
    Update: All updates are the same as dbMigration .NET software (8662)
   

[close]

http://fishcodelib.com/Database.htm

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

Automatic "Where" clause adjustment in SQL console did not work correctly for queries with an "Order by" clause, but no "Where".

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:

    Issue #2078 - Show object breadcrumbs path along with its comment on object hover.
    Issue #3275 - Allow on demand record count setting to be changed per user using preferences.
    Issue #3316 - Added support to show statistics for materialized views.
    Issue #3318 - Added support to create an unnamed index.

    Housekeeping:

    Bug fixes:

    Issue #5044 - Fixed an issue where query tool hangs for some time when multiple columns are selected to open geometry viewer.
    Issue #5777 - Fixed an issue where the browser tree state is not remembered when reopening pgAdmin.
    Issue #5820 - Fixed an issue where collation was set to none if we remove it while creating partitioned table.
    Issue #5922 - Ensure that when pasting a row in query tool grid, default value is used for autogenerated/serial columns.
    Issue #6059 - Show proper message if the debugger is stopped by the user.
    Issue #6075 - Ensure that the save button is enabled when registering a new server fails due to an API error.
    Issue #6077 - The search object, query tool, and psql tool menu should not be displayed for pgAgent.
    Issue #6120 - Fixed error occurring while logging out from pgAdmin keeping a query tool opened.
    Issue #6128 - Fix a SQL error occurring on roles dependents SQL.
    Issue #6130 - Ensure to quote the primary key value if needed while deleting rows from the table.
    Issue #6137 - Fixed error occurring while dumping the servers from CLI.
    Issue #6138 - Throw an appropriate error when a table for which View/Edit data is open, is deleted, and query is executed.
    Issue #6151 - Ensure that internal users are able to login when auth sources are [ldap, internal].
    Issue #6158 - Fixed an issue with the properties tab not getting updated if the user updates the selected node.
    Issue #6159 - Ensure that the ERD tool should work with the external database after moving to psycopg3.
    Issue #6180 - Fixed an issue where PSQL is not working if the PGUSER env variable is set and service file is used for server connection details.
    Issue #6183 - Mac crash when you press Command-Shift-C.
    Issue #6189 - Fix an issue in View SQL when column level privileges are set with multiple roles.
    Issue #6191 - Fixed an issue where Reset Password is not working after upgrading to latest flask-security-too.
    Issue #6234 - Usernames/roles with special character are not double quoted when assigning privileges.

[close]

https://www.pgadmin.org/

[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

Whats new:>>

    Up SQLite to 3.43.1
    Import public Google Spreadsheets
    UI improvements
    Fix minor bugs

https://github.com/little-brother/sqlite-gui

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

    Aliases proposals for tables with joins were improved
    SQL console can now be saved as a script
    Enhanced smart completion is enabled (configurable)
    Issue with big string contents (json, xml) edit was resolved
    JSON formatting in the separate editor was fixed
    Ctrl+Alt+6 shortcut was changed to Ctrl+Alt+T
    JSON functions keywords were added to the SQL Assist
    Representation of errors on query execution was fixed

    ER Diagrams:

    Crow’s foot and Bachman diagram notation styles were added
    Issue with duplicate relations on the diagram was fixed

    Data Editor:

    Big content representation end editing was limited to 1MB (configurable)
    User can now add a shortcut for setting row color
    Issue with hiding the wrong column from the context menu was resolved
    Grouping panel now shows actual executed SQL
    Decimal rounding error was fixed

    General UI:

    When exporting a project, a warning about replacing an existing project was added (thanks to @MontejoJorge)
    Scroll bars were added on the connection page, and other wizards
    Issue with broken quotes in localization files was resolved

    Connectivity:

    Driver download UI was improved: already downloaded driver files are colored in grey
    JDBC drivers maven artifacts resolve was fixed
    The “Propagate driver properties” option was added to the driver settings

    New drivers:

    JDBCX driver was added (thanks to @zhicwu)

    Databases:

    Clickhouse: IPv4 data representation was fixed
    Greenplum: External tables representation was fixe
    MySQL: Unsupported engine types are replaced with the default one

    Oceanbase:

    Views editor was supported
    Routines and procedure parameters read was fixed

    PostgreSQL:

    Foreign tables folder was added
    Enum data types reading performance was enhanced
    Redshift: Backup/Restore tools were deprecated and removed from UI

    Snowflake:

    Driver was updated to 3.13.25
    Materialized views are now supported
    Schema create UI was enhanced was enhanced
    Trino: Views DDL support was added

[close]

https://dbeaver.io/

[SiLæncer]

Changelog

    Bug fixes:

    Use HTTPS when getting version-info
    Better deduplication for entities loader api queries
    Fix CSV uploads aren't possible when native query editing is disabled
    bad gateway 502 for API via reverse proxy (POST request ignores 'location' v0.47.2)
    Provide a heads up when Metabase is upgraded with what’s new
    Can't apply category filters when a question has grouping and aggregation
    Summarizing or sorting in query editor after Exploring results in a SQL question and creating a Custom Column breaks query editor
    Other count displays incorrect value when Language set to Arabic or Arabic (Saudi Arabia)
    Date filters - inconsistent filter values displayed when a question is opened from a filtered dashboard
    UI suggests it's possible to delete an archived collection
    CSV uploads aren't possible when native query editing is disabled
    Search bar font size is too small on Safari
    Summarizing by custom date column does not allow date grouping
    Custom ranges in conditional formatting don't work
    After hiding column in table settings on question based on another question, all joined columns unchecked in notebook editor when still selected
    Unable to add joined columns in table settings after removing through notebook editor on nested Question
    Inputting some values into Whitelabel "Landing Page" can cause the entire frontend to break

[close]

https://www.metabase.com/

[SiLæncer]

Whats new:>>

    The new "Tooltip Indicator" feature lets you see which user interface elements provide a tooltip.
    A rarely occurring "ConcurrentModificationException" issue was corrected.

http://jailer.sourceforge.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:>>

+ Improved: Components update: SSL, SSH, MySQL, Postgres, SQLite, Interbase/Firebird

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

[SiLæncer]

Changelog

    SQL editor:

    Aut-completion for complex SQL queries was improved
    Reconnecting of open editors when switching between Simple and Advanced view was fixed
    SQL console now can be saved as script

    ER diagrams:

    Diagrams notations switcher was added
    Connections rendering was improved
    Crow’s foot notation was added

    Data editor:

    Multiple query results now can be displayed vertically
    `Go to column` (Ctrl+F) action was added
    Column search was added to Metadata panel
    Numeric formatting was fixed for floating point numbers
    Issue with empty table after opening the Calc panel was resolved
    Setting row color for the result set was fixed
    Data transfer: columns automating mapping is now configurable

    General:

    `Restore defaults` on preference pages now resets to actual default preferences
    Eclipse 2023-09 plugin API is now supported
    Reset UI settings was fixed on macOS
    App crash when running on Wayland was fixed
    java.compiler and java.scripting modules were included in bundled Java

    Databases:

    Dameng database extension was added
    Clickhouse: array map representation was fixed
    Google Spanner: table DDL generation was fixed
    DB2 LUW: trigger editor was fixed
    Exasol: customer group creation was fixed
    Fireberd: several keywords were added
    Materialized: system schemas loading was fixed

    PostgreSQL:

    Backup/restore native tools execution was fixed
    `Europe/Kyiv` timezone support was fixed

    Redshift:

    Schemas loading was fixed
    Spectrum tables loading was fixed (for custom driver configurations)

[close]

https://dbeaver.io/

[SiLæncer]

Whats new:>>

    Fix a couple of obscure UAF errors and an obscure memory leak.
    Omit the use of the sprintf() function from the standard library in the CLI, as this now generates warnings on some platforms.
    Avoid conversion of a double into unsigned long long integer, as some platforms do not do such conversions correctly.

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

[SiLæncer]

Changelog

Bug fixes

    Implement unreturnedConnectionTimeout in c3p0 in an env var ( #34377 )
    load-from-h2 fails on master with Command failed with exception: ERROR Clearing default entries created by Liquibase migrations... ( #34505 )
    DashboardTab missing from copy command ( #34411 )
    Dashboard loses effective filter values when auto-apply is turned off ( #34382 )
    We don't seem to be updating certificates when updating the connection ( #33116 )
    Hardly visible expand icon on collection hover ( #31394 )
    Postgres Custom Query Actions require explicit CAST() for date fields ( #29126 )
    Spinners change color and fonts change on signed embedding while loading ( #25638 )
    Corrupted dashboard filter makes it impossible to view the question (unless removed) ( #24500 )
    Update Apache POI ( #34539 )
    Do not lose dashboard filters state on navigating back from Question ( #34399 )

[close]

https://www.metabase.com/