Jay A. Kreibich：SQLite：小巧、快速、可靠的选择

需积分: 10 4 浏览量更新于2024-07-19 收藏 6.11MB PDF 举报

《使用SQLite：小巧、快速、可靠，任选其三》是由Jay A. Kreibich撰写的一本专业书籍，于2010年由美国加利福尼亚州的O'Reilly Media出版社出版。该书针对SQLite数据库管理系统进行了深入讲解，强调了其在轻量级应用中的优势，特别适合那些寻求高效、易用和稳定解决方案的开发者。 SQLite是一款嵌入式关系型数据库管理系统，它的核心特点是轻量级和零配置，可以在没有服务器的情况下运行，非常适合移动设备和小型项目。书中可能详细介绍了SQLite如何实现其高效的数据存储和查询，包括其SQL语法、事务处理、数据完整性以及与其他数据库系统如MySQL或PostgreSQL的比较。此外，作者可能会探讨如何利用SQLite在实时应用、游戏开发、移动应用开发和数据分析等领域中的实际应用案例。由于本书是"Nutshell Handbook"系列的一部分，它可能采用了一种简洁明快的写作风格，旨在让读者迅速掌握关键概念和技术。书中可能包含了大量的代码示例和实战指南，帮助读者迅速上手并理解SQLite的最佳实践。版权方面，所有权利归Jay A. Kreibich所有，未经许可不得复制或传播。印刷版本是在美国出版，电子版也在O'Reilly官方网站和Safari Online书店提供。如果你是教育机构或企业用户，可以联系O'Reilly的销售部门获取更多信息。编辑Mike Loukides、生产编辑Kristen Borg、校对员Kiel Van Horn以及索引者Lucie Haskins共同确保了书籍的质量。封面设计由Karen Montgomery负责，内部设计则是David Futato，插图则由Robert Romano操刀。此版本为2010年8月首次发行的第一版。总结来说，《Using SQLite》是一本实用的教程，适合那些希望深入了解和利用SQLite数据库技术的读者，无论是为了个人学习还是项目开发，都能从中受益匪浅。对于数据库管理和轻量级数据库设计的专业人士，这本书无疑是一个宝贵的参考资料。

www.it-ebooks.info

Preface

This book provides an introduction to the SQLite database product. SQLite is a zero-

configuration, standalone, relational database engine that is designed to be embedded

directly into an application. Database instances are self-contained within a single file,

allowing easy transport and simple setup.

Using SQLite is primarily written for experienced software developers that have never

had a particular need to learn about relational databases. For one reason or another,

you now find yourself with a large data management task, and are hoping a product

like SQLite may provide the answer. To help you out, the various chapters cover the

SQL language, the SQLite C programming API, and the basics of relational database

design, giving you everything you need to successfully integrate SQLite into your ap-

plications and development work.

The book is divided into two major sections. The first part is a traditional set of chapters

that are primarily designed to be read in order. The first two chapters provide an in-

depth look at exactly what SQLite provides and how it can be used. The third chapter

covers downloading and building the library. Chapters Four and Five provide an in-

troduction to the SQL language, while Chapter Six covers database design concepts.

Chapter Seven covers the basics of the C API. Chapter Eight builds on that to cover

more advanced topics, such as storing times and dates, using SQLite from scripting

languages, and utilizing some of the more advanced extensions. Chapters Nine and

Ten cover writing your own custom SQL functions, extensions, and modules.

To complete the picture, the ten chapters are followed by several reference appendixes.

These references cover all of the SQL commands, expressions, and built-in functions

supported by SQLite, as well as documentation for the complete SQLite API.

SQLite Versions

The first edition of this book coves SQLite version 3.6.23.1. As this goes to press, work

on SQLite version 3.7 is being finalized. SQLite 3.7 introduces a new transaction journal

mode known as Write Ahead Logging, or WAL. In some environments, WAL can pro-

vide better concurrent transaction performance than the current rollback journal. This

www.it-ebooks.info

performance comes at a cost, however. WAL has more restrictive operational require-

ments and requires more advanced support from the operating system.

Once WAL has been fully tested and released, look for an article on the O’Reilly website

that covers this new feature and how to get the most out of it.

Email Lists

