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:

    Remove unused dep on aleph (and thus unused transient dep on Netty) (#20342)

    Bug fixes:

    Filter dropdown only allows filtering on "starts with" (#20551)
    Unable to filter dashboards for dashboard subscription emails (#20516)
    Dashboard filter with defaults, doesn't work if values are removed, query fails (#20493)
    Pulse Question Alert to Slack sending cropped images (#20444)
    Cannot remove Google Sign-in setup (#20442)
    Embed dashboard Field Filter cannot work when choosing single option (#20438)
    Custom expression - Count needs parentheses, but deletes them afterwards (#20420)
    Cannot open Model sidebar in some cases (#20414)
    BigQuery incorrectly aliasing, which can make the query fail (#20413)
    Filtering on nested questions causes error in Public and Embedding (#20393)
    BigQuery nested query with ambiguous columns causes error (#20362)
    Setting a filter to "Locked" in Embedding is not possible (#20357)
    Oracle queries don't work when aliases (auto-generated or otherwise) contain double quotes or null characters (#20307)
    When no-data user views a nested question, then all editing options are exposed (#18978)
    When no-data user views a nested question, then "Ask question" and "Browse data" appears (#18977)
    Oracle fails queries on joins with tables with long display names (#15978)
    Pivot Table: Cannot change name of fields used for "values" (#15353)

[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

    SQL editor:
        Problems with app freeze on very complex queries executing was fixed
        Parameters binding dialog now supports multiline editor
        Script selector panel UI was fixed
        New scripts now position cursor to the end of script
    Data editor:
        Columns drag-n-drop support was fixed (Linux)
        Dictionary table editor now supports default column names customization
        Connection-specific data formatting settings save was fixed
    Metadata editor:
        Table DDL is now auto-updated after new table editing
    Navigator:
        Bug with connection element expansion during connect was fixed
        Table statistics refresh was fixed
        Columns configuration (visibility, size, order) save/load was improved
        "Expand on connect" now expands both database and schema
        Column reordering now supports multiple columns
    SSH: known_hosts support and validation of target host before connect were added
    Various database tools: NullPointer error in task wizard was fixed
    Data transfer: table re-create option was added
    Clickhouse: problem with access to read-only connections was fixed
    Firebird: columns autoincrement option editor was added
    Generic driver: ClassCast error during connection instantiation was fixed
    PostgreSQL:
        Event triggers support was added
        Greenplum, EDB: local clients configuration was added
        Google Cloud driver support was fixed (driver dependencies)
        Functions signature now include out parameters
        GIS viewer for columns in complex data types ws fixed
        CIDR data type support was added
        Deferrable foreign keys create was fixed
    SQL Server Synapse support was improved (metadata reading)
    Trino: problem with corrupted navigator tree after long connect was fixed
    New drivers: Denodo driver configuration was added (thanks to @scruz-denodo)

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

    Issue "Desktop window scroll/zoom behaviour".
    Issue "Rendering artifacts on native decorated windows on HiDPI"

http://jailer.sourceforge.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: Fixed (8075) the low-level error that the data table field cache could not be obtained twice (the effect includes multiple places) (8089)
   Upd: Connection Explorer : When [Last Access Time] does not exist, it will be created automatically (8089)
   Upd: (ODBC) Allow update of connection dialog settings after connection failure (8089)
   Upd: Others include cumulative minor updates, corrections and optimizations (8089)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

 Added the -> and ->> operators for easier processing of JSON. The new operators are compatible with MySQL and PostgreSQL.
The JSON functions are now built-ins. It is no longer necessary to use the -DSQLITE_ENABLE_JSON1 compile-time option to enable JSON support. JSON is on by default. Disable the JSON interface using the new -DSQLITE_OMIT_JSON compile-time option.
Enhancements to date and time functions:

    Added the unixepoch() function.
    Added the auto modifier and the julianday modifier.

Rename the printf() SQL function to format() for better compatibility. The original printf() name is retained as an alias for backwards compatibility.
Added the sqlite3_error_offset() interface, which can sometimes help to localize an SQL error to a specific character in the input SQL text, so that applications can provide better error messages.
Enhanced the interface to virtual tables as follows:

    Added the sqlite3_vtab_distinct() interface.
    Added the sqlite3_vtab_rhs_value() interface.
    Added new operator types SQLITE_INDEX_CONSTRAINT_LIMIT and SQLITE_INDEX_CONSTRAINT_OFFSET.
    Added the sqlite3_vtab_in() interface (and related) to enable a virtual table to process IN operator constraints all at once, rather than processing each value of the right-hand side of the IN operator separately.

CLI enhancements:

    Columnar output modes are enhanced to correctly handle tabs and newlines embedded in text.
    Added options like "--wrap N", "--wordwrap on", and "--quote" to the columnar output modes.
    Added the .mode qbox alias.
    The .import command automatically disambiguates column names.
    Use the new sqlite3_error_offset() interface to provide better error messages.

Query planner enhancements:

    Use a Bloom filter to speed up large analytic queries.
    Use a balanced merge tree to evaluate UNION or UNION ALL compound SELECT statements that have an ORDER BY clause.

The ALTER TABLE statement is changed to silently ignores entries in the sqlite_schema table that do not parse when PRAGMA writable_schema=ON.

[close]

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.

Whats new:>>

    GUI improvements.
    Minor GUI bug fixes.

http://www.vlsoftware.net/

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

* Up SQLite to 3.38.0
* Column filters for resultset
* Jinja scripting
* Improve BLOB handling + issue #98

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

[SiLæncer]

Changelog

   

    Bug fixes:

    Dashboards breaks when there's filters to cards that a user don't have permissions to view (#20656)
    Questions with Field Filter with widget type "None" will not show results (#20643)
    Can't combine saved questions on a dashboard card (#20637)
    Setting a filter to "Locked" in Embedding question is not possible (#20634)
    Nested queries with long Data Model names causes failing query with incorrect aliasing (#20627)
    Dropdown list filtering not working, when there's nulls (#20618)
    BigQuery - nested query generating bad aliases, when columns are renamed in Data Model (#20610)
    Summarizing with implicit join does not allow subsequent joins and nested query (#20519)
    Databases shows sync-spinner and doesn't allow to remove it or do a forced sync (#20283)

[close]

https://www.metabase.com/

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

Added /Columns command-line option, which allows you to specify the fields to export from command-line.

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

[SiLæncer]

Changelog

Data transfer:

    Table recreate mapping type was added
    Table selector dialog now supports filters configuration
    Variables configuration for data transfer tasks was fixed
    Variables auto-complete was fixed in output file name
    Custom data formatting now applied for TXT export format
    Insert statement now supports DEFAULT clause for empty list of columns

Data editor:

    Row count calculation query was fixed
    Rows scrolling was disabled for data modifying queries
    Problem with editor focus after new row add was fixed
    Column value filter was fixed (wrong SQL query)

SQL editor:

    Parameters binding dialog was improved (multiline editor was added, keyboard shortcuts were fixed)
    Filtering and ordering by columns with aliases was fixed
    Problem with cursor jump to script end was fixed
    Script selector popup was fixed (issue with datasource association)
    Script task execute was fixed (for connections without default database)

DDL generator: option to generate FKs as separate statements was added
Metadata search: search by LIKE pattern was fixed
Session manager UI was fixed (multiline cells on Linux, background color for connection type)
Interface language now can be changed in preferences (for MacOS and Linux installers)
SSH: option to disable host name validation was added
Local clients configuration load was fixed (MySQL and PostgreSQL derived drivers)
Azure SQL server: view definition read was fixed
Clickhouse: read-only connections support was improved

H2:

    Driver configuration for version 2.x was added
    Check constraints support was added
    Unique keys support was added

MySQL: new view creation was fixed (DDL)

Oracle:

    Metadata read performance was significantly increased
    Case-sensitive navigator filters support was fixed

Snowflake: custom authentication configuration option was fixed
SQLite: sequences read was fixed
SQL Server: open database object dialog now respects selected database
Italian localization was improved (thanks to @capitanfuturo)
Many minor UI bugs were fixed

[close]

https://dbeaver.io/

[SiLæncer]

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

License: Open Source

Changelog

    Features:

    Added capability to deploy PostgreSQL servers on Amazon RDS.
    This feature allows the users to deploy the PostgreSQL server on the Amazon AWS Cloud. In the future more cloud options will be available.

    Bugs/Housekeeping:

    Rename the menu 'Disconnect Database' to 'Disconnect from database'.
    Fixed a schema diff issue in which user mappings were not compared correctly.
    Fixed an issue where pgadmin cannot connect to LDAP when STARTTLS is required before bind.
    Fixed an issue where a warning is flashed every time for an email address when authentication sources are internal and ldap.
    Fixed an issue where the parent partition table was not displayed during autocomplete.
    Fixed an issue where the User Management dialog is not opening.
    Ensure that the user should be able to add a new server with a UNIX socket connection.
    Allow users to scroll and enter input when there is a validation error.
    Ensure that Flask-Security-Too is using the latest version.

[close]

https://www.pgadmin.org/

[SiLæncer]

Changelog

Fix problems with the new Bloom filter optimization that might cause some obscure queries to get an incorrect answer.
Fix the localtime modifier of the date and time functions so that it preserves fractional seconds.
Fix the sqlite_offset SQL function so that it works correctly even in corner cases such as when the argument is a virtual column or the column of a view.
Fix row value IN operator constraints on virtual tables so that they work correctly even if the virtual table implementation relies on bytecode to filter rows that do not satisfy the constraint.
Other minor fixes to assert() statements, test cases, and documentation. See the source code timeline for details.

[close]

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

[SiLæncer]

Whats new:>>

    Security Release:

    Please note that this release includes a security update to fix an issue where a user could upload files to directories outside of their storage directory, when using pgAdmin running in server mode.
    Users running pgAdmin in server mode, including the standard container based distribution, should upgrade to this release as soon as possible.
    This issue does not affect users running in desktop mode.

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

With releases 12.2.1 and 12.2.2, the user interface may freeze when using the extraction model editor. This has been fixed.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

    Navigator:
        Connection read-only state switcher was added in main toolbar/menu
    Data editor:
        Auto-refresh UI was fixed (stop on error visualization)
        Array data types handling was improved (PostgreSQL, Clickhouse)
        Invalid fractional seconds rendering was fixed
        Filter panel is removed in non applicable presentations
        Number of selected rows calculation was fixed
        Row colors reset option was added
        Edit controls enable state was fixed for plaintext view
        Keyboard shortcuts were fixed in inline date/time editor
        Next segment auto fetch was fixed for specific queries
    Data transfer:
        “Ignore duplicated rows” option was added
        Table mapping “re-create” support was improved
        Skipped columns configuration save was fixed
    SQL editor:
        Data filter injection for custom SQL queries was improved
        Transaction monitor was fixed (amount of statements in a transaction)
    Tasks: task ordering was fixed (folders on top)
    Command line: possibility to specify external variables file was added
    MySQL: indexes edit support was added
    Oracle:
        Sequences DDL tab was added
        Scheduler jobs metadata read was fixed
        Arrays presentation was improved (numbers formatting was fixed)
        Materialized view save was fixed
    PostgreSQL:
        View source editor was fixed (redundant ‘create or replace’ clause was removed)
        Template databases are now visible is specified in connection settings
        Server version < 8 support was improved
        Saved backup/restore tasks UI was fixed
    Redshift: search in procedure definition was fixed
    Vertica:
        Metadata performance was significantly improved
        Table/column comments are now read in lazy mode

[close]

https://dbeaver.io/