Study and application of SQLite embedded database system based on Windows cE

Abstract

The SQLite is an open source embedded database engine. For its advantages of small core, fast and high efficiency, stability and reliability, portability and so on, SQLite is widely applied in the data management of embedded environment, such as mobile phone, PDA, industrial control, etc. In this study, the features, architecture and development technology of SQLite are discussed. We proposed a detailed porting process for SQLite to Windows CE platform, and we also introduced an C++ unicode encapsulation for SQLite. In the end, we presented an application of SQLite in embedded system that is about the data recording system which based on ARM and Windows CE 5.0. The experiment shows that it is high performance embedded database and is suitable for embedded system.