Comparison of several small Databases

Comparison of several small Databases

From: http://hi.baidu.com/xiaoyujn/blog/item/53dfba8851c7a097a5c272f2.html

Access, MSDE 2000, embedded Firebird, SQLite, and so on are free redistributable databases. In contrast, MSDE 2000 has a significant disadvantage in that it needs to be installed. Its biggest advantage is that it is consistent with the SQL Server programming model on the server side and is easy to develop. The obvious disadvantage of access is that it has fewer functions and does not support common functions such as transactions. The biggest advantage is that it is simple, most developers are familiar with it, and it is easy to deploy. SQLite supports transactions and is also a single-file database. What is insufficient is that. NET data provider is not very mature. Firebird also has the following advantages: Single file, simple deployment without installation (xcopy only two files), support for transactions, stored procedures, triggers,. NET data provider is stable and mature. There are countless databases on this planet. Here we only list some of the common ones I have been using. It can be a little exaggerated to say that there are interactive applications, at least some data should be saved, even if the data in the Custom structure is saved, it is still the most common INI, XML, etc, it can be regarded as a "Database", such as DBASE series, FOXBASE, Foxpro, msaccess, Interbase, ms SQL Server, Oracle, DB2, etc. These are commercial databases, the first few can only be regarded as databases, and the last few are rmdbs (relational database management system ). Commercial applications include SQLite, simplesql, Berkely dB, minosse, Firebird (formerly Borland Interbase), PostgreSQL, and MySQL. □Sqlite: You can view my SQLite series essays, which are written in C. It can be used across operating platforms and supports most ansi SQL 92. It is an embedded lightweight relational database engine and only needs one DLL, the size is 250 kb, and the database is just a file, which can work without configuration. Since it is open-source, you can even embed it into yourProgram. There is only one core developer. I recently joined another developer, that is, two people. I really admire it. Currently, it has grown to 3.1.0, which is highly efficient and stable. There are open-source drivers and their ado on sourceforge.net. NET data provider for SQLite: https://sourceforge.net/projects/adodotnetsqlite. □Simplesql: it is several times larger than SQLite, but it is also lightweight. It features a little more powerful. It is written in C ++ and has versions such as Ole and Java. □Berkely DB: A large relational database system written in C ++. It also supports XML (using XML as a database) and is known as a 2 million installation volume, mySQL is only known as a 5 million installation, cross-platform. □Minosse: a large-scale relational database system written in pure C #, ideally surpassing ms SQL Server! The latest version: 0.2.0 is really rare. It is much written in pure Java. Pure C # is the first version, not for porting others. I admire it: contains C/S and embedded versions, and can span most platforms, because it does not need windows, it can be compiled under mono. □Firebird: This is awesome. Currently, stable version 1.5 has many features, fully supporting ANSI sql92, 98, and so on. Some cool features are crazy (1.0 features, 1.5 features, from here on) the main developer is a Russian. Currently, the development team has expanded to nearly 100 people. There are three modes: Standalone, typical c/s, and super server. Version 2.0 and version 3.0 will be released in the near future. You will go crazy after reading the Road Map (2.0 and 3.0. It has a. Net driver and is currently in version 1.7beta. Main features: ◆ A. C. I. D; ◆ MGA (any version of the engine can process the same database record ); ◆ Psql (Stored Procedure) is super powerful, ms SQL is relatively too many times, it can be achieved on the server side and pushed to the client to become a powerful report, stored procedure; ◆ Triggers can be obtained from the client for monitoring and tracking; ◆ Automatic read-only mode; ◆ Never make mistakes in innovative transactions; ◆ The database can still be backed up at any time during 24x7 running; ◆ Unified trigger: any operation can allow the unique trigger of a table to be under overall control; ◆ Plug-in can be written in most languages, and functions can be called directly in the stored procedure; ◆ C-> C ++, fewer Code But faster speed; ◆ Three running modes, or even embedded; ◆ It can be called in mainstream languages; ◆ Dynamic SQL Execution; ◆ Transaction retention point; □Postgresql: the post-open-source version of ipvs database, which claims to have a large number of new features not available in any other databases. It seems that the goal is to build a super large oo relational database system, which has grown to 8.0 at present. net driver. The Chinese official website provides a detailed introduction. □Mysql: This is not required, do you? Known as the world's most popular open source database, but I am surprised that PostgreSQL supports Simplified Chinese, including kernel, management tools, QA, and so on. In the latest version of MySQL, I did not find ..., yes. net driver. MySQL connector/net is the bytefx on sf.net. for the data project, the author has joined the MySQL team. For more information, see "feeling 20. Open-source prospects/Qian tu? (1 Database).