Cargando…
Using SQLite /
"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...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, Calif. :
O'Reilly,
2010.
|
| Edición: | 1st ed. |
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- 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.