Electronic Books

The SQLite database was built with this information in mind. In truth, it is little more than a flat text file
with a database engine, but it has been built well, and in such a way that text files will never be sufficient
again. The philosophy behind SQLite is that 95 percent of websites are small to medium traffic sites with
small to medium data requirements. This means that, for most websites, using an enterprise - level
database to store the website data is overkill, thus wasting valuable resources, server real - estate and
development time.
275
Chapter 11: Performing Server-Side Trickery
Here are the bottom - line pros for using a SQLite database:
Requires absolutely no dependencies (excepting libsqlite on Linux).
Runs on almost any operating system, including embedded systems.
Database files are independent of drive formatting and CPU, meaning they are fully portable.
Supports most of the SQL92 specification.
Suitable for sites receiving 100,000 hits per day, and can support sites with up to 1,000,000 hits
per day.


Pages:
516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540