SQLite is an embedded database library that implements a large subset of the SQL 92 standard. Its claim to fame is the combination of both the database engine and the interface (to said engine) within a single library, as well as the ability to store all the data in a single file. I terms of functionality SQLite resides somewhere between MySQL and PostgreSQL. However, when it comes to performance, SQLite is often 2-3 times faster (or even more). This is thanks to a highly tuned internal architecture, and the elimination of server-to-clientand client-to-server communication.
One of the most commonly faced dilemmas of system administrators is making dissimilar operating systems and tools work with each other. It is my hope that this article will make those system adminstrators' jobs a little easier when it comes to making Access and PHP work together.
In this article, I will explain how it is possible to connect and query an MS SQL server (running under a Windows operating system) from php installed on a unix box. The same problem, in the case of php installed under Windows is not covered here because it is well explained in php FAQ; sadly I cannot say the same thing for the unix case. In fact, there is a multitude of incorrect or outdated sources of information which will cause new people trying to solve this problem to drop it after some bad tries. This article can also be of help to people who don't want to use php as a client.
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.