CARVIEW

MOTORHOMES

Select Language

HTTP/2 302 server: nginx date: Thu, 31 Jul 2025 04:04:40 GMT content-type: text/plain; charset=utf-8 content-length: 0 x-archive-redirect-reason: found capture at 20100830151734 location: https://web.archive.org/web/20100830151734/https://answers.oreilly.com/tag/SQLite server-timing: captures_list;dur=0.494011, exclusion.robots;dur=0.019178, exclusion.robots.policy;dur=0.008538, esindex;dur=0.011571, cdx.remote;dur=21.993916, LoadShardBlock;dur=126.699135, PetaboxLoader3.datanode;dur=111.090586 x-app-server: wwwb-app216 x-ts: 302 x-tr: 179 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 set-cookie: SERVER=wwwb-app216; path=/ x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() HTTP/2 200 server: nginx date: Thu, 31 Jul 2025 04:04:41 GMT content-type: text/html;charset=UTF-8 x-archive-orig-date: Mon, 30 Aug 2010 15:17:37 GMT x-archive-orig-server: Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 PHP/5.2.8 x-archive-orig-x-powered-by: PHP/5.2.8 x-archive-orig-set-cookie: answers_session_id=deleted; expires=Sun, 30-Aug-2009 15:17:36 GMT; path=/; domain=.oreilly.com; httponly x-archive-orig-set-cookie: answers_session_id=deleted; expires=Sun, 30-Aug-2009 15:17:36 GMT; path=/; domain=.oreilly.com; httponly x-archive-orig-cache-control: ,no-cachemust-revalidate, max-age=0 x-archive-orig-expires: 0 x-archive-orig-pragma: no-cache x-archive-orig-connection: close x-archive-guessed-content-type: text/html x-archive-guessed-charset: utf-8 memento-datetime: Mon, 30 Aug 2010 15:17:34 GMT link: ; rel="original", ; rel="timemap"; type="application/link-format", ; rel="timegate", ; rel="first memento"; datetime="Fri, 13 Nov 2009 19:15:28 GMT", ; rel="prev memento"; datetime="Sun, 22 Aug 2010 09:22:06 GMT", ; rel="memento"; datetime="Mon, 30 Aug 2010 15:17:34 GMT", ; rel="next memento"; datetime="Tue, 14 Sep 2010 11:37:19 GMT", ; rel="last memento"; datetime="Thu, 28 Aug 2014 02:45:17 GMT" content-security-policy: default-src 'self' 'unsafe-eval' 'unsafe-inline' data: blob: archive.org web.archive.org web-static.archive.org wayback-api.archive.org athena.archive.org analytics.archive.org pragma.archivelab.org wwwb-events.archive.org x-archive-src: 52_17_20100830144650_crawl103-c/52_17_20100830151645_crawl100.arc.gz server-timing: captures_list;dur=0.772793, exclusion.robots;dur=0.026958, exclusion.robots.policy;dur=0.012551, esindex;dur=0.017103, cdx.remote;dur=32.050656, LoadShardBlock;dur=155.084658, PetaboxLoader3.datanode;dur=127.841461, PetaboxLoader3.resolve;dur=150.800701, load_resource;dur=145.222211 x-app-server: wwwb-app216 x-ts: 200 x-tr: 420 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() content-encoding: gzip SQLite Questions and Answers - O'Reilly Answers

Jump to content

O'Reilly Answers

Clever Hacks. Creative Ideas. Innovative Solutions.

Share your knowledge

Welcome

Help

O'Reilly Answers is a community site for sharing knowledge, asking questions, and providing answers that brings together our customers, authors, editors, conference speakers, and Foo (Friends of O'Reilly). More »

Send us feedback
Feed icon

O'Reilly Answers Feed
Twitter icon

@oreillyanswers

Topics: SQLite

SQLite Feed SQLite Open Questions Feed SQLite Email Open Questions via Email

When to Use SQLite instead of Core Data on the iPhone

By chco : 22 August 2010 - 08:05 PM
This excerpt from Using SQLite explains the differences between Core Data and SQLite and will help you decide which to use when developing on the iPhone.When the iPhone and iPod touch were first relea...
Tags:
0Votes

0Comments
How to use Full-Text Search in SQLite

By chco : 21 August 2010 - 11:56 AM
The following is an excerpt from Using SQLite. Below the author gives the best ways to utilize the Full-Text Search Module with SQLite.SQLite includes a Full-Text Search (FTS) engine. The current vers...
Tags:
0Votes

0Comments
A Primer on How to Get Started With SQLite3

By chco : 19 August 2010 - 02:52 PM
The following excerpt from Using SQLite offers an initial approach to working with sqlite3 on a new install.Once you have some form of SQLite installed, the first step is normally to run sqlite3 and p...
Tags:
1Vote

0Comments
What is beyond SQLite's scope?

By chco : 17 August 2010 - 11:24 AM
SQLite, as versatile as it is, is not always the best choice. The following excerpt from Using SQLite takes a look at the situations where it might be best to go with another choice.Although SQLite ha...
Tags:
0Votes

0Comments
Android Database Tutorial

By javahead76 : 17 August 2010 - 10:45 AM
I've posted a new Android Database Tutorial at: https://www.anotheran...abase-tutorial/ Here's the low down: This tutorial will cover the basics of using the SQLite database tools in Android...
Tags:
1Vote

0Comments
What is SQLite?

By chco : 15 August 2010 - 02:50 PM
The following excerpt from Using SQLite gives a brief overview of SQLite's features.In the simplest terms, SQLite is a public-domain software package that provides a relational database management...
Tags:
0Votes

0Comments
Use iPhone Core Data Templates

By tobyjoe : 06 November 2009 - 07:03 PM
The iPhone 3.0 update to the iPhone OS and iPhone SDK included a great new feature, ported from Mac OS X, called Core Data. Core Data is used to store objects in a local database that can be...
Tags:
0Votes

0Comments