This repository is to understand the basic backend implementation of SQLite database. Codes are extracted from SQLite 2.5.0 version and initial implementation may have changed. Here, testing codes are added into the test directory and all SQLite implementation are included into the core directory. Tests included to test VFS, Pager and Btree functionality.
- Take a clone of this project into your local folder
git clone https://github.com/madushadhanushka/simple-sqlite.git
- Move inside the repository
cd simple-sqlite
- Build the project with cmake
cmake -DCMAKE_BUILD_TYPE=Debug
- Build with make
make
- Run test
./simple-sqlite
You can use paging functionality to create your own file accessing implementation. You can find out sample usecase in pager.c.
Open pager with the given file name
int sqlitepager_open(Pager **ppPager,const char *zFilename,int nPage,int nEx);
Get page specified by the page number
int sqlitepager_get(Pager *pPager, Pgno pgno, void **ppPage);
Start to write data into a page specified in pData
int sqlitepager_write(void *pData);
Commit page changes into the file
int sqlitepager_commit(Pager*);
Close the connection to the file
int sqlitepager_close(Pager *pPager);
If you see somthing wrong, Inclomplete content or improvement, you are welcome to create issue or send pull request to this repository in order to improve the code quality and the readability.