HTTP/2 302 server: nginx date: Thu, 07 Aug 2025 18:46:17 GMT content-type: text/plain; charset=utf-8 content-length: 0 x-archive-redirect-reason: found capture at 20120610095028 location: https://web.archive.org/web/20120610095028/https://answers.oreilly.com/rss/tags/sqlite/ server-timing: captures_list;dur=0.686386, exclusion.robots;dur=0.019209, exclusion.robots.policy;dur=0.007378, esindex;dur=0.011285, cdx.remote;dur=21.373786, LoadShardBlock;dur=239.373214, PetaboxLoader3.datanode;dur=56.449734, PetaboxLoader3.resolve;dur=146.970210 x-app-server: wwwb-app239 x-ts: 302 x-tr: 322 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=1 set-cookie: wb-p-SERVER=wwwb-app239; 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, 07 Aug 2025 18:46:20 GMT content-type: text/xml; charset=UTF-8 x-archive-orig-date: Sun, 10 Jun 2012 09:50:28 GMT x-archive-orig-server: Apache x-archive-orig-expires: Sun 10 Jun 2012 09:50:30 AM GMT GMT x-archive-orig-cache-control: must-revalidate, post-check=0, pre-check=0 x-archive-orig-pragma: public x-archive-orig-set-cookie: answers_session_id=edb9c28ff07be8c30078351a6412a4ab; path=/; domain=.oreilly.com; httponly x-archive-orig-set-cookie: answers_session_id=edb9c28ff07be8c30078351a6412a4ab; path=/; domain=.oreilly.com; httponly x-archive-orig-connection: close cache-control: max-age=1800 x-archive-guessed-content-type: text/xml x-archive-guessed-charset: utf-8 memento-datetime: Sun, 10 Jun 2012 09:50:28 GMT link: ; rel="original", ; rel="timemap"; type="application/link-format", ; rel="timegate", ; rel="first memento"; datetime="Sun, 10 Jun 2012 09:50:28 GMT", ; rel="memento"; datetime="Sun, 10 Jun 2012 09:50:28 GMT", ; rel="next memento"; datetime="Fri, 10 May 2013 16:28:20 GMT", ; rel="last memento"; datetime="Wed, 11 Dec 2013 03:03:36 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: WIDE-20120610080245-crawl424/WIDE-20120610091254-06242.warc.gz server-timing: captures_list;dur=0.657000, exclusion.robots;dur=0.017522, exclusion.robots.policy;dur=0.006849, esindex;dur=0.009683, cdx.remote;dur=37.438581, LoadShardBlock;dur=1310.838674, PetaboxLoader3.resolve;dur=2723.102895, PetaboxLoader3.datanode;dur=228.177383, load_resource;dur=1727.960300 x-app-server: wwwb-app239 x-ts: 200 x-tr: 3121 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=() https://answers.oreilly.com/tag/sqlite Mon, 30 Apr 2012 10:35:44 +0000 60 https://answers.oreilly.com/topic/3338-sqlite-database-and-tlf-text-in-flash-cs5/ Thu, 01 Jan 1970 00:00:00 +0000 https://answers.oreilly.com/topic/3338-sqlite-database-and-tlf-text-in-flash-cs5/ https://answers.oreilly.com/topic/3121-how-to-create-a-ios-5-app-with-multiple-sqlite-databases/ SQLite is a great technology for data storage and persistence for mobile applications and web applications. Although not a database server, it offers nevertheless the possibility to group several data... Mon, 30 Jan 2012 11:47:51 +0000 https://answers.oreilly.com/topic/3121-how-to-create-a-ios-5-app-with-multiple-sqlite-databases/ https://answers.oreilly.com/topic/3012-ios-5-sdk-database-insert-update-delete-with-sqlite-and-objective-c-c-how-to/ I have written a tutorial that demonstrates the techniques and syntax to perform Insert, Update and Delete (CRUD) using SQLite on an IOS 5 device like iPad, iPhone or iPod. This tutorial offers comple... Thu, 01 Dec 2011 21:21:22 +0000 https://answers.oreilly.com/topic/3012-ios-5-sdk-database-insert-update-delete-with-sqlite-and-objective-c-c-how-to/ https://answers.oreilly.com/topic/3006-creating-an-ios-5-sqlite-database-application/ I have written a tutorial on how to create and read from a SQLite database with IOS 5 in case someone is interested or in need of this information: Tutorial on Creating an IOS 5 SQLite Database App... Mon, 28 Nov 2011 19:51:02 +0000 https://answers.oreilly.com/topic/3006-creating-an-ios-5-sqlite-database-application/ https://answers.oreilly.com/topic/2035-whats-new-in-sqlite-37/ SQLite 3.7 and Write-Ahead Logging SQLite is a full-featured relational database that is designed to be embedded directly into an application or utility. It has a relatively small runtime footprint... Wed, 08 Sep 2010 02:55:32 +0000 https://answers.oreilly.com/topic/2035-whats-new-in-sqlite-37/ https://answers.oreilly.com/topic/1959-when-to-use-sqlite-instead-of-core-data-on-the-iphone/ 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... Mon, 23 Aug 2010 04:05:22 +0000 https://answers.oreilly.com/topic/1959-when-to-use-sqlite-instead-of-core-data-on-the-iphone/ https://answers.oreilly.com/topic/1955-how-to-use-full-text-search-in-sqlite/ 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... Sat, 21 Aug 2010 19:56:14 +0000 https://answers.oreilly.com/topic/1955-how-to-use-full-text-search-in-sqlite/ https://answers.oreilly.com/topic/1942-a-primer-on-how-to-get-started-with-sqlite3/ 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... Thu, 19 Aug 2010 22:52:51 +0000 https://answers.oreilly.com/topic/1942-a-primer-on-how-to-get-started-with-sqlite3/ https://answers.oreilly.com/topic/1932-what-is-beyond-sqlites-scope/ 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... Tue, 17 Aug 2010 19:24:35 +0000 https://answers.oreilly.com/topic/1932-what-is-beyond-sqlites-scope/ https://answers.oreilly.com/topic/1931-android-database-tutorial/ Tue, 17 Aug 2010 18:45:35 +0000 https://answers.oreilly.com/topic/1931-android-database-tutorial/