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

- Data Browser and Editor :

Upd: Virtual Mode: Optimize the sort processing speed of the field (7159)
Upd: Virtual Mode: Supports filtering of related data in the field (7159)
Fix: Virtual Mode: Fixed problem handling for multiple SQL queries (7157/7159)

- Data Visualization :

Upd: Supports visualization of data after filtering data ( a column ) (7159)

- Main program update ( Main ):

Upd: Others include cumulative small updates, corrections and optimizations (7159)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

            - Data viewer:
                - Virtual primary/foreign keys editors were enhanced
                - Problem with filters on data refresh was fixed
                - Added confirmation dialog before opened result tabs closing
                - Problem with missing updated row count (in script mode) was fixed
                - References panel now remembers last FK/reference selection
                - Value view panel now supports Find/Replace
                - Float values rendering was fixed (numbers rounding is disabled by default)
            - Data transfer:
                - Save of previous target container selections was added
                - Export of tables/queries with complex data types (structs, objects) was improved
            - Connection management:
                - Connection permissions config was added (restrictions of data/metadata changes for a particular connection or connection type)
                - Problem with bootstrap queries and auto-commit state save/load was fixed
                - Multi-project support was improved (use selected project for new connections)
                - Support of empty database passwords was added
                - Copy/paste and drag-n-drop connections between different projects was fixed
            - Database navigator:
                - Default double-click behavior configuration was added (view properties/data/erd)
                - Object edit dialogs are properly sized now (problem with too small dialog window was fixed)
                - Connection type coloring in the main toolbar is back
                - DBeaver toolbars visibility was fixed (for Eclipse plugin version)
            - New DBeaver version automatic downloading (optional) was added
            - MySQL:
                - Datetime columns edit was fixed. Problems with timezone were fixed.
                - Legacy MySQL <4 driver was added (again)
            - PostgreSQL:
                - Automatic transaction error recovery was added (famous "current transaction is aborted" error)
                - Partition management was added (partition create/drop)
                - Support of VACUUM tool for older PG version was fixed
                - Enum items order was fixed (in metadata editor)
                - Legacy PostgreSQL <= 8 driver was added
            - SQL Server: index DDL was improved (now it contains all index properties)
            - Redshift: table DDL generation was fixed ("diststyle AUTO" and other improvements)
            - Hive: struct/array data types support was added
            - Presto: array data types support was fixed
            - DB2 i: routine list reading was fixed
            - We have migrated to the Eclipse 2019-06 platform (fixes many minor UI bugs on Linux)
            - Many other minor bugs were fixed

[close]

https://dbeaver.io/

[SiLæncer]

Changelog

- Main program update ( Main ):
Upd: Optimize the processing speed when multiple query tabs (Query Tabs) are closed (7170)
Fix: Fixed node expansion/exposure update status (7170)
Upd: Firebird component version updated to FirebirdSql.Data.FirebirdClient.dll 7.0.0.0 (2019/08/15) ) (7170)
Upd: VistaDB component version updated to VistaDB.5.NET40.dll 5.8.7 (2019/08/05) (7170)
Upd: Others include cumulative small updates, corrections and optimizations (7170)
Misc: Compatible with Compatible with PostgreSQL 12.0 beta 3 / 11.5 / 10.10 / 9.6.15 / 9.5.19 / 9.4.24 (2019/08/08)
- Plain Execution Plan :
Add: (64bit) Support for HP Vertica 7.x with textual execution plan display processing (7170)
Add: (64bit) Add "Directly Execution Plan Only: Ctrl + F7 " (7170)
Upd: (64bit) Optimize MySQL/SQLite textual execution plan display when digital highlight processing speed (7170)
- Data Browser and Editor :
Upd: Virtual Mode: Optimize the sort processing speed of the field (7159)
Upd: Virtual Mode: Supports filtering of related data in the field (7159)
Fix: Virtual Mode: Fixed problem handling for multiple SQL queries (7157/7159)
- Data Export :
Upd: Export Excel format no longer displays prompts if there is no data to facilitate command line processing (same as other output formats) (7170)
- Data Editor :
Upd: Update right-click menu and work column re-brushing function consistency processing (7170)
- Cell Editor / Cell Viewer :
Fix: Fixed issue with [current] field editing on [new column] (7170)
- Filtering data of a column :
Upd: Supports Data Export , Data Visualization , etc. (7159/7170)
- Code Snippets :
Upd: Optimized and improved interface display processing (7170)
- Database Migration (Pro):
Upd: All updates are the same as dbMigration .NET Software (7170)

[close]

http://fishcodelib.com/Database.htm

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

    Fixed a bug that caused a Liquibase export not to work for Postgres TEXT columns.
    SQL Console didn't work with SQLite.
    Improved validation of CLI arguments.
    The "Upsert" statements are generated for more compact.
    Feature Request 65. https://sourceforge.net/p/jailer/feature-requests/65/

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

- User Interface: Dark Mode :

Upd: Highlighting Groups of Cells shows problems (7171)

- Main program update ( Main ):

Upd: MySQL component version [return] to MySql.Data.dll 6.9.12 (2018/04/27) ( ) (7171)
Fix: Fixed (7156) Resolved issues not supported by older versions of MySQL 5.0.x (7171)
Upd: Others include cumulative small updates, corrections and optimizations (7171)

- Database Migration (Pro):

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

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

Importing C/BLOBs did not work without write permission on the working directory.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

- Main program update ( Main ):

