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.

Whats new:>>

    Fixed several bugs in exporting custom calculated fields to DBF and Database target formats.
    Minor improvements in database opening interface.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

    ERD: table copy-paste was fixed
    Project delete now requires confirmation of project files delete
    Command line: connection credentials now can be passed along with connection name/id
    SSH: private key format conversion was improved (Linux)
    SQL INSERT query generator now skips auto-generated columns
    SQLite: table column delete feature was added
    Teradata: active schema selector was added
    Firebird: problem with missing views was fixed. View source editor was fixed
    Exasol: table index create UI was fixed
    SQL Server: index create UI was improved (index type selector)
    Hive: SQL dialect was improved (extra keywords)
    MySQL/MariaDB: privileges editor UI was fixed
    HANA: triggers metadata reading was fixed (bug with wrong schema)
    Many minor UI bugs were fixed

    A lot of improvements for MacOS:

    Problem with toggle checkboxes was fixed
    Problems with inline value editors were fixed
    Problem with connection editor open on single click was fixed
    Problem with metadata viewer in BigSur was fixed

    SQL editor:

    Complex SQL queries parser was improved
    Query folding now respects active SQL dialect
    Problem with focus loss after query execute was fixed

    Data transfer:

    Imports from CSV/XLS: date columns support was added
    Export in SQL INSERT format: support of various INSERT/REPLACE/UPSERT dialects was added
    Problem with active schema switch during task execute was fixed
    Export from query: task UI configuration was fixed (active schema select)

    PostgreSQL:

    Table DDL was fixed (serial columns)
    Role members/permissions viewer was fixed
    Permission editor now supports sequences and materialized views
    Bug with partition list read was fixed

    Oracle:

    PL/SQL parser was significantly improved
    View DDL read was fixed
    Session manager now supports Oracle 9 and 8

    BigQuery:

    Problem with missing resultsets was fixed
    Driver version was upgraded

[close]

https://dbeaver.io/

[SiLæncer]

Changelog

    Added the sqlite3_txn_state() interface for reporting on the current transaction state of the database connection.
    Enhance recursive common table expressions to support two or more recursive terms as is done by SQL Server, since this helps make queries against graphs easier to write and faster to execute.
    Improved error messages on CHECK constraint failures.

    CLI enhancements:

    The .read dot-command now accepts a pipeline in addition to a filename.
    Added options --data-only and --nosys to the .dump dot-command.
    Added the --nosys option to the .schema dot-command.
    Table name quoting works correctly for the .import dot-command.
    The generate_series(START,END,STEP) table-valued function extension is now built into the CLI.
    The .databases dot-command now show the status of each database file as determined by sqlite3_db_readonly() and sqlite3_txn_state().
    Added the --tabs command-line option that sets .mode tabs.
    The --init option reports an error if the file named as its argument cannot be opened. The --init option also now honors the --bail option.

    Query planner improvements:

    Improved estimates for the cost of running a DISTINCT operator.
    When doing an UPDATE or DELETE using a multi-column index where only a few of the earlier columns of the index are useful for the index lookup, postpone doing the main table seek until after all WHERE clause constraints have been evaluated, in case those constraints can be covered by unused later terms of the index, thus avoiding unnecessary main table seeks.
    The new OP_SeekScan opcode is used to improve performance of multi-column index look-ups when later columns are constrained by an IN operator.
    The BEGIN IMMEDIATE and BEGIN EXCLUSIVE commands now work even if one or more attached database files are read-only.
    Enhanced FTS5 to support trigram indexes.
    Improved performance of WAL mode locking primitives in cases where there are hundreds of connections all accessing the same database file at once.
    Enhanced the carray() table-valued function to include a single-argument form that is bound using the auxiliary sqlite3_carray_bind() interface.
    The substr() SQL function can now also be called "substring()" for compatibility with SQL Server.
    The syntax diagrams are now implemented as Pikchr scripts and rendered as SVG for improved legibility and ease of maintenance.

[close]

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

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

    If a foreign key is nullable, rows can now be exported with no parents without violating the integrity
    by setting the foreign key to null instead. In the same way parents can be deleted without their children.
    Support of CLOB/BLOB in MS SQL

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

-View and edit data (Data Browser and Editor ):

   Add: When the memory consumption exceeds Max 1GB(32bit)~8GB(64bit), it will automatically prompt to choose whether to continue or not to avoid affecting processing performance (7643)
   Add: When memory is insufficient (OutOfMemoryException) Automatically interrupt processing at the time to avoid abnormal exit (7643)

   Upd: The browsing progress increases and the memory occupied is displayed (7643) -Main
