Thema: Datenbanksoftware und Tools diverses ...

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

    Improvements in export interface.
    Improvements and fixes in data migration between SQL Server, Oracle, and PostgreSQL databases. [Pro and Enterprise versions]

http://www.vlsoftware.net/

[SiLæncer]

Changelog

    Multiple fixes for reads past the end of memory buffers (NB: reads not writes) in the following circumstances:

    When processing a corrupt database file using the non-standard SQLITE_ENABLE_STAT4 compile-time option.
    In the CLI when the sqlite3_error_offset() routine returns an out-of-range value (see change item 21 below).
    In the recovery extension.
    In FTS3 when processing a corrupt database file.
    Fix the sqlite3_error_offset() so that it does not return out-of-range values when reporting errors associated with generated columns.
    Multiple fixes in the query query optimizer for problems that cause incorrect results for bizarre, fuzzer-generated queries.
    Increase the size of the reference counter in the page cache object to 64 bits to ensure that the counter never overflows.
    Fix a performance regression caused by a bug fix in patch release 3.41.1.
    Fix a few incorrect assert() statements.

[close]

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

[SiLæncer]

Whats new:>>

    Improvements in export interface.
    Improvements and fixes in export routines.

http://www.vlsoftware.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

    SQL editor:

    Results tab now can be detached
    Editor toolbar now can be customized in preferences
    Query statistics tab now can be turned off
    Table metadata search was improved

    SSH:

    Support of new crypto ciphers was added
    SHH agents now works properly in Linux

    General UI:

    Zoom in text editors and data editors was fixed
    Navigator tree refresh after metadata change was fixed
    Default font size was increased for MacOS
    Text font configuration was fixed in multiple dialog windows
    Connection type settings change now affects UI properly
    Data export: exporting of BLOB values in TXT format was improved
    Native network proxy configuration was fixed
    TiDB: new driver was added (thanks to @Icemap)
    Clickhouse: driver version was updated to 0.4.2
    Firebird: procedure parameters defualt values support was added
    Oracle: additional properties in table info were added
    PostgreSQL: composite data type support was improved
    SQLite: STRICT mode support was added
    Sybase/SQL Anywhere: result set size limitation in SQL was fixed
    Vertica: expired password change feature was added

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

In rare cases, the user interface was blocked for a short time when establishing a connection. This has been corrected.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

    The maximum possible memory usage has been increased.
    Minor improvements to the user interface.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

    Multiple interface improvements.
    Improvements and fixes in export routines.
    Minor changes and bugfixes in formula calculation engine.

http://www.vlsoftware.net/

[SiLæncer]

Whats new:>>

    Multiple interface improvements.
    A bugfix in exporting to database. [Pro and Enterprise editions]

http://www.vlsoftware.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 ):

   Add: (VistaDB ) Supports AES256 encrypted database processing (8495)
   Fix: Fixed (8447) related functions restarted after executing the database shutdown, resulting in the problem that the connection status is still closed (8495) Upd
   : (Excel/Text) Solve the problem of large data tables Obtaining ROWS COUNT when content is too slow (8495)
   Upd: (Text) Add a prompt message if the file length exceeds 64 characters, so it cannot be processed normally (8495)
   Upd: (Text) Exclude obtaining ROWS COUNT when loading objects ( 8495)
   Upd: SQL Server/SQL Azure component version updated to Microsoft.Data.SqlClient 5.1.0 (2023/03/28)()(8495)
   Upd: PostgreSQL component version updated to Npgsql 7.0.2 (2023/02/15)( )(8495)
   Upd: VistaDB component version updated to VistaDB.6.dll 6.4.2 (2022/06/08)( 8495)
   Upd: Others include cumulative small updates, corrections and optimizations (8495)
- Database Migration ( Pro):

   Upd: all updates are the same as dbMigration .NET software (8495)

