Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

This visual designer will help you organize your data in an SQLite-type database, using diagram-style tools for creating and editing entries.

Donationware / GPLv3

Changelog

    New: Font Style
    New: Font Alignment
    Fixed: Font menu

[close]

https://github.com/emily-elizabeth/Database-Designer

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

    Upd: The exported field name will replace the actual field name BaseColumnName with the displayed field name ColumnName (8689)

    Connection Profile:

    Fix: (Firebird) Fixed the problem that the No Triggers setting has no effect (8689)

    Main program update ( Main ):

    Upd: Improve COMPUTED COLUMN syntax parsing capabilities (8689)
    Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 21.12.0 (2023/10/10)( )(8689)
    Update: PostgreSQL component version updated to Npgsql 7.0.5 (2023/09/15)( )(8689)
    Update: Others include cumulative minor updates, corrections and optimizations (8689)

    Database Migration ( Pro):

    Upd: All updates are the same as dbMigration .NET Software(8689)


35.5.8689.1

    Data Export:

    Upd: The exported field name will replace the actual field name BaseColumnName with the displayed field name ColumnName (8689)

    Connection Profile:

    Fix: (Firebird) Fixed the problem that the No Triggers setting has no effect (8689)

    Main program update ( Main ):

    Upd: Improve COMPUTED COLUMN syntax parsing capabilities (8689)
    Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 21.12.0 (2023/10/10)( )(8689)
    Update: PostgreSQL component version updated to Npgsql 7.0.5 (2023/09/15)( )(8689)
    Update: Others include cumulative minor updates, corrections and optimizations (8689)

    Database Migration ( Pro):

    Upd: All updates are the same as dbMigration .NET Software(8689)