program update ( Main ):

   Add: (Informix) Supports SQLI and DRDA Protocols dual communication protocol, automatic source detection Switch processing (7643)
   Add:(Firebird) Support manually specifying the connection code (default is the database code) (7643)
   Fix: (PostgreSQL) After the correction (7592), the numeric database type related processing (7643)
   Upd: IBM DB2/Informix component version updated to IBM 9.7.4.4 .Data.DB2.dll (11.5.5000.9) (2020/11/18) (7643)
      Misc: (IBM the DB2 / Informix) IBM the Data Server Client Packages Standard Package Version 11.5 FP0 (2020/11/18)
   Upd: available The initial directory location of the portable database is automatically obtained from the location of the previous database, which greatly simplifies the omission of selection processing (7643)

   Upd: Others include cumulative minor updates, corrections and optimization processing (7643)-Filtering
and sorting field names ( Filtering and the columns the Sorting ):

   the Add: enable (7559) supports copying selected field to the clipboard functions (copy the selected the columns to Clipboard) (7643)

- data import ( the data Import ):

   the Add:Support batch file importing process (Batch Support), allows select multiple files into processing (7643)

- Data Export ( the Data Export ):

   Upd: user interruption after processing to avoid unnecessary subsequent processing operation (7643)

- generating a script ( generating the scripts ):

   Fix: Fixed CLOB preset types of data missing quotes '' process (7643)

- design table ( the table Designer ):

   the Add: (the SQLite / the Oracle 12+) [update] table ( Design Table) support new Auto field processing (7643)

- database migration ( database migration ) (Pro):

   Upd: all updates with dbMigration .NET software (7643)

