SQL open source:
Corresponding to commercial, open source:
SQLite,
SimpleSQL,
Berkely DB,
Minosse,
Firebird (predecessor is Borland's Interbase),
PostgreSQL,
MySQL, etc.
□
SQLITE: You can see my SQLite series, Class C written, can support most ANSI SQL 92 across operation platform, it is an embedded lightweight database engine, only one DLL is 250K, the database is 250K, the database It is just a file, zero configuration, you can work. Since open source, you can even embed it into your program. The core developers have only one, which has recently joined the other, which is 2 people. It is really admired. It is currently developed to 3.1.0. It is quite high-efficient and stable. There is an open source driver has its ADO.NET DATA Provider for SQLITE:
Https://sourceforge.net/projects/adodotnetsqlite/.
□
SimpleSQL: relative
SQLite is a few times, but it is also a lightweight, a slight power, C written, OLE, Java and other versions.
□
Berkely DB: C Writing Large Relational Database System, which also supports XML (XML as a database), claiming that 200 million installation volume, Mysql is just a number of 500 million installations, cross-platform.
□
Minosse: Pure C # Writing large-scale relational database system, ideal is to transcend MS SQL Server! The latest version of:
0.2.0, really rare, written in pure Java to see much more pure C #, not transplant someone else's, is the first one, admire Author: Contains C / S and embedded version, and across most platforms, because It doesn't have Windows's things, you can compile under Mono.
□
Firebird: This thing is too cattle, there is currently
1.5 The stability version already has a lot of characteristics, fully supports ANSI SQL92, 98, etc., some cool features make people crazy (
1.0 characteristics,
1.5 characteristics,
From here, the main developers are a Russians. At present, the development team has expanded to nearly 100, three modes, stand-alone independent, typical C / S, super servers. 2.0 and 3.0 versions will be launched in the near future.
Road map (2.0, 3.0) you will be crazy. Have
.NET driver, currently
1.7beta version. Main features:
◆ A.c.i.d;
◆ MGA (any version of the engine can handle the same database record);
◆ PSQL (stored procedure) super power, MS SQL is relatively too time, it can be implemented and pushed to the client to become a powerful report, stored procedure;
◆ The trigger can get monitoring tracking at the client;
◆ Automatic read-only mode;
◆ Innovation is definitely not wrong;
◆ 24 * 7 can still be back up to the database at any time during operation;
◆ Unified Trigger: Any operation can make a unique trigger of a table to generally control;
◆ Most languages can write plug-in and call the function directly in the stored procedure;
◆ C-> C , less code but more speed; ◆ 3 operating modes, even embedded;
◆ Mainstream language can call it;
◆ Dynamic SQL execution;
◆ Transaction save points;
□
PostgreSQL: Postgres database's post-open source version, claims to have a lot of new features that have no other database, seemed to be a super-large OO relational database system, which has been developed
8.0, there is
.NET driver.
□
Mysql: This, don't you need to say it? Compilation is used, the world's largest open source database, madman.
