Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Changelog

Object (tables, columns, etc) editor was redesigned
Statistics/misc tab was added to object editors
Data transfer supports document-oriented databases now
Table rename procedure is available from the table editor (MySQL, PG, Oracle, DB2)
Long operations canceling was fixed
“Tip of the day” popup was added
Java 11 support was added
Azure SQL driver was added
AWS Athena support was significantly improved

AWS Redshift:

Spectrum and external tables support was added
Columns and foreign keys metadata reading was fixed
Cockroach: foreign keys reading was fixed (for ERD)
Vertica: performance for data reading from big tables was improved
PostgreSQL: support transactions in tools (Truncate and others) was added
Oracle: TIMESTAMPTZ and TIMESTAMPLTZ data types support was fixed
Greenplum: session manager was added
SQL Server: sequences info reading was fixed
Clickhouse: GROUP BY/ORDER BY functions in grouping panel were fixed
Eclipse 2018-09 is now the default platform.
Extra command line parameters were added
German and Russian localizations were significantly improved
A lot of minor UI fixes

[close]

http://dbeaver.jkiss.org/

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

Fixed to sort date/time columns properly.

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

[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

Whats new:>>

- Fixed: Issues with editing MS Access tables

https://www.etl-tools.com/

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

http://www.vlsoftware.net/

[SiLæncer]

A SQL client that supports simultaneous connections to multiple databases, allowing data sharing and team collaboration on running queries.

Freeware

Changelog

Google BigQuery is supported now!
New collabration and saved queries features added
Favorite your queries and/or folders to access them faster.
Multiple actions on queries and folders
Color options added on folders
SSH issue fixed: Issue #415

[close]

https://teamsql.io/

[SiLæncer]

Whats new:>>

SQL-Console: all requests are now executed in the same connection.
Feature Request "#47 Add additional tables adds too much"
Feature Request "#44 MSSQL export to another DB in same instance"
Feature Request "#49 Mac shortcuts"
Feature Request "#50 Option to not to delete too much from entities"
Improved Cycle Finder component.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

    Increased responsiveness and performance of the SQL Console.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

AutoComplete and IntelliSense:

Add: Support for database names and schema names Auto Perception
Upd: Resolves user-defined high DPI settings settings, causing display anomalies
Upd: Optimize and improve automatic sensing processing speed
Fix: (SQL Server/SybaseASE) Fixed an issue where the [initial selected database] auto-sensing function in All databases mode has no effect
Add: (SQL Server/SybaseASE) supports schema.{table} auto-aware
Upd: (SQL Server/SybaseASE) Optimize db.schema.{table}, db.{schema.table} Auto Perception

Object Navigator:

Add: (FoxPro) supports Foreign Keys object display and delete processing
Fix: (NuoDB 2.5+) with the latest version of the Foreign Keys object display and delete processing (including data sheet design)
Fix: (Teradata) Fixed Foreign Keys object display and deletion processing (including data sheet design)

Main program update ( Main ):

Upd: Improved query tab icon and status column database type update processing
Upd: NuoDB component version updated to NuoDb.Data.Client.dll 2.3.0.10 (2018/10/30)
Upd: Others include cumulative small updates, corrections and optimizations
Misc: Compatible with SQL Server 2014 SP3 / SQL Server 2014 SP3 Express and LocalDB (2018/10/30)

Horizontal browsing mode:

Add: Supports Ctrl key to synchronize scrolling

Cell Editor / Cell Viewer:

Add: Support HTML Browsing Mode web browsing mode

SQL Performance Analyzer ( SQL Profiler ):

Add: Global Mode supports Firebird 3.0/4.0 Embedded inline version

Plain Execution Plan:

Upd: Optimize content display, distinguish between text and digital colors to make content reading more intuitive

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Results viewer:

Ordering confirmation config was fixed (issue with “unsortable” results fixed)
Toolbars layout was changed
Grid presentation: columns width stretching (fit screen/value) commands were added
Plaintext presentation: tabs support was fixed

SQL editor:

Associated connection info can be placed in the first line of script (can be shared between different users)
Unnecessary objects information reading was disabled (completion performance was greatly improved)
Auto-completion was fixed (identifier replacement)
Use different syntax for store functions and procedures invocation
Fix for the “Search inside names” option support

Object editor:

Property editor form was redesigned/fixed
Glitch with jumping cursor fixed
Grid visibility config was added
Read-only connections detection was fixed
Light theme is now default DBeaver theme (instead of Classic)
Preferences pages were reorganized. SQL scripts processing pref page was added.
Driver selection page: new design (optional)
Linked folder/file handling was fixed (do not delete broken links)
Data transfer wizard: progress monitor was fixed

Greenplum:

Functions header/footer was added to DDL
Table DDL generation was enhanced
SQL Server: procedure names fixed in auto-completion
AWS Athena: connection page was fixed
ORacle: do not use DBA_* views by default

Mock data generation wizard was improved:

Possibility to skip columns
Column generator settings save/load was fixed
Skip auto-generated columns by default
Darkest Dark theme support was fixed
German language localization update (thanks to Bullnados)
Chinese language localization update (thanks to fengchao)
Maven configuration was redesigned (now Maven project nature can be used in Eclipse)
A lot of minor UI fixes

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

Disallow the use of window functions in the recursive part of a CTE. Ticket e8275b415a2f03bee
Fix the behavior of typeof() and length() on virtual tables. Ticket 69d642332d25aa3b7315a6d385
Strengthen defenses against deliberately corrupted database files.
Fix a problem in the query planner that results when a row-value expression is used with a PRIMARY KEY with redundant columns. Ticket 1a84668dcfdebaf12415d
Fix the query planner so that it works correctly for IS NOT NULL operators in the ON clause of a LEFT JOIN with the SQLITE_ENABLE_STAT4 compile-time option. 65eb38f6e46de8c75e188a17ec

Hashes:

SQLITE_SOURCE_ID: "2018-11-05 20:37:38 89e099fbe5e13c33e683bef07361231ca525b88f7907be7092058007b75036f2"
SHA3-256 for sqlite3.c: 45586e4df74de3a43f3a1f8c7a78c3c3f02edce01af7d10cafe68bb94476a5c5

[close]

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

[SiLæncer]

Whats new: >>

Minor GUI changes.
Minor bugfixes.

http://www.vlsoftware.net/

[SiLæncer]

Whats new:>>

New export option "check primary keys" allows checking the validity of manually defined primary keys.
New export option "limit transaction sizes" reduces transaction sizes. (Feature request 51)
Improved indexing of working tables.
JSQLParser has been updated to version 1.3.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new: >>

Improvements in export field mappings setup.

http://www.vlsoftware.net/

[SiLæncer]

Whats new:>>

Fix for bug 32 "SQL analyzer: duplicate associations"

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

SQL Server (MSSQL) database extension was added:

Native SQL Server metadata
Table/columns/indexes/constraints editor
View/edit objects’ comments
Connection invalidate/reconnect action was redesigned (now forces reconnect always)

Data viewer:

Cell rendering was fixed in the plaintext view
Data save/reject key bindings were fixed
Support of right align for numbers and dates in plaintext view was added

SQL editor:

Tabs management was redesigned (now all tabs are pinnable and closeable)
SQL completion was significantly improved/fixed
Additional configuration for SQL formatter

Object editor:

Problem with “jumping” focus was fixed
Links rendering was fixed
Checkboxes are now grouped together
Data transfer: problem with multiple tables mappings was fixed
Read-only connections now restrict metadata edit
Driver properties editor UI was improved (password properties masking)
Project explorer UI was fixed (header column sizes)

PostgreSQL:

View and functions rename support was added
PostGIS support improved (now supports creation of new geometry values)
Data type DDL was added
Functions DDL was improved (comments)
JDBC driver default version changed to 42.2.5

MySQL:

Multiple/excluding schema filters were fixed
Presto: table elements reading was fixed (performance)
DB2 z/OS: driver config was fixed (foreign keys reading)
A lot of minor UI fixes

[close]

http://dbeaver.jkiss.org/