Thema: Datenbanksoftware und Tools diverses ...

[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: Fixed some problems with SSH tunnel (upgraded SSH client) #315
    FIXED: Fixed MognoDB executing find query #312
    ADDED: Interval filters for date/time columns #311
    ADDED: Ability to clone rows #309
    ADDED: connecting option Trust server certificate for SQL Server #305
    ADDED: Autorefresh, reload table every x second #303
    FIXED(app): Changing editor theme and font size in Editor Themes #300

[close]

https://github.com/dbgate/dbgate

[SiLæncer]

Whats new:>>

    ADDED: SQL Server - support using domain logins under Linux and Mac #305
    ADDED: Permissions for connections #318
    ADDED: Ability to change editor front #308
    ADDED: Custom expression in query designer #306
    ADDED: OR conditions in query designer #321
    ADDED: Ability to configure settings view environment variables #304

https://github.com/dbgate/dbgate

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

    Fixed a bug when exporting data to database with Append+Update export mode and Batch mode combined.
    Minor interface changes and bug fixes.

http://www.vlsoftware.net/

[SiLæncer]

Whats new:>>

    Fix a performance regression in the query planner associated with rearranging the order of FROM clause terms in the presences of a LEFT JOIN.
    Apply fixes for CVE-2022-35737, Chromium bugs 1343348 and 1345947, forum post 3607259d3c, and other minor problems discovered by internal testing.

https://www.sqlite.org/index.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

    SQL editor:

    Autocomplete of variables with prefix @ was fixed
    Problem with columns aliases in grouping panel was resolved
    SQL console text now can be saved as project script

    Data editor:

    Collection string representation was improved
    Problem with data read performance was fixed

    Data transfer:

    Target table properties (such as engine, charset, etc) were added in import wizard
    CSV import was fixed for files with invalid value quotation
    Import from string to geometry columns was fixed
    Issue in full text search wizard (NullPointer) was resolved
    General UI: tab quick search was improved (find by substring, fuzzy search)
    Connections: multiple connection mode was disabled for non-relational databases
    Azure SQL: driver version was upgraded, problem with auth token refresh was resolved

    Clickhouse:

    Table engine and engine parameters (editable) were added to table properties
    View code editor was fixed
    DB2: dependent views can be excluded from table DDL

    Oracle:

    DDL tab was added tp scheduler jobs
    New table column properties was fixed
    Issue with Debian installer was resolved (configuration files mark removed)

[close]

https://dbeaver.io/

[SiLæncer]

Whats new:>>

    FIXED: Fixed problem with SSE events on web version
    ADDED: Added menu command "New query designer"
    ADDED: Added menu command "New ER diagram"

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:

    Bulk Filter Modal v3 (#23911)
    Add snowplow tracking for new records on TaskHistory (#23893)
    New date filter widget, "is empty" is under the "Exclude" section but is used for inclusion (#23677)
    [Epic] Reconsider how we email new users when SSO is active (#23630)
    [Epic] Better communicate embedding options in Admin settings (#23498)

    Bug fixes:

    Archive page does not render all items (#24213)
    Revert buttons shown on dashboard revision history for users without edit permissions (#24210)
    Search returns irrelevant matches for non-native questions (#24132)
    Can't embed cards with filters after v0.44.0-RC1 - Invalid Parameters: "missing id" (#24103)
    Exports fail on specific date styles (#23980)
    Bubble size is scaling according to y-axis on scatter charts (#23977)
    Error sending emails when reply-to setting contains empty string (#23940)
    Email settings needs to use real password, not obfuscated password (#23919)
    Wrong username/password on Office365 for email settings has misleading error (#23918)
    Missing full-screen button on public dashboards (#23811)
    Primary color is not being used on background colors, so branding is not kept consistent (#23777)
    Full Screen Night Mode Dashboard Has light background when scrolled down (#23766)
    Dark primary color in data visualization makes icons almost disappear. (#23759)
    Primary color in text with dark backgrounds makes text hard to read (#23751)
    Relative Date filters on dashboard does not include the filter on drill-through (#23748)
    Dashboard causes scrollbars to constantly go on/off depending on viewport size (#23695)
    Items in the saved question picker are sorted case-sensitive (#23693)
    Sandboxed group managers can't see other users in the People tab (#23689)
    Dashboard parameter widget connected to template tag clears value after a few seconds (#23640)
    Token check error floods the logs when there's no internet connection (#23588)
    Data point value style missing stroke, which makes it hard to read sometimes (#23529)
    Arbitrary recipient's email addresses are shown as empty values (#23527)
    Data reference in SQL editor does not list the correct tables if accessed directly (#23510)
    Models should not allow variables (#23505)
    Viewing archived questions causes bad error (#23501)

[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 #4488 - Added option to trigger autocomplete on key press in the query tool.
    Issue #4607 - Allow users to delete files/folders from the storage manager.
    Issue #7389 - Allow users to search within the file/storage manager.
    Issue #7486 - Added support for visualizing the graphs using Stacked Line, Bar, and Stacked Bar charts in the query tool.
    Issue #7487 - Added support for visualise the graph using a Pie chart in the query tool.

    Housekeeping:

    Issue #7313 - Port the file/storage manager to React.
    Issue #7341 - Port change password dialog to React.
    Issue #7342 - Port Master Password dialog to React.
    Issue #7492 - Removing dynamic module loading and replacing it with static loading.
    Issue #7546 - Port named restore point dialog to React.

    Bug fixes:

    Issue #7428 - Preserve the settings set by the user in the import/export data dialog.
    Issue #7471 - Ensure that the splash screen can be moved.
    Issue #7508 - Fixed an issue where comments on indexes are not displayed.
    Issue #7512 - Ensure that notices should not disappear from the messages tab.
    Issue #7517 - Enable the start debugging button once execution is completed.
    Issue #7518 - Ensure that dashboard graph API is not called after the panel has been closed.
    Issue #7519 - Ensure that geometry should be shown for all the selected cells.
    Issue #7520 - Fixed the JSON editor issue of hiding the first record.
    Issue #7522 - Added support for Azure PostgreSQL deployment in server mode.
    Issue #7523 - Fixed typo error for Statistics on the table header.
    Issue #7524 - Fixed an issue where new folders cannot be created in the save dialog.

[close]

https://www.pgadmin.org/

[SiLæncer]

Whats new:>>

    Bug fixes:

    Set a timeout for isValidTimeout.

https://www.metabase.com/

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

* Pinned tables and views
* Up SQLite to 3.39.2
* Minor changes (issues: #120, #121, #124)

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

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

    Upd: Update Office Access compatibility detection, support ClickToRun Installation version:
    Affects include: (Access) text execution plan, (Text) delimited text file custom extension file name...etc.
    Upd: (MySQL) SSL Mode added to VerifyCA/VerifyFull Support (8249)
    Upd: (MySQL) Automatically configure max_allowed_packet with a minimum size of 16M (8249)
    Upd: (MySQL) Backup and restore default default-character-set taken from the server side utf8 (mb3/mb4) encoding (8249)
    Upd: Update MySQL component version to MySql.Data.dll 8.0.30 (2022/07/26)( )(8249)
    Upd: Update Firebird component version to FirebirdSql.Data.FirebirdClient 9.0.2.0 (2022/07/12)( )(8249)
    Upd: Update the PostgreSQL component version to Npgsql.dll 6.0.5 (2022/06/19)( )(8249)
    Upd: Others include cumulative minor updates, corrections and optimizations (8249)
    Query Design Tool ( Query Builder )
    Fix: Fixed and improved Query Reverse Engineering (8249)

    Plain Execution Plan :

    Fix:(Access) Fixed the initial problem that the ACE/OLEDB Provider could not be executed normally (8249)

    Visual Execution Plan :

    Fix: Fixed the syntax highlighting problem of Plain Execution Plan in Professional Edition (8249)

    Generated Generating Scripts :

    Fix: (MySQL 8/MariaDB) Generate CHECK CONSTRAINTS object syntax definition separately, remove exception characters (8249) -

    Connection Profile :

    Upd: Clear dozens of multiple databases Useless connection properties to simplify setup (8249)

    Database Migration (Pro):

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

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

    Enhancements:

    Bump jetty-server to 9.4.48.v20220622 (#24482)
    Bulk Filter Modal v3 (#23911)
    Add snowplow tracking for new records on TaskHistory (#23893)
    New date filter widget, "is empty" is under the "Eclude" section but is used for inclusion (#23677)

    Bug fies:

    Click behavior to another dashboard/question makes the browser open the destination on a new window (#24451)
    False warning that No self-service means higher access than Block permissions (#24380)
    Bookmark icon not updated when question is converted to model and vice-versa (#24375)
    Default /api/collection/tree call does not include "eclude-archived=true" (#24329)
    Archive page does not render all items (#24213)
    Revert buttons shown on dashboard revision history for users without edit permissions (#24210)
    Search returns irrelevant matches for non-native questions (#24132)
    Can't embed cards with filters after v0.44.0-RC1 - Invalid Parameters: "missing id" (#24103)
    CASE statements don't evaluate to False if using , False and nested CASE statements (#24100)
    "Custom..." model refresh setting does not work on first request (#24053)
    "Our analytics" appears on "Save question" collection search header even when user doesn't have access to it (#23981)
    Eports fail on specific date styles (#23980)
    Bubble size is scaling according to y-ais on scatter charts (#23977)
    Error sending emails when reply-to setting contains empty string (#23940)
    Email settings needs to use real password, not obfuscated password (#23919)
    Wrong username/password on Office365 for email settings has misleading error (#23918)
    Missing full-screen button on public dashboards (#23811)
    Primary color is not being used on background colors, so branding is not kept consistent (#23777)
    Full Screen Night Mode Dashboard Has light background when scrolled down (#23766)
    Dark primary color in data visualization makes icons almost disappear. (#23759)
    Primary color in tet with dark backgrounds makes tet hard to read (#23751)
    Relative Date filters on dashboard does not include the filter on drill-through (#23748)
    Dashboard causes scrollbars to constantly go on/off depending on viewport size (#23695)
    Items in the saved question picker are sorted case-sensitive (#23693)
    Sandboed group managers can't see other users in the People tab (#23689)
    Dashboard parameter widget connected to template tag clears value after a few seconds (#23640)

[close]

https://www.metabase.com/

[SiLæncer]

Changelog

    Enhancements:

    Bump jetty-server to 9.4.48.v20220622 (#24482)
    Bulk Filter Modal v3 (#23911)
    Add snowplow tracking for new records on TaskHistory (#23893)

    Bug fixes:

    Blank screen if user without permissions to view dashboard card tries to edit the dashboard filter (#24530)
    Click behavior to another dashboard/question makes the browser open the destination on a new window (#24451)
    False warning that No self-service means higher access than Block permissions (#24380)
    Bookmark icon not updated when question is converted to model and vice-versa (#24375)
    Scalars show short number before showing the full number (#24332)
    Default /api/collection/tree call does not include "exclude-archived=true" (#24329)
    Archive page does not render all items (#24213)
    Revert buttons shown on dashboard revision history for users without edit permissions (#24210)
    Search returns irrelevant matches for non-native questions (#24132)
    Can't embed cards with filters after v0.44.0-RC1 - Invalid Parameters: "missing id" (#24103)
    CASE statements don't evaluate to False if using , False and nested CASE statements (#24100)
    "Custom..." model refresh setting does not work on first request (#24053)
    "Our analytics" appears on "Save question" collection search header even when user doesn't have access to it (#23981)
    Exports fail on specific date styles (#23980)
    Bubble size is scaling according to y-axis on scatter charts (#23977)
    Error sending emails when reply-to setting contains empty string (#23940)
    Email settings needs to use real password, not obfuscated password (#23919)
    Wrong username/password on Office365 for email settings has misleading error (#23918)
    Missing full-screen button on public dashboards (#23811)
    Primary color is not being used on background colors, so branding is not kept consistent (#23777)
    Full Screen Night Mode Dashboard Has light background when scrolled down (#23766)
    Dark primary color in data visualization makes icons almost disappear. (#23759)
    Primary color in text with dark backgrounds makes text hard to read (#23751)
    Relative Date filters on dashboard does not include the filter on drill-through (#23748)
    Dashboard causes scrollbars to constantly go on/off depending on viewport size (#23695)
    Items in the saved question picker are sorted case-sensitive (#23693)
    Sandboxed group managers can't see other users in the People tab (#23689)

[close]

https://www.metabase.com/

[SiLæncer]

Changelog

    Data editor:

    Dangerous operation detector was improved (delete … returning)
    Export of sorted rows was fixed
    Status messages formatting and UI were improved
    Filter by enum value was fixed
    Collection editor was improved (UI in value panel)
    Problem with statistics tab open was fixed

    Console view:

    Non-SELECT queries support was added
    Errors messages are now printed in console
    Driver editor: possibility to set property value to NULL was added
    SQL formatting settings save and preview was fixed
    Data transfer: task settings loading was fixed
    Azure SQL Server, Babelfish: multiple databases support was redesigned

    Clickhouse:

    Table list load was fixed for older server versions
    Data type mapping was improved for cross-database data transfer
    Multirow insert support was added
    64-bit integers support was fixed
    H2: table metadata and DDL read was fixed
    PostgreSQL, CocroachDB:
    Row security policy support was added
    PgPass authentication now support SSH hosts and host redefine
    Routines privileges DDL was fixed

    General UI:

    Default embedded browser was changed to Microsoft Edge
    Properties editor: value save on focus change was fixed
    Tip of the day dialog layout was fixed (thanks to @troizet)
    Many minor UI bugs were fixed

[close]

https://dbeaver.io/

[SiLæncer]

Changelog

    ADDED: Perspectives (docs: https://dbgate.org/docs/perspectives.html )
    CHANGED: Upgraded SQLite engine version (driver better-sqlite3: 7.6.2)
    CHANGED: Upgraded ElectronJS version (from version 13 to version 17)
    CHANGED: Upgraded all dependencies with current available minor version updates
    CHANGED: By default, connect on click #332?
    CHANGED: Improved keyboard navigation, when editing table data #331
    ADDED: Option to skip Save changes dialog #329
    FIXED: Unsigned column doesn't work correctly. #324

[close]

https://github.com/dbgate/dbgate