SQLITE数据库支持库
关于“Sqlite数据库支持库”
“Sqlite数据库支持库”是一个易语言支持库,是对Sqlite数据库的封装,使用此支持库可以方便地在易语言中操作Sqlite数据库。关于Sqlite数据库,请看下一节的介绍。
关于“Sqlite数据库”
Sqlite数据库是一个小型关系型文件数据库;跨平台;支持SQL语句、事务、触发器、视图;速度相当快;小巧且不依赖任何额外的驱动程序。Sqlite数据库是本地数据库,不是网络数据库。
相对于易语言数据库,Sqlite数据库的优势是支持SQL语句、事务、触发器、视图; 相对于Microsoft Access,Sqlite数据库的优势是跨平台、无需额外驱动;
相对于其它非本地数据库,如Oracle、DB2、MS SQL Server、MySQL、PostgreSQL,Sqlite数据库具有小巧、速度快的优势。
Sqlite数据库的主要特性列表(资料来源于doc.guandang.net):
Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures. Zero-configuration - no setup or administration needed. Implements most of SQL92. (Features not supported) A complete database is stored in a single disk file.
Database files can be freely shared between machines with different byte orders. Supports databases up to 2 terabytes (241 bytes) in size.
Sizes of strings and BLOBs limited only by available memory.
Small code footprint: less than 30K lines of C code, less than 250KB code space (gcc on i486) Faster than popular client/server database engines for most common operations. Simple, easy to use API.
TCL bindings included. Bindings for many other languages available separately. Well-commented source code with over 95% test coverage. Self-contained: no external dependencies.
Sources are in the public domain. Use for any purpose.
热门文档