Thema: Datenbanksoftware und Tools diverses ...

[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

    Resultset search by Ctrl + F
    Resultset transposition
    Compare an query (diff) with clipboard by Ctrl + D
    Alt + Double Click in a resultset for drill-down by references
    Drag-n-drop into a tree to open db or import csv/sql file
    Improve text formatting (issues #101, #103)
    Improve Edit data dialog
    Help for pragmas
    Minor changes
    Fix bugs

[close]

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

[SiLæncer]

Whats new:>>

    Fix a case of the query planner be overly aggressive with optimizing automatic-index and Bloom-filter construction, using inappropriate ON clause terms to restrict the size of the automatic-index or Bloom filter, and resulting in missing rows in the output.
    Other minor patches. See the timeline for details.

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.

Freemium

Whats new:>>

    Added a possibility of exporting and importing the list of registered databases.
    Opportunity to create SQLite, Interbase, and Microsoft Access (.mdb) databases from GUI. [Enterprise edition]
    Minor changes and bug fixes.

http://www.vlsoftware.net/

[SiLæncer]

A database management application with support for MySQL, MS SQL and PostgreSQL, with a built-in query designer and a table and SQL editor.

MIT License

Changelog

    CHANGED: New app icon
    ADDED: SQL dump, SQL import - also from/to saved queries
    FIXED(mac): Fixed crash when reopening main window
    FIXED: MySQL dump now handles correctly dependand views
    FIXED(app): Browse tabs with Ctrl+Tab
    ADDED(app): Browse tabs in reverse order with Ctrl+Shift+Tab #245

[close]

https://github.com/dbgate/dbgate

[SiLæncer]

Free multi-platform database tool for developers, database administrators, analysts and all people who need to work with databases. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Apache Hive, Phoenix, Presto, etc.

Apache License 2.0

Changelog

    SQL editor:
        Problem with semicolon on a new line was fixed
        Problem with client-side commands parsing was fixed
        Error highlighting support was improved
        Tabs close/confirmation behavior was improved
        Script with multiple @set commands processing was fixed
        Command for data export automation was added (@export)
        Toggle comment command was fixed (thanks to @arvillion)
        SQL script datasource association command was fixed
    Data editor:
        Value filter now shows total number of distinct values
        Search for whole word was fixed
        Custom filter value save was fixed
    Spatial viewer:
        Ability to select spatial objects on map and data grid was added
        Default zoom level option was added
    Data transfer:
        Default data type mapping was improved (especially for char/varchar columns)
        Multi-table transfer now opens all target tables
        Database restore task now requires additional confirmation
        Output folder parameter now supports additional variables
        Import task UI was fixed (problem with lost target tables configuration)
        SQL export format now supports append mode
    Navigator: database selector popup was fixed (null pointer error)
    SSH: problem with connections and corrupted known_hosts file was resolved
    CLI: parameter “create” was fixed for connection opened using -con parameter
    Windows: DBeaver now supports workspaces on network paths (e.g. \network-shareworkspace)
    MacOS: problem with UI freeze after data edit was fixed
    DB2 i: keys and foreign keys metadata read was fixed
    MySQL:
        Generate SQL for geometry data types was fixed
        Permission editor was fixed (problem with duplicated permissions)
        Problem with decimal data types with zerofill flag was fixed
        UPDATE SET replace method was added
    Netezza: table rename SQL was fixed
    Oracle: table partition metadata read was fixed
    PostgreSQL:
        Problem with SQL generation and JSONB columns was fixed
        View column edit support was added
        Default driver version was changed to 42.2.25 due to security reasons
    SQLite: connection settings dialog UI was fixed (Open and Create buttons behavior)
    SQL Server:
        Money data type support was fixed
        Connection settings dialog was redesigned
    A lot of minor fixes in application localization

[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

Whats new:>>

    FlatLAF has been updated to version 2.2.
    Minor fixes.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

    Fix a byte-code problem in the Bloom filter pull-down optimization added by release 3.38.0 in which an error in the byte code causes the byte code engine to enter an infinite loop when the pull-down optimization encounters a NULL key.
    Other minor patches.

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

[SiLæncer]

Release Notes

Welcome to the release of phpMyAdmin version 5.2.0. This release contains many new features and quite a few bug fixes. We are simultaneously releasing phpMyAdmin 5.1.4, which is the last release of the 5.1 line and is mostly intended to help downstream packaging teams. Most users should migrate to 5.2.0.

Most notably, these releases resolve a networking error when exporting a file (https://github.com/phpmyadmin/phpmyadmin/issues/17445).

Some other highlights of 5.2.0 include:

    Removed support for Microsoft Internet Explorer
    Requires PHP 7.2 or newer
    Requires the openssl PHP extension
    Improved handling of system CA bundle and cacert.pem, falling back to Mozilla CA if needed
    Replace "master/slave" terms with "primary/replica"
    Add "NOT LIKE %...%" operator to Table search
    Add support for the Mroonga engine
    Add support for account locking
    Several fixes and improvements to the SQL parser library

There are, of course, many more fixes and new features that you can see in the ChangeLog file included with this release or online at https://demo.phpmyadmin.net/master-config/index.php?route=/changelog

[close]

https://www.phpmyadmin.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):

    Fix: (ODBC/OleDB) Allow database drivers to handle Quoted identifiers without quotes
    Fix: Connection provider (Provider) version detection, add password discrimination processing
    Fix: (MySQL) Fixed the problem that when the ROWS COUNT timed out, it could not continue processing
    Upd: (MySQL) Improve password expiration handling to simplify processing
    Upd: Execute an SQL script file: Added batch execution of Single INSERTs
    Upd: MySQL component version updated to MySql.Data.dll 8.0.29 (2022/04)()
    Upd: PostgreSQL component version updated to Npgsql.dll 5.0.13 (2022/04/27)()
    Upd: Others include cumulative minor updates, corrections and optimizations

    Object Explorer:

    Add: (PostgreSQL 14+) Support PROCRDURES 14 object parameter OUT related processing
    Upd: (PostgreSQL) Improve PROCRDURES/FUNCTIONS object parameters including IN/OUT/INOUT display
    Generating Scripts:

    Fix: (PostgreSQL) Fixed Script AS EXECUTE generated content

    SQL Profiler:

    Add: Session Mode adds support for MySQL 5.0 database

    Grant Manager and Security Manager:

    Add: (PostgreSQL 11+) support PROCRDURES object authorization processing

    Security Manager:

    Upd: (MySQL 5.7+) Improve user-defined syntax generation content

    SQL Editor:

    Add: Added shortcut keys to move line up/down (Move line up/down): Alt + Up/Down

    Command-line processing:

    Add: Support only connection parameters (Read-Only Mode: [-readonly])

    Filtering data of a column:

    Upd: resolve exception handling when field (or alias) does not exist

    Database Migration (Pro):

    Upd: All updates with dbMigration .NET software

[close]

http://fishcodelib.com/Database.htm

[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 #3253 - Added status bar to the Query Tool.
    Issue #3989 - Ensure that row numbers should be visible in view when scrolling horizontally.
    Issue #6830 - Relocate GIS Viewer Button to the Left Side of the Results Table.
    Issue #7179 - Added capability to deploy PostgreSQL servers on EDB BigAnimal.
    Issue #7282 - Added options ‘Ignore owner’ and ‘Ignore whitespace’ to the schema diff panel.
    Issue #7325 - Added support for Azure AD OAUTH2 authentication.

    Housekeeping:

    Issue #6131 - Port query tool to React.
    Issue #6746 - Improve the Kerberos Documentation.
    Issue #7255 - Ensure the database and schema restriction controls are not shown as a drop-down.
    Issue #7340 - Port data filter dialog to React.

    Bug fixes:

    Issue #6725 - Fixed an issue where the Query tool opens on minimum size if the user opens multiple query tool Window quickly.
    Issue #6958 - Only set permissions on the storage directory upon creation.
    Issue #7026 - Fixed an issue where the Browser panel is not completely viewable.
    Issue #7168 - Improvement to the Geometry Viewer popup to change the size of the result tables when column names are quite long.
    Issue #7187 - Fixed an issue where the downloaded ERD diagram was 0 bytes.
    Issue #7188 - Fixed an issue where the connection bar is not visible.
    Issue #7231 - Don’t strip binaries when packaging them in the server RPM as this might break cpython modules.
    Issue #7252 - Ensure that Columns should always be visible in the import/export dialog.
    Issue #7260 - Fixed an issue where an Empty message popup after running a query.
    Issue #7262 - Ensure that Autocomplete should work after changing the connection.
    Issue #7294 - Fixed an issue where the copy and paste row does not work if the first column contains no data.
    Issue #7296 - Ensure that after deleting multiple objects from the properties panel, the browser tree should be refreshed.
    Issue #7299 - Fixed sorting issue in the statistics panel.
    Issue #7305 - Fixed an issue where the Dashboard Server Activity was showing old queries as active.
    Issue #7307 - Fixed an issue where the table showed duplicate columns when creating multiple sequences on the same column.
    Issue #7308 - Ensure that sorting should be preserved on refresh for Server Activity.
    Issue #7322 - Fixed an issue while creating a new database throwing an error that failed to retrieve data.
    Issue #7333 - Fixed an issue where the drag and drop table in ERD throws an error.
    Issue #7339 - Ensure that the Dashboard column sort order should be remembered when the refresh button is clicked.

[close]

https://www.pgadmin.org/

[SiLæncer]

Whats new:>>

    Opportunity to create Firebird databases from GUI. [Enterprise edition]
    Added 'Use raw data' option for exporting data to HTML format. It lets you the opportunity to add your own formatting to the target document.
    New command line switch /UseRawData for exporting data to HTML format.
    Minor changes and bug fixes.

http://www.vlsoftware.net/

[SiLæncer]

Whats new:>>

    Update of the local H2 database to version 2.1.212.
    Single launch configuration for both tools.

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

    Docs - update login troubleshooting
    Show correct settings UI when MB_ENABLE_EMBEDDING env var specified
    Fix removing the field type in data reference
    Fix relative filters for non-english locale
    Update api docs
    Add permission change warnings
    Handle not available Notifications API
    Fix cancelling the native query via shortcut
    XLSX formatting for temporal breakout fields
    Updates docstring to correct formatting
    [E2E] Remove joins check from CCI
    Fix unescaped apostrophes in translated strings during .edn creation
    Remove misleading permissions tooltip
    Fix visualization and settings buttons are visible for questions that use blocked db
    Add a delay for showing tooltips for relative date filters
    Manual Backport: [E2E] Download permissions
    Fixes loading moment locale for zh locale
    Docs -fix missing link
    Use a different icon for tables on the homepage
    Fix pasting non-numeric values into numeric filters
    Make it possible to convert relative filters to expressions
    Fix toggle button alignment
    Extends ring.protocols/StreamableResponseBody to keywords
    Clear download perms when setting block perms
    Fix permission bugs
    Fix :Postgres :day-of-week extracts coming back as 0..6 instead of 1..7
    Pass parameter value to disabled TextWidget
    Add moderated_status icon to recents list
    Prevent channging visibility_type when updating table properties
    Fix issue with missing parameter options in cloned, targeted dashboard
    Backported "mbql.u/add-temporal-unit should ignore invalid units"
    Fix unneeded query nesting when removing all expressions
    Manual backport #22368
    Better logs for rotate encryption key + better command error messages…
    Bump snowplow-java-tracker
    Fix automagic dashboards for queries with source queries
    Fix redirects of group managers when they remove the last group they manage
    Fix invalid unit on dashboard relative date time filters
    Manual backport of
    Fix embedded dashboard is not being updated after changing params
    Manual backport of
    Fix a typo in the component name
    Turn on logging in quartz to watch for connection allocation
    Start task scheduler at end of startup.
    Clean up aggregation options getter
    Fix whitelabeled logo proportions
    Do not show restore sample database button to non-admins
    Upgrade Cypress to v9.6.1
    Backporting PR E2E Checks
    Don't reschedule syncs on startup
    Reduce sync query size for expedient amelioration of
    Record startup times
    Docs - updates api docs
    Repro #22700: Custom expression aggregation does not work in metrics
    Translations for x.43.1
    Fix inability to save to sub-collections when having no access to the parent
    Manual backport for No open redirects for enterprise SSO's
    Fix relative preview dates for past intervals
    Add nowrap to Cloud CTA link
    Fix smart scalar alignment
    Don’t enable Add Group button with string of white space as a group name
    Pass isNavBarOpen to BulkActionBar
    Tweak bulk action bar height
    Do not render value for null-related conditional formattings)
    URIDecode exported question filenames

[close]

https://www.metabase.com/

[SiLæncer]

Whats new:>>

    Pinned result sets
    Improve charts (issue #106)
    Up SQLite to 3.38.5
    Fix issues #104, #105, #107, #110, #111, #112, #114, #115

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

[SiLæncer]

Changelog

    Data editor:
        Numbers formatting: digit group size option was added
        Problem with unexpected change of timestamp values was fixed
        Smooth scrolling on MacOS was improved (thanks to @Andrew0002)
    Data transfer: XML format export was improved (encoding information)
    SQL editor:
        Results tab reuse behavior was fixed + new config option was added
        Result logging was added for script execute task (thanks to @avandorp)
        Redundant “Problems” view popup was removed
        Keywords highlighting was fixed (problem with identifiers which start with underscore)
    Diagrams:
        Connected entities highlighting was added
        Entities and columns search was improved
        New diagram routing was added
        Problem with unreadable comments was fixed (dark theme)
        Export in SVG and Graphml formats was improved
        Pseudo columns were removed from diagrams
        Diagram re-arrange was fixed
        Many minor bugs were fixed
    Connections:
        Creating connection from JDBC URL was improved
        Opening connection using CLI was improved (extra option -save was added)
    Preference pages: problem with small font size ws resolved
    Linux:
        Problem with workspace load was fixed on some
        Problem with UI freeze in connection type editor was fixed
    PostgreSQL:
        SSPI authentication support was added (problem with JNA library conflicts was resolved)
        Read-only connections support was improved (restrict of DML queries)
        Scheduled jobs management was added
    SQL Server:
        External tables metadata read was fixed
        NTLM authentication support was fixed
    Italian localization was improved (thanks to @andreagualandi)
    Chinese localization was improved (thanks to @bianyun1981)

[close]

https://dbeaver.io/