SQLite应用指南：轻量级数据库开发

using

sqlite

4星 · 超过85%的资源需积分: 10 160 浏览量更新于2023-06-20 收藏 9.59MB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

资源详情

资源推荐

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

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

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

剩余527页未读，继续阅读

-逗你玩儿-

粉丝: 76
资源: 8

会员权益专享

SQLite应用指南：轻量级数据库开发

《Using.SQLite》

Using+SQLite.pdf

SQLite权威指南 第二版 pdf

julia使用sqlite的代码

how to use the statement you provided in sqlite database

sqlite3 c# vs2017

kotlin sqlite in

unity sqlite

sqlite的python教程

基于SQLitede 的英文文献有哪些

Andtoid使用Sqlite创建数据库的示例代码

sqlites3 excute

CRUD python demo

centos 更新sqlite3

使用dapper操作sqlite数据库

C#查看SQLite版本

c# sqlite

c# sqlite 数据源

C++调用sqlite查询

C# winform 读取sqlite

会员权益专享

最新资源

SQLite权威指南第二版 pdf