Autor Thema: Datenbanksoftware und Tools diverses ...  (Gelesen 105184 mal)

0 Mitglieder und 1 Gast betrachten dieses Thema.

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
Database .NET 18.7.6023.3
« Antwort #630 am: 29 Juni, 2016, 13:37 »
Database .NET is a powerful and intuitive multiple database management tool. The program allows the administration of local or remote databases to browse objects, design tables, edit rows, export data, create new databases, and run queries with a consistent interface. The program includes table/data editor, index editor, syntax highlighting, SQL profiler, code manager, and multiple query tabs.

Supported databases include SQL Server, SQL Azure, Firebird, SQLite, MySQL, PostgreSQL, Oracle, IBM DB2 and Informix, Sybase ASE, MS Access and Excel, dBase IV, FoxPro, Data Sources, ODBC DSN, and OData. Can export to CSV, XML, TXT, XLS, or SQL Print Query Results.

License:    Free for personal or non-profit use

Changelog

    AUTOMATICALLY AND PERCEPTION ( the AutoComplete and IntelliSense * ):

    Upd: (SQL Server / SybaseASE) increased significantly with improved cross-repository table aware processing (6023) (Cross-database  table.)
    Fix: Cross-repository table (. Cross-database ) and cross structure description (. Cross-schema ) aware processing: Could not load successfully corrected the problem when the first read
    Upd: Improved when SchemaName or TableName name is too long, table fields can not perceive a problem

    MAIN PROGRAM UPDATE ( the Main ):

    Upd: SQLite element updated to System.Data.SQLite.dll 1.0.102.0 (3.13.0) (2016/06/23
    Upd: Cumulative contain other minor updates, fixes and optimization


[close]

http://fishcodelib.com/Database.htm

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
DBeaver 3.7.0
« Antwort #631 am: 03 Juli, 2016, 11:45 »
Changelog

Context help system added
Filters dialog improvements (IN clause, dictionary browser)
Filters context menu was added (F11)
Multi-cell paste command was added (copy-paste from Excel, etc)
SQL editor + external files support improved.
SQL Editor auto-indent fixed
Row count limit usage fixed
Refresh connection URL on settings change (fix)
Saved passwords management fixed
Version update dialog/incremental update fixed (EE)
Drivers management dialog fixed
Results viewer: multiple bugfixes
MySQL: triggers create/drop fixed
MySQL: create procedure fixed
PostgreSQL: create/alter procedure fixed
Oracle: foreign key drop fixed
Oracle: BFILE type support added
Virtuoso: driver config added
CSV: driver configuration updated (maven)
Redis: beta version of Redis extension
Cassandra: InetAddress/UUID data types support, binary data type handle was fixed
Query manager persistence was fixed
A lof of minor UI fixes

[close]

http://dbeaver.jkiss.org/

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
Exportizer 6.0.3
« Antwort #632 am: 04 Juli, 2016, 13:25 »
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 SQL Script for SQL Server.
Bugs fixed in exporting to PDF.

http://www.vlsoftware.net/

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
Database .NET 18.8.6029.1
« Antwort #633 am: 04 Juli, 2016, 16:45 »
Changelog

THE MAIN PROGRAM UPDATE ( the Main ):

Add: (SQLite) was added JSON1 extension support
Add: (SQLite) was added FTS5 extension support
Upd: (SQLite) update REGEXP extension mode is enabled
Add: (SQLite) database support to restore memory database processing (TOOLS -> Restore from a file into an in-memory database)
Fix: Problems error message (SQLite) to display when defining WITHOUT PK AND ROWID data editor
Add: (Firebird) database coding increases automatic setting processing (Automatically set charset), when you turn the different coding repository no longer any need to manually set
Upd: MySQL element updated to MySql.Data.dll 6.9.9 (2016/07/01)
Upd: SQLite element updated to System.Data.SQLite.dll 1.0.102.0 (3.13.0) (2016/06/23)
Upd: Cumulative contain other minor updates, fixes and optimization

SQL HISTORY RECORDS ( the SQL History ):

Add: Added SQL insert query page to check processing (Insert SQL to new query)
Add: Add Tags [after Close] to save the process, even if did not perform will be recorded at any time convenient recovery processing (Note: The original record only [perform] After saving processing)
Upd: Other improvements: 1. Supports Right selected, 2. maintain the original SQL format of the content

AUTOMATICALLY AND PERCEPTION ( the AutoComplete and IntelliSense * ):

Upd: (SQL Server / SybaseASE) increased significantly with improved cross-repository table aware processing (Cross-database  table.)
Fix: Cross-repository table (. Cross-database ) and cross structure description (. Cross-schema ) aware processing: Could not load successfully corrected the problem when the first read
Upd: Improved when SchemaName or TableName name is too long, table fields can not perceive a problem

DATABASE MIGRATION ( Database Migration ) (Pro):

Upd: Updated with all dbMigration .NET Software

[close]

http://fishcodelib.com/Database.htm

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
Database Browser 5.3.1.7
« Antwort #634 am: 05 Juli, 2016, 04:45 »
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: >>

+ Third party components update
+ Improved compatibility with third party xlsx files
+ Improved compatibility with invalid xls and xlsx files

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

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
RecordEditor 0.98 Test
« Antwort #635 am: 07 Juli, 2016, 22:45 »
RecordEditor is a datafile editor, similar to File-Aid or Net-Cobols Cobol-Editor. It uses a record layout to format the data in the file in to a human readable format. Because it knows the format of fields, it can format binary fields as normal numbers rather than displaying hex equivalent as most hex editors do. The file can be editted in a table (spreadsheet-like format) or in a single record format with fields going down the page.

Freeware

Release Notes


    Several Cobol Fixes (Right Justified , GNU Cobol Zoned Decimal).

    Adding JRecord Code Generate function - this will generate either:
        Java~JRecord code from a Cobol Copybook / File.
        Utility scripts (CobolToCsv or CobolToXml or CobolToJson) scripts from a Cobol Copybook/file.

    Generate simple skelton Java~JRecord, Python or Ruby programs to read/write the file being editted. There a still a lot of limititations.


[close]

Download hier : https://sourceforge.net/projects/record-editor/files/Test/

http://record-editor.sourceforge.net/

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
Database .NET v18.8.6036
« Antwort #636 am: 11 Juli, 2016, 18:15 »
Changelog

- The main program update ( the Main ):
Add: Join Microsoft.ACE.OLEDB 12/15/16 automatic switching and connectivity, so as to enhance the Access / Excel / Text and other databases in different environments connection capacity (6036)
Add: Support Microsoft Office Access 2016 and Microsoft Access Runtime 2016 element connection process (6036)
Fix: solve the root of the TreeView when more than 1 ?? nodes, may cause display freezing problems (6036)
Upd: (SQL Server) to update the database include ways to significantly improve loading speed resolve when login account [without authority] to access the database causes a load problem for too long (6036)
Upd: (64bit) Remove dBase IV / 5.0 (* .dbf) supported repositories (6036)
Upd: Cumulative contain other minor updates, fixes and optimization (6036)
- Display informational message ( the Displaying informational to be messages ):
Add: (PostgreSQL) Join Reporting Errors and Messages support (6036)
Add: (PostgreSQL) was added LISTEN - listen for a notification support (6036)
- SQL performance analyzer ( the SQL the Profiler ):
Add: Support SQLite database sessions analytical processing (Session Mode) (formerly Log Mode) (6036)
- Database Migration ( Database Migration ) (Pro):
Upd: Updated with all dbMigration .NET Software (6036)

[close]

http://fishcodelib.com/Database.htm

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
DBeaver 3.7.1
« Antwort #637 am: 13 Juli, 2016, 13:22 »
Changelog

DBeaver logo and icons were redesigned
Results order/refresh has been fixed
PostgreSQL: alter column SQL fixed
Oracle: PL/SQL block processing was improved (DECLARE/BEGIN/END)
Oracle: output reading was fixed
JDBC: case-sensitive indexes reading was fixed
Results filter menu was extended
Project explorer view: scripts can be copy/pasted from OS file system
SQL keywords were updated
Korean localization was added

[close]

http://dbeaver.jkiss.org/

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
Database .NET 18.9.6040
« Antwort #638 am: 15 Juli, 2016, 16:00 »
Changelog

- The main program update ( the Main ):
Add: (Firebird) support single-dimensional array, multi-dimensional arrays data type is displayed with the relevant processing (6040)
Add: (PostgreSQL) support multi-dimensional arrays data type is displayed with the relevant processing (6040)
Add: (PostgreSQL) support bigserial data type is displayed with the relevant processing (6040)
Upd: (HP Vertica) table updates automatically increment fields grammar original AUTO_INCREMENT change IDENTITY (seed, increment) full definition (including table editing and script generation processing) (6040).
Add: Join Microsoft.ACE.OLEDB 12/15/16 automatic switching and connectivity, so as to enhance the Access / Excel / Text and other databases in different environments connection capacity (6036)
Add: Support Microsoft Office Access 2016 and Microsoft Access Runtime 2016 element connection process (6036)
Fix: resolve when TreeView [root] directory of more than 1 ?? nodes, may cause display freezing problems (6036)
Upd: (SQL Server) to update the database include ways to significantly improve loading speed resolve when login account [without authority] to access the database causes a load problem for too long (6036)
Upd: (64bit) Remove dBase IV / 5.0 (* .dbf) supported repositories (6036)
Upd: Cumulative contain other minor updates, fixes and optimization (6040)
Misc: the with Compatible the SQL Server SP2, 2014 / the SQL Server Express SP2 and LocalDB, 2014 (2016/07/12)
- Table editor ( the Table Designer ):
Add: (PostgreSQL / Informix) increase the auto-increment field set to automatically switch to Serial data type (6040)
Upd: Allow auto-increment columns plus [no] primary key (AUTO_INCREMENT + NON-PK) establishment process (6040)
- Display informational message ( the Displaying informational to be messages ):
Add: (PostgreSQL) Join Reporting Errors and Messages support (6036)
Add: (PostgreSQL) was added LISTEN - listen for a notification support (6036)
- SQL performance analyzer ( the SQL the Profiler ):
Add: Support SQLite database sessions analytical processing (Session Mode) (formerly Log Mode) (6036)
- Database Migration ( Database Migration ) (Pro):
Upd: Updated with all dbMigration .NET Software (6040)

[close]

http://fishcodelib.com/Database.htm

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
Database .NET 19.0.6059.1
« Antwort #639 am: 03 August, 2016, 09:11 »
Changelog

MAIN PROGRAM UPDATE:
Add: (Pro) new authorization object management capabilities ( Grant Manager )
Supports all types of objects, add support search processing, support individual designated processing, greatly simplify the problem of object permissions
Support contains SQL Server / SQL Azure / Firebird / MySQL / PostgreSQL / Oracle and other database
Fix: Fixed screen resolution> = 4K and> = 250% environment, when you start cause display problems (6059) exception occurs
Upd: (Oracle / Firebird 3) Resolution (6015) led to suite object (Packages) loading too slow display problem (
Fix: (Firebird) Fixed remote connections can not use a non-default account connection problems
Upd: Cumulative contain other minor updates, fixes and optimization
Upd: Update Files Additional .NET Database ( 32bit / 64bit ) (2016/07/30)
Misc: the with Compatible the MySQL 5.7.14 (2016/07/29) / the MySQL 5.6.32 (2016/07/29) / the MySQL 5.5.51 (2016/07/29)
AUTOMATICALLY AND PERCEPTION ( the AutoComplete and IntelliSense * ):
Upd: inserting an object no longer contains Quoted Identifiers, changed to automatically determine whether the exception processing characters (6059)
Fix: resolve quickly enter and click F5 to execute, the display of unnecessary problems
SQL EDITOR:
Fix: Fixed multi-line comments /*...*/, if one batch command GO, / issue that causes part of the database can not be processed normally
TABLE EDITOR:
Upd: (MySQL) New encoding table change to take character-set-server instead of the default character-set-database library encoding
ROW EDITING AND BROWSING:
Add: Support the field data type is System.Object (Date / String / Numeric) content is displayed as text and date digital processing
DATABASE OBJECT SEARCH:
Fix: Fixed If via shortcuts Enter or Ctrl + E when the input, resulting in repeated thereby affecting search speed
DATABASE MIGRATION:
Upd: Updated with all dbMigration .NET Software

[close]

http://fishcodelib.com/Database.htm

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
Database .NET 19.0.6063
« Antwort #640 am: 07 August, 2016, 18:15 »
Changelog

- Authorization object management capabilities ( Grant Manager ) (Pro):
Add: Authorization Manager supports IBM DB2 objects: TABLE / VIEW / PROCEDURE / FUNCTION (6063)
Add: increase the effectiveness of detecting movement when permissions are configured to provide a more intuitive message display (6063)
Upd: (Firebird) increased USER: PUBLIC default user permissions handling (6063)
Fix: (PostgreSQL) correction can not (FUNCTIONS / PROCEDURES) of [Search Add] and [individual designated] Issue (6063) permission settings
- The main program update ( the Main ):
Upd: Cumulative contain other minor updates, fixes and optimization (6063)

[close]

http://fishcodelib.com/Database.htm

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
SQLite 3.14.0
« Antwort #641 am: 09 August, 2016, 05:51 »
Changelog

Added support for WITHOUT ROWID virtual tables.
Improved the query planner so that the OR optimization can be used on virtual tables even if one or more of the disjuncts use the LIKE, GLOB, REGEXP, MATCH operators.
Added the CSV virtual table for reading RFC 4180 formatted comma-separated value files.
Added the carray() table-valued function extension.
Enabled persistent loadable extensions using the new SQLITE_OK_LOAD_PERMANENTLY return code from the extension entry point.
Added the SQLITE_DBSTATUS_CACHE_USED_SHARED option to sqlite3_db_status().
Add the vfsstat.c loadable extension - a VFS shim that measures I/O together with an eponymous virtual table that provides access to the measurements.
Improved algorithm for running queries with both an ORDER BY and a LIMIT where only the inner-most loop naturally generates rows in the correct order.
Enhancements to Lemon parser generator, so that it generates a faster parser.
The PRAGMA compile_options command now attempts to show the version number of the compiler that generated the library.
Enhance PRAGMA table_info so that it provides information about eponymous virtual tables.
Added the "win32-none" VFS, analogous to the "unix-none" VFS, that works like the default "win32" VFS except that it ignores all file locks.
The query planner uses a full scan of a partial index instead of a full scan of the main table, in cases where that makes sense.
Allow table-valued functions to appear on the right-hand side of an IN operator.
Created the dbhash.exe command-line utility.
Added two new C-language interfaces: sqlite3_expanded_sql() and sqlite3_trace_v2(). These new interfaces subsume the functions of sqlite3_trace() and sqlite3_profile() which are now deprecated.
Added the json_quote() SQL function to the json1 extension.
Disable the authorizer callback while reparsing the schema.
Added the SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION compile-time option and turned that option on by default when building the command-line shell.

Bug Fixes:

Fix the ALTER TABLE command so that it does not corrupt descending indexes when adding a column to a legacy file format database. Ticket f68bf68513a1c15f
Fix a NULL-pointer dereference/crash that could occurs when a transitive WHERE clause references a non-existent collating sequence. Ticket e8d439c77685eca6.
Improved the cost estimation for an index scan which includes a WHERE clause that can be partially or fully evaluated using columns in the index and without having to do a table lookup. This fixes a performance regression that occurred for some obscure queries following the ORDER BY LIMIT optimization introduced in version 3.12.0.

[close]

https://www.sqlite.org/

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
SQLite 3.14.1
« Antwort #642 am: 12 August, 2016, 10:16 »
Whats new:>>

A performance enhancement to the page-cache "truncate" operation reduces COMMIT time by dozens of milliseconds on systems with a large page cache.
Fix to the --rbu option of sqldiff.

https://www.sqlite.org/

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
Database .NET 19.1.6068
« Antwort #643 am: 12 August, 2016, 17:15 »
Changelog

- Authorization object management capabilities ( Grant Manager ) (Pro):
Add: Support SQL Server 2000 Authorization Manager objects: TABLE / VIEW / PROCEDURE / FUNCTION (6068)
Add: Support SybaseASE object Authorization Manager: TABLE / VIEW / PROCEDURE / FUNCTION (6068)
Add: Support Teradata objects Authorization Manager: TABLE / VIEW / PROCEDURE / FUNCTION / MACRO (6068)
Add: Support NuoDB object Authorization Manager: TABLE / VIEW / PROCEDURE / FUNCTION (6068)
Add: Support HP Vertica object Authorization Manager: TABLE / VIEW / SEQUENCE (6068 )
Add: Authorization Manager supports IBM Informix objects: TABLE / VIEW / PROCEDURE / FUNCTION / SEQUENCE (6068)
Add: Authorization Manager supports IBM DB2 objects: TABLE / VIEW / PROCEDURE / FUNCTION (6063/6068)
Fix: Problems unspecified sources Db (6068) when (MySQL) amended to read object permissions
Upd: (Firebird / Oracle) increased USER: PUBLIC default user permissions treatment (6063/6068)
Fix: (PostgreSQL) correction can not (FUNCTIONS / PROCEDURES) of [Search Add] and [individual designated] Issue (6063) permission settings
Add: increase the effectiveness of detecting movement when permissions are configured to provide a more intuitive message display (6063)
It contains full support for SQL Server / SQL Azure / Firebird / MySQL / PostgreSQL / Oracle / IBM DB2 / Informix / SybaseASE / NuoDB / HP Vertica / Teradata database, etc.
- Security Administrator (Database Tools: Security Manager ):
Fix: (NuoDB) to solve new user (User) when the batch command (GO) problem can not be executed (6068)
- Data Definition Language ( the Data Definition! Language (the DDL) ):
Problem (HP Vertica) Fixed script generation FUNCTION missing ")" in (6068): Fix
- The main program update ( the Main ):
Upd: (IBM DB2 / Informix) dramatically PROCEDURES / FUNCTIONS object browser loading processing speed (6068)
Add: (NuoDB) function increases object processing (FUNCTIONS): contains browse / execute / delete / script generation ... and other functions (6068)
Fix: completely solve the problem on the left to display the object heavy brush exception, when the content is not currently in heavy brush tab exception (6068)
Upd: Cumulative contain other minor updates, fixes and optimization (6068)
Misc: Compatible with Microsoft Windows 10 redstone (6063 )
Misc: the with the PostgreSQL Compatible 9.5.4 / 9.4.9 / 9.3.14 / 9.2.18 / 9.1.23 (2016/08/11)

[close]

http://fishcodelib.com/Database.htm

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
phpMyAdmin 4.6.4
« Antwort #644 am: 17 August, 2016, 16:45 »
Changelog

Aside from the security fixes, bugs have been fixed affecting:

Create view when no view name specified
Changing a password
Fix deleting of users with non-English locales
Fixed password change on MariaDB without auth plugin

[close]

http://www.phpmyadmin.net/

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )