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. Scythe Mugen MAX
  2. Intel Core i7 5960X Haswell-E On Linux
  3. Intel 80GB 530 Series M.2 SSD On Linux
  4. With A New Motherboard, The Core i7 5960X Haswell-E Lights Up
Latest Linux Articles
  1. RadeonSI GLAMOR Benchmarks With X.Org Server 1.16
  2. RadeonSI Gallium3D vs. Catalyst At 4K UHD On Linux
  3. MSAA RadeonSI Gallium3D Performance Preview
  4. Intel Core i7 5960X CPU Core Scaling Under Linux
Latest Linux News
  1. Tropico 5 Being Released For Linux Gamers This Week
  2. Eclipse IDE Starts Firing Up On Wayland's Weston
  3. OpenSUSE Announcement On SUSE's Recent Merger
  4. Valve Begins Publicly Tracking AMD Catalyst Linux Issues
  5. Digia Qt Spinoff Is Called "The Qt Company"
  6. GNOME 3.14 Makes More Progress In Running Natively On Wayland
  7. Minix 3.3 Released With Cortex-A8 ARM Support, NetBSD Userland Compatibility
  8. More Intel DRM Changes Queued For Linux 3.18, Including Old i830M Fixes
  9. New Code Starts Lining Up For X.Org Server 1.17
  10. Rust Developers Planning For The Rust 1.0 Language
Latest Forum Discussions
  1. New Group Calls For Boycotting Systemd
  2. Hd 6850
  3. New stress testing utility for GPU's
  4. Best Radeon for a Power Mac G5?
  5. Updated and Optimized Ubuntu Free Graphics Drivers
  6. support for first generation UVD blocks (RV6xx, RS780, RS880 and RV790)
  7. Nvidia joins the ranks of Apple and Microsoft
  8. nv and xorg.conf under Debian PPC