Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Changelog

            - Task management: now all data transfer operations (export/import) can be saved as tasks:
                - New task management view
                - Running saved tasks in two clicks
                - Task execution logs
            - Data transfer:
                - Output file names were fixed
                - Previous wizard settings save was fixed
                - Many minor improvements
            - Virtual table columns
                - Supported for all tables and views
                - Supports expressions, math functions and geometry transformation functions
            - Virtual foreign keys config save/copy was fixed
            - Data viewer:
                - Hex viewer was added for string content
                - Long CLOB text viewer was fixed
                - Filter dialog was fixed (orderings, distinct value reading)
            - SQL editor: parameters binding was improved:
                - Show dialog before script execution
                - Show current query text
            - Object editor: new command for expensive properties (row count) reading
            - SAP HANA - new extension developed (thanks to @kai-morich):
                - Driver auto-download
                - Sequences, synonyms, triggers
                - SQL execution plan
                - Object searcher
            - H2GIS: spatial data viewer was added
            - Redshift: stored procedures support was added
            - Yellowbrick: driver config was fixed for better performance
            - Oracle: view column comments edit support was added
            - A lot of minor UI fixes

[close]

https://dbeaver.io/

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

    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)"
    https://github.com/Wisser/Jailer/issues/16
    The initial base folder of the data models was incorrect if the installer was used on Windows.
    The minimum requirement for the number of available database connections has been reduced to a single one.
    Extensive internal redesigns since the last major release.

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

    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
    The initial base folder of the data models was incorrect if the installer was used on Windows.
    The minimum requirement for the number of available database connections has been reduced to a single one.
    Extensive internal redesigns since the last major release.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

    Fix a bug in the query flattener that might cause a segfault for nested queries that use the new FILTER clause on aggregate functions.
    Cherrypick fixes for other obscure problems found since the 3.30.0 release

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

Table Designer :

Add: Support data line sorting (Collation Name) setting processing (7226)
Support for databases such as SQL Server/SQL Azure/SQLite/PostgreSQL/Firebird/MySQL/NuoDB
Add: Column Properties setting increment type (Identity Type: BY DEFAULT / ALWAYS) setting processing (7226)
Support for libraries including Firebird 4+/Oracle 12+/PostgreSQL 10+/NuoDB/IBM DB2/Teradata
Upd: Boolean default value Selector: Increase the data type such as logical/yesno (7226)
Upd: (PostgreSQL) Enhanced data type automatic conversion processing, automatic use of arithmetic processing (USING expression) when conversion fails (7226)
Fix: (MySQL) Correct calculation data field transaction processing (7226)

Object Authorization Management (64bit):

Add: Add item menu to add SCHEMAS object option (7226)
Support for databases such as SQL Server/SQL Azure/NuoDB/IBM DB2/PostgreSQL/HP Vertica
Fix: After fixing the new object, the title column shows that the count is not updated synchronously (7226)
Upd: Unified PROCEDURE and FUNCTION group name display (7226)

Data Import :

Upd: Improve processing speed when importing large text content (7226)

AutoComplete and IntelliSense :

Fix: Fixed the problem of avoiding the conversion of Quoted Identifiers to uppercase (7226)

Main program update ( Main ):

Add: Support for PostgreSQL 12.0 RTM database (7226)
Upd: Improved query column display efficiency when query tabs (Query Tabs) switch (7226)
Fix: Resolve the problem of unable to read MATERIALIZED VIEW due to changes in PostgreSQL 12 (7226)
Fix: (PostgreSQL) Fixed a problem where MATERIALIZED VIEW could not display UDT field type (7226)
Fix: (Firebird) Automatically excludes connection exceptions (Error Code:335544325) (7226)
Upd: Others include cumulative small updates, corrections and optimizations (7226)

Database Migration (Pro):

Upd: All updates are the same as dbMigration .NET Software (7226)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

    The animation of the data model view in the desktop did not work.
    When the DDL is generated for a table, it is also generated for the indexes.
    Performance improvements.
    HiDPI display support.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

    Performance improvements.
    The animation of the data model view in the desktop did not work.
    When the DDL is generated for a table, it is also generated for the indexes.
    HiDPI display support.

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

[SiLæncer]

Whats new:>>

    Fetching results from PostgreSQL is now based on a cursor. This prevents out-of-memory errors with large amounts of data.
    Performance improvements.
    The animation of the data model view in the desktop did not work.
    When the DDL is generated for a table, it is also generated for the indexes.
    HiDPI display support.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

 Main program update ( Main ):

