The Research And Implementation Of Embedded Database SQLite Debugger

With the development of embedded technology and information technology used in all kinds of environments, there is an urgent need for data management in embedded system, it has been a critical problem. File system can't meet the user's need to flexisble and large data. Researchers have developed database management system suited in embedded devices to store data and provide efficient data management. Generally embedded database has the feature of small foot-print, high speed, and real-time processing capability. Its data mainly resides in memory to remove the uncertainly brought by accessing the peripheral storage device.In more popular open source embedded database management system at present, SQLite has many features as follows:cross-platform, simple and easy to use API, small code footprint, faster than popular client/server database engines for most common operations, reliable, used less resources, and free for use for any purpose, commercial or private. The same as other embedded database management system, SQLite can't lonely execute, because it is not a sole process. SQLite must be integrated into host application, and share the address of process.According to the feature of SQLite, most of the software developers isn't clear for the internal working principle of SQLite, which lead to take more time on the development of database and the imperfect of design. Meanwhile, compare to the more popular of embedded database management system, they has much or less debugging and trace function to help database developers with finishing the design of database, but SQLite isn't so. Debugging is a very frequent task in the development and maintenance of software, and there may be a great variety of issues to be debugged in each stage of software life circle. The method of debugging has a direct impact on the efficiency of the system development and the quality of the software. Currently, the study on technology about debugger is less in our country, meanwhile most of the embedded database's debugging tools are supported by foreign companies. So it is meaningful to study the debugging technology deeply and develop the debugger of SQLite.For this, on the basis of analysis the advantages and disadvantages of various debugging technology and according to the analysis and research of open source embedded database management system with debugging and trace function, the design model of external debugger is not suitable for the design of SQLite's debugger at present. But it is feasible design in the SQLite with a debugging and trace function of the library.This paper implement the debugger of SQLite, which fully inherit the statement style of SQLite development, namely standard ANSI C. It is good for compatible debugger with SQLite.Under the debugging mode, SQlite can normal and high efficiency in the operation, and not produce exception results. What'more, the function call of the debugger of SQLite is simple and easy use. Software developers only insert into the breakpoints of SQL or put a few macros with the need of debugging and trace in the program. Both will appear as SQLite database development personnel to provide a simple and efficient program test function, decreasing the fault of SQLite database in the design, so that the period of software developing will be decreased.