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

    SQL Editor:

    Add: Add the highlighted column [Selected] display (Highlight current line) (7373)
    Upd: Optimize the [Background] display of the highlighted column (Highlight current line: Options-> Editor-> LineViewerStyle = FullRow) (7373)
    Upd: Optimize the [Number] display of the highlighted column (Highlight current line: Options-> Editor-> LineNumber = True) (7373)
    Upd: Highlighting all matching words under cursor : Keep the original text color when the background is highlighted (7373)

    Generating Scripts:

    Add: Support node all object types [Delete] Script All Object Types as DROP (7373)
    Add: Support node column [Add and Query] script generation (Script Column as ALTER AND SELECT) (7373)
    Add: Support node foreign index key [New] Script Foreign Key as ALTER (7373)
    Add: Support node check condition constraint [New] Script Check Constraint as ALTER (7373)
    Fix: (Firebird) Fix CRUD Stored Procedures generation processing (7373)
    Fix: (Firebird) Fixed TRIGGERS generation script processing (backwards compatible with all database versions) (7373)

    AutoComplete and IntelliSense :

    Upd: Automatically select the first object in the field [ Check ] for easy insertion processing (7373)
    Fix: Improve click. Insert processing to avoid repeated prefix characters in some cases (7373)

    Main program update:

    Upd: Update status bar [color and text content] multiple improvements (7373)
    Fix: (Firebird) Exclude non-DATABASE TRIGGERS objects from being displayed (7373)
    Fix: (Free / Plus) Solve the problem of abnormal handling of High DPI scaling under 32bit (7355)
    Upd: Teradata component version updated to Teradata.Client.Provider.dll 16.20.9.0 (2020/01/24) ( ) (7373)
    Upd: Others include cumulative minor updates, corrections and optimizations (7373)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

New features and enhancements in this version:

    Support connecting to SQLite database files
    drop schema support for PostgreSQL
    support foreign keys in PostgreSQL
    support foreign keys in MS SQL
    read-only mode for grid cell editors, if underlying query or table does not allow updates
    support scram-sha-256 authentication on PostgreSQL
    enhanced readability of release notes
    enhanced readability of help links with dark themes
    support column comments of PostgreSQL
    support disabling "Full table status" on PostgreSQL
    new filter edit box on session manager, for filtering sessions using regular expressions
    close query tabs via middle mouse click
    trim text in various text inputs of session manager, to prevent leading and trailing spaces after pasting
    sort collation drop down on "Bulk table editor" alphabetically
    place icons on the 3 new/save/delete buttons on the session manager, to make them more noticeable
    performance: use first 1000 rows only for calculating the CSV export size, and interpolate the rest.
    widen buttons on search/replace dialog by one quarter, so translations fit better on them
    use default library of given network type in command line receiver
    refreshed application icon

Bugfixes:

    fix crashes when restoring tabs: expect no UTF-8 BOM
    Procedure body changes invisible when parameter tab is active
    last active session was no longer scrolled into view area of session manager
    crash when mouse moves over data grid with broken connection
    clicking too fast on session folder opens connection instead of collapse
    passphrase input for SSH tunnel now masked
    detect columns from PG table keys only in current schema, do not mix these with columns from an equally named table in a different schema
    fix crash when accessing data from data tab on a disconnected session
    fix crash when active main tab changes and data grid is disabled (due to disconnect)
    make copy/cut safer against harmless crashes, and show occurring error messages in log panel
    MSSQL: Remove surrounding parentheses from default value
    fix state of checkboxes on the session manager's Advanced tab
    fix crash by click on "Add column" in table editor, when columns list has a minimum height

Third party libraries and components:

    update libmariadb.dll to v3.1.7
    update libpq.dll to v10.0.11
    introduce additional libpq.dll v12.0.1
    update InnoSetup compiler to v6.0.3
    update VirtualTree component to v7.3
    introduce sqlite3.dll v3.30.1

