Thema: Datenbanksoftware und Tools diverses ...

[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 #5468 - Added option to ignore the whitespaces while comparing objects in schema diff.
Issue #5500 - Added server group name while selecting servers in schema diff.
Issue #5516 - Added support of Row Security Policies.
Issue #5576 - Improve error messaging if the storage and log directories cannot be created.

Housekeeping

Issue #5325 - Improve code coverage and API test cases for Collations.
Issue #5574 - Cleanup Windows build scripts and ensure Windows x64 builds will work.
Issue #5581 - Documentation of Row Level Security Policies.

Bug fixes

Issue #3591 - Ensure that the query tool should display the proper error message while terminating the active session.
Issue #3669 - Ensure that proper error should be displayed for the deleted node.
Issue #3787 - Disabled the Stop process button after clicking it and added a message ‘Terminating the process…’ to notify the user.
Issue #4226 - Fixed an issue where select all checkbox only selects the first 50 tables.
Issue #5416 - Ensure that the query tool panel gets closed when clicking on the ‘Don’t Save’ button.
Issue #5465 - Fixed an issue where the Edge browser version is showing wrong and warning message gets displayed.
Issue #5492 - Fixed an issue where the search object is unable to locate inherited tables and constraint filters are not working.
Issue #5507 - Fixed connection and version number detection issue when the database server is upgraded.
Issue #5521 - Fixed an issue when dumping servers from a desktop pgAdmin app by providing an option ‘–sqlite-path’.
Issue #5539 - Fixed typo in exception keyword.
Issue #5584 - Fixed an issue where two identical tables showing different by schema diff tool.
Issue #5592 - Ensure that pgadmin should be able to connect to the server which has password more than 1000 characters.

[close]

https://www.pgadmin.org/

[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

-View and edit data column (Data Browser and Editor ):

   Add : Add display of the title prompt of the data row column ( Getting base table name and base column name )(7484) Exclusive Features : Through the prompt, you can understand the source [actual] table name and field name Add : Add data column field properties ( Column properties ) content display (7484) Upd:

Status bar increase SQL execution time (SQL Execution time) display (7484) Upd:

   When switching between different results tabs, the status bar performs time synchronization to update the display (7484)-SQL

History ( SQL History ):

   Add: supports the specified time or time range record (7484)
   Add: supports the specified database type or all databases type of record (7484)

- SQL editor ( SQL editor ):

   Upd: avoid recovery (undo) / redo (redo) generates an exception (7484)

- text of the implementation plan ( Plain execution plan ):

   the Add: increase in content search Function (Find: Ctrl + F ) (including Messages Tab) (7484)-Connection
Manager ( Connection Manager )
   Upd: The default is to process based on the access date, and the date format is modified to handle exceptions (7484)-Connection

process management ( Connection Process Manager ):

   Add : Add search function in the field ( Find In Grid ) (7484)

-Main program update ( Main ):

   Add: Increase the detection of the existence of the table structure description (Schema) (7484)
   Upd: Improve the case of different case when switching SCHEMA via SQL statement (7484)
   Upd: File Increase the prompt message when opening more than 10MB (7484)
   Upd: limit the display of the name of the tab page (<32) (including other related updates) (7484)
   Upd: update Database .NET Additional Files ( 32bit / 64bit ) (2020/06/ 26) (7484)
      Support the latest version database backup and restore from PostgreSQL (32bit/64bit) 9.3/9.4/9.5/9.6/10, (64bit) 11/12 and 13.0 beta 2
   Upd: Others include cumulative minor updates, corrections and optimization (7484)

- database migration ( database migration ) (Pro):

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

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Powerful and versatile relational database system that provides a variety of ANSI SQL standard features and cross-platform support.

License: GPL

Changelog

    Improvements:

    (CORE-6334) Added missing relocation support to MacOS builds.
    Implemented by A. Peshkov
    (CORE-6274) Increased parsing speed of long queries.
    Implemented by A. dos Santos Fernandes
    (CORE-6237) Improved performance when using SRP plugin.
    Implemented by A. Peshkov
    (CORE-4933) Added better transaction control to ISQL.
    Implemented by V. Khorsun

[close]

http://www.firebirdsql.org/en/start/

[SiLæncer]

Changelog

    Data Browser and Editor (Data Browser and Editor ):

    Add : The title of the data row column prompts to increase the base table and column display ( Getting base table name and base column name )(7484) Exclusive Features
    : Through prompt able to understand the source of [actual] the table name and column names
    Add: increase row Field Properties ( Column the Properties ) content is displayed (7484)
    Upd: Status column to increase SQL execution time (SQL Execution time) display (7484 )
    Upd: When switching between different results tabs, the status bar performs time synchronization update display (7484)-SQL

    history ( SQL History ):

    Add: supports the specified time or time range record (7484)
    Add: supports the specified database type or Records of all database types (7484)-SQL

    Editor ( SQL Editor ):

    Upd: Avoid Undo/Redo exception processing (7484)-Plain Execution Plan

    ( Plain Execution Plan ):

    Add: Added content search function (Find: Ctrl + F ) (including Messages Tab) (7484)-Connection
    Manager ( Connection Manager )
    Upd: Preset to change depending on the date of treatment access, and correct the date format exception handling (7484)

    connection process management ( Connection Process Manager ):

    the Add: increase Looking function (in the field in the Find an In Grid ) (7484)

    Main Program update ( Main ):

    Add: Increase the detection of the existence of the table structure description (Schema) (7484)
    Upd: Improve the case of different case when switching SCHEMA via SQL statement (7484)
    Upd: File open exceeds Increase the prompt message at 10MB (7484)
    Upd: Limit the display of the name of the tab page (<32) (including other related updates) (7484)
    Upd: Update Database .NET Additional Files ( 32bit / 64bit ) (2020/06/26) (7484)
    Support the latest version database backup and restore from PostgreSQL (32bit/64bit) 9.3/9.4/9.5/9.6/10, (64bit) 11/12 and 13.0 beta 2
    Upd: Others include cumulative minor updates, corrections and optimization processing (7484)

    Database Migration ( Database Migration ) (Pro):

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

[close]

http://fishcodelib.com/Database.htm

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

    Increased initial responsiveness of the Data Browser.
    Extensive internal redesigns since the last major release.

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

    Increased initial responsiveness of the Data Browser.
    Extensive internal redesigns since the last major release.

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

[SiLæncer]

Changelog

    Data viewer:

    Now we refresh entire row after cell value update (handy if you have triggers)
    Generate SQL context menu was fixed
    Horizontal scroll with mouse wheel support was added
    Export data in source code (PHP arrays) format was added
    Bug with Ctrl+Backspace handler was fixed

    SQL Editor:

    Query cancel handler was improved (problem with UI stuck was fixed)
    Now we show query information in the result tab tooltip
    Query parser was fixed (active query extraction for Ctrl+Enter action)
    Template variables (${word_selection} and ${line_selection}) support was fixed

    Navigator:

    Icons for “Create object” actions were fixed
    Main menu File items were reordered
    Heading and trailing spaces trim was added to all edit dialogs/panels
    Session manager: problem with multiple windows was fixed
    SQL Server: Database tools (index rebuild, triggers disable) were redesigned
    Firebird: new table and table column creation was fixed
    PostgreSQL: Table partition DDL was fixed
    MySQL: CHECK constraints edit support was added

    Oracle:

    Table statistics read was fixed
    Schema indexes folder was added
    Check constraints editor was added
    Trigger status icon was fixed
    Exasol: (thanks to @Sargul)
    Metadata read performance was improved
    Metadata search support was added
    Table references
    Index create DDL was fixed
    Table statistics read performance was improved
    Redshift: driver download was fixed
    SQreamDB driver was added
    YugabyteDB driver was added
    We upgraded Eclipse platform version to 2020-06. It affects dark theme and General preferences and fixes several minor bugs

[close]

https://dbeaver.io/

[SiLæncer]

Changelog

    Main Program Update ( Main ):

    the Add: (VistaDB) support VistaDB read-only mode ( the read-Only mode ) (7498)
    currently supports include SQLite / SQLCe / Access / Excel / dBase / Text / HP Vertica / MySQL / SQL Server / VistaDB and other database
    Upd : (VistaDB) database connection changed to (Non-exclusive) shared mode: Allow other applications to open in the same database (7498)
    Upd: (VistaDB) Improve VistaDB version detection processing (7498)
    Upd: IBM DB2/ Informix component version updated toIBM.Data.DB2.dll 9.7.4.4 (11.5.4000.4) (2020/06/30)(7498)
    Misc: (IBM DB2/Informix) IBM Data Server Client Packages Version 11.5 FP0 (2020/06/30)
    Upd: other includes the cumulative minor updates, fixes and optimization (7498)

    conditions design constraints ( constraint Designer ):

    Fix: corrected (7198) led to lower Firebird can not open this editing function (7498)

    row editing (the data editor ):

    Upd: (SQLite) to improve INTEGER + PRIMARY KEY (ROWID) is automatically incremented field update mode (7498)

    rows browsing and editing (the data browser and editor ):

    Fix: corrected (7484) led to the status column affected the initial display issues (7488)

    Object browser ( Object Explorer ):

    Upd:(VistaDB) Clear CHECK Constraint Name blank character processing (7498) -Generating Scripts

    ( Generating Scripts ):

    Fix: (VistaDB) Update Multiple Check Constraints generation method to solve the problem that the native cannot handle normally (7498)-Database

    migration ( Database Migration ) (Pro):

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

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

    Spatial presentation: tooltips rendering was fixed
    DB2: UI tools were converted into database tasks
    MySQL/MariaDB: database restore was fixed (binary data corruption)
    PostgreSQL: data type DDL was improved + comment edit support was added
    Oracle: problem with connect as SYSDBA was fixed
    Exasol: (thaks to @Sargul)
    Database error type discovery was added (proper handle of “connection lost” errors)
    Metadata read performance was improved
    Googlee Spanner: official driver configuration was added (thanks to @olavloite)
    Simple view mode was fixed (redundant database objects were hidden)
    Proxy configuration UI was fixed
    MacOS installer was fixed (potential vulnerability was removed, thanks to @De4dCr0w)
    Tasks management: error handing was improved (for deleted tables)
    We reverted to Eeclipse 2020-03 platform (it resolves a set of UI glitches on some platforms)
    A few minor UI and database-specific bugs were 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

    New features and improvements:

    SQL/native query snippets:

    You can now save bits of SQL or native queries and refer to them in your queries via a tag, like {{ snippet: My Great Snippet }}. Updating the definition of a snippet will update every query that uses that snippet. Just click the icon with the three lines in the native query editor to open up the SQL snippets sidebar. Any user with SQL editor permissions for at least one database can use, create, and edit snippets.

    Language selection:

    Instead of changing the language in the UI for each user based on their browser's language settings, Metabase now lets admins pick the language for the instance on the Localization tab of the Settings page in the Admin Panel. Users can also change their personal language preferences from their Account Settings page.

    Better value labels for line, area, bar, and combo charts:

    You can now turn on value labels for charts with multiple series, and selectively turn labels on or off for individual series.

    Reorderable table columns in the Data Model:

    You can now change the default order for table columns, and choose between database order, alphabetical, custom order, or the old "smart" ordering. You can also click and drag on columns to reorder them manually.

    A reorganized Data Model section:

    We've moved things around a bit in the Data Model section: there are now tabs at the top to see all of the Segments and Metrics you've defined across your whole instance, so you no longer need to drill down through your tables to find a Segment or Metric.

    Enhancements:

    Search: don't show inaccessible metrics & segments (#12916)
    Fix z-index for all auth wrappers (#12894)
    make jetty request header size configurable (#12683)
    Update data model nav (#12665)
    Improve error message when attempting to connect to Mongo with SSL (#12605)
    Don't complain about API endpoints/schemas missing docstrings when running linters (#12417)

    Bug fixes:

    :user-joined and :create-user activities not saved to activity log during setup (#12933)
    Error when updating Max Cache Entry Size: "Values greater than {1} are not allowed" (#12884)
    Sync not triggered for database added during setup (#12826)
    Download not working on revoking raw sql query access (#12745)
    Sync DB schema loses manual schema config (#12680)
    Can't create new Slack Metabot (#12678)
    Password reset doesn't work on low-resolution screens (#12658)
    Cannot start Metabase on Turkish language OS (#12623)
    Documentation links in app not correct (#12615)
    SQLite does not support Right or Full Outer joins (#12598)
    Sanitize field names better (#12592)
    Query fails on "Error reducing result rows" on cumulative aggregations with null-values (#12585)
    Can't use "Sum over time" or "Distribution" with nested question (#12568)
    Trend visualization fails, when results comes from cache (#12556)
    Column type of aggreated column in sql view is unkown (#12547)
    Creating a dashboard with a nested query Card can result in all dashboards being broken until hard refreshing (#12518)
    Homepage is missing sections (X-rays and Our data) after setup (#12510)
    viewing Card with another Card as source query gets stuck on loading spinner forever (#12501)
    Drill-through is broken on nested question on dashboard (#12455)
    Visualization type gets reset to "Table" (different scenarios) (#12361)
    Some users don't have permission to view query with a subquery, but can view the subquery directly (#12354)
    java.lang.ClassCastException: class java.time.Instant cannot be cast to class java.time.chrono.ChronoLocalDateTime (#12311)
    "Custom Column" with a / (slashes) in name will fail the query (#12305)
    Dashboard filter dropdown not working when linked to question joined table (#12250)

[close]

https://www.metabase.com/

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

Added 'Copy Clicked Cell' option to the right-click context menu, which copies to the clipboard the text of cell that you right-clicked with the mouse.

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

[SiLæncer]

Changelog

Support configuration files that are external to the application installation.
Added support for LDAP authentication with different DN by setting the dedicated user for the LDAP connection.
Added support for schema level restriction.
Added RLS Policy support in Schema Diff.
Added support for permissive/restricted policy type while creating RLS Policy.
Added support for LDAP anonymous binding.
Added High Contrast theme support.
Added missing dependencies/dependent and corrected some wrongly identified.
Replace the runtime themes with ones that don't have sizing issues.
Fixed tab indent issue on a selection of lines is deleting the content when 'use spaces == true' in the preferences.
Fixed CSRF errors when pgAdmin opened in an iframe on safari browser.

[close]

https://www.pgadmin.org/

[SiLæncer]

Changelog

    Bug fixes:

    Data Model Metrics shows error if using special combination of Custom Expressions (#13022)
    Dashboards with questions, that user doesn't haven't permissions to, breaks completely (#13005)
    Questions based on Saved Question joined with another Saved Question breaks Notebook (#13000)
    Field filters break SQL-type questions for Redshift data sources in v0.36.0 (#12984)
    Snowflake views stopped appearing (#12971)
    Can't use "Sum over time" or "Distribution" with nested question (#12568)
    Dashboard filter not working correctly when Field Type is Unix Timestamp (#12362)
    Filters are sometimes not applied when downloading data (#11557)
    Snowflake Tables Don't Show (#9511)
    "Custom Mapping" Display Value option is not available on tables with NULL entries (#8116)
    "Is empty" option filters out only NULL String (#5299)

[close]

https://www.metabase.com/

[SiLæncer]

Whats new:>>

    Bug fixes:

    Cannot setup new Metabase instance, when browser locale is different from available language (#13045)
    Cannot click some card titles on dashboard to go to question (#13042)

https://www.metabase.com/

[SiLæncer]

Changelog

    Database navigator:

    Connection status icons and tooltips were redesigned
    Icon decorations added for Git-integrated projects
    Navigator view options were added in the context menu
    Simple view support was improved (redundant objects removed from the navigator tree)
    Icons for “Create new objects” action were fixed

    Data editor:

    Unique key detection was fixed (for data editor)
    Advanced paste of multiple rows was fixed (redundant rows create was removed)
    Column filter dialog move/resize was fixed on Linux
    Grid data rendering performance was improved
    Auto-complete of column names was fixed in the filter panel

    SQL editor:

    Search/replace/undio/redo shortcuts were fixed in embedded editors (view/procedure sources)
    Parameter binding was fixed for multiple occurrences of the same parameter
    Smart commit mode behavior was fixed for PostgreSQL (post-error transaction recovery)
    Delete indent with single backspace was enabled by default
    Server log panel now works for data modification triggers
    Extract query from source code now shows notification popup
    Multiple queries execution is now allowed (in separate tabs)
    ERD editor: extra coloring was added for multi-schema diagrams

    Oracle:

    Metadata read performance was increased (Tables, materialized views)
    Columns and constraints were added in materialized view editor
    Numeric data type precision read was fixed
    Support of implicit cursors in query results was added
    View DDL reading was improved (view comments are included in DDL)

    PostgreSQL:

    Default schema detection and search_path overwrite was fixed
    Multi-dimension arrays support was added
    Table DDL for inherited tables was fixed

    MySQL:

    Active database change in read-only connections was fixed
    CHECK constraints support was added
    Table copy operation was fixed
    User password management was improved (to avoid FLUSH PRIVILEGES)

    Sybase:

    Support of text editing in views was added
    Schema indexes reading was fixed
    New table columns create was fixed
    CockroachDB: direct table data edit support was fixed
    HSQLDB: UUID data type support was added
    Query cancelling was improved (force cancel for hanging connections)
    Transaction isolation level settings save was fixed
    Error and debug logging was fixed
    A large number of minor UI improvements and bugfixes

[close]

https://dbeaver.io/