Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Changelog

- The main program update ( the Main ):
Add: Added to browse delimited text file function ( Browsing the Text Delimited Files ) (5981/5989)
Automatic Identification text file separator character (comma, tab, pipe, semicolon and custom delimiter) the file encoding
You can query SQL commands way to browse and convert other formats
Right-click the table to increase other formats conversion process (5989)
Upd: Firebird element updated to FirebirdSql.Data.FirebirdClient.dll 5.0.5.0 (2016/05/24) (5989)
Boolean Data Type Support and SRP authentication
Upd: HP Vertica element updated to Vertica.Data.dll 7.2.3 (2016/05/23) (5989)
Upd: Cumulative contain other minor updates, fixes and optimization (5989)
Misc: the with the PostgreSQL Compatible 9.5.3 / 9.4.8 / 9.3.13 / 9.2.17 / 9.1.22 (2016/05/12)
- Row editing and browsing ( the Data Editor and Browser ):
Upd: table primary key (Primary Keys) support for [all] data type handling (contains multiple related functions) (5989)
- Database Migration ( Database Migration ) (Pro):
Add: New source-separated text file conversion process (Delimited Text Files) (5981)
Upd: table data synchronization ( the Data Synchronization ): table primary key (Primary Keys) support for [all] the types of data processing (5989)
- Data Import ( the Data Import ):
Upd: import formats delimiters automatic determination process (Auto-detect delimiter): increase the Tab delimiter detection process (5981)
- Automatically and perception ( the AutoComplete and IntelliSense * ):
Upd: Optimization table fields automatically senses the added characters # exception processing table (5981)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

External projects/external SQL files are now managable
OS shell integration was added
Resource management was improved
SQL preview in data editor
Oracle: TNS names usage was fixed
PostgreSQL: SQL completion was fixes
PostgreSQL: schema and tables rename support was added
MySQL: functions source code read was fixed
MySQL: binaries dump in hex support was added
Cassandra: timestamp representation is now configurable
Teradata: tables, views, procedure DDL
SQL editor tabs can be pinned
SQL editor “link with navigator” command was improved
SQL completion now uses fuzzy search
ERD uses table filters
Binaries presentation was fixed
A lot of bug fixes and UI improvements

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

4.6.2 (2016-05-25)
- issue        [security] User SQL queries can be revealed through URL GET parameters, see PMASA-2016-14
- issue        [security] Self XSS vulneratbility, see PMASA-2016-16
- issue #12225 Use https for documentation links
- issue #12234 Fix schema export with too many tables
- issue #12240 Avoid parsing non JSON responses as JSON
- issue #12244 Avoid using too log URLs when getting javascripts
- issue #12118 Fixed setting mixed case languages
- issue #12229 Avoid storing objects in session when debugging SQL
- issue #12249 Fix cookie path on IIS
- issue #11705 Fix occassional 200 errors on Windows
- issue #12219 Fix locking issues when importing SQL
- issue #12231 Avoid confusing warning when mysql extension is missing
- issue        Improve handling of logout
- issue        Safer handling of sessions during authentication
- issue #12209 Fix server selection on main page
- issue #12192 Avoid storing full error data in session
- issue #12082 Fixed export of ARCHIVE tables with keys
- issue #11565 Add session reload for config authentication
- issue #12229 Do not fail on errors stored in session
- issue #12248 Fix loading of APC based upload progress bar

[close]

Download : Klick

http://www.phpmyadmin.net/

[SiLæncer]

SSuite Office - MonoBase enables you to create unlimited databases with unlimited tables, fields, and rows. This all in one database creator also includes an easy-to-use custom report builder. You will also be able to interface with ODBC (Open Database Connectivity) compatible databases and create custom reports for them.

Freeware

Changelog

  - Export data in CSV or XML format
  - Master / Detail view on linked tables
  - One click table and data form creation
  - Added 2D/3D charting on custom SQL Queries
  - Insert or paste Images with unlimited size for archiving
  - Enhanced data handling for edit/insert and viewing of data
  - Tables now have referential integrity with primary and secondary keys
  - Added ODBC drivers and translators for MS Excel, SQL Server, Paradox, Access, dBase, and Text files etc.

[close]

http://www.ssuitesoft.com/database.htm

[SiLæncer]

Changelog

SQL completion fixed
Tables data export fixed
Grid control UI fixed
Arrays edit support added
Misc minor UI fixes
MySQL: index creation fixed
MySQL: extra keywords support
PostgreSQL: functions rename/delete fixed
PostgreSQL: functions, tables comments read/write
PostgreSQL: CHECK constraints
Cache: streams reading
Redis: keys navigation improved
Redis: commands execution in SQL editor

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

