Thema: Datenbanksoftware und Tools diverses ...

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

    The number of rows of a subject table to be exported can now be limited taking into account a possible column order.
    Nullable primary key columns could lead to incorrect results under certain circumstances.
    In the data browser, the user interface sometimes blocked when the acquisition of database metadata took a long time.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

    Active database/schema selector behavior was significantly improved

    Smart commit mode was enhanced:

    Switching to auto-commit after the end of transaction
    Smart commit for table editors
    Transactions preference page was added

    Data transfer:

    CSV export parameters (quote mode) were added
    Add/remove table to existing data transfer task was fixed

    SQL editor:

    “Select all rows” query generation was fixed
    Read data in console now uses correct default schema
    Exasol: metadata editor was significantly improved
    Neo4j: complex data types (structs/arrays) support was fixed
    Snowflake: index editor was fixed, view editor was fixed
    Greenplum 6.x: table DDL was fixed
    Oracle: PL/SQL parser was fixed (code blocks)
    A lot of minor bugfixes

    Data viewer:

    Show boolean values as checkboxes (configurable)
    Row colors customization was fixed

    Connection editor:

    Multiple connection editor dialogs can be opened now
    Extra variables were introduced, config UI was improved

    Apache Phoenix:

    Driver version was updated
    Schema-less tables read was fixed
    Index create support was added
    SQL autocomplete was fixed

    PostgreSQL:

    Backup for selected tables was fixed
    Execute script on the selected database was fixed

[close]

https://dbeaver.io/

[SiLæncer]

Database Browser is an easy to use tool allows you to connect to any database (Oracle, MS-SQL, MySQL, Firebird, etc) and browse or modify data, run sql scripts, export and print data.

Features

    * Works directly with Oracle, MS Sql Server, ODBC, MySql, PostgreSQL, Interbase and Firebird
    * Support for ODBC connection strings
    * Unlimited number of connections
    * One click switching from one connection to another
    * One click table browsing
    * Data browsing
    * Data exports into CSV, Excel, Html files
    * Execution history
    * SQL Builder with wide range of supported databases
    * Execution Log
    * Incremental Table Search

Whats new:>>

Added: Support for PostgreSql 12

http://www.etl-tools.com/database-editors/database-browser/overview.html

[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 #2554 - Added support for a multi-level partitioned table.
    Issue #3452 - Added a Schema Diff tool to compare two schemas and generate a diff script.
    Issue #4762 - Allow screen-reader to read label & description of non-textable elements.
    Issue #4763 - Allow screen-reader to identify the alert errors.
    Issue #4770 - Added labels and titles after parsing and validating all the pgAdmin4 web pages for accessibility.
    Issue #4993 - Set input controls as read-only instead of disabled will allow tab navigation in the properties tab and also allow screen readers to read it.

    Housekeeping:

    Issue #5049 - Improve code coverage and API test cases for the CAST module.
    Issue #5050 - Improve code coverage and API test cases for the LANGUAGE module.
    Issue #5071 - Improve the test framework to run for multiple classes defined in a single file.
    Issue #5072 - Updated wcDocker package which includes aria-label accessibility improvements.
    Issue #5096 - Replace node-sass with sass for SCSS compilation.

    Bug fixes:

    Issue #3812 - Ensure that path file name should not disappear when changing ext from the dropdown in file explorer dialog.
    Issue #4410 - Fixed an issue while editing char[] or character varying[] column from View/Edit data throwing an error.
    Issue #4511 - Fixed an issue where Grant wizard unable to handle multiple objects when the query string parameter exceeds its limit.
    Issue #4601 - Added tab navigation on close buttons for all the panels and create/properties dialog.
    Issue #4827 - Fix column resizable issue in the file explorer dialog.
    Issue #5000 - Logout the pgAdmin session when no user activity of mouse move, click or keypress.
    Issue #5025 - Fix an issue where setting STORAGE_DIR to empty should show all the volumes on Windows in server mode.
    Issue #5065 - Updated the incorrect icon used for the cast node on refresh.
    Issue #5066 - Fix an issue where refreshing a package results in the change in the object completely.
    Issue #5074 - Fix an issue where select, insert and update scripts on tables throwing an error.
    Issue #5076 - Ensure Postfix starts in the container, now it runs as non-root by default.
    Issue #5116 - Fixed an issue where Save Password control disappears after clicking on it while creating a server.

[close]

https://www.pgadmin.org/

[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

    Bug fixes:

    Fixed filtering on time fields in BigQuery (#11725)
    MongoDB single date/month field filters aren't working correctly (#11715)
    MongoDB single date field filters aren't working correctly (#11690)
    MongoDB Field filters variable in native query with nested fields not working (#11597)
    Native Query cannot be cancelled (#11713)
    Disappearing X-Axis in Scatter Plot (#11688)
    "Add to dashboard" popup shown when starting a new question (#11666) (#10672)
    Postgres "money" type breaks visualization (#11498)
    Postgres: Casting to Money is broken (#3754)
    Cannot click on some "Saved Questions" in personal collection (#11496)
    Diacritics in a user's name prevent a user's personal collection from being created via LDAP SSO (#10738)
    Text columns are converted aggressively to DateTime in charts (#11069)
    When report-timezone is set, Snowflake dates are returned from the day prior (#11036)
    Permission error messages are not showing (#10921)
    Don't abort on any 403 (#10816)
    Make MySQL metadata use utf8mb4 (#10691)
    Unexpected end of stream, read 0 bytes from 7 (#9885)
    Prefix "?" gets converted to "?" on save on RDS (#5192)

    Minor enhancements:

    We now log a warning when connecting to unsupported MySQL versions (#11767)
    We've updated the Google Analytics driver's Google dependency version (#11733)

[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 DATABASE TRIGGERS object browse / delete / enable / generate processing (7349)
    Support Firebird / SQL Server / SQL Azure / Oracle / NuoDB and other databases
    Upd: a large number of interface updates and optimizations (7349)
    Upd: Firebird component version updated to FirebirdSql.Data.FirebirdClient.dll 7.5.0.0 (2020/02/06) ( ) (7349)
    Upd: Others include cumulative minor updates, corrections and optimizations (7349)

    Data Browser and Editor :

    Upd: Results column display is faster and smoother (7349)
    Upd: Optimize the result column column width automatic scaling display processing (7349)
    Upd: Significantly improves processing speed when [Query and Result Columns] tab is closed (7349)

    Visual Execution Plan :

    Upd: Integrate the Plain Execution Plan into the tab page (7349)
    Supports SQL Server / SQL Azure / PostgreSQL / Oracle / HP Vertica and other databases
    Upd: Initially automatically selects the root node and displays the attribute content (7349)
    Fix: Improve and fix related issues when executing multiple statements (7349)

    AutoComplete :

    Fix: Quoted identifiers: Automatically exclude inline functions with @@ character at the beginning (7349)
    Upd: Improve the response speed of the object list window (7349)

    Connection Process Manager :

    Upd: Status column adds Last Updated time (7349)

[close]

http://fishcodelib.com/Database.htm

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

    Fixed a bug with exporting floating-point values to XLS format.
    Minor improvements in SQL editor. [Pro and Enterprise editions]

http://www.vlsoftware.net/

[SiLæncer]

Changelog

    Data viewer:

    Read-only columns UI was improved (icon + explanation were added)
    Filter text content assistant was significantly improved
    Row count calculation control UI ws fixed
    “Set default value” shortcut was changed
    Ordering in record mode was fixed
    Data change confirmation was fixed
    Plaintext presentation rendering was fixed (extra spaces)
    Numbers native representation mode (no client-side formatting) was added

    SQL editor:

    Export from query task was fixed
    Output tab now remains active after query execute
    Auto-commit toggle was fixed (rollback is performed on mode switch)
    Connection initialization was fixed (“Not connected to a database” bug)
    Column values assistance was added
    Numbers color and font was fixed

    ERD viewer:

    Entity/schema diagram “reset” action was added
    “Show views” option handle was fixed

    Connections and drivers:

    Variables support was improved (now all properties may contain variables)
    Maven artifact version resolution was fixed (null version bug)
    External drivers configuration support was added (see wiki)

    PostgreSQL:

    Query cancellation was fixed
    Hyperlinks and “Go to object” action were fixed (now they use current database instead of default one)
    Schema privileges were added in DDL
    Indexes read was fixed (redundant primary key constraint was removed)
    Arrays of domain types support was fixed
    Column copy-paste support was added

    MySQL:

    Identifiers redundant quotation was fixed
    Column copy-paste support was added

    Oracle:

    Default schema detection was fixed
    Double compilation of package was fixed
    PL/SQL parser was improved (case .. when .. end)
    DB2: alter column DDL was fixed (column modifiers were added)
    SQL Server: metadata search was fixed (wrong object types bug)
    AWS Athena: error position highlighting was added
    Sybase: legacy versions (12 and earlier) support was improved
    A lot of minor bugfixes

[close]

https://dbeaver.io/

[SiLæncer]

Whats new:>>

    Fixed "Syntax error creating tables in PostgreSQL" #27
    Modifications to the connection properties in the "Connection" dialog were sometimes retained after a "cancel".
    "About" dialog now also shows system properties.

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

    Fixed "Syntax error creating tables in PostgreSQL" https://github.com/Wisser/Jailer/issues/27
    Modifications to the connection properties in the "Connection" dialog were sometimes retained after a "cancel".
    "About" dialog now also shows system properties.

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

[SiLæncer]

Whats new:>>

    Fix: (Free / Plus) Solve the problem of abnormal handling of High DPI scaling under 32bit (7355)
    Upd: Others include cumulative minor updates, corrections and optimizations (7355)

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

    Tasks management: data transfer, backup-restore, SQL execution
    Git integration
    SSH agents and jump servers support
    And a lot of other great things

    Data viewer and data editor UI major improvements:

    GIS/geo-spatial viewer
    JSON viewer
    Logical columns, primary and foreign keys
    References panel
    Advanced row coloring

    SQL editor major improvements:

    Smart-commit mode
    Enhanced SQL parser and auto-complete proposals

[close]

https://dbeaver.io/

[SiLæncer]

Whats new:>>

    Fixed "Conditions with () have leading and trailing parans removed" #28
    Fetching results from MySQL/MariaDB is now based on a cursor. This prevents out-of-memory errors with large amounts of data.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

    Fixed "Conditions with () have leading and trailing parans removed" https://github.com/Wisser/Jailer/issues/28
    Fetching results from MySQL/MariaDB is now based on a cursor. This prevents out-of-memory errors with large amounts of data.

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

[SiLæncer]

Changelog

    Added Python 3.8 support.
    Added accessibility support in AlertifyJS.
    Added Czech language support.
    Improvements in the UI for both default and dark themes.
    Fix an issue where debugger not showing all arguments anymore after hitting SQL error while debugging.
    Ensure that all the transactions should be canceled before closing the connections when a server is disconnected using pgAdmin.
    Fixed Firefox monospaced issue by updating the font to the latest version.
    Improve the style of the highlighted code after query execution for Dark mode.
    Changed background pattern for geometry viewer to use #fff for all themes.

[close]

https://www.pgadmin.org/