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...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Kreibich, Jay A.
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)

MARC

LEADER 00000cam a2200000Ia 4500
001 OR_ocn738406394
003 OCoLC
005 20231017213018.0
006 m o d
007 cr unu||||||||
008 110705s2010 caua o 001 0 eng d
040 |a UMI  |b eng  |e pn  |c UMI  |d WAU  |d COO  |d N$T  |d TEFOD  |d OCLCQ  |d DEBSZ  |d YDXCP  |d OCLCF  |d NLE  |d EBLCP  |d CIT  |d CUS  |d S4S  |d E7B  |d OCLCQ  |d TEFOD  |d OCL  |d OCLCQ  |d FEM  |d OCLCQ  |d CEF  |d NTG  |d MOQ  |d AU@  |d UAB  |d OCLCQ  |d UKAHL  |d OCL  |d OCLCQ  |d OCLCO  |d OCLCQ  |d OCLCO 
019 |a 657383816  |a 773205209  |a 780425292  |a 859878853  |a 872697410  |a 968047497  |a 969033458 
020 |a 9781449399467  |q (electronic bk.) 
020 |a 1449399460  |q (electronic bk.) 
020 |a 9781449399641  |q (electronic bk.) 
020 |a 1449399649  |q (electronic bk.) 
020 |a 0596521189 
020 |a 9780596521189 
020 |z 9781449394592 
020 |z 1449394590 
020 |z 9780596521189  |q (pbk.) 
020 |z 0596521189  |q (pbk.) 
024 3 |a 9780596521189 
029 1 |a AU@  |b 000058043965 
029 1 |a DEBSZ  |b 368475239 
029 1 |a DEBSZ  |b 396420311 
029 1 |a HEBIS  |b 291542239 
029 1 |a AU@  |b 000066232539 
029 1 |a AU@  |b 000067106514 
035 |a (OCoLC)738406394  |z (OCoLC)657383816  |z (OCoLC)773205209  |z (OCoLC)780425292  |z (OCoLC)859878853  |z (OCoLC)872697410  |z (OCoLC)968047497  |z (OCoLC)969033458 
037 |a CL0500000093  |b Safari Books Online 
037 |a E92F5286-3F48-43FF-9B33-9F3C22941852  |b OverDrive, Inc.  |n http://www.overdrive.com 
050 4 |a QA76.73.S67  |b K737 2010 
072 7 |a COM  |x 051170  |2 bisacsh 
082 0 4 |a 005.756  |2 22 
049 |a UAMI 
100 1 |a Kreibich, Jay A. 
245 1 0 |a Using SQLite /  |c Jay A. Kreibich. 
250 |a 1st ed. 
260 |a Sebastopol, Calif. :  |b O'Reilly,  |c 2010. 
300 |a 1 online resource (xx, 503 pages) :  |b illustrations 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
347 |a text file  |2 rda 
588 0 |a Print version record. 
520 |a "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. 
505 0 |a 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. 
505 8 |a 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. 
505 8 |a 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. 
505 8 |a 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. 
505 8 |a 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. 
590 |a O'Reilly  |b O'Reilly Online Learning: Academic/Public Library Edition 
650 0 |a SQL (Computer program language) 
650 0 |a Relational databases. 
650 0 |a Database management. 
650 0 |a Application software. 
650 6 |a SQL (Langage de programmation) 
650 6 |a Bases de données relationnelles. 
650 6 |a Bases de données  |x Gestion. 
650 6 |a Logiciels d'application. 
650 7 |a COMPUTERS  |x Programming Languages  |x SQL.  |2 bisacsh 
650 7 |a Application software  |2 fast 
650 7 |a Database management  |2 fast 
650 7 |a Relational databases  |2 fast 
650 7 |a SQL (Computer program language)  |2 fast 
655 7 |a Software  |2 fast 
776 0 8 |i Print version:  |a Kreibich, Jay A.  |t Using SQLite.  |b 1st ed.  |d Sebastopol, CA : O'Reilly, ©2010  |z 9780596521189  |w (OCoLC)535495179 
856 4 0 |u https://learning.oreilly.com/library/view/~/9781449394592/?ar  |z Texto completo (Requiere registro previo con correo institucional) 
938 |a Askews and Holts Library Services  |b ASKH  |n AH26833059 
938 |a Askews and Holts Library Services  |b ASKH  |n AH26833031 
938 |a ProQuest Ebook Central  |b EBLB  |n EBL580130 
938 |a ebrary  |b EBRY  |n ebr10761340 
938 |a EBSCOhost  |b EBSC  |n 415510 
938 |a YBP Library Services  |b YANK  |n 7489366 
938 |a YBP Library Services  |b YANK  |n 7408210 
994 |a 92  |b IZTAP