Thema: Datenbanksoftware und Tools diverses ...

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

    Fixed an error when rearranging table windows.
    Added a "welcome" dialog for new users.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

    Performance issues with autocomplete have been fixed.

http://jailer.sourceforge.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

Changelog

    Import/Export JSON
    Built-in REST API web server
    fileio extension
    Fix bugs (issues #65, #67, #68, #69)
    Fix "Add table" dialog
    Minor changes

[close]

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

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

    Upd: Improve and fix issues related to Asynchronous Processing (7874)
    Upd: Optimize the interface and HiDPI high zoom ratio display issues (7874)
    Fix: (Access) Fix that the database cannot be [re]opened under Windows 7 (7874)
    Fix: (Access) Fix the password protection (MDB) database cannot be opened normally without ACE Provider (7874)
    Upd: MySQL component version updated toMySql.Data.dll 8.0.26 (2021/07)( )(7874)
       Fix: In order to be compatible with the old version of MySQL/MariaDB, it supports TLSv1.0 and TLSv1.1, so it returns 8.0.25 (7875)
    Upd: Others include cumulative small update, correction and optimization (7877)

- data Export ( the data Export ):

    the Add: (Firebird) .sql export formats, support for Single INSERT generated content (7877)
    Upd: improved .sql export formats Single INSERT option, data No longer display when the library does not support (7877)-Data

Import ( Data Import ):

    Upd: Optimize the import processing, and support the display of the average number of rows processed per second (Avg.rows/s) (7874) -Data Import

( Data Browser and Editor ):

    Upd: When advanced editing [ADV] the same data table, the new tab will not be opened repeatedly (7874)
-SQL Performance Analyzer ( SQL Profiler ):
    Upd: (SQLite) Improve the official Trace event output processing, automatically exclude a large number of repeated statement display (7874)
    Upd: A large number of code optimization processing (7874)-Database

Migration ( Database Migration ) (Pro):

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

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

The user interface of the data browser and SQL console has been made a bit more appealing.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

    Data transfer:

    Multi-row insert support was added
    Data transfer performance significantly improved
    Unnecessary commit/rollback in source connection were removed
    Table/column name case conversion was fixed
    Ambiguous column name mapping was fixed

    Data viewer:

    Data filter for enum data types was fixed
    Data edit support for queries with joins
    Row insert with default values support was added
    Timestamp value render: timezone configuration was added
    Value transformers: save last transformer configuration
    Cell color highlight add/reset was fixed
    Data refresh was fixed in multi-row record mode

    MySQL:

    TLS 1.0 and 1.1 support added
    User password change was fixed

    PostgreSQL:

    Bit string editor was fixed
    PG 13 backup/restore support was added
    Column rename DDL was fixed
    INSERT queries for OID data types were fixed
    Composite data type edit was fixed
    SQL Server: active schema selector was fixed
    Several minor UI bugs were fixed

[close]

https://dbeaver.io/

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

    Documentation improvements for 40.2 (#17303)
    Add Metabase Cloud link to admin settings for hosted instances (#17134)
    Fix dashboard card hovering buttons drag behaviour (#17130)
    Popover footer is displaced when using filter with a search input (#16830)
    Padding needed for button on map settings page (#16612)
    LDAP/Email settings gets cleared if validation fails (#16226)
    Modify instead of replace default EB nginx config (#5623)

    Bug fixes:

    Snippet folder permissions are always applied to root (#17268)
    Cannot start development in VS Code because of missing Node.js (#17233)
    Search widget on question builder hangs tab, API field search limit not respected (#17228)
    Only 50 groups are displayed (#17200)
    People search dropdown goes outside of the screen (#17186)
    Only 50 users shown in email autocomplete and "Other user's personal collection" (#17164)
    Dashboard - Adding ‘Click Behavior’ to an image field converts image to URL (#17161)
    Cannot upgrade to v0.40.x on AWS Elastic Beanstalk due to AWS Inspector not being available in certain regions (#17143)
    Elastic Beanstalk nginx config is not updated on latest EB docker images (#17115)
    Cannot deactivate users after the first 50 users (#17113)
    Tabs in the Audit section look broken (#17102)
    Duplication of the displayed table (#17060)
    Allow selecting text in Textbox cards, while dashboard is in edit-mode (#17039)
    Metabase on old AWS Elastic Beanstalk (Amazon Linux w/ old Docker) upgrade to 0.40 failed (#17012)
    Public Sharing footer is double-size because action buttons are stacked (#16798)
    Error when setting column type to Number in data model settings (#16781)
    Site URL can sometimes be incorrectly defined during startup (#16754)
    Serialization: Visualization column settings lost (#16150)
    Waterfall visualization does not work with ordinal X-axis (#15550)
    Clicking "Cancel" on collection archive modal should let you stay in that same collection (#15289)
    Snowflake Connector Requires Deprecated Region Id (#10142)

[close]

https://www.metabase.com/

[SiLæncer]

Whats new:>>

    Query shortcuts Alt+F1, Ctrl + 1, Ctrl + 2, ...
    Show help by Ctrl + Space
    Name for result tab (use -- before an query)
    Remove transform and math extensions
    Minor changes
    Fix minor bugs

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

[SiLæncer]

Changelog

-Data Import ( Data Import ):

    Add: Support Bulk Insert mode ( Bulk Insert mode ): Significantly improve the import processing speed (7890)
       Currently supports SQL Server/SQL Azure/NuoDB/IBM DB2/SQLite/PostgreSQL/MySQL/Firebird and other databases
    Upd : Optimize the processing speed of Batch Insert mode (7890)
    Fix: Improve the judgment of the end character (NullChar) to avoid generating empty columns (7890)

-Object Explorer ( Object Explorer ):

    Add: Support source table size information ( Table Size Information ) display (7890)
       Support SQL Server/Sybase ASE/PostgreSQL/MySQL/Oracle and other databases

-Main program update ( Main ):

    Add: The ROWS COUNT message display (7890) is added to the data table property page.
    Upd: Click to reset the data table to [automatically run] statistical data update processing (Table Statistics) (7890)
    Upd: Optimize the interface and HiDPI high zoom ratio display problem (7890)
    Add : Support MariaDB database backup and restore processing (7890)
    Fix: (MySQL/PostgreSQL) Fix the exception processing when additional files are not installed or the executable file cannot be found when performing database backup (7890)
    Upd: Oracle component version updated to Oracle .ManagedDataAccess.dll 19.12.0(2021/08/05) (7890)
    Upd: Update the .NET Additional Files Database ( 32bit / 64bit ) (2021/08/06) (7890)
    Upd: Other includes the cumulative minor updates, fixes and optimization (7890)

- data Export ( Data Export ):

    Add: (Oracle) .sql export format, support INSERT ALL to generate content (7890) -SQL History

( SQL History ):

    Upd: When the same SQL statement is executed continuously and repeatedly, only the first will be retained pen, to reduce unnecessary treatment record (7890)

- database migration ( database migration ) (Pro):

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

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

    Data Import ( Data Import ):

    Fix : Fix the low-level error that can not be used normally when the import function is converted to [Official Version] (affects including table editing) (7894)-SQL

    Editor ( SQL Editor ):

    Upd: (64bit) IntelliSense Parameter Info ( IntelliSense Parameter Info ): Right-click the mouse to close the prompt to avoid affecting the menu display (7894)-Main

    program update ( Main):

    Upd: Others include cumulative minor updates, corrections and optimizations (7894)

[close]

http://fishcodelib.com/Database.htm

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

    Added support to copy SQL from main window to query tool.
    Added support for formatted JSON viewer/editor when interacting with data in a JSON column.
    Housekeeping:
    Rename the “Resize by data?” to “Columns sized by” and disabled the ‘Maximum column width’ button if ‘Columns sized by’ is set to ‘Column data’.

    Bug fixes:

    Ensure that the login account should be locked after N number of attempts. N is configurable using the ‘MAX_LOGIN_ATTEMPTS’ parameter.
    Fixed CSRF errors for stale sessions by increasing the session expiration time for desktop mode.
    Fixed an issue in the search object when searching in ‘all types’ or ‘subscription’ if the user doesn’t have access to the subscription.
    Fixed an issue where paste is not working through Right-Click option on PSQL.
    Fixed TypeError ‘NoneType’ object is not sub scriptable.
    Fixed incorrect tablespace options in the drop-down for move objects dialog.
    Fixed an issue where the titles in query tabs are different.
    Fixed incorrect binary path issue when the user deletes the binary path from the preferences.
    Ensure that all the required options should be loaded when the Range data type is selected while creating a custom data type.
    Fixed dashboard server activity issue when active_since parameter is None.
    Fixed an issue where even if the user is locked, he can reset the password and can login into pgAdmin.

[close]

https://www.pgadmin.org/

[SiLæncer]

Whats new:>>

* Improve resizing (issue #71)
* Improve BLOB exports
* Drag-n-drop files to editor (issue #73)
* Export table or query result to Excel
* Rough query formatter by Ctrl + T
* Fix CSV import (issue #72)
* Fix bugs

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

[SiLæncer]

Whats new:>>

An error in the validation of database connections that have not been used for a long time has been corrected.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

-Automatic completion and perception ( AutoComplete and IntelliSense ):

    Upd: Improve the processing speed of auto-sensing lists, reduce unnecessary processing and avoid rearrangement problems (7898)
    Upd: Solve the problem of delayed processing of PageUp , PageDown , Home , and End buttons (7898)
    Fix: Fix Ctrl+ J When opening List Members, the highlighted text is not fully synchronized (7898)
    Fix: Fix (7890) the problem that other related objects in the table cannot be loaded after executing the preloaded table field (7898)-Object

browsing ( Object Explorer ):

    Fix : Fix the problem that the horizontal scrolling [Object function key] cannot be displayed normally (7898)
    Upd: Optimize the display of node prompt messages and solve the problem of excessively long and overlapping display content (7898)
    Fix: (SQL Server/SQL Azure) Fix the problem of abnormal display when browsing DBTRIGGERS objects (7898)-Main

program update ( Main ):

    Upd: (64bit) Support the latest PostgreSQL 14.0 beta3 database backup/restore processing (7898)
    Fix: Fix (7890) cause the object to be expanded The problem that the parameters will still be reorganized (the impact includes multiple points) (7898)

    Upd: Others include cumulative minor updates, corrections and optimization processing (7898)-Database
object search ( Search Database Objects ):

    Fix : Fix the problem that when the search object itself does not contain sub-objects, the object cannot be found when Sub-Objects is turned on (7898)
    Fix: Fix the problem that the window is forcibly closed during the search process (7898) )

- generate scripts ( generating scripts ):

    the Add: (SQL Server / SQL Azure / PostgreSQL) supports the generation of single DEFAULT CONSTRAINTS object syntax defined (7898)
    the Add: (VistaDB) supports the generation CHECK CONSTRAINTS object syntax definition (7898) alone

- Profile column viewing and editing (the data browser and editor ):

    Upd: (SQLite) data type time display and output in the same way datetime to meet the official definition of the way (7898)

- data import ( the data Import ):

    Fix:Amended import function on the turn [official version], resulting in a stupid mistake does not work properly (affecting contains data table editor) (7894)

- SQL editor ( SQL Editor ):

    Upd: (64bit) IntelliSense parameters message ( IntelliSense the Parameter Info ): Click the right mouse button to close the prompt to avoid affecting the menu display (7894)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

    SQL editor: action buttons tooltips were fixed (keyboard shortcuts)
    SQL Server: user management was added
    Oracle: View triggers read was fixed
    Procedure body read now re-established connection on demand
    Shell commands now support quoted parameters (Linux, MacOS)
    Debian/RPM package installers now use different directories for community and commercial versions
    Simple schema compare wizard UI was fixed
    SQL queries which contains passwords were removed from logs
    Driver editor dialog enhancements
    Minor UI bugfixes

    ERD editor:

    Properties panel was added for diagram elements
    Diagram drag tool was added
    Entity search UI was improved
    Diagram refresh now asks confirmation
    Table column navigation was fixed
    GraphML export was improved (notes, styles)
    Arrange diagram now respect grid alignment
    Export ERD in XML (.erd) format was added
    Cross-project entity drag-n-drop was restricted

    Data editor:

    Row insert with default values was improved
    Data filter popup now visualizes loading process
    Pin column now works for multiple selected columns
    Filters dialog now supports column pin/unpin
    Auto-complete in grouping panel was fixed
    Plaintext record mode switch was fixed
    Excel import was fixed (NULL cells support was added)

    PostgreSQL:

    Additional PostGIS data type support was added
    Connection user role handle was fixed

[close]

https://dbeaver.io/