Common embedded Databases

1. MySQLIt is a relational database management system developed by MySQL AB in Sweden. because of its small size, high speed, and low overall cost, in particular, the open source code features that many small and medium websites have chosen the MySQL database to reduce the overall cost of their websites. MySQL is widely used on servers of Small and Medium-sized websites on the Internet. MySQL has the following features:

(1) the source code is written in C and C ++ languages and tested using multiple compilers. This ensures the portability and Stability of the source code;

(2) supports multiple operating systems, including AIX, FreeBSD, HP-UX, Linux, Mac OS, Novell Netware, OpenBSD, OS/2 Wrap, Solaris, and Windows;

(3) provides API functions for multiple programming languages, such as C, C ++, Eiffel, Java, Perl, PHP, Python, Ruby, and Tcl;

(4) Optimizes the SQL query algorithm, effectively improving the query efficiency;

(5) multi-threaded mechanism to make full use of CPU resources;

(6) provides powerful management tools for managing, checking, and optimizing database operations;

(7) supports common encodings such as Chinese GB 2312, BIG5, and Japanese Shift_JIS in multiple languages, which can be used as data table names and data column names. In the network environment of the Client/Server, it can be used as a separate application, or as a library embedded in other software.

(8) handling large databases with over 10 million records;

(9) provides multiple database connection methods, such as TCP/IP, ODBC, and JDBC.

2. mSQL

MSQL is a single-user database management system. Because of its short and concise nature, Internet users love to use its developed application systems. MSQL occupies less system resources. It is a small relational database system and cannot fully support some standard SQL functions. In addition, mSQL lacks most of the features of ANSISQL and has no transaction and reference integrity, basically, it does not support any nested SQL statements. It only implements APIs with smaller functions. MSQL can only be used for free in a university, or for non-profit purposes such as academic research and charity. It can be used for free. For other applications, you must pay for registration before obtaining formal copyrights, it is not completely free software.

3. Berkeley

The source code of the Berkeley database is open source. It is an embedded database management system that provides high performance when providing data management services for applications. When writing a program, you only need to call some simple API functions to access and manage the database. It is different from common database management systems such as MySQL and Oracle. In BerkeleyDB, there is no concept of a database server, the application directly saves, queries, modifies, and deletes data through the function library embedded in the program. These operations do not need to establish a network connection with the database service in advance.

4. solid

Unlike traditional large enterprise-level database systems, Solid is a "lightweight" database. It is compact and lightweight (the installation medium is about 30 mb, and only about 10 MB of system resources are required for running ), installation, deployment, and maintenance are also very simple, which greatly reduces the maintenance and management costs of the customer. However, solid is also a standard relational database. It does not lose any functionality due to its "lightweight" nature. It supports standards such as SQL, ACID, and transaction isolation levels, and also supports internal database programming, such as stored procedures, triggers, and events. Technical staff with any experience in using other relational databases can easily master the problem. In addition, it covers almost all operating system platforms and can run stably in embedded operating systems, Windows, Linux, AIX, HP-UX and Solaris environments, you can provide an end-to-end data sharing platform within the global network. Solid databases have a wide range of applications, such as embedded fields, desktop systems, small and medium business systems, and can also be applied to business support systems in financial/communication and other high-end industries, it can also be used in core operation support systems of the Telecom, financial, and other industries.

5. SQLite

SQLite database is an embedded database, which is D. developed by Richard Hipp, it is implemented using a small C library and is a powerful embedded relational database. In order to pursue the goal as simple as possible, giving up the complex features of traditional enterprise-level databases, but implementing some essential basic functions of databases. It can be seen that most standard SQL92 statements can be supported by SQLite. In addition, SQLite stores databases in a single file, which is about one to two times faster than MySQL. Statement operations are more similar to relational databases and are very convenient to use. SQLite is an open source database system and can be widely used in commercial products. It has the following features:

(1) Open Source Code: In program development of embedded systems, Free Open Source Code not only reduces product development time, reduces development costs, but also facilitates product maintenance and operation stability.

(2) Small Size and fast speed: all its source code is composed of about 30 thousand lines of C language code, with a size of about KB. Data operations are faster than most popular database systems.

(3) complete functions: supports ACID (Atomicity, Consistency, Isolation, Durability) transactions, Atomicity (Atomicity), Consistency (Consistency), Isolation (Isolation) and Durability (Durability) A database system that supports transactions must have four features. Otherwise, data correctness cannot be guaranteed in the Transaction process (Transaction processing, the transaction process may not meet the requirements of the transaction party. SQLite supports most SQL92, that is, triggers, multiple tables, indexes, transactions, views, and nested SQL. The SQLite database is stored in a single disk file, which allows machines in different byte orders to freely share and supports a database size of 2 TB.

(4) rich API support: For C/C ++, PHP, Perl, and other programming languages, you can use APIs to access the SQLite database and communicate with database files.