Thema: Datenbanksoftware und Tools diverses ...

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

    Slack files channel can be confusing after initial setup (#20936)

    Bug fixes:

    sessionStorage can become filled causing the frontend to throw errors until browser restart (#25312)
    Filters incorrectly showing as linked to all fields on combined charts (#25248)
    First created question not in Saved Questions inside Data Selector until page reload (#25144)
    Cannot change email From-name and Reply-to-address when environment variables are used for other settings (#25057)
    Column filters not working on multi-aggregation (#25016)
    Tooltip periods are not displayed nicely on SQL questions (#25007)
    Can't change filters via 'Show filters' (#24994)
    Bubble size not consistent across multiple series (#24936)
    A hidden Database Sync doesn't allow descriptions for tables or fields to be edited (#24900)
    Newly created Model not an option when creating a new question (#24878)
    Dashboard filter does not show Search widget when trying to workaround other filter issues (#24741)
    Chinese weekdays in calendar widget are incorrect (#22871)
    Field filter linked to Boolean column causes an error when refreshing a public question (#22591)

[close]

https://www.metabase.com/

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

Issues related to metadata acquisition in the SQL console have been corrected.

http://jailer.sourceforge.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

    FIXED: MongoDb any export function does not work. #373
    ADDED: Query Designer short order more flexibility #372
    ADDED: Form View move between records #370
    ADDED: Custom SQL conditions in query designer and table filtering #369
    ADDED: Query Designer filter eq to X or IS NULL #368
    FIXED: Query designer, open a saved query lost sort order #363
    ADDED: Query designer reorder columns #362
    ADDED: connect via socket #358
    FIXED: Show affected rows after UPDATE/DELETE/INSERT #361
    ADDED: Perspective cell formatters - JSON, image
    ADDED: Perspectives - cells without joined data are gray

[close]

https://github.com/dbgate/dbgate

[SiLæncer]

pgAdmin allows multi-database management through an administration interface for PostgreSQL permitting statement, procedure viewing and more.

License: Open Source

Changelog

    Housekeeping:

    Port schema diff to React.
    Remove Backgrid and Backform.
    Port the remaining components of the ERD Tool to React.
    Updated keyboard shortcut documentation.
    Remove Alertify from pgAdmin completely.
    Port search object dialog to React.

    Bug fixes:

    Ensure that if big animal authentication is aborted, API calls should be stopped.
    Fixed an issue where pgAdmin failed to start due to bin path migration.
    Fixed an issue where backup does not work due to parameter ‘preexec_fn’ no longer being supported.
    Ensure that the browser tree should be refreshed after changing the ownership.
    Fixed the error message displayed when clicking the cloud server for which deployment is in progress.
    Fixed an issue where the wrong SQL displayed in difference if the user create an RLS policy on the table without a column.
    Ensure that the dump servers functionality works from setup.py.
    Ensure that the Import/Export server menu option is visible.
    Fixed API test case for change password in the server mode.
    Fixed an issue with the non-visibility of columns added prior to import/export data.
    Fixed an issue where textarea of the JSON Editor does not resize with dialog.
    Fixed ModuleNotFoundError when running setup.py to load/dump servers.
    Replace the language selection ‘Brazilian’ with ‘Portuguese (Brazilian).
    Fixed an issue where server names with special characters are not displayed correctly in the process tab.
    Fixed an issue where ERD throws an error if variable is added to the column.
    Fixed an error while saving changes to the ERD table.
    Fixes a redirect vulnerability when the user opens the pgAdmin URL.

[close]

https://www.pgadmin.org/

[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

    Connection Profile:

    Upd: (SQL Server/SQL Azure) Added Encryption connection encryption option (Optional/Mandatory/Strict)

    SQL Editor:

    Upd: Move line up/down: Alt + Up/Down: Support multi-selection move processing

    AutoComplete and IntelliSense:

    Upd: Optimize and improve the table hint parsing ability
    Upd: Optimization improvements, eliminate unnecessary perceptual processing

    SQL Profiler:

    Fix: Fixed the event setting window, in some states, when double-clicking to expand or add, it may cause blank or exceptions

    Object Explorer:

    Fix: (Firebird) Fixed and improved Reversed Words display and syntax highlighting

    Main program update (Main):

    Upd: Improve the processing speed of GetForeignKeys, affecting multiple functions
    Upd: (PostgreSQL) Inherit from the initial value of search_path in database (or connection) settings
    Upd: PostgreSQL component version updated to Npgsql 6.0.7
    Upd: SQL Server/SQL Azure component version updated to Microsoft.Data.SqlClient 5.0.0
    Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 21.7.0
    Upd: Others include cumulative minor updates, corrections and optimizations

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

    Full text search with wildcards.
    Vertical toolbar for table windows.

http://jailer.sourceforge.net/

[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

    Data editor:
        URL transformer was fixed (for edit mode)
        Grouping panel behavior was fixed
        BLOB/CLOB viewer now shows smart warnings
        NullPointer error was fixed in spatial viewer
    SQL editor: “Open in new tab” behavior was fixed
    Connections:
        URL-based configuration support was added to PostgreSQL, SQL Server and Generic drivers
        SSH user name is now optional (current user name is used)
        SSH: problems with credentials prompt were resolved
    Data transfer: columns auto-mappings was improved (case-insensitive search)
    Diagrams: association creation was fixed
    Metadata editor: schema refresh performance was significantly increased
    Eclipse plugin: a lot of DBeaver-related warnings in error log were resolved
    i18n:
        Chinese localization was improved (thanks to @fengchao)
        German localization was improved (thanks to @bulldog98)
    Apache Hive: default schema detection was implemented
    Clickhouse:
        SSL connection configuration support was added
        UUID data type support was added
    Greenplum: proper client app name is now sent to the server
    MariaDB: problem with data transfer was fixed
    PostgreSQL: box data type support was improved
    SQL Server: problem with sequence value selection was fixed
    Vertica: default driver upgraded to version 12
    Many minor UI bugfixes

[close]

https://dbeaver.io/

[SiLæncer]

Whats new:>>

    ADDED: Editing multiline cell values #378 #371 #359
    ADDED: Truncate table #333
    ADDED: Perspectives - show row count
    ADDED: Query - error markers in gutter area
    ADDED: Query - ability to execute query elements from gutter
    FIXED: Coorect error line numbers returned from queries

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

Minor bug fixes.

http://www.vlsoftware.net/

[SiLæncer]

Whats new:>>

    Fix the build on Windows so that it works with -DSQLITE_OMIT_AUTOINIT
    Fix a long-standing problem in the btree balancer that might, in rare cases, cause database corruption if the application uses an application-defined page cache.
    Enhance SQLITE_DBCONFIG_DEFENSIVE so that it disallows CREATE TRIGGER statements if one or more of the statements in the body of the trigger write into shadow tables.
    Fix a possible integer overflow in the size computation for a memory allocation in FTS3.
    Fix a misuse of the sqlite3_set_auxdata() interface in the ICU Extension.

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

[SiLæncer]

Whats new:>>

    FlatLAF has been updated to version 2.5.
    Minor improvements to the GUI.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

    Enhancements:

    Bump Postgres driver to 42.5.0 (#25544)
    Inform admins if their account is in bad standing (#25161)
    Bump MinaSSHD to 2.9.1 (#25112)
    Envar to disable custom maps / GeoJSON (#19189)
    Metabase Prometheus Exporter (#12377)

    Bug fixes:

    When LDAP is enabled but password login is disabled, login doesn't work (#25661)
    404 on loading models when instance is configured in another language (#25537)
    Loading spinners in filters don't appear anymore (#25322)
    MYSQL disable JSON unfolding doesn't work (#25068)
    MySQL unfolding of JSON fails for boolean and bigint attributes (#24720)
    Aggregation in Models causes the column name to incorrectly be parsed down to questions based on that Model (#23248)
    Changing filters on Simple question drops anything after first aggregation (#14193)
    Changing filters on Simple question drops aggregated filters (#11957)
    Drill through / underlying records action doesn't respect filters in metric definitions (#6010)

[close]

https://www.metabase.com/

[SiLæncer]

Whats new:>>

    ADDED: Drop database commands #384
    ADDED: Customizable Redis key separator #379
    ADDED: ARM support for docker images
    ADDED: Version tags for docker images
    ADDED: Better SQL command splitting and highlighting
    ADDED: Unsaved marker for SQL files

https://github.com/dbgate/dbgate

[SiLæncer]

Whats new:>>

    Improvements when working with list of registered databases.
    Minor changes.

http://www.vlsoftware.net/

[SiLæncer]

Whats new:>>

    Issue "Laggy SQL Console". #95
    Issue "Liquibase export of Oracle RAW-columns fails", #96
    SQL Autocompletion has been significantly improved.

http://jailer.sourceforge.net/