Thema: Datenbanksoftware und Tools diverses ...

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

    Deadlock prevention in PostgreSQL.
    Support for PostgreSQL type "bpchar".
    Improved display of errors in the data browser.
    More robustness if primary keys are not specified correctly.

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

    Deadlock prevention in PostgreSQL.
    Support for PostgreSQL type "bpchar".

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

[SiLæncer]

Changelog

            - SQL editor:
                - Select row count from custom query was fixed (ORDER BY now allowed)
                - Parameters/variable binding was fixed
                - Export from query with parameters was fixed
                - Number of improvements in intellisense algorithms
            - Data viewer:
                - Smooth scrolling mode was added
                - Number of fixes in floating point numbers handling
                - Option for short/fully qualified table names in SQL script was added
                - Grid state save/restore (after ordering/filter apply) was fixed
                - Tabs pin + drag-n-drop behavior was fixed
            - Tables navigation was fixed (filter value refresh)
            - Query manager: query ordering/refresh was fixed
            - ERD: problem with broken layout after config change was fixed
            - CSV export: row separator config was added
            - PostgreSQL:
                - $$ delimiters handle was fixed
                - Function parameters default value reading was fixed
            - Oracle: table column comments save was fixed
            - SQL Server: functions and synonyms support was added in object search
            - Java version in Windows ad MacOS installers was upgraded to OpenJDK 11.0.5
            - A lot of other minor UI fixes

[close]

https://dbeaver.io/

[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 ):
Upd: Optimize user experience and efficiency: If the switch query tag belongs to a [different] database or structure description, change the [execution] query instead of automatic switching (7247)
Add: Support for PostgreSQL 8.0.x (compatible with Amazone Redshift ) database system (7247)
Add: Query Settings option to enable automatic recognition mode setting after connection ( Query Settings -> Enable Auto-Commit mode when connected ) (7247)
Upd: Improved MariaDB version detection processing, affecting related functions (7247)
Fix: (Oracle) Fixed FUNCTIONS/PROCEDURES Arguments data type display problem (7247)
Upd: SQLite component version updated to System.Data.SQLite.DLL 1.0.112.0 (3.30.1) (2019/10/28) (7247)
Upd: Others include cumulative small updates, corrections and optimizations (7247)
- Command line processing ( Command-line ):
Add: Support multiple configuration settings (Multiple Profiles: [-c:"your profile path"])
(Relative Path) app.exe -c:"Database_Files1" , app.exe -c:"../Database_Files2"
(Absolute Path) app.exe -c:"x:\Database_Files1" , app.exe -c:"x:\db1\Database_Files2"
- AutoComplete and IntelliSense :
Add: (SQL Server/SQL Azure/Sybase ASE) Supports both Cross-database. <schema.table> , Cross-database.schema. <table> Cross-database awareness processing (7247)
Add: Cross-schema: Support for database processing such as IBM DB2/Informix (7247)
Fix: Cross-database and Cross-schema: Perceived ability optimization and correction processing (7247)
Fix: Cross-database: Fixed an issue where [schema] could not be processed with quotes (7247)
Add: Add data table aliases automatically generated (Options -> Editor -> AutoAliases: Auto-generate aliases for tables and views) (7247)
Add: Add re-brushing field cache processing (

• Refresh column caches): Click
• to re-update content in the status column below the display field list (7247)

Fix: Improved avoidance of Schema name repetitive processing when inserting object names (7247)
- SQL Editor ( SQL Editor ):
Upd: Uppercase and lowercase suboptions ( U Uppercase and L Lowercase) moved to the format main option (SQL Formatting) (7247)
Fix: Execute current statement: Ctrl + Enter : Fix the parsing problem when including single-line annotations (7247)
- Table Designer :
Add: Support for adding fields of type AUTOINCREMENT to existing data tables (7247)
(SQL Server/SQL Azure/Sybase ASE/SQLCe/Access/PostgreSQL/MySQL) Support for adding new values ​​and automatically assigning them to non-empty data tables
(VistaDB/NuoDB) Support for addition under non-empty data table but need to be set to NULL
(Firebird/Informix/FoxPro) only supports adding under the empty data table
Fix: (Firebird) Correction of the processing line (Collation Name) generation processing priority (7247)
- Database Migration (Pro):
Upd: All updates are the same as dbMigration .NET Software (7247)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

- AutoComplete and IntelliSense :

Add: Add data table aliases automatically generated (Options -> Editor -> AutoAliases: Auto-generate aliases for tables and views) (7247/7248)
Fix: Cross-database and cross-schema: Perceived ability optimization and correction processing (7247/7248)

- Main program update ( Main ):

Upd: Others include cumulative small updates, corrections and optimizations (7247/7248)

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

    Support for data type datetime2 in MS SQL. https://github.com/Wisser/Jailer/issues/20
    The -schemamapping option was not used correctly for the statements of a delete script. https://github.com/Wisser/Jailer/issues/21
    Formatting of dates/timestamps during export no longer takes place synchronized. This improves performance when multiple threads are used.
    Minor improvements to the "Export Data" dialog.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

    Support for data type datetime2 in MS SQL.
    The -schemamapping option was not used correctly for the statements of a delete script.
    Formatting of dates/timestamps during export no longer takes place synchronized.
    This improves performance when multiple threads are used.
    Minor improvements to the "Export Data" dialog.

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.
    Improvements in exporting to JSON and user defined export formats.
    Minor changes and bugfixes in the user interface and command line processing.

[close]

http://www.vlsoftware.net/

[SiLæncer]

Whats new:>>

    Fixed NullPointerException in Data Browser.
    Support for data type datetime2 in MS SQL. #20
    The -schemamapping option was not used correctly for the statements of a delete script. #21

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

Fixed NullPointerException in Data Browser.

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

[SiLæncer]

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

License: Open Source

Changelog

    Added Dark(Beta) UI Theme option.
    Added support for custom theme creation and selection.
    Added encrypted password in reverse engineered SQL for roles.
    Support Enable Always and Enable Replica on triggers.
    Add an option to request confirmation before cancelling/resetting changes on a Properties dialog.
    Rename the context menu from 'Drop Server' to 'Remove Server'.
    Fixed issue where Drop and Disconnect connection menu points are too close to each other.
    Ensure all messages are retained in the Query Tool from long running queries.
    Ensure compression level is passed to pg_dump when backing up in directory format.
    Ensure the number of jobs can be specified when backing up in directory format.
    Download your copy here.

[close]

https://www.pgadmin.org/

[SiLæncer]

Changelog

            - Problem with context menu was fixed (on Linux)
            - Problem with mixed global/connection settings was fixed
            - SSH: "jump" server support was added (thanks to bsv798)
            - Data editor:
                - Vertical and horizontal scroll position is now saved between data refresh/filter
                - Smooth scroll mode is now the default mode (and configurable)
                - Large json loading performance was improved
                - Ordering by unnamed columns was fixed
                - Grouping panel refresh was fixed
                - Data export/copy as: use the same connection by default
            - Object editor: property change and object rename was fixed (right order of DDL queries)
            - SQL editor: CASE/WHEN formatting was fixed
            - Oracle: data type editor UI was fixed
            - MySQL: events DDL was fixed (interval)
            - PostgreSQL: array-based domain data types handle was fixed
            - SQL Server: synonyms search was added
            - HANA: table column create was fixed
            - Greenplum 6+: table DDL (distribution) was fixed
            - Full-text search dialog render was fixed
            - Application startup speed was improved
            - Several rendering glitches on HighDPI screens were fixed
            - Many other minor UI fixes

[close]

https://dbeaver.io/

[SiLæncer]

Changelog

- AutoComplete and IntelliSense :
 Add: Adds whether the object owner is included when the object is inserted (Enabled -> owner.object , Disabled -> object ) (7261)
 (Options -> Editor -> InsertOwner: whether or not to include object owner after inserting an object)
 Add: IntelliSense: Inductive processing such as EXEC/EXECUTE/CALL+<space> PROCEDURES/FUNCTIONS (7261)
 Upd: Cross-database and Cross-schema: Perceptual optimization and related correction processing (7261)
 Fix: Fixed a problem with the window zoom problem that may cause the screen to display abnormally (7261)
- Highlighting Groups of Cells :
 Upd: distinguishes between NULL / 'NULL' / EMPTY and other content display processing (7261)
- Multiple Tabs and Browsing Mode :
 Upd: Optimize the problem of multi-page automatic switching to vertical browsing mode when initial execution (7261)
- Data Editor :
 Add: Right-click menu Set as NULL New sub-function [E] Set as Empty is set to empty (7261)
- Backup and Restore :
 Add: Support SQL Server 2017/2019 on Linux database backup and restore (7261)
- Main program update ( Main ):
 Add: Support for Microsoft Windows 10 (1909) Operating System (7261)
 Add: Support for SQL Server 2019 GA database (7261)
 Upd: High DPI scaling processing: Improved multiple icons (Icons) and controls (Controls) automatic scaling processing (7261)
 Upd: Teradata component version updated to Teradata.Client.Provider.dll 16.20.8.0 (2019/10/09) (  ) (7261)
 Upd: Others include cumulative small updates, corrections and optimizations (7261)
 Misc: Compatible with Compatible with PostgreSQL 12.1 / 11.6 / 10.11 / 9.6.16 / 9.5.20 / 9.4.25 (2019/11/14)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

Minor changes and bugfixes.

http://www.vlsoftware.net/

[SiLæncer]

Release Notes

This security fix is part of an ongoing effort to improve the security of the Designer feature and is designated PMASA-2019-5. There is also an improvement for how we sanitize Git version information shown on the home page, thanks to Ali Hubail.

This release includes fixes for many bugs, including:

    Fixes for the "Failed to set session cookie" error which relates to the cookie name. In some cases, data stored in the cookie (such as the previously-used user account) may not be loaded from a previous phpMyAdmin cookie the first time you run version 4.9.2
    Fix for Advisor with MySQL 8.0.3 and newer
    Fix PHP deprecation errors
    Fix a situation where exporting users after a delete query could remove users
    Fix incorrect "You do not have privileges to manipulate with the users!" warning
    Fix copying a database's privileges and several other problems moving columns with MariaDB
    Fix for phpMyAdmin not selecting all the values when using shift-click to select during Export

There are many, many more bug fixes thanks to the efforts of our developers and other contributors.

[close]

https://www.phpmyadmin.net/