Wednesday, March 14, 12 - CertifiedNetworks.com

bawltherapistΛογισμικό & κατασκευή λογ/κού

13 Δεκ 2013 (πριν από 3 χρόνια και 7 μήνες)

65 εμφανίσεις

SQLite
Wednesday, March 14, 12
SQLite

Open source desktop database product

Lightweight

Not particularly multi-user

iPhone/iPad Version: SQLite3

C interface - somewhat tedious
Wednesday, March 14, 12
Typical Workflow

Wrapper classes are typically used to hide details of
SQLite C API Calls

FMDB Cocoa wrapper by Gus Mueller is one example:

http://flycode.googlecode.com/svn/trunk/fmdb

Core Data is becoming more preferred API, SQLite is
the backing store
Wednesday, March 14, 12
Sqlite3 Command Line

Issue Commands in Terminal App

Create Database ucla.sqlite

$ SQLite3 ucla.sqlite

Create Table

Insert Record

Display All Records
Wednesday, March 14, 12
Other SQLite Tools

SQLite Database Browser

Open Source

Cross Platform Tool

Firefox

SQLite Plugin
Wednesday, March 14, 12
SQLite3 Examples

SQLite Command Line

SQLite Firefox add-in

Example_SQLlite

Erica Sadun: Cookbook Series
Wednesday, March 14, 12