Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

This is viewer and editor for Paradox tables. It has password protection removing and fix & repair ability. It uses BDE.
Built-in BLOB viewer, filtering and searching, column statistics, index management and structure viewer are tools that covers most needed operations.
Data can be exported to many formats e.g. HTML, SYLK, Excel, RTF or XML and CSV and printed.
Data can be imported from XML and CSV.

Freeware

Whats new:>>

BLOB bug fix

http://www.mitec.cz/pde.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.

Whats new: >>

    Minor changes.
    Minor bugfixes in command line processing.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

Extra sanity checking added to ALTER TABLE in the 3.25.0 release sometimes raises a false-positive when the table being modified has a trigger that updates a virtual table. The false-positive caused the ALTER TABLE to rollback, thus leaving the schema unchanged. Ticket b41031ea2b537237.
The fix in the 3.25.0 release for the endless-loop in the byte-code associated with the ORDER BY LIMIT optimization did not work for some queries involving window functions. An additional correction is required. Ticket 510cde277783b5fb

[close]

https://www.sqlite.org/

[SiLæncer]

Changelog

    Command line processing ( Command-line ):
    Fix: Fixed a problem where the command line specified the database type of the last selected database type in the non-wired list will cause invalidation
    Fix: Improved [Servo Library Direct Connection Processing] Temporary setting deletion problem when disconnected
    Main program update ( Main ):
    Upd: (Firebird) Improvement When the same instance is not enabled to open the message using different fbembed.dll/fbclient.dll components
    Upd: Resolving the DataGridView control When the field name contains comma(,) characters, clicking on the field sorting will cause an exception
    Upd: Others include cumulative small updates, corrections and optimizations
    Generating Scripts:
    Upd: (PostgreSQL 10+) The main data table is generated with sub-partitioned tables .
    SQL Editor ( SQL Editor ):
    Add: Messages Tab Right-click menu to add Save As and Clear
    Database Migration (Pro):
    Upd: All updates are the same as dbMigration .NET Software

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

    The new "PathFinder" feature allows elaborate finding
    of association paths between tables in complex data models.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

SQL editor: highlighting all occurrences of selected word (configurable)
DBeaver extensions installer was improved: admin permissions are not required any more
Color Theme extension support was added including Solarized Dark/Light themes
Problem with upgrade from DBeaver 3.x was fixed

Server session manager was improved:

UI was redesigned
Session manager is now present in Tools menu
“Explain execution plan” tab was added
Long operations panel was added
Oracle: many additional session properties were added
RPM package was fixed (with newer RPM packager)
Data transfer: option “Selected columns/rows only” were fixed
“Read data in SQL console” behaviour was fixed (use SQL scripts instead of console)
Extra commands were added to Database navigator context menu: for data edit, ERD, etc
Grouping panel was improved: default ordering, duplicates finder, SQL Server syntax support
UI for the connection selection dialog was improved
Procedures editor was fixed (Generic driver)

Results viewer:

Columns widths resize issue was fixed
Row deletion for custom SQL without unique key was fixed

SQL Editor:

Paste from source code
formatting was improved (line feeds)
SQL indentation was fixed (DDL statements)
Formatter preferences page was redesigned
SQL Workbench formatter was added
ERD editor: note delete command was fixed
Generic connections (Impala and some others) create was fixed (buttons enablement)
Oracle: “Connections has timed out” error was fixed
SQL Server: IPv6 hosts support was added
Vertica: tables metadata reading performance was greatly increased
PostgreSQL: generic (Legacy) driver metadata reading was fixed
Redshift/PostgreSQL: array data types support was improved (NULL arrays)
Added localization for many UI strings
Many minor UI fixes

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

SQLite version 3.25.2 is another patch against 3.25.0 that fixes still more problems associated with the new window function feature and the ALTER TABLE enhancements. Of particular note is the new PRAGMA legacy_alter_table=ON command, which causes the ALTER TABLE RENAME command to behave in the same goofy way that it did before the enhancements found in version 3.25.0 → references to renamed tables that are inside the bodies of triggers and views are not updated. The legacy behavior is arguably a bug, but some programs depend on the older buggy behavior. The 3.25.2 release also contains a fix to window function processing for VIEWs. There also a slew of other minor fixes that affect obscure compile-time options.

[close]

https://www.sqlite.org/

[SiLæncer]

Changelog

