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

- Transaction Mode ):

     Upd: Significantly rewrite and optimize the processing efficiency of the transaction mode, affecting multiple related functions (7734)
     Upd: Allow editing data ( Editing Data ) and search ( Search Table Data ) processing in the transaction mode (7734)
     Upd: Non-query tab Mode (Non-Query Tabs) are processed in non-transaction mode (7734)
     Upd:Enhance the interrupt handling, with non-transaction mode (7734)
     Upd: data import ( the Data Import ) and script file execution ( Script File Execution ) is added to close the transaction mode prompt treatment (7734)
     Fix: (Access) Provider amended version compatibility Sexual issues (7734)
     Fix: (Firebird) Fix the problem that the Execution Plan cannot be displayed completely (7734)
     Fix: (PostgreSQL/SQL Server/SQL Azure) Fix the exception handling problem when the transaction mode executes the wrong syntax (7734)
     Fix: Fix the SessionID acquisition problem, affecting related functions (7734)

     Fix: Fix the problem that may cause abnormal exit when establishing a connection failure (7734)-Main
program update ( Main ):

     Upd: Improve analysis SQL and binding variables (Parsing SQL and Binding Variables) Test processing speed (7734)
     Upd: Avoid the problem of abnormalities caused by repeated clicks on the connection during the connection process (7734)
     Upd: Secure Shell protocol ( SSH: Secure Shell ) components to update Renci.SshNet.dll 2020.0.1 (2021/01/24) (7734)
     Upd: filtering and servo version of the database schema ( Filtering Databases and Schemas ): Automatic processing added over detection avoid having to wait too long (7734)
     Upd: improved relative path (relative path) processing mode (7734)
     Upd: other comprising accumulated small update, modification and optimization (7734)

- to generate script ( generating the scripts ):

     Upd: (PostgreSQL) Add REFERENCING and WHEN condition generation display (7734)
     Fix: (SQL Server/SQL Azure) Fix the problem that the field Nullable status cannot be obtained correctly when the table name starts with _ (7734)-Database

