Web Design Specialists.

Databases MySQL, PostSQL, mSQL

Common Database features:

• All three databases use a subset of the features of ANSI SQL. This allows a program or user to store, manipulate and retrieve data in table structures.
• All three databases have a sophisticated and flexible client server architecture. Each of these programs has a standalone application that listens for connections on a well known TCP port.
• All three databases include debugging and monitoring tools for writing software applications and tracing problems.
• All three databases support a number of programming languages. C, Java, PHP and Perl are well supported on all the databases and free libraries are available to build applications.

mSQL

mSQL is a lightweight database engine designed to provide fast access to stored data with low memory requirements. mSQL is run by a number of internet hosting sites because it offers free entry level access to fast database services but is free to license and light on system resources. One way in which it preserves memory while keeping up speed is by using a "single process engine". This means that new connections to the database are at a low cost to the system in terms of memory and CPU use. The drawback of this approach is that the number of simultaneous connections is limited to around 250.

mySQL

MySQL is slightly more sophisticated in the features it has available and is faster than mSQL but uses more memory. mySQL is built on top of a fast indexed sequential engine. It is faster than mSQL but it gains this extract speed by burning extra system resources. It is fully multi-threaded using kernel threads. That means it easily can use multiple CPUs if available. As well as excellent Linux support it also runs on most Unix systems and has a ODBC driver available. Support contracts are available from the company that wrote the program at very reasonable rates.

PostSQL

PostSQL uses even more memory and is slower but offers more features. PostSQL is a sophisticated Object-Relational DBMS, supporting almost all SQL constructs, including subselects, transactions, and user-defined types and functions. It is the most advanced open-source database available.

PostSQL is based on the commercial Ingres database system. Because of its roots as a teaching aid it does not have the blistering performance that MySQL boasts, but instead has focused on a wide range of features.

A   B   C   D   E   F   G   H   I   J   K   L   M   N   O   P   Q   R   S   T   U   V   W   X   Y   Z