Upd: Compatible with Compatible with Microsoft Windows 10 (20H1) (7181)
Add: Support for Sorting Tabs by Type and Name (7181)
Upd: (SQL Server) Database settings will no longer be displayed when offline or without permission access (7181)
Fix: Fix the problem that the message dialog shows the content length limit (7181)
Upd: Others include cumulative small updates, corrections and optimizations (7181)

- AutoComplete and IntelliSense :

Fix: Correct text highlighting deviation problem (7181)

- User Interface: Dark Mode :

Upd: Add error message/execution plan/text result/auto-complete...etc. dark mode display (7181)

- Security Manager :

Add: (SQL Server) Add Library Online/Offline Settings (7181)
Add: (SQL Server) Add database property script generation display (7181)
Fix: (MariaDB) Fixed user lock and password expiration enabled state under different versions (7181)
Upd: (PostgreSQL) Support ENCRYPTED PASSWORD 'xxx' Encrypted content display (7181)

- Database Migration (Pro):

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

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

- Security Manager :
Add: (SQL Server) Support Library Properties [Settings] Processing (7184)
- Main program update ( Main ):
Upd: Others include cumulative small updates, corrections and optimizations (7184)
- Database Migration (Pro):
Upd: All updates are the same as dbMigration .NET Software (7184)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

    "[new feature] add command line options to bypass the data model selection dialog" https://github.com/Wisser/Jailer/issues/14
    "Multiple table selection" https://github.com/Wisser/Jailer/issues/13
    The model selection dialog has been improved. Recently used connections/sessions/bookmarks can be reopened with a single click.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

    "[new feature] add command line options to bypass the data model selection dialog" #14
    "Multiple table selection" #13
    The model selection dialog has been improved. Recently used connections/sessions/bookmarks can be reopened with a single click.
    The sorting settings of table browsers in bookmarks are recorded and restored.
    New feature "Find Column..." of the data browser makes it easy to find a column in a wide table.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

            - Data viewer:
                - JSON highlighting/formatting was added
                - Select/deselect rows with alt+click was improved
                - Reference panel now supports virtual foreign keys
                - "Set to default value" action was fixed (for timestamp columns)
                - Dictionary read was fixed
            - ERD:
                - Table/schema diagram edit is now supported
                - Virtual foreign keys support was added
            - Database navigator:
                - Transactions tracking was improved (+now commit/rollback actions are always active)
                - Cross-project connections copy-paste and drag-n-drop was fixed
                - Navigator tree state save (and restore on restart) was added (thanks to loro2)
                - Columns reordering was fixed
                - Global filters configuration was fixed
                - Connection permissions are now supported in connection type (prod, dev, test)
            - SQL editor:
                - Query execution time logging was fixed
                - Generate SQL dialog was improved (FQ names, copy to clipboard)
                - Script selector panel UI was fixed
                - Variables binding now can be skipped for a query/script
                - JDBC fetch size now set for custom SQL queries
            - Data export now reuses SQL editor connection
            - Metadata editor: columns drop was fixed
            - SQL Server:
                - NVARCHAR/NCHAR length calculation was fixed
                - Column default value edit support was added
                - DDL for TEXT/NTEXT data types was fixed
            - PostgreSQL:
                - Driver now uses URL template (by default)
                - Column comments for new tables now saved properly
            - SQL Server Data Warehouse support was added
            - MySQL: bit stream data type support was fixed
            - CockroachDB: table metadata read was fixed
            - Apache Derby driver was upgraded
            - Teradata: multiple resultsets support was added
            - Test connection dialog was redesigned
            - Driver libraries cache was fixed (re-download of Maven artifacts)
            - Widows registry reading was fixed (Java 8 compatibility)
            - Many other minor bugs were fixed

[close]

https://dbeaver.io/

[SiLæncer]

Changelog

- Data Import :
Upd: Delimited file format: Supports automatic character encoding content import processing (7191)
Upd: (SQL Server/SQL Azure/Sybase ASE/VistaDB) Automatically cancels the field of data type Timestamp (7191)
- Data Editor :
Add: Supports the calculation of the data field (Computed Columns) when there is no primary key (PKs) (7191)
- Filtering data of a column :
Fix: (Oracle/Teradata) Resolves an issue where the Decimal data type field cannot be processed (7191)
- Security Manager :
Add: (SQL Server) Support Library Properties [Settings] Processing (7184)
- AutoComplete and IntelliSense :
Upd: Optimize the speed of querying Tables/Views objects (7191)
- Main program update ( Main ):
Add: Set options to increase the user interface category (Options->User Interface), including language font and color settings (7191)
Upd: Firebird component version updated to FirebirdSql.Data.FirebirdClient.dll 7.1.1.0 (2019/09/05) ) (7191)
Upd: Others include cumulative small updates, corrections and optimizations (7191)
- Database Migration (Pro):
Upd: All updates are the same as dbMigration .NET Software (7191)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

- 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)
- Security Manager :
Add: (PostgreSQL) Support Structure Description Permission Syntax Generation (GRANT x ON SCHEMA TO x) (7193)
- Main program update ( Main ):
Upd: (SQL Server/SQL Azure/Sybase ASE) Improve all query (SELECT) encoding problem processing (7193)
Upd: Others include cumulative small updates, corrections and optimizations (7193)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

    Upsert statements in PostgreSQL format could fail due to missing explicit conversion of "bytea" literals.
    The data model editor is now more robust against errors in the data model files.
    Minor improvements to the GUI and bug 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:>>

    Upsert statements in PostgreSQL format could fail due to missing explicit conversion of bytea literals.
    The data model editor is now more robust against errors in the data model files.
    Minor improvements to the GUI and bug fixes.

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