Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Relational data browsing application that allows you to gain valuable insight into both the table and the interrelation of the rows.

Apache License 2.0

Whats new:>>

    Improved database metadata management.
    Increased initial responsiveness of the Data Browser.

https://sourceforge.net/projects/dbeauty/

[SiLæncer]

Changelog

    Added support for approximate ANALYZE using the PRAGMA analysis_limit command.
    Added the bytecode virtual table.
    Add the checksum VFS shim to the set of run-time loadable extensions included in the source tree.
    Added the iif() SQL function.
    INSERT and UPDATE statements now always apply column affinity before computing CHECK constraints. This bug fix could, in theory, cause problems for legacy databases with unorthodox CHECK constraints the require the input type for an INSERT is different from the declared column type. See ticket 86ba67afafded936 for more information.
    Added the sqlite3_create_filename(), sqlite3_free_filename(), and sqlite3_database_file_object() interfaces to better support of VFS shim implementations.
    Increase the default upper bound on the number of parameters from 999 to 32766.
    Added code for the UINT collating sequence as an optional loadable extension.
    The ESCAPE clause of a LIKE operator now overrides wildcard characters, so that the behavior now matches what PostgreSQL does.
    SQLITE_SOURCE_ID: 2020-05-22 17:46:16 5998789c9c744bce92e4cff7636bba800a75574243d6977e1fc8281e360f8d5a
    SHA3-256 for sqlite3.c: 33ed868b21b62ce1d0352ed88bdbd9880a42f29046497a222df6459fc32a356f

    Enhancements to the CLI:

    Add options to the .import command: --csv, --ascii, --skip
    The .dump command now accepts multiple LIKE-pattern arguments and outputs the union of all matching tables.
    Add the .oom command in debugging builds
    Add the --bom option to the .excel, .output, and .once commands.
    Enhance the .filectrl command to support the --schema option.
    The UINT collating sequence extension is automatically loaded

[close]

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

[SiLæncer]

Whats new:>>

    Fix two long-standing bugs that allow malicious SQL statements to crash the process that is running SQLite. These bugs were announced by a third-party approximately 24 hours after the 3.32.0 release but are not specific to the 3.32.0 release.
    Other minor compiler-warning fixes and whatnot.

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

    Show the startup log as well as the server log in the runtime's log viewer.
    Implement Selenium Grid to run multiple tests across different browsers, operating systems, and machines in parallel.
    Remove support for Python 2.
    Ensure that maintenance job should be worked properly for indexes under a materialized view.
    Ensure that file browse "home" button should point to $HOME rather than /.
    Fixed data truncation issue when updating the data of type character with length
    Fixed generated SQL issue for auto vacuum options.
    Fixed internal server error when clicking on Triggers -> 'Enable All' for partitions
    Fixed the SQL help issue for EDB Postgres Advanced Server.
    Fixed an issue where if LDAP_SEARCH_BASE_DN is not set then, the value for LDAP_BASE_DN will be considered.
    Improve code coverage and API test cases for Indexes, Rules, Triggers and Compound Triggers.

[close]

https://www.pgadmin.org/