- The main program update ( the Main ):
Add: Support Firebird 3 Embedded Server mode (Property -> Client Library = fbclient ) (6001)
Add: Support Firebird (Run as an Application) for the execution mode processing application (6001)
Add: increase Firebird Client Library path specifies the location (Property -> Client Library Path) : easy to switch between different versions (6001)
Upd: Improved tying dialog (Binding Dialog): Enter the text at the end of the contraction (blank characters and line breaks, etc.) processing (6001)
Upd: Improved Database [Backup and Restore] prompt message handling (6001)
Fix: (Oracle) solve different ending Functions; character display mode, the problem may affect the implementation of compilation (6001)
Upd: Cumulative contain other minor updates, fixes and optimization (6001)
Upd: HP Vertica element version [Back] Update to Vertica.Data.dll 7.2.3 -> 7.1.2 (6001)
Misc: the with Compatible the SQL Server 2016 the RTM (2016/05/31)
- Database Migration ( Database Migration ) (Pro):
Add: increase in test mode only the first 100 test process (Only Top 100 Rows) (6001 )
Upd: Improved Firebird (Super / Embedded Service and Application ) automatic detection process (6001)
Add: increase Firebird database connection settings (Help-> Options-> Firebird Database Settings ) (6001)
Fix: Fixed (5959) led to double-click can not change other types of data processing outside (6001) after [Objective field]
Upd: command line processing ( the Command-Line ):
Fix: Fixed custom object table approach, original -srctable | desctable: old_a | new_a to -srctable @ desttable: old_a @ new_a ( 6001)
Upd: Improved automatically match the field data types ( the Automatic Mapping Types & ):
Upd: optimization GUID / money / currency / char type data from sources such as the automatic matching process (6001)
Fix: Fixed Oracle numeric data type automatic matching process (6001)
Fix: Fixed length data location type is not the end of the show, many issues related to treatment (such as INTERVAL YEAR (x) TO MONTH ... etc) (6001)
- Automatically and perception ( the AutoComplete and IntelliSense * ):
Upd: Increase in the membership list (List Members) shortcut Ctrl + Space (with Ctrl + J) (6001)

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

Freeware

Whats new: >>

Improvements in database grid.

http://www.vlsoftware.net/

[SiLæncer]

Release Notes

# Functionality Added or Changed
- The version of the tcmalloc library included in MySQL distributions was very old. It has been removed and is no longer included with MySQL.
# Bugs Fixed
- INSERT with ON DUPLICATE KEY UPDATE and REPLACE on a table with a foreign key constraint defined failed with an incorrect “duplicate entry” error rather than a foreign key constraint violation error.
- Setting sort_buffer_size to a very large value could cause some operations to fail with an out-of-memory error.
- Several potential buffer overflow issues were corrected.
- If the CA certificate as given to the --ssl-ca option had an invalid path, yaSSL returned an error message different from OpenSSL. Now both return SSL connection error: SSL_CTX_set_default_verify_paths failed.
- Some string functions returned one or a combination of their parameters as their result. If one of the parameters had a non-ASCII character set, the result string had the same character set, resulting in incorrect behavior when an ASCII string was expected.
- A null pointer dereference of a parser structure could occur during stored procedure name validation.
- mysqld_multi displayed misleading error messages when it was unable to execute my_print_defaults.

[close]

http://www.mysql.com/

[SiLæncer]

Changelog

Fixed problem with DBeaver startup on some machines
Cell value editor redesigned
Array data type support
Help system fixed
SQL editor auto-save feature was added
SQL editor encoding issues were fixed
SQL preview dialog encoding issue was fixed
SQL editors reopening was fixed
Netezza extension has been added
PostgreSQL: security exception handling
MySQL: database import tools was fixed
DB2: DDL extraction fixed ( for old drivers)
EE version now supports incremental version update
Misc UI fixes

[close]

http://dbeaver.jkiss.org/