[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 #640 - Add support for foreign table’s new functionality for PG 11 and above.
    Issue #6229 - Allow setting custom username for shared servers, with default as username of server being shared.
    Issue #6373 - Add ‘GENERATED ALWAYS AS..’ option while creating column constraints for Foreign Table.
    Issue #6797 - GUI representation of the system’s activity using the ‘system_stats’ extension.
    Issue #6802 - Added ‘load_balance_hosts’ connection string parameter for PG 16 and above.

    Housekeeping:

    Issue #6782 - Use PG16 as the default PostgreSQL version.

    Bug fixes:

    Issue #4995 - Fixed an issue in ERD tool where the downloaded images have a few links cut.
    Issue #5749 - Fixed an issue where user was not able to assign new/old columns as primary key once column with primary key is deleted.
    Issue #6285 - Add support for setting prepare threshold in server connection.
    Issue #6482 - Fixed an issue where the wrong message “Current database has been moved or renamed” is displayed when debugging any function.
    Issue #6538 - Fixed an issue where Processes tab displays wrong server name in some scenario.
    Issue #6579 - Fix an issue where global/native keyboard shortcuts are not working when any cell of data output grid has focus.
    Issue #6666 - Fixed query history slowness issue by storing query only for those having certain threshold max length.
    Issue #6674 - Fix an issue where foreign table column name becomes “none” if the user changes any column data type.
    Issue #6718 - Pin the cryptography version to fix PyO3 modules initialisation error.
    Issue #6790 - Ensure that the backup works properly for PG 16 on the latest docker image.
    Issue #6799 - Fixed an issue where the user is unable to select objects on the backup dialog due to tree flickering.
    Issue #6836 - Fixed an issue where non-super PostgreSQL users are not able to terminate their own connections from dashboard.
    Issue #6851 - Fix an issue where scale in columns is not allowed to have value as 0 or below.
    Issue #6858 - Fix an issue in graphical explain plan where query tool crashes when the plan has parallel workers details and sort node is clicked for details.
    Issue #6865 - Fix an issue where user login is not working if username/email contains single quote in server mode.

[close]

https://www.pgadmin.org/

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

An error in handling "like" conditions in the "Condition Editor" has been fixed

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

    Bug fixes:

Fix SQL autocomplete is hard to use because keywords are shown instead of tables and columns (#34601)
Replace java-time namespace with java-time.api (#34506)
Snowflake Database Setting allows you to input small caps role but breaks connection afterwards (used to work for both in 1.46. (#34829)
404 when downloading results on embedded questions on sub-paths (#34634)
Splitting multidimension questions that only have 1 metric (#34618)
The slack token is logged in plain text (#34616)
Event Icon for "Balloons" is a cake (#34581)
Pivot Table Viz shows different output and calls different endpoints when saved VS being created (#34278)
d is not a function after latest update to v0.47.0 when enabling Show values on data points (#33725)
View-only native SQL question should hide SQL when browser back button used (#32387)
Error occurs when performing "Join data" with fields containing "." character (#32182)
False "Cannot read properties" error appears sometimes when saving a question (#31766)
logarithm function calculates wrong result in BigQuery because parameters backwards (#31153)
Nested questions get confused around custom columns that are just columns (#28451)
Click Behavior on ranges always parses single-date to destination question's filters (#17879)

[close]

https://www.metabase.com/

[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

    Misc:

    we switched to Eclipse 2023-09

    Data editor:

    Excel (XLSX) export now supports columns auto-fit
    Copy from row bellow/above command was fixed
    Shortcut for “Got to column” column was changed to Ctrl+Shift+G

    SQL editor:

    Script statistics configuration was extended
    AI completion bugs were fixed and configuration UI was redesigned
    Tabs close in horizontal mode was fixed
    Script to connection association save was fixed

    Data export:

    Data import tasks wer fixed for schema-less databases
    Columns value transform expressions evaluation was fixed
    All data transfer were migrated to a new IO API
    Export functionality now can be disabled completely
    Tasks loading for missing database objects was fixed
    ER diagrams: one-to-one connections rendering was fixed

    General:

    Default file encoding was changed to UTF-8. IT affects all external tools integration.
    Web based authentication is now opened in external browser by default
    Version update functionality now can be disabled completely

    Databases:

    Clickhouse: map data type visualization was fixed
    Databricks: issue with national encodings was resolved

    Greenplum:

    Issue with case-sensitive table names was resolved
    FFL for function parameters was fixed
    MySQL: session manager now shows info from performance_schema
    OpenEdge: root catalog is now hidden; data export was fixed
    PostgreSQL: foreign key DDL was fixed (MATCH FULL)

[close]

https://dbeaver.io/

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

Minor interface improvements.

http://www.vlsoftware.net/

[SiLæncer]

Whats new:>>

    The "Desktop Overview" view has been improved.
    Workaround for issue "Popup is not closed on click outside of area controlled by XWayland".

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

    Bug fixes:

    Error: Field X is not present in the Query Processor Store. (#34950)
    Selecting filter on date, then going back and selecting expression results in error (#34794)
    Auto pivot is freezing query editor on high cardinality fields (#34677)
    JavaScript TypeError when removing dashboard filter (#33826)
    Can't go back with browser back button from "Table metadata" (#33784)
    Large column names should wrap in the sidebar (#31086)

https://www.metabase.com/

[SiLæncer]

Changelog

    Fix: Fix the problem that re-flash or re-execution causes loss of effect (8701)
- Object Browser ( Object Explorer ):
    Add: Data table Advanced browsing (Open->[ADV]) and advanced editing (Edit->[ADV]): Support canceling DESC field sorting (8701) - Search Table Data:
Fix : Correction
    ( 8656 ) causes advanced search exceptions (8701)
- Timer for Automatic Execution :
    Upd: Retain original search keyword highlighting when reloading (8701)
- Data Export :
    Upd: Export The field name will be displayed with the column name ColumnName instead of the actual field name BaseColumnName (8689)
- Connection Profile ( Connection Profile ):
    Fix: (Firebird) Fixed the problem that the No Triggers setting has no effect (8689)
- Main program update ( Main ):
    Upd: Improve the control item display problem in the Windows 7 operating environment (8701)
    Upd: Improve the COMPUTED COLUMN syntax parsing capability (8689)
    Upd: Update the SQL Server/SQL Azure component version to Microsoft.Data.SqlClient 5.1.2 (2023 / 10/27)( )(8701)
    Upd: The Oracle component version is updated to Oracle.ManagedDataAccess.dll 21.12.0 (2023/10/10)( )(8689)
    Upd: The PostgreSQL component version is updated to Npgsql 7.0.6 (2023/ 09/15)( )(8701)
    Upd: Others include cumulative minor updates, corrections and optimizations (8701)
- Database Migration ( Pro):
    Upd: All updates are the same as dbMigration .NET software (8701)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

    Fix: Correction (8701) The problem of missing dependent version numbers that have not been updated (8703)
    Upd: Others include cumulative minor updates , Correction and optimization (8703)

http://fishcodelib.com/Database.htm

[SiLæncer]

HeidiSQL lets you see and edit data and structures from computers running one of the database systems MariaDB, MySQL, Microsoft SQL, PostgreSQL and SQLite.

License: GPLv2

Changelog

3rd party updates:

    Update madExcept exception handler to v5.1.3
    Upgrading to Delphi compiler version 11.3
    Update VirtualTrees component code to release v7.6.5a
    Update vcl-styles-utils from current master branch
    Update SQLite libraries to v3.44.0
    Issue #1841: Update OpenSSL libraries used by libpq-15.dll to v3.1.3
    Update plink executables to v0.79

New stuff:

    Issue #861: New static row id column in all result grids. Uses the session background color, and can be hidden. (see screenshot)
    Issue #750: SQL formatting now with 2 new online formatters: (see screenshot)
        https://github.com/doctrine/sql-formatter - hosted on heidisql.com
        https://sqlformat.org/ - Thanks to Andi Albrecht!
    Add context menu on data grid header with "Query exact row count" item, querying SELECT COUNT(*)... on the underlying table
    Support main tabs in a single line, and support tab-scrolling per mouse wheel
    Issue #940: Support removing shortcuts per button in preferences. (see screenshot)
    Issue #1619: Use the same hotkey (Ctrl+S) for saving a table/trigger/... as for saving a query file.

Bugfixes and enhancements:

    Issue #1863: Fixes compatibility to Wine v8.18 again, and probably to more versions
    Grayscale icons on non-active tabs, for a clearer user interface (see screenshot)
    Separate double-click and middle-click options for closing tabs (see screenshot)
    Issue #1795: remove menu items and code for explain analyzer on https://mariadb.org, which is no longer available
    Issue #1854: fixes incorrect table name used in grid updates when comment with valid query exists
    Issue #279: Support serial columns in PosgreSQL, which is different from auto_increment on MySQL
    Issue #872: fix crash when opening a table with columns defined as INVISIBLE, and ensure such columns are selected and visible in the data grid
    Translation fixes: remove various unused strings, fix some wrong spelled strings, add some missing strings
    Issue #1850: too short text in popup text editor, when field contains high UTF-8 characters like emojis
    Add missing PMYSQL_LENGTHS type, and use this for the result of mysql_fetch_lengths(). Fixes an issue broken since 2009 (!)
    Issue #1640: Fix crash in MouseUp event of query tab close button, by closing/freeing the tab and button through a timer event
    Issue #752: Fix SQL export on MySQL 8, overwriting view helper tables caused "xyz is not view"
    Keyboard shortcuts: allow the user to accept duplicate assignments per ignore button. (see screenshot)
    Issue #1826: Fix ON UPDATE part of DEFAULT clause with no parentheses on MySQL 8, which are required only for the initial DEFAULT value.
    Fixes numerous different crashes, found in uploaded crash reports. Thanks to all users reporting these:
        Fix crash after following a foreign key value
        Fix sporadic crash "Cannot make a visible window modal" in search/replace dialog
        Fix crash in various places where we just try to get the current clipboard text
        CSV scanner: fix crash when selected filename cannot be opened
        Fix sporadic crashes in various calls to [TWinControl].SetFocus, with the new class helper .TrySetFocus
        Fix crash in highlighter customizer, as long as no attribute is selected
        Silence a popular crash in DBtreeFocusChanged, when trying to detect whether the user clicked into a different session
        Fix EAccessViolation in TMainForm.DBtreeFocusChanged:124
        Fix crash when trying to stop current query and the helper connection cannot connect for some reason.
        Silence sporadic EAccessViolation in DBtreeBeforeCellPaint, when reading DbObj.Connection.Parameters
        Fix EAccessViolation in TDBObject.GetImageIndex:6
        Fix EAccessViolation in TMainForm.DBtreeGetText:12
        Catch different EInOutError exception happening in rare cases of ForceDirectories()
        Fix EAccessViolation in TMainForm.AnyGridGetText:5
        Fix crash when user clicks Help button on maintenance dialog, in a non-MySQL session
        Catch additional EReadError crash in RunQueryFile
        Fix crash in printer dialog, when printer is somehow not available
        Fix crash after reconnect, when query helpers functions are exapanded
        MSSQL: Catch OLE exception when provider names cannot be listed
        Fix crash in TMainForm.DBtreeGetText happening while connecting through SSH tunnel
        Fix sporadic crash with focused Host tab while connecting to another session
        Warn the user about potential data loss when loading a (csv) file with encoding set to "auto-detect".

[close]

https://www.heidisql.com/

[SiLæncer]

Changelog

    SQL editor:

    Code completion for update statements was added
    Smart completion and replacements of quoted expressions was fixed
    Redundant errors on opening SQL Editor for the first time were removed from the logs

    Database Navigator:

    Filtered objects visualization was added
    Script folder opening was fixed

    Data transfer:

    Attributes names for quoted attributes are handled correctly
    “Copy as HTML” result presentation is improved

    Data editor:

    Background color reset was fixed
    Message about content representation size limit was fixed
    App freeze in binary editor was fixed (MacOS)
    ER diagrams: one-to-one connection rendering was fixed

    Connections:

    SSH connection page validation is enhanced for jump servers
    Complex JDBC driver support was improved (context classloader + driver cache)

    General:

    Script names are sorted alphabetically
    Refresh button was added to the “Generate DDL” dialog
    Issue with app launch was fixed (rare case)

    Databases:

    Oracle: search package bodies as packages was supported

    PostgreSQL:

    Default privileges presentation and editing was supported
    Sequences permissions reading for quoted roles was fixed
    SQLite: required columns creating was fixed

[close]

https://dbeaver.io/

[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

Whats new:>>

    Improve autocomplete
    Ctrl + Mouse wheel to change font size
    Duplicate table data
    Up SQLite to 3.44.0
    Minor changes (inc. issue #148)

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

[SiLæncer]

Changelog

    Bug fixes:

    Disable auto-commit (enable transactions) for read-only connections (#35268)
    Adding check for column before getting friendly name (#34761)
    Support subtracting intervals (#23423)
    Graphing chart with date filter at 24 months is broken (#35129)
    Serialization v2 export doesn't include parameter_card entity_ids which breaks the import (#35097)
    Dashboard reversion should skip cards that have been deleted or archived (#34884)
    Serialization v2 duplicates entities loaded with serialization v1 on old versions (#34871)
    Dashboard filter Apply button does not follow column structure and shows up to right of other elements instead of below them (#34385)
    MBQL v1 query breaks with boolean breakout (#34286)
    Inconsistent display of numbers in Arabic locales (#34271)
    Incorrect dialect is chosen for ClickHouse pretty SQL formatting (#34235)
    Bar Chart visualization settings show an error and do not allow changes to be made (#33936)
    Question in table view: Removing a field rearranges the entire table columns (#33348)
    The title of the pdf exported by the dashboard is garbled in Chinese (#33121)
    Custom expression that has a name consisting only of whitespace breaks the question (#32571)
    New custom columns won't appear in a dashboard card with reordered columns (custom viz settings) (#25592)
    Scrolling doesn't update dragging on Visible Column configuration (#14238)

[close]

https://www.metabase.com/