Add: High DPI scaling processing: Increase image (Icon) automatic scaling processing (7233)
Upd: High DPI scaling processing: Improved multi-text (Text) and control (Controls) automatic scaling processing (7233)
Fix: Avoid clicking the mouse to open the data sheet continuously, causing the exception to occur (7233)
Upd: Others include cumulative small updates, corrections and optimizations (7233)

- Generating Scripts :

Fix: (PostgreSQL) Fix EXCLUSION Constraints generation method (7233)
Upd: (PostgreSQL) Supports database versions below <8.4, including related function processing (7233)
Fix: (PostgreSQL) Fix database version below <9.0, exclude built-in TRIGGERS object display (7233)
Fix: (PostgreSQL 12) Resolve issues with CHECK constraints due to changes in v12 (7233)

- Data Browser and Editor :

Upd: Improved data type BigDecimal output and exception problem handling (7233)

- Data Editor :

Upd: Disable [field data filtering] processing in edit mode, should be replaced by [Query Filter Data] function (7233)

- Security Manager :

Upd: Improved generation of CREATE USER full content (7233)

- Connection Profile :

Add: Add a Save Button to change the connection settings (7233)
Fix: Secure Shell Protocol ( SSH: Secure Shell ): Fixed an issue where settings could not be canceled after saving (7233)

- Table Designer :

Add: Column Properties settings: Add Collation Name Automatically (7233)
Fix: (MySQL) Remove data type ENUM/SET The default value is null ''Processing (7233)

- Database Migration (Pro):

Upd: All updates are the same as dbMigration .NET Software (7233)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

Fetching results from PostgreSQL is now based on a cursor. This prevents out-of-memory errors with large amounts of data.

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 BYTES fields in data exporting.
    Minor improvements in exporting data to PostgreSQL, Microsoft Access, Visual FoxPro, Firebird, and Interbase databases.
    Minor improvements in data grids.

[close]

http://www.vlsoftware.net/

[SiLæncer]

Changelog

    SQL Editor: parameters binding dialog improvements (value preview)
    Data viewer:
        Result tabs drag-n-drop support was added
        Spatial data viewer was fixed (tooltips generator)
    Task editor: add/remove tables for existing task was fixed
    Virtual foreign keys support was fixed (table rename support)
    Oracle: Q-style quoting support was added
    PostgreSQL:
        Foreign Data Wrappers configurator wizard was added
        $$-quote support was fixed
        Dependencies info reading was fixed (PG12)
        Function signature generator was fixed (FQ type names)
    MySQL: column autoincrement flag editor was fixed
    Elasticsearch: driver version was updated
    Windows: app crash problem was fixed
    MacOS: app notarization added for all distributions
    Eclipse plugin: create .dbeaver folder on demand
    A lot of minor UI fixes

[close]

https://dbeaver.io/

[SiLæncer]

Whats new:>>

    More robustness if primary keys are not specified correctly.
    Improved display of errors in the data browser.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

    Improved display of errors in the data browser.
    More robustness if primary keys are not specified correctly.

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

[SiLæncer]

This tool allows completely manage any Interbase >5.x/Firebird database. It is based on Borland IBX components. It contains following modules:

    SQL Editor
    It contains SQL Editor with syntax highlighting with Result Buffer. You can run any type of sql statement or script. Output is flushed to formatted text, not to grid, what it allows more flexible and synoptic result overview.
    You can also export/import data to/from CSV, XML, raw batch file or printer.
    Every correctly run statement is saved in SQL History Buffer. You can open multiple instances of this editor to run "simultaneous" queries.
    Object Explorer
    Here you can inspect every database object including its detail properties. Some object you can edit too. Also you can extract metadata of all objects including data for tables.
    Event Watcher
    Here you can inspect user defined event triggering.
    Performance Monitor
    This tool allows profile and watch database operations. It contains following modules:
        Memory usage of watched database
        Number of writes and read to database and to buffer cache
    User Manager
    Allows you add, edit and delete database users and roles.
    Grant Manager
    Allows to grant or revoke privileges on all database objects.
    Services
    Here are available following services:
        Server Log View
        Server Properties Overview
        Database Statistics Overview
        Database Validation Task

Freeware

Whats new:>>

User manager allows to delete multiple accounts in one step.

http://www.mitec.cz/ibq.html