The SQLite project maintains three mailing lists. If you’re trying to learn more about

SQLite, or have any questions that are not addressed in this book or in the project

documentation, these are often a good place to start.

sqlite-announce@sqlite.org

This list is limited to announcements of new releases, critical bug alerts, and other

significant events in the SQLite community. Traffic is extremely low, and most

messages are posted by the SQLite development team.

sqlite-users@sqlite.org

This is the main support list for SQLite. It covers a broad range of topics, including

SQL questions, programming questions, and questions about how the library

works. This list is moderately busy.

sqlite-dev@sqlite.org

This list is for people working on the internal code of the SQLite library itself. If

you have questions about how to use the published SQLite API, those questions

belong on the sqlite-users list. Traffic on this list is fairly low.

You can find instructions on how to join these mailing lists on the SQLite website. Visit

http://www.sqlite.org/support.html for more details.

The sqlite-users@sqlite.org email list can be quite helpful, but it is a moderately busy

list. If you’re only a casual user and don’t wish to receive that much email, you can also

access and search list messages through a web archive. Links to several different

archives are available on the SQLite support page.

Example Code Download

The code examples found in this book are available for download from the O’Reilly

website. You can find a link to the examples on the book’s catalog page at http://oreilly

.com/catalog/9780596521196/. The files include both the SQL examples and the C

examples found in later chapters.

xvi | Preface

www.it-ebooks.info

How We Got Here

Taking a book from an idea to a finished product involves a great many people. Al-

though my name is on the cover, this could not have been possible without all of their

help.

First, I would like to acknowledge the friendship and support of my primary editor,

Mike Loukides. Thanks to some mutual friends, I first started doing technical reviews

for Mike over eight years ago. Through the years, Mike gently encouraged me to take

on my own project.

The first step on that path came nearly three years ago. I had downloaded a set of

database exports from the Wikipedia project and was trying to devise a minimal data-

base configuration that would (hopefully) cram nearly all the current data onto a small

flash storage card. The end goal was to provide a local copy of the Wikipedia articles

on an ebook reader I had. SQLite was a natural choice. At some point, frustrated with

trying to understand the correct call sequence, I threw my hands up and exclaimed,

“Someone should write a book about this!”—Ding!—The proverbial light bulb went

off, and many, many (many…) late nights later, here we are.

Behind Mike stands the whole staff of O’Reilly Media. Everyone I interacted with did

their best to help me out, calm me down, and fix my problems—sometimes all at once.

The production staff understands how to make life easy for the author, so that we can

focus on writing and leave the details to someone else.

I would like to thank D. Richard Hipp, the creator and lead maintainer of SQLite. In

addition to coordinating the continued development of SQLite and providing us all

with a high-quality software product, he was also gracious enough to answer numerous

questions, as well as review a final draft of the manuscript. Some tricky spots went

through several revisions, and he was always quick to review things and get back to me

with additional comments.

A technical review was also done by Jon W. Marks. Jon is an old personal and profes-

sional friend with enterprise-class database experience. He has had the opportunity to

mentor several experienced developers as they made their first journey into the rela-

tional database world. Jon provided very insightful feedback, and was able to pinpoint

areas that are often difficult for beginners to grasp.

My final two technical reviewers were Jordan Hawker and Erin Moy. Although they

are knowledgeable developers, they were relatively new to relational databases. As they

went through the learning process, they kept me honest when I started to make too

many assumptions, and kept me on track when I started to skip ahead too quickly.

Preface | xvii

www.it-ebooks.info

剩余527页未读，继续阅读

grey911

粉丝: 1
资源: 4

Jay A. Kreibich：SQLite：小巧、快速、可靠的选择

Jaya-Optimizer-master_Jaya算法_jayaalgorithm_jaya_jaya优化算法_多目标jaya

Multi-objective Jaya Algorithm (MOJaya)：MOJaya 基于SPEA2（改进强度帕累托进化算法）。-matlab开发

mainAlgorithm.java

SQLite学习指南：Jay A. Kreibich著

Using SQLite

awesome-sqlite:很棒的sqlite工具，脚本，书籍等的集合

SQLite数据库指南：Using SQLite

SQLite使用指南

SQLite数据库应用指南

SQLite用户专业指南

最新资源