Life with SQLite

摘要

With Tiger, Apple has started using SQLite in many ways. Most notably, SQLite is the recommended store for Core Data applications. A database server, for example Oracle or PostgreSQL, is a daemon that responds to requests from client applications. The clients make requests of the server using Structured Query Language (SQL) via some client library. The server takes care of the security, concurrency, and distribution issues. The server stores tables of data that can be indexed for quick random access.