Interoperable SQLite for a Bare PC

  • William Thompson
  • Ramesh Karne
  • Alexander Wijesinha
  • Hojin Chang
Conference paper

DOI: 10.1007/978-3-319-58274-0_15

Part of the Communications in Computer and Information Science book series (CCIS, volume 716)
Cite this paper as:
Thompson W., Karne R., Wijesinha A., Chang H. (2017) Interoperable SQLite for a Bare PC. In: Kozielski S., Mrozek D., Kasprowski P., Małysiak-Mrozek B., Kostrzewa D. (eds) Beyond Databases, Architectures and Structures. Towards Efficient Solutions for Data Analysis and Knowledge Representation. BDAS 2017. Communications in Computer and Information Science, vol 716. Springer, Cham

Abstract

SQLite, a widely used database engine, has been previously transformed to run on a bare PC without the support of any OS or kernel. However, the transformed SQLite database was stored in main memory i.e., it had no file system. This paper extends the transformation process to enable bare PC SQLite to work with standard file system interfaces based on the FAT32 file specification. It further presents mechanisms and programming interfaces for a bare machine file system integrated with SQLite that uses a removable USB flash drive. The bare SQLite database and file system can interoperate with conventional OS-based database systems. It can be adapted in the future to work with bare Web browsers, large bare databases, other bare applications, and bare mobile devices.

Keywords

SQLite Transformation Interoperability Performance 

Copyright information

© Springer International Publishing AG 2017

Authors and Affiliations

  • William Thompson
    • 1
  • Ramesh Karne
    • 1
  • Alexander Wijesinha
    • 1
  • Hojin Chang
    • 1
  1. 1.Towson UniversityTowsonUSA

Personalised recommendations