Thema: Datenbanksoftware und Tools diverses ...

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

    Table with multiple Entity Key columns incorrectly filtering on "Connected To" drill-through (#5648)

    Bug fixes:

    Tooltip shows incorrect values on unaggregated data with breakout (#15785)
    Can't use parentheses as expected in filter expressions (#15754)
    UI prevents adding 2 parameters to Percentile() function (#15714)
    Login logo is left-aligned on EE, when whitelabel features are enabled (#15713)
    No loading spinner when clicking a Collection on the home page (#15221)
    Tooltip on unaggregated data does not show summed value like the visualization (#11907)

[close]

https://www.metabase.com/

[SiLæncer]

Changelog

    Navigator:

        Database statistics in simple mode was fixed
        Legacy search icons were updated
        Legacy edit toolbar and main toolbar items was removed
        Columns reorder now supports multiple columns
        Object lookup function now supports search in comments
        DBeaver main menus are visible in DBeaver perspective only
 
    SQL editor:

        Collapsed results panel expand was fixed

    Data editor:

        Find/replace dialog was improved
        Virtual unique key create dialog was redesigned
        References panel was fixed for custom SQL queries

    SSH:

        SSH Agent support was fixed
        SSHJ extension install was fixed

    MySQL:

        Column editor was fixed (DEFAULT_GENERATED clause removed)
        Index editor was added

    PostgreSQL:

        Schema data types read was fixed
        Sequence editor was implemented
        Data type rename support was added

    SQL Server:

        Calculated columns support was added
        Extended properties were added to table DDL
        Default precision and scale for numeric data types was fixed
        View triggers support was added

    Oracle:

        Functions folder was added (in addition to Procedures)
        Jobs support was added (read-only)
        Data type compile action was fixed
        Synonyms read was fixed for partitioned tables
        Table triggers loading performance was improved
        Trigger disable/enable tool was added
        Procedure/function dependencies were added
        Comments for views and view columns were added
        Data type DDL was fixed for predefined types
    Redshift: problem with read-only resultset was fixed

    SAP HANA:

        Table columns was fixed for table names with special symbols
        Hex literal formatting was fixed
    Sybase IQ: SQL dialect support was improved
    Snowflake: drop procedure function was fixed
    DB2: stored procedures call generator was improved

    Vertica:

        Table column create/edit was fixed
        View constraints read was implemented
        Unique key creation was fixed
    DuckDB driver configuration was added
    RMI server waas fixed (no more public port listeners)

[close]

https://dbeaver.io/

[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

    Sessions can be restored from the history of recent sessions.
    The automatic initial naming of database connections has been greatly improved.

[close]

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

Inplace editors for PostgreSQL data types "hstore", "ghstore", "json", "jsonb" and "boolean".

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

Prevention of the "Streaming result set is still active." error with mysql.

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

    Add: Object [ Quick Filter / Auto-Complete ]: Contains DATABASE TRIGGERS object (7804)
    Upd: Improve the processing speed of obtaining the total number of table data rows (affects multiple functions) (7804)
    Upd: Servo version connection editor Number limit, increased to 512 characters (7804)

    Upd: Asynchronous Processing:

    Add:Support for asynchronous processing such as [Backup/Restore/Compression/Encryption] (7804)
    Upd: (SQLite) Improve the processing efficiency of file-related functions (7804)
    Upd: SQLite component version updated to System.Data.SQLite.DLL 1.0.114.0 ( 3.35.5) (2021/05/02) (7804)
    Upd: other minor updates contain accumulated, correction and optimization (7804)

    Comparative query ( comparison query ):

    Upd: Add the main label [repeat / compare / substituted] related function processing (7804)

    the script generator ( Script generator ):

    Upd: (the SQLite) supported omitted gENERATED ALWAYS calculated data fields generating process (7804) keyword
    Upd: (the SQLite) improved detection CHECK Constraints generation processing ( 7804)
    Upd: (SQLite) Remove the HIDDEN keyword when the data type is displayed (7804)

    Database Migration ( Database Migration ) (Pro):

    Upd: all updates with dbMigration .NET software (7804)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

    Navigator:

        Boolean properties editor behavior was redesigned
        Broken shortcuts (F2, F4, etc) in object editor were fixed
        Redundant help icons removed from standard dialogs
        Language change validation and documentation was added
        Quick filter now supports triggers

    SQL Editor:

        Auto-completion was fixed for table aliases, joins and asterisks
        Smart commit now ignores EXPLAIN statements
        Big updated row count (>2gb) support was added
        Output log enable/disable button was added

    Data editor:

        Selected rows highlight was fixed
        Bug with overlapping timestamp and FK values was fixed
        Find/replace dialog now respects number formatting
    ERD viewer: property view support was fixed, entity/attributes context menu was fixed

    PostgreSQL:

        Constraints and indexes support was added
        Problem with constantly growing search_path was fixed
        Fully-qualified table names in foreign keys DDL was fixed
        PGPASS authentication now can be used with empty user name
        NaN and Infinity numbers formatting was fixed
        Data transfer: ON DUPLICATE query generation was fixed
        Database size statistics was added (configurable, off by default)
        CREATE DOMAIN DDL was fixed
    DB2: BEGIN/END blocks support was added
    Greenplum: DDL for replicated tables was fixed

    Oracle:

        Procedure body formattign was fixed (for encoded procedures)
        Procedures/triggers/packages DDL statements processing was fixed
    Redshift: view columns metadata read was fixed, extra data type aliases were added

    Vertica:

        Table columns read was fixed for older Vertica versions
        Sequences support was added
    BigQuery driver version was upgraded
    Eclipse plugin: bug with redundant .dbeaver folders was fixed
    System notifications support was added on Linux
    Jar code sign certificate was updated
    Big number of minor bigfixes

[close]

https://dbeaver.io/

[SiLæncer]

Changelog

    Enhancements:

    Show right versions on enterprise custom builds (#15677)
    Not possible to select pinned collection item using checkbox (#15338)
    Collection tree loader causes UI jump (#14603)
    Need better instructions for setting up Google Auth (#9744)

    Bug fixes:

    Regression combining Druid date filters with dimension filters (#15903)
    Regression in filtering Druid table where greater than date (#15902)
    Variable Field Type after upgrade "Input to parse-value-to-field-type does not match schema" (#15901)
    Whitelabel favicon does not work correctly in all browsers (#15711)
    The new "contains" behavior for field value lookup doesn't work outside of dashboards (#15240)
    Cannot restore table visibility in Data Model, when database is down (#15165)
    LDAP user authorization failed with $ in password (#15145)
    Difficult to use some filters, when user has no data permissions [FE - Filter widget stops working if API endpoint returns 403] (#15119)
    Serialization: Dashboard cards are corrupted, when questions are outside of dashboard collection (#14912)
    Filters with dropdown lists uses query on the database (#13832)
    Login Failing for LDAP if user email isn't lowercase (#13739)
    Startup warning about unsupported class will impact performance (#13625)
    Auth Returns 400 Bad Request instead of 401 Unauthorized upon wrong credentials submission (#13140)

[close]

https://www.metabase.com/

[SiLæncer]

SQLite Database Browser is a freeware, public domain, open source visual tool used to create, design and edit database files compatible with SQLite. It is meant to be used for users and developers that want to create databases, edit and search data using a familiar spreadsheet-like interface, without the need to learn complicated SQL commands.

Changelog

    Fix saving the list of extensions in the Preferences dialog
    Corrected a typo in the French translation
    Updated the included SQLite and SQLCipher libraries to their latest release (SQLite 3.35.5, SQLCipher 4.4.3)
    Updated the “public” certificate, used for communicating with DBHub.io anonymously

[close]

http://sqlitebrowser.org/

[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

    "Save as" for database (issue #29)
    Line number in a status bar (issue #22)
    Line number in an error message (issue #23)
    Fix editor's bug in Win10 (issue #25)
    Fix issues: #18, #20, #21, #24, #26, #27, #28

[close]

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

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

    Issue #5954 - Added support to set auto width of columns by content size in the data output window.
    Issue #6158 - Added support to connect PostgreSQL servers via Kerberos authentication.
    Issue #6397 - Added “IF NOT EXISTS” clause while creating tables and partition tables which is convenient while using the ERD tool.

    Bug fixes:

    Issue #4436 - Fixed an issue where drag and drop object is not correct in codemirror for properties dialog.
    Issue #5477 - Added support for cache bust webpack chunk files.
    Issue #5555 - Fixed an issue where data is displayed in the wrong order when executing the query repeatedly.
    Issue #5776 - Ensure that while connecting to the server using SSPI login, it should not prompt for the password.
    Issue #6329 - Fixed an issue where the wrong SQL is showing for the child partition tables.
    Issue #6341 - Fixed an issue where CSV download quotes the numeric columns.
    Issue #6355 - Ensure that pgAdmin should not allow opening external files that are dragged into it.
    Issue #6377 - Fixed an issue where schema diff does not create DROP DEFAULT statement for columns.
    Issue #6385 - Ensure that Backup and Restore should work on shared servers.
    Issue #6392 - Fixed an issue where the filter ‘Include/Exclude By Selection’ not working for null values.
    Issue #6399 - Ensure that the user should not be able to add duplicate panels.
    Issue #6407 - Added support for the creation of Nested Table and Varying Array Type for Advanced Server.
    Issue #6408 - Fixed ModuleNotFoundError when running setup.py from outside of the root.
    Issue #6409 - Fixed an issue where the current debug line is not visible in the ‘Dark’ theme.
    Issue #6413 - Fixed an issue where duplicate columns are visible in the browser tree, which is owned by two sequences.
    Issue #6414 - Fixed an issue where the Help message not displaying correctly on Login/Group role.
    Issue #6416 - Added comment column in the properties panel for View and Materialized View collection node.
    Issue #6417 - Fixed an issue where query editor is not being closed if the user clicks on the ‘Don’t Save’ button.
    Issue #6420 - Ensure that pgAdmin4 shut down completely on the Quit command.
    Issue #6443 - Fixed an issue where file dialog showing incorrect files for the selected file types.
    Issue #6444 - Fixed an issue where the user is not warned if Kerberos ticket expiration is less than 30 min while initiating a global backup.
    Issue #6445 - Ensure that proper identification should be there when the server is connected using Kerberos or without Kerberos.

[close]

https://www.pgadmin.org/

[SiLæncer]

Whats new:>>

    An error in the autocompletion of "*" in "Insert into... Select..." statements has been corrected.
    Working with multiple browser windows has been made clearer.

http://jailer.sourceforge.net/

[SiLæncer]

ESEDatabaseView reads and displays the data stored inside Extensible Storage Engine (ESE) database (Also known as 'Jet Blue' or .edb file). It displays a list of all tables available in the opened database file, allows you to choose the desired table to view, and then when you choose a table, it displays all records found in the selected table.

ESEDatabaseView also allows you to easily choose one or more records, and then export them into comma-delimited/tab-delimited/html/xml file, or copy the records to the clipboard (Ctrl+C) and then paste them into Excel or other spreadsheet application.

License:    Freeware

Whats new: >>

    Updated to work properly in high DPI mode.
    Added secondary sorting support: You can now get a secondary sorting, by holding down the shift key while clicking the column header. Be aware that you only have to hold down the shift key when clicking the second/third/fourth column. To sort the first column you should not hold down the Shift key.
    Added option to change the sorting column from the menu (View -> Sort By). Like the column header click sorting, if you click again the same sorting menu item, it'll switch between ascending and descending order. Also, if you hold down the shift key while choosing the sort menu item, you'll get a secondary sorting.

http://www.nirsoft.net/utils/ese_database_view.html

[SiLæncer]

Changelog

    Connection Setting ( Connection Profile ):

    Add: (SQL Server / SQL Azure) support for the latest Azure Active Directory authentication Login methods (7814)
    new Directory contains the Active Interactive / Service Principal / Flow Device Code / Managed the Identity and other authentication
    Add:(SQL Server/SQL Azure) Add Active Directory Authentication drop-down option in the main interface (7814)-Main

    program update ( Main ):

    Add: (SQLite) Additional Commands ( Additional Commands ): Support loading application extension modules SELECT LOAD_EXTENSION(' filename ')(7814)
    Add: (SQLite) database tool supports loading application extension modules (Mainmenu -> Database Tools -> Extensions )(7814)
    Add: supports the latest PostgreSQL 14.0 beta1 database system (2021/05/20 )(7814) The
    update includes: (64bit) database backup/restore/object authorization management ( Grant Manager )... and other functions (7814)
    Upd: Update Database .NET Additional Files 64bit(2021/05/20)(7814)
    Update PostgreSQL 14.0 related components
    Add: (PostgreSQL) Added support for hstore and ghstore extended data types (7814)
    Upd: (PostgreSQL) Fixed structure description PUBLIC is the default search path (search_path)( 7814)
    Upd: (Firebird) Reserved Words (ReservedWords) are loaded according to different database versions (7814)
    Fix: Improve the processing when the last selected (database or structure description) of the load no longer exists (7814)
    Upd: Others include cumulative minor updates, corrections and optimization processing (7814)-SQL

    Editor ( SQL Editor ):

    Add: Code Folding: Add SELECT...FROM processing (7814)
    Add: Automatically summarize the same data of INSERT INTO table record processing, display and reduce unnecessary records (7814)

    the script generator ( Script generator ):

    Fix:Generation (SQL INSERTs) multiple choice items into a single file related bug fixes (7814)
    Upd: optimized instruction code generation processing speed and reduce the memory footprint (7814)

    - Database Migration ( Database Migration ) (Pro):

    Upd: All Updates with dbMigration .NET software (7814)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

+ Ctrl + / in Editor to comment/uncomment block (issue #33)
+ Shift + F3 in Editor to change text case
+ Ctrl + A/Backspace/Del in small inputs (issue #35, #36)
+ .set and .get commands in terminal
* Fix an error line number (issue #31)
* Fix save to file behaviour (issue #32, #34)
* Improve charts (issue #11)
* Fix bugs

[close]

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