Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Ermöglicht den modellbasierten Datenexport aus relationalen Datenbanken; extrahiert konsistente, referenziell intakte Daten aus produktiven Datenbanken und fügt sie in Testdatenbanken ein; entfernt zudem alte, nicht mehr benötigte Daten aus der Datenbank, ohne die Integrität der Datenbank zu verletzen; generiert DbUnit-Datasets, strukturiertes XML und sortierte SQL-DML-Statements.

Lizenz: Open Source

Whats new:>>

- Minor GUI Improvements and bug fixes.

http://jailer.sourceforge.net/

[SiLæncer]

ESEDatabaseView reads and displays the data stored inside Extensible Storage Engine (ESE) database (Also known as 'Jet Blue' or .edb file). It displays a list of all tables available in the opened database file, allows you to choose the desired table to view, and then when you choose a table, it displays all records found in the selected table.

ESEDatabaseView also allows you to easily choose one or more records, and then export them into comma-delimited/tab-delimited/html/xml file, or copy the records to the clipboard (Ctrl+C) and then paste them into Excel or other spreadsheet application.

License:    Freeware

Whats new: >>

Added 'Run As Administrator' option (Ctrl+F11).

http://www.nirsoft.net/utils/ese_database_view.html

[SiLæncer]

Changelog

Data export: markdown (wiki, confluence) format support
Data export: extra configuration for CSV format
Data export: auto-size clumns in XLS
Mockdata generator: UI redesign, extra configuration
Connection selector dialog was redesigned
ERD: save to image was fixed (image bounds)
SQL generate: queries unwrap (configurable)
SSH tunnel: external SSHJ implementation (ed25519 support, bouncy castle)
Generic driver configuration was fixed
PostgreSQL: table DDL fix (include table comment)
MySQL: global server privileges edit fixed
Oracle: PL/SQL parser was fixed
Oracle: float data type support was fixed
ERD in SVG format support was fixed
Many minor UI fixes

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

Main program update ( Main ):

Add: Supports middle mouse button to close the [Meter-Click to Close Results tab] (6652)
Upd: (PostgreSQL) Updates data type processing to avoid duplicate or unsupported displays (6652)
Fix: Binding Function parameters : Fixed PostgreSQL inoperative (6652)
Upd: Improved efficiency issues after [New] query tag execution (6652)
Upd: Improve the processing of field types in query data tables (6652)
Fix: Exception handling when field length is corrected (6652)
Upd: IBM DB2/Informix Component Version Updated to IBM.Data.DB2.dll 9.7.4.4 (11.1.3030) (2018/03/07) (6652)
Misc: (IBM DB2/Informix) IBM Data Server Client Packages Version 11.1.3 Fix Pack 3 (2018/03/07)
Upd: Other contains cumulative minor updates, corrections, and optimizations (6652)

Query Reverse Engineering:

Fix: Fixed an issue that could not handle field names with more than 1 blank character (6652)

SQL Formatting:

Upd: comma is placed before or after the column name (trailingCommas), contains the data table to generate query processing (6652)

Process List:

Upd: Allows you to modify the update frequency (Timer) (6652)

Database Migration (Pro):

Upd: All updates with dbMigration .NET Software (6652)

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

Freeware

Whats new: >>

Improvements in exporting data to HTML.
Minor changes.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

Welcome to the release candidate version of the upcoming 4.8.0 release. This is likely to be the final testing release before 4.8.0 is officially released.

Notable changes since 4.8.0-alpha1:

Designer: fix broken "Add tables from other database"
Fix double escaping of ENUM dropdown
Restore SQL query after session expires
Query builder: Fix for new column not being added
Fix for blank login page
Changes to the handling of arg_separator for AJAX requests; see issue #13940
Structure tab: fix silent failure to create new indexes
Fix improperly escaped HTML code on the database structure page
ix JavaScript errors when using Internet Explorer (in particular when editing rows)
Fix for broken error report
Fix failed import
Fix for "Cannot read property sql_query of undefined" errors
The remaining notes are for changes from the 4.7.x branch to 4.8.0 and also applied to 4.8.0-alpha1.

[close]

https://www.phpmyadmin.net/

[SiLæncer]

Whats new:>>

  - Improved SQL Outline rendering.
  - Improved table meta data rendering.
  - Asynchronous meta data loading.
  - Minor GUI Improvements and bug fixes

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

Data Editor:

Add: (SQLite) Automatically recognizes Binary GUID and String GUID Add/Update/Delete processing (6664)
Add: (Sybase ASE) Default Value Synchronization Update Display After Supporting [New Data Column] (6664)
Upd: (MySQL) Improvements When the Default Value='' is Blank [New Data Column] Synchronized Update Display (6664)
Upd: (MySQL) Supports ON UPDATE CURRENT_TIMESTAMP [Update Data Column] Synchronized Update Display (6664)
Fix: Fixed an issue that could cause exceptions if the save was skipped at the same time as the reflash process (6664)

