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 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.
Microsoft Access, is a relational database management system from Microsoft that combines the relational Microsoft Jet Database Engine
with a graphical user interface and software development tools. It is a member of the 2007 Microsoft Office system.
One of the benefits of Access from a programmer's perspective is its relative compatibility with SQL (structured query language)
- queries may be viewed and edited as SQL statements, and SQL statements can be used directly in Macros
and VBA Modules to manipulate Access tables. Users may mix and use both VBA and "Macros" for programming forms and logic and offers object-oriented possibilities.
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 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.
Festivals & Fairs (USA)