Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Changelog

Results viewer UI was fixed and improved
Plaintext results viewer was fixed (columns width, scrolling, etc)
Dark theme support was improved
Single entity diagrams (ERD) were improved (show more connections)
Hex editor UI was fixed
GTK: context menus was fixed
GTK: UI freeze in cell editors was fixed
Vertica extension was added (views and procedure source code)
SQL Server & Vertica: big resultsets reading was fixed
PostgreSQL procedures source code viewer was improved
DB2: nanoseconds support in date/time data types was added
Cassandra: BLOBs columns reading was fixed
MongoDB: JSON & XML viewer added
Many minor UI fixes

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

- bug #4851 PHP errors in login dialogue
- bug #4207 json_encode error due to strftime returning non utf8 chars in Windows 8.1 Chinese version
- bug #4845 White screen (Cloudflare)
- bug #4794 Server error viewing table content
- bug       Fix issues related to number of decimal places in time
- bug #4853 Relation view between 1600 and 1780 px
- bug       PHP 7 compatibility in php-gettext
- bug       PHP 7 compatibility in bfShapeFiles
- bug       PHP 7 session_regenerate_id() warning
- bug #4857 Alter table after changing column name error
- bug #4830 Maximum execution time exceeded in Util.class.php

[close]

Download : Klick

http://www.phpmyadmin.net/

[SiLæncer]

Changelog

Column editing and browsing data ( Data Editor and Viewer ):

Upd: Edit mode with different background color of the selected cells clearly distinguish whether the information can be edited (5588)
Upd: New data fields allow the column to NULL, but for Computed Columns or UNION operations midnight New Processing (5588)
Upd: [Advanced Editing] removes display virtual field (Virtual Columns) in the (5588)
Upd: (SQL Server / SQL Azure) can not be read to solve problems Microsoft.SqlServer.Types field type information (5588)
Fix: Correction [no primary key] update processing, direct input NULL when problems can not be updated (5588)
Fix: (Firebird) correction due to RDB $ DB_KEY field back in time with a different name, resulting in the update-related issues (5588)

Data Import ( Data Import ):

Add: Support to import the selected fields ( Importing specific fields ) (5588)

Data Export ( Data Export ):

Upd: instruction code generation (SCRIPT AS -> Data (INSERTs)): simplification (less) generates data content, eliminating the need for field data for processing NULL (5588)

Generate Data Definition Language ( Data Definition Language ):