[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

    Custom column concat function errors on Amazon Redshift when using 3 or more parameters (#12544)
    Fingerprinting breaks on infinities (#12511)
    Custom columns failing when joined data has over about 30 columns (#12481)
    Fixed an issue where the Metabase logo was displaying too small (#12441)
    Adding custom field result in not being able to find columns from table (#12397)
    Create Slack Bot button has gone missing (#12382)
    Cannot view/edit table-level permissions for databases that are not schema-based (#12372)
    "Error reducing result rows" exception when downloading full results (#12339)
    Unable to create new personalized questions (#12323)
    Custom Column "ERROR: missing FROM-clause entry for table" Postgres (#12304)
    Upgrade to 0.35.0 release fails (#12223)
    Object Details (single record view) places the results outside of view (#11887)
    Zero-dates cause Pulses to fail (#11665)
    Cannot save question when results are empty (#11256)
    Line/area/bar charts are hiding x-axis labels too aggressively when scale is set to Timeseries (#11158)
    java.lang.NullPointerException when use TIMEDIFF (#10983)
    Not possible to restore visibility after setting "Do Not Include" in Data Model (#10297)
    Cannot read property 'lat' of null - Allow filter empty/not empty (like for dates) (#7361)
    Auto-refresh doesn't work for dashboards if redirected after login (#7244)
    Clicking link to unsaved question when logged out takes you to 404 page after login (#6317)
    Raw queries with "ON" date filter are broken for Druid [Regression] (#6290)

[close]

https://www.metabase.com/

[SiLæncer]

Changelog

    Database navigator:

    Statistics view (table sizes) was added
    Connection coloring was redesigned
    Connection host name tip was added

    Data viewer:

    Ref cursor panel viewer was added
    Columns sort settings save/load was added
    Data export in HTML format was fixed (styles)

    SQL editor:

    Function call formatting was improved
    Table alias generation was fixed (for unicode/numeric table names)

    PostgreSQL:

    Ref cursors refresh support was added
    Table and schema statistics was added
    Table comment and rules were added to DDL

    Oracle:

    Metadata search was fixed
    Java source read was fixed
    ODBC driver download was fixed
    Exasol: metadata edit dialogs were redesigned
    Clickhouse: table statistics was added
    Firebird: view editor was fixed
    Plain HTTP driver repositories (Maven or direct links) were replaced or removed
    Big number of minor UI and database-specific bugs were fixed

[close]

https://dbeaver.io/

[SiLæncer]

Changelog

    JSON Notes:

    The rapidjson library included with MySQL has been upgraded to the GitHub snapshot of 16 January 2020. A fix for a compiler error encountered when building from the snapshot on Mac OS X has been added. (Bug #30898701)

    Packaging Notes:

    Binary packages that include curl rather than linking to the system curl library have been upgraded to use curl 7.69.0. (Bug #30866333)
    The bundled libedit library was upgraded to version 3.1.

    Bugs Fixed:

    InnoDB: The row_upd_clust_rec_by_insert function, which marks a clustered index record as deleted and inserts an updated version of the record into the clustered index, passed an incorrect n_ext value (the total number of external fields) to lower level functions, causing an assertion failure. (Bug #30437378)
    InnoDB: An operation performed with the innodb_buffer_pool_evict debug variable set to uncompressed caused an assertion failure. (Bug #30405531)
    InnoDB: An add column operation caused an assertion failure. The failure was due to a dangling pointer. (Bug #29866408)
    References: This issue is a regression of: Bug #28491099.
    InnoDB: Updating certain InnoDB system variables that take string values raised invalid read errors during Valgrind testing. (Bug #29717909, Bug #95215)
    InnoDB: An insert statement on a table with a spatial index raised a record type mismatch assertion due to a tuple corruption. (Bug #29465567)
    InnoDB: A function that calculates undo log record size could calculate an incorrect length value in the case of a corrupted undo log record, resulting in a malloc failure. Assertion code was added to detect incorrect calculations. (Bug #29448406, Bug #82734)
    Replication: While an SQL statement was in the process of being rewritten for the binary log so that sensitive information did not appear in plain text, if a SHOW PROCESSLIST statement was used to inspect the query, the query could become corrupted when it was written to the binary log, causing replication to stop. The process of rewriting the query is now kept private, and the query thread is updated only when rewriting is complete. (Bug #30569003, Bug #97531, Bug #30654405)
    Replication: When a GRANT or REVOKE statement is only partially executed, an incident event is logged in the binary log, which makes the replication slave's applier thread stop so that the slave can be reconciled manually with the master. Previously, if a failed GRANT or REVOKE statement was the first statement executed in the session, no GTID was applied to the incident event (because the cache manager did not yet exist for the session), causing an error on the replication slave. Also, no incident event was logged in the situation where a GRANT statement created a user but then failed because the privileges had been specified incorrectly, again causing an error on the replication slave. Both these issues have now been fixed. (Bug #30566518, Bug #30324661)
    Replication: When a replication slave has a generated column that the master does not have in that table, with a secondary index on the generated column, the generated expression should be evaluated and the value stored by the storage engine in the secondary index. When row-based binary logging is in use, the replication slave assigns default values to any fields that are not in the master's definition of the table. In the case of a generated column, which does not have a default value, the slave was previously assigning a null or a zero value to the column. This value was then stored by the storage engine in the secondary index, causing both the table and the index to become corrupted. To fix this issue, generated columns in a table on a replication slave are now re-evaluated before the values are sent to the storage engine. (Bug #30034874)
    Replication: In the event of an unplanned disconnection of a replication slave from the master, the reference to the master's dump thread might not be removed from the list of registered slaves, in which case statements that accessed the list of slaves would fail. The issue has now been fixed. (Bug #29915479)
    Replication: With the settings binlog_format=MIXED, tx_isolation=READ-COMMITTED, and binlog_row_image=FULL, an INSERT ... SELECT query involving a transactional storage engine omitted any columns with a null value from the row image written to the binary log. This happened because when processing INSERT ... SELECT statements, the columns were marked for inserts before the binary logging format was selected. The issue has now been fixed. (Bug #29110804, Bug #93423)
    The -libs-compat RPM package is now built with system zlib to avoid problems with unrestricted export of symbols in libmysqlclient.so.18. (Bug #30722389, Bug #98130)
    The Event Scheduler had a memory leak. (Bug #30628268)
    Under certain circumstances, a memcached command could result in reading an uninitialized memory buffer, causing a failure. (Bug #30592346)
    Using ALTER USER to reset an account MAX_USER_CONNECTIONS value did not take effect until all current account connections terminated, if there were any. (Bug #30578217, Bug #97735)
    A materialized subquery including a condition in which a column value was used as input to a nondeterministic function produced incorrect results. (Bug #30368937)
    CONCAT() and CONCAT_WS() could produce incorrect results in rare cases due to incorrect substring handling. (Bug #30350206, Bug #96950)
    Scheduling of events could be disturbed by removing events. (Bug #30301356, Bug #96849)
    Client programs could load authentication plugins from outside the plugin library. (Bug #30191834, Bug #30644258)
    The server did not handle correctly a UNION in which one of the queries A query with a WHERE clause whose predicate contained a numeric value in scientific notation was not handled correctly.
    In addition, attempting to insert a particular integer specified as a string caused a server exit when the string-to-integer conversion was not successful. (Bug #29723340, Bug #30441969)
    Previously, mysqlpump read the [mysql_dump] and [client] groups from option files. mysqlpump now additionally reads the [mysqlpump] group. The [mysql_dump] group is still accepted but is deprecated. (Bug #24733245, Bug #83144)
    A multi-table UPDATE statement which updated a table joined to a derived table that joined two other tables was not optimized properly as it had been in MySQL 5.6, instead being treated as if STRAIGHT_JOIN had been used with the subquery creating the derived table. (Bug #97418, Bug #30488700)

[close]

https://www.mysql.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

Whats new:>>

    Improved database metadata management.
    Increased initial responsiveness of the Data Browser.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

    Improved database metadata management.
    Increased initial responsiveness of the Data Browser.

https://sourceforge.net/projects/dbeauty/

[SiLæncer]

Whats new:>>

Fix a long-standing bug in the byte-code engine that can cause a COMMIT command report as success when in fact it failed to commit.

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

-Main Program Update ( Main ):
   Add: (VistaDB) Support Memory databases (7463)
   Add: Support PostgreSQL 13 latest database system (7463)
   Upd: Update Database .NET Additional Files ( 32bit / 64bit ) (2020/05/22) (7463)
      Support the latest version of PostgreSQL 13.0 database backup and restore
   Add: (MySQL 8.0.16+) Support CHECK Constraints object enable and disable settings (7463)
   Upd: Compatible with Microsoft Windows 10 (2004) (7463) Upd: Others include cumulative minor updates, corrections and optimizations (7463)-Bookmark Manager ( Bookmark Manager ): Add: support browsing of selected data types (7463) Add: support Search results show (7463) -Object Explorer ( Object Explorer ): Add: (SQLite/VistaDB) to quickly switch to another database : support memory database (Memory databases) switch (7463) -SQL Editor ( SQL Editor ): Upd: Improve the speed of SQL statements parsing and processing (7463)-Timer function ( Timer for Automatic Execution ): Upd: Avoid the problem of repositioning the control focus when redrawing (7463) -Generate scripts ( Generating Scripts ): Upd:

(PostgreSQL 9.1+) Support UNLOGGED TABLE table attribute generation (7463)-Connection Process Manager
( Connection Process Manager ):

   Fix: Fix the update problem when Filter Expression switches to other editing tabs (7463)

- Data Editor :

   Upd: Automatically restore after [Cancel] wrong filter expression (7463)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

Fixed issue "Error when running sql script"

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

Fixed issue "Error when running sql script"

https://sourceforge.net/projects/dbeauty/

[SiLæncer]

Whats new:>>

Added support for the Novation Launchkey [MK3] series
Added support for Presonus ATOM SQ control surface

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

[SiLæncer]

Changelog

    Database navigator:

    Connection type highlighting was redesigned
    Simple view support was improved
    "Force object refresh on editor open" action was fixed
    Main toolbar UIX was improved (no disabled selectors)
    Database tools context menu was fixed

    Table statistics:

    Rendering problems (redraw on scrolling) were fixed
    Performance problems were fixed
    SQL Server support was added

    Data viewer:

    Wrong value extraction was fixed for expression aliases which conflict with table column names
    Dictionary values separator configuration was added
    Row coloring: support of gradient coloring for read-only columns was added

    Data formatter:

    Action "reset to default" was fixed in preferences
    Preference changes are immediately applied to open data editors

    SQL editor:

    Results tab rename was fixed (now we save tab title between results refresh)
    Parser of multiple SQL queries on a single line was fixed
    Execution plan explain operation cancel was implemented
    Coloring of numbers in scientific notation was fixed
    Paste from source code: n and r characters handle was fixed (now we use proper line feeds)
    Stored procedures call generation was fixed
    Object editor: "reject changes" and command undo/redo command were fixed
    Data import: open target table on finish
    Data migration: DDL generation was improved (apply the same column data type when source and target databases use the same driver)
    Database tasks: PostgreSQL, MySQL and Oracle tools now can be saved as tasks
    SSH configurator: UI controls layout was fixed
    Database driver edit dialog was fixed (legacy driver option is disabled by default)

    MySQL:

    User permission management was fixed (FLUSH PRIVILEGES is not needed for newer server versions)
    Unsigned INT and BIGINT data types support was added

    Oracle:

    Numeric data type modifiers (scale/precision) rendering was fixed
    Materialized views read/create and delete was fixed (mviews were removed from table list)

    PostgreSQL:

    Vacuum tool was improved (run in auto-commit mode)
    List of reserved keywords was updated
    Redshift: View with no schema binding support was added
    SQL Server: timestamp columns were marked as auto-generated
    Big number of minor UI and database-specific bugs were fixed

[close]

https://dbeaver.io/