Main program update ( Main ):
Add: Switching between all databases and a specified database (6844)
Supports databases such as PostgreSQL/IBM DB2/Informix/NuoDB/Vertica/SQL Server/Sybase ASE/MySQL/Oracle/Teradata
Add: Supports Specified Schema browsing mode (6844)
Added support for PostgreSQL/IBM DB2/Informix/NuoDB/Vertica / Includes libraries such as SQL Server/Sybase ASE/MySQL/Oracle/Teradata
Upd: Supports the selected post-loading mode, greatly improving the database object loading processing speed (6844)
Added support for PostgreSQL/IBM DB2/Informix/NuoDB/Vertica / Includes libraries such as SQL Server/Sybase ASE/MySQL/Oracle/Teradata
Upd: Optimized interface display: Unify the display and configuration of different differences in all servo database (6844)
Upd: (Firebird) Improvement (6806) When the same instance is not enabled to open the message using different fbembed.dll/fbclient.dll components (6837)
Upd: Resolving the DataGridView control When the field name contains comma(,) characters, clicking on the field sorting will cause an exception (6837)
Upd: Others include cumulative small updates, corrections and optimizations (6844)
AutoComplete and IntelliSense :
Add: (SQL Server/Sybase ASE) supports db.schema.{table}, db.{schema.table} auto-sensing processing (6844)
Add: Support comma characters , insert processing after selection (6844)
Plain Execution Plan :
Upd: Support user-defined EXPLAIN syntax query, and automatically switch to [Textual Execution Plan] display mode (6844)
Support for databases such as SQLite/PostgreSQL/MySQL/NuoDB/Teradata/HP Vertica
Data Editor and Browser :
Upd: Solving the problem of processing efficiency when the Decimal data type exceeds the preset length (6844)
Search Objects :
Fix: Fixed an issue where using Full Sub-Objects caused the database object [without parameters] could not be processed properly (6844)
Generating Scripts :
Add: (PostgreSQL 10+) Supports Partitioned indexes data table index related processing (6844)
Upd: (PostgreSQL 10+) The main data table is generated with sub-partitioned tables (6837).
SQL Editor ( SQL Editor ):
Add: Support CASE...END Code Folding (6844)
Add: Messages Tab Right-click menu to add Save As and Clear (6837)
Code Manager :
Upd: When the disk position changes in the portable mode, it can be automatically updated without modification (6844)
Command line processing ( Command-line ):
Fix: Fixed a problem where the command line specified the database type of the last selected database type in the non-wired list will cause invalidation (6837)
Fix: Improve the direct connection processing of the servo database: Temporarily set to avoid the problem of undelete after disconnecting the connection (6837)
Database Migration (Pro):
Upd: All updates are the same as dbMigration .NET Software (6844)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

Foreign key columns can be set to null if parent row is not exported
Increased responsiveness and performance of the data browser GUI
The new "PathFinder" feature allows elaborate finding
of association paths between tables in complex data models

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

Context variables WIRE_COMPRESSED and WIRE_ENCRYPTED were added to the SYSTEM namespace to report compression and encryption status, respectively, of the current connection. See Context Variables: v.3.0.4 for details.
Enhanced reporting of errors when a dynamic library fails to load. For more information, see Better Reporting on Dynamic Library Loading Errors.
When an external function (UDF) causes an error of the type "Arithmetic exception, numeric overflow, or string truncation", the error message will now include the name of the function.
The API now supports passing the DPB/spb item ***_auth_plugin_list from an application to the client interface. More details.
Two new context variables LOCALTIME and LOCALTIMESTAMP that are synonyms for CURRENT_TIME and CURRENT_TIMESTAMP, respectively. They can be used in Firebird 3.0.4 and later, for forward-compatibility with Firebird 4. See Context Variables: v.3.0.4 for details.
The read-only restriction for system tables was relaxed to permit CREATE, ALTER and DROP operations on their indexes.

[close]

http://www.firebirdsql.org/

[SiLæncer]

Changelog

Main program update:

Add: New Switch to another database : Steps to save the interrupt and then reconnect
Supports SQLite/SQLCe/Firebird/Access/Excel/Text/dBASE/FoxPro/OleDB/ODBC/OData/SQL Azure and other databases
Upd: Improve user experience: Interrupt connection button right click menu to increase reconnection function
Upd: Improve user experience: Cancel mouse click on object name change processing (Note: Shortcut key F2 and menu processing are still available)
Upd: Improve user experience: Group node is changed to click to close
Upd: Improve the user experience: Icon (Icon) level can display node objects to complete loading
Upd: Improved user experience: Optimized processing of the user interface (UI)
Fix: Improve compatibility issues and avoid accidental unboots
Upd: Compatible with Compatible with Microsoft Windows 10 (1809)
Upd: Others include cumulative small updates, corrections and optimizations

Visual Execution Plan :

Upd: (MySQL 5.6+) supports both visual and textual execution plan display
Upd: (MariaDB) Change to textual execution plan display processing
Fix: Fixed an issue where the split control on the right side didn't work

Connection Profile :

Add: New Schemas auto-execution: Supports databases such as IBM DB2/Informix/PostgreSQL/HP Vertica/NuoDB
Add: Automatic database (Databases) auto-execution: Supports Informix/HP Vertica and other databases
Upd: When the manual connection setting processing is performed, the Select last object when connected processing will be skipped.

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Google BigQuery extension was added
DBF files driver was added
SOCKS proxy: support for proxies on localhost
New version release checker was fixed (NPE)

SQL editor:

Selection occurrences highlighting was improved
Auto-completion: fuzzy completion is now used for all database objects
Extra formatting configuration was added
Active query tab switch bug was fixed
SQL joins auto-completion was fixed (quote column names)

