Modify

Opened 15 years ago

Closed 15 years ago

Last modified 15 years ago

#962 closed Feature Request (Completed)

SQLite - update it to latest version

Reported by: Zedna Owned by: Gary
Milestone: Future Release Component: Standard UDFs
Version: Severity: None
Keywords: Cc:

Description

SQLite is in 3.6.7 version in AutoIt 3.3.0

According to http://www.sqlite.org/changes.html
There are is version with speed/functionality enhancements.
At this time there is latest version 3.6.14 from 2009-05-07

2009 May 7 (3.6.14)

    * Added the optional asynchronous VFS module.
    * Enhanced the query optimizer so that virtual tables are able to make use of OR and IN operators in the WHERE clause.
    * Speed improvements in the btree and pager layers.
    * Added the SQLITE_HAVE_ISNAN compile-time option which will cause the isnan() function from the standard math library to be used instead of SQLite's own home-brew NaN checker.
    * Countless minor bug fixes, documentation improvements, new and improved test cases, and code simplifications and cleanups. 

2009 April 13 (3.6.13)

    * Fix a bug in version 3.6.12 that causes a segfault when running a count(*) on the sqlite_master table of an empty database. Ticket #3774.
    * Fix a bug in version 3.6.12 that causes a segfault that when inserting into a table using a DEFAULT value where there is a function as part of the DEFAULT value expression. Ticket #3791.
    * Fix data structure alignment issues on Sparc. Ticket #3777.
    * Other minor bug fixes. 

2009 March 31 (3.6.12)

    * Fixed a bug that caused database corruption when an incremental_vacuum is rolled back in an in-memory database. Ticket #3761.
    * Added the sqlite3_unlock_notify() interface.
    * Added the reverse_unordered_selects pragma.
    * The default page size on windows is automatically adjusted to match the capabilities of the underlying filesystem.
    * Add the new ".genfkey" command in the CLI for generating triggers to implement foreign key constraints.
    * Performance improvements for "count(*)" queries.
    * Reduce the amount of heap memory used, especially by TRIGGERs.
*

2009 Feb 18 (3.6.11)

    * Added the hot-backup interface.
    * Added new commands ".backup" and ".restore" to the CLI.
    * Added new methods backup and restore to the TCL interface.
    * Improvements to the syntax bubble diagrams
    * Various minor bug fixes 

2009 Jan 15 (3.6.10)

    * Fix a cache coherency problem that could lead to database corruption. Ticket #3584. 

2009 Jan 14 (3.6.9)

    * Fix two bugs, which when combined might result in incorrect query results. Both bugs were harmless by themselves; only when they team up do they cause problems. Ticket #3581. 

2009 Jan 12 (3.6.8)

    * Added support for nested transactions
    * Enhanced the query optimizer so that it is able to use multiple indices to efficiently process OR-connected constraints in a WHERE clause.
    * Added support for parentheses in FTS3 query patterns using the SQLITE_ENABLE_FTS3_PARENTHESIS compile-time option.

Attachments (0)

Change History (7)

comment:1 Changed 15 years ago by Zedna

2009-May-07 - Version 3.6.14

SQLite version 3.6.14 provides new performance enhancements in the btree and pager layers and in the query optimizer. Certain workloads can be as much as twice as fast as the previous release, though 10% faster is a more typical result.

comment:2 Changed 15 years ago by Zedna

2009-May-07 - Version 3.6.14

SQLite version 3.6.14 provides new performance enhancements in the btree and pager layers and in the query optimizer. Certain workloads can be as much as twice as fast as the previous release, though 10% faster is a more typical result.

comment:3 Changed 15 years ago by TicketCleanup

  • Version 3.3.0.0 deleted

Automatic ticket cleanup.

comment:4 Changed 15 years ago by Jpm

  • Resolution set to Completed
  • Status changed from new to closed

Be patient it is done already just waiting beta/release delivery ...

comment:5 Changed 15 years ago by TicketCleanup

  • Milestone set to Future Release

Automatic ticket cleanup.

comment:6 Changed 15 years ago by Zedna

OK thanks for info JP.

I'm not demanding on this.
I just created this ticket because I wanted to have latest SQLite included in next beta/release (to developers not forget about it). :-)

comment:7 Changed 15 years ago by Jpm

I take care of any version coming out sqlite.org now we are at 3.6.14.1

Guidelines for posting comments:

  • You cannot re-open a ticket but you may still leave a comment if you have additional information to add.
  • In-depth discussions should take place on the forum.

For more information see the full version of the ticket guidelines here.

Add Comment

Modify Ticket

Action
as closed The owner will remain Gary.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.