Thema: Datenbanksoftware und Tools diverses ...

[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 exporting data into csv and tab files from grids

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

[SiLæncer]

Changelog

Database objects search fixed (GoTo object dialog)
Database full-text search was improved (state loading, bug were fixed, search history was fixed)
Default error dialog was redesigned (allow message copy-paste and scrolling)
Drivers download errors was fixed (missing Maven artifacts handling)
ERD looks-and-feel was fixed. Extra configuration was added.

SQL editor:

Query comments processing was fixed
Left toolbar rendering was fixed (background color issue)
SQL formatter for sub-selects was fixed

Results viewer:

Presentation switch error was fixed
Sorting by ambiguous columns was fixed
Visualize read-only columns in grid header (different background color + tooltip)
Value view panel read-only state handling was fixed
Search in value view panels was added
Execution log and output panel toggle shortcuts were changed

PostgreSQL:

Driver version updated to 42.2.3
Multi-database support was improved (no need to switch active database on access)
Foreign table DDL was fixed
Materialized view DDL was fixed
Domain data types resolution was fixed (problems with date/time types)
Debug perspective switch was fixed

MySQL:

New driver for MySQL 8.x was added
Timestamp time zone issue was resolved

Oracle:

Tablespace storage information was fixed
Yellowbrick driver configuration was added
Timescale driver connection page was fixed
SAP HANA: activate database switch was added
Data export in SQL: null table name issue was fixed
Data transfer by segments + table truncate was fixed
Database output log contents filtering was added (zero characters)
Database navigator: icons position was fixed
New table columns rename was fixed
MacOS installer was fixed (CE and EE version on the same machine issue)
Debug logging was fixed (do not log secure information)
Many minor UI fixes

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Whats new:>>

  - Fix for "Can't connect to SOCKS proxy:http" https://github.com/Wisser/Jailer/issues/8
  - Comprehensive usability improvements of the data browser.
  - Animated row-to-row links.
  - Increased rendering quality of row-to-row link.
  - Automatic layouting of data browser desktop.
  - Using working-table-scope "LOCAL_DATABASE" led to concurrency problems and connection leaks.
  - Update of SQL keyword catalog to SQL 2003 standard.
  - Added context menu to columns view of results table.

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

Improved: Third party components update

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

[SiLæncer]

Changelog

Main program update ( Main ):

Add: Support multiple selections (Multi selections ) (6778)
Object Navigator : Support for deleting/opening/editing/editing/Scripting multiple selections (Deleting/Opening/Editing/Scripting multiple selections)
Connection List : Support for deleting and removing multiple selections (Deleting/Removing multiple selections)
Code Manager : Support for deleting and opening multiple selections (Deleting/Opening multiple selections)
Insert Text: Supports dragging/copying multiple selections
Add: (Firebird) Support CryptKey by using Base64 string connection property setting (req Encryption plugin ) (6778)
Add: (Firebird) Add Embedded version display (6778)
Fix: (Firebird) Fix (6726) causes the status update issue when Remote and Embedded are selected (6778)
Fix: (64bit) Solve the problem that the user interface color picker (Color Picker) function can not work under the latest Win10 (6758)
Upd: Others include cumulative small updates, corrections and optimizations (6778)

Code Snippets :

Add: New Filtering Code Snippets (6778)
Fix: Fixed an issue where the original code fragment was not reloaded after updating the management content (6778)

SQL Editor ( SQL Editor ):

Add: Right-click menu auto-complete project ( AutoComplete ): Add switch auto-complete mode sub-option [N/S/C] (6778)
Fix: Fix Close All Tabs, when the [Last Label is Edit Mode] is turned off, it will cause an exception (6778)

Data Export :

Add: Copy the Selected Selected Items to Clipboard : Supports formats such as Markdown/JSON/HTML (6778)
Upd: Optimize [all] export format processing (6778)

Data Import :

Upd: Preview Mode no longer displays dialog prompts to support pre-correlated change processing (6758)
Upd: Add file format detection to avoid opening unsupported import format files (6758)

SQL Formatting ( SQL Formatting ):

Add: Support editor properties ConvertTabsToSpaces and TabIndent settings to format processing (6758)

Table Designer :

Fix: Resolve the problem of resetting if the data table contains an incremental field (AUTOINC) after changing the name of the field (6758)

Database Migration (Pro):

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

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

SQLiteStudio is a comprehensive and reliable SQLite database manager that provides you with a simple means of managing the contents of each database, including tables, triggers and views.

License : GPLv3

Changelog

[NEW]: #3188 New plugin to have images stored in database being visible as another tab in the Form View or cell's editor dialog window.
[NEW]: #3207 #1444 #2547 Export, Import & Populate dialog settings are remembered, even after application restart.
[NEW]: #3268 Query bind parameters are now supported by the query editor while execution - user will be asked for values for these parameters in a dedicated dialog.
[NEW]: #3267 Added Extension Manager window, where all SQLite extensions can be registered for loading into databases.
[NEW]: #3161 Added support for table-valued functions (https://sqlite.org/vtab.html#tabfunc2)
[NEW]: #3349 Added support for UPSERT syntax from SQLite 3.24.0.
[NEW]: #3292 Added possibility to execute huge SQL files directly from disk, without loading them to SQL Editor.
[NEW]: #3265 Completely new installer for SQLiteStudio is introduced. It bases on Qt Installer Framework. This addresses numerous issues with automatic updates that SQLiteStudio had. It also allows for some new features, like automatic file association under Windows (#3178). Portable (download & run, without installation) distribution continues to be available.
[NEW]: #2659 AutoIncrement option is now always available in PK configuration dialog. When AutoIncrement is enabled, a datatype will be enforced to INTEGER type.
[NEW]: #2798 Added filter inputs per column as an option.
[NEW]: #3224 Added context menu for SQL history tab to delete individual (or a range of selected) entries. Also a "delete" key can be used.
[NEW]: #2651 Only a single instance of SQLiteStudio can be running at the time. If another instance is requested, the first one will be brought to the front of windows stack. If another instance was requested due to associated file being open, then the first instance will not only be raised, but also the requested file will be added to database list as temporary, volatile database (not added permanently to configuration).
[NEW]: #3033 Ctrl+Shift+c copies data including headers. Also context menu entry added for the same.
[NEW]: #2962 Pasting single value to multiple cells results in pasting the value into all selected cells, not just to first one.
[NEW]: #2907 The "Open file's directory" menu item added to database list for database nodes.
[NEW]: #3388 Added file association entries in the plist for MacOSX
[NEW]: #3163 Added menubar accelerator keys.
[CHANGE]: #3257 #3260 #3271 Bug/Feature reports are now completely managed by GitHub. Bug report dialog is no longer present in the application, but instead the menu entry opens web browser on project's GitHub page.
[CHANGE]: #3285 SQLCipher and wxSQLite3 plugins can now be linked to system-provided libraries, which is especially useful under Linux. Instructions were added to the wiki page: https://github.com/pawelsalawa/sqlitestudio/wiki/Instructions_for_compilation_under_Linux#linking-with-system-provided-libraries
[CHANGE]: #3284 SQLite3 upgraded to version 3.24.0 (excluding SQLCipher plugin, which is still on 3.20.1).
[CHANGE]: API of QueryExecutor enhanced to provide custom steps at certain stages of execution. Steps can be injected by plugins.
[CHANGE]: #3121 Column widths are kept between data reloads.
[CHANGE]: #3024 Edit in editor action in cell's context menu stands now "show in viewer" if clicked on read-only cell. Also "set null" and "erase" are not displayed if none of selected cells is editable.
[CHANGE]: #3142 Horizontal scroll position is now preserved between sort request on a data view.
[CHANGE]: #2971 Column width is now mostly based on data width, not header width, but if there is little columns to be displayed, the header width is also considered.
[CHANGE]: #3323 Disabled automatic line wrapping in SQL editor and all other code edition fields in the application.
[BUGFIX]: #3259 #3215 #3327 Stop interpreting "+3" or "0010" as numeric types if entered to TEXT column (or any other column not declared as numeric-ish).
[BUGFIX]: #3191 CSV import speed improved. It's 1400 times faster. It's not a joke. The bug used to cause the import to be terribly slow. Also other importing plugins gained around 400% of speed.
[BUGFIX]: #3119 Fixed extra "empty" row of data when importing from CSV with a new, empty line at the end.
[BUGFIX]: #3235 Crash when opening DB dialog, but file was moved.
[BUGFIX]: #3185 Fixed creation of new tables/views if "Data" tab is configured as first.
[BUGFIX]: #3279 Fixed reporting rows affected with DELETE statement for SQLite2.
[BUGFIX]: #3023 Optimized SQL editor widget to work with huge contents.
[BUGFIX]: Fixed random crashes at application close (when saving session). Most frequend on Windows platform.
[BUGFIX]: #3252 Fixed first character input when starting to edit FK column data.
[BUGFIX]: #3251 Fixed DEFAULT constraint dialog to work wit "literal values in double-quotes"
[BUGFIX]: #3084 #3085 Fixed beeps under MacOSX when editing FK cell.
[BUGFIX]: #3293 Fixed deault shortcut for code assistant under MacOSX from Cmd-Space to Ctrl-Space, so it does not conflict with Spotlight
[BUGFIX]: #3190 Fixed handling WITHOUT ROWID and unusual column name.
[BUGFIX]: #3177 Fixed tab indentations when selecting even part of a line.
[BUGFIX]: #3171 Pasting object to same database is prevented.
[BUGFIX]: #3176 Fixed exporting with Common Table Expression (the WITH statement).
[BUGFIX]: #3162 Fixed order of column headers in Index Dialog
[BUGFIX]: #3159 Fixed dictionary populating plugin to recognize different new-line characters.
[BUGFIX]: #3156 Fixed recognition of double-quoted values.
[BUGFIX]: #3093 Columns with AUTOINCREMENT statement are defaulted to null for new rows in Form View, so they get committed this way (unless manually changed) and they become an auto generated values.
[BUGFIX]: #3086 #3187 Fixed internal task ordering when drag&dropping tasks on the taskbar, so switching between tasks with keyboard shortcut reflects order of tasks on the taskbar.
[BUGFIX]: #3173 Added support for detecting and trimming whitespace in pasted text (thanks to nishanthkarthik for contributing this)
[BUGFIX]: #2922 Fixed CTE execution by QueryExecutor, so it understands columns from CTE (not editable columns for now, maybe will become editable in future).
[BUGFIX]: #2964 SQL history tab shows now local time of execution, not UTC.
[BUGFIX]: #3290 Fixed querying data for FK dropdown from tables/columns with unusual characters in name. Also fixed name-wrapping for objects that have unescaped wrapper character inside of their name.
[BUGFIX]: #3305 Introduced dynamic limit for number of rows per page - based on number of columns, so it's less likely to hit the memory limit.
[BUGFIX]: #3311 Fixed floating point numbers handling.
[BUGFIX]: #3383 Fixed JSON export plugin for quoted names.
[BUGFIX]: #3347 #3351 Fixed QCheckBox in several places, so text() of it is not used as a valid data. This is to address issues with automatic accelerator keys.
[BUGFIX]: Addressed some concurrency erorrs in SQLite 2 plugin
[BUGFIX]: #3139 #3116 #3326 #3341 Various code compiling issues addressed.
[BUGFIX]: #3145 #3165 #3179 Fixed various typos in messages/interface.
[BUGFIX]: #3333 Fixed unit test to honor new features of TableModifier, but also fixed few bugs in TableModifier.
[BUGFIX]: #3277 Open Source license issues addressed (specific exceptions for OpenSSL and icons)
[BUGFIX]: #2966 Application icon added to package.
[BUGFIX]: Few other bugfixes made on the fly, while working on other issues.

[close]

http://sqlitestudio.pl/

[SiLæncer]

Whats new:>>

[BUGFIX]: Fixed 'export data' checkbox in export dialog to not ignore it anymore.
[BUGFIX]: Binary packages now include the MultiEditorImage plugin, which introduces the picture preview for BLOB values. It was introduced in 3.2.0, but missing in binary distributions.

http://sqlitestudio.pl/

[SiLæncer]

Whats new:>>

The estimated number of rows of the tables is displayed.
Limited fetch size of statements to prevent an OOM exception when the default fetch size is too large (MySQL).
Updated H2 DBMS from version 1.3.160 to 1.3.175

http://jailer.sourceforge.net/

[SiLæncer]

Whats new:>>

– Fixed: Issues with copying data from grids

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

[SiLæncer]

HeidiSQL is an easy-to-use interface and a "working-horse" for web-developers using the popular MySQL-Database. It allows you to manage and browse your databases and tables from an intuitive Windows interface. Includes:

    MySQL Server user management
    Database management (modify databases, tables, fields, indexes)
    Data browsing and modification (including search filters, blob editing)
    MySQL session management (can kill queries)
    SQL query execution, including SQL batch scripting (and MySQL function list)
    Import/export of data

Functional in Linux via WINE.

License: GPL

Changelog

Fix comparison of table names on servers with lower_case_table_names=1 or 2 (both insensitive). Affects SQL export, which is calling PrepareColumnAttributes since recently.

[close]

http://www.heidisql.com/

[SiLæncer]

Changelog

Data viewer:

Foreign keys/references navigation was improved
Unique key detection was changed (ROWID is used only if no natural key was found)
String filter editor was fixed
Full-text search history navigation was fixed
SQL formatter was fixed/improved
ERD: self-referencing tables rendering was fixed
Error dialog was enhanced (scrollable text for all errors, default focus is on Ok button)
Database navigator double-click behavior was extended (open new editor)
Database driver search was improved (search in descriptions)
Snowflake connection configuration UI was added in CE
Elastic Search driver configuration was added
AWS Athena driver configuration was added
Exasol extension now relies on v6 driver

PostgreSQL:

Multiple databases filter was fixed
Active database detection was fixed
Function list reading was fixed for PG < 8.4
Foreign server user mapping was added (thanks to @johnatanDM)
Permission editor UI was fixed
Many minor UI fixes
MariaDB/Galera: users editor was improved
MySQL/MariaDB: view creation was fixed

Oracle:

DATE data type support was fixed
Table statistics/storage information was added
Synonyms support was added in metadata extraction
Extra columns were added to Explain Plan nodes
Multiline editor for table/column comments
Firebird: sequences and triggers reading was fixed for older FB versions
Phoenix: metadata reading bug was fixed (databases with single schema)
Shortcuts with Ctrl+Alt were changed on Ctrl+Shift
DBeaver was migrated to Eclipse 4.8 platform. Besides other improvements this fixes a few old UI bugs on MacOS and Linux.

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

Main program update ( Main ):

Add: My Favorites : Add support for Databases and Schemas object processing (6785)
Add: (PostgreSQL 9.1+) Supports the processing of Foreign tables data table (6785)
Add: (PostgreSQL 10+) Supports Partitioned tables data table related processing (6785)
Upd: Others include cumulative small updates, corrections and optimizations (6785)
Misc: Compatible with Compatible with MySQL 8.0.12 / MySQL 5.7.23 / MySQL 5.6.41 / MySQL 5.5.61 (2018/07)

Connection List :

Add: Support my favorite connection list ( My Favorite Connections ) (6785)

Data Editor :

Fix: Correct the System.Object data type handling method when there is no primary key (6785)

Cell Editor / Cell Viewer :

Upd: When the field data type is System.Byte[], the text can be saved and saved by default (6785)

Database Migration (Pro):

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

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Table Designer:

Add: (Access/NuoDB) support check condition constraint ( CHECK constraints ) add and delete processing (6792)
Upd: (SQLite) Cannot add a non-constant default when the new fields are built in. Can not add a column with non-constant default (6792)

Main program update ( Main ):

Upd: (NuoDB 3.1/3.2+) With the latest version of Data Type update processing, solve the problem that the data type cannot be displayed normally (6792)
Upd: (Access/Excel/Text/dBASE/FoxPro) Preset quote string ``replace with [] instead (6792)
Upd: Others include cumulative small updates, corrections and optimizations (6792)
Misc: Compatible with NuoDB 3.1 / 3.2
Misc: Compatible with Compatible with MySQL 8.0.12 / MySQL 5.7.23 / MySQL 5.6.41 / MySQL 5.5.61 (2018/07)

Generating Scripts:

Add: (Access) supports CHECK constraints definition generation and deletion processing (6792)
Fix: (VistaDB) Fixed issue where CHECK constraints did not contain quoted string () (6792)
Fix: (Teradata) Fix CHECK constraints [Do not include name] (6792)
Fix: (Informix) Fixed CHECK constraints [with multiple lines] (6792)
Fix: (Firebird) Fixed issue with CHECK constraints multi-field condition processing (6792)
Fix: (Firebird) Fixed an issue where the default keyword in the field was defined as [lowercase] and could not be parsed properly (6792)

Connection List:

Add: Supports Dragging multiple selections (6792)

Database Migration (Pro):

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

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Changes:

Fix failure to reset libpq's state fully between connection attempts.
Fix INSERT ... ON CONFLICT UPDATE through a view that isn't just SELECT * FROM.
Ensure that updates to the relfrozenxid and relminmxid values for “nailed” system catalogs are processed in a timely fashion.
Fix case where a freshly-promoted standby crashes before having completed its first post-recovery checkpoint.
Avoid emitting a bogus WAL record when recycling an all-zero btree page.
During WAL replay, guard against corrupted record lengths exceeding 1GB.
When ending recovery, delay writing the timeline history file as long as possible.
Improve performance of WAL replay for transactions that drop many relations.
Improve performance of lock releasing in standby server WAL replay.
Make logical WAL senders report streaming state correctly.
Ensure that a snapshot is provided when executing data type input functions in logical replication subscribers.
Fix bugs in snapshot handling during logical decoding, allowing wrong decoding results in rare cases.
Add subtransaction handling in logical-replication table synchronization workers.
Ensure a table's cached index list is correctly rebuilt after an index creation fails partway through.
Fix mishandling of empty uncompressed posting list pages in GIN indexes.
Pad arrays of unnamed POSIX semaphores to reduce cache line sharing.
Ensure that a process doing a parallel index scan will respond to signals.
Ensure that VACUUM will respond to signals within btree page deletion loops.
Fix hash-join costing mistake introduced with inner_unique optimization.
Fix misoptimization of equivalence classes involving composite-type columns.
Fix planner to avoid “ORDER/GROUP BY expression not found in targetlist” errors in some queries with set-returning functions.
Fix handling of partition keys whose data type uses a polymorphic btree operator class, such as arrays.
Fix SQL-standard FETCH FIRST syntax to allow parameters ($n), as the standard expects.
Remove undocumented restriction against duplicate partition key columns.
Disallow temporary tables from being partitions of non-temporary tables.
Fix EXPLAIN's accounting for resource usage, particularly buffer accesses, in parallel workers.
Fix SHOW ALL to show all settings to roles that are members of pg_read_all_settings, and also allow such roles to see source filename and line number in the pg_settings view.
Fix failure to schema-qualify some object names in getObjectDescription and getObjectIdentity output.
Fix CREATE AGGREGATE type checking so that parallelism support functions can be attached to variadic aggregates.
Widen COPY FROM's current-line-number counter from 32 to 64 bits.
Allow replication slots to be dropped in single-user mode.
Fix incorrect results from variance(int4) and related aggregates when run in parallel aggregation mode.
Process TEXT and CDATA nodes correctly in xmltable() column expressions.
Cope with possible failure of OpenSSL's RAND_bytes() function.
Fix libpq's handling of some cases where hostaddr is specified.
Add a string freeing function to ecpg's pgtypes library, so that cross-module memory management problems can be avoided on Windows.
Fix ecpg's support for long long variables on Windows, as well as other platforms that declare strtoll/strtoull nonstandardly or not at all.
Fix misidentification of SQL statement type in PL/pgSQL, when a rule change causes a change in the semantics of a statement intra-session.
Fix password prompting in client programs so that echo is properly disabled on Windows when stdin is not the terminal.
Further fix mis-quoting of values for list-valued GUC variables in dumps.
Fix pg_dump's failure to dump REPLICA IDENTITY properties for constraint indexes.
Make pg_upgrade check that the old server was shut down cleanly.
Fix contrib/hstore_plperl to look through Perl scalar references, and to not crash if it doesn't find a hash reference where it expects one.
Fix crash in contrib/ltree's lca() function when the input array is empty.
Fix various error-handling code paths in which an incorrect error code might be reported.
Rearrange makefiles to ensure that programs link to freshly-built libraries (such as libpq.so) rather than ones that might exist in the system library directories.
Update time zone data files to tzdata release 2018e for DST law changes in North Korea, plus historical corrections for Czechoslovakia.

[close]

http://www.postgresql.org/

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

Many minor improvements and bug fixes in interface and export procedures.

http://www.vlsoftware.net/