Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Changelog

* Fix buffer overruns in to_char()
* Fix buffer overruns in contrib/pgcrypto
* Fix possible loss of frontend/backend protocol synchronization after an error
* Fix information leak via constraint-violation error messages
* Lock down regression testing's temporary installations on Windows
* Cope with the Windows locale named "Norwegian (Bokmål)"
* Fix use-of-already-freed-memory problem in EvalPlanQual processing
* Avoid possible deadlock while trying to acquire tuple locks in EvalPlanQual processing
* Fix failure to wait when a transaction tries to acquire a FOR NO KEY EXCLUSIVE tuple lock, while multiple other transactions currently hold FOR SHARE locks
* Improve performance of EXPLAIN with large range tables
* Fix jsonb Unicode escape processing, and in consequence disallow \u0000
* Fix namespace handling in xpath()
* Fix assorted oversights in range-operator selectivity estimation
* Revert unintended reduction in maximum size of a GIN index item
* Fix query-duration memory leak during repeated GIN index rescans
* Fix possible crash when using nonzero gin_fuzzy_search_limit
* Assorted fixes for logical decoding
* Fix incorrect replay of WAL parameter change records that report changes in the wal_log_hints setting
* Change "pgstat wait timeout" warning message to be LOG level, and rephrase it to be more understandable
* Warn if OS X's setlocale() starts an unwanted extra thread inside the postmaster
* Fix libpq's behavior when /etc/passwd isn't readable
* Improve consistency of parsing of psql's special variables
* Fix pg_dump to handle comments on event triggers without failing
* Allow parallel pg_dump to use --serializable-deferrable
* Prevent WAL files created by pg_basebackup -x/-X from being archived again when the standby is promoted
* Handle unexpected query results, especially NULLs, safely in contrib/tablefunc's connectby()
* Numerous cleanups of warnings from Coverity static code analyzer
* Allow CFLAGS from configure's environment to override automatically-supplied CFLAGS
* Make pg_regress remove any temporary installation it created upon successful exit
* Add CST (China Standard Time) to our lists of timezone abbreviations
* Update time zone data files to tzdata release 2015a for DST law changes in Chile and Mexico, plus historical changes in Iceland.

[close]

www.postgresql.org

[SiLæncer]

Changelog

Data Sheet and view a list of tables ( Table View and List ):

Add: to increase the capacity of the display data table (supporting MySQL / SQL Server / SQL Azure / DB2 / Oracle / PostgreSQL / Sybase ASE / Teradata database, etc.)
Add: Display Data Sheet Notes (Table comments): Added support Vertica database
Upd: When you select to update all the information table statistics synchronized display information related to the data sheet (5519)
Fix: correction (54 ??) update statistics support the cause can not browse the database system issues

Object Browser ( Object Navigator ):

Add: Data Table column header shows the number of data ( RowCount ): Added support for Oracle / DB2 and other repositories
Add: Updates Data Sheet Statistics ( Update Table Statistics ): Added support for Oracle database
Add: Data Sheet Properties page ( TABLE Properties ): Firebird 3.0 increases the data sheet statistics (Statistics) show

Data column editing ( Data Editor ):

Upd: Data format editing and browsing (Cell Editor and Viewer): 1. HEX preset display to Ansi, 2. reduce heavy brush display problems
Upd: Data Grid View (Cell Viewer): Work-related columns support the same Cell Editor Function Switch

Master Program Update ( Main ):

