Scribd
Upload
42 views1 page

0003 What Is SQLite

This document provides an overview of SQLite. SQLite is a public domain software library that provides a relational database management system (RDBMS). As an RDBMS, SQLite stores user-defined records in tables and can process complex queries combining data from multiple tables. Unlike other RDBMS products, SQLite does not require a separate server process - the entire database is contained in a single cross-platform file. It has a very small memory footprint and minimal setup requirements.

Uploaded by

Cavalcante Cavalcante
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
42 views1 page

0003 What Is SQLite

This document provides an overview of SQLite. SQLite is a public domain software library that provides a relational database management system (RDBMS). As an RDBMS, SQLite stores user-defined records in tables and can process complex queries combining data from multiple tables. Unlike other RDBMS products, SQLite does not require a separate server process - the entire database is contained in a single cross-platform file. It has a very small memory footprint and minimal setup requirements.

Uploaded by

Cavalcante Cavalcante
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

[Link]-ebooks.

info

CHAPTER 1

What Is SQLite?

,Q WKH VLPSOHVW WHUPV 64/LWH LV D SXEOLFGRPDLQ VRIWZDUH SDFNDJH WKDW SURYLGHV D
UHODWLRQDOGDWDEDVHPDQDJHPHQWV\VWHPRU5'%065HODWLRQDOGDWDEDVHV\VWHPVDUH
XVHGWRVWRUHXVHUGHILQHGUHFRUGVLQODUJHWDEOHV,QDGGLWLRQWRGDWDVWRUDJHDQGPDQ
DJHPHQWDGDWDEDVHHQJLQHFDQSURFHVVFRPSOH[TXHU\FRPPDQGVWKDWFRPELQHGDWD
IURPPXOWLSOHWDEOHVWRJHQHUDWHUHSRUWVDQGGDWDVXPPDULHV2WKHUSRSXODU5'%06
SURGXFWV LQFOXGH 2UDFOH 'DWDEDVH ,%0V '% DQG 0LFURVRIWV 64/ 6HUYHU RQ WKH
FRPPHUFLDOVLGHZLWK0\64/DQG3RVWJUH64/EHLQJSRSXODURSHQVRXUFHSURGXFWV
7KH/LWHLQ64/LWHGRHVQRWUHIHUWRLWVFDSDELOLWLHV5DWKHU64/LWHLVOLJKWZHLJKW
ZKHQ LW FRPHV WR VHWXS FRPSOH[LW\ DGPLQLVWUDWLYH RYHUKHDG DQG UHVRXUFH XVDJH
64/LWHLVGHILQHGE\WKHIROORZLQJIHDWXUHV
6HUYHUOHVV
64/LWHGRHVQRWUHTXLUHDVHSDUDWHVHUYHUSURFHVVRUV\VWHPWRRSHUDWH7KH64/LWH
OLEUDU\DFFHVVHVLWVVWRUDJHILOHVGLUHFWO\
=HUR&RQILJXUDWLRQ
1R VHUYHU PHDQV QR VHWXS &UHDWLQJ DQ 64/LWH GDWDEDVH LQVWDQFH LV DV HDV\ DV
RSHQLQJDILOH
&URVV3ODWIRUP
7KHHQWLUHGDWDEDVHLQVWDQFHUHVLGHVLQDVLQJOHFURVVSODWIRUPILOHUHTXLULQJQR
DGPLQLVWUDWLRQ
6HOI&RQWDLQHG
$VLQJOHOLEUDU\FRQWDLQVWKHHQWLUHGDWDEDVHV\VWHPZKLFKLQWHJUDWHVGLUHFWO\LQWR
DKRVWDSSOLFDWLRQ
6PDOO5XQWLPH)RRWSULQW
7KHGHIDXOWEXLOGLVOHVVWKDQDPHJDE\WHRIFRGHDQGUHTXLUHVRQO\DIHZPHJDE\WHV
RIPHPRU\:LWKVRPHDGMXVWPHQWVERWKWKHOLEUDU\VL]HDQGPHPRU\XVHFDQEH
VLJQLILFDQWO\UHGXFHG

You might also like