Thema: Datenbanksoftware und Tools diverses ...

[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 bug fixes in export routines.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

- issue #11744 Incomplete results of UNION ALL
- issue #11742 MATCH AGAINST keywords not recognized
- issue #11723 syntax verifier is not knowing "STRAIGHT_JOIN"
- issue #11699 REPLACE() function confused with REPLACE statement
- issue #11690 FLUSH word not recognized by parser
- issue #11664 Online syntax verifier bug - "IF" on SELECT statement
- issue #11665 Format breaks query with COUNT()
- issue        Undefinex index: SendErrorReports
- issue        Incorrect script name in include
- issue #11685 Warning: Invalid argument supplied for foreach()
- issue #11687 Delimiter missing while exporting multiple db routines
- issue #11684 mysql_native_password with MariaDB bug
- issue #11693 Flush privileges overusage - related to #11597
- issue #11691 Query was empty on creating User in 4.5.2
- issue #11695 PMA_getDataForDeleteUsers() warning
- issue #11698 Cannot create user on Percona Server
- issue        Properly report error on connecting
- issue #11706 Database export template not saving compression option
- issue #11721 Fix single quote export for servers in ANSI_QUOTES mode
- issue #11714 Avoid duplicite fetching of table information
- issue #11724 Temporary fix for live data edit of big sets is not working
- issue        IE 8 compatibility in console
- issue #11732 Exporting feature does not work with union table
- issue #11728 CSV import skip row count after
- issue #11679 Cannot export results of some queries
- issue #11720 Message "An account already exists..." incorrectly displayed
- issue #11758 Missing quoting of table in ALTER CONVERT query
- issue #11752 PMA 4.5.2 breaks MySQL Master-Master Cluster
- issue #11757 Export and preview show different SQL for character set
- issue #11749 Fix possible undefined variables in table operations

[close]

Download : Klick

http://www.phpmyadmin.net/

[SiLæncer]

Changelog

4.5.3.1 (2015-12-25)
- issue #11774 Undefined offset 2
- issue [Security] Path disclosure, see PMASA-2015-6

[close]

Download : Klick

http://www.phpmyadmin.net/

[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

Enhancements:

Add proper file extension filters to all file dialogs - 6b8f57d (thanks to @MKleusberg)
Improved error handling, e.g. more error messages with more detailed error descriptions - #362, #363, 1696ad1 (thanks to @schdub and @MKleusberg)
Allow changing table columns even when there is a foreign key constraint on the table - #362 (thanks to @MKleusberg)
When holding Ctrl and Shift while clicking on a cell with a foreign key set, the browser now jumps to the referenced record - #192 (thanks to @MKleusberg)
Add option for disabling the SQL error indicators in the Execute SQL area - #302 (thanks to @MKleusberg)
Add an option for setting the colours of fields with regular and binary data - #377 (thanks to @schdub)
Use the name of the imported file as default suggestion for a table name during CSV import - #376 (thanks to @MKleusberg)
Save filter values, sort order and column widths for all tables when switching the current table or tab; also save the settings in the project file - 748f06d (thanks to @MKleusberg)
Show a small clear button inside each filter box - 944e22a (thanks to @MKleusberg)
Add basic support for different 'display formats', i.e. a conversion of the contents of a column into a different format for display purposes (e.g. converting a Unix epoch into an actual date) - 7c1d237, 22e858d (thanks to @MKleusberg)
Remove deleted files from list of recently opened files - #379 (thanks to @MKleusberg)
Add a new option for horizontal tiling of the code and result view in the Execute SQL area - #380 (thanks to @MKleusberg)
Move execution time of the SQL statement to the top of the result view in the Execute SQL area - #381 (thanks to @MKleusberg)
Add 'x rows affected' information to the result view of the Execute SQL area - 82292c2 (thanks to @MKleusberg)
Add built-in UTF16 and UTF16CI collation - #391 (thanks to @sebastian-philipp)
Add Ctrl+R shortcut (besides F5) for the refresh table button - #388 (thanks to @MKleusberg)
Add option for setting the font and font size of the text in the table browser view - #383 (thanks to @MKleusberg)
Support opening of read only database files - #402 (thanks to @MKleusberg)
Add option for showing the rowid column in the data browser view - #408 (thanks to @MKleusberg)
Add option for showing the text in the data browser view using a different encoding - #414 (thanks to @MKleusberg)
Add option for setting an escape character for the filters in the data browser - #421 (thanks to @MKleusberg)
Add a small delay before applying a new filter value instead of performing an instantaneous search to improve performance on large tables - #415 (thanks to @MKleusberg)
Automatically add '%...%' wildcards to a filter query - #415 (thanks to @MKleusberg)
Add Delete and Alt+Delete keyboard shortcuts for setting the current cell to empty string or NULL in the data browser view - #443 (thanks to @MKleusberg)
Add new option for moving the Edit cell data dialog into a dock which is locked to the main window and stays opened - #416, #440, #441 (thanks to @MKleusberg)
Allow drag-&-dropping text and files on a cell in the data browser - #441 (thanks to @MKleusberg)
Add keyboard shortcuts for recently opened files - #432 (thanks to @MKleusberg)
Add new option for setting a SQL script which gets executed whenever any database file is opened - #451 (thanks to @MKleusberg)
Allow pasting data (e.g. from a spreadsheet) directly into the data browser view - #453 (thanks to @MilosSubotic)

Bug fixes:

Fix missing SQL log when query contains a line break, also trim the log - #337, #356 (thanks to @schdub and @MKleusberg)
Also set foreign key settings when creating a new database instead of just setting them when opening a file - 212116a (thanks to @MKleusberg)
Fix drawing of Unicode characters in the SQL editor where the font settings wouldn't apply as they should have - #365 (thanks to @SevenLines)
Allow values greater than 10000 in the user_version pragma of a database - #366 (thanks to @schdub)
Fix adding new a record into a table where all fields are set to a default value - #369 (thanks to @schdub)
Fix resizing of the code and result view in the Execute SQL area - 6806a9b (thanks to @MKleusberg)
Fix error message when changing table - #390 (thanks to @MKleusberg and @GeorgijK)
Fix parsing of double backticks and double quotes used to escape a single one in create table statements - 160bc87, dce47b3 (thanks to @MKleusberg)
Fix handling of tables when their name contains a backtick - #387 (thanks to @MKleusberg)
Try to set a better window position when opening the Edit cell data dialog - #342, #394 (thanks to @MKleusberg)
Fix possible infinite loop in the Edit cell data dialog - #444 (thanks to @manisandro)
Fix bug when pressing the cancel button in the dialog you see when you're closing a database with unsaved changes - #432 (thanks to @MKleusberg)
Don't allow conflicting field names in the Edit Table dialog - #460 (thanks to @MKleusberg)

Translations:

Add translation into Traditional Chinese - #425 (thanks to @PeterDaveHello)

[close]

http://sqlitebrowser.org/

[SiLæncer]

Changelog

SQL completion was fixed
Results filtering (by custom value) was fixed
DDL generation was added (from context menu)
Duplicated procedures were removed
Enum types support was fixed
Dictionary tables editor was added
Temporary files cleanup was fixed

[close]

http://dbeaver.jkiss.org/

[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

Whats new:>>

Added MRU List to data entry grid
Removed Ctrl+X shortcut

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

[SiLæncer]

Changelog

SQL editor ( SQL Editor ):

Upd: syntax highlighting: Supports single quotation marks content in multiple lines '\ r \ n' display processing (5844)
Upd: Syntax highlighting: improved marks identifying the content item [], ``, '' exclude highlighted when the keyword display process (5844)
Upd: Updated syntax highlighting color content display processing (5844)

Code Management ( Code Manager ):

Add: SQL File Version Control Manager ( Version Control Manager ): Work row to increase heavy brush list (Refresh) / check-out file (Checkout) / delete items (Delete) button, etc. (5844)
Upd: Fixed (57xx) cause SQL file version control ( SQL File Version Control ) function problems stalled (5844)

Information column editing ( Data Editor ):

Upd: When (SQLite) without a primary key (PK) update and delete process, change in the conditions of the search process ROWID (with Oracle) (5844)
Data definition language ( Data Definition Language (DDL) ):
Add: (SQL Server / SQLAzure) support COLUMNSTORE / XML / SPATIAL INDEX scripting generation and related treatment (5844)

Main Program Update ( Main ):

Fixed multiple issues related to Screen (Multiple Monitors) under when the monitor is set to [Up / Down] when the (5844): Fix
Upd: Improved error message exception handling, exception error when the set is empty (5844)
Upd: Improved Data Sheet object loading process, when the failure will display an error and continue to complete other objects loading (5844)
Upd: (Oracle) is automatically re-connect process (Automatic reconnection): increased event Ora-12537 connection [interrupts] automatic reconnection process (5844)
Upd: (Firebird) database when the connection is not the same with the preset encoding automatically switches to NONE to solve Can not transliterate character between character sets of questions (5844)
Upd: Accumulated other contains minor updates, correction and optimization (5844)
Upd: Firebird components updated to FirebirdSql.Data.FirebirdClient.dll 4.9.0.0 (2015/12/20) (5844)
Misc: Compatible with NuoDB 2.4 (2015/12/22)
Misc: Compatible with PostgreSQL 9.5rc1 or ENGINEERING (2015/12/18)
Misc: Compatible with SQL Server 2016 CTP 3.2 (2015/12/17)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

General improvements:

Added support for LIKE, GLOB, and REGEXP operators on virtual tables.
Added the colUsed field to sqlite3_index_info for use by the sqlite3_module.xBestIndex method.
Enhance the PRAGMA cache_spill statement to accept a 32-bit integer parameter which is the threshold below which cache spilling is prohibited.
On unix, if a symlink to a database file is opened, then the corresponding journal files are based on the actual filename, not the symlink name.
Added the "--transaction" option to sqldiff.
Added the sqlite3_db_cacheflush() interface.
Added the sqlite3_strlike() interface.
When using memory-mapped I/O map the database file read-only so that stray pointers and/or array overruns in the application cannot accidently modify the database file.
Added the experimental sqlite3_snapshot_get(), sqlite3_snapshot_open(), and sqlite3_snapshot_free() interfaces. These are subject to change or removal in a subsequent release.
Enhance the 'utc' modifier in the date and time functions so that it is a no-op if the date/time is known to already be in UTC. (This is not a compatibility break since the behavior has long been documented as "undefined" in that case.)
Added the json_group_array() and json_group_object() SQL functions in the json extension.
Added the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option.
Many small performance optimizations.

Portability enhancements:

Work around a sign-exension bug in the optimizer of the HP C compiler on HP/UX. (details)

Enhancements to the command-line shell:

Added the ".changes ON|OFF" and ".vfsinfo" dot-commands.
Translate between MBCS and UTF8 when running in cmd.exe on Windows.

Enhancements to makefiles:

Added the --enable-editline and --enable-static-shell options to the various autoconf-generated configure scripts.
Omit all use of "awk" in the makefiles, to make building easier for MSVC users.

Important fixes:

Fix inconsistent integer to floating-point comparison operations that could result in a corrupt index if the index is created on a table column that contains both large integers and floating point values of similar magnitude. Ticket 38a97a87a6.
Fix an infinite-loop in the query planner that could occur on malformed common table expressions.
Various bug fixes in the sqldiff tool.

Hashes:

SQLITE_SOURCE_ID: "2016-01-06 11:01:07 fd0a50f0797d154fefff724624f00548b5320566"
SHA1 for sqlite3.c: b92ca988ebb6df02ac0c8f866dbf3256740408ac

[close]

http://www.hwaci.com/sw/index.html

[SiLæncer]

Changelog

Data Table Editor ( Table Designer ):

Fix: (SQLite / SQLCe) amendments to the existing data table, renamed field problems stalled (5851)

Main Program Update ( Main ):

Upd: IBM DB2 / Informix element updated to IBM.Data.DB2.dll 9.7.4.4 (10.5.7.4) (2015/12/30) (5851)
Misc: (IBM DB2 / Informix) IBM Data Server Client Packages Version 10.5 Fix Pack 7 (2015/12/30)
Misc: Compatible with PostgreSQL 9.5 (2016/01/07)
Upd: Accumulated other contains minor updates, correction and optimization (5851)
Upd: Update Database .NET Additional Files ( 32bit / 64bit ) (2016/01/08)
PostgreSQL 9.5 supports backup and restore process

Database migration ( Database Migration ) (Pro):

Add: Inheritance Database .NET connection string settings Additional settings (Additional connection parameters) (5851)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

# Major enhancements :

- Allow INSERTs that would generate constraint conflicts to be turned into UPDATEs or ignored
- Add GROUP BY analysis features GROUPING SETS, CUBE and ROLLUP.
- Add row-level security control.
- Create mechanisms for tracking the progress of replication, including methods for identifying the origin of individual changes during logical replication.
- Add Block Range Indexes (BRIN).
- Substantial performance improvements for sorting.
- Substantial performance improvements for multi-CPU machines.

[close]

http://www.postgresql.org/

[SiLæncer]

Whats new: >>

Minor improvements in GUI.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

Object Browser ( Object Navigator ):

Upd: Open Data Sheets [Viewing and Editing] Key Function column data interchange TOP Rows All Rows, easily and quickly browse and consistent with the shortcut keys (5861)

Data Import ( Data Import ):

Upd: supports automatic import character delimited format determination process (Auto-detect delimiter) (5861)
Fix: can not manually change the separator character when correcting problems via File Import (5861)

SQL editor ( SQL Editor ):

Upd: Optimization tab displays speed, improved rendering unnecessary treatment (5861)
Fix: Fixed in the absence of any tab, click mouse problems exceptions

new label (5861)

Data Table Editor ( Table Designer ):

Fix: (SQLite / SQLCe) amendments to the existing data table, renamed field problems stalled (5851)

Main Program Update ( Main ):

Upd: Improved the default control performance issues, optimizing database object processing speed loading (5861)
Upd: Object Object header row increases the loading process standby state (5861)
Upd: IBM DB2 / Informix element updated to IBM.Data.DB2.dll 9.7.4.4 (10.5.7.4) (2015/12/30) (5851)
Misc: (IBM DB2 / Informix) IBM Data Server Client Packages Version 10.5 Fix Pack 7 (2015/12/30)
Misc: Compatible with PostgreSQL 9.5 (2016/01/07)
Upd: Accumulated other contains minor updates, correction and optimization (5861)
Upd: Update Database .NET Additional Files ( 32bit / 64bit ) (2016/01/08)
PostgreSQL 9.5 supports backup and restore process

Database migration ( Database Migration ) (Pro):

Add: Help button (Help Button): integrated wiring list (Connection List) display (5861)
Add: Connection list items increased to generate the command-line options scrapbook son (Generate the command-line to Clipboard) (5861)
Add: Inheritance Database .NET connection string settings Additional settings (Additional connection parameters) (5851)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

#11724 live data edit of big sets is not working
Table list not saved in db QBE bookmarked search
#11777 While 'changing a column', query fails with a syntax error after the 'CHARSET=' keyword
#11783 Avoid syntax error in javascript messages on invalid PHP setting for max_input_vars
#11784 Properly handle errors in upacking zip archive
#11785 Set PHP's internal encoding to UTF-8
#11786 Fixed Kanji encoding in some specific cases
#11787 Check whether iconv works before using it
#11788 Avoid conversion of MySQL error messages
#11792 Undefined index: parameters
#11802 Undefined index: field_name_orig
Undefined index: host
#11810 'Add to central columns' (per column button) does nothing
#11727 SQL duplicate entry error trying to INSERT in designer_settings table
#11798 Fix handling of databases with dot in a name
#11820 Fix hiding of page content behind menu
#11780 FROM clause not generated after loading search bookmark
#11826 Fix creating/editing VIEW with DEFINER containing special chars
#11828 Do not invoke FLUSH PRIVILEGES when server in --skip-grant-tables
#11804 Misleading message for configuration storage
#11772 Table pagination does nothing when session expired
#11840 Index comments not working properly
#11791 Better handle local storage errors
#11752 Improve detection of privileges for privilege adjusting
#11854 Undefined property: stdClass::$releases at version check when disabled in config
#11814 SQL comment and variable stripped from bookmark on save
Gracefully handle errors in regex based javascript search
[Security] Multiple full path disclosure vulnerabilities, see PMASA-2016-1
[Security] Unsafe generation of CSRF token, see PMASA-2016-2
[Security] Multiple XSS vulnerabilities, see PMASA-2016-3
[Security] Insecure password generation in JavaScript, see PMASA-2016-4
[Security] Unsafe comparison of CSRF token, see PMASA-2016-5
[Security] Multiple full path disclosure vulnerabilities, see PMASA-2016-6
[Security] XSS vulnerability in normalization page, see PMASA-2016-7
[Security] Full path disclosure vulnerability in SQL parser, see PMASA-2016-8
[Security] XSS vulnerability in SQL editor, see PMASA-2016-9

[close]

Download : Klick

http://www.phpmyadmin.net/

[SiLæncer]

Whats new:>>

Fixed:

- issue #11892 Error with PMA 4.4.15.3
- issue #11896 Remove hard dependency on phpseclib

Download : Klick

http://www.phpmyadmin.net/

[SiLæncer]

Changelog

Main Program Update ( Main ):
Add: (64bit) increase dBase IV / 5.0 (* .dbf) supported by the repository (with 32bit) (5875)
Add: (64bit) increased Excel Workbook (* .xls) database new features (with 32bit) (5875)
Problems (5875) (32bit) amended by the repository list dBase Folder New Folder function stalled: Fix
Upd: Updated interface Slovenian language Slovenian language (by Jadran Rudec) (5875)
Upd: Firebird components updated to FirebirdSql.Data.FirebirdClient.dll 4.10.0.0 (2016/01/18) (5875)
Upd: Accumulated other contains minor updates, correction and optimization (5875)
The visual implementation plan ( Visual Execution Plan ):
Upd: dramatically improve the overall processing speed optimization (5875)
Data definition language ( Data Definition Language (DDL) ):
Fix: (DB2) correction (52 ??) causes PROCEDURES AND FUNCTIONS [part] script generation processing issues stalled (5875)
Object Browser ( Object Navigator ):
Former browse and edit the original pen before n, will support if the presence of PK [latest] n T data column (TOP Rows + PK DESC) (5875): Upd
Upd: Improved Advanced viewing and editing options ([ADV] Advanced Browsing / Edit Options): ORDER BY + TOP and distinct case and other related processing (5875)
Upd: Fixed (5861) related issues is consistent with the shortcut keys are not synchronized updates and other issues (5875)
Database migration ( Database Migration ) (Pro):
Add: Added establish data table structure is described only process (Create Table Schema Only) (5875)
Add: Support dBase IV / 5.0 Library (5875)

[close]

http://fishcodelib.com/Database.htm