SQLite - People

scacchicgardenΛογισμικό & κατασκευή λογ/κού

13 Δεκ 2013 (πριν από 3 χρόνια και 10 μήνες)

95 εμφανίσεις

SQLite

Cole Hoosier

hoozh@ksu.edu

Overview


RDBMS


Relational database management
system


ACID Compliant


Atomicity, consistency, isolation,
durability


C Library


Public Domain

The Good


Fast


Zero configuration


Variable
-
length records


Each DB stored in single file


Libraries are small ( <250KB )


Supports 5 common operating
systems

The Bad


No type
-
checking


A feature?


Only one process can obtain write
access at a time


Higher overhead to initialize a
transaction

The Ugly


Not SQL
-
92 Complete


3
rd

revision of the SQL standard


No “foreign key” constraints


No “check” constraints


No “grant”/”revoke” access
permissions


Supported Languages


C/C++/Objective
-
C


Java


.NET


Lisp


OCaml


Perl


PHP


Python **


Ruby


Visual Basic


ODBC Driver


Many more….

Appropriate Uses


Websites


Embedded Devices


Application File Format


Testing and Demo Work


Classwork

Non
-
Appropriate Uses


Client/Server Apps


Very High
-
Volume Websites


High concurrency

Example (1)

Example (2)

Example (3)

Example (4)

Example (5)

References


http://www.sqlite.org/


http://en.wikipedia.org/wiki/SQLite


http://en.wikipedia.org/wiki/ACID


http://en.wikipedia.org/wiki/Compari
son_of_relational_database_manage
ment_systems