Toronto Metropolitan University
Browse
Ma_Jason_V.pdf (1.99 MB)

SQLite Page Caching Algorithm

Download (1.99 MB)
report
posted on 2023-01-10, 16:00 authored by Jason V Ma

[Introduction]: "SQLite is a database which can be easily embedded inside an application written in the C programming language.  One common use is inside the Mozilla Firefox web browser.  It supports asubset of the SQL language but was not intended to be a replacement for a multi-user database suchas MySQL, Oracle or Microsoft SQL Server.The entire database is integrated into one *.c file and the command shell for the command lineinterface is inside another file.  Thus to embed the database a developer just has to copy and pastethe source code into their database.  It also comes in another format with separate files for eachcomponent but is not recommended for use  due to slower performance.  SQLite's developers indicate there is a 5-10% performance improvement when using the amalgamation due to compileroptimizations for a single file.

SQLite supports connections via multiple threads, but it does not support intra-query parallelism.For example commercial databases can divide a large query so that it is run concurrently acrossseparate CPUs.  SQLite has a very coarse locking level.  Since the database is located inside one file,the entire file is locked for writing.  Concurrent reads can still occur on the file.  It does not supportfiner levels of locking such as table or row locks."

History

Language

eng

Usage metrics

    Computer Science

    Exports

    RefWorks
    BibTeX
    Ref. manager
    Endnote
    DataCite
    NLM
    DC