Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Changelog

- issue #1808  "Improve table structure" generates invalid SQL
- issue        Once checked "Show only active" checkbox is always checked
- issue #1813  Delete rows using "Check All" is broken
- issue        Fix PHP 7 possible binding ambiguity
- issue #11326 Exported schema includes all the tables of the database
- issue #11339 Results not displayed if query ends in delimiter and comment
- issue #11320 Live edit of data fields is not working always
- issue        Table list in navigation collapses when entering into a table in another page
- issue #11364 JS error while trying to auto navigate to db structure page when db creation has failed

[close]

Download : Klick

http://www.phpmyadmin.net/

[SiLæncer]

Fixed :

- issue #11368 SQL error when importing phpMyAdmin dump file

http://www.phpmyadmin.net/

[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

Bugfix:

    Crash in foreign key dropdown editor.
    Crash when killing processes on very long running servers.
    SQL error when accessing UUID and JSON columns in PostgreSQL via SUBSTR.
    MSSQL: Prefer "schema.table" quoting over "schema"."table" when renaming a table.
    Fix column type converted to locale string format by String.ToUpper in TDBConnection.GetCreateCode - prefer String.ToUpperInvariant instead, to avoid funny characters in data types.
    MSSQL: Do not pass "Database=xyz" to connection string if database(s) setting contains more than one database.
    MSSQL: Try to use some universal date/time format, by injecting a "T" between the date and the time portion.
    Fix wrong detection of BIT default values.
    Use "SET search_path TO db" instead of "SET SCHEMA db" for changing a database in PostgreSQL, for downward compatibility reasons.
    Prepend 'E' to escaped PostgreSQL strings.
    Use updated URL for MariaDB Explain analyzer, and encode semicolon in URL parameter.
    User manager: Select "authentication_string" instead of "password" column on MySQL 5.7.6+.
    Fix various selection bugs in column selection panel.
    Fix SQL error in "Copy table" dialog, in PostgreSQL mode. Use lowercase table and column names in IS.TABLES, so PG can find them.
    CSV import: Disable features supported in MySQL only, if active connection is not MySQL.
    PostgreSQL: Always keep public schema in search path, so one can use procedures from it without prefixing.
    Text import: Use very last value from last row, even if it's not followed by a field or line terminator.
    PostgreSQL: Fix wrong ALTER TABLE query for modifying table comment.
    Update VirtualTree component code to v6.1.0, to fix graphical issues in Windows 8 + 10.

Enhancement:

    Show error when SSH port is already in use.
    Add support for PostgreSQL's data types uuid, cidr, inet and macaddr.
    Strip folder path from various file settings, including plink.exe location, if it's the application directory.
    Try higher ports, up to the 20 next ones, as SSH local port, when the configured one is in use.
    Display session name in caption of all message dialogs.
    Add a custom icon for confirmation dialogs, with a question mark on it, so we don't have to use the "i" icon.
    Use server time for data grid > "Insert value" menu items.
    Show line breaks other than Windows style as normal line breaks in text editor.

New feature:

    Introduce option for setting the line break style in text cells without breaks.
    Session manager: Add support for SSL cipher, and add various texthints.

[close]

http://www.heidisql.com/

[SiLæncer]

SQLiteSpy is a fast and compact GUI database manager for SQLite. It reads SQLite 3 files and executes SQL against them. Its graphical user interface makes it very easy to explore, analyze and manipulate SQLite databases.

License:    Freeware for personal and educational use.

Whats new: >>

Update built-in DISQLite3 engine to SQLite 3.8.11.1, including new Full Text Search 5 (FTS5).
Fix table browsing if INTEGER PRIMARY KEY column contained ^ characters.
Try to detect UTF-8 encoding if loading an SQL file without BOM.

http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index

[SiLæncer]

Whats new:>>

- issue #11367 Export after search, missing WHERE clause
- issue #11380 Incomplete message after import
- issue        Incorrect scalar type declaration (reported under PHP 7)
- issue #11389 ReCaptcha produces deprecated messages under PHP 7
- issue #11387 phpseclib < 2.0 produces deprecated messages on PHP 7
- issue #11404 "Switch to copied table" doesn't work
- issue #11406 Missing quotes after calling "distinct values"
- issue #11386 Cannot import database with long data in one column
- issue #11410 SPATIAL index option is not clickable

http://www.phpmyadmin.net/

[SiLæncer]

Changelog

Main Program Update ( Main ):

Add: Integration dbMigration .NET - A universal database migration tool Universal Database migration tool
Add: Progress window minimize the main window to increase the function keys ( Minimize Main Window ): easy to be handled in the context of the
Fix: Fixed When [schedule] window display minimize [main] window, when the reduction will lead to progress window not properly closed issues
Fix: Fixed avoid the repository object failed to load, the program can not continue to cause problems processing
Upd: Open VIEW object contains multiple data tables when editing, post during browsing, click Cancel process will not continue to turn the rest of the data table
Fix: (Access) correction can not browse the [field contains the data table name] VIEW object processing (including other similar process)
Fix: (Firebird) Correction (55xx) lead to data table properties page message display (Statistics) issue stalled
Upd: (Firebird 3.x) to update user-defined data type object display (User-Defined Data Types) (Domains)
Upd: SQLite element updated to System.Data.SQLite.dll 1.0.98.0 (3.8.11.1) (2015/08/19)
Upd: IBM DB2 / Informix element updated to IBM.Data.DB2.dll 9.7.4.4 (10.5.6.4) (2015/08/17)
Misc: (IBM DB2 / Informix) IBM Data Server Client Packages Version 10.5 Fix Pack 6 (2015/08/17)
Upd: NuoDB element updated to NuoDb.Data.Client.dll 2.3.0.4 (2015/08/17)
Upd: MySQL element is updated to version 6.9.7 MySql.Data.dll (2015/08/05)
Upd: Accumulated other contains minor updates, correction and optimization

Data definition language ( Data Definition Language (DDL) ):

Upd: (Firebird) when the text type of field coding is different from the preset library will display its encoded form (CHARACTER SET xxxx)
Upd: (PostgreSQL) subdivision Serial (automatically generated) and integer (custom build) sequence object (nextval'xxxx ') processing

Batch script generation ( Generating Batch Scripts ):

Upd: Update Sequence objects (SEQUENCES) display order to facilitate priority when checking

AutoComplete and perception ( AutoComplete and IntelliSense * ):

Upd: Improved User Experience: Data tables and fields automatically sense the process, are the recommended mode (Suggestion mode) display Regardless of the setting
Fix: Fixed (569x) cause problems AutoComplete text mode settings can not be displayed properly on the

The tying SQL statement variables ( Binding SQL variables ):

Fix: Problems omissions supported under (SQLCe) Correction trading patterns

Information column editing ( Data Editor ):

Upd: edit or import the field is numeric type (Numeric), but data show Brin type (Boolean) when the automatic conversion process
Fix: (Informix) to solve new problems and update content material if containing newline (CRLF) characters, can not be successfully treated (5713)
Upd: Data Grid Editor ( Cell Editor * ): joining save failed exception message display processing

Data Import ( Data Import ):

Fix: Right menu directly into the data table processing: 1. Support the specified field in the first column or not processed, 2. Data content analysis processing with Preview Import Processing
Fix: (HP Vertica) [temporarily] batch import can not solve the problem of

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Apache Derby extension was added (view source, sequences, etc)
SQL editor now scrolls to error position (Oracle, MySQL, PostgreSQL, Firebird, Derby)
Output messages were fixed (MSSQL)
Sequences were fixed (PostgreSQL)
MongoDB 3.x support added
Preference pages were redesigned
Plaintext results presentation configuration was added
Eclipse 4.5 (Mars) support added for plugin version
CSV export config improved
ERD export in GraphML format was added
A few hanging/UI freeze problems were fixed
Misc UI bugs were fixed

[close]

http://dbeaver.jkiss.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: >>

Minor changes in exporting to HTML and RTF.
New expression engine functions.

http://www.vlsoftware.net/

[SiLæncer]

Snap DB is a simple, lightweight and customizable flat-file database application. Columns can be easily created, deleted, renamed and moved, and it has an instant search to provide rapid access to the stored information.

License: Freeware

What's new: >>

When printing, added ability to add the header row into the output.

http://skwire.dcmembers.com/wb/pages/software/snap-db.php

[SiLæncer]

Changelog

- SQL editor ( SQL Editor ):
 Upd: significantly improve the speed of processing text search to solve a serious impact performance when searching the contents of a larger issue (5725)
- Data Import ( Data Import ):
 Upd: Support Import failed retry processing (5725)
- Column editing and browsing data ( Data Editor and Browser ):
 Show Exclusions wrong question correction Microsoft.SqlServer.Types field data is NULL (5725): Fix
- Data definition language ( Data Definition Language (DDL) ):
 Upd: Updated data sheets Notes (Table comments) generation problems (5725)
 Fix: Fixed (5695) omit GO processing exclude (SybaseASE / DB2 / Informix / Teradata) and other repositories, because of their built-in batch processing is not complete with the rules (5725)
- Main Program Update ( Main ):
 Upd: Improved servo version repository after [New] Connection failure handling (5725)
 Upd: Improved User Experience: The original part of the function to the Edit menu to move to the next file menu (Edit: Open / Save / SaveAs -> File) (5725)
 Upd: middle mouse button to close the tab (Middle-Click to Close Tabs): changed to directly close the mouse is pointing tab (5725)
 Show the improved tab handling sequential Close (5725): Upd
 Fix: issues related to the multi-screen (Multiple Monitors) when the main display is set in [R] when the amendment (5725)
 Upd: (IBM DB2 / Informix) Update PROCEDURE / FUNCTION open design (Design) generated UPDATE syntax (5725)
 Upd: (Excel) When you create a blank database, first as a field name no longer need to ask (5725)
 Fix: (Excel) Correction (5393) results can not add a blank database issues (5725)
 Upd: PostgreSQL components updated to Npgsql.dll 2.2.6 (2015/08/27) (5725)
 Upd: Accumulated other contains minor updates, correction and optimization (5725)
 Misc: Compatible with SQL Server 2016 CTP 2.3 (2015/09/02)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

- issue [security] reCaptcha bypass

http://www.phpmyadmin.net/

[SiLæncer]

Database .NET is a simple, uniform and intuitive database management tool for multiple databases. It makes Local and Remote database administration easier without installing anything. With it you can Create databases, Design tables, Edit data, Export data, Generate scripts and run SQL queries.

An innovative, powerful and intuitive multiple database management tool, based on .NET Framework 4.0.

Freeware

Whats new: >>

Changelog

SQL editor:

Fix: Fixed (5725) led to replace all word processing (Replace All) produces the wrong question (5735)

Main Program Update:

Fix: Fixed Teradata script generated content, if unable to complete more than one row contains a problem is displayed (5735)
Upd: Improved Teradata database provide a more complete error message is displayed (5735)
Upd: NuoDB element updated to NuoDb.Data.Client.dll 2.3.0.5 (2015/09/09) (5735)
Upd: Teradata components updated to Teradata.Client.Provider.dll 15.11.0.0 (2015/09/08) (5735)
Upd: Accumulated other contains minor updates, correction and optimization (5735)
Misc: Compatible with NuoDB 2.3.1 (2015/09)
Misc: (Pro) New Database .NET Professional (64bit) ( Native 64bit and Built-in Database Migration )

Display informational message ( Displaying informational messages ):

Upd: avoid problems repeating the same message is displayed (5735)

Database migration ( Database Migration ) (Pro):

Upd: (Pro) improved maximum processing Decimal data type, the length of the field when the source exceeds the purpose of field, automatically takes the maximum value (with other data types) (5735) The purpose of the data fields

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

- issue #11411 Undefined "replace" function on numeric scalar
- issue #11421 Stored-proc / routine - broken parameter parsing
- issue        Missing name for configuration read_as_multibytes
- issue #11431 Incorrect "No row selected" message
- issue #11447 MySQL 5.5 and the language system variable
- issue #11452 Semantics of export and import icons are mixed up
- issue #11451 Designer-Bug in move.js on multiple server configuration
- issue #11458 Invalid UTF-8 sequence in argument
- issue #11457 Request URI too large
- issue        Invalid argument supplied for foreach()
- issue #11461 Foreign key constraints for InnoDB tables with upper-case letters disabled
- issue #11487 Warning when entering Query page

http://www.phpmyadmin.net/

[SiLæncer]

Changelog

SQL editor ( SQL Editor ):

Add: When adding file changes when the outside environment detection (Detect when file is changed outside the environment)
Upd: unified process newline characters (carriage return (CR) and line feed (LF)), to avoid the parsing error

Database migration ( Database Migration ) (Pro):

Add: allows the [same] source and destination connection, [different] columns data sheet consolidation process (5742)
Fix: (SQLCe / SQLAzure / SQLServer / Sybase) correction data column can not be merged when the problem data sheet containing the auto-increment fields (IDENTITY) of (5742)
Upd: source and destination data table the same as the auto-increment field (AUTO_INCREMENT), will retain the source increment value (5742) non-merger
Fix: Fixed some source repository status bar is not displayed correctly (NOT NULL) of (5742)

Main Program Update ( Main ):

Fix: (Teradata) to solve the problem can not be processed CREATE / REPLACE PROCEDURE statement of the (5742)
Upd: PostgreSQL components updated to Npgsql.dll 2.2.7 (2015/09/18) (5742)
Upd: NuoDB element updated to NuoDb.Data.Client.dll 2.3.0.6 (2015/09/15) (5742)
Upd: Firebird components updated to FirebirdSql.Data.FirebirdClient.dll 4.8.0.0 (2015/09/14) (5742)
Upd: Accumulated other contains minor updates, correction and optimization (5742)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new: >>

Minor changes.

http://www.vlsoftware.net/