Thema: Datenbanksoftware und Tools diverses ...

[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

Editor for Fixed Width, Csv and Existing Xml files.
The RecordEditor is a Data File editor for Flat Files (delimited and fixed field position). It supports Unix / PC / Legacy (e.g. Mainframe) file formats, both Text and binary files.
The Editor uses a Record-Layout description to format the files. This is ideal for Fixed width (Text or Binary) files, Cobol Data Files, Mainframe files and complicated Csv files. Cobol Copybooks can be used to format Cobol Data files.

As well as an editor, The following utilities are supplied:

Formatted Compare
File Copy and reformat Utility
FileWizard this is use to work out the format of a File. It can generally find both Text and binary / packed deicimal fields in a file
For Simple Csv you should look at its sister project reCsvEditor.
Note: The core Editor code is also used in the "Protocol buffers editor" and "Avro Editor"

[close]

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

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

[SiLæncer]

Changelog

Upd: Accumulated more than 100 updates, correction and optimization processing (6901)
Misc: Compatible with Compatible with PostgreSQL 11.1 / 10.6 / 9.6.11 / 9.5.15 / 9.4.20 / 9.3.25 (2018/11/08)

Table Designer :

Add: Support data sheet column movement ( Column moving* ) processing (6901)
In addition to the original supported database, all new databases such as Access/dBASE/FoxPro/Firebird/ODBC/OleDB are supported.

Duplicating Tables :

Add: Support for copying data table indexes (Indexes) and checking condition constraints (CHECK Constraints) (6901)
Upd: Support automatic update (AUTOINCREMENT) field value after copying (6901)
Fix: Fixed (SQL Server) unable to copy the problem with the IDENTITY field data table (6901)

Data Editor :

Add: (Firebird 2.5+) Update and delete data column processing when UUID is supported as primary key (PK) (6901)
Upd: Synchronous update display when TRIGGER is supported as Default Value (6901)

AutoComplete and IntelliSense :

Upd: Improved single-line annotation ( -- ) in the automatic perceptual processing of data sheets (6901)

SQL Editor ( SQL Editor ):

Fix: Fixed an issue where the Increase Indent could not be processed on [Selected Fragments] when the format property ConvertTabsToSpaces=True (6901)

Security Manager :

Upd: (Firebird 4+) Supports unchecking the role system permission setting processing (6901)
Fix: (Firebird 4+) Fixed a problem with partial file system permission settings being displayed incorrectly (6901)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Main program update ( Main ):

Fix: Fixed an issue that caused an exception when the object was initially loaded as the [First] repository in the All databases mode (6905)
Add: (MariaDB 10.3.5+) Support PACKAGES object browsing, new and delete processing (6905)
Fix: (Firebird) Fix CREATE PACKAGE New Sample Sample (6905)
Upd: Others include cumulative small updates, corrections and optimizations (6905)

Security Manager :

Upd: (MySQL) Update user syntax generation issues to be compatible with MariaDB and MySQL (6905)
Fix: (MySQL) Change user password down compatible with 5.7 or later (6905)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

Fixed "SQLite JDBC: inconsistent internal state" during database analysis.
Fixed "#32 SQL analyzer: duplicate associations".
Implemented "#51 Reduce transaction sizes"
Implemented "#54 Number thousand separators"
New option to set the isolation level.
Bookmark feature in data browser.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

- Main program update ( Main ):

Add: (64bit) New Split Query Mode* (6908)
The professional version provides a more intuitive and convenient way to compare the content of the query with the content of the data browsing, greatly eliminating the trouble and inconvenience of switching the tab.
Fix: Fixed (6778) problem that prevented the table and view objects list from being opened (6908)
Upd: IBM DB2/Informix component version updated to IBM.Data.DB2.dll 9.7.4.4 (11.1.4040.4) (2018/11/21) (6908)
Misc: (IBM DB2/Informix) IBM Data Server Client Packages Version 11.1.4 Fix Pack 4 (2018/11/21)
Upd: Others include cumulative small updates, corrections and optimizations (6908)

- Database Migration (Pro):

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

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

    Optimization: When doing an UPDATE on a table with indexes on expressions, do not update the expression indexes if they do not refer to any of the columns of the table being updated.
    Allow the xBestIndex() method of virtual table implementations to return SQLITE_CONSTRAINT to indicate that the proposed query plan is unusable and should not be given further consideration.
    Added the SQLITE_DBCONFIG_DEFENSIVE option which disables the ability to create corrupt database files using ordinary SQL.
    Added support for read-only shadow tables when the SQLITE_DBCONFIG_DEFENSIVE option is enabled.
    Added the PRAGMA legacy_alter_table command, which if enabled causes the ALTER TABLE command to behave like older version of SQLite (prior to version 3.25.0) for compatibility.
    Added PRAGMA table_xinfo that works just like PRAGMA table_info except that it also shows hidden columns in virtual tables.
    Added the explain virtual table as a run-time loadable extension.
    Add a limit counter to the query planner to prevent excessive sqlite3_prepare() times for certain pathological SQL inputs.
    Added support for the sqlite3_normalized_sql() interface, when compiling with SQLITE_ENABLE_NORMALIZE.
    Enhanced triggers so that they can use table-valued functions that exist in schemas other than the schema where the trigger is defined.
    Enhancements to the CLI:
        Improvements to the ".help" command.
        The SQLITE_HISTORY environment variable, if it exists, specifies the name of the command-line editing history file
        The --deserialize option associated with opening a new database cause the database file to be read into memory and accessed using the sqlite3_deserialize() API. This simplifies running tests on a database without modifying the file on disk.
    Enhancements to the geopoly extension:
        Aways stores polygons using the binary format, which is faster and uses less space.
        Added the geopoly_regular() function.
        Added the geopoly_ccw() function.
    Enhancements to the session extension:
        Added the SQLITE_CHANGESETAPPLY_INVERT flag
        Added the sqlite3changeset_start_v2() interface and the SQLITE_CHANGESETSTART_INVERT flag.
        Added the changesetfuzz.c test-case generator utility.

    Hashes:

    SQLITE_SOURCE_ID: "2018-12-01 12:34:55 bf8c1b2b7a5960c282e543b9c293686dccff272512d08865f4600fb58238b4f9"
    SHA3-256 for sqlite3.c: 72c08830da9b5d1cb397c612c0e870d7f5eb41a323b41aa3d8aa5ae9ccedb2c4

[close]

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

[SiLæncer]

Whats new:>>

Intra-database export: automatic fallback to MERGE on tables without PK has been removed.
Increased SQL import performance + progress bar also for compressed files.
Logging did not work if the working directory is read-only.
Improved error handling.
Minor bug fixes.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

Data editor:

Dictionary tables lookup/search was added
Grouping panel now supports different presentations
Unpin all tabs command was added

SQL editor:

Auto-completion algorithm was improved
SQL formatter was improved (UPDATE, BEGIN/END)
Multi-tab context menu was fixed
Connection wizard: settings page UI was redesigned
Foreign key creation dialog: unique indexes usage was added
SQL processing: LIMIT usage was fixed
Connection ping (keep-alive) was improved (ping CALLED only during idle periods)
FireBird: SQL execution plan analyzer was added (thanks to tomas303)

SQL Server:

Database objects search was fixed
Metadata reading (unique keys) was fixed
Table comments editor was fixed
DateTimeOffset data type support was fixed
New extension requires Microsoft driver only

Oracle:

Timestamp handling was fixed (for some Oracle server versions)

PostgreSQL:

Non-default databases are disabled by default
Native psql invocation was fixed (for old PG versions)
CSV files: columns and foreign keys reading was fixed
H2: embedded database shutdown procedure was fixed
A lot of minor fixes in UI and metadata processing

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

The phpMyAdmin team is pleased to announce the release of phpMyAdmin version 4.8.4. Among other bug fixes, this contains several important security fixes.

The security fixes involve:

    Local file inclusion (https://www.phpmyadmin.net/security/PMASA-2018-6/),
    XSRF/CSRF vulnerabilities allowing a specially-crafted URL to perform harmful operations (https://www.phpmyadmin.net/security/PMASA-2018-7/), and
    an XSS vulnerability in the navigation tree (https://www.phpmyadmin.net/security/PMASA-2018-8/)

In addition to the security fixes, this release also includes these bug fixes and more as part of our regular release cycle:

    Issue with changing theme
    Ensure that database names with a dot ('.') are handled properly when DisableIS is true
    Fix for message "Error while copying database (pma__column_info)"
    Move operation causes "SELECT * FROM `undefined`" error
    When logging with $cfg['AuthLog'] to syslog, successful login messages were not logged when $cfg['AuthLogSuccess'] was true
    Multiple errors and regressions with Designer

And several more. Complete notes are in the ChangeLog file included with this release.

Note that for this release, we experimented with a pre-release announcement so that hosting providers and package managers would have an opportunity to prepare for the security release. If this was helpful to you or if you have feedback about this technique, please let us know through the public list developers@phpmyadmin.net or privately at security@phpmyadmin.net. We may or may not decide use this behavior in the future and your feedback will help us decide whether it's beneficial to the community.

As always, downloads are available at https://www.phpmyadmin.net/downloads/

[close]

https://www.phpmyadmin.net/

[SiLæncer]

Changelog

Add: (64bit) New Split Query Mode* (6908/6920)
Exclusively provide more intuitive and convenient comparison of query content and data browsing content, greatly eliminating the trouble and inconvenience of switching tabs
Add: Split Ctrl key to synchronize horizontal and vertical scrolling (6920)
Fix: Fixed (6778) problem that prevented the table and view objects list from being opened (6908)
Fix: Fixed an issue that caused an exception when the object was initially loaded as the [First] repository in the All databases mode (6905)
Add: (MariaDB 10.3.5+) Support PACKAGES object browsing, new and delete processing (6905)
Fix: (Firebird 3.0+) Fix CREATE PACKAGE New Sample Sample (6905)
Upd: NuoDB component version updated to NuoDb.Data.Client.dll 2.3.0.11 (2018/12/04) (6920)
Upd: IBM DB2/Informix component version updated to IBM.Data.DB2.dll 9.7.4.4 (11.1.4040.4) (2018/11/21) (6908)
Misc: (IBM DB2/Informix) IBM Data Server Client Packages Version 11.1.4 Fix Pack 4 (2018/11/21)
Upd: Others include cumulative small updates, corrections and optimizations (6920)

Vertical browsing mode :

Add: Supports Ctrl key to synchronize vertical scrolling (6920)

Script Generator :

Add: Add more export formats: In addition to the original SQL/CSV, add a new export format such as TSV/PSV/SSV/XLSX/XLS/XML/JSON/HTML/MD (6920)

Security Manager :

Upd: (MySQL) Update user syntax generation issues to be compatible with MariaDB and MySQL (6905)
Fix: (MySQL) Change user password down compatible with 5.7 or later (6905)

Database Migration (Pro):

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

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

Whats new: >>

Improvements in exporting data to HTML and Text/CSV formats.
New export option for Text/CSV target format: Quote character.
New command line option: /QuoteChar.
Minor changes and bugfixes.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

Java 11 support was added
Data transfer: saving for tables/columns mappings was added
Extensions installation/update were fixed on Windows (infinite restart loop)

Object editor:

Actions toolbar UI was fixed
Expand/collapse actions for all list items were added
Foreign key creation dialog was fixed

Data editor:

Dictionary value viewer/editor was fixed (null values, SQLite foreign keys)
Tooltips for foreign key links were added
Shortcuts for data view panels were added (customizable)
Results pagination now supports full data refresh (configurable)
Grid columns width calculation was fixed

SQL editor:

Query timing was fixed
Linked files/folders rename was fixed

PostgreSQL:

UI for active database switching was improved
Interval data type support was improved
Database backup was fixed (schema name quote)
Support for table triggers comment view/edit was added

Greenplum:

Tables DDL show GP-specific options now
Partition tables view was fixed
DB2 z/OS: views definition reading was added
Sybase/SAP ASE/SQL Anywhere: stored procedure list reading was fixed
Vertica: projection columns comments view/edit support was added
MonetDB: driver configuration was added
Many minor UI bugfixes

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Whats new:>>


    Implemented "#57 Analyze database convenience". UPK is formed exclusively for the tables related to the subjects.
    Implemented "#58 receipt += times"
    Fixed "#34 Possible Performance-Improvement in CellContentConverter.toSql"
    Fixed "#59 Retry Deadlock?"
    Automatic adjustment of the number of database connections.

http://jailer.sourceforge.net/

[SiLæncer]

Changelog

- Main program update ( Main ):
Add: (64bit) Added floating query mode ( Float Query Mode* ) (6940)
In addition to the split query mode ( Distributed Query Mode* ), the exclusive way to provide another intuitive and convenient query content and data browsing content, the independent window can be more scalable
Upd: (64bit) Split Query Mode* : Improvements in editor text search and replacement dialog position and related issues (6940)
Add: Add Comment Tips to display (6940)
Column Comments: Included in the Data Editor , Object Navigator , Search Table Data , etc.
Table Comments: Included in the Object Navigator function
Upd: Optimize the main menu and the main work column click processing, you can directly click on the post-processing without having to get the focus (6940)
Upd: SQLite (SQLCipher AES256) component version update from 3.8.10 to 3.20.1 (6940)
Upd: Others include cumulative small updates, corrections and optimizations (6940)
- Quick Filtering Objects
Upd: (SQL Server/SQL Azure/Sybase ASE) Support for search processing including schema.objname, objname (schema), etc. (6940)
Upd: Improved input synchronization processing problem (6940)
Fix: Fixed an issue where SYNONYMS objects were not included in the quick screening process (6940)
- Generating Scripts :
Add: (HP Vertica) Support for Partitioned tables property generation display (6940)
- Table Designer :
Fix: (IBM DB2/Teradata) Fixed a problem with Column Comments getting lost (including generating scripts) (6940)
- Data Editor :
Fix: (Teradata) automatically distinguishes DATE and TIMESTAMP (WITHZONE) date format content, solves problems that cannot be added and updated (including SQL INSERTs output) (6940)
- Database Migration (Pro):
Upd: All updates are the same as dbMigration .NET Software (6940)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

UUID/GUID generate function was added
Data transfer: “truncate target table before load” function was fixed
Redshift: column encoding information was added
Oracle: PS/SQL blocks parser was fixed
Huge code refactoring was made (separation of model and UI plugins)
Many minor UI bugfixes

Data editor:

Open With menu was added (web browser and Excel)
Next page auto-fetch was fixed

ERD:

Save as picture function was fixed (case-insensitive file path)
Attributes visibility configuration was improved

SQL editor:

Parameters biding dialog + results scrolling glitch was fixed
Glitch with first time reading of proposal was fixed
Stored procedure auto-completion was fixed
Syntax coloring: Color Themes support was fixed

SQL Server:

Default schema detection was fixed
Column data type resolution was fixed
Identifiers auto-completion was fixed
NVarchar(MAX) data type resolution was fixed

Exasol:

Exasol V6.1 support was added
Metadata reading performance was significantly improved
Partitions information was added
Security management was improved (roles, priority groups, policies, etc)

PostgreSQL:

Rules support was added (read-only)
Stored procedures (PostgreSQL 11) support was added
Aggregate functions meta information support was added
Database tablespace edit support was added
Reserved keywords update was added

Greenplum:

External table DDL generation fixes were added

[close]

http://dbeaver.jkiss.org/