Thema: Datenbanksoftware und Tools diverses ...

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

    the Add: PostgreSQL support read-only mode ( the read-Only mode ) (7520)
    currently supports include SQLite / SQLCE / Access / Excel / dBase / Text / the HP Vertica / MySQL / SQL Server / VistaDB / PostgreSQL and other databases
    Fix: Fixed the display problem of the cursor prompt under HiDPI high zoom ratio (7520)
    Upd: Teradata component version updated to Teradata.Client.Provider.dll 17.0.2.0 (2020/07/07)( )(7520)
    Upd: Others include cumulative minor updates, corrections and optimization processing (7520)-Copy

    cell results to Clipboard (Copy cell results to Clipboard):

    Upd: Significantly increase processing speed while reducing memory usage (7520)
    Add: Increase waiting Cursor status and exception handling (7520) -Data Browser and Editor

    (Data Browser and Editor ):

    Upd: Solve the problem of opening the right-click menu due to the number of selected cells (Cells) and rows (Rows) affecting the opening speed (7520)

    Data Browser (Data Browser ):

    Fix : Fix the problem that caused an exception when the printed content is too long (7520)-Object
    authorization management ( Grant Manager ) and Security Manager ( Security Manager ):
    Fix: solve the problem the box through Space processing key, an abnormality cause problems (.NET apos bugs) (7520)

    to generate script ( generating the scripts ):

    Upd:(Firebird) Update VIEW object generation script processing (7520) AutoComplete and IntelliSense

    ( AutoComplete and IntelliSense ):

    Upd: Improve table alias automatic generation processing (AutoAliases)(7520)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

    Database Chart ( Database Diagram ):

    Fix: (MySQL) correction can not be displayed Shenkaoziliao table (includes other related functions)

    automatically and perception ( autoComplete and IntelliSense ):

    Upd: to enhance the external reference index key ( automatically Foreign key List the References ) processing Ability

[close]

http://fishcodelib.com/Database.htm

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

    Fix for "[jailer:bugs] #43 PostgreSQL: Export of inet and interval"
    Fix for "[jailer:bugs] #44 not a proxy instance if WorkingTableScope.LOCAL_DATABASEand Tomcat jdbc pool"

http://jailer.sourceforge.net/

[SiLæncer]

Relational data browsing application that allows you to gain valuable insight into both the table and the interrelation of the rows.

Apache License 2.0

Whats new:>>

    Fix for "[jailer:bugs] #43 PostgreSQL: Export of inet and interval"
    Fix for "[jailer:bugs] #44 not a proxy instance if WorkingTableScope.LOCAL_DATABASEand Tomcat jdbc pool"

https://sourceforge.net/projects/dbeauty/

