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

Changelog

    Main program update ( Main ):

    Fix: Fix (7814) the problem that the judgment of ignoring case difference is not working (affects multiple functions) (7818)
    Add: (SQLite) Additional Commands ( Additional Commands ): Support loading application expansion module SELECT LOAD_EXTENSION(' filename ')(7814)
    Add: (SQLite) Database tools support loading application extension modules (Mainmenu -> Database Tools -> Extensions )(7814)
    Add: Support the latest PostgreSQL 14.0 beta1 database system (2021/05/20)(7814)
    update includes: (64bit) database backup/restore/object authorization management ( Grant Manager )... and other functions( 7814)
    Upd: Update Database .NET Additional Files 64bit (2021/05/20)(7814)
    Update PostgreSQL 14.0 related components
    Add: (PostgreSQL) Add support for hstore, ghstore extended data types (7814)
    Upd: (PostgreSQL) Fixed structure Description PUBLIC is the default search path (search_path) (7814)
    Upd: (Firebird) Reserved Words (ReservedWords) are loaded according to different database versions (7814)
    Fix: Improve loading when the last selected (database or structure description) has been loaded Related processing when it does not exist (7814)
    Upd:Other minor updates include the cumulative correction and optimization (7818)

    Connection settings ( Connection Profile ):

    the Add: (SQL Server / SQL Azure) support for the latest Azure Active Directory Authentication Login Methods (7814)
    new Directory contains the Active Interactive / Service Authentication methods such as Principal/Device Code Flow/Managed Identity
    Add: (SQL Server/SQL Azure) Add Active Directory Authentication drop-down option in the main interface (7814)-SQL

    Editor ( SQL Editor ):

    Add: Code Folding: SELECT ... FROM increase processing (7814)
    the Add: automatically aggregated INSERT INTO table records the same process, to reduce (7814) the display of unnecessary records

    The instruction code generator ( Script generator):

    Fix: generation (SQL INSERTs) multiple choice items into a single file related bug fixes (7814)
    Upd: optimized instruction code generation processing speed and reduce the memory footprint (7814)

    Database Migration ( Database Migration ) (Pro):

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

