Oracle join the SQLite Consortium
By Gregory Burd on Jun 23, 2010
Yesterday Oracle became the latest member of the SQLite Consortium.
Over the past few months Oracle has been launching various products with new support for the SQLite3 API. Oracle Database Lite Mobile Server now supports synchronization of data within SQLite databases to Oracle Database. Oracle JDeveloper is adding support for SQLite. And most recently Oracle Berkeley DB 11gR2 (220.127.116.11.21) was released with a new SQL API which is in fact a layering of SQLite query processing code on top of Berkeley DB storage code. Combining the two products brings SQL processing to Berkeley DB users and a more robust, concurrent, and scalable storage layer (btree) to the SQLite community of users.
To show our commitment to the community which built SQLite and demonstrate our sincere desire to be a good citizen and partner in that community we've joined the SQLite Consortium. In so doing we gain access to more complete test suites which we will use to validate our combined BDB SQL(ite) API. When we find and fix bugs or make improvements to the SQLite code it is our intention to provide that code to the SQLite team for integration into their product. We don't want to see SQLite fork, we will work to continually integrate and cooperate with the SQLite developers.
Finally, we fundamentally believe that the SQLite approach to small device SQL storage is the right one. They are making the right trade-offs, hard decisions not to include infrequently used features or over optimize code prematurely. The SQLite SQL engine is an amazing example of the 80/20 rule and due to that focus of purpose it is now a dominant, defacto solution in mobile and embedded devices as well as small to medium sized ISV applications.
As a new emergent standard, the SQLite3 ANSI C API, is now supported by at least two vendors and used by millions of open source developers around the globe. Ask your vendor, "Do you support the SQLite3 API?" because that's the new "ODBC" for in-device and in-application relational database access.
The Oracle mobile platform database strategy is evolving and the Berkeley DB storage product is the way we expect everyone will build solutions on the edge or in consumer devices. Berkeley DB's new SQLite-based SQL API is the new standard by which all solutions will be measured.
Is your solution based on the SQLite API or Berkeley DB's SQL?