Thema: Datenbanksoftware und Tools diverses ...

[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

- Data Browser ( Data Browser ):

   Upd: Optimize field data access processing, take up less resources and process faster (8184)

- Object Explorer :

   Fix: (SybaseASE) Fixed the problem of resetting the auto-increment column value when clearing the data table (8184)
   Add: (ODBC-Informix) Added support for SYNONYMS object display (8184)
   Upd: (ODBC/OleDB) The structure description name of PROCEDURES/FUNCTIONS adds recognition to PROCEDURE_OWNER (8184)
   Fix: (ODBC/OleDB) Fixed the problem that the FUNCTIONS object click to reorganize has no effect (8184)
   Fix: Corrected whether the database object is supported or not and divided into database migration ( Database Migration ) to avoid being affected (8184)

- Filtering Objects :

   Fix: Fixed an issue that may cause exceptions to occur when clicking the shift key while typing (8184)

- Data Import :

   Add: (SQL Server/SQL Azure/Sybase ASE/VistaDB/SQLCe) Support Preserve identity values ??option (8184)
   Upd: (SQL Server/SQL Azure/PostgreSQL/MySQL/SQLite) Import process unconstrained processing (8184)

- Data Export :

   Fix: Fix related processing when Preserve identity values ??is enabled (8184)

- SQL Profiler ( SQL Profiler ):

   Upd: Change to Asynchronous Processing (8184)
   Upd: Automatically exclude content with no returned value SQL Text (8184)

- Query Builder ( Query Builder )

   Fix: Fix and improve the Query Reverse Engineering ability (8184)

- Main program update ( Main ):

   Upd: Optimization and improvement of database access speed in related functions (8184)
   Upd: Others include cumulative minor updates, corrections and optimizations (8184)

- Database Migration (Pro):

   Upd: All updates with dbMigration .NET Software(8184)

[close]

http://fishcodelib.com/Database.htm

[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

Redesigned navigation and homepage, bookmarks, events and timelines, feature-level permissions, and more.

[close]

https://www.metabase.com/

[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 #7364 - Added the ability to resize columns on dashboard tables.

    Housekeeping:

    Issue #7283 - PG 15 compatibility issues fixed.
    Issue #7337 - Port connect server password dialog to React.

    Bug fixes:

    Issue #6962 - Fixed the browser tree overlapping nodes and expansion issue.
    Issue #7002 - Added the ability to detect and warn users about bidirectional Unicode characters.
    Issue #7347 - Ensure that when Authentication buttons are disabled their text is visible in the Dark and High contrast theme.
    Issue #7368 - Ensure that unwanted APIs should not be getting called for BigAnimal.
    Issue #7372 - Tell Docker to always pull the latest base images when building containers.
    Issue #7373 - Fixed an issue with geometry window zoom mouse scroll not working.
    Issue #7374 - Fixed an issue when switching between connections in the Query Tool dropdown, the background and foreground colors should be changed.
    Issue #7376 - Fixed an issue where a popup for unsaved changes appears when clicking on the open file button for a blank query editor.
    Issue #7380 - Added support for multi-cell selection in the query tool grid.
    Issue #7383 - Fixed an issue where Preferences are not saved when the dialog is maximized.
    Issue #7388 - Fixed an issue where an error message fills the entire window if the query is long.
    Issue #7393 - Ensure that the editor position should not get changed once it is opened.
    Issue #7394 - Fixed an issue where geometry is not visible when a single cell is selected.
    Issue #7399 - Added missing toggle case keyboard shortcuts to the query tool.
    Issue #7402 - Ensure that Dashboard graphs should be refreshed on changing the node from the browser tree.
    Issue #7403 - Fixed an issue where comments on domain constraints were not visible when selecting a domain node.
    Issue #7405 - Ensure that null values are accepted for the numeric columns in react-data-grid.
    Issue #7408 - Fixed an issue when a table has a column with an array type with length or precision, the column type is not selected while editing the table.

[close]

https://www.pgadmin.org/

[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

FIXED: Cannot use SSH Tunnel after update #291

[close]

https://github.com/dbgate/dbgate

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

Fixed bug with the 'Auto Detect 64-bit Date/Time Value' option: Some numeric values detected as date/time values.

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

[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

    General UI:
        Local timezone configuration was added in preferences
        Connection type color now affects SQL editor panels
        Tab selector (CTRL+E) now supports fast/fuzzy search
        Project rename now updates project name in all linked views
        Problem with navigator tree refresh was resolved
        Preference pages now respects font configuration
        Configuration popup positioning was fixed for low-res monitors
        Problem with embedded dropdown editors was resolved (MacOS)
        Problem with application start on some MacOS and Linux installations was fixed
        Read-only connections toggle was redesigned
        “Copy object name” action was added to tab context menu
    Data editor:
        Color by range now supports foreground color customization
        Problem with clob/json popup editors was resolved
        Epoch time transformer now supports 4 more modes (thanks to @nodaki)
        Grouping panel: problem with GROUP BY query generation was fixed for many analytical databases
        Date/time inline editor UI was improved (thanks to @PILINING)
    SQL editor:
        Right click on a script text now changes cursor position
        Part divider element visualization was improved
        Confirmation was added for “Delete this script” action
        Dangerous query execution confirmation configuration was fixed
    DB2: procedure name auto-completion was fixed
    HANA: procedures output parameters fetch was fixed
    Netezza: case-sensitive user names support was added
    Snowflake: database metadata read performance was significantly improved
    Teradata: SQL query limit (TOP) support was added
    Many minor UI bugfixes
    New database driver: Apache Kyuubi

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

    The location of the local database files is now configurable.
    This prevents disk space problems when there is not enough space available in the system's tmp directory.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

    CHANGED: Optimalization of loading DB structure for PostgreSQL, MySQL #273
    CHANGED: Upgraded mysql driver #293
    CHANGED: Better UX when defining SSH port #291
    ADDED: Database object menu from tab
    CHANGED: Ability to close file uploader
    FIXED: Correct handling of NUL values in update keys
    CHANGED: Upgraded MS SQL tedious driver
    ADDED: Change order of pinned tables & databases #227
    FIXED: #294 Statusbar doesn't match active tab
    CHANGED: Improved connection worklflow, disconnecting shws confirmations, when it leads to close any tabs
    ADDED: Configurable object actions #255
    ADDED: Multiple sort criteria #235
    ADDED(app): Open JSON file

[close]

https://github.com/dbgate/dbgate

[SiLæncer]

Whats new:>>

    The temporary files for the local database were not always cleared away in case of an error. This has been corrected.
    The dialog for database connection parameter entry has been improved.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

    ADDED: Visualisation geographics objects on map #288
    ADDED: Support for native SQL as default value inside yaml files #296
    FIXED: Postgres boolean columns don't filter correctly #298
    FIXED: Importing dbgate-api as NPM package now works correctly
    FIXED: Handle error when reading deleted archive

[close]

https://github.com/dbgate/dbgate

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

    Bump google oauth version (#23165)

    Bug fixes:

    Slack setup doesn't work if channels cache was recently cleared (#23251)
    Custom Expression field is not respecting the modal size (#23223)
    Relative filter with a lower "Starting from" period is confusing (#23099)
    Cannot print large dashboards (multi page) (#23098)
    Sync of JSON columns fails in schemas where schema names contains system characters (#23027)
    Sync of fields fails, when table name contains uppercase characters (#23026)
    Preview function in Notebook does not respect the columns selected on base source (#23023)
    Viewing Metadata for a Model and cancelling can result in error, and further in blank screen (#23022)
    Do not offer "Explore results" unless the database supports it (#22822)
    Cannot view Object Detail of non-numeric IDs (#22768)
    Click Behavior not redirecting in some cases (#22702)
    Uploading certificates causes failure in TrustManager/KeyManager because of bad MIME-type (#22626)
    New Slack App does not allow selecting private channels for pulses (#20867)
    Query executions hitting the cache are not recorded (#18777)
    Pulse fails when there is a column type time (#15146)

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

   Fix: Solve the compatibility problem of Windows 11 Build 25136+ latest version (8202)
   Upd: SQLite component version updated to System.Data.SQLite.DLL 1.0.116.0 (3.38.5) (2022/06/01)(8202)
   Upd: Others include cumulative minor updates, corrections and optimizations (8202)
- Query Builder ( Query Builder )
   Add: Added SQL Formatting formatting options (8202)
   Upd: Support Sort Type/Sort Order/Group By clear setting processing (8202)
   Upd: Improve the problem of displaying multiple links in the right-click menu of the data table at the same time (8202)
   Fix: Fixed and improved Query Reverse Engineering ability: no OUTER keyword processing (8202)

- Code Manager :

   Upd: Automatically preserve the original file encoding format (UTF8 with BOM/UTF8 without BOM/Unicode) (8202)

- SQL Editor ( SQL Editor ):

   Add: Add UTF8 with BOM/UTF8 without BOM option in Save As... (8202)

- IntelliSense Parameter Info :

   Fix: (64bit) Fixed and improved perception ability with structure description names (8202)

- AutoComplete and IntelliSense :

   Fix: Fixed and improved perception ability with structure descriptive names (8202)

- Object Authorization Management ( Grant Manager ):

   Add: (SQL Server/SQL Azure) support SYNONYMS object authorization processing (8202)

- Table Designer ( Table Designer ):

   Upd: (Firebird) Exclude database versions that do not support COLLATE (8202)

- Database Migration (Pro):

   Upd: All updates with dbMigration .NET Software(8202)

[close]

https://fishcodelib.com/Database.htm

[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

* Support scripting in terminal mode (issue #116)
* Fix crushes (issue #117)

[close]

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

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

Fixed: Viewing Views Issues

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

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

You can now set your own icon to display near every item instead of the default icon, by changing the ItemIcon line in the ESEDatabaseView.cfg file.
You can load icon from .ico file, .exe file, or .dll file. for .exe and .dll files, you can specify the icon index (positive number) or the icon ID (negative number)

Examples:

ItemIcon=shell32.dll,-151
ItemIcon=shell32.dll,3
ItemIcon=c:\windows\regedit.exe

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