Using SQLite
Application developers, take note: databases aren't just for the IS group any more. You can build database-backed applications for the desktop, Web, embedded systems, or operating systems without linking to heavy-duty client-server databases such as Oracle and MySQL. This book shows you how to...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
O'Reilly
[2010]
|
| Edición: | 1st ed |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628341806719 |
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
- Reset and Finalize