Main program update ( Main ):

Upd: (SQLite) Resolve compatibility issues with System.Data.SQLite.DLL encryption characters and use of open methods (6664)
Upd: (dBase) Automatically exclude files from [non-] dBase Table File Format to avoid invalid loading (6664)
Upd: (Oracle) Updating TIMESTAMP Data Type Maximum Length Limit (6664)
Upd: Others contain cumulative minor updates, corrections, and optimizations (6664)

Table Designer:

Add: DateTime default value selector (6664)
Fix: (FoxPro) Fixed an issue that could not [update] existing data tables (6664)

Database Migration (Pro):

Upd: All updates with dbMigration .NET Software (6664)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Exasol: table row count support was added
SQL Server: URL generation (explicit port value) was fixed
Greenplum driver configuration was added
Data export: XLS format (NULL cell values, column comments) was fixed
Results viewer: plaintext + record mode error was fixed
Minor UI bugfixes

SQL editor:

Empty script close behavior config was enhanced
Resources leak (thread + memory) was fixed

PostgreSQL:

Permission grants in table DDL
Constraints comments support was added
Foreign keys comments support was added
Sequences support (v10) was fixed
Sequences comments support was added
Functions permissions UI was added
Triggers DDL was added
Inherited tables DDL was fixed
Foreign servers DDL was added
Foreign wrappers DDL was added
Database rename support was added

Oracle:

DBA views resolve was fixed
Standard function names highlight was fixed

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

Add the sqlite3_serialize() and sqlite3_deserialize() interfaces when the SQLITE_ENABLE_DESERIALIZE compile-time option is used.
Recognize TRUE and FALSE as constants. (For compatibility, if there exist columns named "true" or "false", then the identifiers refer to the columns rather than Boolean constants.)
Support operators IS TRUE, IS FALSE, IS NOT TRUE, and IS NOT FALSE.
Added the SQLITE_DBSTATUS_CACHE_SPILL option to sqlite3_db_status() for reporting the number of cache spills that have occurred.
The "alternate-form-2" flag ("!") on the built-in printf implementation now causes string substitutions to measure the width and precision in characters instead of bytes.
If the xColumn method in a virtual table implementation returns an error message using sqlite3_result_error() then give that error message preference over internally-generated messages.
Added the -A command-line option to the CLI to make it easier to manage SQLite Archive files.
Add support for INSERT OR REPLACE, INSERT OR IGNORE, and UPDATE OR REPLACE in the Zipfile virtual table.
Enhance the sqlite3changeset_apply() interface so that it is hardened against attacks from deliberately corrupted changeset objects.
Added the sqlite3_normalize() extension function.

Query optimizer enhancements:

Improve the omit-left-join optimization so that it works in cases where the right-hand table is UNIQUE but not necessarily NOT NULL.
Improve the push-down optimization so that it works for many LEFT JOINs.
Add the LEFT JOIN strength reduction optimization that converts a LEFT JOIN into an ordinary JOIN if there exist terms in the WHERE clause that would prevent the extra all-NULL row of the LEFT JOIN from appearing in the output set.
Avoid unnecessary writes to the sqlite_sequence table when an AUTOINCREMENT table is updated with an rowid that is less than the maximum.

Bug fixes:

Fix the parser to accept valid row value syntax. Ticket 7310e2fb3d046a5
Fix the query planner so that it takes into account dependencies in the arguments to table-valued functions in subexpressions in the WHERE clause. Ticket 80177f0c226ff54
Fix incorrect result with complex OR-connected WHERE and STAT4. Ticket ec32177c99ccac2
Fix potential corruption in indexes on expressions due to automatic datatype conversions. Ticket 343634942dd54ab
Assertion fault in FTS4. Ticket d6ec09eccf68cfc
Incorrect result on the less-than operator in row values. Ticket f484b65f3d62305
Always interpret non-zero floating-point values as TRUE, even if the integer part is zero. Ticket 36fae083b450e3a
Fix an issue in the fsdir(PATH) table-valued function to the fileio.c extension, that caused a segfault if the fsdir() table was used as the inner table of a join. Problem reported on the mailing list and fixed by check-in 7ce4e71c1b7251be
Issue an error rather instead of an assertion-fault or null-pointer dereference when the sqlite_master table is corrupted so that the sqlite_sequence table root page is really a btree-index page. Check-in 525deb7a67fbd647
Fix the ANALYZE command so that it computes statistics on tables whose names begin with "sqlite". Check-in 0249d9aecf69948d

Additional fixes for issues detected by OSSFuzz:

