Access, SQLite, HSQLDB, Sybase, MySQL, db4o

I. Access

The data type is somewhat different, and the password is too easy to break and the performance is not high. It can only be used in Windows Program .

Generally, it is better to have no more than 0.1 million records in a single table, and the whole database should not exceed MB. Access limits the database capacity to 2 GB, but the performance will take effect after the database capacity exceeds MB.

There will be a large discount.

Ii. HSQLDB

Supports CSV, easy configuration distribution, and poor performance in the case of large data volumes. This is irrelevant to the SQL Execution efficiency, and the performance bottleneck lies in the hard disk file. After all, because HSQLDB is not

It takes only a CSV file to store data files. It can only be used in Java programs.

Iii. Firebird

Data files are single, and deployment and distribution are relatively simple. In embedded mode, you only need to set icudt30.dll, icuin30.dll, icuuc30.dll,

Jaybird21.dll, fbembed. dll, five files, and the Directory Intl (which contains two files that process character sets) can be placed in the program startup directory. Chinese support is good.

But use the gb_2312 character set when creating the database. There are multiple bindings in. net, C ++, and Java.

Iv. Sybase ASA

Data can be encrypted with good performance and requires payment.

5. Derby

Both Performance and ease of use are good, but the embedded version does not have data authentication at all, so everyone can open the database to execute SQL statements, and the database is stored in a directory

Stored. It can only be used in Java programs.

Vi. sqllite

The official release does not support data encryption. In addition, data encryption is often incorrect for Chinese characters, especially when order by is used. In addition, user authentication is not performed at all.

Good efficiency. Almost a little popularProgramming LanguageAll have corresponding binding.

VII. MySQL

Even though MySQL can be directly copied without installation, it is still far from embedded.

8. db4o

For object-oriented databases, you can directly store objects using db4o without Using ORM tools. Supports Java and. Net platforms. Customizable Data EncryptionAlgorithm, Excellent performance

Good, single file. Although server mode is also supported, embedded is the best choice.

In addition, you can select vistadb, berkeleydb, and so on.