migration ( Database Migration )(Pro):

     Upd:All updates are the same as dbMigration .NET software (7734)

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

    Breadcrumbs can be confusing (the current one "seems" clickable when it's not) (#14879)
    Difficult to see which cells has "Click behavior" vs normal behavior (#13548)

    Bug fixes:

    Serialization dump of aggregated questions are not copied over on load (#15048)
    Serialization doesn't update Sub-Query variable reference (#15047)
    Oracle, BigQuery filtering by column with day-of-week bucketing not working (#15044)
    Pivot Table export not working on unsaved questions (#15027)
    Pivot Table does not work for users without data permissions (#14989)
    Pivot Table not working with Sandboxed user (#14969)
    BigQuery: Joins in the query builder generate invalid table aliases (#14933)
    BigQuery: Question Stays running until timeout when query is error in Native Query (#14918)
    Serialization: Archived items are included in dump (#14911)
    regexextract breaks query on sandboxed table (#14873)
    Multi-level aggregations fails when filter is the last section (#14872)
    Pivot queries aren't recorded to query execution log (#14765)
    Start of Week not applied to Field Filter in Native question, which can lead to incorrect results (#14294)
    In Safari 14, add-grouping button disappears randomly but consistently (#14131)
    Serialization does not initialize 3rd party drivers when loading a dump (#13614)
    Wrong day names are displayed when using not-Sunday as start of the week and grouping by "Day of week" (#13604)
    Object Detail previous/next buttons not working correctly (#13250)
    Global number formatting does not apply to percentages (#12659)
    Native question filter widget reordering doesn't work (#9357)

[close]

https://www.metabase.com/

[SiLæncer]

Changelog

    Main program update ( Main ):

    Add: Main menu integrates functions such as Tab Name and Context Menu (7744)
    Add: Main taskbar integrates close and tab switching (Close/Previous/Next Tab) functions (7744)
    Upd: The Recent connections menu supports scrolling processing to avoid excessively long display (7744)
    Upd: The query tab menu is moved to the sub-option (Window->Tabs), and scrolling processing is supported at the same time to avoid excessively long display ( 7744)
    Upd:The recently closed tabs drop-down menu supports scrolling to avoid excessive display (7744)
    Fix: Fix the problem that the Tooltips cannot be redisplayed after executing the menu sub-functions (7744)
    Upd: Others cumulative contains minor updates, correction and optimization (7744)

    vertical tag mode ( vertical Tabs mode ) (64bit):

    the Add: redesigned vertical mode label ( redesign vertical Tabs mode ): displays more intuitive, more convenient operation (7744)
    Add: Support label placement and movement processing ( ALT must be pressed) (7744)
    Add: Support label index number (IndexNumber) display (7744)
    Upd: Completely replace no longer display horizontal labels at the same time (7744)
    Upd: Update and optimize label color , Text style and prompt display (7744)-Query

    Tabs:

    Add:Increase the label auto-scaling setting option (Rename->Enable AutoResize Tabs: On/Off) (7744)
    Fix: Fix (7716) the problem that may cause the index label data type and name sort processing to be invalid (7744)
    Fix: The title name length is 1 when issues related amendments (7744)

    Compare query ( comparison query ):

    Upd: allows segmentation query mode with the float query mode back and forth to switch directly (7744)

    row editing (the data editor ):

    the Add: In addition to the original GUID type, increase Character type [VAR]CHAR(36) Support ( GUID Generator )(7744)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

    Fix a bug in the new DROP COLUMN feature when used on columns that are indexed and that are quoted in the index definition.
    Documentation improvements.

[close]

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

[SiLæncer]

Changelog

    Fix a problem in the appendvfs.c extension that was introduced into version 3.35.0.
    Ensure that date/time functions with no arguments (which generate responses that depend on the current time) are treated as non-deterministic functions. Ticket 2c6c8689fb5f3d2f
    Fix a problem in the sqldiff utility program having to do with unusual whitespace characters in a virtual table definition.
    Limit the new UNION ALL optimization described by item 8c in the 3.35.0 release so that it does not try to make too many new subqueries

[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

Changelog

    Fixed "(Minor) Dropdown menu disabling inconsistency"
    Fixed "Parameters not working when using complex filters"
    Minor fixes and improvements

    SQL Console and desktop improvements:

    Queries are now subjected to intensive analysis, which makes it possible to detect primary and foreign keys and display them accordingly, as well as the origin table of each column.
    Number data is now formatted and right-aligned.
    Faster metadata acquisition with Oracle DBMS

[close]

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

    Connection management:

    Automatic ending of idle transactions was added
    Network profiles configuration page was fixed
    Filters in the connection selector dialog were fixed

    Data transfer:

    Possibility to disable foreign keys was added (PostgreSQL, Oracle)
    Numeric data types mappings were improved
    “Skip all errors” button added in the error dialog

    Metadata editor:

    Column delete now checks for dependent objects
    Constraint/index create command now available in the columns edit tab
    Problem with deleted object dup was fixed

    SQL editor:

    Script selector popup panel UIX was improved
    Hex constants and scientific numbers formatting was fixed
    Columns alias generation was improved
    Multi-line comments support was fixed

    Data editor:

    Column filter UI was improved (value count column)
    Extra configuration was added to SQL script generator
    Better support of IE browser in the spatial viewer (GIS)
    Virtual columns support (rows add/delete) was fixed
    Cells selection was fixed (MacOS)

    ERD:

    Export as image: image cropping problem was fixed
    Export in SVG format was improved
    Diagram save now forces UTF encoding
    Tables coloring was fixed
    Show/hide system object option is now respected
    Print command enablement was fixed

    PostgreSQL:

    PgBouncer support was fixed (problem with prepared statements)
    Data types read queries were fixed for older (8.4 and earlier) versions
    Role permissions editor was fixed
    Infinity timestamp values support was added
    Auto-generated columns support was added
    Role name DDL was fixed

    Teradata:

    Triggers management was added
    Views metadata read was fixed

    Clickhouse:

    Table data edit support was added
    Tables and indexed create/drop DDL was fixed

    Firebird:

    Procedure parameters’ default value read was fixed
    View metadata read was improved
    Automatic app version upgrade was implemented
    Notification popup rendering in dark theme was fixed
    Perspective customization UI was fixed
    Informix: foreign key DDL was fixed
    Sybase IQ support (server version detection) was fixed
    Vertica: view create/edit was fixed
    Data Virtuality driver was added (thanks to @sebcom-gmbh)
    Preferences localization was updated

[close]

https://dbeaver.io/

[SiLæncer]

Changelog

    Fixed "(Minor) Dropdown menu disabling inconsistency" #40
    Fixed "Parameters not working when using complex filters" #41
    New logo.
    Minor fixes and improvements.

    SQL Console and desktop improvements:

    Queries are now subjected to intensive analysis,
    which makes it possible to detect primary and foreign keys and display them accordingly,
    as well as the origin table of each column.
    Number data is now formatted and right-aligned.
    Faster metadata acquisition with Oracle DBMS.

[close]

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

    New features:

    Issue #5404 - Show the login roles that are members of a group role be shown when examining a group role.
    Issue #6212 - Make the container distribution a multi-arch build with x86_64 and Arm64 support.
    Issue #6268 - Make ‘kerberos’ an optional feature in the Python wheel, to avoid the need to install MIT Kerberos on the system by default.
    Issue #6270 - Added ‘–replace’ option in Import server to replace the list of servers with the newly imported one.
    Issue #6271 - Added zoom scaling options with keyboard shortcuts in runtime.

    Housekeeping:

    Issue #3976 - Use schema qualification while accessing the catalog objects.
    Issue #6176 - Make the ‘Save Data Changes’ icon to be more intuitive.

    Bug fixes:

    Issue #4014 - Fixed alignment issue under preferences for the German language.
    Issue #4020 - Fixed color issue on the statistics tab for collection node in the safari browser.
    Issue #4438 - Fixed an issue where adding/updating records fails if the table name contains percent sign.
    Issue #4784 - Ensure that autovacuum and analyze scale factors should be editable with more than two decimals.
    Issue #4847 - Fixed an issue where % displayed twice in explain analyze for query and table.
    Issue #4849 - Rename text ‘table’ with ‘relation’ in the statistic tab for explain analyze.
    Issue #4959 - Fixed an issue where the properties tab for collection nodes is unresponsive after switching the tabs.
    Issue #5073 - Fixed an issue where the Save button is enabled for functions/procedures by default when open the properties dialog.
    Issue #5119 - Fixed an issue where hanging symlinks in a directory cause select file dialog to break.
    Issue #5467 - Allow underscores in the Windows installation path.
    Issue #5628 - Remove the “launch now” option in the Windows installer, as UAC could cause it to run as an elevated user.
    Issue #5810 - Ensure that cell content being auto selected when editing the cell data.
    Issue #5869 - Ensure that SQL formatter should not add extra tabs and format the SQL correctly.
    Issue #6018 - Fixed encoding issue when database encoding set to SQL_ASCII and name of the column is in ASCII character.
    Issue #6159 - Ensure that the user should be able to kill the session from Dashboard if the user has a ‘pg_signal_backend’ role.
    Issue #6206 - Ensure that the view/edit data panel should not be opened for unsupported nodes using the keyboard shortcut.
    Issue #6227 - Ensure PGADMIN_DEFAULT_EMAIL looks sane when initialising a container deployment.
    Issue #6228 - Improve the web setup script for Linux to make the platform detection more robust and overrideable.
    Issue #6233 - Ensure that SQL formatter should not use tab size if ‘Use spaces?’ set to false.
    Issue #6253 - Fixed an issue where the user is unable to create a subscription if the host/IP address for connection is 127.0.0.1.
    Issue #6259 - Ensure that proper error message should be shown on the properties and statistics tab in case of insufficient privileges for a subscription.
    Issue #6260 - Fixed an issue where the ‘Create Slot’ option is disabled in case of the same IP/host provided but the port is different.
    Issue #6269 - Ensure the Python interpreter used by the runtime ignores user site-packages.
    Issue #6272 - Fixed an issue where the user is not able to change the connection in Query Tool when any SQL file is opened.
    Issue #6279 - Ensure that the venv activation scripts have the correct path in them on Linux.
    Issue #6281 - Fixed an issue where schema diff showing wrong SQL when comparing triggers with different when clause.
    Issue #6286 - Ensure that the template database should be visible while creating the database.
    Issue #6292 - Fixed string index out of range error where the dependent tab is in focus and selecting any publication or table.
    Issue #6294 - Fixed an issue where the dependent tab throwing an error when selecting any login/group role.
    Issue #6307 - Fixed an issue where the incorrect values visible in the dependents tab for publication.
    Issue #6312 - Fixed an issue where copy/paste rows in view data paste the wrong value for boolean type.
    Issue #6316 - Ensure that the primary key should be visible properly in the table dialog.
    Issue #6317 - Ensure that toggle buttons are accessible by most screen readers.
    Issue #6322 - Fixed an issue where the top menu disappears when entering into the full screen for minimum screen resolution.
    Issue #6323 - Ensure that the grantor name should be visible properly for the security tab in the table dialog.

[close]

https://www.pgadmin.org/

[SiLæncer]

Changelog

    Enhance the OP_OpenDup opcode of the bytecode engine so that it works even if the cursor being duplicated itself came from OP_OpenDup. Fix for ticket bb8a9fd4a9b7fce5. This problem only came to light due to the recent MATERIALIZED hint enhancement.
    When materializing correlated common table expressions, do so separately for each use case, as that is required for correctness. This fixes a problem that was introduced by the MATERIALIZED hint enhancement.
    Fix a problem in the filename normalizer of the unix VFS.
    Fix the "box" output mode in the CLI so that it works with statements that returns one or more rows of zero columns (such as PRAGMA incremental_vacuum). Forum post afbbcb5b72.
    Improvements to error messages generated by faulty common table expressions. Forum post aa5a0431c99e.
    Fix some incorrect assert() statements.
    Fix to the SELECT statement syntax diagram so that the FROM clause syntax is shown correctly. Forum post 9ed02582fe.
    Fix the EBCDIC character classifier so that it understands newlines as whitespace. Forum post 58540ce22dcd.
    Improvements the xBestIndex method in the implementation of the (unsupported) wholenumber virtual table extension so that it does a better job of convincing the query planner to avoid trying to materialize a table with an infinite number of rows.

[close]

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

[SiLæncer]

Changelog

-Main program update ( Main ): Fix: Fix (7716) In a specific database, if the last line of the statement is a one-line comment (--), an exception may occur (.NET's bug??) (7761) Fix: Fix (7744) causes Jet< ->The problem that the automatic switching ability of the ACE driver does not work (7761) Fix: Fix the problem that the taskbar is displayed abnormally when the data bar is minimized and then restored under editing (7761) Add: Add the display or hide the explorer panel button to the taskbar ( 7761) Upd: Optimize HiDPI high zoom ratio display(7761)
     Upd: (SQLite 3.35+) SQL References and Reserved Words add support for Math functions (7761)
     Upd: SQLite component version updated to System.Data.SQLite.DLL 1.0.114.0 (3.35.3) (2021/03/30)( 7761)
     Upd: Oracle component version updated to Oracle.ManagedDataAccess.dll 19.11.0 (2021/03/05)(7761)
     Upd: VistaDB component version updated to VistaDB.6.dll 6.1.2 (2021/02/28)( 7761)
     Upd: Others include cumulative minor updates, corrections and optimizations (7761) -SQL Editor
( SQL Editor ):
     Add: Added toggle folding function (Format->[T]Toggle All Foldings: Alt + T, Toggle Folding: Alt + F ) (7761)
     Fix: Change the problem is not synchronized updated after enabling the folding feature set (7761)
- data table design ( the Table Designer ):
     Upd: (SQLite 3.35+) supports native field delete (DROP the cOLUMN) processing (7761)
     Upd: (the SQLite 3.30+) native support columns renamed (rENAME cOLUMN) processing (7761)
- the script generator ( Script generator ):
     the Add: the master node supporting section check status display (7761)
- filtering and sorting field names ( filtering and the sorting the columns ):
     Upd: optimization and highlighted search results display only consistent field (7761)
- vertical label mode ( vertical Number of Tabs mode ) (64bit):
     Fix:Fixes tab asked to put mobile relevance (7761)
- Database Migration ( Database Migration ) (Pro):
     Upd: all updates with dbMigration .NET software (7761)

[close]

http://fishcodelib.com/Database.htm

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

    Ability to specify names of sheets for multi-table exporting to XLSX format. This is especially useful when exporting multiple table to one file. [Enterprise edition]
    Minor interface improvements and bug fixes.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

    Fix a defect in the query planner optimization identified by item 8b above. Ticket de7db14784a08053.
    Fix a defect in the new RETURNING syntax. Ticket 132994c8b1063bfb.
    Fix the new RETURNING feature so that it raises an error if one of the terms in the RETURNING clause references a unknown table, instead of silently ignoring that error.
    Fix an assertion associated with aggregate function processing that was incorrectly triggered by the push-down optimization.

[close]

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

[SiLæncer]

Changelog

    Further desktop improvements:

    Single-row views are now directly editable. It is also possible to search for columns within them.
    The metadata view has been simplified and made clearer.
    rowid/tid pseudo columns are used to identify a row when the table has no primary key.
    An error in the row count query has been corrected.

[close]

http://jailer.sourceforge.net/

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

    Overflow text on Ask a question page (#15439)
    Frontend load issue: SMTP Email (#12692)
    Add Bitcoin as a unit of currency (#11406)
    Line chart dots don't have cursor: pointer when hovering (#5056)

    Bug fixes:

    Filtering on coerced column doesn't always know its coerced (#15317)
    Wrong series label in multiple series scatterplot (#15150)
    Dashboard Subscription fails for all SQL questions with a Field Filter on date column connected on dashboard (#15067)
    Dashboard Subscription Emails do not work with filtered Native Queries (#15066)
    Dashboard Subscription sidebar broken for Sandboxed users (#14990)
    Provide more logging information on permission errors when creating Cards (#14931)
    In Settings > Email, Save Changes is enabled even when there are no changes (#14749)
    Exports always uses UTC as timezone instead of the selected Report Timezone (#13677)
    Invalid Redirect Location After SAML Sign-in via Full App Embed (#13666)
    Cannot download XLSX if there's more than 1 million results (#13585)
    Pie chart sometimes does not show total (#12506)
    Users with collections "edit" permissions and no data access permissions can't edit question metadata (#11719)
    Column "Custom title" not working in tooltips (#11395)
    Schema sync does not update changes in column type case (#7923)
    Error on visualization change of a question with SQL queries view only permission (#6718)

[close]

https://www.metabase.com/