Upd: (SQL Server / SQL Azure) update (Column / Index / Trigger comments) database object scripting exception message generated annotation characters (') processing (5315)

Master Program Update ( Main ):

Upd: significantly improved connection attribute set (Connection Properties):
Add: Added Sybase ASE complete connection property is set (5588)
Upd: full display SQLCe hidden connection property is set (5588)
Upd: exclude [Repeat] and [without Display] property is set (5588)
Upd: full display default connection properties (5588)
Upd: Updated Firebird default character encoding to connect (Character Set = UTF8) (5588)
Fix: Can not update Firebird Default connection correction character encoding (Charset) problem properties (5588)
Contains Firebird / SQLite / SQLCe, MySQL / NuoDB / Teradata / DB2 / Informix / Oracle / PostgreSQL / Vertica / SQL Server / SQL Azure databases, etc. (5588)
Upd: Firebird components updated to version 4.6.2.0 FirebirdSql.Data.FirebirdClient.dll (2015/04/16) (5588)
Upd: Accumulated other contains a small update, correction and optimization (5588)

[close]

http://fishcodelib.com/Database.htm

[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

What's new: >>

- Addressed issues with creating new connections

http://www.dbsoftlab.com/database-editors/database-browser/overview.html

[SiLæncer]

Changelog

- bug #4863 Edit vs Change
- bug #4859 Don't scroll (to bottom) when editing multiple rows
- bug #4862 Misaligned Inline edit field
- bug #4861 Use of undefined constant PMA_DRIZZLE
- bug #4865 sprintf(): Too few arguments
- bug #4866 Limit column ordering in index edit dialog
- bug #4867 Incorrect ALTER TABLE statement generated
- bug #4870 Inconsistency in 'Ignore' checkbox in insert page
- bug #4869 Drop column action not asking to confirm
- bug #4871 Error on creating table - bug Undefined index: Rows

[close]

Download : Klick

http://www.phpmyadmin.net/

[SiLæncer]

Changelog

- Master Program Update ( Main ):
 Add: Added link list search function ( Search Connection Explorer ) (5595)
 Add: Support servo version deleted repository (structural description) treatment (Database Tools -> Drop Databases and Schemas) (5595)
 Database contains SQL Server / MySQL / Sybase ASE, etc.
 Structural description contains PostgreSQL / DB2 / Informix / NuoDB / Oracle / Teradata / Vertica, etc.
 Add: New structural description processing (Database Tools -> Create Schema): increase of Oracle and Teradata databases, etc. (5595)
 Add: Data Export ( Data Export ): support for export selected fields ( Exporting specific fields ) (5595)
 Upd: Improved (5588) connection attribute set (Connection Properties): set the properties added to our catalog display (5595)
 Fix: corrected multi-screen main window [mouse to drag and manually click] stops the screen boundary treatment (Dock Window) (5595)
 Fix: field AutoFilter ( AutoFilter ): Correction [Edit Mode] under field data type (DateTime) automated screening process (5595)
 Upd: Updated Italian interface language Italian language (by Paolo Saudin) (5595)
 Upd: Accumulated other contains a small update, correction and optimization (5595)
- Data column editing ( Data Editor ):
 Upd: [Add / Update / Import] field DateTimeOffset data type, and not when you specify the time zone (TimeZone), will take the default operating system (5595)
 Add: Data Grid Edit ( Cell Editor * ): Added date picker ( DateTime Picker ): increase DateTimeOffset field type of support (5595)
 Fix: Correction [no primary key] question the edit field is NULL / NOT NULL / {blank} and other updates and search (5595)
- Tying SQL statement variables ( Binding SQL variables ):
 Upd: NULL Check function increases, and a clear distinction between 'NULL' / NULL / BLANK other treatment (5595)
 Upd: adding more can be specified as the default IS NULL conditional processing ( expression {= | <> | = |> |> = |> | <| | <= <!!!} (5595))
- Search and replace function ( Quick Find and Replace ):
 Upd: Use regular expressions (Regular Expression) added exception handling (5595)
 Fix: corrected exactly match (Match Case) handle exceptions if the input characters may cause problems in an infinite loop (5595)
- Object Browser ( Object Navigator ):
 Upd: Click Single Click Double Click and double-click on the object in order to expand and collapse the distinction between different colors for easy identification (5595)
 Upd: Updated Firebird 3.0 Functions and Procedures and other objects display (5595)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

Driver license accept is now required
SQL parameters binding dialog was fixed
Error dialog was fixed
Added drivers configuration for NuoDB, GemfireXD, ExaSol
SQL formatter was fixed
Data transfer DDL generator was fixed
Data transfer performance was improved
LIMIT clause usage was fixed + SQL limit configuration was added
ERD UI fixes
Document renderer (JSON) was improved (MongoDB)
UI freeze on disconnect was fixed

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

SQLite Database Browser is a freeware, public domain, open source visual tool used to create, design and edit database files compatible with SQLite. It is meant to be used for users and developers that want to create databases, edit and search data using a familiar spreadsheet-like interface, without the need to learn complicated SQL commands.

Changelog

Major new features are...

    Our first 64-bit windows release! If you notice any weirdness from it, please let us know. :smile:
    Now using Scintilla for our code editor which brings many nice improvements like brace matching, code folding, error highlighting, multi-line tab and shift+tab, better code completion, help texts, etc.
    Better SQL export
    REGEXP support (see the wiki page for details...)
    NULL value highlighting - customisable in the preferences

Enhancements

    Highlight NULL values in all table views and make the highlighting configurable - #163 and #220 (thanks to @samir-aguiar)
    Use Scintilla as code editor - #260 (thanks to @MKleusberg)
    Allow manually setting the application language in the Preferences Dialog - #182 (thanks to @samir-aguiar)
    Pressing tab on last field of "Browse Data" now auto-creates a new record, making it faster to add new rows - #209 (thanks to @MKleusberg)
    Added an AppData file for all the Linux software centres - #178 (thanks to @glawrence)
    Add an option for the tab size in the SQL code editor - d8cdcbd (thanks to @rp-)
    Add option to name the columns in the SQL export files - #242 (thanks to @schdub)
    Allow schema only export when exporting SQL files - #103 (thanks to @schdub)
    Allow resizing multiple columns at once in the Browse Data tab - #241 (thanks to @schdub)
    Mark syntax errors in the Execute SQL tab after their execution failed - 649b179 (thanks to @MKleusberg)
    Data browsing using Database Structure table selection - #246 (thanks to @MKleusberg)
    Add support for non-integer primary keys in Without Rowid tables - #240 (thanks to @MKleusberg)
    Add option to Preferences Dialog to disable automatic version check - #173 and #208 (thanks to @MKleusberg)
    Improve error messages a little bit - 3c24397, b2b068f, and 808c771 (thanks to @MKleusberg)
    Add support for CR line ending in the CSV import - #212 (thanks to @samir-aguiar)
    Add implementation for the REGEXP operator in SQL code - #215 (thanks to @MKleusberg)
    Allow copying information in About dialog - #222 (thanks to @MKleusberg)
    Set focus to text edit after clearing in Edit Data dialog - 50c0340 (thanks to @samir-aguiar)
    Support MSVC2013 builds - 8cbc13a (thanks to @rp-)

Bug fixes

    Some translations had the Preferences menu in the wrong place on OSX - #200 (thanks to @MKleusberg)
    Fix new version check - 2c25b7e (thanks to @MKleusberg)
    Fix +Infinite and -Infinite Expression on Export Database to SQL file - #244 (thanks to @schdub)
    Fix type of imported BLOB data - #239 (thanks to @schdub)
    Modify Table list selection could be 'fooled' by dragging - #261 (thanks to @MKleusberg)
    There were no file format filters in the Open File dialog when opening a database file - #266 (thanks to @samir-aguiar)
    Escape special characters in headers and values correctly in CSV export - #219 (thanks to @samir-aguiar)
    Grammar parser didn't read foreign key column constraints - #227 (thanks to @MKleusberg)
    Fix crash when having a table with a foreign key referencing a column the name of which uses different upper/lower case characters - #228 (thanks to @MKleusberg)
    Disable actions to save SQL when no file is open - #233 (thanks to @samir-aguiar)
    Don't add file filters on OS X in Edit Data dialog to work around a Qt bug - #230 (thanks to @samir-aguiar)
    Fix bug where sort arrows in the Browse Data tab were pointing in the wrong direction - #231 (thanks to @samir-aguiar)

Translations

    Updated the French translation - d6f9716 (thanks to @mvt91)

Other notes

    New Windows builds
        New 64-bit build
        Updated to QT 5.4.1 (shared dll)
        Bundles SQLite 3.8.9
        Requires the (free) Microsoft Visual C++ Redistributable Packages for Visual Studio 2013 to be installed, available here.
    MacOS X builds
        The standard SQLite build bundles SQLite 3.8.9
        The build including SQLCipher support bundles SQLCipher 3.2.0 (based on SQLite 3.8.6)

[close]

http://sqlitebrowser.org/

[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

New feature:

    Add support for JSON grid export.
    Add support for Markdown Here grid export.
    Support new command line parameter "n", or "nettype", which takes an integer, representing the protocol number (0=mysql tcpip, ...).
    Add support for connecting to Microsoft Azure Servers.
    Add edit box + updown buttons for limiting the size of exported INSERT queries in bytes.
    Display creation time, last alter time, comment and start time of scheduled events.
    Online help document available. Various "Help" buttons in relevant dialogs link to this document.

Bugfix:

    Dropping functions and procedures on PostgreSQL now with required parameters list.
    Size bars in "Database" tab on PostgreSQL now with correct values.
    Loading full grid data on PostgreSQL did not work on text columns.
    Fix microseconds in MSSQL date/time data types, hidden in data and query grids.
    Use ISO 8601 date/time format on MSSQL.
    PostgreSQL: Fix wrong order of columns shown in indexes, and show normal indexes also.
    Do not uppercase ENUM values in procedure parameter datatypes.
    Fix crash when right-clicking a database, following by a click on "Drop".
    Version conditional disabling for "Create new" menu items in MySQL mode only.
    TEXT data type has a maximum length of 65k for MySQL only. Introduce other values for MSSQL and PostgreSQL.
    Fix memory leak in TfrmTableTools.SaveSettings.
    Let longer data type matches win over shorter ones, especially important on PostgreSQL.
    Make TPGConnection.FetchDbObjects compatible to pre-9.0 servers on PostgreSQL.
    Fix non working addition of new columns in MySQL.
    Detect xid type (oid 28) as integer.
    Detect character type (oid 1042) as char, not varchar.
    Detect aclitem[] type (oid 1034) as unknown, not text.
    Fix detection of PostgreSQL data type INTERVAL as VARCHAR.

Enhancement:

    Automatic storing of settings in portable mode.
    Optimize query for getting total row count on PostgreSQL.
    Add support for microsecond precision of MSSQL date/time types in table editor, show these in "Length/Set" column.
    Add a help button to the quite non-intuitive controls on the export dialog.
    Add support for JSON data type on PostgreSQL.
    Add support for HIERARCHYID data type on MSSQL.
    Increase various default values for window dimensions, for reasonable look and feel for new users.
    Add "Rename" context menu item in session tree.
    Use local number formatting in grids by default.
    Use transparent background for NULL cells by default.
    Support columns with a string literal as default value plus an ON UPDATE CURRENT_TIMESTAMP clause.
    Increase compatibility when getting procedure body on MSSQL.
    Remove duplicates from recent file list pulldown.
    Translate connected/disconnected words in status bar.
    Set focus on filter box when SQL help dialog opens.
    Update gettext unit.
    Make search/replace dialog resizable.
    Activate "Clear filter" button after applying text to filter memo.
    Gracefully remove superfluous WHERE keyword from data grid filter, so other places like the previously modified "More filters" menu do not add a second WHERE.
    Use existing data grid WHERE filter to filter values from quick filter > "More values".
    Remove outdated details in readme file, and redirect to official help page instead.
    Detect all array style types on PostgreSQL as unknown type, e.g. TEXT[].
    Pass column or argument name to NativeToNamedColumnType(), as a hint for the user.
    Support quoted datatypes in TDBConnection.GetDatatypeByName, coming from TDBConnection.ParseTableStructure.

[close]

http://www.heidisql.com/

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

http://www.vlsoftware.net/

[SiLæncer]

Changelog

- bug       Table overhead stats: missing space before the unit
- bug       Fix resize icon in Designer
- bug #4879 Exit fullscreen in Designer does not change the button text
- bug #4880 Designer icons missing when using original theme
- bug #4878 Column list of central columns is not cleared
- bug #4881 jQuery dialogs of the Designer are not displayed in fullscreen
- bug #4883 Search function breaks when searching for certain combinations of backslashes and slashes
- bug #4830 Maximum execution time exceeded in Util.class.php (better fix)
- bug #4885 Some icons are above the overlay of jQuery dialogs
- bug #4886 Clicking on external links in advisor rules give JS error
- bug #4888 Filter in central columns does not work in other languages

[close]

Download : Klick

http://www.phpmyadmin.net/

[SiLæncer]

ESEDatabaseView reads and displays the data stored inside Extensible Storage Engine (ESE) database (Also known as 'Jet Blue' or .edb file). It displays a list of all tables available in the opened database file, allows you to choose the desired table to view, and then when you choose a table, it displays all records found in the selected table.

ESEDatabaseView also allows you to easily choose one or more records, and then export them into comma-delimited/tab-delimited/html/xml file, or copy the records to the clipboard (Ctrl+C) and then paste them into Excel or other spreadsheet application.

License:    Freeware

Whats new: >>

Added option to export to JSON file.
Fixed bug: ESEDatabaseView failed to load records on some tables/databases.
Fixed bug: ESEDatabaseView crashed when trying to load a very large binary value.

http://www.nirsoft.net/utils/ese_database_view.html

[SiLæncer]

Changelog

- bug #4890 webkitStorageInfo and webkitIndexedDB is deprecated
- bug #4892 Undefined variable: unique_conditions

[close]

Download : Klick

http://www.phpmyadmin.net/

[SiLæncer]

Changelog

Main program update ( Main ):

Add: Connection administrator ( Connection Manager ): increase new connection handle (Add new connection)
Upd: auto-complete and perception ( AutoComplete and IntelliSense ) When optimizing Click Delete, Backspace keys, etc., automatically exclude unnecessary display processing according to the text before and after (5606)
Upd: Data Export ( Data Export ): Improved exception handling when Excel Export: 2 choose to continue or cancel the process, an increase in the error column and data content display
Upd: servo Edition database connection settings ( Connection Profile ) Improved input connection name (Profile Name) treatment already exists for
Upd: File type library name allows the same name but differ in case [renamed] Processing
Fix: Fixed rename files or directories, and If there is already the case with the same name but distinct issues
Fix: Fixed some table name with a database exception handling problems when characters.
Upd: Change the Teradata transaction isolation level (Isolation Level) (5606)
In order to support comprising: a transaction mode processing ( Transaction Mode ), data import ( Data Import ), execute SQL script file ( Execute an SQL Script File ) and other functions
Upd: Accumulated other contains minor updates, corrections and optimization

Data Table Editor ( Table Designer ):

Fix: Data Sheet primary key selector ( PrimaryKey Selector ): correction data table does not support more than one or more primary key selection processing
Fix: (NuoDB) Fixed edit field is exemplified by type (ENUM), the problem can not be displayed include value (including script generation) (5606)
Upd: When (MySQL) Updated Edition exemplified type (ENUM / SET) display, for example, be displayed only in the length of the position value (5606)
Problems (Oracle 12c) amended AutoIncrement set stalled (5606): Fix

Fix: Data Table Field order (Changing the column order of an existing table) change already exists:

Upd: support the data table contains IDENTITY (x, x) when the field is moving process
Fix: Fixed not added SCHEMA specified processing while improving exception handling problems

Column editing and browsing data ( Data Editor and Viewer ):

Upd: support data field type String Object but the data content when, direct display process
Upd: Improved JSON Array browsing processing
Fix: Fixed right-click menu [Copy] function, if the copy contents contains {...} will not properly handle the issue

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

AutoComplete and perception ( AutoComplete and IntelliSense ):

Add: item list of icons combine my favorite item display ( My favorite Objects )
Add: New Item Shortcut ( Shortcut Keys: F1 ~ F12 ): can be inserted directly specified item, eliminating selection process
Add: All servo version SCHEMA database objects are added to the display, including Procedures / Functions / Sequences / Packages / Macros (with Tables / Views)
Upd: Improved and Correction Sub-Select aware processing capacity
Fix: Fixed led to automate processing part Keywords useless

Main program update ( Main ):

Upd: Improved handling Message dialog box (MsgBox): increased replication error message handling, progress dialog automatically restore the original process, under 125DPI; Fixed display problems
Upd: Data Export ( Data Export ): Memory archive type (Save as type) settings, eliminating the need for the next issue of the open reselect
Upd: Accumulated other contains minor updates, corrections and optimization

[close]

http://fishcodelib.com/Database.htm