[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

    Enhancements:

    LDAP settings form hitting wrong API endpoint on save (#16173)
    Fix Serialization P1s (#15756)
    Test LDAP settings before saving (#11446)

    Bug fixes:

    Feature flag causes problems with Number filters in Native query (#16218)
    Revoking access to users in multiple groups does not correctly cleanup GTAP (#16190)
    ExpressionEditor loses value when user resizes browser window (#16127)
    ExpressionEditor loses value when user clicks away from associated name input (#16126)
    Filter dropdown not working for non-data users, when field has 300+ distinct values. (#16112)
    Tooltip only shows first Y-axis value when X-axis is numeric and style is Ordinal/Histogram (#15998)
    Gauge visualization on small screens can cause frontend refresh on hover (#15980)
    Serialization: field-literal converted to field since 1.39.0 (#15971)
    Serialization dumps with static references instead of paths in 1.39.0 (#15812)
    Incorrect result + loss of user input when summarizing with Saved Question (#15725)
    Some places shows {0} placeholder instead of expected value (#15694)
    Serialization load-process does not update source-table in joins, leading to broken questions (#15283)
    Unchecking "Remember me" box has no effect -- close the browser and reopen, then go back to your MB instance and you're still logged in (#15223)
    Serialization dump includes Personal Collections (#15120)
    Serialization: Nested question references questions in other collection are moved and becomes corrupted (#14914)
    Serialization: Snippet folders and Collections collide on dump because of missing namespace separation (#14910)
    Serialization: Snippets are not transferred correctly, leading to incorrect references and broken queries (#14909)
    Serialization: Click Behavior not translating entitiy ID on dump, potentially referencing wrong entities on load (#14566)
    Wrong LDAP port input (non-numeric) can cause complete lockout (#13313)
    Nested queries using metric got wrong SQL (#12507)
    Cannot aggregate question with unix timestamp column that is converted/cast in Metabase (#12430)
    Nested queries using metrics need to include all columns used in metric filters (#8856)

[close]

https://www.metabase.com/

[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

Changelog

Fix for bug "Exported enum names are truncated in lookup table definitions".

[close]

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

Still need 32bit support?

    I am planning to drop the 32bit releases in a future release, for keeping the installer package small, and to decrease deployment efforts. Tell me what you think about it.

3rd party updates:

    Update SynEdit component code
    Update VirtualTrees component code
    Include Microsoft Visual C++ 2015-2019 Redistributable in installer, required for some 3rd party libraries (issue #1296)
    Update plink.exe to v0.75

New stuff:

    Log DDL and/or DML queries per session to custom file path (issue #397)
    Grid text editor:
        syntax highlighting for 64 code languages, including JSON and XML (issue #136)
        gutter with line numbers and marks for edited lines
        now using search/replace dialog with regular expression support
    Enable query timeout setting for MySQL and MariaDB (issue #1306)
    Show check constraints on MySQL, MSSQL and PostgreSQL (issue #1298)
    New menu Query > "Editor commands", revealing available quick actions for SQL editors
    Create "Editor commands" menu in "Query" main menu, and populate it with all available editor commands
    Add new preference option for displaying hexadecimal content in lowercase

Bugfixes and enhancements:

    Query tab resizes after minimize (issue #1113)
    Foreign key add issue (issue #1320)
    Cannot update/insert postgres jsonb column from data editor (issue #1321)
    MariaDB 10.5: REPLICATION CLIENT privilege was renamed to BINLOG MONITOR (issue #1302)
    Quoted column default value expression on Percona (issue #1282)
    Cannot delete row in MSSQL (issue #1294)
    Always read portable settings file and imported settings file in UTF8 mode, instead of auto-detecting a potentially wrong encoding. Fixes broken characters loaded from a portable file larger than the examined 16 (?) KB
    Database search feature: prefer a normal log line for tables with no matching data type, so the "Found rows" column has a number, to fix wrong sorting
    function COALESCE is identified as plain text, not function (issue #1342)
    Non-synchronized checkbox state on privileges in user manager tree (issue #1352)
    Auto-scroll grid when tabbing through cells
    Run SQL button disabled after reconnect (issue #1319)
    Don't repeat running prompt to reload a file after multiple external changes (issue #821)
    Fix identifier quoting when creating a foreign key in a database with dots in its name (issue #1364)
    Increase maximum pixel width of status bar panels slightly, so these better fit with a larger font size. (issue #1356)
    Get rid of quotes around hex values and integers in quick filters
    Fix crash happening when using un/comment action. (issue #1359)
    include column names in "copy as" submenu export actions by default (issue #1357)
    Restore/keep cursor position in filter editor after refresh
    Detect pressed shift key before prompting for filter value. (issue #588)
    Fix wrong query duration in log panel after multiple queries in "one-go" mode
    Unhide public schema on Redshift
    Table tools: auto-fit column widths with each result grid update, and show execution time in main status bar
    Enable menu items for EXPLAIN <query> on PostgreSQL and SQLite

[close]

http://www.heidisql.com/

[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

Changelog

    Add histogram and areas to charts
    Improve history/saved queries lists (issue #44)
    Fix issues: #37, #38, #41, #42, #43, #45

[close]

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

[SiLæncer]

Changelog

    Connection recovery was improved. SSH tunnel infinite reopening cycle was fixed
    Project settings: corrupted folders configuration fix was added
    Legacy status icons were updated
    Application launch time was reduced
    Data editor: LOB viewer shows error dialog on data load errors now
    CLI: reuseWorkspace parameter handler was fixed
    Oracle: synonyms search is now configurable
    MySQL: user rename feature was added
    Exasol: schema refresh was fixed
    Snowflake: metadata read was fixed for case-sensitive schema names
    BigQuery: driver version was upgraded
    Bundled Java updated to version 11.0.11
    Many minor UI bugs were fixed

    Data transfer:

    Insert/replace method configuration was fixed
    Cross-database column data type mapping was improved

    SQL Editor:

    Problem with results tab collapse was fixed
    Dummy NullPointerException and StackOverflowError errors were fixed

    SQL Server:

    Extended properties editor was added
    New row insert for tables with calculated columns was fixed

    PostgreSQL:

    User password change feature was added
    Domain arrays support was fixed
    Role DDL now contains permissions information
    Sequences DDL was fixed
    VARBIT data type support was fixed
    Default database switch was fixed

    Informix:

    Table statistics feature was added
    Function parameters read was fixed

[close]

https://dbeaver.io/

[SiLæncer]

Changelog

    Main program update ( Main ):

    Add: Support the latest Firebird 4.0 RTM database system (2021/06/01) (7825)
    Add: (Firebird 4) Support int128, decfloat, timetz, timestamptz and other data types related function processing (7825)
    Upd: (Firebird) Update time time data type microsecond length display and output problem (7825)
    Add:(Firebird) Rewrite database backup and restore, and support remote (Remote) and local (Local) processing (7825)
    Add: (All) Support BigInteger data type related processing (7825)
    Add: (Oracle) Support BFILE, XMLTYPE and other data type related function processing (7825)
    Upd: (Oracle) Support and correction of INTERVAL DAY TO SECOND, INTERVAL YEAR TO MONTH and other data type related function processing (7825)
    Add: (SybaseASE) Add date, time, bigdatetime, bigtime Waiting for the data type (7825)
    Upd: (SQLite/SybaseASE/HP Vertica) Update time The time data type only displays the part of the output time (7825)
    Fix: (NuoDB) Fix the problem that the time data type cannot be processed (7825)
    Upd: Initial Check the existence of the selected (database or structure description) (7825)
    Upd: Improve and modify the data [Edit and Import] field type (including length) recognition processing (7825)
    Upd: Others include cumulative minor updates, corrections and Optimization processing (7825)
    rows browsing and editing (the Data Browser and Editor ):
    Upd: to enhance the ability to obtain information on the type of display (7825)
    Upd: field background color recognition AllowDBNull Browse mode or not (7825)

    Data Grid Editor ( the Cell Editor )/ Cell Viewer :

    Add: Support code editor (Code Editor) and text editor (Text Editor) to switch display (7825) -SQL Editor

    ( SQL Editor ):

    Upd: (IBM DB2/ Oracle) after the completion of the implementation of the SQL DBMS_OUTPUT close processing (7825)

    database migration ( database migration ) (Pro):

    Upd: all updates with dbMigration .NETSoftware (7825)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

    Drag-n-drop tree items to an editor (with Ctrl to generate statement)
    Static colors for columns in Chart
    Fix issues: #47, #48
    Minor changes
    Fix minor bugs

[close]

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

[SiLæncer]

Whats new:>>

    Main program update ( Main ):

    Fix: (SQL Azure) Fix (7825) the problem that causes the object not to be loaded normally (7837)
    Add: When the tree node display item exceeds the boundary, it will be displayed in full with a tooltip (7837)
    Upd: Others include cumulative minor updates, corrections and optimizations (7837)

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Enhancements

    Switch to column settings when sidebar is already open (#16368)
    Missing tooltip for sharing individual question (#16108)
    Don't show Custom Expression helper, when input is not in focus (#15891)

Bug fixes

    Javascript error when enabling JWT authentication (#16378)
    Questions on MongoDB return 'No results!' after upgrade from 0.38.5 to 0.39.0 when filtering against array (#16299)
    Login blocked till timeout if Metabase can't reach GeoJS API (#16169)
    Histograms should filter out null x values (#16049)
    Shifted chart values on line with ordinal x axis (#16002)
    Dashboard filters dropdown only list the first 100 values (#15695)
    Cannot use arithmetic between two case() function in Custom Expression (#15107)
    LDAP login fails with Group Sync when user is assigned to 1 group (#15073)
    LDAP auth errors with "did not match stored password" if givenName or sn is missing (#14767)
    Cannot join Saved Questions that themselves contains joins (#12928)
    Human-reable numering not working properly (#12629)
    Time series filter and granularity widgets at bottom of screen are missing (#11183)
    LDAP group sync - LDAPException after removing user from a mapped group (#11172)
    Dashboard text cards aren't scrolling (#8333)

[close]

https://www.metabase.com/

[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 #1561 - Added browse button to select the binary path in the Preferences.
    Issue #1591 - Added Grant Wizard option under Package node.
    Issue #2341 - Added support to launch PSQL for the connected database server.
    Issue #4064 - Added window maximize/restore functionality for properties dialog.
    Issue #5370 - Added support to set the binary path for the different database server versions.
    Issue #6231 - Added OS, Browser, Configuration details in the About dialog.
    Issue #6395 - Added support for rotating the pgAdmin log file on the basis of size and age.
    Issue #6524 - Support non-admin installation on Windows.

    Housekeeping:

    Issue #4622 - Added RESQL/MSQL test cases for Table and its child nodes.
    Issue #6225 - Updated Flask-Security-Too to the latest v4.
    Issue #6460 - Added a mechanism to detect a corrupt/broken config database file.

    Bug fixes:

    Issue #4203 - Fixed the issue of renaming the database by another user.
    Issue #6404 - Ensure that the Query Tool connection string should not be changed as per the ‘Query Tool tab title’.
    Issue #6466 - Ensure that the user should be able to add members in Login/Role group while creating it.
    Issue #6469 - Ensure that the calendar control should be disabled in the properties panel for Role.
    Issue #6473 - Disable browser password saving in the runtime.
    Issue #6478 - Fixed duplicate SQL issue for tables with more than one partition.
    Issue #6482 - Fixed an issue where the Foreground Color property of server dialog does not work.
    Issue #6513 - Fixed an issue where pgAdmin does not open after password reset in server mode.
    Issue #6520 - Fixed an issue where a decimal number is appended for character varying fields while downloading the data in CSV format.

[close]

https://www.pgadmin.org/

[SiLæncer]

Changelog

    Improvement to the EXPLAIN QUERY PLAN output to make it easier to understand.
    Byte-order marks at the start of a token are skipped as if they were whitespace.
    An error is raised on any attempt to access the rowid of a VIEW or subquery. Formerly, the rowid of a VIEW would be indeterminate and often would be NULL. The -DSQLITE_ALLOW_ROWID_IN_VIEW compile-time option is available to restore the legacy behavior for applications that need it.
    The sqlite3_deserialize() and sqlite3_serialize() interfaces are now enabled by default. The -DSQLITE_ENABLE_DESERIALIZE compile-time option is no longer required. Instead, there is is a new -DSQLITE_OMIT_DESERIALIZE compile-time option to omit those interfaces.
    The "memdb" VFS now allows the same in-memory database to be shared among multiple database connections in the same process as long as the database name begins with "/".
    Back out the EXISTS-to-IN optimization (item 8b in the SQLite 3.35.0 change log) as it was found to slow down queries more often than speed them up.
    Improve the constant-propagation optimization so that it works on non-join queries.
    The REGEXP extension is now included in CLI builds.

[close]

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

[SiLæncer]

Changelog

    Automatic check for updates
    Autocomplete column names (issue #52)
    Copy an query result as csv with header (issue #53)
    Up SQLite to 3.36.0
    Fix minor bugs (issues #50, #51)

[close]

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

[SiLæncer]

Changelog

Navigator:

    Quick search now supports multiple object names
    Entity editor preferences for active tab configuration were improved
    Object rename dialog was fixed
    Metadata refresh UI was fixed

Data editor:

    Row coloring now supports LIKE and other operators
    Read-only columns mark was redesigned
    Confirmation dialog was added for column filters
    References panel UI was fixed (rows highlighting)
    Spatial data viewer now remembers selected SRID for particular columns

Data export: special characters escape was fixed in HTML and JSON formats

SQL editor:

    Problem with active schema reset after connection invalidate was fixed
    Problem with focus lost on query execution was fixed
    Auto-completion for quoted identifiers was fixed
    Embedded SQL editors performance was greatly improved
    Problem with @set command was fixed
    Problem with Find/Replace window and NullPointerException was fixed
    Several problems with hanging UI after complicated SQL execute were fixed

Greenplum: materialized views DDL was fixed
MySQL: foreign key edit support was added

Oracle:

    Table DDL was fixed (missing semicolons)
    Timestamp columns editor was fixed
    Function-based indexes column read was fixed (duplicated rows removed)
    Package loading performance was greatly improved

PostgreSQL:

    Column data type editor was redesigned
    Infinity timestamps handler was fixed
    Array and interval data types editor was fixed
    Foreign tables DDL was fixed (missing OPTIONS)
    Cross-schema references rendering was fixed

Redshift:

    Permission editor was added
    Problem with case-sensitive object names was fixed

SQL Server:

    Cross-schema foreign keys support was fixed
    Detailed triggers metadata read was added

Teradata: triggers and procedures DDL was fixed (extra linefeeds were removed)
Taiwan localization was added (thanks to @ralic)
Test connection dialog now shows connection detailed information
Last workspace location is now restored after DBeaver version upgrade
Redundant P2 plugins were removed from the standalone version
TLS 1.0 and TLS 1.1 support configuration was fixed

[close]

https://dbeaver.io/

[SiLæncer]

Changelog

-Code Management ( Code Manager ):
    Add: Support separate processing of re-flashing the main directory, when the designated main directory contains sub-directories [Re-flash the main directory], specify the root directory [Re-flash all directories] (7848)
    Add: Support automatic sorting processing after adding files or directories (7848)
    Fix: Fix the problem of handling new blank documents through the right-click menu (7848)
    Fix: Fix and improve many problems such as New, Open and Save (7848)-Main
program update ( Main ) :
    Upd: (Sybase ASE/MySQL) Improve the speed of obtaining DEFAULT VALUES (impacts include multiple impacts) (7848)
    Add: (OData) Support collection data type and content display (7848)
    Fix: (SQL Azure) Fix (7825) causing abnormal The problem of loading objects (7837)
    Fix: (SQL Server/SQL Azure/Sybase ASE) Fix the problem that a small part of EXEC/SELECT input parameters does not contain the N'' identification code (7848)
    Add: The tree node display item exceeds When bordering, it will be displayed in full with a tooltip (7837)
    Upd: IBM DB2/Informix component version updated to IBM.Data.DB2.dll 9.7.4.4 (11.5.6000.4) (2021/06/21) (7848)
       Misc: (IBM DB2/Informix) IBM Data Server Client Packages Version 11.5.6 FP0 (2021/06/21)
    Upd: Others include cumulative minor updates, corrections and optimization processing (7848) -Script
generator ( Script Generator ):
    Fix: Fix (7788) the problem of ALTER script generation error (7848)
    Upd: More optimization of script generation speed and reduction of memory usage processing (7848)
-Query Tabs:
    Fix: When the tag name contains parentheses, related issues are improved and corrected (7848)-Connection
Explorer ( Connection Explorer ):
    Add: Right-click the menu to add the comment option (7848)

[close]

http://fishcodelib.com/Database.htm