Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Changelog

    Informix: SQL error position detector was added
    Snowflake: active catalog/schema selector was fixed
    DB2 LUW: extra embedded routines support added
    Google Spanner driver configuration was updated
    MariaDB: TIME data type support was fixed
    Vertica: column comments read and update support was added
    Redshift: table permissions read in table DDL was fixed
    APM Jenifer driver configuration was added
    Automatic version upgrade: app restart procedure was improved
    Application icons were updated

    SQL Editor:

    Configuration of open editor action was added
    Smart auto-completion of column values was improved
    Problem with ambiguous column name resolution was fixed
    Hyperlinks detection was fixed
    Problems with SQL templates view freeze was fixed
    SQL formatter of case and conditional operators was improved
    Syntax highlighting for single and double quotes was fixed
    SQL folding state is now saved for each script
    Trim spaces command was added
    Problem with double save/commit confirmations was fixed

    Database navigator:

    Quick schema filter was fixed
    Metadata changes save: single transaction processing was improved
    Delete object(s) dialog UI was improved

    Data transfer:

    Export to flat files now supports columns configuration
    BOM support was added to CSV import

    Data viewer:

    BLOB viewer now respects content type of cell value
    Grouping panel: queries with trailing comment now handled properly
    Custom resultset ordering support was fixed

    PostgreSQL:

    Serial data types selector was fixed
    Column default value editor was fixed
    Numeric arrays rendering was fixed (number formatting removed)
    SAP HANA (thanks to @wernerdaehn):
    Smart completion was improved
    Public synonyms read was added
    Metadata object search was redesigned

    SQL Server:

    Default delimiter was changed to ; instead of GO
    Synonyms support was improved
    Check constraints added to table DDL
    Unicode string literals generation 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

    Enhancements:

    docs - add duplicate question section (#15421)
    docs - update search for 39 (#15419)
    Add an ENV var setting for typeahead search (#15379)
    Update MS SQL Server JDBC driver version (#15287)
    Fix Oracle SSL tests (#15260)
    Add missing "is" assertions to various tests (#15254)
    Custom Expression formula starts with high cursor placement on Firefox (#15245)
    Custom Expression filter not setting the "Done" button to current state of the formula until onblur (#15244)
    Only display schema in search results if there is more than one schema (#15230)
    Support string and number filter operators in dashboard parameter filters (#15055)
    Allow users to more easiy explore saved SQL results (#15010)
    defsetting macro throw an Exception if you try to define a setting that's already defined in a different namespace (#15000)
    Fix render error when removing a dashboard parameter (#14999)
    Upgrade HoneySQL version to latest (#14934)
    Dashboard Filter Improvements (to support large-scale rollout) (#14930)
    SSH Connectivity Improvements (#14929)
    MBQL Refactor: Combine various Field clauses into one new clause (#14897)
    Switch native query execution to use Statement instead of PreparedStatement (#14883)
    MongoDB shouldn't do an initial projection for :default date bucketing (#14838)
    Return richer API response for search (#14832)
    MongoDB & temporal filter query optimizations (#14829)
    Migrate Off Flow (#14802)
    Upgrade to React 16 (#14801)
    Semantic types pt 1 (special-type -> semantic-type rename) (#14780)

    Bug fixes:

    Hitting return when modifying a custom expression incorrectly discards changes (#15241)
    metabase/metabase-enterprise-head Docker image doesn't have enterprise extensions (#15226)
    Custom expressions: UI is too wide when shown in the sidebar (#15217)
    Search: some results are as being in a folder which doesn't exist in the data reference (#15216)
    Error saving metric in data reference (#15127)
    Negative filter can not be converted to custom expression (#14880)

[close]

https://www.metabase.com/

[SiLæncer]

This compact and minimalist Windows GUI for SQLite will enable its users to perform a wide range of database operations and processes.

License: GPLv2

Changelog

    Hold Ctrl to open database read-only
    Add conv(num, base_from, base_to) to ora-extension
    Fix issue #7: attached databases must use the same text encoding as main database
    Fix autostart of a transaction if an imported sql file has own transaction
    Fix the single table mode
    Fix the main toolbar color for non-classic Windows theme
    Fix an error on open non-SQLite file

[close]

https://github.com/little-brother/sqlite-gui

[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

Changelog

    Improved rendering quality on HiDPI environments.
    Many icons have been improved and increased in resolution.
    Mac keyboard shortcuts are now also used with Nimbus-LAF.
    The GUI has been simplified in some places and made clearer.

[close]

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

    Ctrl + Click to view a cell value in an query result
    XML-extension
    Fix minor bugs

https://github.com/little-brother/sqlite-gui

[SiLæncer]

Changelog

    Enhancements:

    Add feature flag for the new 0.39.0 dashboard filter types (#15488)
    docs - add duplicate question section (#15421)
    docs - update search for 39 (#15419)
    Add an ENV var setting for typeahead search (#15379)
    Add missing "is" assertions to various tests (#15254)
    Custom Expression formula starts with high cursor placement on Firefox (#15245)
    Custom Expression filter not setting the "Done" button to current state of the formula until onblur (#15244)
    Normalize queries in URL fragments on FE (#15079)
    Support string and number filter operators in dashboard parameter filters (#15055)
    Allow users to more easiy explore saved SQL results (#15010)
    defsetting macro throw an Exception if you try to define a setting that's already defined in a different namespace (#15000)
    Fix render error when removing a dashboard parameter (#14999)
    Upgrade HoneySQL version to latest (#14934)
    Dashboard Filter Improvements (to support large-scale rollout) (#14930)
    SSH Connectivity Improvements (#14929)
    MBQL Refactor: Combine various Field clauses into one new clause (#14897)
    MongoDB shouldn't do an initial projection for :default date bucketing (#14838)
    Return richer API response for search (#14832)
    MongoDB & temporal filter query optimizations (#14829)
    Migrate Off Flow (#14802)

    Bug fixes:

    Pulse fails when visualization_settings is referring to a field-literal column (#15475)
    Login History not recording correct IP address (#15437)
    Questions based on Saved Questions is not using the same query for date filters leading to wrong results (#15352)
    Hitting return when modifying a custom expression incorrectly discards changes (#15241)
    metabase/metabase-enterprise-head Docker image doesn't have enterprise extensions (#15226)
    Custom expressions: UI is too wide when shown in the sidebar (#15217)
    Search: some results are as being in a folder which doesn't exist in the data reference (#15216)
    Error saving metric in data reference (#15127)
    Negative filter can not be converted to custom expression (#14880)
    Don't show stacktrace to users during SAML/JWT login (#14820)

[close]

https://www.metabase.com/

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

    Add: Support Asynchronous Processing (7774)
    Misc: Initially search and browse the database in advance of [Native] and [Non-Native] Asynchronous Processing
    Add: Main Menu Tab Name (Tab Name): Support Click Swipe Middle mouse button to close the tab (7774)
    Upd: (MySQL) Remove the wrong connection attribute Allow Load Data Local Infile, and change it to the default enable processing (7774)
    Fix: Fix the problem that the current [database or structure description] is not restored after reconnecting without interrupting the connection (7774)
    Fix: (32bit) Fix (7761) the problem that the taskbar is displayed abnormally when the window is maximized (7774)
    Upd: PostgreSQL component version updated to Npgsql.dll 4.1.9 (2021/04/06)(7774)
    Upd: SQLite component version updated to System.Data.SQLite.DLL 1.0.114.0 (3.35.4) (2021/04/ 02)(7774)
    Upd: IBM DB2/Informix component version updated to IBM.Data.DB2.dll 9.7.4.4 (11.5.5010.4) (2021/04/01)(7774)
    Misc: (IBM DB2/Informix) IBM Data Server Client Packages Version 11.5 FP1 (2021/04/01)
    Upd: Others include cumulative minor updates, corrections and optimization processing (7774) -Data Browser
    Viewing and Editing (Data Browserand Editor ):

    The Add: upper left corner column shows the total number of fields (Total Columns count) and the total number of data (Total Rows count) (7774) column
    Upd: field tips ( Column Tips ) and the Field Properties ( Column the Properties ): Support Display of the same field name in different tables (7774)
    Upd: The data collection label of high memory consumption will be automatically closed after disconnection (7774)
    Fix: (PostgreSQL) Fix (7592) cause the object to return to the data collection display ( Displaying RefCursor) results ) function does not work (7774)-Data

    Editor Data Editor:

    Add: filter expression (Filter Expression) adds a key to clear (Clear) button processing (7774) -Search Table Data

    Search Table Data:

    Add:Add one-click Clear button processing to search conditions (7774) -Search Database Objects

    Search Database Objects:

    Upd: Improve the efficiency of script content search, cancel processing through the clipboard (7774)-Script Generator

    Script Generator:

    Upd: Improve the efficiency of generating script processing, cancel processing through the clipboard (7774)-Visual Execution Plan

    Visual Execution Plan:

    Fix: (HP Vertica 9.x+) Solve problems caused by the difference in the output format of the database version issue (7774) of the normal display

    Vertical label mode ( vertical Number of Tabs mode ) (64bit):

    Fix: corrected (7761) cause problems label search stalled (7774)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Explore the contents of SQLite databases right from Windows Explorer, with this integrated viewing solution that offers an information report.

Freeware

http://www.evilapp.com/product_pages/dbbrother.html

[SiLæncer]

Changelog

    Dark theme support was improved (Windows 10 and GTk)
    Metadata search now supports search in comments
    SQL Server: MFA (multi-factor authentication) support was added
    PostgreSQL: array data types read was fixed
    Oracle: indexes were added to table DDL
    Vertica: LIMIT clause support was improved
    Athena: extra AWS regions added to connection dialog
    Sybase IQ: server version detection was improved
    SAP ASE: user function loading was fixed
    Informix: cross-database metadata read was fixed
    We migrated to Eclipse 2021-03 platform

    Data viewer:

    Copy As: format configuration editor was added
    Extra configuration for filter dialog (performance)
    Sort by column as fixed (for small fetch sizes)
    Case-insensitive filters support was added
    Plaintext view now support top/bottom dividers
    Data editor was fixed (when column name conflicts with alias name)
    Duplicate row(s) command was fixed for multiple selected rows
    Edit sub-menu was returned to the context menu
    Columns auto-size configuration was added
    Dictionary viewer was fixed (for read-only connections)
    Current/selected row highlighting support was added (configurable)

    GIS/Spatial:

    Map position preserve after tiles change
    Support of geometries with Z and M coordinates was added
    Postgis: DDL for 3D geometry columns was fixed
    Presto + MySQL geometry type support was added
    BigQuery now supports spatial data viewer
    Binary geo json support was improved
    Geometry export was fixed (SRID parameter)
    Tiles definition editor was fixed (multi-line definitions + formatting)

    SQL editor:

    Auto-completion for objects names with spaces inside was fixed
    Database objects hyperlinks rendering was fixed

[close]

https://dbeaver.io/

[SiLæncer]

Whats new:>>

    Fix defects in the new ALTER TABLE DROP COLUMN feature that could corrupt the database file.
    Fix an obscure query optimizer problem that might cause an incorrect query result.

https://www.sqlite.org/index.html

[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 changes.
    Minor fixes.

http://www.vlsoftware.net/

[SiLæncer]

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

License: Open Source

Changelog

Housekeeping:

Issue #5319 - Improve code coverage and API test cases for Server module.

Bug fixes:

Issue #4001 - Updated docs and screenshots to cover the Notifications tab on the Query Tool.
Issue #5519 - Ensure that the query tool tab should be closed after server disconnection when auto-commit/auto-rollback is set to false.
Issue #5908 - Fixed an issue where shortcut keys are not working with manage macro.
Issue #6076 - Fixed an issue where correct error not thrown while importing servers and JSON file has incorrect/insufficient keys.
Issue #6082 - Ensure that the user should not be to change the connection when a long query is running.
Issue #6106 - Fixed flickering issue of the input box on check constraints.
Issue #6161 - Fixed an issue where the cursor shifts its focus to the wrong window for all the query tool related model dialogs.
Issue #6220 - Corrected the syntax for ‘CREATE TRIGGER’, use ‘EXECUTE FUNCTION’ instead of ‘EXECUTE PROCEDURE’ from v11 onwards.
Issue #6274 - Ensure that the strings in the LDAP auth module are translatable.
Issue #6293 - Fixed an issue where the procedure creation is failed when providing the Volatility option.
Issue #6306 - Fixed an issue while selecting the row which was deleted just before the selection operation.
Issue #6325 - Ensure that the file format for the storage manager should be ‘All files’ and for other dialogs, it should remember the last selected format.
Issue #6327 - Ensure that while comparing domains check function dependencies should be considered in schema diff.
Issue #6333 - Fixed sizing issue of help dialog for Query Tool and ERD Tool when open in the new browser tab.
Issue #6334 - Fixed SQL panel black screen issue when detaching it in runtime.
Issue #6338 - Added missing dependency ‘xdg-utils’ for the desktop packages in RPM and Debian.
Issue #6344 - Fixed cannot unpack non-iterable response object error when selecting any partition.
Issue #6356 - Mark the Apache HTTPD config file as such in the web DEB and RPM packages.
Issue #6367 - Fixed an issue where the Save button is enabled by default when open the table’s properties dialog on PG 9.5.
Issue #6375 - Fixed an issue where users are unable to see data of the partitions using the View/Edit data option.
Issue #6376 - Fixed an issue where a connection warning should be displayed on the user clicks on explain or explain analyze and the database server is disconnected from the browser tree.
Issue #6379 - Fixed an issue where foreign data wrapper properties are not visible if the host option contains two host addresses.
Issue #6385 - Ensure that Backup and Restore should work on shared servers.

[close]

https://www.pgadmin.org/

[SiLæncer]

Whats new:>>

    The detail view dialog has been made non-modal, allowing a smoother workflow.
    Rows can now also be edited via the detail view dialog.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

    Support of encrypted database using by SQLite3 Multiple Ciphers
    Ability to open in-memory database (issue #9)
    Fix extension functions: XML.xml_each and ora.strpart
    Fix insertion a number as numeric in a text column
    Fix quick references in a single table mode
    Up SQLite to 3.35.5

https://github.com/little-brother/sqlite-gui

[SiLæncer]

Changelog

    Main program update ( Main ):

    Upd: Asynchronous Processing (7774)
    Add: Support Asynchronous [Interrupt] Processing (7788)
    Add: Support Database [Connect] Asynchronous Processing (7788)
    Add: Support [ Intelligent Sensing Parameter Message ] Asynchronous processing (7788)
    Upd: Optimization and support for more [Query] and [Browse] Asynchronous processing (7788)
    Upd:Optimize and improve ODBC asynchronous processing (7788)
    Fix: (MySQL/Informix) Fix the problem of trying to switch connection after clicking to cancel the connection test (7788)
    Upd: Improve the display of different themes (Themes) HiDPI high zoom ratio (7788) )
    Upd: MySQL component version updated to MySql.Data.dll 8.0.24 (2021/03/25) ( )(7788)
    Upd: Others include cumulative minor updates, corrections and optimization processing (7788) -Data

    Column browsing and editing ( Data Browser and Editor ):

    Upd: (Oracle) Solve the problem that the timestampltz read speed is too slow (7788) -SQL Editor

    ( SQL Editor ):

    Upd: Automatically jump to the error column (or position): Contains annotations and variable processing issue (7788)

    Data import ( the data Import ):

    Upd: Modify seconds batch processing (Batch Seconds:> 2s to> 3s), automatic batch approval (7788) is exceeded

    Screening of field data ( Filtering Data of column A ):

    the Add: Support type field value IS [ NOT] NULL data screening process (7788)
    Upd: improved search input processing, while reducing the delay search problem (7788)

[close]

http://fishcodelib.com/Database.htm