Add: snippet Management ( Code Snippets Manager ): Support preset placeholder definition (Default placeholders)
DATE - Inserts the current date (Custom date format: DATE (yyyy / MM / dd) .
TIME - Inserts the current time (Custom time format: $ TIME (HH: mm: ss).
USER - Inserts the name of the connected user.
MACHINE - Inserts the name of this local computer.
SERVER - Inserts the name of the connected database server.
DBNAME - Inserts the name of the current database.
SCHEMANAME - Inserts the name of the current schema.
OBJECTNAME - Inserts the name of the current object.
(Eg) SELECT FROM SCHEMANAME OBJECTNAME is inserted as SELECT FROM dbo. Test
Upd: rewrite the SQL Server Backup and Restore Processing: Added support for remote data backup and restore processing (5519)
Fix: instruction code generation (SCRIPT AS -> Data (INSERTs)): BOOLEAN correction process BLOB data types and data output problems (5519)
Fix: correction (5448) through the open operating system Database4.exe associated files (File Associations: * .sql; * txt.) When, in the absence of other problems can not be switched connection under the label (5519)
Upd: SQLite components updated to version 1.0.95.0 System.Data.SQLite.dll (3.8.8.2) (2015/02/06) (5519)
Upd: PostgreSQL components updated to version 2.2.4.1 Npgsql.dll (2015/02/03) (5519)
Upd: Accumulated other contains a small update, correction and optimization (5519)
Upd: Update Database .NET Additional Files ( ) (2015/02/05)
Misc: Compatible with PostgreSQL 9.4.1 / 9.3.6 / 9.2.10 / 9.1.15 / 9.0.19 (2015/02/05)
Misc: Compatible with MySQL 5.6.23 (2015/02/02) / MySQL 5.5.42 (2015/02/02)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

DBeaver is a comprehensive and effective software solution geared towards developers and database administrators who need to manage and organize tables, triggers, views and stored procedures from multiple databases.

Freeware

Whats new:>>

Eclipse plugin version now works for older Eclipse versions
SSH auth was fixed
SSH logging was added
Max rows issue was fixed (MS SQL)
MS Access driver was fixed
Results control toolbar was fixed

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

Master Program Update ( Main ):

Add: create a shortcut key to increase the processing task bar and start menu, etc. (Options-> Pin to Start Menu and Pin to Taskbar)
Fix: problem solving selected to perform the task bar and then nail the nail election invalid
Fix: When the nail has been selected to resolve the icon on the task bar, you can not inherit the original problem illustrated execution
Upd: Accumulated other contains a small update, correction and optimization

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

bug Undefined index navwork
bug #4744 Opening console scroll down the page
bug Remove extra column heading in view structure page
bug Add missing confirmation when deleting central columns
bug Undefined index DisableIS
bug #4763 Database export with more than 512 tables fails
bug #4769 Previously set column aliases are destroyed if returned to the same table
bug #4752 Incorrect page after creating table
bug #4771 Central Columns not working, showing error

[close]

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: >>

Fixed bug: ESEDatabaseView displayed incorrect values in date/time fields.

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

[SiLæncer]

Changelog

- Master Program Update ( Main ):

 Fix: When the amendment (5532) fast load handling PK / FK question / UK is not loaded at the same time (5532.3)
 Fix: correction (5532) led to the columns of information can not be multiple-choice questions (5532.2)
 Add: Print function supports the specified list machine ( Specifying a specific Printer ) (5532)
 Add: SQL Server Backup and Restore, support for native connections to remote database specified location ( Specifying a database location for local and remote connections ) (5532)
 Upd: Database chart ( Database Diagram * ): significantly improve the processing speed chart generation library (5532)
 Upd: Object Browser ( Object Navigator ): Right dramatically menu Data Sheets [view / edit / search / Import] to open the processing speed (5532)
 Add: create a shortcut key to increase to deal with the Start menu and taskbar, etc. ( Options-> Pin to Start Menu and Pin to Taskbar ) (5526)
 Upd: when improved when the operating system shutdown Pin function disabled setting process (5532)
 Fix: problem solving selected to perform the task bar and then nail the nail election invalid (5526)
 Fix: When the nail has been selected to resolve the icon on the task bar, you can not inherit the original problem illustrated execution (5526)
 Upd: Accumulated other contains a small update, correction and optimization (5532)
- AutoComplete and perception ( AutoComplete and IntelliSense * ):
 Add: Support cross-repository (Cross-database) data table field sensing processing (SELECT <cols> FROM <database.schema.table> WHERE <cols>) (5532)
 Supports SQL Server / Sybase ASE / PostgreSQL
 Upd: Improved Cross-structural description (Cross-schema) of the data table field perceptual processing (SELECT <cols> FROM <schema.table> WHERE <cols>) (5532)
 Supports SQL Server / Sybase ASE / PostgreSQL / Oracle / MySQL / DB2 / Informix / NuoDB / Teradata / HP Vertica
 Add: After filtering the hidden data table support column aware processing (5532)
 Upd: dramatically improved data sheets and fields associated with perceptual processing speed (5532)
 Fix: solve the table name when the last character table $, the field can not be perceived problem (5532)
 Fix: (MySQL / Oracle / DB2) correction (55 ??) leads to deal with cross-table data structure described problems when exceptions (5532)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new:>>

Fix: When the amendment (5532) fast load handling PK / FK question / UK is not loaded at the same time (5532.3)

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

- bug #4774 SQL links are completely wrong
- bug #4768 MariaDB: version mismatch
- bug #4777 Some images are missing in Designer for original theme
- bug #4767 Drizzle: undefined index in mysql_charsets.inc.php
- bug #4753 Normal field and multi-line field have different margins
- bug #4760 Cannot re-import settings from local storage
- bug #4778 SQL error when database list is sorted by additional columns
- bug #4780 Notice when timestamp column does not have default value

[close]

http://www.phpmyadmin.net/

[SiLæncer]

Whats new:>>

Eclipse plugin update site was fixed
Parameters binding dialog was fixed
Data export was fixed (by-segment reading)
Data types load fix (PostgreSQL)
Copy/paste in resultset was fixed
SQL autocomplete was fixed
Scripts titles are now configurable
A few minor UI bug was fixed

http://dbeaver.jkiss.org/

[SiLæncer]

Whats new:>>

- bug       [security] Risk of BREACH attack, see PMASA-2015-1

http://www.phpmyadmin.net/

[SiLæncer]

Changelog

Custom SQL variables ( Self-defined SQL variables):

Add: Support for dynamic change numeric input processing (Specifying dynamic variables):

(Specifying a fixed variable): setvar "value"
(Specifying a dynamic variable): setvar
(Using a variable) $ (varname)
: Setvar FixedVar "% e%"
: Setvar DynmicVar
SELECT * FROM [Categories] WHERE [CategoryName] LIKE '$ (FixedVar)' AND [CategoryID] = $ (DynmicVar)
Upd: GO supports custom commands and / may include use (5542) in the same script language

Tying SQL statement variables ( Binding SQL variables ):

Upd:? When solving repository for tying characters, [with a] tying name can not be referenced multiple problems
Affected include DB2 / Informix / Teradata / FoxPro / Odbc / NuoDB database, etc.

Data Definition Language ( Data Definition Language (DDL) ):

Upd: (SQL Server / SQL Azure) script to generate VIEWS / TRIGGERS / PROCEDURES / FUNCTIONS other objects consistent name for [schema] [objectname] display mode
Fix: This update jointly address the object was renamed ( sp_rename and object name of the original definition of inconsistency) and after
Upd: (PostgreSQL / MySQL / SQL Server / SQL Azure / SybaseASE) update script to generate CREATE FUNCTION {...} default model

Data column editing ( Data Editor ):

Add: Data Grid Edit (Cell Editor): increase automatically formatted XML data type (XML Auto Formatting) (with the browse mode)
Add: data grid editing and browsing (Cell Editor and Viewer): increase the information content of the folding display processing XML (Code Folding)

Master Program Update ( Main ):

Upd: (NuoDB) built-in function reference (Built-in Functions): right-click menu can be executed directly processing
Upd: SQLite components updated to version 1.0.96.0 System.Data.SQLite.dll (3.8.8.3)
Upd: MySQL components updated to version 6.9.6 MySql.Data.dll
Upd: NuoDB component version update to NuoDb.Data.Client.dll 2.2.0
Upd: plug execute SQL formatting program (SqlFormatter.exe) can be placed in the \ Database_Files directory
Upd: Accumulated other contains a small update, correction and optimization

Misc: Compatible with NuoDB 2.2

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

+ Use Excel Style Filters option was introduced

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

[SiLæncer]

Changelog

Data Table Editor ( Table Designer ):

Upd: (PostgreSQL) change data types supported by the length of the bit / time / timetz / timestamp / timestamptz etc. and display (including script generation) (5546)
Fix: (PostgreSQL) amendment (5287) data type is displayed after the turn led to lower raw char / varchar / numeric and problems can not be changed, such as the length of the show (including script generation) (5546)

Master Program Update ( Main ):

Upd: Accumulated other contains a small update, correction and optimization (5546)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

- Master Program Update ( Main ):

 Add: Added favorites ( My Favorites ) object browsing and management: centralized management for quick browsing and common objects (5550)
 Add: add file UTF-8 / ANSI encoding detection process, including: SQL file search , import data files , script files processing functions such as support for ANSI file processing (5550)
 Upd: Strengthening automatic reconnection processing (Automatic reconnection): In addition to existing support for connection [close] automatically reconnect, but an additional connection [interrupts] automatic reconnection process (5550)
 Fix: corrected when switching between different databases or structural description, filter objects unsynchronized update in question [loaded] (5550)
 Add: Data Export ( Data Export ): support export data encoding preset settings (Options-> Export-> Results to files (Default Encoding: UTF-8 / ANSI)) (5550)
 Upd: snippet Management ( Code Snippets Manager ): automatic transfer of data retention mode (XML-> SQLite), in order to improve the overall processing speed (5550)
 Upd: data visualization ( Data Visualization ): in order to clearly distinguish the color of text and numerical data field type (5546)
 Fix: Data tables and view a list of tables ( Table View and List ): amended (5519) led to some problems can not be displayed RowCount database processing (5546)
 Upd: PostgreSQL components updated to version 2.2.5 Npgsql.dll (2015/02/10) (5550)
 Upd: Accumulated other contains a small update, correction and optimization (5550)
- Connection Process Management ( Connection Process Manager ):
 Add: Added support for DB2 / Informix / Teradata database, etc. (including the removal process function) (5550)
 Incl DB2 / Informix / Teradata / MySQL / PostgreSQL / Oracle / SQL Server / SQLAzure / SQLCe / Sybase / HP Vertica database, etc.
 Upd: rewrite process list display and processing methods (5550)
 Add: (SQL Azure) supported the deletion process handling (Kill Sessions) (5550)

- AutoComplete and perception ( AutoComplete and IntelliSense * ):

 Upd: perceptual processing cache data retention [recent] 5000 pen, the excess will be automatically deleted processing (5550)
 Upd: When the library itself or delete database objects, together with the deletion process will cache data (5550)

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

 Add: BLOB data type content display, increase UTF8 encoding detection (5550)
 Edit automatically converted to text editing mode (Text Editor), browse down automatically converted to text browsing mode (Text Viewer), replace HEX Viewer

- Data Table Editor ( Table Designer ):

 Upd: (PostgreSQL) change data types supported by the length of the bit / time / timetz / timestamp / timestamptz etc. and display (including script generation) (5546)
 Fix: (PostgreSQL) amendment (5287) data type is displayed after the turn led to lower raw char / varchar / numeric and problems can not be changed, such as the length of the show (including script generation) (5546)

[close]

http://fishcodelib.com/Database.htm