[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

Support for externally linked tables (#12741)

[close]

https://www.metabase.com/

[SiLæncer]

Whats new:>>

    Fix for "[Bug] firebird database - No suitable Inline-View Style known #32"
    #32
    Fix for "Delete Reduction is not deleting rows"

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

    Fix for "[Bug] firebird database - No suitable Inline-View Style known #32"
    Fix for "Delete Reduction is not deleting rows"

https://sourceforge.net/projects/dbeauty/

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

    Fixes for opening specifically named tables.
    Improvements and bugfixes when exporting to PostgreSQL and SQL Server databases.
    Improvements in data grid.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

    Support for UPDATE FROM following the PostgreSQL syntax.
    Increase the maximum size of database files to 281 TB.
    Extended the PRAGMA integrity_check statement so that it can optionally be limited to verifying just a single table and its indexes, rather than the entire database file.
    Added the decimal extension for doing arbitrary-precision decimal arithmetic.
    Enhancements to the ieee754 extension for working with IEEE 754 binary64 numbers.

    CLI enhancements:

    Added four new output modes: "box", "json", "markdown", and "table".
    The "column" output mode automatically expands columns to contain the longest output row and automatically turns ".header" on if it has not been previously set.
    The "quote" output mode honors ".separator"
    The decimal extension and the ieee754 extension are built-in to the CLI

    Query planner improvements:

    Add the ability to find a full-index-scan query plan for queries using INDEXED BY which previously would fail with "no query solution".
    Do a better job of detecting missing, incomplete, and/or dodgy sqlite_stat1 data and generates good query plans in spite of the misinformation.
    Improved performance of queries like "SELECT min(x) FROM t WHERE y IN (?,?,?)" assuming an index on t(x,y).
    In WAL mode, if a writer crashes and leaves the shm file in an inconsistent state, subsequent transactions are now able to recover the shm file even if there are active read transactions. Before this enhancement, shm file recovery that scenario would result in an SQLITE_PROTOCOL error.

[close]

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

[SiLæncer]

Changelog

    Data transfer:

    Import from multiple CSV files was added
    Import from files into new tables
    Data import preview dialog was added
    Target table create/alter DDL now supports database-specific options
    Virtual columns are ignored in SQL INSERTs export
    Problem with data transfer wizard and Darkest Dark theme was fixed
    Problem with timestamp format for CSV/XLSX export was fixed
    Case sensitive table/column names resolution was fixed

    Database navigator:

    Statistics render was fixed for MacOS and Linux
    Database size statistics was added for PostgreSQL, MySQL, SQL Server, DB2

    Team work:

    Problem with empty Git Repositories view was fixed
    Git integration was added in project navigator view

    PostgreSQL:

    Native client version was upgraded to version 12 (Windows)
    Check constraints read was fixed (PG 12+)
    SQL results limit was fixed (for queries with LIMIT/OFFSET/FETCH clauses)
    Object DDL generator was improved (comments, permissions)
    Support of case insensitive full-text search was added
    Table partitions statistics was added

    Oracle:

    TNS names search was fixed
    Connection info was fixed for TNS/custom URL connections
    Variables are now supported in custom JDBC URL (thanks to @insightfuls)

    MysQL:

    Problem with check constraints read was fixed
    Table copy was fixed (bug with redundant indexes was resolved)
    Redshift: problem with read-only resultsets was fixed
    Snowflake: SQL dialect support was fixed ($$ comments)
    A large number of minor UI improvements and bugfixes

[close]

https://dbeaver.io/

[SiLæncer]

Changelog

    Enhancements:

    Handle large Slack channel lists (#11735)

    Bug fixes:

    Slack pulse issue with 0.36.0: Slack channel named metabase_files is missing & other channels missing from Pulse dropdown with > 1000 Slack channels (#12978)
    Only admins can search for tables via universal search. (#12332)
    MongoDB: Error filtering by ObjectId field with "Is empty" or "Not empty" options (#11134)
    BigQuery column of ARRAY type in results causes a casting exception (#10275)

[close]

https://www.metabase.com/

[SiLæncer]

Changelog

    SQL Editor ( SQL Editor ):

    Add: Messages Tab: Add SQL statement display (7541)
    Add: Message Tab (Messages Tab): Add SQL execution time display (7541)
    Add: Display results in text (Results to Text): Add SQL execution time and total time display (7541)
    Add: Plain Execution Plan ( Plain Execution Plan ): Add SQL execution time display (7541)
    Add: Add Keeping original formatting): Easy excluded can not be formatted correctly or want to keep the original content format handling (7541)

    generate scripts ( Generating Scripts ):

    the Add: (SQLite 3.31+) support computing data fields ( Computed the Columns ) generation process (including editing and other related Processing) (7541)
    Fix: (SQLite) Fix the problem of index expressions generation (7541)
    Upd: (Firebird) Update the calculation data field to SQL standard syntax display ([type] GENERATED ALWAYS AS) (7541)
    Upd : (PostgreSQL) Optimize Index Columns acquisition speed (7541) -Data Browser and Editor

    (Data Browser and Editor ):

    Upd: Improve and optimize the result of label object removal processing (7541)-Main

    program update ( Main ) :

    Upd: Optimize the display of different fonts under HiDPI high zoom ratio (7541)
    Upd: (SQLite) Database tool- >Password (encryption) setting: Add integrity check to avoid database damage due to version differences (7541)
    Add:All new object scripts are generated, and the reference URL is added (7541)
    Upd: SQLite component version is updated to System.Data.SQLite.DLL 1.0.113.0 (3.32.1) (2020/06/01)(7541)
    Upd: Others include cumulative minor updates, fixes and optimization (7541)

    database migration ( database migration ) (Pro):

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

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

    Major changes since 7.1:

    Simplified database structure view was added
    Database maintenance tools can be saved as tasks now
    Table and schema size statistics were added in the database navigator
    Import from multiple CSV files was added. Files can be imported into new or existing tables
    Many problems with UI freeze on disconnect or query cancel were fixed
    Database navigator rendering was redesigned
    A number of problems with keyboard shortcuts were fixed
    Git integration was improved: now we show file status in the Project Explorer view
    New database drivers were added: YugabyteDB and SQreamDB

    Changes since 7.1.5:

    Problem with database list load was fixed (PostgreSQL, Redshift, MySQL, Oracle, SQL Server)
    Metadata editor: edit property form rendering was improved (non-applicable fields are hidden)
    Performance for table statistics reading was improved

    Data viewer:

    Column ordering was fixed (for custom SQL queries)
    UUID transform: version 2 support was added
    Default database name and default user name were added for many database drivers
    Data export: custom data type formatting support was fixed

    PostgreSQL:

    Cursor fetch was fixed
    Native client was upgraded to version 12
    Table OID support was fixed (PG 12)
    PgPass parser was improved (support for escaped characters was added)

    Oracle:

    Materialized view comment editor was fixed
    View definition reading was fixed (for non-DBA users)
    Table reading now uses DBA views (optional)
    Profile resources metadata reading was fixed
    MariaDB/MySQL: table column resolving was fixed
    CockroachDB: connectivity problem was fixed

    Greenplum:

    Metadata search was fixed (for procedures)
    Table metadata reading was fixed
    Dark theme support was improved (tab folders, toolbars)
    A large number of minor UI bugfixes

[close]

https://dbeaver.io/

[SiLæncer]

Whats new:>>

    Improved Connection Settings Wizard.
    Some diagnostic means have been added.
    Minor fixes.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

    Improved Connection Settings Wizard.
    Some diagnostic means have been added.
    Minor fixes.

https://sourceforge.net/projects/dbeauty/