[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

    Enhancements:

    Fix implicit actions not created in a deterministic order (#29605)
    Currency list: Add Mauritania ouguiya (MRU) as currency (#29545)

    Bug fixes:

    drill-through not working correctly in legend for stacked charts (#29840)
    SSO mapping: users are removed from groups that are not mapped (#29718)
    Date Filter (Specific Dates) doesn't show first days of the month (#29692)
    Big xslx file downloaded from BigQuery are corrupted in v0.45.3 and were not in v0.45.1 (#29118)
    Infinite loop, logging at warn level, filling disk for a GCP BigQuery connection (#28868)
    Dashboard sticky filter incorrectly positioned, when moving between dashboards (#26230)
    Unable to properly filter on an aggregation (#22230)

[close]

https://www.metabase.com/

[SiLæncer]

SQLiteStudio is a comprehensive and reliable SQLite database manager that provides you with a simple means of managing the contents of each database, including tables, triggers and views.

License : GPLv3

Changelog

    ADDED: #3488 SQLite ICU extension is boundled into binary packages (thanks to @tuffnatty).
    ADDED: #4697 Added a 'Restore original hotkey' buttons at keyboard shortcuts page of configuration dialog.
    ADDED: Added sqlar extension to the default set of extensions provided with binary packages.
    CHANGE: #4689 Sorting order is not cleared when table data is refreshed. To removed sorting order user can either double-click on header (once or twice) to restore no sorting for a column, or use context menu to clear any sorting.
    CHANGE: #4735 Order of functions loading has changed. Now it's: built-in, extension-provided, user-defined. The last loaded has the highest precedense.
    CHANGE: #4732 SQLite updated to 3.41.2 (except for SQLCipher, which is still on 3.39.4 at the moment).
    CHANGE: #4683 Custom syntax highlighting colors now use theme-based colors by default (to work well with dynamically changing color palette in night/day theme changes) and can be explicitly enabled in configuration.
    BUGFIX: #4676 #4716 #4693 #4701 #4669 #4721 Few critical fixes for Query Executor, fixing a frequent error: near ")": syntax error.
    BUGFIX: #4685 Fixed WINDOW/OVER/FILTER keyword handling in the SQL parser.
    BUGFIX: #4694 Fixed messages for toolbar buttons in Code Snippets window & fixed loading translations for plugins.
    BUGFIX: #4698 Fixed handling object names with '{' and '}' in their names.
    BUGFIX: #4681 Fixed risk of null reference call in the SqliteOrderBy.
    BUGFIX: #4707 Fixed database file selection dialog, so it doesn't complaint about read-only files.
    BUGFIX: #4679 Fixed issue with case sensivity of CTE alias.
    BUGFIX: #4697 Changed default hotkey for rolling back pending changes in table data from Ctrl+Backspace to Alt+Shit+Backspace. Default hotkey affects new users and will not change automatically for those who upgrade from older SQLiteStudio.
    BUGFIX: #4739 Fixed committing changes in Extensions Manager if modifying valid extension settings, while there is another invalid, yet untouched extension on the list.
    BUGFIX: #4715 Fixed the UPDATE OF column popup on MacOSX.
    BUGFIX: #4754 Fixed Windows uninstaller to not create separate uninstall entries in Windows registry per each SQLiteStudio version and added SQLiteStudio icon for the uninstall entry in Windows Add/Remove programs.
    BUGFIX: Tcl plugin compilation improved on Ubuntu 18.04 (thanks to @tuffnatty).

[close]

http://sqlitestudio.pl/

[SiLæncer]

Changelog

    ER Diagrams:
        Accessibility support (text reader) was added
        Many keyboard shortcuts were added
        Issue with diagram re-layout after options change was resolved
        Issue with moving focus when searching was fixed
    General UI:
        Database editors remain open after disconnect (configurable)
        Clickable hints are now displayed as links
        Issue with missing icons in the toolbar on MacOS was fixed
        Font and color changes in the Result Set were improved
        Large fonts now display correctly on MacOS
    SQL Editor:
        Auto-completion for INSERT/UPDATE/DELETE queries was improved
        Font changes are now applied without a restart
    Data Editor:
        Show numeric values (e.g. infinity) rendering was improved
        Issue with opening images from value panel in external editor was fixed
    Connectivity:
        Legacy SSH algorithms support was added
        Confirmation dialogs now remember user selection
        The number of attempts to reopen the connection was reduced
        Ability to connect via SSHJ with unsaved password was added
        Maven artifacts configuration now supports classifier
    Data transfer: column description support was added for CSV and XLS formats
    AI (ChatGPT): unsupported AI models were replaced with new ones
    Databases:
        Firebird: default parameters in procedure definitions were added
        PostgresSQL: materialized views dependencies were added
        Databricks: support of table comments were added
        Oracle: issue with cropped ‘q’ at the end of the string was fixed
        SQLite: triggers delete was implemented
        SQL Server: issue with duplicated data types was resolved
    Localization:
        Traditional Chinese localization was updated (thanks to @hwhsu1231)
        Traditional Chinese language was added to Windows installer
    Misc:
        Microsoft store: issue with application installation was fixed on most machines
        We switched to Java 17 (again)
        We switched to Eclipse 2023-03 as a base platform

[close]

https://dbeaver.io/

[SiLæncer]

Whats new:>>

    Both the in-place editor and the search condition dialog now support columns of type "enum".
    Support of "identity" columns was added. (PostgreSQL, Microsoft SQL Server and DB/2)

http://jailer.sourceforge.net/

[SiLæncer]

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

License: Open Source

Changelog

Supported Database Servers

PostgreSQL: 11, 12, 13, 14 and 15

EDB Advanced Server: 11, 12, 13, 14 and 15

Bundled PostgreSQL Utilities

psql, pg_dump, pg_dumpall, pg_restore: 15.2

New features

    Issue #3298 - Auto expand row edit form when a new row is added for Primary Key, Foreign Key, Unique Constraint and Exclusion Constraint.
    Issue #5014 - Added support for mounting shared storage in server mode.
    Issue #5022 - Add a note on top of keyboard shortcuts preferences to show the Accesskey of the browser.
    Issue #5750 - Added capability to deploy PostgreSQL servers on Google Cloud.
    Issue #5805 - Added support of BigAnimal v3 API.
    Issue #5854 - On pressing Ctrl+C on a tree object, copy the fully qualified name to clipboard.
    Issue #5855 - Added option to create unique constraint with nulls not distinct.

Housekeeping

    Issue #4734 - Rename the “Properties…” context menu option of the objects to “Edit Object…” and the “Browser” tree to “Object Explorer”.
    Issue #5011 - Upgrade from psycopg2 to psycopg3.
    Issue #5701 - Remove Bootstrap and jQuery usage.
    Issue #5830 - Add .ts and .tsx files under linter and fix linter issues.
    Issue #5901 - Update SQLAlchemy, Flask, Flask-SQLAlchemy, and other packages to current versions.

Bug fixes

    Issue #4423 - Fixed an issue where list of tables is not displayed in a SQL_ASCII database.
    Issue #4784 - Handle errors occurring during decoding UTF-8 encoded query result data which contains ascii characters.
    Issue #4884 - Fixed an issue where it is not possible to import csv data to tables having columns with german umlauts in their name.
    Issue #4891 - Fixed ‘rawunicodeescape’ codec can’t decode issue in a SQL_ASCII database.
    Issue #5504 - Fixed an issue where incorrect view of text[] fields in query and table results when use other then UTF8 (win1251) codepage and symbols.
    Issue #5735 - Show appropriate error message when master password is not set instead of ‘Crypt key missing’.
    Issue #5775 - Display the ‘No menu available for this object’ message if the selected tree node does not have any options.
    Issue #5824 - Ensure that the user’s storage directory is created when the users are created, as well as for those users whose directories have not yet been created.
    Issue #5833 - Fixed an issue where user MFA entry was not getting delete after deleting a user.
    Issue #5834 - Fixed issue where pgAgent jobs were not getting dropped from properties tab.
    Issue #5874 - Make “using” and “with check” fields a textarea in the RLS policy.
    Issue #5894 - Use fetch instead of axios to close connections in SQLEditor, ERD, Schema Diff and Debugger to ensure it completes.
    Issue #5904 - Fixed an issue where the count query should not be triggered when the estimated count is less than zero.
    Issue #5907 - Validate user inputs provided in configuration files before starting pgadmin server.
    Issue #5916 - Fix an issue in search objects where objects were unable to locate occasionally.
    Issue #5919 - While restoring the database connections due to lost server connection, ensure that the databases which were previously connected are only reconnected.
    Issue #5921 - Ensure that when pasting rows the rows are added right below the selected rows for copying.
    Issue #5929 - Dashboard graph Y-axis width should increase with label.
    Issue #5934 - Ensure that default values are set only for insert statement if user does not provide any values, in case of updating existing values to blank it should be set to null.
    Issue #5941 - Fixed an issue where migration on external database is not working.
    Issue #5943 - Use http for SVG namespace URLs which were changed to https for SonarQube fixes.
    Issue #5952 - Ensure that the schema diff tool should not allow comparison between Postgres Server and EDB Postgres Advanced Server.
    Issue #5953 - Fixed error while executing continue in debugging session after some time of debug execution.
    Issue #5955 - Fix an issue where query tool is stuck when running query after discarding changed data.
    Issue #5958 - Fix an issue where new dashboard graphs are partially following theme colors.
    Issue #5959 - Fix an issue where Backup, Restore, and Maintenance not working if connection timeout is set in the server dialog.
    Issue #6018 - Change the foreground color of the code mirror text for Dark Theme.
    Issue #6093 - Fix the dependents SQL of Roles which is throwing a type casting error on PostgreSQL 15.
    Issue #6100 - Fixed the LDAP authentication issue for the simultaneous login attempts.(CVE-2023-1907)
    Issue #6109 - Fixed asyncio random task error messages in Query tool.
    Issue #6122 - Fixed CSV export from Query Tool results does not include all columns for multiple CTEs.

[close]

https://www.pgadmin.org/

[SiLæncer]

Whats new:>>

    In exporting interface, added capability to copy primary keys from source to target for multi-table database-to-database migration (if possible). [Enterprise edition]
    Minor changes and bugfixes.

http://www.vlsoftware.net/