Thema: Datenbanksoftware und Tools diverses ...

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

    Add a new tool for check foreign key
    Add Index wizzard
    Raise CSV import wizzard if a pasted text contains CSV data
    Double-click selection: hold Ctrl to get an entire quoted text
    Fix query formatter
    Fix issues #63, #73

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

[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

-Main program update ( Main ):

    Fix: (PostgreSQL) Solve the 25P02 exception handling, and provide a more detailed error cause display (7908)

    Upd: Others include cumulative minor updates, corrections and optimization processing (7908) -SQL Editor
( SQL Editor ):

    Upd : exclusion exception when parsing a single line improvements statement notes (7908)

- row editing (the data editor ):

    Fix: corrected (7890) leads the field to take the process out of action preset value IS NULL + DEFAULT VALUE issue (7908)

- Database Migration ( Database Migration ) (Pro):

    Upd: all updates with dbMigration .NET software ( 7908)

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

    The connection dialog has been improved.
    Database-specific logos are now displayed in the connection dialog and in the status bar.
    The condition editor now also displays the number of rows that are "null" or "not null".

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

This is a hotfix release to 0.40.3 to fix a UI issue. See https://github.com/metabase/metabase/releases/tag/v0.40.3 for full release notes to this maintenance release detailing bugs fixed.

[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

    Data transfer:

    Value binding mode switcher was added (affects performance)
    Automatic columns mapping was fixed
    Import from files/relational tables into document oriented databases was fixed
    Column length detection was improved
    SSH tunnel: jump server support was added
    Tasks management view: task folders were added
    Navigator: show tables from different schemas in a single list (optional)
    Connection driver settings: problem with non-editable properties was fixed

    Data editor:

    Toolbar commands enablement handler was fixed
    Detached text/binary editor was fixed
    Row coloring: LIKE and REGEX filter value editor was fixed

    SQL editor:

    Extraction of queries from source code on paste: problem with line feeds was fixed
    Multibyte unicode numbers handler was improved (app hang fixed)
    Main windows title now shows proper information about the current editor
    Greenplum: stored procedures auto-completion and navigation was fixed

    PostgreSQL:

    Multi-column foreign keys navigation was fixed
    Auto-completion for quoted identifiers was improved
    Active schema detection was fixed
    Floating point numbers formatting was fixed

    Redshift:

    Data transfer performance was significantly increased (up to x10000)
    Tables and procedures DDL was improved (security definer was added)
    Stored procedures search and auto-completion was fixed
    Timestamp value editor was fixed (in native date formatting mode)
    Snowflake: driver configuration was fixed (JNA dependencies)
    Many minor UI and database-specific bugs were fixed

[close]

https://dbeaver.io/

[SiLæncer]

Changelog

    Browse and Edit Data Bar (Data Browser and Editor ):

    Add: Optimize the edit display, the new row contains auto-increment fields/default values/calculated data fields... and other prompt displays (7919)
    Add: Edit field prompt messages, add Field attributes/default values/calculated data fields... and other content display (7919)
    Add: Edit the background color of the field, the default value and calculated data fields are displayed in different background colors (7919)
    Add:Right-click menu save function (Save): Add sub-function to add new row ([ADD] Add a new row) (7919)
    Add: Right-click menu search function (Find): Add sub-function to move to row ([G] Go To Row) (7919)
    Add: Move to Row (Go To Row: Ctrl + G ): Added Move to Top and End shortcut keys (7919)
    Fix: Fix (7890) the field is IS NULL+DEFAULT VALUE and COMPUTED COLUMN cannot be automatically issue (7908) update

    SQL editor ( SQL editor ):

    the Add: right menu search function, increased sub-function moved to the line ([G] the To Go line) (7919)
    the Add: move line (the To Go line: Ctrl + G ): Added Move to Top and End shortcut button (7919)
    Upd: Right-click menu to reposition multiple sub-function keys (7919)
    Upd:Update the display of the input method window, the window moves with the cursor to replace the floating display (7919)
    Upd: Improve the exclusion of exceptions when parsing single-line comments in the statement (7908)
    Fix: Fix the problem that the exception message pops up after the save as file format is .htm ( 7919) -AutoComplete and IntelliSense

    ( AutoComplete and IntelliSense ):

    Upd: Improve when the input method is turned on, do not do any automatic completion and perception processing (7919) -Main

    program update ( Main ):

    Fix: (PostgreSQL) Resolve 25P02 Exception handling, and provide more detailed error reason display (7908)
    Upd: Optimized interface and HiDPI high zoom ratio display problem (7919)
    Upd: SQLite component version updated to System.Data.SQLite.DLL 1.0.115.0 (3.36.0) ( 2021/08/25) (7919)

    Upd: Others include cumulative minor updates, corrections and optimization processing (7908) -Backup
    and restore ( And Restore Backup ):

    Fix: After (SQL Server) a revised version of the update causes problems related controls can not be changed manually enter (7908)

    Database Migration ( Database Migration ) (Pro):

    Upd: all updates with dbMigration .NET software ( 7908)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

The user interface of the data browser and SQL console has been made a bit more appealing.

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 for the truncate table with restart identity.
    Make code folding case insensitive in the code mirror.
    Added database and server information on the Maintenance process watcher dialog.
    Allow the referenced table to be the same as the local table in one to many relationship for ERD Tool.
    Make closing tabs to be smarter by focusing on the appropriate tab when the user closed a tab.
    Set PSQLRC and PSQL_HISTORY env vars to apt. user storage path in the server mode.

    Housekeeping:

    Bug fixes:

    Fixed an issue where privileges were revoked using SQL query on objects like tables that do not correctly show in SQL tab.
    Fixed an issue where the user can not paste the updated table header in safari 12 and 13 browsers.
    Ensure that trigger function SQL should have ‘create or replace function’ instead of ‘create function’ only.
    Fixed blank screen issue on windows and also made changes to use NWjs manifest for remembering window size.
    Fixed the export image issue where relation lines are over the nodes.
    Fixed width limitation issue in PSQL tool window.
    Fixed an issue where columns with sequences get altered unnecessarily with a schema diff tool.
    Ensure that the lock panel should not be blocked for larger records.
    Partially fixes the data output panel display issue.
    Fixed an issue where whitespace in function bodies was not applied while generating the script using Schema Diff.
    Introduced OAUTH2_SCOPE variable for the Oauth2 scope configuration.
    Enables pgAdmin to retrieve user permissions in case of nested roles which helps to terminate the session for AWS RDS.
    Fixed no attribute ‘_asdict’ error when connecting the database server.
    Fixed errors related to HTML tags shown in the error message for JSON editor.
    Fixed UnboundLocalError where local variable ‘user_id’ referenced before assignment.
    Renamed ‘Auto rollback?’ to ‘Auto rollback on error?’.
    Fixed the JSON editor issue of hiding the first record.
    Ensure that deleting a database should not automatically connect to the next database.
    Ensure that pgAdmin should not fail at login due to a special character in the hostname.
    Fixed an issue where multiple query tool tabs getting closed for the single close event.

[close]

https://www.pgadmin.org/

[SiLæncer]

Changelog

    Bug fixes:

    Dashboard filter autocomplete not working with mixed Search/Dropdown when dropdown has a null value (#17659)
    Not possible to delete Dashboard Subscription unless dashboard is in root collection (#17658)
    Possible to not input recipient of Subscription, which will then cause blank screen (#17657)
    Valid Email settings disappear on save, but re-appear after refresh (#17615)
    Unable to click "Learn more" on custom expression (#17548)
    Editing an alert causes it to be deleted in some circumstances (#17547)
    New databases with "This is a large database ..." still uses the default sync+scan settings (#17450)
    Adding cards to dashboard via search can cause the card to show spinner until browser refresh (#15959)
    Cannot login with OpenAM SAML since 1.38.3 (#15567)
    Native question "Filter widget type"="None" hides the filter widget even after changing it to something else (#13825)

[close]

https://www.metabase.com/

[SiLæncer]

Whats new:>>

    The new "Go Back"/"Go Forward" feature allows to go back and forth to any state ever reached while navigating through the database.
    The layout auto-rearrangement can now be turned off.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

An error in creating NVARCHAR literals for MS-SQL Server was corrected.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

    SSH tunnel: jump server configurator was fixed (port number)
    Windows shortcuts (lnk) resolution was added
    ERD: columns sort support was added
    Confirmation dialog UI was redesigned
    Database session manager refresh was fixed
    DB2: columns, procedures and functions search support was added
    Firebird: calculated fields support was added
    Greenplum: table DDL was fixed (unique keys)
    H2: procedure aliases support was added
    SQL Server: cross database metadata search support was added
    Vertica: metadata search and full-text search support was added
    Linux installers (deb, rpm) were improved. App shortcut links were fixed
    Eclipse 2021-06 is new base platform
    DBeaver now requires Java 11
    MacOS X M1 installer was added (beta)

    Data viewer:

    Boolean value render configuration was redesigned
    Special format for “time/timestamp with timezone” types was added
    Advanced paste: configuration dialog was added
    Radix transformer was fixed
    Numeric transformer was added
    Geometry data type editor was fixed (Exasol, Oracle)
    Value panel now saves last used content viewer settings

    Data transfer:

    Output settings configurator was fixed
    External process execute was fixed (backslash escape)
    Import from XLSX: column mapping was fixed
    Database dump configuration page was fixed (Mysql, PostgreSQL)
    Data load performance was improved (thanks to @deepaksenthilkumar)

    Metadata search:

    Search in object comments configurator was fixed
    Search page was fixed for cross-database search PostgreSQL

    PostgreSQL:

    Composite data type support was fixed
    UDF parameters support was fixed
    Foreign table comments support was added

    Redshift:

    External table columns metadata read was fixed
    Char data type support was fixed
    Timeout error recovery was added
    Driver version was upgraded to 2.0
    Geometry data types support was improved

[close]

https://dbeaver.io/

[SiLæncer]

Whats new:>>

* Export/Import CSV via CLI/terminal
* Minor improvements
* Fix minor bugs

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

[SiLæncer]

Changelog

    Bug fixes:

    GeoJSON URL validation fix (#17991)
    Grid map causes frontend reload or blank screen, when hovering the grids if there is no metric (#17940)
    Cannot create more than 2 metrics, when UI language is Turkish - screen goes blank or displays "Something went wrong" (#16323)
    Visualizations with more than 100 series just shows a blank chart (#16000)Data point values uses formatting Style of first series on all series (#13095)
    Grid map causes frontend reload or blank screen, when hovering the grids if there is no metric (#17940)
    Cannot create more than 2 metrics, when UI language is Turkish - screen goes blank or displays "Something went wrong" (#16323)
    Visualizations with more than 100 series just shows a blank chart (#16000)
    Data point values uses formatting Style of first serie on all series (#13095)

[close]

https://www.metabase.com/

[SiLæncer]

Changelog

    Main program update (Main):

    Upd: Upgrade .NET Framework to version 4.7.2, performance and related functions are optimized and improved at the same time (7943)
    Add: Filtering Objects (Filtering Objects): Supports [all] database types, which can eliminate unnecessary object display, and improve processing speed at the same time (7943)
    Add: Multiple selections: Supports clicking Escape during processing to interrupt processing (7943)
    Add: (SQL Server/SQL Azure) Azure Active Directory authentication login method: Add Active Directory Default(7943)
    Add: (Teradata) Added support for External Browser and Transport Layer Security (TLS) authentication login methods (7943)
    Upd: Allow connection to the database type of SQL Server but the connection source is the connection setting of SQL Azure (to prevent users from selecting the wrong database type) (7943)
    Fix: Fix Parse Query processing method (7943)
    Upd: (SQLite) Improve the processing speed of opening AES256 encrypted database (7943)
    Fix: (Oracle) Remove all blank characters at the beginning and end of the SQL statement during execution to avoid errors such as (ORA-00911/ORA-00900) (7943)
    Upd: (Firebird) Update asynchronous processing and execution plan processing (7943)
    Add: Support manually click the lower right corner of the label status bar to change the database type (7943)
    Upd: Continuously optimize the interface and HiDPI high zoom ratio display problem (7943)
    Upd: SQL Server/SQL Azure component version updated to Microsoft.Data.SqlClient 3.0.1 (2021/09/24)()(7943)
    Upd: PostgreSQL component version updated to Npgsql 5.0.10 (2021/09/15)()(7943)
    Upd: Teradata component version updated to Teradata.Client.Provider.dll 17.10.2.0 (2021/05/11)()(7943)
    Upd: Firebird component version updated to FirebirdSql.Data.FirebirdClient 8.0.1.0 (2021/04/07)()(7943)
    Upd: Others include cumulative minor updates, corrections and optimization processing (7943)

    Data Export:

    Upd: Export of Single INSERTs is changed to batch processing to avoid exceptions such as the limit on the number of entries in the database and the length of the text (7943)

    Generating Scripts:

    Upd: (Oracle) Optimized using quoted identifiers for objects = False to generate processing when canceling the setting (7943)
    Fix: (SQL Server/SQL Azure) Fix the issue of Included Columns generation (7943)

    Table Designer:

    Upd: If the new field has been assigned a name, avoid clicking Escape to delete it (7943)

    Database Migration (Pro):

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

[close]

http://fishcodelib.com/Database.htm