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

    When deleting rows, an IllegalStateException sometimes occurred incorrectly.
    Improved performance of deletion script generation.
    Progress dialog for exporting is no longer modal.

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

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

    When deleting rows, an IllegalStateException sometimes occurred incorrectly.
    Improved performance of deletion script generation.
    Progress dialog for exporting is no longer modal.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

    Database backup/restore/sql tools (PostgreSQL, MySQL, Oracle) now can be saved as tasks
    Smart auto-commit mode was introduced (enable transactions vefore data modifying query execute)
    SQL editor:
        Alias generation was improved
        Output log flush eas fixed
        Default database assign (for SQL script) was fixed
    Data editor: advances paste now respects NULLs for dates and numbers
    PostgreSQL:
        $$ strings parser was fixed
        Domain type arrays support was fixed
    DB2 (iSeries, z/OS): new connection issue was fixed
    Oracle: session manager now shows servr-side execution plans (thanks to @SergDzh)
    MySQL: database backup/restore was fixed
    Firebird: unique key DDL was fixed
    Number of fixes and improvements in backup/restore tools
    Workspace switch: last chosen workspace is now saved between app restarts
    Dark theme support was improved (toolbars, dark colors customization)
    Eclipse 4.6 support was fixed
    Problem with missing toolbar buttons was fixed (Linux)
    A lot of minor bugfixes

[close]

https://dbeaver.io/

[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 command line interface

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

[SiLæncer]

Release Notes

The phpMyAdmin team announces the release of versions 4.9.4 and 5.0.1.

As a reminder, version 4.x is in the LTS phase, where only security fixes and critical bug fixes are made. Users are suggested to migrate to version 5.

These releases address two issues, a problem with two-factor authentication that was introduced with the last releases, and a fix for an SQL injection vulnerability that was reported by CSW Research Labs https://twitter.com/cswcyberworks. This vulnerability is assigned PMASA-2020-1 and requires that the attacker have logged in through a valid MySQL account.

Known issue: the reported current release version may display incorrectly on the main page (for instance, "Version information: 5.0.1, latest stable version: 4.9.4"). This is expected to be fixed in the next routine bug fix release.

Downloads are available at phpmyadmin.net.

Happy new year, the phpMyAdmin team

[close]

https://www.phpmyadmin.net/

[SiLæncer]

pgAdmin allows multi-database management through an administration interface for PostgreSQL permitting statement, procedure viewing and more.

License: Open Source

Changelog

    Notable changes in this release include:

    Allow screen-reader to read relationship attributes in nested elements.
    Ensure all binaries are securely signed and linked with the hardened runtime in the macOS bundle.
    Added support to view multilevel partitioned tables.
    Rename some internal environment variables that could conflict with Kubernetes.
    Fix an issue where operator, access method and operator class is not visible for exclusion constraints.
    Ensure that constraints, indexes, rules, triggers, and compound triggers should be created on partitions.
    Fix syntax highlighting in code mirror for backslash and escape constant.
    Ensure that the user should be able to select/modify tablespace for the partitioned table on v12 and above.
    Added support for on-demand loading of items in Select2

[close]

https://www.pgadmin.org/

[SiLæncer]

Exportizer is a free database export tool. It allows you to export data to a file, clipboard, or printer. Exportizer works via BDE or ADO. It can convert DB, DBF, text, CSV to text, CSV, XLS, RTF, XML, HTML, DBF, and INSERT statements. Many export options ensure full control over output. There is an ability to specify the source-to-target field mappings. Export operations can be performed either via the program interface or via command line with large number of parameters. You can easily generate needed command line directly from the GUI. It is possible to copy data to the clipboard or print it. There are several utility functions for data manipulating and bookmarking.

Features:

Opening tables from multi-table database files like XLS, XLSX, XLSM, XLSB, MDB, ACCDB, HTML, GDB, IB, FDB, UDL, and other multi-table databases like ODBC data sources etc.
Exporting data from all files, which are located in one folder, or all tables from a multi-table data source, at once (from interface or via command line).
Ability to specify custom increment number for Increment Field Value function.
Exporting data to Excel (XML-based) and DATABASE formats.
Using extra command line line options like /Silent, /LogFile, /CloseOnError etc.
Using extra export modes like Append and Empty+Insert.

Whats new:>>

    Faster exporting to XLS format.
    Possibility to add totals when exporting to majority of export formats.
    More correct calculating expressions.
    Minor GUI improvements.
    Fixed several GUI bugs.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

    Improved the engine providers compatibility across Firebird versions.
    Added a configuration switch to disable the "TCP Loopback Fast Path" option (Windows only).
    Improved the WIN_SSPI plugin to produce keys for the WireCrypt plugin.
    Made it possible for the AuthClient plugin to access the authentication block from DPB.
    Added ability to use "install.sh -path /opt/my_path" without a need to install Firebird first in the default folder.
    Implemented option to restore compressed .nbk files without explicitly decompressing them.

[close]

http://www.firebirdsql.org/

[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

-Data Browser :
Add: Supports filtering data with the selected cells (7317)
Multiple data items in different fields can be selected at the same time
Upd: Filtering data of a column : Change to clear processing when clicked again (7317)
-AutoComplete and IntelliSense :
Add: Support WITH common_table_expression field automatic perception processing (7317)
-Data Export :
Add: export format MERGE statement (* .sql): support PostgreSQL INSERT INTO ... ON CONFLICT ... (7317)
Add: export format MERGE statement (* .sql): Add related settings dialog (7317)
-Generating Scripts :
Add: (SQL Server / SQL Azure) Added SCRIPT AS UPSERT (MERGE / REPLACE) syntax definition generation (Note: Missing enabled) (7317)
Add: (Oracle) Support for generating the MATERIALIZED VIEW COMMENT object annotation (7317)
Upd: (Firebird) Added BLOB data type (SEGMENT SIZE) attribute content (7317)
Add: (Informix) Update UDDT custom type display, and support Distinct type instruction code generation processing (7317)
Fix: (Informix) Fix SYNONYMS generation instruction code processing (7317)
Fix: (SQL Server 2008 + / SQL Azure) Fixed the problem that Sparse Columns and Column Sets are not displayed (7317)
-Main program update ( Main ):
Add: Support SYNONYMS to click re-brush processing under child nodes (7317)
Add: (NuoDB) Supports Drop User-Defined Data Types (7317)
Fix: Fixed (Refresh User-Defined Data Types) clicking the taskbar to re-brush has no effect (due to the enabled state) (7317)
Upd: Others include cumulative minor updates, corrections and optimizations (7317)

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

    LDAP group sync broken on 0.34.0 (#11617)
    PermissionSQL questions cannot be viewed after granted "View access" (#11672)
    Unable to connect Presto in v0.34.0 (#11598)
    Can't edit segments (#11343)
    Charts not working with window smaller than 800px wide (#11619)
    Field filters mismatch Datetimes and Timestamps (#11578)
    Can't break out Google Analytics metrics by Date:Month (#11489)
    Metabase does not install new version of database plugins when upgrading (#11699)
    Fix issues where dates in Pulses could be formatted with wrong year (year of the start of the week instead of actual year) (#11692)
    Pulse charts don't honor custom column names (#11655)
    Boolean field filters don't work correctly for Oracle (#11693)
    MongoDB single date field filters aren't working correctly (#11690)
    Trend/SmartScalar visualization returns NaN when % growth over 1000 (#11630)
    Automagic dashboards fail on PeriodDuration.between (#11603)
    Native query on sql server with filter on bit column type throws exception- Invalid column name 'TRUE'. (#11592)
    Native/SQL editor displaces cursor one position to the right of mouse click (#11584)
    Interrupted typing when adding a SQL parameter (#11581)
    Native/SQL variable panel, cards jumps around when editing (#11580)
    Native questions shows Save-button without changing anything (#11572)
    Trend/Smart Number does not work when dates are descending (#11089)

    Enhancements:

    GeoJSON proxy response performance improvements and improved resource cleanup (#11706)

[close]

https://www.metabase.com/

[SiLæncer]

Changelog

    Oracle: procedures/views source code editor was fixed
    MySQL: database restore log level config was fixed
    Netezza: views and procedures source extraction was fixed
    Hive: view editor was fixed
    Neo4j: arrays support was fixed, SQL parser was fixed
    Metadata editor: current database detection was fixed
    Tooltips for database navigator were improved
    Variables in connection parameters now enabled by default
    Connection type permissions save was fixed
    Dark theme support was improved in the main toolbar and in different dialogs
    SSH agents support was fixed (now we use ssh-agent on Linux)
    SSH + private key + password: configuration dialog was fixed
    A lot of minor bugfixes

    Tasks:

    SQL script execute task was added
    Variables support was added
    Grouping of tasks by project/type was added
    Active database/schema now saved for custom SQL queries
    Target table mapping was fixed for database-to-database data transfer

    Data viewer:

    Column filter UI was improved (multi-value select, value search)
    Null XML columns support was fixed
    Column value transformations and coloring was fixed
    Context menu was improved (layout was change, missing commands were added)
    Problem with missing toolbar actions was fixed
    Hex editor coloring was improved, dark theme support was added

    SQL editor:

    Auto-complete now respects active schema
    Database output read was fixed (async mode)
    Hyperlinks and object navigation were fixed
    Aliases generation algorithm was improved

    PostgreSQL:

    Database restore task was fixed (target database)
    SQL parser was fixed (BEGIN/END keywords)

[close]

https://dbeaver.io/

[SiLæncer]

Changelog

Add support for generated columns.
Add the sqlite3_hard_heap_limit64() interface and the corresponding PRAGMA hard_heap_limit command.
Enhance the function_list pragma to show the number of arguments on each function, the type of function (scalar, aggregate, window), and the function property flags SQLITE_DETERMINISTIC, SQLITE_DIRECTONLY, SQLITE_INNOCUOUS, and/or SQLITE_SUBTYPE.
Add the aggregated mode feature to the DBSTAT virtual table.
Add the SQLITE_OPEN_NOFOLLOW option to sqlite3_open_v2() that prevents SQLite from opening symbolic links.
Added the "#-N" array notation for JSON function path arguments.
Added the SQLITE_DBCONFIG_TRUSTED_SCHEMA connection setting which is also controllable via the new trusted_schema pragma and at compile-time using the -DSQLITE_TRUSTED_SCHEMA compile-time option.
Added APIs sqlite3_filename_database(), sqlite3_filename_journal(), and sqlite3_filename_wal() which are useful for specialized extensions.
Add the sqlite3_uri_key() interface.
Upgraded the sqlite3_uri_parameter() function so that it works with the rollback journal or WAL filename in addition to the database filename.
Provide the ability to tag application-defined SQL functions with new properties SQLITE_INNOCUOUS or SQLITE_DIRECTONLY.
Add new verbs to sqlite3_vtab_config() so that the xConnect method of virtual tables can declare the virtual table as SQLITE_VTAB_INNOCUOUS or SQLITE_VTAB_DIRECTONLY.
Faster response to sqlite3_interrupt().
Added the uuid.c extension module implementing functions for processing RFC-4122 UUIDs.
The lookaside memory allocator is enhanced to support two separate memory pools with different sized allocations in each pool. This allows more memory allocations to be covered by lookaside while at the same time reducing the heap memory usage to 48KB per connection, down from 120KB.
The legacy_file_format pragma is deactivated. It is now a no-op. In its place, the SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config() is provided. The legacy_file_format pragma is deactivated because (1) it is rarely useful and (2) it is incompatible with VACUUM in schemas that have tables with both generated columns and descending indexes. Ticket 6484e6ce678fffab

[close]

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

[SiLæncer]

Changelog

    Main program update ( Main ):

    Add: (64bit) Support VistaDB 6 database
    Upd: backward compatible with VistaDB 5 database
    Add: Support VistaDB 5 to VistaDB 6 Database (Database Tools-> Upgrade)
    Upd: (VistaDB / SQLCe) Improve the speed of opening encrypted database
    Fix: (SQL Server / SQL Azure) Solve the problem that the field information cannot be obtained correctly when the table name prefix is ​​_ (second correction)
    Upd: (Teradata) Exclude Built-in Custom Types (User-Defined Data Types) Browse Display
    Fix: (Sybase ASE) Fix database creation processing (Database Tools-> Create)
    Upd: Others include cumulative minor updates, corrections and optimizations

    Generating Scripts:

    Upd: (Oracle) Significantly improves the processing speed of Foreign Key Relationships (50% +) (affects multiple functions) (7331)
    Fix: (PostgreSQL 12) Fixed an issue that could not generate UDDT script

    Binding SQL variables:

    Upd: Automatically exclude @var: = xxx and @ var = xxx configured bind variable processing
    Upd: Change the interrupt processing (No) to cancel the setting (Cancel) and continue execution to avoid any misjudgment

    SQL Formatting:

    Upd: Added DROP [type] IF EXISTS [objname] formatted exception handling

    Filtering data with the selected cells:

    Upd: Automatically exclude if the field type of the selected cell is not supported

    Database Migration (Pro):

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

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

    Revert the data layout for an internal-use-only SQLite data structure. Applications that use SQLite should never reference internal SQLite data structures, but some do anyhow, and a change to one such data structure in 3.30.0 broke a popular and widely-deployed application. Reverting that change in SQLite, at least temporarily, gives developers of misbehaving applications time to fix their code.
    Fix a typos in the sqlite3ext.h header file that prevented the sqlite3_stmt_isexplain() and sqlite3_value_frombind() interfaces from being called from run-time loadable extensions.

    Hashes:
    SQLITE_SOURCE_ID: 2020-01-27 19:55:54 3bfa9cc97da10598521b342961df8f5f68c7388fa117345eeb516eaa837bb4d6
    SHA3-256 for sqlite3.c: de465c64f09529429a38cbdf637acce4dfda6897f93e3db3594009e0fed56d27

Changes carried forward from version 3.31.0 (2020-01-22):

    Add support for generated columns.
    Add the sqlite3_hard_heap_limit64() interface and the corresponding PRAGMA hard_heap_limit command.
    Enhance the function_list pragma to show the number of arguments on each function, the type of function (scalar, aggregate, window), and the function property flags SQLITE_DETERMINISTIC, SQLITE_DIRECTONLY, SQLITE_INNOCUOUS, and/or SQLITE_SUBTYPE.
    Add the aggregated mode feature to the DBSTAT virtual table.
    Add the SQLITE_OPEN_NOFOLLOW option to sqlite3_open_v2() that prevents SQLite from opening symbolic links.
    Added the "#-N" array notation for JSON function path arguments.
    Added the SQLITE_DBCONFIG_TRUSTED_SCHEMA connection setting which is also controllable via the new trusted_schema pragma and at compile-time using the -DSQLITE_TRUSTED_SCHEMA compile-time option.
    Added APIs sqlite3_filename_database(), sqlite3_filename_journal(), and sqlite3_filename_wal() which are useful for specialized extensions.
    Add the sqlite3_uri_key() interface.
    Upgraded the sqlite3_uri_parameter() function so that it works with the rollback journal or WAL filename in addition to the database filename.
    Provide the ability to tag application-defined SQL functions with new properties SQLITE_INNOCUOUS or SQLITE_DIRECTONLY.
    Add new verbs to sqlite3_vtab_config() so that the xConnect method of virtual tables can declare the virtual table as SQLITE_VTAB_INNOCUOUS or SQLITE_VTAB_DIRECTONLY.
    Faster response to sqlite3_interrupt().
    Added the uuid.c extension module implementing functions for processing RFC-4122 UUIDs.
    The lookaside memory allocator is enhanced to support two separate memory pools with different sized allocations in each pool. This allows more memory allocations to be covered by lookaside while at the same time reducing the heap memory usage to 48KB per connection, down from 120KB.
    The legacy_file_format pragma is deactivated. It is now a no-op. In its place, the SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config() is provided. The legacy_file_format pragma is deactivated because (1) it is rarely useful and (2) it is incompatible with VACUUM in schemas that have tables with both generated columns and descending indexes. Ticket 6484e6ce678fffab

[close]

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

[SiLæncer]

Whats new:>>

    The number of rows of a subject table to be exported can now be limited taking into account a possible column order.
    Nullable primary key columns could lead to incorrect results under certain circumstances.
    In the data browser, the user interface sometimes blocked when the acquisition of database metadata took a long time.

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