Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Whats new:>>

Fix a bug in the IN operator that was introduced by an attempted optimization in version 3.27.0. Ticket df46dfb631f75694
Fix a bug causing a crash when a window function is misused. Ticket 4feb3159c6bc3f7e33959.
Fix various documentation typos

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

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

Minor improvements in data grid.

http://www.vlsoftware.net/

[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

Update built-in DISQLite3 engine to SQLite 3.27.2.
Add the PREFIXES extension:
prefixes() table-valued SQL function.
Example: SELECT prefixes('abcdefg');
prefix_length() SQL function.
Example: SELECT prefix_length('abcdxxx', 'abcyy'); yields 3.
Add the IsoWeek() and IsoWeekYear() SQL functions. Right now, they accept a date in exactly YYYY-MM-DD string format only.
SELECT IsoWeek('2019-01-01');
SELECT IsoWeekYear('2019-01-01');
Add the SQLAR extension.
Add the ZIPFILE extension.
Pull syntax highlighter keywords and function names from SQLite3.
Fix an AV when trying to edit a table with no result rows.

[close]

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

[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: greatly optimize the user interface (User Interface) control and text font display (7002)
Add: Query Tab Menu Adding Query Tabs (7002)
Add: Query tab page menu to add R Close tabs to the right (7002)
Upd: Others include cumulative small updates, corrections and optimizations (7002)
SQL Editor ( SQL Editor ):
Add: Supports cursor text uppercase (Uppercase: Ctrl + U ) and lowercase (Lowercase: Ctrl + L ) conversion processing, no need to select (7002)
Add: Right-click menu search (Find) to increase the uppercase and lowercase sub-options ( U Uppercase and L Lowercase) (7002)
Add: Right click on the menu to add the restore and redo suboptions ( U Undo and R Redo) (7002)
Data Editor and Browser :
Fix: Resolve an issue that is abnormally slow if you cannot read data from a database type such as System.Decimal or System.DateTime (7002)
Object Navigator :
Fix: Click the middle mouse button to browse and solve the problem that cannot be executed when the focus is not fixed (7002)
Generating Scripts :
Upd: Optimize and improve multiple database objects to create new sample generation content (7002)
Cell Viewer :
Upd: Browse BLOB content: 1. Add AUTO to automatically select the format, 2. Maintain the selected format display when switching (7002)
Database Migration (Pro):
Upd: All updates are the same as dbMigration .NET Software (7002)

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

Minor bug fixes.

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

https://www.pgadmin.org/

[SiLæncer]

Changelog

Changes since 5.0:

    Added support for different cloud databases in AWS and Azure,
    Significantly improved support for PostgreSQL and SQL Server
    Increased number supported drivers to more than 70.
    Renovated connection wizard and data migration tools.
    Added analytical panels, customizable dashboards, mock data generators, SQL debugger.
    Modernized UI, significantly improved dark theme support
    Closed more than 1600 issues on GitHub.
    And a lot of other things Thank you for your support!

Changes since 5.3.5:

    Navigator:
        Filters were fixed for multi-database drivers (PostgreSQL, SQL Server)
        Folders management was improved (move, drag-n-drop, etc)
        Scripts ordering was fixed
    Data view:
        Multiple cells editor was fixed (performance)
        Plain text presentation was improved
        Context menus were fixed
    PostgreSQL:
        Views dependencies tab was added
        Composite data types rendering and editing was fixed
        GIS data types rendering was fixed
        Table columns collation support was added
        Geometry type and SRID are shown in DDL
        Support of triggers delete was added
    SQL Server:
        Tables DDL generation was improved
        Column default values render was fixed
    Sybase procedures loading was fixed
    BigQuery: error position discovery was added
    Generic driver: JDBC URL
    Dashboards rendering was fixed
    ERD: rendering was fixed (IDEF1X compatibility)
    Tools editor opening was fixed (sessions, locks)
    CSV import: support of custom data/tme format was added
    SQL editor colors were updated for dark theme
    Multiple shortcuts were fixed
    CrateDB driver was added
    Elasticsearch driver was fixed (6.6 compatibility)
    Some icons in UI were updated
    A lot of minor UI fixes

[close]

https://dbeaver.io/

[SiLæncer]

MDB Viewer Plus is a tabbed viewer/editor for Access MDB files. It provides a quick and easy way to create, view, edit and search/querry MDB files without having Microsoft Access installed. It is not a full database development solution but allows you to view/edit MDB files without an Access license.

Imports and exports to a variety of formats.

License: Freeware

http://www.alexnolan.net/software/mdb_viewer_plus.htm

[SiLæncer]

Whats new:>>

Column order in the display can be defined not only globally but also for each table.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

- Find in the field ( Find In Grid ):

Greatly rewritten, directly highlighted after inputting the search, the query speed is several times faster than the original processing (7016)
Integration into the query result list / edit result list / search data table result list / SQL performance analyzer / SQL file version control management / SQL history record ... and other functions (7016)

- Main program update ( Main ):

Add: Support search word [bottom line hint] display, including [object and connection] node search (7016)
Add: Add Show or Hide Results Panel Shortcut Keys : (Show or hide the results pane: F10 )(7016)
Upd: Detailed optimization of user interface (User Interface) controls and text font display (7016)
Upd: Update Security Protocol ( Tls11/Tls12 /Tls/Ssl3) (7016)
Upd: (Firebird) Improved INSERT (...) RETURNING (...) Unable to get back the value (7016)
Upd: (Firebird) Improve user login account case sensitivity (7016)
Upd: SQLite component version updated to System.Data.SQLite.DLL 1.0.110.0 (3.27.2) (2019/03/04) (7016)
Upd: IBM DB2/Informix component version updated to IBM.Data.DB2.dll 9.7.4.4 (11.1.4041.4) (2019/03/06) (7016)
Misc: (IBM DB2/Informix) IBM Data Server Client Packages Version 11.1.4 Fix Pack 4a (2019/03/06)
Upd: Others include cumulative small updates, corrections and optimizations (7016)

- Connection Explorer :

Add: Add Clear Button and Shortcut Key: Esc (7016)
Fix: Resolve an issue where the database or path contains exception characters (including: Connection Profile and Connection Manager ) (7016)

- Quick Filtering Objects :

Add: Add Shortcut Key: Esc (7016)

- Database Diagram :

Add: Add data table association syntax prompt message display (7016)

- AutoComplete and IntelliSense :

Upd: Improve new and optimized member list response speed (7016)

- Database Migration (Pro):

Upd: All updates are the same as dbMigration .NET Software (7016)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

- Find in the field ( Find In Grid ):
Add: Support for Find Next and Find Previous button processing:
Add: Support shortcut key processing ( Shutcut Keys ):
Get Focus: Enter : Get the first position after input
Find Next: F3 : Find the next one, Find Previous: Shift+F3 : Find the previous one
Upd: Update the highlight background color to more clearly distinguish the selected background from the search highlight background
Upd: Clear search status by color
- Search Database Objects :
Upd: Redesigned ( Redesign ), support multiple search database type
Upd: Added to the Database Tools menu
- Data Browser :
Upd: Update the result list label name, replace the original database with a number
- Data Editor :
Fix: Fix and update replaces the function in the field ( Replace In Grid )
Fix: Fix and update status column message display and related issues
Fix: Fixed issue of conditional filtering (or re-brushing) control release
- Main program update ( Main ):
Upd: Detail Optimized User Interface
Upd: (SQLite) Modify the way to open the network disk database connection (only for new)
Upd: Others include cumulative small updates, corrections and optimizations

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

            - Eclipse 2018-12 is now the default platform
            - 32-bit versions were obsoleted
            - Charts colors configuration
            - Navigator resource folders visibility configuration
            - Mock data: new random texts generators were added
            - Data editor: inline editor focus handler was fixed
            - Plaintext format: show Western European characters
            - Data transfer: new connection close fix
            - Snowflake: tables and columns comments edit support was added
            - Oracle:
                - Session manager now tracks global sessions (RAC)
                - Procedures/packages save/compile command was fixed
            - PostgreSQL:
                - Multi-tenant  databases support was improved
                - Database description reading was added
            - MySQL: execution plan build fix

[close]

https://dbeaver.io/

[SiLæncer]

Whats new:>>

The table from which the navigation starts can now be changed at any time in the data browser.
Improved data browser performance.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

Server Objects (64bit/ Exclusive Features ):
Add: (SQL Server 2008+) Support for Linked Servers (7033)
Add: (PostgreSQL 9.1+) Support for External Servers ( Foreign Servers ) (7033)
Add: (Oracle 10+) Support Database Links (7033)
Main program update ( Main ):
Add: Support home page shortcut key processing ( Shortcut Keys ): (7033)
Object Explorer: Ctrl+1 , Code Manager: Ctrl+2 , SQL References: Ctrl+3 , Server Objects: Ctrl+4
Add: (Access) Supports Pass-Through Queries Object Display (7033)
Upd: Others include cumulative small updates, corrections and optimizations (7033)
Auto Filter Data :
Add: When the preset 500 totals are exceeded, the prompt will be displayed and the summary number switching selection will be provided (7033)
Upd: 1. Support the shortcut key after the selection, 2. Increase the display processing speed (7033)
AutoComplete and IntelliSense :
Fix: Fix the problem of displaying an exception after moving the up and down keys after displaying the member list (7033)
SQL Editor ( SQL Editor ):
Add: Support for selecting single word shortcuts ( Select Word : Ctrl + W ) (7033)
Database Migration (Pro):
Upd: All updates are the same as dbMigration .NET Software (7033)

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

- Minor bug fixes.

http://jailer.sourceforge.net/