[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

Bug fixes

    Fix chain filtering with temporal string params like 'last32weeks' (#13876)
    Linked filters breaking SQL questions on v0.37.2 (#13868)
    Running with timezone Europe/Moscow shows Pulse timezone as MT instead of MSK and sends pulses on incorrect time (#13867)
    For dump_to_h2, order fields to dump by ID (#13839)
    For dump_to_h2, remove object count from log output (#13823)

[close]

https://www.metabase.com/

[SiLæncer]

Whats new:>>

    Improvements in opening dBase (DBF) databases in 64-bit applications when using ADO interface.
    More correct quoting field names when exporting data to SQL Script and Database target formats.
    Possibility to specify field mappings in the table mappings XML file for multi-table exporting. See table mappings file documentation for details. [Enterprise edition]

http://www.vlsoftware.net/

[SiLæncer]

Changelog

    Enhancements:

    Restyled drill-through and actions popover (#13695)
    Collections Redesign Implementation (#13660)
    Add timeouts for both configurations (#13568)
    Run metabase helm chart on a kubernetes cluster which has pod security policy (#13147)
    Don't set Site URL on requests from ELB HealthChecker (#12996)
    Request to add Updated timestamp type to data model, or generic timestamp type (#12386)
    Docker image can not run as non-root (#9861)
    Add option to disable user ID/hash remark added to every SQL question (#8539)
    We should add field descriptions to lists of fields in the Data Reference (#6316)
    Add Special Type: DateTime String (ISO) (#1576)

    Bug fixes:

    Object Details breaks if Field Type is "Field containing JSON", but data is not JSON (#12600)

[close]

https://www.metabase.com/

[SiLæncer]

Rdex is a freeform database which can be used to store addresses, phone numbers, birthdays, online ids, recipes etc. basically any miscellaneous piece of information. It is based on the idea of a cardfile, like a Rolodex. Just click "New Card," paste or type in some info and click save. Later, you can search for any text contained in the card by tpying the word you are searching for into the search box at the top.

License: GPL

Changelog

    Improved security of password handling for encrypted files.
    Added a timestamp (date) insertion menu item.
    Added an erase button for the search box.
    Added an option to open in List View.
    Display in browser function now accepts file: urls from the local file system.
    Organized preference items into a new options menu item.
    Added ctrl double-click to select an entire line.
    Added a portable memory stick capability that stores the rdex.ini file in the same folder as the program.

[close]

http://pnewman.com/rdex/rdex-windows.htm

[SiLæncer]

SQLiteSpy is a fast and compact GUI database manager for SQLite. It reads SQLite 3 files and executes SQL against them. Its graphical user interface makes it very easy to explore, analyze and manipulate SQLite databases.

License:    Freeware for personal and educational use.

Changelog

    The download package now contains SQLiteSpy.exe Win32 as well as Win64 executables.
    Update built-in DISQLite3 engine to SQLite 3.31.1.
    Add the BLOBIO SQL function extension. Example:
        CREATE TABLE t(a blob);
        INSERT INTO t VALUES (x'01020304');
        SELECT readblob('main', 't', 'a', 1, 0, 4);
    Add the DBDATA virtual table extension. Examples:
        SELECT * FROM sqlite_dbdata();
        SELECT * FROM sqlite_dbptr();
    Add the FOSSILDELTA SQL function extension. Example:
        SELECT delta_apply(x'0102', delta_create(x'0102', x'0304'));
    Add the URIFUNCS SQL functions extension. Examples:
        select sqlite3_filename_database('main');
        select sqlite3_filename_journal('main');
        select sqlite3_filename_wal('main');
    Add the UUID SQL functions extension. Examples:
        SELECT uuid();
        SELECT uuid_str(uuid());
        SELECT uuid_blob(uuid());
    Add redo to SQL edit.
    Automatic column widths of result grid take column caption into account.

[close]

http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index

[SiLæncer]

Changelog

    Password field layout was fixed
    Tasks editor view: collapse/expand behavior was fixed
    Opening SQL files from shell was fixed (MacOS)
    SAP HANA: connection settings page redesigned (thanks to @kai-morich)
    PostgreSQL: roles DDL view was added
    SQL Server: stored procedures invocation was fixed
    Clickhouse: ALTER TABLE scripts for new columns was fixed
    Many minor UI bugs were fixed

    Data editor:

    Default column values are now shown for new rows
    LIKE filers now add % masks automatically
    Tabs close confirmation dialog was fixed
    Value filter drop-down was fixed (problem with column mismatch was fixed)
    Boolean values view is now configurable
    Result tabs drag-n-drop behavior was fixed

    Metadata editor:

    Boolean values view is now configurable
    Virtual foreign keys editor was fixed
    Incorrect column length (zero or negative) was fixed

    Data transfer:

    Data type mapping was improved (better type matching)

    Redshift:

    Extra data types (non-PostgreSQL) support was added
    Strings parser was fixed (escape with backslash)

[close]

https://dbeaver.io/

[SiLæncer]

Whats new:>>

    Workaround for "Parser hangs in some queries"
    Internal refactoring measures

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

    Enhancements:

    Sandboxing: peek at metadata for native SQL sandboxing queries by running them as a test user (#13716)
    Restyled drill-through and actions popover (#13695)
    Collections Redesign Implementation (#13660)
    Add timeouts for both configurations (#13568)
    Add Swiss number formatting (Localization - Separator Style) (#13348)
    Run metabase helm chart on a kubernetes cluster which has pod security policy (#13147)
    Don't set Site URL on requests from ELB HealthChecker (#12996)
    Request to add Updated timestamp type to data model, or generic timestamp type (#12386)
    Docker image can not run as non-root (#9861)
    Add option to disable user ID/hash remark added to every SQL question (#8539)
    We should add field descriptions to lists of fields in the Data Reference (#6316)
    Support unix timestamps in microseconds (µs) (#1889)
    Add Special Type: DateTime String (ISO) (#1576)

    Bug fixes:

    datetime fingerprinters are incorrect for :type/UNIXTimestampSeconds columns (#14067)
    Object Details breaks if Field Type is "Field containing JSON", but data is not JSON (#12600)
    axl_ini: support line continuation for values
    axl_gui: gui::Engine::writeClipboard should use sl::ArrayRef, not sl::Array

[close]

https://www.metabase.com/

[SiLæncer]

Whats new:>>

    Improved animation performance.
    Workaround for "Parser hangs in some queries #1013"
    Internal refactoring measures

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

    Add: Support Firebird 4.0 new data type processing (int128, decfloat(16/34), time with time zone, timestamp with time zone))
    Upd: Firebird component version updated to FirebirdSql.Data.FirebirdClient.dll 7.10 .1.0
    Upd: the PostgreSQL version update to the member Npgsql.dll 4.1.7
    Upd: Secure Shell Protocol ( SSH: Secure Shell ): PrivateKey supports both absolute and relative position saving
    Add: (MariaDB) supports System-Versioned Tables (Temporal Tables) Object-related processing
    Upd: Optimize the display and control of HiDPI high zoom ratio >150
    Fix: Solve the problem of continuous flashing when the status bar prompts overlap with the mouse cursor
    Upd : Update Italian language (by Paolo Saudin)
    Upd: Others include cumulative minor updates, corrections and optimization processing-Server
    version database and structure description filtering ( Filtering Databases and Schemas )
    Add: Data Filter processing of library and structure description, add to the root node right-click menu

    Add:(SQL Server) increased automatically excluded functions when no permission to access the database generated scripts ( Generating Scripts ):

    Fix: fixes and improvements related fields pre-processing IS NULL the DEFAULT Database Migration ( Database Migration )(Pro)
    Upd: All updates are the same as dbMigration .NET software

[close]

http://fishcodelib.com/Database.htm