Fix a possible infinite loop on VACUUM for corrupt database files. Check-in 27754b74ddf64
Disallow parameters in the WITH clause of triggers and views. Check-in b918d4b4e546d
Fix a potential memory leak in row value processing. Check-in 2df6bbf1b8ca8
Improve the performance of the replace() SQL function for cases where there are many substitutions on megabyte-sized strings, in an attempt to avoid OSSFuzz timeouts during testing. Check-in fab2c2b07b5d3
Provide an appropriate error message when the sqlite_master table contains a CREATE TABLE AS statement. Formerly this caused either an assertion fault or null pointer dereference. Problem found by OSSFuzz on the GDAL project. Check-in d75e67654aa96
Incorrect assert() statement removed. Check-in 823779d31eb09cda.
Fix a problem with using the LIKE optimization on an INTEGER PRIMARY KEY. Check-in b850dd159918af56.

[close]

https://www.sqlite.org/

[SiLæncer]

Changelog

Allow the removal of individual segments from pie charts
Improved database search to allow matching the exact phrase
phpMyAdmin no longer requires using the PHP eval() function
The mbstring dependency is now optional
Authentication logging using $cfg[‘AuthLog’] https://docs.phpmyadmin.net/en/latest/config.html#cfg_AuthLog
Add support for Google’s Invisible Captcha
Improved handling of reCAPTCHA
Fixes to the JavaScript editor for TIME values
Improved the editor for the JSON data type
Add „Format“ button to the edit view form
Implement mobile interface
There are now configuration directives to set defaults for Transformation options https://docs.phpmyadmin.net/en/latest/config.html#default-options-for-transformations
Allow Designer to show tables from other databases
Add support for authentication using U2F and 2FA
Designer: fix broken „Add tables from other database“
Fix double escaping of ENUM dropdown
Restore SQL query after session expires
Query builder: Fix for new column not being added
Fix for blank login page
Changes to the handling of arg_separator for AJAX requests; see issue #13940
Structure tab: fix silent failure to create new indexes
Fix improperly escaped HTML code on the database structure page
Fix JavaScript errors when using Internet Explorer (in particular when editing rows)
Fix for broken error report
Fix failed import
Fix for „Cannot read property sql_query of undefined“ errors

[close]

https://www.phpmyadmin.net/

[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

Release Notes

In this new version of MDB Viewer Plus the main change has been to rewrite the Query window. Although it may look roughly the same, the inner workings have changed alot. When clicking the query button on the main toolbar the query window opens as a tab along the top next to tables and welcome tabs instead of within a static query tab in previous versions. If you click the query button a second time you get another instance of the query window next to the first. This behaviour in the most important change in this update. Previously you could open up new query tables within the query window but each tab was sharing the results grid. This meant you had to re-execute the query everytime you changed tabs. Now each query tab is it's on instance and therefore has it's own results grid.

The tree on the right side of the query window has been replaced to two linked grids displaying table names and field names for the select table. By right clicking on the tables list presents a menu of option to assist building queries. I will be adding more to this menu in future versions.

The other change I have finally been able to make is getting shortcut key F5 to re-execute which ever query window is active.

The SQL button icon on the main tool bar has changed colour to reflect the icon shown when a new query window is launched.

[close]

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

[SiLæncer]

Changelog

- Main program update ( Main ):

Add: (IBM DB2) Support DBMS_OUTPUT output message display (6673)
Supported include: Oracle/ IBM DB2 and other databases
Upd: (Oracle) Solve the problem that when the database encoding is non-UTF (8/16), and the client code is not English, the error message garbled (6673)
Upd: (MySQL) Forces the connection attribute setting (Allow Zero Datetime=False) and removes it from the settings to avoid failures resulting in editing and export in/out (6673)
Add: (VistaDB) Identity Data Seed Value Reset Processing After Clearing Data Sheet Data (6673)
Add: (VistaDB) Support Data Table Identity Property Increment Value Get(6673)
Upd: (Access/SQLCe) Improved data table clearing process, retaining the original Identity property Increment value (6673)
Upd: Others contain cumulative minor updates, corrections, and optimizations (6673)
Misc: How to install 64bit Microsoft Access Database Engine alongside 32bit Microsoft Office?
- Binding Procedure parameters :
Add: (IBM DB2) Support OUTPUT output parameter content display (6673)
- AutoComplete and IntelliSense :
Fix: Fix the problem that the shortcut Ctrl + K Code Code (Code Snippets) doesn't work (6673)
- Database Migration (Pro):
Upd: All updates with dbMigration .NET Software (6673)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

SQL-Console: added support for substitution variables.
Fixed a bug concerning SQL outline rendering.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

Fix two problems in the new LEFT JOIN strength reduction optimization. Tickets 1e39b966ae9ee739 and 1e39b966ae9ee739.
Fix misbehavior of the FTS5 xBestIndex method. Ticket 2b8aed9f7c9e61e8.
Fix a harmless reference to an uninitialized virtual machine register. Ticket 093420fc0eb7cba7.
Fix the CLI so that it builds with -DSQLITE_UNTESTABLE
Fix the eval.c extension so that it works with PRAGMA empty_result_callbacks=ON.
Fix the generate_series virtual table so that it correctly returns no rows if any of its constraints are NULL.
Performance enhancements in the parser.

[close]

https://www.sqlite.org/