1. Computers
  2. Display Drivers
  3. Graphics Cards
  4. Memory
  5. Motherboards
  6. Processors
  7. Software
  8. Storage
  9. Operating Systems


Facebook RSS Twitter Twitter Google Plus


Phoronix Test Suite

OpenBenchmarking.org

SQLite 3.8 Release Brings Partial Indexes, NGQP

Free Software

Published on 26 August 2013 11:20 AM EDT
Written by Michael Larabel in Free Software
Comment On This Article

For those relying upon the widely-used SQLite relational database system, version 3.8.0 is now available with support for partial indexes, the Next Generation Query Planner (NGQP), new pragmas, and other features.

SQLite 3.8.0 isn't an incredibly feature-rich release but in part due to the NGQP introduction, the version was bumped to 3.8.0 rather than 3.7.18. There's also some chance of legacy applications breaking on this release.

For those curious about the Next Generation Query Planner for SQLite, it's described at length on this web-page and it's "almost always better" than the existing query planner, which comes up with the best algorithm to accomplish an SQL statement. This leads to faster and better query plans with SQLite 3.8.

SQLite 3.8.0 also supports partial indexes and new pragmas for cache_spill, query_only, and defer_foreign_keys. There's also a host of new compile-time options, other enhancements, and bug-fixes to this lightweight SQL library release.

More details on SQLite 3.8.0 can be found via SQLite.org.

About The Author
Michael Larabel is the principal author of Phoronix.com and founded the web-site in 2004 with a focus on enriching the Linux hardware experience and being the largest web-site devoted to Linux hardware reviews, particularly for products relevant to Linux gamers and enthusiasts but also commonly reviewing servers/workstations and embedded Linux devices. Michael has written more than 10,000 articles covering the state of Linux hardware support, Linux performance, graphics hardware drivers, and other topics. Michael is also the lead developer of the Phoronix Test Suite, Phoromatic, and OpenBenchmarking.org automated testing software. He can be followed via and or contacted via .
Latest Linux Hardware Reviews
  1. AMD Radeon R9 290: Gallium3D vs. Catalyst Drivers
  2. AMD Radeon R9 290 Open-Source Driver Works, But Has A Ways To Go
  3. Trying The Configurable 45 Watt TDP With AMD's A10-7800 / A6-7400K
  4. Sumo's Omni Gets Reloaded
Latest Linux Articles
  1. 20-Way Radeon Comparison With Open-Source Graphics For Steam On Linux Gaming
  2. Preview: OS X 10.10 Yosemite vs. Ubuntu Linux GPU Performance
  3. Radeon Graphics Yield Mixed Results With Linux 3.17 Kernel
  4. AMD's RadeonSI Driver Sped Up A Lot This Summer
Latest Linux News
  1. Nouveau On Oibaf PPA Is Back To Running Well
  2. Metro 2033 Redux Will Hopefully Hit Linux Real Soon
  3. New Virtual Monitor Software Might End Up On Linux
  4. Company of Heroes 2 Might Be Coming Out For Linux
  5. NIR Still Being Discussed For Mesa, LLVM Gets Brought Up Again
  6. Plasma Active Is Mostly Ported To KDE Frameworks 5
  7. Google Chrome 37 Brings Many Security Fixes
  8. MenuetOS Updated With SMP Threads & Onscreen Keyboard
  9. Mesa Has A New Release Manager
  10. Enlightenment E19 Lands Its New Wayland Compositor Code
Latest Forum Discussions
  1. AMD Releases UVD Video Decode Support For R600 GPUs
  2. Announcing radeontop, a tool for viewing the GPU usage
  3. Updated and Optimized Ubuntu Free Graphics Drivers
  4. [DB] BIOS - ACPI - data collecting
  5. It's Now Possible To Play Netflix Natively On Linux Without Wine Plug-Ins
  6. Users defect to Linux as OpenBSD removes Lynx from base system
  7. Chinese People Try To Patent Wine On ARM
  8. American Citizens running AMOK for food stamps