Op werkdagen voor 23:00 besteld, morgen in huis Gratis verzending vanaf €20

Using SQLite

Small. Fast. Reliable. Choose Any Three

Paperback Engels 2010 9780596521189
Verwachte levertijd ongeveer 5 werkdagen

Samenvatting

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

Specificaties

ISBN13:9780596521189
Taal:Engels
Bindwijze:paperback
Aantal pagina's:503
Uitgever:O'Reilly
Druk:1
Verschijningsdatum:3-8-2022
Hoofdrubriek:IT-management / ICT

Lezersrecensies

Wees de eerste die een lezersrecensie schrijft!

Geef uw waardering

Zeer goed Goed Voldoende Matig Slecht

Over Jay Kreibich

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.

Andere boeken door Jay Kreibich

Inhoudsopgave

Preface

1. What Is SQLite?
-Self-Contained, No Server Required
-Single File Database
-Zero Configuration
-Embedded Device Support
-Unique Features
-Compatible License
-Highly Reliable

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

3. Building and Installing SQLite
-SQLite Products
-Precompiled Distributions
-Documentation Distribution
-Source Distributions
-Building
-Build and Installation Options
-An sqlite3 Primer
-Summary

4. The SQL Language
-Learning SQL
-Brief Background
-General Syntax
-SQL Data Languages
-Data Definition Language
-Data Manipulation Language
-Transaction Control Language
-System Catalogs
-Wrap-up

5. The SELECT Command
-SQL Tables
-The SELECT Pipeline
-Advanced Techniques
-SELECT Examples
-What's Next

6. Database Design
-Tables and Keys
-Common Structures and Relationships
-Normal Form
-Indexes
-Transferring Design Experience
-Closing

7. C Programming Interface
-API Overview
-Library Initialization
-Database Connections
-Prepared Statements
-Bound Parameters
-Convenience Functions
-Result Codes and Error Codes
-Utility Functions
-Summary

8. Additional Features and APIs
-Date and Time Features
-ICU Internationalization Extension
-Full-Text Search Module
-R*Trees and Spatial Indexing Module
-Scripting Languages and Other Interfaces
-Mobile and Embedded Development
-Additional Extensions

9. SQL Functions and Extensions
-Scalar Functions
-Aggregate Functions
-Collation Functions
-SQLite Extensions

10. Virtual Tables and Modules
-Introduction to Modules
-Module API
-Simple Example: dblist Module
-Advanced Example: weblog Module
-Best Index and Filter
-Wrap-Up

Appendix A: SQLite Build Options
Appendix B: sqlite3 Command Reference
Appendix C: SQLite SQL Command Reference
Appendix D: SQLite SQL Expression Reference
Appendix E: SQLite SQL Function Reference
Appendix F: SQLite SQL PRAGMA Reference
Appendix G: SQLite C API Reference

Index

Managementboek Top 100

Rubrieken

Populaire producten

    Personen

      Trefwoorden

        Using SQLite