Muutke küpsiste eelistusi

E-raamat: Using SQLite: Small. Fast. Reliable. Choose Any Three.

3.83/5 (131 hinnangut Goodreads-ist)
  • Formaat: 530 pages
  • Ilmumisaeg: 10-Aug-2010
  • Kirjastus: O'Reilly Media
  • Keel: eng
  • ISBN-13: 9781449399467
Teised raamatud teemal:
  • Formaat - PDF+DRM
  • Hind: 26,90 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
Using SQLite: Small. Fast. Reliable. Choose Any Three.Suurem pilt
  • Formaat: 530 pages
  • Ilmumisaeg: 10-Aug-2010
  • Kirjastus: O'Reilly Media
  • Keel: eng
  • ISBN-13: 9781449399467
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

Explains how to build database-backed applications for the Web, desktop, embedded systems, and operating systems using SQLite.

Application developers, take note: databases aren't just for the IS group any more. You can build database-hacked 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 use SQLite, a small and lightweight relational database engine that you can build directly into your application.

With SQLite, you can develop a database-hacked application that remains manageable both in size and complexity. This book guides you every step of the way. You'll get a crash course in data modeling, become familiar with SQLite's dialect of the SQL database language, and much more.

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

Application developers, take note: databases aren't just for the IS group any more. Whether you're developing applications for the desktop, the Web, embedded systems, or operating systems, the SQLite database provides an alternative to heavy-duty client-server databases such as Oracle and MySQL. With this book, you'll get complete guidance for using this small and lightweight database effectively. You'll learn how to make SQLite an integral part of your application to help contain the size and complexity of your project. And you'll discover how much simpler it is to build database-backed applications with SQLite than the database tools you've been using.

  • Get a crash course in data modeling
  • Learn how to use SQLite with scripting languages such as Perl, Python, and Ruby
  • Become familiar with the subset of SQL supported by SQLite
