This chapter introduces both SQLite
and PHP??™s ability to interface with this surprisingly capable database engine.
Introduction to SQLite
SQLite is a very compact, multiplatform SQL database engine written in C. Practically
SQL-92 compliant, SQLite offers many of the core management features made available
by products such as MySQL, Oracle, and PostgreSQL, yet at considerable savings
in terms of cost, learning curve, and administration investment. Some of SQLite??™s
more compelling characteristics include the following:
??? SQLite stores an entire database in a single file, allowing for easy backup
and transfer.
??? SQLite??™s approach to database security is based entirely on the executing user??™s
file permissions. So, for example, user web might own the Web server daemon
process and, through a script executed on that server, attempt to write to an
SQLite database named mydatabase.db. Whether this user is capable of doing so
depends entirely on the mydatabase.db file permissions.
568 CHAPTER 22 ?– SQLITE
??? SQLite offers default transactional support, automatically integrating commit
and rollback support.
??? SQLite is available under a public domain license (it??™s free) for both the
Microsoft Windows and Linux platforms.
This section offers a brief guide to the SQLite command-line interface. The purpose
of this section is twofold. First, it provides an introductory look at this useful client.
Pages:
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651