| Description |
1 online resource (xx, 503 pages) : illustrations |
|
text file rda |
| Summary |
"Learn how to maintain localized storage in a single file that requires no configuration; build your own SQLite library or use a precompiled distribution in your application; get a primer on SQL, and learn how to use several language functions and extensions; work with SQLite using a scripting language or a C-based language such as C♯ or Objective-C; understand the basics of database design, and learn how to transfer what you already know to SQLite; take advantage of virtual tables and modules"--Page 4 of cover. |
| Contents |
Table of Contents; Preface; SQLite Versions; Email Lists; Example Code Download; How We Got Here; Conventions Used in This Book; Using Code Examples; Safari® Books Online; How to Contact Us; Chapter 1. What Is SQLite?; Self-Contained, No Server Required; Single File Database; Zero Configuration; Embedded Device Support; Unique Features; Compatible License; Highly Reliable; Chapter 2. Uses of SQLite; Database Junior; Application Files; Application Cache; Archives and Data Stores; Client/Server Stand-in; Teaching Tool; Generic SQL Engine; Not the Best Choice; Big Name Users. |
|
Chapter 3. Building and Installing SQLiteSQLite Products; Precompiled Distributions; Documentation Distribution; Source Distributions; The Amalgamation; Source Files; Source Downloads; Building; Configure; Manually; Build Customization; Build and Installation Options; An sqlite3 Primer; Summary; Chapter 4. The SQL Language; Learning SQL; Brief Background; Declarative; Portability; General Syntax; Basic Syntax; Three-Valued Logic; Simple Operators; SQL Data Languages; Data Definition Language; Tables; The basics; Column types; Column constraints; Primary keys; Table constraints. |
|
Tables from queriesAltering tables; Dropping tables; Virtual tables; Views; Indexes; Data Manipulation Language; Row Modification Commands; INSERT; UPDATE; DELETE; The Query Command; Transaction Control Language; ACID Transactions; SQL Transactions; Save-Points; System Catalogs; Wrap-up; Chapter 5. The SELECT Command; SQL Tables; The SELECT Pipeline; FROM Clause; CROSS JOIN; INNER JOIN; OUTER JOIN; Table aliases; WHERE Clause; GROUP BY Clause; SELECT Header; HAVING Clause; DISTINCT Keyword; ORDER BY Clause; LIMIT and OFFSET Clauses; Advanced Techniques; Subqueries; Compound SELECT Statements. |
|
Alternate JOIN NotationSELECT Examples; Simple SELECTs; Simple JOINs; JOIN ... ON; JOIN ... USING, NATURAL JOIN; OUTER JOIN; Compound JOIN; Self JOIN; WHERE Examples; GROUP BY Examples; ORDER BY Examples; What's Next; Chapter 6. Database Design; Tables and Keys; Keys Define the Table; Foreign Keys; Foreign Key Constraints; Generic ID Keys; Keep It Specific; Common Structures and Relationships; One-to-One Relationships; One-to-Many Relationships; Many-to-Many Relationships; Hierarchies and Trees; Adjacency Model; Nested set; More information; Normal Form; Normalization; Denormalization. |
|
The First Normal FormThe Second Normal Form; The Third Normal Form; Higher Normal Forms; Indexes; How They Work; Must Be Diverse; INTEGER PRIMARY KEYs; Order Matters; One at a Time; Index Summary; Transferring Design Experience; Tables Are Types; Keys Are Backwards Pointers; Do One Thing; Closing; Chapter 7. C Programming Interface; API Overview; Structure; Strings and Unicode; Error Codes; Structures and Allocations; More Info; Library Initialization; Database Connections; Opening; Special Cases; Closing; Example; Prepared Statements; Statement Life Cycle; Prepare; Step; Result Columns. |
| Subject |
SQL (Computer program language)
|
|
Relational databases.
|
|
Database management.
|
|
Application software.
|
|
SQL (Langage de programmation) |
|
Bases de données relationnelles. |
|
Bases de données -- Gestion. |
|
Logiciels d'application. |
|
Application software |
|
Database management |
|
Relational databases |
|
SQL (Computer program language) |
| Genre |
Software
|
| Other Form: |
Print version: Kreibich, Jay A. Using SQLite. 1st ed. Sebastopol, CA : O'Reilly, ©2010 9780596521189 (OCoLC)535495179 |
| ISBN |
9781449399467 (electronic bk.) |
|
1449399460 (electronic bk.) |
|
9781449399641 (electronic bk.) |
|
1449399649 (electronic bk.) |
|
0596521189 |
|
9780596521189 |
|
(pbk.) |
|
(pbk.) |
| Standard No. |
9780596521189 |
|
More Resources