Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Changelog

Fixed direct login for accounts without a password
Fixed check for mbstring.func_overload
Fixed wrong encoding of table at triggers
Several fixes to the documentation including user settings and NavigationTreeEnableExpansion
Improved performance when importing with tracking enabled
Fixed the „Create PHP code“ functionality

[close]

https://www.phpmyadmin.net/

[SiLæncer]

Database Browser is an easy to use tool allows you to connect to any database (Oracle, MS-SQL, MySQL, Firebird, etc) and browse or modify data, run sql scripts, export and print data.

Features

    * Works directly with Oracle, MS Sql Server, ODBC, MySql, PostgreSQL, Interbase and Firebird
    * Support for ODBC connection strings
    * Unlimited number of connections
    * One click switching from one connection to another
    * One click table browsing
    * Data browsing
    * Data exports into CSV, Excel, Html files
    * Execution history
    * SQL Builder with wide range of supported databases
    * Execution Log
    * Incremental Table Search

What's new: >>

+ Improved : Multiline select statement execution

http://www.etl-tools.com/database-editors/database-browser/overview.html

[SiLæncer]

Changelog

- Main program:
 Upd: (ODBC / OLEDB) to enhance the primary key (Primary Keys) to obtain the ability (including data editing and script generation) (6397)
 Upd: (ODBC / OLEDB) Improved primary key index automatic elimination (including script generation) (6397)
 Upd: HP Vertica Component Version Update to Vertica.Data.dll 8.0.1.6 (2017/06/26) (6397)
 Updger: IBM DB2 / Informix component version update to IBM.Data.DB2.dll 9.7.4.4 (11.1.2020.4) (2017/06/23) (6397)
 Misc: (IBM DB2 / Informix) IBM Data Server Client Packages 11.1 Fix Pack 2 (2017/06/23)
 Upd: Other Include Cumulative Small Update, Fix and Optimize (6397)
- Generating Scripts :
 Upd: (SQL Server 2005+) Increase the display of the Computed Column property PERSISTED (6397)
- Connection Manager :
 Upd: 1. The title shows the currently selected connection, 2. The initial selection of the last item (6397)
 Fix: Fix the problem of missing new connection (6397)
- Table Designer :
 Fix: (Firebird) Fixed (6379) Problems with IDENTITY field attribute setting lost (6397)
- Data Import :
 Add: support record record separation ( Restoring the record separator from '\ r \ n' ) (6387)
 Upd: When you import via [Edit], the hidden field is no longer displayed (6387)
 Fix: Improved ( Empty as NULL ): No processing when the source is not a text type (6387)
- Data export:
 Add: (Delimitex Text) supports the recording of the separator separator ( Convergence of the record separator to '\ r \ n' ) (6387)
 Add: (HTML) Support Multiple Lines of Text () Export Export Character Processing (6387)
- SQL editor:
 Upd: Optimizing and Correcting JSON Formatting and Compression Processing (6387)
- Database Migration (Pro):
 Upd: All updates with dbMigration .NET  Software (6397)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Notable changes since 4.7.2:

Fixed creating relations
Fixed export without back quotes
Improved handling of uploaded files with open_basedir
Fixed usage of some browser transformations
Automatically connect using SSL when server is configured for such

[close]

https://www.phpmyadmin.net/

[SiLæncer]

Changelog

- Main program update:
Add: Automatically exclude unsupported connection attribute settings, to avoid problems with different versions that can cause no connection (6411)
Add: (HP Vertica 8+) Join CHECK Constraints Object Browse / Delete / Enable / Script Generation (6411)
Upd: (ODBC / OleDB) to improve the access to different types of database data types (6411)
Upd: (Firebird) Improved Data Table Fields DOMAIN Type Access Capabilities (6411)
Upd: Update Editor Font Size Max Settings (Editor Font MaxSize = 16) (6411)
Upd: (64bit) VistaDB Component Version Update to VistaDB.5.NET40.dll 5.6.8 (2017/07/12) (6411)
Upd: HP Vertica Component Version Update to Vertica.Data.dll 8.1.1.0 (2017/07/10) (6411)
Upd: Teradata component version update to Teradata.Client.Provider.dll 16.10.0.0 (64bit) (2017/07/05) /15.11.0.4 (32bit) (2017/04/28) (6411)
Upd: Other Include Cumulative Small Update, Fix and Optimize (6411)
Misc: Compatible with Compatible with MySQL 8.0.2 (2017/07) / MySQL 5.7.19 (2017/07) / MySQL 5.6.37 (2017/07) / MySQL 5.5.57 (2017/07)
- Data column editor:
Add: (HP Vertica) support after the automatic display (Named Sequence) value-added processing (6411)
- Data Browser :
Upd: Field Data Type Display Replace the original System Types with the original System Types (6411)
Add: field name background display support different color distinction NOT NULL (same editor) (6411)
- Data editor ( Cell Editor ) / data grid browser ( Cell Viewer )
Upd: Optimize and Improve Image Format Export Processing (6411)
- Generating Scripts :
Add: (PostgreSQL 10+) support CREATE SEQUENCE AS datatype attribute generation (6411)
- Database Migration (Pro):
Upd: All updates with dbMigration .NET Software (6411)