Results viewer:

Filtering + ORDER BY was fixed
All long string editors now support xml/json formatting
Native date/time formatting support was added
Date/time columns justify config was added
Bit string values support was fixed

Data transfer:

Max string column length is respected when generating DDL
TXT format support was fixed (column widths)
Query/long tasks canceling was improved (configuration)
Connection default transaction isolation level configuration was fixed
Driver version selector was fixed (MacOS)

Apache Hive/Spark/Impala:

Table data edit support was added
Table/view source reading was implemented
Driver version was upgraded (2.6.5)
Firebird: table columns rename/reorder/edit is now supported

PostgreSQL:

Indexes predicate support was added
Domain data types (timestamp) resolve was fixed
Oracle 11: NULL timestamp bug was fixed
Clickhouse: driver config was fixed (catalogs)
SQL Server: native driver version upgrade (7.0.0)
Generic driver connection page UI was fixed (long URLs problem)
Many minor UI fixes

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

RecordEditor is a datafile editor, similar to File-Aid or Net-Cobols Cobol-Editor. It uses a record layout to format the data in the file in to a human readable format. Because it knows the format of fields, it can format binary fields as normal numbers rather than displaying hex equivalent as most hex editors do. The file can be editted in a table (spreadsheet-like format) or in a single record format with fields going down the page.

Freeware

Changelog

New Cross-platform File list screen
New enhanced File fields.
New Icons (Mainly Icon set)- this will allow better support HDPI screens in the future

Two new Open file dialogs:

Classic option which is an enhanced version of the current screen
File List screen
for both the above, file schema's

File Descriptions can be retrieved from:

RecordEditor Databases
Derived from Csv / Xml files
Cobol Copybook / Xml Schema

[close]

Download hier : https://sourceforge.net/projects/record-editor/files/Test/

http://record-editor.sourceforge.net/

[SiLæncer]

Changelog

Main program update ( Main ):

Add: Add Execute query to text: Ctrl + T : Steps to save processing after switching
Upd: (Oracle) supports complete field type display and related processing such as
Number(*,x), Number(x,-x):

Upd: (Oracle) Improved alternative handling when SEQUENCES cannot be generated
Upd: (NuoDB) supports Number Scale x field type display and related processing
Fix: (NuoDB) Fix and update field data type generation method
Upd: Others include cumulative small updates, corrections and optimizations
Misc: Compatible with Compatible with NuoDB 3.3

Connection Profile :

Add: (Firebird) Add Character Sets List to simplify setup issues
Upd: (Firebird) [New Library] The default encoding is changed to UTF8 and allowed to be modified in the property page
Fix: (Firebird) [Embedded] Fixed an error that the test did not continue if it was processed directly

SQL Editor ( SQL Editor ):

Upd: Replace the [Selected] node object name with the [Source] to edit content

SQL Performance Analyzer ( SQL Profiler ):

Fix: Fixed an issue where the SQLite pause (with exit) feature has no effect

Data Editor :

Fix: Filter Expression : Fix exception handling under the database that supports RowID

Database Migration (Pro):

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

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Main program update ( Main ):

Upd: Support for PostgreSQL 11 RTM database system (2018/10/18) (6869)
Add: (PostgreSQL 11) Supports Store Procedures Pre-stored program objects, including: Browse/Delete/Generate/Execute...etc. (6869)
Fix: (PostgreSQL) Fixed (6862) Numeric data type (6869) that could not be processed [without specified length]
Upd: (PostgreSQL) Support Numeric [no specified length] generation and display (including script generation) (6869)
Upd: Optimize interface display problem and graphic display processing speed (6869)
Upd: VistaDB component version updated to VistaDB.5.NET40.dll 5.7.4 (2018/10/14) (6869)
Upd: Update Database .NET Additional Files ( 32bit / 64bit ) (2018/10/19) (6869)
Upd: Others include cumulative small updates, corrections and optimizations (6869)

Connection Profile :

Add: Support Secure Shell Protocol ( SSH: Secure Shell ) connection method (6869)
Supports databases such as PostgreSQL/IBM DB2/Informix/NuoDB/Vertica/SQL Server/Sybase ASE/MySQL/Oracle/Teradata
Add: (Firebird) [New Library] Add PageSize Setting Item (6869)
Upd: (Firebird) Simplified connection setting display and update enable status (6869)
Upd: (Firebird) Client Library path is saved in Relative path, which is convenient for portable version mobile processing (6869)

SQL Editor ( SQL Editor ):

Add: Query Tab Adds Query Tab Icons : You can view the properties of the tab directly through the icon without switching (6869)

Code Manager :

Upd: Code Path path is saved in Relative path, which is convenient for portable version mobile processing (6869)
Fix: Fixed an issue where the original code path was not updated after switching from the default path to the portable mode ()

Data Import :

Upd: Improved error column number and source information message when the import process is wrong (6869)

Database Migration (Pro):

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

[close]

http://fishcodelib.com/Database.htm