[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.13.0.
Add the JSON extension.
Example: SELECT json_extract('{“a”:2,“c”:[4,5,{“f”:7}]}', '$.c[2].f');
Add the Session extension.
Example: SELECT * FROM generate_series(0,100,5);

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

[SiLæncer]

Changelog

MAIN PROGRAM UPDATE ( the Main ):
Add: (Oracle / Firebird 3) increased Kit objects (Packages) in the stored procedure and function objects (Procedures / Functions) display and perform other functions (6015)
Fix: (Oracle) complete address different Procedures / Functions / Packages end; character display mode issues, affecting the implementation of compilation (6015)
Upd: (Oracle) database update delete (DROP USER), increase CASCADE property processing (6015)
Upd: (Firebird 3) Client Library can automatically correct the wrong set of issues (6015)
Fix: When executed automatically when not in heavy brush correction object tab page, will lead to [show] unusual problems (6015)
Upd: Cumulative contain other minor updates, fixes and optimization (6015)
Upd: IBM DB2 / Informix element updated to IBM.Data.DB2.dll 9.7.4.4 (11.1.0.4) (2016/06/16) (6015)
Misc: the with Compatible the IBM the DB2 11.1 (2016/06/16)
Misc: the with Compatible the MySQL 5.7.13 (2016/06/02) / the MySQL 5.6.31 (2016/06/02) / the MySQL 5.5.50 (2016/06/02)
BIND STORED PROCEDURES AND FUNCTIONS PARAMETERS ( the Binding Procedure To the Parameters and Function ):
Add: (Oracle) Support Procedures / Functions / Packages object returned REF CURSORS data set show (6015)
Upd: Error objects stored procedures and functions (Procedures / Functions) perform no longer occurs directly off, easy to modify the start-up process (6015)
Upd: When text and automatically add the relevant date type input quoted for (6015)
TRANSACTION MODE PROCESSING ( the Transaction Mode ):
Add: (SQL Server / SQLAzure) was added LOCK_TIMEOUT treatment, to avoid locking problems cause the program can not continue to operate (6015)
Fix: Fixed not support automatic switching current Schema Issues (6015)
Fix: Fixed not support the display of informative messages ( the Displaying informational to be messages ) Issues (6015)
SEARCH ROW( the Find the In the Grid ):
Fix: Fixed [specify field] The search is case of NULL or Byte [], the problem still searching for the other fields of the (6015)
Upd: increase Exclude binary data type (Byte []) and non-visible field (Visible = False) content search (6015)
QUERY DESIGN TOOLS( Query Builder )
Add: Support aggregate function generating process (Aggregate Functions): Count / Min / Max / Sum / Avg / Group By ... and others (6015)
Upd: Selected query criteria to the query generator ( the Selected to the Text Query Builder ): Improved ORDER BY, GROUP BY reducing treatment non-Alias ​​field when the (6015)
BATCH SCRIPT GENERATOR ( Generating Batch the Scripts ):
Fix: (Oracle) Fixed SQL INSERTs Export Processing: When not in use GO batch process to generate command is missing; end character (6015)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

includes the regularly scheduled maintenance
improvements and bug fixes.
In addition to bugs affecting particular version combinations, some of the other bugs fixed include:
Fixing cookie path on Windows
Fix MySQL SSL connections with some PHP versions
Fix listing of routines for non-privileged user

[close]

http://www.phpmyadmin.net/

[SiLæncer]

Alternate Firebird Copy is an application that was created in order to help users handle tables that are contained in Firebird or Interbase databases. It will allow them to easily select the preferred databases and copy the required tables.

Freeware

Whats new:>>

Correction for home folder.

http://www.alternate-tools.com/pages/c_fireupdate.php?lang=ENG

[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

[ADDED]: SQLCipher plugin is now free, open source and distributed together with other standard plugins.
[ADDED]: #2963 Indexed expressions for CREATE INDEX statements (introduced in SQLite 3.9) are now supported and can be edited in Index Dialog.
[ADDED]: View window now supports explicit column names for the view (introduced in SQLite 3.9).
[ADDED]: #3056 #3063 Implemented index column ordering in index dialog.
[ADDED]: Added shortcut (Ctrl+/ by default) to toggle comment of current line or selected block of code (if any) in SQL editor.
[ADDED]: #3040 Added new entry in context menu of data grid to generate SELECT/INSERT/UPDATE/DELETE statement together with WHERE clause containing IN conditions for selected cells.
[ADDED]: Added new entry in context menu of database list to generate queries like in #3040 for selected table.
[ADDED]: #2975 Information message after successful table/view change.
[ADDED]: Introduced "loadByDefault" property for plugin descriptor files.
[ADDED]: Added options to have "Data" tab placed as a first tab for Table windows and for View windows. By default option is disabled, so by default nothing changes.
[ADDED]: Added option in configuration dialog to avoid reopening status panel for each message printed there.
[ADDED]: Added option in configuration dialog to prevent displaying tooltips over data view when user holds mouse over it.
[ADDED]: #3070 Added option in configuration dialog to have new databases marked as not permanent by default.
[ADDED]: #3070 Added option in configuration dialog to bypass database dialog completely when dropping file from file manager onto database list.
[ADDED]: #3013 When double clicking on empty space in list of indexes or tables (in table or view window) the action is not ignored, but a dialog opens for adding new item.
[CHANGE]: DbAndroid plugin has now JAR file embedded and you can get it from Tools menu.
[CHANGE]: SQLite version updated to 3.13.0.
[CHANGE]: Qt version updated to 5.6.0. Should still compile with 5.3, but binary distributions on homepage will be made with 5.6.
[CHANGE]: Foreign key dropdown (when editing FK cell) uses now more readable set of columns and column headers can be resized.
[CHANGE]: Column dialog validates scale and precision fields (against INTEGER PRIMARY KEY and against each other).
[CHANGE]: Structure tab in table window has now fully named headers in column list.
[CHANGE]: Table and View window options moved from Look & Feel configuration page to Data Browsing page.
[CHANGE]: All database list options moved to a separate Database List configuration page.
[CHANGE]: Window list in main menu -> "View" -> "Window list" is not sorted alphabetically.
[BUGFIX]: Not loading Android plugin by default (needs manual load from configuration dialog), which stops the "ADB" error for people not using the plugin.
[BUGFIX]: #2927 Several critical bugs fixed and enhancements to table modification algorithm related to foreign keys.
[BUGFIX]: #2954 #2803 #2937 Fixed incorrect recreation of foreign keys chain.
[BUGFIX]: #3008 Editing foreign key cell with more than 10 000 possible values will now use simple text editor, not dropdown. It also loads values asynchronously.
[BUGFIX]: Fixed importing from CSV with some of lines containing less fields than defined in header (or in first data row).
[BUGFIX]: #2989 Fixed multiline value handling in CSV import plugin.
[BUGFIX]: #2921 Fixed empty values as NULL handling in CSV import plugin.
[BUGFIX]: #3034 Fixed handling empty string as value for DEFAULT constraint.
[BUGFIX]: #3064 Fixed locking database executions when counting rows in huge tables.
[BUGFIX]: DbAndroid plugin has fix for null pointer in the JAR when client has disconnected
[BUGFIX]: Error message details were missing in some cases (when smart execution method failed at parsing stage). This is fixed now.
[BUGFIX]: #3026 #3027 #3043 Fixed RAISE() function formatting in enterprise formatter (used to produce invalid SQL).
[BUGFIX]: #3015 Fixed error with DEFAULT constraint containing datetime('now', 'localtime').
[BUGFIX]: #3000 Fixed compilation errors for Qt >= 5.5.
[BUGFIX]: #2956 Fixed unexpected data refresh when clicking in the right side of value filter field in table window.
[BUGFIX]: #2991 #2928 #2929 #2941 #2960 Fixed executing "garbage" query, causing application crash.
[BUGFIX]: #2920 Fixed removing several databases.
[BUGFIX]: #3068 #3066 Fixed database removal confirmation dialog so the message asks about removing it from the list, not deleting it.
[BUGFIX]: #3073 Fixed crash when unloading plugin with its own configuration subpage and saving config dialog.
[BUGFIX]: #2931 #2962 Fixed incorrect results when executing 2-level queries with an expression and an alias combination as a result column definition.
[BUGFIX]: #2942 Fixed deleting multiple tables/indexes/... when selected them and picked "Delete table/index/..." from context menu.
[BUGFIX]: #2945 Fixed manual reordering of database objects with Drag&Drop.
[BUGFIX]: #3055 Fixed crash when exporting on MacOS using plugin that requires column value length information (such as PDF export plugin).
[BUGFIX]: #3047 Fixed copying/moving tables together with indexes or triggers with Drag&Drop across same SQLite version databases.
[BUGFIX]: #3012 SQL simple formatter plugin does not load by default from now on. It is still available, but won't load until manually loaded.
[BUGFIX]: Table window for new table (just created) will now properly close when that table gets deleted immediately by the user.
[BUGFIX]: #2998 Fixed reading decimal values from database when using simple execution method (a fallback in case of some problems).
[BUGFIX]: #2999 Fixed working on objects from database that on the list is named "main".
[BUGFIX]: Fixed error detection when selecting column from incorrect table alias (http://forum.sqlitestudio.pl/viewtopic.php?f=11&t=1051).
[BUGFIX]: #3046 Fixed scale & precision fields in column dialog so it's possible to delete their values from the column.
[BUGFIX]: Vacuum invoked from context menu on database list is now executed in SQL editor and is asynchronous.
[BUGFIX]: #3001 Order of objects exported by Export Dialog is now alphabetical (in object type groups).
[BUGFIX]: #3022 Fixed parsing of some expressions, resulting in this particular bug report in being unable to browse view results.
[BUGFIX]: Enhanced floating point numbers handling.
[BUGFIX]: Fixed formatting of INSERT and UPDATE statements.
[BUGFIX]: Enterprise formatter no longer puts new lines when formating list of elements in "IN" clause.

[close]

http://sqlitestudio.pl/

[SiLæncer]

Whats new:>>

SERVER-24054: JS segmentation fault on load of certain NaNs.
SERVER-24058: Connection pool asio doesn’t honor setup timeouts.
SERVER-24117: Mongo binaries ELF stack has become executable.
All issues closed in 3.2.7

https://www.mongodb.com/