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. The Power Consumption & Efficiency Of Open-Source GPU Drivers
  2. AMD R600g/RadeonSI Performance On Linux 3.16 With Mesa 10.3-devel
  3. Intel Pentium G3258 On Linux
  4. SilverStone Precision PS10
Latest Linux Articles
  1. Nouveau vs. Radeon vs. Intel Tests On Linux 3.16, Mesa 10.3-devel
  2. KVM Benchmarks On Ubuntu 14.10
  3. X.Org Server 1.16 Officially Released With Terrific Features
  4. Ubuntu With Linux 3.16 Smashes OS X 10.9.4 On The MacBook Air
Latest Linux News
  1. Git 2.1 To Further Mainline Windows Support Patches
  2. Debian 8.0 Jessie Is Settling For Linux 3.16
  3. Meson: A Next-Gen Build System Showing Promise
  4. Linux 3.16-rc7 Calms Things Down For The Linux 3.16 Kernel
  5. Open-Source AMD Users Report Hawaii GPU Acceleration Is Working
  6. Linus Torvalds On GCC 4.9: Pure & Utter Crap
  7. Cauldron 2014: GCC & LLVM Will Look To Collaborate More
  8. GCC Receives ACM Programming Languages Software Award
  9. KDE 4.14 Beta 3 Released
  10. A New Video Has Us Real Excited About The New UT For Linux
Latest Forum Discussions
  1. Updated and Optimized Ubuntu Free Graphics Drivers
  2. ASRock AM1H-ITX: One Of The Best AM1 Mini-ITX Motherboards
  3. Debian + radeonsi
  4. Open-source drivers on ATI R7 260X
  5. Table test
  6. How To Setup Radeon DPM On Ubuntu Linux
  7. New build, first Linux PC, what could go wrong? ;)
  8. AMD "Hawaii" Open-Source GPU Acceleration Still Not Working Right