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

    New command line parameters to simplify database connection.
    Minor changes and bugfixes.

http://www.vlsoftware.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:>>

    Fixed https://github.com/Wisser/Jailer/issues/22
    Updated the SQLite JDBC driver.
    A new wizard for JDBC URL settings has been created.

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

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

    Updated the SQLite JDBC driver.
    A new wizard for JDBC URL settings has been created.

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

-Main program update ( Main ):

Add: (64bit) Supports IntelliSense Parameter Info (7274)
Supports [all] database systems containing objects such as FUNCTIONS / PROCEDURES
Support to display when AutoComplete [selected] objects
Support to display when SQL Editor [click] object name
Upd: Wait for status window to add informative message display (7274)
Upd: Others include cumulative minor updates, corrections and optimizations (7274)

-AutoComplete and IntelliSense :

Upd: When the inserted item contains blank characters, add the front object name automatic judgment processing (7274)
Fix: (IBM DB2 / NuoDB / Oracle) Fix removing parameter count / x processing after inserting objects (7274)

-SQL Editor :

Fix: Resolve indentation (Increase / Decrease Indent) exception handling (7274)

-Data Import :

Add: Add Excel Workbook (* .xlsx) import format (7274)
Upd: Update toolbar and enable status (7274)
Fix: Fixed the issue that Empty As Null is not updated when importing preview in XML format (7274)

-Data Editor :

Upd: Re-support the sort processing of click fields, solve the problem of editing data rows after sorting (7274)

-Generating Scripts :

Fix: Fix the problem of object name update processing after generating DDL (7274)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

            - SSH Agent support was added (pageant and ssh-agent)
            - Disconnect project/folder/all actions were reworked
            - Problem with connection properties save was fixed
            - Connection properties dialogs UI was improved (test connection, password save, pref page search)
            - Task management UI was improved (task create/save actions in data transfer wizard)
            - ER diagrams: dummy errors are now suppressed (now they present in log file only)
            - Legacy Eclipse plugins installation support was added (with hold update site format)
            - Dark theme support was significantly improved
            - Auto-commit mode behavior change:
                - Toolbar toggle now affects current connection only
                - Mode change affects active DBeaver session only
            - Data export:
                - Export from SQL script now supports commands (@set and others)
                - Saved settings loading was fixed
                - XLSX exporter now respects export configuration
            - Data editor:
                - Fetch size can be changed before query execute
                - Spatial viewer now supports different pluggable tiles (mapbox, osm, etc)
                - Wrong date/time format now treated as error
            - SQL Editor: editor layout now saved between DBeaver sessions
            - Object editor (tables, views, etc) now checks for object name duplicates
            - Oracle: now we use full type name presentation by default
            - PostgreSQL: support of extra type aliases and array data types was added
            - CockroachDB: native CDB data types were added
            - Impala: active schema change support was added
            - A lot of minor UI/DB-specific bug fixes

[close]

https://dbeaver.io/

[SiLæncer]

Whats new:>>

  - Support for nullable primary key columns.
    This simplifies the definition of pseudo-primary keys for tables without keys.
  - "Limit" parameter as a safeguard for exports. https://github.com/Wisser/Jailer/issues/24

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

Whats new:>>

Important security fix for Google Auth login

https://www.metabase.com/

[SiLæncer]

Changelog

-Main program update ( Main ):
Add: increase settings [self] backup and repair processing (7289)
Upd: data table generation query statement supports formatting (expandCommaLists) (7289)
Upd: (SQLite) Modify the password detection method to solve the compatibility problem of database opening (7289)
Upd: Others include cumulative minor updates, corrections and optimizations (7289)
-Transaction Mode :
Add: (64bit) Support Comparison Query Processing (7289)
Add: Messages Tab: Added display processing when clicking on Commit and Rollback transactions (7289)
-Object Explorer :
Add: Object (KEYS) prompt message to add dependent field display (7289)
Fix: Fix the problem when COLUMN NAME is the same as DOMAIN NAME (including multiple updates) (7289)
-Generating Scripts :
Fix: (Firebird) Fix the display order when the field contains COLLATE and PRIMARY KEY (7289)
-AutoComplete and IntelliSense :
Upd: Refresh column caches (

• Refresh column caches): Support shortcut key processing ( Shortcut Keys : Ctrl + Shift + R ) (7289)

-Database Migration (Pro):
Upd: All updates are the same as dbMigration .NET Softwares (7289)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

    Support for nullable primary key columns.
    This simplifies the definition of pseudo-primary keys for tables without keys.
    "Limit" parameter as a safeguard for exports. #24

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

New features and enhancements in this version:

    Theme preview in preferences dialog
    "Library" dropdown in session manager, to enhance support for older and newer MySQL and MariaDB versions
    Various new shortcuts in the "Go to" menu, e.g. for switching between result and query area
    Support newer plink versions for SSH tunneled connections
    Grid rightclick on cell: "Open in webbrowser" for fields containing a web url
    Support for client_ed25519 MariaDB plugin
    Support for SSH tunneled connections to PostgreSQL servers
    Support for SSL on PostgreSQL servers
    "Same text" background color in grid now applies to neigbour fields in selected row as well
    Support for connections to Amazon Redshift (basically older PostgreSQL servers)
    Restored query tabs also restore bind parameters
    New option in grid export dialog: "Remove linebreaks from data"
    New option to remove DEFINER clauses in SQL export option drop-down
    Increase compatibility of table editor on PostgreSQL