Preface xv
1 What Is SQLite? 1(8)
Self-Contained, No Server Required
2(2)
Single File Database
4(1)
Zero Configuration
4(1)
Embedded Device Support
5(1)
Unique Features
5(1)
Compatible License
6(1)
Highly Reliable
6(3)
2 Uses of SQLite 9(8)
Data base Junior
9(1)
Application Files
10(1)
Application Cache
11(1)
Archives and Data Stores
11(1)
Client/Server Stand-in
11(1)
Teaching Tool
12(1)
Generic SQL Engine
13(1)
Not the Best Choice
13(2)
Big Name Users
15(2)
3 Building and Installing SQLite 17(10)
SQLite Products
17(1)
Precompiled Distributions
18(1)
Documentation Distribution
18(1)
Source Distributions
19(2)
The Amalgamation
19(1)
Source Files
19(1)
Source Downloads
20(1)
Building
21(2)
Configure
21(1)
Manually
22(1)
Build Customization
23(1)
Build and Installation Options
23(1)
An sqlite3 Primer
24(2)
Summary
26(1)
4 The SQL Language 27(34)
Learning SQL
27(1)
Brief Background
28(2)
Declarative
28(1)
Portability
29(1)
General Syntax
30(4)
Basic Syntax
30(1)
Three-Valued Logic
31(2)
Simple Operators
33(1)
SQL Data Languages
34(1)
Data Definition Language
34(11)
Tables
35(8)
Views
43(1)
Indexes
44(1)
Data Manipulation Language
45(6)
Row Modification Commands
46(3)
The Query Command
49(2)
Transaction Control Language
51(6)
ACID Transactions
51(2)
SQL Transactions
53(2)
Save-Points
55(2)
System Catalogs
57(1)
Wrap-up
58(3)
5 The SELECT Command 61(26)
SQL Tables
61(1)
The SELECT Pipeline
62(14)
FROM Clause
63(5)
WHERE Clause
68(1)
GROUP BY Clause
69(1)
SELECT Header
70(3)
HAVING Clause
73(1)
DISTINCT Keyword
74(1)
ORDER BY Clause
74(1)
LIMIT and OFFSET Clauses
75(1)
Advanced Techniques
76(3)
Subqueries
76(1)
Compound SELECT Statements
77(1)
Alternate JOIN Notation
78(1)
SELECT Examples
79(6)
Simple SELECTs
80(1)
Simple JOINs
80(1)
JOIN...ON
81(1)
JOIN...USING, NATURAL JOIN
82(1)
OUTER JOIN
82(1)
Compound JOIN
82(1)
Self JOIN
83(1)
WHERE Examples
83(1)
GROUP BY Examples
84(1)
ORDER BY Examples
85(1)
What's Next
85(2)
6 Database Design 87(28)
Tables and Keys
87(6)
Keys Define the Table
87(2)
Foreign Keys
89(1)
Foreign Key Constraints
90(1)
Generic ID Keys
91(1)
Keep It Specific
92(1)
Common Structures and Relationships
93(9)
One-to-One Relationships
93(2)
One-to-Many Relationships
95(2)
Many-to-Many Relationships
97(2)
Hierarehies and Trees
99(3)
Normal Form
102(5)
Normalization
103(1)
Denormalization
103(1)
The First Normal Form
104(1)
The Second Normal Form
104(1)
The Third Normal Form
105(1)
Higher Normal Forms
106(1)
Indexes
107(5)
How They Work
107(1)
Must Be Diverse
108(1)
INTEGER PRIMARY KEYs
109(1)
Order Matters
109(1)
One at a Time
110(1)
Index Summary
111(1)
Transferring Design Experience
112(2)
Tables Are Types
112(1)
Keys Are Backwards Pointers
113(1)
Do One Thing
113(1)
Closing
114(1)
7 C Programming Interface 115(44)
API Overview
115(4)
Structure
116(1)
Strings and Unicode
117(1)
Error Codes
118(1)
Structures and Allocations
118(1)
More Info
119(1)
Library Initialization
119(1)
Database Connections
120(3)
Opening
120(1)
Special Cases
121(1)
Closing
122(1)
Example
122(1)
Prepared Statements
123(10)
Statement Life Cycle
123(1)
Prepare
124(2)
Step
126(1)
Result Columns
127(3)
Reset and Finalize
130(1)
Statement Transitions
131(1)
Examples
132(1)
Bound Parameters
133(9)
Parameter Tokens
133(2)
Binding Values
135(3)
Security and Performance
138(2)
Example
140(1)
Potential Pitfalls
141(1)
Convenience Functions
142(4)
Result Codes and Error Codes
146(10)
Standard Codes
146(2)
Extended Codes
148(1)
Error Functions
148(1)
Prepare v2
149(1)
Transactions and Errors
150(1)
Database Locking
151(5)
Utility Functions
156(2)
Version Management
156(1)
Memory Management
157(1)
Summary
158(1)
8 Additional Features and APIs 159(22)
Date and Time Features
159(8)
Application Requirements
160(1)
Representations
160(2)
Time and Date Functions
162(5)
ICU Internationalization Extension
167(2)
Full-"Text Search Module
169(2)
Creating and Populating yrs Tables
169(1)
Searching FTS Tables
170(1)
More Details
171(1)
R*Trees and Spatial Indexing Module
171(1)
Scripting Languages and Other Interfaces
172(4)
Perl
172(1)
PHP
173(1)
Python
173(1)
Java
174(1)
Tel
174(1)
ODBC
175(1)
.NET
175(1)
C++
175(1)
Other Languages
176(1)
Mobile and Embedded Development
176(4)
Memory
176(1)
Storage
177(1)
Other Resources
178(1)
iPhone Support
178(1)
Other Environments
179(1)
Additional Extensions
180(1)
9 SQL Functions and Extensions 181(36)
Scalar Functions
182(12)
Registering Functions
182(2)
Extracting Parameters
184(2)
Returning Results and Errors
186(3)
Example
189(5)
Aggregate Functions
194(6)
Defining Aggregates
194(1)
Aggregate Context
195(2)
Example
197(3)
Collation Functions
200(4)
Registering a Collation
201(1)
Collation Example
202(2)
SQLite Extensions
204(13)
Extension Architecture
205(1)
Extension Design
206(1)
Example Extension: sql_trig
207(2)
Building and Integrating Static Extensions
209(2)
Using Loadable Extensions
211(1)
Building Loadable Extensions
212(1)
Loadable Extension Security
213(1)
Loading Loadable Extensions
213(2)
Multiple Entry Points
215(1)
Chapter Summary
215(2)
10 Virtual Tables and Modules 217(52)
Introduction to Modules
218(2)
Internal Modules
218(1)
External Modules
218(1)
Example Modules
219(1)
SQL for Anything
219(1)
Module API
220(4)
Simple Example: dblist Module
224(22)
Create and Connect
224(5)
Disconnect and Destroy
229(1)
Query Optimization
230(1)
Custom Functions
231(1)
Table Rename
232(1)
Opening and Closing Table Cursors
233(2)
Filtering Rows
235(2)
Extracting and Returning Data
237(2)
Virtual Table Modifications
239(1)
Cursor Sequence
240(1)
Transaction Control
241(2)
Register the Module
243(2)
Example Usage
245(1)
Advanced Example: weblog Module
246(16)
Create and Connect
248(1)
Disconnect and Destroy
249(1)
Other Table Functions
250(1)
Open and Close
250(2)
Filter
252(2)
Rows and Columns
254(5)
Register the Module
259(1)
Example Usage
259(3)
Best Index and Filter
262(6)
Purpose and Need
262(1)
xBestIndex()
263(3)
xFilter()
266(1)
Typical Usage
267(1)
Wrap-Up
268(1)
A SQLite Build Options 269(18)
B sqlite3 Command Reference 287(12)
C SQLite SQL Command Reference 299(42)
D SQLite SQL Expression Reference 341(20)
E SQLite SQL Function Reference 361(20)
F SQLite SQL PRAGMA Reference 381(28)
G SQLite C API Reference 409(82)
Index 491
Jay Kreibich is a professional software engineer who has always been interested in how people process and understand information. He is current working for Volition, Inc., a software studio that specializes in open-world video games. He lives on a small farm in central Illinois with his wife and two sons, where he enjoys reading, photography, and tinkering.
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97814493994672e.html
Märksõnad: