Thema: Datenbanksoftware und Tools diverses ...

[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

Whats new:>>

Fix: influence correction (7989) of changes to the SQL Server / SQL Azure processing (7990)

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

Fixed "Invisible combo box items." JFormDesigner/FlatLaf#426

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:

Added support of Aggregate and Operator node in view-only mode.
Ensure that users should be able to modify the REMOTE_USER environment variable as per their environment by introducing the new config parameter WEBSERVER_REMOTE_USER.

Housekeeping:

Bug fixes:

Fixed pgAdmin freezing issue by providing the error message for the operation that can’t perform due to lock on the particular table.
Ensure that columns should be merged if the newly added column is present in the parent table.
Fixed an issue where pgAdmin is not opening properly.
Ensure that internal authentication when combined with other authentication providers, the order of internal source should not matter while picking up the provider.
Ensure that inherit table icon should be visible properly in the tree view.
Fixed an issue where properties panel is not updated when any object is added from the browser tree.
Ensure that the user should be able to navigate browser tree objects using arrow keys from keyboard.
Fixed an issue where database nodes are not getting loaded behind a reverse proxy with SSL.
Fixed SQL syntax error if select “Custom auto-vacuum” option and not set Autovacuum option to Yes or No.
Fixed an issue where older server group name displayed in the confirmation pop-up when the user removes server group.
Fixed an issue where JSON editor preview colours have inappropriate contrast in dark mode.
Fixed JSON Editor scrolling issue in code mode.
Fixed an issue where user details are not shown when the non-admin user tries to connect to the shared server.
Ensure that dialog should be opened when clicking on Reassign/Drop owned menu.
Ensure that changing themes should work on Windows when system high contrast mode is enabled.
Ensure that the Binary path for PG14 should be visible in the preferences.
Added operators and aggregates in search objects.
Fixed an issue where textarea should be allowed to resize and have more than 255 chars.
Fixed an issue where SQL for index shows the same column multiple times.
Reset the layout if pgAdmin4 detects the layout is in an inconsistent state.

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

* Value preview (image, text or hex) of an query result
* Recompile sqlite3 with math functions (issue #81)
* Improve auto-detection for pasted text (issue #79)
* Fix minor bugs

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

[SiLæncer]

Changelog

   

    Main program update:

    Fix: (SQL Server/SQL Azure) Fix (7989) the problem that the DOMAIN object is not displayed.
    Fix: (SQL Server/SQL Azure) Fix (7989) Rewrite the impact of GetSchemaTable processing.
    Upd: SQL Server/SQL Azure component version updated to Microsoft.Data.SqlClient 4.0.0.
    Upd: Others include cumulative minor updates, corrections and optimization processing.

    SQL Editor:

    Upd: Update the default display size and font Cascadia Mono (when the system is installed).

    Generating Scripts:

    Upd: (SQL Server/PostgreSQL) Improve VIEW object generation script processing speed.

    Displaying Data Types on the column header:

    Upd: Improve ODBC/OleDB data type display

    Database Migration:

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

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

    Button to toggle Link on Hover/Link on Select for Details Panel. #66
    The SQL filter editor of the data browser had problems with complex RHS expressions. This has been corrected.
    Minor cosmetics to the UI.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

    STRICT tables provide a prescriptive style of data type management, for developers who prefer that kind of thing.
    When adding columns that contain a CHECK constraint or a generated column containing a NOT NULL constraint, the ALTER TABLE ADD COLUMN now checks new constraints against preexisting rows in the database and will only proceed if no constraints are violated.
    Added the PRAGMA table_list statement.

    CLI enhancements:

    Add the .connection command, allowing the CLI to keep multiple database connections open at the same time.
    Add the --safe command-line option that disables dot-commands and SQL statements that might cause side-effects that extend beyond the single database file named on the command-line.
    Performance improvements when reading SQL statements that span many lines.
    Added the sqlite3_autovacuum_pages() interface.
    The sqlite3_deserialize() does not and has never worked for the TEMP database. That limitation is now noted in the documentation.
    The query planner now omits ORDER BY clauses on subqueries and views if removing those clauses does not change the semantics of the query.
    The generate_series table-valued function extension is modified so that the first parameter ("START") is now required. This is done as a way to demonstrate how to write table-valued functions with required parameters. The legacy behavior is available using the -DZERO_ARGUMENT_GENERATE_SERIES compile-time option.
    Added new sqlite3_changes64() and sqlite3_total_changes64() interfaces.
    Added the SQLITE_OPEN_EXRESCODE flag option to sqlite3_open_v2().
    Use less memory to hold the database schema.

[close]

https://www.sqlite.org/

[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

    Data viewer:

    Filters configuration dialog UI was fixed (MacOS)
    Found occurrences highlighting was fixed (find/replace)
    Problem with long columns resize was fixed
    Problem with overlapping column icons was fixed
    Diagram viewer: connections auto-layout was fixed
    Problem with SQL script preview dialog was fixed on MacOS
    Error “PKIX path building failed” was fixed on Windows (OS certificate storage is now the default)
    Dark theme: bug with mismatching colors was fixed on MacOS
    Problem with missing file extensions was fixed (Windows)
    Metadata editor: editor flickering after mode change was fixed
    Full-text search now keeps original table filters
    Currupted projects auto-recovery feature was added
    Legacy error/warning icons were replaced with new ones

    Version auto-upgrade:

    Incorrect package type detection was fixed
    Incorrect architecture (M1/ARM/x86) detection was fixed

    Driver editor:

    URL template edit support was added for all drivers
    Maven artifacts import/edit UI was improved
    SSH tunnel test: system variables support was added

    New database drivers:

    Babelfish driver was added (thanks to @okeuday)
    OceanBase driver was added (thanks to @LuckyLeoZZ)
    Greenplum: permission editor was fixed for older GP versions
    MySQL/MariaDB/PostgreSQL: backup/restore tasks create wizard was fixed (NPE)
    ODBC: app crash on editor open was fixed

    PostgreSQL:

    Database structure was redesigned (all cluster-level entities moved to the top level)
    Multirange data types support was added
    Exclusive schema filters support was fixed
    Support of JSON columns in unique keys was added
    SQLite: table indexes create/delete support was added
    SQL Server: auto-completion and hyperlinks were fixed in stored procedures

[close]

https://dbeaver.io/

[SiLæncer]

A database management application with support for MySQL, MS SQL and PostgreSQL, with a built-in query designer and a table and SQL editor.

MIT License

Changelog

    ADDED: Open SQL script from SQL confirm
    CHANGED: Better looking statusbar
    ADDED: Create table from database popup menu
    FIXED: Some fixes for DB compare+deploy (eg. #196)
    ADDED: Archives + DB models from external directories
    ADDED: DB deploy supports preloaded data
    ADDED: Support for Command key on Mac (#199)

[close]

https://github.com/dbgate/dbgate

[SiLæncer]

Changelog

   

    AutoComplete and IntelliSense:

    Add: Add object alias (Alias) to auto-complete item (8007)
    Upd: Optimized completion mode (Completion Mode) processing method (8007)
    Upd: Optimize perception processing, when the object contains and does not contain quoted identifiers (Quoted identifiers) (8007)
    Main program update (Main):

    Upd: Support exception characters & display and related processing (including files/objects/titles... etc.)(8007)
    Fix: Solve the problem that Firebird 1.5 loses support (8007)
    Upd: (SQL Server/SQL Azure) Prevent users from not shutting down normally after executing FMTONLY/NO_BROWSETABLE, resulting in abnormal handling of subsequent programs (8007)
    Fix: (SQL Server/SQL Azure) Fix (7989) the problem that the DOMAIN object is not displayed (7996)
    Fix: (SQL Server/SQL Azure) Fix (7989) Rewrite the effect of GetSchemaTable processing (7990)
    Upd: SQL Server/SQL Azure component version updated to Microsoft.Data.SqlClient 4.0.0 (2021/11/19)()(7996)
    Upd: Others include cumulative minor updates, corrections and optimization processing (8007)

    Code Manager:

    Fix: Double-click to open the file in the [Group], fix the label name display problem (8007)

    SQL Editor:

    Upd: Update the default display size and font Cascadia Mono (when the system is installed) (7996)

    Generating Scripts:

    Upd: (SQL Server/PostgreSQL) Improve VIEW object generation script processing speed (7996)
    Displaying Data Types on the column header:
    Upd: Improve ODBC/OleDB data type display (7996)

    Database Migration (Pro):

    Upd: All updates are the same as dbMigration .NET software (8007)

[close]

http://fishcodelib.com/Database.htm

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

    Static viz creates Picaso painting, when data is unordered Timeseries (#19098)
    Harmonize Google dependency versions, which could cause conflict between GA and new BigQuery driver (#19080)
    Saving/updating questions can take a very long time (seconds or minutes) on large instances (#19053)
    Funnel chart showing retained NaN% when all rows from aggregate column are zero (#18980)
    Changing a (old) pivoted table to less than 3 columns results in blank screen (#18976)
    Exports fails, when there's invalid visualization column_settings references (#18972)
    Cannot send test emails before creating subscription, when using non-default filter values (#18669)
    Native editor autocomplete suggestions makes object lookup without limit (#16736)
    Strip whitespace from Google sign-in client IDs (#15976)
    Validate Google sign-in client IDs (#15975)
    Dashboard causes permission error, when "Click Behavior" linking to dashboard/question without access (#15368)
    Clicking on legend in native question breaks the UI (#12439)
    Trend tile on dashboard differs from tile on full screen (#10786)
    BigQuery and Google Analytics drivers broken on x.41.3 (#19173)
    BigQuery connection error on 0.41.1 (#18788)

[close]

https://www.metabase.com/

[SiLæncer]

Whats new:>>

    Automatic and transparent persistence of SQL console content.
    Obfuscation of database credentials.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

    ADDED: Connection and database colors
    ADDED: Ability to pin connection or table
    ADDED: MongoDb: create, drop collection from menu
    ADDED: Copy as MongoDB insert
    ADDED: MongoDB support for multiple statements in script (dbgate-query-splitter)
    ADDED: View JSON in tab
    ADDED: Open DB model as JSON
    ADDED: Open JSON array as data sheet
    ADDED: Open JSON from data grid
    FIXED: Mongo update command when using string IDs resembling Mongo IDs
    CHANGED: Imrpoved add JSON document, change JSON document commands
    ADDED: Possibility to add column to JSON grid view
    FIXED: Hiding columns #1
    REMOVED: Copy JSON document menu command (please use Copy advanced instead)
    CHANGED: Save widget visibility and size

[close]

https://github.com/dbgate/dbgate

[SiLæncer]

Whats new:>>

    Up SQLite to 3.37.0
    bit version
    Migrate to mingw64
    Set font size for all controls
    Fix bugs

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

[SiLæncer]

Whats new:>>

    Bug fixes:

    Addresses the CVE-2021-44228 security vulnerability by updating log4j2 to 2.15.0

https://www.metabase.com/