Bugfixes:

    Reverts earlier attempts for native high DPI support, so scaling is done by Windows again (blurry but less buggy)
    Auto-detected Chinese localization fixed
    Compatibility to MySQL 4 restored
    Various fixes for SSL on MySQL and MariaDB
    Fixed broken "undo" after auto-uppercased SQL keyword
    Fixed crash when switching to table/database with same name on different server
    Fixed invisible column comments on PostgreSQL
    Fixed unsupported def.adsrc on PostgreSQL 12
    Ctrl+Backspace in text boxes deletes left word, instead of writing cryptic character
    Fixed update SQL for JSON columns in PostgreSQL
    Fixed disappearing table comments after saving
    Fixed warning about unsafe query when fooled with a commented WHERE clause

[close]

http://www.heidisql.com/

[SiLæncer]

Whats new:>>

    Function 'char' for expression engine.
    Minor improvements and bugfixes for exporting data to SQL Server, PostgreSQL.
    Extended application of some export error handling options.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

    SQL editor:
        Active database/schema change now affects current editor only
        Server-side output now works with huge outputs
        New command @unset was introduced
        Table alias generation was fixed (conflicts with SQL keywords were fixed)
        Query parameters dialog now doesn’t appear on scrolling/refresh
        Code templates now saved in utf-8
    Data editor:
        Smart option “Use all columns” for virtual identifier
        Inline cell editor now uses the same font as in grid
        Decimal values formatting was fixed
    Data transfer:
        Selected rows/columns option support was fixed
        CSV import was fixed
        Export to single file was fixed (timestamp pattern)
        Export from query now works with variables
    Transaction log/query manager: dark theme support was fixed
    Dashboards + timeseries + minute interval support was fixed
    SSH with private key + password support was fixed
    Extra locales (pt and ru) support was added in bundled JDK
    SAP HANA: GIS/spatial data type viewer support was added (thanks to @stefanuhrig)
    Presto: metadata reading was improved (dummy errors suppressed)
    AWS Athena: URL template now respected in new connections
    MySQL:
        Database backup can be saved as task now
        Events editor (DDL) was fixed
    PostgreSQL:
        Connection dialog was improved (new tab was added)
        $$ and $tag$ parser was improved (new config options were added)
        JSON and struct data types support was fixed
    DB2: table truncate command was fixed
    Oracle: new function DDL was fixed
    Snap repository dbeaver-ce is now official. We will update it on every version release
    A lot of minor bugs were fixed
    Merry Christmas and Happy New Year!

[close]

https://dbeaver.io/

[SiLæncer]

Changelog

-Data Browser and Editor :
Add: (SQLite) Support Julian day and Unix Time to ISO8601 automatic conversion date type processing (7297)
Add: (SQLite) Support yyyy / mm / dd and yyyy.mm.dd to yyyy-mm-dd (ISO8601) Automatic conversion date format processing (7297)
Fix: (Oracle) Fix TimeStampTZ display format problem in edit mode (7297)
Fix: (Oracle) Solve the problem that TimeStampTZ data content does not include TimeZone (7297)
Fix: (Oracle) Fix the actual defined length of Millisecond output in TimeStampTZ (7297)
Upd: Optimize data display speed (7297)
Fix: Fix the problem that the field data type (TimeStampTZ) cannot be edited (7297)
-Main program update ( Main ):
Fix: (FoxPro) Solve the problem that the built-in GetSchema cannot distinguish the Character / Varchar field type correctly (7297)
Fix: (SQLite) After setting some connection properties, the database with password could not be opened (7297)
Upd: Others include cumulative minor updates, corrections and optimizations (7297)
-Generating Scripts :
Fix: Fixed the problem of object name update after generating DDL (tab characters before the object name) (7297)
-Database Migration (Pro):
Upd: All updates are the same as dbMigration .NET Softwares (7297)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Release Notes

Welcome to the release of phpMyAdmin version 5.0.0. This release is occurring simultaneously with version 4.9.3; except for users with old PHP installations, version 5.0.0 is the recommended version.

This release includes many new features and improvements from the 4.9 series. We expect to maintain version 4 in a security capacity to support users with older PHP installations. For full details about supported versions and end of life dates, see the "Supported versions" grid at https://www.phpmyadmin.net/downloads/.

With this release, we are removing support of old PHP versions (5.5, 5.6, 7.0, and HHVM). These versions are outdated and are no longer supported by the PHP team.

Version 5.0 includes many coding improvements that modernize the interface. Many of these changes are transparent to users, but make the code easier to maintain. Much of this refactoring work is completed by our contract developer, Maurício Meneghini Fauth. We always consider applications for new (paid) contract developers, see https://www.phpmyadmin.net/contractor/ for program details.

Some of the changes and new features include:

    Enable columns names by default for CSV exports
    Add Metro theme
    Automatically add the index when creating an auto increment column
    Improvements to exporting views
    Prompt the user for confirmation before running an UPDATE query with no WHERE clause
    Improvements to how errors are show to the user (including allowing easier copying of the error text to the clipboard)
    Added keystrokes to clear the line (ctrl+l) and clear the entire console window (ctrl+u)
    Use charset 'windows-1252' when export format is MS Excel

There are several more changes, please refer to the ChangeLog file included with the release for full details.

[close]

https://www.phpmyadmin.net/

[SiLæncer]

Whats new:>>

Minor bug fixes in command line and action file processing.

http://www.vlsoftware.net/