Documentation Database Servers Beat

From FedoraProject

(Difference between revisions)
Jump to: navigation, search
m (sqlite)
(5 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
{{header|docs}}
 
{{header|docs}}
 
+
{{Docs_beat_closed}}
 
+
= postgresql =
+
 
+
'''postgresql''' has been upgraded to 9.1.2
+
 
+
{{admon/warning | Potentially Incompatible Change | If you rely on the information_schema.referential_constraints view, or if you have columns of type citext, you may need to take special action.  Refer to http://www.postgresql.org/docs/9.1/static/release-9-1-2.html }}
+
 
+
This is primarily a bugfix release.
+
 
+
 
+
= sqlite =
+
 
+
'''sqlite''' has been upgraded to 3.7.9
+
 
+
{{admon/warning | Potentially Incompatible Change | If a search token (on the right-hand side of the MATCH operator) in FTS4 begins with "^" then that token must be the first in its field of the document. }}
+
 
+
There are many changes and improvements:
+
* Orders of magnitude performance improvement for CREATE INDEX on very large tables.
+
* Improved the windows VFS to better defend against interference from anti-virus software.
+
* Improved query plan optimization when the DISTINCT keyword is present.
+
* Allow more system calls to be overridden in the unix VFS - to provide better support for chromium sandboxes.
+
* Increase the default size of a lookahead cache line from 100 to 128 bytes.
+
* Enhancements to the test_quota.c module so that it can track preexisting files.
+
* Added options SQLITE_DBSTATUS_CACHE_HIT and SQLITE_DBSTATUS_CACHE_MISS to the sqlite3_db_status() interface.
+
* Removed support for SQLITE_ENABLE_STAT2, replacing it with the much more capable SQLITE_ENABLE_STAT3 option.
+
* Enhancements to the sqlite3_analyzer utility program, including the --pageinfo and --stats options and support for multiplexed databases.
+
* Enhance the sqlite3_data_count() interface so that it can be used to determine if SQLITE_DONE has been seen on the prepared statement.
+
* Added the SQLITE_FCNTL_OVERWRITE file-control by which the SQLite core indicates to the VFS that the current transaction will overwrite the entire database file.
+
* Increase the default lookaside memory allocator allocation size from 100 to 128 bytes.
+
* Enhanced the query planner so that it can factor terms in and out of OR expressions in the WHERE clause in an effort to find better indices.
+
* Added the SQLITE_DIRECT_OVERFLOW_READ compile-time option, causing overflow pages to be read directly from the database file, bypassing the page cache.
+
* Remove limits on the magnitude of precision and width value in the format specifiers of the sqlite3_mprintf() family of string rendering routines.
+
 
+
  
 
[[Category:Docs Project]]
 
[[Category:Docs Project]]
 
[[Category:Draft documentation]]
 
[[Category:Draft documentation]]
 
[[Category:Documentation beats]]
 
[[Category:Documentation beats]]

Revision as of 04:56, 8 May 2013

DocsProject Header docTeam1.png
Warning (medium size).png
Beat Closed on Wiki
Work on beats has now moved to git. If you have changes or additions, please contact the docs team via #fedora-docs, docs@lists.fp.o, or with the fedora-release-notes BZ component.