Thema: Datenbanksoftware und Tools diverses ...

[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

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

[SiLæncer]

Changelog

    Database navigator:

    View only connected data sources filter was added
    Quick search in connections/schemas options were added
    Multiple objects delete confirmation dialog was redesigned
    Tooltips visibility configuration was added in preferences
    Windows installer: shortcuts for “All Users” were fixed

    SSH tunnels:

    Support for OpenSSH key format was added
    Problem with dobule password prompt was fixed

    Data viewer:

    Grouping panel now supports column reordering
    Column modifier icons (key, read-only) were updated
    JSON/XML viewer performance was significantly improved
    SQL editor: toolbar buttons enablement was fixed

    Data transfer:

    Native client selector was fixed
    Extra file name pattern variables were added
    Native date/timestamp format support was added to the SQL INSERTS export
    Extra formatting options were added to the SQL INSERTS format
    MySQL: user credentials of mysqldump overwrite local configuration now

    SQL Server:

    SSL support was added
    Database create/drop/rename features were added

    PostgreSQL:

    Interval data type DDL was improved
    Table storage parameters were added to DDL
    “Connect as role” option was added in the connection settings
    Materialized view comment edit was fixed
    Trigger comment editor was added
    Oracle: extra NLS parameters were added on the connection settings page
    Snowflake: active schema set command was fixed
    Derby: unique indexes metadata read was implemented
    SQLite: column autoincrement option support was added
    Firebird: data types information read was fixed
    Several other minor UI bugs were fixed

[close]

https://dbeaver.io/

[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 interface improvements.
    Exporting to CSV and text: text data with line breaks are enclosed in quotes now.

http://www.vlsoftware.net/

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

    Changes:

    Automatic download of JDBC drivers.
    Workaround for bug "JDK-8215200 : IllegalArgumentException in sun.lwawt.macosx.CPlatformWindow"

http://jailer.sourceforge.net/

[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

    Presto not respecting SSL and always uses http instead of https (#13295)
    Footer (with export/fullscreen/refresh buttons) on Public/Embedded questions disappears when using Premium Embedding (#13285)
    Postgres sync not respecting SSH tunneling (#8396)
    Partial remediation of OOM errors on syncing large columns/rows (#13288)

[close]

https://www.metabase.com/

[SiLæncer]

Release Notes

    First the security fixes:

    PMASA-2020-5 XSS vulnerability with transformation feature
    PMASA-2020-6 SQL injection vulnerability with the search feature

    Next a few of the key bugfixes included with this release:

    Fix an error message about htmlspecialchars() when attempting to export XML
    Support double tapping to edit on mobile
    Fix the error message "Use of undefined constant MYSQLI_TYPE_JSON" when using mysqlnd
    Fix fatal JS error on index creation after using Enter key to submit the form
    Fix "axis-order" to swap latitude and longitude on MySQL 8.1 or newer
    Fix an error when overwriting an existing query bookmark
    Fix some warnings that appear with PHP 8
    Fix alter user privileges query when editing an account with MySQL 8.0.11 and newer
    Fix issues regarding TIMESTAMP columns with default CURRENT_TIMESTAMP in MySQL 8.0.13 and newer
    Fix a message that "Warning: error_reporting() has been disabled for security reasons" on php 7.x

[close]

https://www.phpmyadmin.net/

[SiLæncer]

Whats new:>>

    Automatic download of JDBC drivers.
    Workaround for bug "JDK-8215200 : IllegalArgumentException in sun.lwawt.macosx.CPlatformWindow"
    AdoptOpenJDK/openjdk-jdk11#10

http://jailer.sourceforge.net/

[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: (SQL Server/SQL Azure) Change to PROC method to improve the processing speed of index key reference acquisition (7613)
    Upd: Optimize (7607) interrupt handling capabilities, strengthen disconnected automatic reconnection processing (7613)
    Fix: ( PostgreSQL) Fix (7607) 25P02: current transaction is aborted may occur in transaction mode (7613)
    Fix: (Oracle) Fix (7607) the problem that DBMS_OUTPUT loses function, and rewrite the processing method (7611)
    Upd: Others include accumulation Minor updates, corrections and optimizations (7613)

    Transaction Mode ( Transaction Mode ):

    Fix: (SQLite) Fix the problem that SQL Profiler ( SQL Profiler ) is not supported in transaction mode (7613)
    Upd: (SQLite) distinguish journal mode=(wal/delete) processing method (7613) )
    Fix: corrected (7607) cause problems stalled under the trading model (7611)

    SQL editor ( SQL editor ):

    Fix: solve the execution cursor may disappear issue (7613)

    Conditions design constraints ( constraint Designer ):

    Fix: (Oracle) can not be corrected problems include PK Tables (7613)

    Automatically and perception ( autoComplete and IntelliSense ):

    Upd: support and improve the object list of keyboard operation processing including Escape , PageUp , PageDown , Home , EndAnd other buttons (7611)

    Generate scripts ( Generating Scripts ):

    the Add: (Firebird 3.0+) support EXTERNAL ROUTINES (PROCEDURE / FUNCTION / TRIGGER ) grammar generation (7611)

    Database Migration ( Database Migration ) (Pro):

    Upd: All updates are the same as dbMigration .NET software (7613)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

3rd party updates:

    move to new Delphi v10.4 Sydney compiler
    ship plink.exe v0.73 by installing HeidiSQL, so users don't have to download it
    use smaller libmariadb.dll v10.4.12 without debug symbols
    update VCL Styles Utils code
    Get latest bugfixes for VirtualTrees component
    Sync latest modifications from official SynEdit component sources

New features and enhancements in this version:

    code folding! (using #region and #endregion)
    introduce basic support for connecting to ProxySQL Admin servers, via new network type
    session paths and names in menus sorted alphabetically
    Add new "Query" main menu, and put most of the SQL relevant actions there, including a submenu with some new code folding actions. Closes #1132
    Issue #807: add SQL editor in "Find on server" dialog, to support complex comparisons e.g. on binary values without quotes "=0xaa00"
    Set "0" as default port for new MSSQL TCP/IP connections, enabling auto-detection
    Set SQL_NOTES to 0 in SQL export, to silence warnings due to unsupported "ALTER TABLE .. DISABLE/ENABLE KEYS" on InnoDB tables. Closes #756
    Sort collations alphabetically, in drop-down of column editor in table designer. Closes #828
    Allow free typing in collation drop-down for collations in a column. Set to empty string if user typed a non existent item. See https://www.heidisql.com/forum.php?t=37117
    Grid export: escape special characters in LaTeX output
    Wrap numeric values in LaTeX export with $. See https://www.heidisql.com/forum.php?t=36530
    Extract MySQL/MariaDB functions hints out of MariaDB 10.5 help tables
    Grid export: No longer force ANSI encoding for Excel output, but silently insert a BOM
    Issue #629: do not limit the second column in the query helpers box to a width of 100 pixels
    Provide UTC versions of most date/time menu items, in "Insert value" grid context menu. Closes #936
    Provide columns of selected table in completion proposal of query editors, but only if left side strings don't dictate a different table. Closes #9.
    use TComboboxEx for network types, with icons and ProxySQL sorted after the regular MySQL types
    Activate hoAutoResizeInclCaption option on all VirtualTree headers, so auto-resizing per double click takes the column captions into account. Closes #906
    Issue #957: give labels on preferences dialog more horizontal space, for longer translations, synchronize space over all tabs, and fix some tab orders
    Issue #957: give labels on session manager more horizontal space, for longer translations
    Issue #618: implement an owner-draw approach for column headers in data grid, and paint sort icons as text, including a superscript number of its index
    Convert TSynHotKey's to standard VCL THotKey's. And finally remove code extension in SynEditMiscClasses which I accidentally overwrote on updates several times.
    Issue #120: Allow unsupported ADODB providers per registry hack
    Play "Error" sound when executed file(s) had errors. See https://www.heidisql.com/forum.php?t=12800 . Also, cancel execution of further files when user presses the cancel button
    Add informative message in log panel after running SQL files, and play a short "OK" sound. This should probably be an "Error" sound when the file(s) had errors. See https://www.heidisql.com/forum.php?t=12800
    Show tree lines in database tree, which may be helpful for a better overview
    Issue #293: make warning threshold for number of grid rows customizable, in preferences dialog, on grid formatting tab
    Issue #293: prevent long sort operation on header click in large query results
    Remove nearly unused style packages, and keep the 9 used by more than 100 users last month. Reduces executable size by ~2.5M, and speeds up start up time significantly.
    Optimize SQL query in TDBConnection.GetTableForeignKeys. See https://www.heidisql.com/forum.php?t=36212
    Extend exception message with useful folder variable, in TAppSettings.PrepareRegistry, which I saw several times now in user reports, last time here: https://github.com/HeidiSQL/HeidiSQL/issues/1028#issuecomment-628131074

Bugfixes:

    MS SQL: Support UPDATEs and DELETEs with key column values containing international characters
    SSH tunnel: support very slow connections
    Prevent access violation in DBTree.GetImageIndex, with no connection on connection root node
    Format decimal point with milliseconds in date/time values in locale format for Excel
    fix endless recursion happening on some systems when starting HeidiSQL
    Overwrite data filter with newly generated one, by click on "Apply filter". Closes #829
    Limit number of rows per extended INSERT to 1000 in CSV import dialog. Closes #326
    Rename "IS NULL" and "IS NOT NULL" quick filter actions, so they don't prompt the user for an unused value. Closes #1065
    Issue #1081: apply quirk for missing IDENTIFIED BY PASSWORD clause to MySQL 5.7.6+ only (MariaDB still includes it). Will still be an issue for newer MySQL versions.
    Allow underscores in IP address wildcards of users, in conjunction with --skip-name-resolve on the server. Closes #1080
    Prefer ILIKE over LIKE operator on PostgreSQL servers, for auto-generated queries, to overcome errors with double columns. See https://www.heidisql.com/forum.php?t=36500
    Fix wrong row index used in TSQLiteQuery.Col and TSQLiteQuery.IsNull. Fixes loading more rows after first page on large SQLite tables. Closes #1053
    Leave numeric precision and scale away from DOUBLE column detection if either of them is empty. Closes #953
    Fix alias of PostgreSQL column type TIMESTAMPTZ with missing space. Closes #1071
    Use different sets of characters not requiring quotes, per connection type. Use that to force quotes around columns with uppercase characters in PostgreSQL. Closes #1072.
    Use ValidateNode to initialize all column nodes early, so they keep their FColumn data after click on Remove button. Closes #245
    Set minimum window height of session manager. Closes #1074
    Issue #444: get quick filter items in "More values" working again without crash
    Issue #338: reuse progress animation dialog when running multiple SQL files, and fix several focus stealing issues
    Fix non-ghosted icons in database tree, temporarily in VirtualTrees.Utils.pas. The right place for that fix would be in TVirtualImageList.DoDraw. Closes #1045
    Safety assignment for connection otherwise created by command line. See https://stackoverflow.com/questions/21168998/why-does-assigned-return-true-for-uninitialized-variables
    Try to disable styles for madExcept window. Related to #887
    Auto-reset style to default if selected one does not exist
    Cast relpages to bigint, preventing out-of-range SQL error in PostgreSQL. Closes #1038
    Issue #1028: Optimize unused code in TDBConnection.GetDbObjects away, which looked for cached object lists which specific OnlyNodeType property, which we don't cache anyway
    Issue #1028: Fix one-time recursion in TMySQLConnection.FetchDbObjects, caused by accessing InformationSchemaObjects, which in turn calls GetDBObjects and then again FetchDbObjects. More dramatically, this caused GetTableColumns to do an endless loop with two cache entries for "information_schema". This also fixes many of the v11.0 crashes in TAppSettings.PrepareRegistry, which were just a symptom of that endless loop. Thanks to als2020 on Github for pointing me in this direction.

[close]

http://www.heidisql.com/

[SiLæncer]

Whats new:>>

    When working with PostgreSQL, you can use the "ctid" pseudo columns instead of primary keys
    for row identification. See #36
    Under rare circumstances SQL statements were generated that could not be processed by older MS SQL database systems.
    This has been corrected.

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

    New features:

    Added support to download utility files at the client-side.
    Added support to rename query tool and debugger tabs title.
    Added support for dynamic tab size.
    Added tab title placeholder for Query Tool, View/Edit Data, and Debugger.
    Added support to compare schemas and databases in schema diff.

    Housekeeping:

    Issue #5938 - Documentation of Storage Manager.

    Bug fixes:

    Ensure that some fields should be disabled for the trigger in edit mode.
    Fixed an issue where the validation error message is shown twice.
    Ensure that non-superuser should be able to debug the function.
    Ensure that query history should be listed by date/time in descending order.
    Ensure that search object functionality works with case insensitive string.
    Fixed an issue where the suffix for Toast table size is not visible in the Statistics tab.
    Ensure that macros should be run on the older version of Safari and Chrome.
    Fixed an issue where a mismatch in the value of ‘Estimated row’ for functions.
    Added security related enhancements.
    Fixed an issue where non-closeable tabs are getting closed.
    Fixed an issue where a long file name is not visible on the process watcher dialog.
    Fixed an issue where connection to the server is on wait state if a different user is provided.
    Ensure that Grant Wizard should include foreign tables.

[close]

https://www.pgadmin.org/

[SiLæncer]

Whats new:>>

    When working with PostgreSQL, you can use the "ctid" pseudo columns instead of primary keys
    for row identification. See #36
    Under rare circumstances SQL statements were generated that could not be processed by Sybase database systems.
    This has been corrected.
    The performance of the working table scope "local database" was improved. Especially with embedded usage (API).
    If the subsetter is used via API, access to the working tables is synchronized
    so that different extraction models can be used concurrently.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

    SQL Editor:
        Folding support was improved and enabled by default
        Current/selected word highlighting support was improved
        SQL formatting was fixed for DDL queries (like CREATE TABLE)
        "Find in Google" command was added
        SQL-related preference pages were redesigned
        Parser of complex SQL blocks (e.g. PL/SQL) was significantly improved
        Problem with missing query results for some DDL queries was fixed
    Data editor:
        ROWID columns support was fixed
        Binary values copy-paste support was added
        Column auto-completion in the filter panel was fixed
    Data transfer:
        Automatic columns mapping added for CSV without header column
        Import from CSV/XLS: timezone parameter was added for date/time columns
        Export from SQL query with custom variables: UIX was improved
    Boolean value editor UI was changed (text instead of icons)
    User authentication UI was fixed when "Save password" option is off
    SSH: private key format transform was improved on Linux
    PostgreSQL:
        Arrays edit support was fixed
        Inet and other custom data types edit was fixed
        "Generate SQL" action for varchar arrays was fixed
        Create/alter trigger functions were fixed
        Partition create/drop/alter actions were added
    Hive:
        Indexes metadata read was added
        Index create/drop functions were added
        Column add/delete support was added
        Table rename support was added
    Oracle:
        Extra metadata read performance options were added
        Foreign key metadata read was fixed (ON DELETE rules)
        View DDL was fixed (column comments)
    Many other minor bugs were fixed

[close]

https://dbeaver.io/

[SiLæncer]

Whats new:>>

Bug fixes

    When visualization returns null (No results), then UI becomes broken (#13801)

https://www.metabase.com/

[SiLæncer]

Changelog

    Main program update ( Main ):

    Upd: Oracle component version is updated to Oracle.ManagedDataAccess.dll 19.10.0 (2020/11/17)(7629)
    Related updates retain Oracle 10 support without being affected (7629)
    Support Easy Connect Plus connection method and changes Latest connection settings (7629)
    Add: Add Norwegian Bokmaal language (by Edvind Håpnes) (7629)
    Add: (PostgreSQL 12+) Add JsonPath Type database type related processing (7629)
    Add:(PostgreSQL) Add Composite Types to UDDT custom types (7629)
    Fix: Improve interrupt handling capability, and fix (7613) The problem that automatic disconnection processing is not enabled (7629)
    Upd: (Firebird) When the embedded version component does not exist, The original settings will be reopened to facilitate the update (7629)
    Fix: (Oracle 10/11) Fix the problem that the initial default value of NUMBER exceeds the limit (7629)
    Fix: Solve the problem that the size cannot be set correctly when using third-party fonts (7629)
    Upd: PostgreSQL component version updated to Npgsql.dll 4.1.6 (2020/11/16)(7629)

    Upd: Others include cumulative minor updates, corrections and optimization processing (7629) -Data
    Browser and Editing (Data Browser and Editor ):

    Add: Support ExpandoObject data type analysis processing (7629)
    Fix: (PostgreSQL) Fix the problem that Composite Types data type cannot be displayed after (7592)
    Fix:(PostgreSQL) Corrected (7592) timestamp/timestamptz/tstzrange database type related processing (7629)
    Fix: (PostgreSQL) Corrected time/timetz database type related processing (7629)
    Upd: Added timetz and improved timestamptz database type analysis capabilities (7629)

    To generate script ( generating the scripts ):

    the Add: support sCRIPT AS ALTER grammar definition generating (7629)
    Fix: (Firebird) correcting (7613) lead to some type of information extra incorrect length is displayed (7629)
    Fix: (Firebird ) amended DBTRIGGERS generation problem stalled (7629)

    Data grid editor ( the cell editor ) / data grid browser ( the cell Viewer ):

    Fix: (PostgreSQL) correction (7592) after Json Jsonb data type can not be saved question / ( 7629)

    Data Export ( the data Export ):

    the Add:(csv / tsv / psv / ssv / sql) to increase the blank option trimmed end of the line data (Trim Spaces trailing from the Data Fields) (7629)

    SQL editor ( SQL Editor ):

    Fix: corrected text under the old version of the implementation of Oracle 10g plan ( Plain Execution plan ) issue (7629) can not be displayed
    Database migration ( database migration ) (Pro):
    Upd: all updates with dbMigration .NET software (7629)

[close]

http://fishcodelib.com/Database.htm