Why Use SQLite?


There are many reasons for choosing SQLite, including

  • Performance SQLite performs database operations efficiently and is faster than other free databases such as MySQL and PostgreSQL.

  • Size SQLite has a small memory footprint and only a single library is required to access databases, making it ideal for embedded database applications.

  • Portability SQLite runs on many platforms and its databases can be ported easily with no client/server setup or ongoing administration required.

  • Stability SQLite is ACID-compliant, meeting all four criteriaAtomicity, Consistency, Isolation, and Durability.

  • SQL support SQLite implements a large subset of the ANSI-92 SQL standard, including views, subqueries, and triggers.

  • Interfaces SQLite has language APIs for C/C++, PHP, Perl, Python, Tcl, and many more beyond those covered in this book.

  • Cost SQLite is in the public domain and therefore is free to use for any purpose without cost and can be freely redistributed.



    SQLite
    SQLite
    ISBN: 067232685X
    EAN: 2147483647
    Year: 2004
    Pages: 118
    Authors: Chris Newman

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net