Using SQLite (Paperback)

Jay A. Kreibich

  • 出版商: O'Reilly
  • 出版日期: 2010-09-21
  • 定價: $1,800
  • 售價: 9.5$1,710
  • 貴賓價: 8.8$1,584
  • 語言: 英文
  • 頁數: 530
  • 裝訂: Paperback
  • ISBN: 0596521189
  • ISBN-13: 9780596521189
  • 相關分類: SQL
  • 立即出貨 (庫存=1)



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


應用程式開發者請注意:資料庫不再僅限於資訊系統團隊使用。您可以建立支援資料庫的桌面應用程式、網頁、嵌入式系統或作業系統,而無需連結重型的客戶端-伺服器資料庫,如 Oracle 和 MySQL。本書將向您展示如何使用 SQLite,一個小型且輕量級的關聯式資料庫引擎,您可以直接將其建置到您的應用程式中。

透過 SQLite,您將學習如何開發一個在大小和複雜度上都易於管理的資料庫支援應用程式。本書將引導您完成每一個步驟。您將快速了解資料建模,熟悉 SQLite 的 SQL 資料庫語言方言,以及更多相關知識。

- 學習如何在不需要配置的單一檔案中維護本地化儲存
- 建立自己的 SQLite 函式庫或在應用程式中使用預編譯的發行版
- 入門 SQL,並學習如何使用多種語言函數和擴充功能
- 使用腳本語言或基於 C 的語言(如 C# 或 Objective-C)與 SQLite 進行互動
- 瞭解資料庫設計的基礎,並學習如何將您已經掌握的知識轉移到 SQLite 上
- 充分利用虛擬表格和模組功能

"清晰解釋複雜的 SQL 概念。"
- SQLite 創始人 D. Richard Hipp