Complete change list: https://github.com/HeidiSQL/HeidiSQL/milestone/4?closed=1

[close]

http://www.heidisql.com/

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

    Minor bugfixes in Export dialog, Field Mappings section. [Pro and Enterprise editions]
    Minor bugfixes in exporting data to SQL Server. [Pro and Enterprise editions]
    Minor changes.

http://www.vlsoftware.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:>>

    Fixed: Characters in bookmark names that are not valid in file names caused errors when saving the bookmarks.
    Minor improvements to the GUI of the data-browser.

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

    Fixed: Characters in bookmark names that are not valid in file names caused errors when saving the bookmarks.
    Minor improvements to the GUI of the data-browser.

http://jailer.sourceforge.net/

[SiLæncer]

Release Notes

The phpMyAdmin team announces the release of both 4.9.5 and 5.0.2.

Both versions contain several security fixes:

    PMASA-2020-2 SQL injection vulnerability in the user accounts page, particularly when changing a password
    PMASA-2020-3 SQL injection vulnerability relating to the search feature
    PMASA-2020-4 SQL injection and XSS having to do with displaying results
    Removing of the "options" field for the external transformation.

We are removing the ability for users to set "options" field for the external transformation. This must now be hard coded in the plugin file directly (where the program is configured). This feature allows users to pipe output directly to an executable file, however the options field presented a security risk and we have decided to move the options to be hard coded in the transformation plugin file. For further assistance, please reach out to our support team through email or Github pull request.

Version 5.0.3 also contains many bug fixes:

    Fix for copying a user account
    Removed SET AUTOCOMMIT=0 from SQL export
    Fix for the display of table borders
    Fix for ENUM radio button user interface problems
    Improved the prompt for abandoning changes when no changes were made in the SQL window
    Fix for inserting a primary key with "insert as new row"
    Fix incorrect suggested latest available version to version 5

There are many other bugs fixes, please see the ChangeLog file included with this release for full details.

Known shortcomings:

Due to changes in the MySQL authentication method, PHP versions prior to 7.4 are unable to authenticate to a MySQL 8.0 or newer server (our tests show the problem actually began with MySQL 8.0.11). This relates to a PHP bug https://bugs.php.net/bug.php?id=76243. There is a workaround, that is to set your user account to use the current-style password hash method, mysql_native_password. This unfortunate lack of coordination has caused the incompatibility to affect all PHP applications, not just phpMyAdmin. For more details, you can see our bug tracker item at https://github.com/phpmyadmin/phpmyadmin/issues/14220. We suggest upgrading your PHP installation to take advantage of the authentication methods.

As a reminder, phpMyAdmin 4.9 is in the long-term support phase where it will only get important security fixes and critical bug fixes. Users are suggested to migrate to version 5.0.

Downloads are available now at https://phpmyadmin.net/downloads/

For the phpMyAdmin team, Isaac

[close]

https://www.phpmyadmin.net/

[SiLæncer]

Changelog

    ERD viewer: table resize support was added
    Query manager: full query text view was fixed
    Connections invalidate was fixed (redundant connections open) and invalidate performance was improved
    SQLite: column rename support was added
    Snap package was significantly improved (thanks to @galgalesh)
    Many other minor bug fixes

    Data viewer:

    Search/replace in selected rows support was added
    Problem with Find/Replace and scrolling was fixed
    Floating point numbers rendering/copying was fixed (precision fix)

    SQL editor:

    Connection initialization was fixed (active schema set)
    Auto-completion for DROP/ALTER procedure/function was added
    Auto-completion for asterisk (*) was fixed
    Auto-completion for table aliases was disabled
    Auto sync with database navigator was fixed (proper catalog/schema change)

    Schema compare (simple):

    Compare progress visualization was fixed
    Stored procedures body compare was fixed
    SSH tunnel: default user name (current OS user) is used when user name not set

    PostgreSQL:

    PGPASS authentication was added
    Unique key indexes visibility was fixed
    Schema permissions viewer/editor was added
    Function/procedure create dialog was fixed
    Options for tables/functions DDL viewer now saved
    Enum values editor was added
    Array values copy-paste was fixed

    Oracle:

    Automatic driver download was added
    View constraints create/drop support was added

    DB2 LUW:

    Automatic driver download was added
    Table references read was fixed

    SQL Server:

    Driver download (native artifacts) was fixed
    Custom SQL query result editor was fixed
    Schema selector (main toolbar) was fixed

[close]

https://dbeaver.io/

[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

    Filter expressions, string extracts, and more:

    We've added filter expressions to let you write more complex filters that include ORs in them, and have also added a whole host of new spreadsheet-like functions to the custom column and custom metric formula editors.

    Reference saved questions in your SQL queries:

    You can now reference the results of saved questions in your SQL or native queries using syntax like with my_result as {{ #123 }} select * from my_result, where #123 is the ID number of a saved question.

    Performance improvements:

    We've refactored a number of things in this version, including how we handle the saved question "database" that allows you to use the results of saved questions as starting data for new ones. We hope you'll find that the net result is a much snappier loading times of pages throughout much of Metabase.

    Minor Enhancements:

    Replace util fns with ones from (updated) medley (#12061)
    Add background hover on bubble radio items (#12055)
    Add hover color to dash card titles (#12053)
    Add 'block' support to Select (#11894)

    Bug fixes:

    Improve chart value labels styling (#12160)
    Can't scroll columns list when creating a filter in the notebook (#12139)
    Cannot filter on joined/linked table when question has Custom Column (#12129)
    Expressions - Certain function text is impossible to read on hover (#12103)
    Homepage is missing sections (X-rays and Our data) on login (#12085)
    Public shared question does not show Y-axis (#12018)
    User with no data access are not allowed to see questions (#11932)
    Druid v0.17.0 Error for a simple query (#11925)
    Dashboard filter using boolean value sends string on browser reload (#11911)
    Cannot use mixed-type question filters on dashboard (#11882)
    Fixed a bug with date/range native query template tags for Unix timestamp columns (#11934)
    Don't use system command as alias with MySQL (#12098)
    Attempt to infer better base type for native queries (#12150)
    Fix some typos in docs (#12142)

[close]

https://www.metabase.com/

[SiLæncer]

Whats new:>>

Instant visualization of the contents of the row under the mouse pointer in the data browser.

http://jailer.sourceforge.net/

[SiLæncer]

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

License: Open Source

Changelog

    Added support of Collation, FTS Configuration, FTS Dictionary, FTS Parser and FTS Template to the Schema Diff.
    Added support of Domain, Domain Constraints and Types to the Schema Diff.
    Added and fixed gettext usage for better translation coverage.
    Improve logic to get the DDL statements as a part of the comparison.
    Enhance the color of switch control for both light and dark theme.
    Change some colors and opacity to comply with WCAG color contrast standards.
    Fixed tab key navigation issue for Grant Wizard.
    Fix an issue where the user can not change the value of DateTime picker control using keyboard.

[close]

https://www.pgadmin.org/

[SiLæncer]

Changelog

Bug fixes:

This release fixes two high priority bugs that were in version 0.35.0
Fixed a bug with date field filter variables in native queries and dashboards
Fixed a bug that was preventing filtering on columns from manually joined tables

Upgrading:

You can download a .jar of the release, or get the latest on Docker. Make sure to back up your Metabase database before you upgrade! Need help? Check out our upgrading instructions.
Docker image: metabase/metabase:v0.35.1
Download the JAR here: https://downloads.metabase.com/v0.35.1/metabase.jar

[close]

https://www.metabase.com/

[SiLæncer]

Changelog

    Main program update ( Main ):

    Add: (64bit) Add Vertical Tabs Mode (7400)
    Make full use of the large screen, so it can accommodate more labels to display (7400)
    Support title text search, can quickly find matching tags (7400)
    Support mouse scrolling, no need to click to quickly browse (7400)
    Upd: Massively optimized Dark Mode user interface display (7400)
    Upd: reconfigure multiple menu options to provide more intuitive operation processing (7400)
    Upd: Improve the update of quoted identifiers (Quoted identifiers) to avoid the problem of related preload statements failing after switching between different database types (7400)
    Upd: Synchronize and update the query label menu order after sorting and moving (7400)
    Fix: (SQL Server / SQL Azure) Fixed (7331) the problem that the SYSTEM VIEWS object field may be displayed abnormally (7400)
    Fix: Fix the problem that the label is not switched correctly when switching the structure description under the non-object tree view (7400)
    Fix: Fix the problem of querying the label [detection of existing] in the newly opened data table after the program restarts (7400)
    Upd: Others include cumulative minor updates, corrections and optimization (7400)

    SQL Editor ( SQL Editor ):

    Add: batch command GO , / increase horizontal line (Horizontal Line) display, can clearly display the execution block (7400)
    Add: integrate the cursor position information into the editor (7400)
    Add: Change the font size (Font Size) to the editor (7400)
    Add: Integrate Editor Options to Editor (7400)
    Upd: Improved Undo / Redo problem for multi-line processing of Comment and Indent (7400)

    Comparison query ( Comparison Query ):

    Fix: Fix the problem that the status of the taskbar is not updated synchronously (7400)

    Generating scripts ( Generating Scripts ):

    Fix: (PostgreSQL) Fix the problem of generating script when DOMAIN contains CHECK (also compatible with old database version) (7400)

    Connection profile ( Connection Profile ):

    Add: Connection test includes pre-loaded script (SQL statement) settings (7400)

    Database Migration (Pro):

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

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

    Database navigator:

    Simplified database structure view was added
    Navigator view settings and presets were added

    Object editor:

    Context menu was added to the object breadcrumbs
    Object alter script now can be opened in SQL editor

    Data editor:

    Preference and data format changes now applying immediately (without data refresh)
    Scrollbar position reset in columns reorder/filtering was fixed
    Number of selected rows/columns/cells now shown in the status bar
    Query filter history save/load was fixed
    Floating point numbers (4-byte precision) rendering was fixed
    SQL Editor: quick search tool was added (ctrl+alt+shift+f)
    Driver copy was fixed (problem with read-only URL)

    PostgreSQL:

    PGPASS support was fixed
    Database information (ctype, collate) reading was fixed
    Problems with default database change were fixed
    OID types rendering fix
    Domain metadata reading was fixed (base type qualified name)
    Extra options were added to database backup/restore wizards
    Redshift: data type resolution was fixed (array types)

    SQL Server:

    Driver download and “reset to default” was fixed
    Default schema detection was added
    Problems with read-only query results were fixed
    Column comments edit was fixed

    MySQL:

    Permission editor was fixed (schema privileges)
    Index rename support was added

    Exasol:

    Security tree (Exasol 7) was fixed
    Auto-completion for builtin functions was added
    Foreign keys metadata was fixed
    Oracle: “drop procedure” support was fixed
    SAP HANA: driver download was fixed
    Firebird: driver version was upgraded (4.0)
    Many other minor bug fixes

[close]

https://dbeaver.io/

[SiLæncer]

Whats new:>>

Minor improvements to the GUI of the SQL console.
Increased responsiveness and performance of the SQL Console.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

    Bug fixes:

    Improve form error handling (#12291)
    Fix email settings "Send test email" and "Clear" buttons (#12275, #12274)
    Fix "Premium embedding" setting (#12273)
    Cannot view/edit table-level permissions for databases that are not schema-based (#12269)

https://www.metabase.com/