Book Cover

Using SQLite

by Jay A. Kreibich
15.0 minutes

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 configurationBuild your own SQLite library or use a precompiled distribution in your applicationGet a primer on SQL, and learn how to use several language functions and extensionsWork with SQLite...

Key Points

MindMap

Target Audience

本书主要面向有经验的软件开发人员,他们以前没有学习关系数据库的特殊需求。无论出于何种原因,您现在发现自己面临着一项大型数据管理任务,并希望像 SQLite 这样的产品能够提供答案。为了帮助您,各个章节涵盖了 SQL 语言、SQLite C 编程 API 和关系数据库设计的基础知识,为您提供了成功将 SQLite 集成到您的应用程序和开发工作中的一切。

Author Background

Jay A. Kreibich 是一位经验丰富的软件工程师,对人们如何处理和理解信息有着浓厚的兴趣。他目前在 Volition, Inc. 工作,这是一家专门从事开放世界视频游戏的软件工作室。他与妻子和两个儿子住在伊利诺伊州中部的一个小农场,在那里他喜欢阅读、摄影和修补。

Historical Context

SQLite 诞生于 2000 年,旨在提供一种无需独立服务器进程即可运行的数据库解决方案。它最初是为了简化软件部署,特别是在嵌入式设备和小型应用程序中。与传统的客户端-服务器数据库管理系统不同,SQLite 将整个数据库(定义、表、数据)存储在单个跨平台文件中。这种设计选择极大地简化了配置和管理,使其成为各种应用场景的理想选择。SQLite 的发展历程与互联网的普及和嵌入式技术的兴起紧密相连,满足了对轻量级、易于集成的数据存储方案日益增长的需求。

Chapter Summary

Audio

Comming Soon...