Używamy cookies, aby ułatwić korzystanie z Portalu. Możesz określić warunki przechowywania, dostępu do plików cookies w Twojej przeglądarce. Dowiedz się więcej.
strona główna Strona główna | Nowości | Promocje | Zapowiedzi Twoje konto | Zarejestruj | Schowek | Kontakt | Pomoc
mapa działów
Szukaj: szukanie zaawansowane
Książki \ Servery \ SQL Server

Using SQLite Język: 2


Cena Brutto: 221.24

Cena netto: 210.70

Wersja: Drukowana
Autor Jay A. Kreibich
Liczba_stron 528
Wydawnictwo OReilly Media
Data_Wydania 2010-08-10
Poziom All Levels

Informacje podstawowe:

  • Wydawnictwo: O'Reilly Media
  • Data wydania: 10 sierpnia 2010
  • Liczba stron: 528
  • Autor/autorzy:
    • Jay A. Kreibich


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 use SQLite, a small and lightweight relational database engine that you can build directly into your application.

With SQLite, you'll discover how to develop a database-backed application that remains manageable 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

"Complex SQL concepts explained clearly."

-D. Richard Hipp, creator of SQLite

O autorze/autorach:

Jay A. Kreibich

Jay Kreibich is a professional software engineer who has always beeninterested in how people process and understand information.He iscurrent working for Volition, Inc., a software studio that specializesin 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.

View Jay A. Kreibich's full profile page.

Zawartość (spis treści):

  1. Chapter 1 What Is SQLite?

    1. Self-Contained, No Server Required
    2. Single File Database
    3. Zero Configuration
    4. Embedded Device Support
    5. Unique Features
    6. Compatible License
    7. Highly Reliable
  2. Chapter 2 Uses of SQLite

    1. Database Junior
    2. Application Files
    3. Application Cache
    4. Archives and Data Stores
    5. Client/Server Stand-in
    6. Teaching Tool
    7. Generic SQL Engine
    8. Not the Best Choice
    9. Big Name Users
  3. Chapter 3 Building and Installing SQLite

    1. SQLite Products
    2. Precompiled Distributions
    3. Documentation Distribution
    4. Source Distributions
    5. Building
    6. Build and Installation Options
    7. An sqlite3 Primer
    8. Summary
  4. Chapter 4 The SQL Language

    1. Learning SQL
    2. Brief Background
    3. General Syntax
    4. SQL Data Languages
    5. Data Definition Language
    6. Data Manipulation Language
    7. Transaction Control Language
    8. System Catalogs
    9. Wrap-up
  5. Chapter 5 The SELECT Command

    1. SQL Tables
    2. The SELECT Pipeline
    3. Advanced Techniques
    4. SELECT Examples
    5. What’s Next
  6. Chapter 6 Database Design

    1. Tables and Keys
    2. Common Structures and Relationships
    3. Normal Form
    4. Indexes
    5. Transferring Design Experience
    6. Closing
  7. Chapter 7 C Programming Interface

    1. API Overview
    2. Library Initialization
    3. Database Connections
    4. Prepared Statements
    5. Bound Parameters
    6. Convenience Functions
    7. Result Codes and Error Codes
    8. Utility Functions
    9. Summary
  8. Chapter 8 Additional Features and APIs

    1. Date and Time Features
    2. ICU Internationalization Extension
    3. Full-Text Search Module
    4. R*Trees and Spatial Indexing Module
    5. Scripting Languages and Other Interfaces
    6. Mobile and Embedded Development
    7. Additional Extensions
  9. Chapter 9 SQL Functions and Extensions

    1. Scalar Functions
    2. Aggregate Functions
    3. Collation Functions
    4. SQLite Extensions
  10. Chapter 10 Virtual Tables and Modules

    1. Introduction to Modules
    2. Module API
    3. Simple Example: dblist Module
    4. Advanced Example: weblog Module
    5. Best Index and Filter
    6. Wrap-Up
  1. AppendixSQLite Build Options

    1. Shell Directives
    2. Default Values
    3. Sizes and Limits
    4. Operation and Behavior
    5. Debug Settings
    6. Enable Extensions
    7. Limit Features
    8. Omit Core Features
  2. Appendixsqlite3 Command Reference

    1. Command-Line Options
    2. Interactive Dot-Commands
  3. AppendixSQLite SQL Command Reference

    1. SQLite SQL Commands
  4. AppendixSQLite SQL Expression Reference

    1. Literal Expressions
    2. Logic Representations
    3. Unary Expressions
    4. Binary Expressions
    5. Function Calls
    6. Column Names
    7. General Expressions
  5. AppendixSQLite SQL Function Reference

    1. Scalar Functions
    2. Aggregate Functions
  6. AppendixSQLite SQL PRAGMA Reference

    1. SQLite PRAGMAs
  7. AppendixSQLite C API Reference

    1. API Datatypes
    2. API Functions
  8. Colophon

Produkty Podobne
Tablice informatyczne. SQL. Wydanie II
SQL. Leksykon kieszonkowy. Wydanie II
Praktyczny kurs SQL. Wydanie II
SQL. Ćwiczenia praktyczne. Wydanie II
SQL. Rusz głową!
SQL Pocket Guide, Third Edition
Using SQLite
SQL Antipatterns
Oracle Database 11g PL/SQL Programming Workbook
OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047)
Więcej produktów