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 ):
    Add: Support for PostgreSQL 12.0 beta 4 database (7198)
    Fix: Resolve the problem that GetSchemaTable cannot be obtained due to PostgreSQL 12 changes, which affects related function processing (7198)
    Upd: (SQL Server/SQL Azure/Sybase ASE) Improve all query (SELECT) encoding problem processing (7193)
    Upd: Update Database .NET Additional Files ( 32bit / 64bit ) (2019/09/14) (7198)
    Add: Support for PostgreSQL 12 Beta 4 database backup and restore (7198)
    Upd: Others include cumulative small updates, corrections and optimizations (7198)
    Constraint Designer :
    Add: (PostgreSQL/NuoDB/IBM DB2/Informix/HP Vertica) Supports association processing across different data table schemas (Schema) (7198)
    Upd: (SQL Server/SQL Azure/Sybase ASE) Add data table structure description (Schema) display (7198)
    Security Manager :
    Upd: (NuoDB) Allows deletion of non-empty structure description (Schema) objects (7198)
    Add: (PostgreSQL) Support Structure Description Permission Syntax Generation (GRANT x ON SCHEMA TO x) (7193)
    Generating Scripts :
    Fix: (HP Vertica) Fixed an issue that could not be generated across associations between different schemas (Schema) (7198)
    SQL Editor ( SQL Editor ):
    Upd: greatly optimized search and replace (Finding and Replacing) processing speed (7193)
    PrimaryKey Selector :
    Fix: Fixed an issue where the schema description (Schema) was not specified (7193)
    Database Migration (Pro):
    Upd: All updates are the same as dbMigration .NET Software (7198)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

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

License: Open Source

Changelog

    Added Gather Merge, Named Tuple Store Scan and Table Function Scan icon for explain module.
    Don't wait for the database connection before rendering the Query Tool UI, for improved UX.
    Allow configuration options to be set from the environment in the container distribution.
    Ensure editable and read-only columns in Query Tool should be identified by icons and tooltips in the column header.
    Add an Italian translation.
    Refactor Dockerfile to avoid needing to run supporting scripts (i.e. 'docker build .' will work) and minimise layers.
    Ensure Boolean columns should be editable using keyboard keys.
    Fix error while importing data to a table using Import/Export dialog and providing "Not null columns" option.
    Fix an issue where oid column should not be pasted when copy/paste row is used on query output containing the oid column.
    Ensure port and username should not be mandatory when a service is provided.
    Unescape HTML entities in database names in the Query Tool title bar.
    Fix PGADMIN_SERVER_JSON_FILE environment variable support in the container.
    Ensure sequence with negative value should be created.
    Fix issue where EXEC script doesn't write the complete script for Procedures.

[close]

https://www.pgadmin.org/

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

    Avoid NPE if there is no default scheme.
    Import filters did not work correctly when a foreign key column with a filter was exported,
    but not the corresponding primary key column.
    In the condition editor, scalar subqueries for columns of adjacent tables can now be generated.
    Minor fixes.


http://jailer.sourceforge.net/

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

    Avoid NPE if there is no default scheme.
    Import filters did not work correctly when a foreign key column with a filter was exported, but not the corresponding primary key column.
    In the condition editor, scalar subqueries for columns of adjacent tables can now be generated.
    Minor fixes.

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

[SiLæncer]

Release Notes

This is a regularly-schedule bugfix release that also includes some security hardening measures.

We wish to point out that this also includes a routine fix for an issue that has been reported as CVE-2019-12922. The fix for this has been in our release queue to be part of this release, however it is the opinion of the team that the reported attack vector did not justify a separate release.

This release includes fixes for many bugs, including:

    Editing columns with CURRENT_TIMESTAMP for MySQL versions 8.0.13 and newer
    Compatibility issues with PHP 8
    Export of GIS visualization
    Enhanced descriptions for several collation types
    Creating a user with a single quote in the password string
    Unexpected quotes during import and export on text fields
    Improvements to adding new tables to Designer
    Fix an issue where an authenticated user could trigger heavy traffic between the database server and web server
    Fix a weakness where an attacker, under certain conditions, working at the same time as an administrator is using the setup script, could delete a server from the setup script

[close]

https://www.phpmyadmin.net/

[SiLæncer]

Whats new:>>

Many other minor bugs were fixed

https://dbeaver.io/

[SiLæncer]

Whats new:>>

Hotfix release for Issue "Gui: NPE after renaming model file (*.jm)", #16

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

Hotfix release for Issue "Gui: NPE after renaming model file (*.jm)"

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

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

Changelog

    Better working with binary fields in data grid: it is now possible to view and copy the HEX representation of the contents of such fields.
    New export option: possibility to export data to Unicode without BOM.
    Minor changes in exporting to Excel (XLSX) formats. [Pro and Enterprise edition]
    Minor interface changes.
    Optimization of export procedures for some field types.

[close]

http://www.vlsoftware.net/

[SiLæncer]

Changelog

    Main program update ( Main ):

    Add: Support for High DPI scaling (7212)
    Supports zoom ratio from 100% to 300%+ above for automatic adaptation display processing
    Upd: Others include cumulative small updates, corrections and optimizations (7212)

    SQL Editor ( SQL Editor ):

    Add: Supports all matching words under cursor (7212)
    Directly click on text or selected text to highlight all matching strings

    Object Authorization Management (64bit):

    Add: Support structure description permissions (Managing schema permissions) (7212)
    Support for databases such as SQL Server/SQL Azure/NuoDB/IBM DB2/HP Vertica/PostgreSQL

    Security Manager :

    Add: Support structure description permission syntax generation (GRANT x ON SCHEMA TO x) (7212)
    Support for databases such as SQL Server/SQL Azure/NuoDB/IBM DB2/HP Vertica /PostgreSQL
    Upd: (SQL Server/Sybase ASE) Keep the original object group location after switching the database (7212)
    Upd: (SQL Server/Sybase ASE) Object structure description (Schema) increases the current database name display (7212)

    Horizontal and Vertical browsing mode :

    Upd: Auto displaying Scrolling (Automatic Scrolling) when the number of pages exceeds the display range (7212)

    Table Designer :

    Upd: (PostgreSQL 10+) Increase data type smallint/integer/bigint Support AutoIncerment setting (7212)
    Upd: (SQLCe 3.1/3.5) Increase data type bigint Support AutoIncerment setting (7212)
    Constraint Designer :
    Upd: (SQLite) solves the problem that the original window cannot be returned after the establishment fails (7212)
    Fix: Optimize the interface display, and correct the problem that [condition constraint name] cannot be restored after the establishment failure (7212)

    Cell Editor / Cell Viewer :

    Upd: If the content has been changed before the editor is opened, it will be saved before processing (7212)
    Upd: Save and Import will no longer appear in the query dialog (7212)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

    Minor improvements in data grids.
    Minor improvements and bugfixes in export procedures.

http://www.vlsoftware.net/

[SiLæncer]

Whats new:>>

    Hover & See function in the data browser to easily see which row is related to which other rows.
    Added configuration information for MariaDB.
    Fix for Issue "Gui: NPE after renaming model file (*.jm)"
    Extensive internal redesigns since the last major release.

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

[SiLæncer]

Whats new:>>

    Hover & See function in the data browser to easily see which row is related to which other rows.
    Added configuration information for MariaDB.
    Fix for Issue "Gui: NPE after renaming model file (*.jm)". #16
    Extensive internal redesigns since the last major release.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

    Add support for the FILTER clause on aggregate functions.
    Add support for the NULLS FIRST and NULLS LAST syntax in ORDER BY clauses.
    The index_info and index_xinfo pragmas are enhanced to provide information about the on-disk representation of WITHOUT ROWID tables.
    Add the sqlite3_drop_modules() interface, allowing applications to disable automatically loaded virtual tables that they do not need.
    Improvements to the .recover dot-command in the CLI so that it recovers more content from corrupt database files.
    Enhance the RBU extension to support indexes on expressions.
    Change the schema parser so that it will error out if any of the type, name, and tbl_name columns of the sqlite_master table have been corrupted and the database connection is not in writable_schema mode.
    The PRAGMA function_list, PRAGMA module_list, and PRAGMA pragma_list commands are now enabled in all builds by default. Disable them using -DSQLITE_OMIT_INTROSPECTION_PRAGMAS.
    Add the SQLITE_DBCONFIG_ENABLE_VIEW option for sqlite3_db_config().
    Added the TCL Interface config method in order to be able to disable SQLITE_DBCONFIG_ENABLE_VIEW as well as control other sqlite3_db_config() options from TCL.
    Added the SQLITE_DIRECTONLY flag for application-defined SQL functions to prevent those functions from being used inside triggers and views.
    The legacy SQLITE_ENABLE_STAT3 compile-time option is now a no-op.

[close]

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

[SiLæncer]

Whats new:>>

    Ability to clone registered database under a new name.
    Interface changes in Open Data Source and Registered Databases dialogs.

http://www.vlsoftware.net/