[close]

http://fishcodelib.com/Database.htm

[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 new quick filter options: 'Find records with all words (space-delimited list)' and 'Find records with all strings (comma-delimited list)'
Added new quick filter combo-box: 'Show only items match the filter' and 'Hide items that match the filter'.

http://www.nirsoft.net/utils/ese_database_view.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.

Freeware

Whats new: >>

Minor changes.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

SQL editor layout configuration was added
Results viewer: search dialog now highlighs cells
Connection/database selector was fixed
Office data export was enhanced
Dark theme support was improved
BLOB/CLOB editor was fixed
Numeric values editor was improved
Data transfer wizard was improved (columns mapping)
Folder editor UI was fixed
SQL formatting was fixed
Tray icon support was enhanced (can be used for long data export/import operations)
Oracle: PL/SQL parser was improved
MySQL/MariaDB: extra keywords added to SQL dialect
Generic driver: data types were added in navigator tree
Multiple UI bugs were fixed

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

Data Editor and Browser :

Add: Highlighting Groups of Cells (6422)
(Including SQL Histroy / SQL Profiler and other functions), which allows users to browse the same data in different data columns,

SQL Profiler :

Add: Added Vertica Performance Analyzer (64 Profiler for HP Vertica ) (6422)

Main program update:

Add: (SQLite) support table data table number display ( Table RowCount ) and data statistics update processing ( Table Statistics ) (6422)
Add: (Firebird 3 + / Oracle 12c +) support to clear the data table after the reset sequence value processing (RESET SEQUENCES) (6422)
Add: (Firebird) right-click menu to join the information table Enabled or Disabling an Index (6422)
Add: (Firebird) Right-click menu to join the data sheet Rebuilding an Index (6422)
Add: (SQLite) Right-click menu to add index statistics (6422)
Add: (NuoDB) support SYSTEM SEQUENCES system object display (6422)
Add: (NuoDB) supports right-click menu to view SEQUENCES object contents (6422)
Upd: Index table index rebuilds index index data after rebuilding (6422)
Upd: Other Include Cumulative Small Update, Fix and Optimize (6422)

Data column editor:

Upd: Optimize the new preset value after the automatic update processing (6422)
Fix: Improvements and Fixes Duplicate the Row (6422)
Fix: Fix and fix settings are set to NULL (6422)

SQL editor:

Upd: Improvements in the SQL tab of the Messages tab affect the overall efficiency of the implementation (6422)

AutoComplete and IntelliSense :

Add: Support NATURAL JOIN Perceptual Resolution (6422)

Table and View objects list :

Add: increase the data statistics selected update processing (Update Selected Items) (6422)

Generating Scripts :

Fix: (Firebird) Fixed Table Field Default Values ​​Lost Generated Issues (6422)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Update the text of error messages returned by sqlite3_errmsg() for some error codes.
Add new pointer passing interfaces.
Backwards-incompatible changes to some extensions in order to take advantage of the improved security offered by the new pointer passing interfaces:
Extending FTS5 → requires sqlite3_bind_pointer() to find the fts5_api pointer.
carray(PTR,N) → requires sqlite3_bind_pointer() to set the PTR parameter.
remember(V,PTR) → requires sqlite3_bind_pointer() to set the PTR parameter.
Added the SQLITE_STMT virtual table extension.
Added the COMPLETION extension - designed to suggest tab-completions for interactive user interfaces. This is a work in progress. Expect further enhancements in future releases.
Added the UNION virtual table extension.
The built-in date and time functions have been enhanced so that they can be used in CHECK constraints, in indexes on expressions, and in the WHERE clauses of partial indexes, provided that they do not use the 'now', 'localtime', or 'utc' keywords. Futher information.
Added the sqlite3_prepare_v3() and sqlite3_prepare16_v3() interfaces with the extra "prepFlags" parameters.
Provide the SQLITE_PREPARE_PERSISTENT flag for sqlite3_prepare_v3() and use it to limit lookaside memory misuse by FTS3, FTS5, and the R-Tree extension.
Added the PRAGMA secure_delete=FAST command. When secure_delete is set to FAST, old content is overwritten with zeros as long as that does not increase the amount of I/O. Deleted content might still persist on the free-page list but will be purged from all b-tree pages.
Enhancements to the command-line shell:
Add support for tab-completion using the COMPLETION extension, for both readline and linenoise.
Add the ".cd" command.
Enhance the ".schema" command to show the schema of all attached databases.
Enhance ".tables" so that it shows the schema names for all attached if the name is anything other than "main".
The ".import" command ignores an initial UTF-8 BOM.
Added the "--newlines" option to the ".dump" command to cause U+000a and U+000d characters to be output literally rather than escaped using the replace() function.
Query planner enhancements:
When generating individual loops for each ORed term of an OR scan, move any constant WHERE expressions outside of the loop, as is done for top-level loops.
The query planner examines the values of bound parameters to help determine if a partial index is usable.
When deciding between two plans with the same estimated cost, bias the selection toward the one that does not use the sorter.
Evaluate WHERE clause constraints involving correlated subqueries last, in the hope that they never have be evaluated at all.
Do not use the flattening optimization for a sub-query on the RHS of a LEFT JOIN if that subquery reads data from a virtual table as doing so prevents the query planner from creating automatic indexes on the results of the sub-query, which can slow down the query.
Add SQLITE_STMTSTATUS_REPREPARE, SQLITE_STMTSTATUS_RUN, and SQLITE_STMTSTATUS_MEMUSED options for the sqlite3_stmt_status() interface.
Provide PRAGMA functions for PRAGMA integrity_check, PRAGMA quick_check, and PRAGMA foreign_key_check.
Add the -withoutnulls option to the TCL interface eval method.
Enhance the sqlite3_analyzer.exe utility program so that it shows the number of bytes of metadata on btree pages.
The SQLITE_DBCONFIG_ENABLE_QPSG run-time option and the SQLITE_ENABLE_QPSG compile-time option enable the query planner stability guarantee. See also ticket 892fc34f173e99d8
Miscellaneous optimizations result in a 2% reduction in CPU cycles used.
Bug Fixes:
Fix the behavior of sqlite3_column_name() for queries that use the flattening optimization so that the result is consistent with other queries that do not use that optimization, and with PostgreSQL, MySQL, and SQLServer.
Fix the query planner so that it knows not to use automatic indexes on the right table of LEFT JOIN if the WHERE clause uses the IS operator.
Ensure that the query planner knows that any column of a flattened LEFT JOIN can be NULL even if that column is labeled with "NOT NULL".
Fix rare false-positives in PRAGMA integrity_check when run on a database connection with attached databases.
Fix a bug (discovered by OSSFuzz) that causes an assertion fault if certain dodgy CREATE TABLE declarations are used.

[close]

https://www.sqlite.org/

[SiLæncer]

Changelog

Named filters support was added
Data formats: locale config on Linux was fixed
Custom SQL query ordering was fixed
Office extension install in CE version was fixed
Entity delete confirmation was fixed (multiple objects delete)
Debug log configuration was added
Query manager coloring was fixed
ERD: support of dark theme was fixed
Windows: taskbar notifications enhancements (for data transfer and external tools)
Version update check was fixed
Command line enhancements (auto-commit option)
Full-text search processor was fixed (fail on first error)
SQL Editor: support of dynamic include of other scripts
SQL Editor: support of different quote chars
SQL Editor: script commands processing was fixed
SQL Editor: single line comments toggle was fixed
SQL Editor: open object (F4) shortcut now works in procedures/packages
SQL Editor: connection delete handle was fixed
Results viewer: shortcuts redefine was fixed
Results viewer: filter proposal was fixed (quoted identifiers)
Results viewer: find/replace highlights search string
Results viewer: right justify numbers and dates (configurable)
Database selector was fixed (minimize on some platforms)
PostgreSQL: access methods/operators metadata support was added
PostgreSQL: database dump using inserts (thanks to Alma Garcia)
PostgreSQL: SSL configuration page was fixed
PostgreSQL: DDL generator in generic driver was fixed
PostgreSQL: update connection setting on different database activation
Oracle: compile procedure/package error handling was fixed
SQL Server: support of [] quotes
Multiple UI fixes (including UI freeze on some platforms)

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

Main program update:

Upd: Optimize command -line resolution (6430)
Fix: start the last query to open the label: 1. Fixed (6372) lead to the same name tab can not save the problem, 2. increase the preservation of the last label to 100 (6430)
Upd: (Firebird) Improvements to get the installation directory may cause an exception event handling (6430)
Upd: Other Include Cumulative Minor Update, Fix and Optimize (6430)

Data editor ( Cell Editor ) / data grid browser ( Cell Viewer ):

Add: support for exporting original file format (Original Format (*. *)) (6430)
Upd: Optimize Gif file format export processing (6430)
Fix: Fixed (6411) part of the file format export still can not handle the problem (6430)

SQL Profiler:

Upd: (MySQL) Join Global Mode Message Switch Display and Support Version Detection Processing (6430)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

    Main program update:

    Add: support Schema switch object cache processing, can quickly switch between different Schema query tags no need to reload processing (6437)
    Add: Status column Add the current label Database Type and Schema Name Display (6437)
    (NuoDB / Vertica / Informix / DB2 / PostgreSQL) support different Schema Name tag switching, while switching objects to browse under the Schema (6437)
    Add: (FoxPro) support (* .dbf) database connection processing (automatically create dbc multiple choice to join * .dbf file) (6437)
    Upd: Optimize command -line resolution (6430)
    Upd: (Firebird) Improvements to get the installation directory may cause an exception event handling (6430)
    Upd: Other Include Cumulative Small Update, Fix and Optimize (6437)
    Misc: Compatible with Compatible with PostgreSQL 9.6.4 / 9.5.8 / 9.4.13 / 9.3.18 / 9.2.22 (2017/08/10)
    Open last query tabs on startup :

    Add: add SchemaName and DBtype state save processing, re-connect directly after the state (6437)
    Upd: Save the last label to 100 (6430)
    Fix: Fix (6372) Problems with the same name tab can not be saved (6430)

    Data Export :

    Add: Data Column Export Format * .sql Add Preserve schema name (6437)

    My Favorites ( My Favorites ):

    Fix: rewrite and fix [Servo] database handling (6437)

    Plain Execution Plan :

    Upd: (Informix) Optimize output processing to exclude unwanted message display (6437)

    Table Designer :

    Upd: (SQLite) field defaults when the function is automatically added (Parentheses) brackets (including script generation) (6437)
    Data editor ( Cell Editor ) / data grid browser ( Cell Viewer )
    Add: support for exporting original file format (Original Format (*. *)) (6430)
    Upd: Optimize Gif file format export processing (6430)
    Fix: Fixed (6411) part of the file format export still can not handle the problem (6430)

    SQL Profiler :

    Upd: (MySQL) Join Global Mode Message Switch Display and Support Version Detection Processing (6430)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Changes:
Further restrict visibility of pg_user_mappings.umoptions, to protect passwords stored as user mapping options.
Disallow empty passwords in all password-based authentication methods.
Make lo_put() check for UPDATE privilege on the target large object.
Correct the documentation about the process for upgrading standby servers with pg_upgrade.
Fix concurrent locking of tuple update chains.
Fix potential data corruption when freezing a tuple whose XMAX is a multixact with exactly one still-interesting member.
Avoid integer overflow and ensuing crash when sorting more than one billion tuples in-memory.
On Windows, retry process creation if we fail to reserve the address range for our shared memory in the new process.
Fix low-probability corruption of shared predicate-lock hash table in Windows builds.
Avoid logging clean closure of an SSL connection as though it were a connection reset.
Prevent sending SSL session tickets to clients.
Fix code for setting tcp_keepalives_idle on Solaris.
Fix statistics collector to honor inquiry messages issued just after a postmaster shutdown and immediate restart.
Ensure that the statistics collector's receive buffer size is at least 100KB.
Fix possible creation of an invalid WAL segment when a standby is promoted just after it processes an XLOG_SWITCH WAL record.
Fix walsender to exit promptly when client requests shutdown.
Fix SIGHUP and SIGUSR1 handling in walsender processes.
Prevent walsender-triggered panics during shutdown checkpoints.
Fix unnecessarily slow restarts of walreceiver processes due to race condition in postmaster.
Fix leakage of small subtransactions spilled to disk during logical decoding.
Reduce the work needed to build snapshots during creation of logical-decoding slots.
Fix race condition that could indefinitely delay creation of logical-decoding slots.
Reduce overhead in processing syscache invalidation events.
Remove incorrect heuristic used in some cases to estimate join selectivity based on the presence of foreign-key constraints.
Fix cases where an INSERT or UPDATE assigns to more than one element of a column that is of domain-over-array type.
Allow window functions to be used in sub-SELECTs that are within the arguments of an aggregate function.
Ensure that a view's CHECK OPTIONS clause is enforced properly when the underlying table is a foreign table.
Move autogenerated array types out of the way during ALTER ... RENAME.
Fix dangling pointer in ALTER TABLE when there is a comment on a constraint belonging to the table.
Ensure that ALTER USER ... SET accepts all the syntax variants that ALTER ROLE ... SET does.
Allow a foreign table's CHECK constraints to be initially NOT VALID.
Properly update dependency info when changing a datatype I/O function's argument or return type from opaque to the correct type.
Allow parallelism in the query plan when COPY copies from a query's result.
Reduce memory usage when ANALYZE processes a tsvector column.
Fix unnecessary precision loss and sloppy rounding when multiplying or dividing money values by integers or floats.
Tighten checks for whitespace in functions that parse identifiers, such as regprocedurein().
Use relevant #define symbols from Perl while compiling PL/Perl.
In libpq, reset GSS/SASL and SSPI authentication state properly after a failed connection attempt.
In psql, fix failure when COPY FROM STDIN is ended with a keyboard EOF signal and then another COPY FROM STDIN is attempted.
Fix pg_dump and pg_restore to emit REFRESH MATERIALIZED VIEW commands last.
Improve pg_dump/pg_restore's reporting of error conditions originating in zlib.
Fix pg_dump with the --clean option to drop event triggers as expected.
Fix pg_dump with the --clean option to not fail when the public schema doesn't exist.
Fix pg_dump to not emit invalid SQL for an empty operator class.
Fix pg_dump output to stdout on Windows.
Fix pg_get_ruledef() to print correct output for the ON SELECT rule of a view whose columns have been renamed.
Fix dumping of outer joins with empty constraints, such as the result of a NATURAL LEFT JOIN with no common columns.
Fix dumping of function expressions in the FROM clause in cases where the expression does not deparse into something that looks like a function call.
Fix pg_basebackup output to stdout on Windows.
Fix pg_rewind to correctly handle files exceeding 2GB.
Fix pg_upgrade to ensure that the ending WAL record does not have wal_level = minimum.
Fix pg_xlogdump's computation of WAL record length.
In postgres_fdw, re-establish connections to remote servers after ALTER SERVER or ALTER USER MAPPING commands.
In postgres_fdw, allow cancellation of remote transaction control commands.
Increase MAX_SYSCACHE_CALLBACKS to provide more room for extensions.
Always use -fPIC, not -fpic, when building shared libraries with gcc.
In MSVC builds, handle the case where the openssl library is not within a VC subdirectory.
In MSVC builds, add proper include path for libxml2 header files.
In MSVC builds, recognize a Tcl library that is named tcl86.lib.
In MSVC builds, honor PROVE_FLAGS settings on vcregress.pl's command line.

[close]

www.postgresql.org

[SiLæncer]

Changelog

Results viewer: save filters settings for each table
Results viewer: columns reordering with drag-n-drop
Results viewer: dark theme support was improved
SQL editor: variables support was fixed (global vars)
SQL Editor: hyperlinks on quoted identifiers were fixed
SQL Editor: autocomplete of quoted identifiers was fixed
SQL scripts create was fixed (for new projects)
Triggers source viewer was fixed (empty trigger body)
Auto-complete: optional support of global (in all schemas) tables search
Checkbox editor UI was fixed
Database/schema selector was fixed (application minimize problem)
Custom (named) object filters support was added
Locale configuration was fixed
Custom SQL queries ordering fix (quoted column names)
Exasol: object comments support improved, DEFINE command support
Oracle: all table triggers folder was added
PostgreSQL: SSL configuration UI was fixed
Informix: active database change was added
Informix: column names (instead of descriptions) in results viewer
Informix: triggers reading was fixed
Drivers download was fixed

[close]

http://dbeaver.jkiss.org/