An alternative to Core Data for people who like having direct SQL access.
An alternative to Core Data for people who like having direct SQL access.
By Marco Arment. See the LICENSE file for license info (it’s the MIT license).
FCModel is a generic model layer on top of SQLite. It’s intended for people who want some of Core Data’s convenience, but with more control over implementation, performance, database schemas, queries, indexes, and migrations, and the ability to use raw SQL queries and SQLite features directly.
This is a beta. I use it in Overcast, a few others are using it and making contributions, and it’s stable for us so far. But the API may still change in minor but backward-incompatible ways.
NSMapTable)sqlite3 (automatic if you use CocoaPods)There isn’t much. Check out the FCModel.h header and the example project.
SQLite tables are associated with FCModel subclasses of the same name, and database columns map to @property declarations with the same name. So you could have a table like this:
CREATE TABLE Person (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL DEFAULT '',
createdTime REAL NOT NULL
);
CREATE INDEX IF NOT EXISTS name ON Person (name);
A single-column primary key is required. It can be an integer or a string. If you don’t specify a key value upon object creation, FCModel will generate a random 64-bit signed integer key that’s unique within the table. You’re responsible for creating your own table indexes.
This table’s model would look like this:
#import "FCModel.h"
@interface Person : FCModel
@property (nonatomic) int64_t id;
@property (nonatomic, copy) NSString *name;
@property (nonatomic) NSDate *createdTime;
@end
Database-mapped object properties can be:
int, double, BOOL, int64_t, etc.) or NSNumber, limited to SQLite’s precision (64-bit signed for integers).NSString, which is always stored and loaded as UTF-8NSData for BLOB columnsDatabase values may be NSString or NSNumber for INTEGER/FLOAT/TEXT columns, or NSData for BLOB columns. For columns that permit NULL, these methods may receive or return nil.
You can name your column-property ivars whatever you like. FCModel associates columns with property names, not ivar names.
Models may have properties that have no corresponding database columns. But if any columns in a model’s table don’t have corresponding properties and aren’t returned by the subclass’ ignoredFieldNames method, FCModel logs a notice to the console at launch.
In your application:didFinishLaunchingWithOptions: method, before any models are accessed, call FCModel’s openDatabaseAtPath:withSchemaBuilder:. This looks a bit crazy, but bear with me — it’s conceptually very simple.
Your schema-builder block is passed int *schemaVersion, which is an in-out argument:
*schemaVersion to reflect the new version.Here’s an example from that Person class described above:
NSString *documentsPath = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) objectAtIndex:0];
NSString *dbPath = [documentsPath stringByAppendingPathComponent:@"testDB.sqlite3"];
[FCModel openDatabaseAtPath:dbPath withSchemaBuilder:^(FMDatabase *db, int *schemaVersion) {
[db beginTransaction];
// My custom failure handling. Yours may vary.
void (^failedAt)(int statement) = ^(int statement){
int lastErrorCode = db.lastErrorCode;
NSString *lastErrorMessage = db.lastErrorMessage;
[db rollback];
NSAssert3(0, @"Migration statement %d failed, code %d: %@", statement, lastErrorCode, lastErrorMessage);
};
if (*schemaVersion < 1) {
if (! [db executeUpdate:
@"CREATE TABLE Person ("
@" id INTEGER PRIMARY KEY,"
@" name TEXT NOT NULL DEFAULT '',"
@" createdTime REAL NOT NULL"
@");"
]) failedAt(1);
if (! [db executeUpdate:@"CREATE INDEX IF NOT EXISTS name ON Person (name);"]) failedAt(2);
*schemaVersion = 1;
}
// If you wanted to change the schema in a later app version, you'd add something like this here:
/*
if (*schemaVersion < 2) {
if (! [db executeUpdate:@"ALTER TABLE Person ADD COLUMN title TEXT NOT NULL DEFAULT ''"]) failedAt(3);
*schemaVersion = 2;
}
// And so on...
if (*schemaVersion < 3) {
if (! [db executeUpdate:@"CREATE TABLE..."]) failedAt(4);
*schemaVersion = 3;
}
*/
[db commit];
}];
Once you’ve shipped a version to customers, never change its construction in your code. That way, on an initial launch of a new version, your schema-builder will see that the customer’s existing database is at e.g. schema version 2, and you can execute only what’s required to bring it up to version 3.
All changes to model instances should be done within a save: block, which will be executed synchronously on the main thread.
Creating new instances (INSERTs):
// If you want a random 64-bit signed integer primary key value for .id:
Person *bob = [Person new];
// If you want to specify your own .id value:
Person *bob = [Person instanceWithPrimaryKey:@123];
[bob save:^{
bob.name = @"Bob";
bob.createdTime = [NSDate date];
}];
SELECT and UPDATE queries should look familiar to FMDB fans: everything’s parameterized with ? placeholders and varargs query functions, and it’s passed right through to FMDB. Just as with FMDB, you need to box primitives when passing them as query params, e.g. @1 instead of 1.
// Find that specific Bob by ID
Person *bob = [Person instanceWithPrimaryKey:@123];
[bob save:^{
bob.name = @"Robert";
}];
// Or find the first person named Bob
Person *firstBob = [Person firstInstanceWhere:@"name = ? ORDER BY id LIMIT 1", @"Bob"];
// Find all Bobs
NSArray *allBobs = [Person instancesWhere:@"name = ?", @"Bob"];
You can use two shortcuts in queries:
$T: The model’s table name. (e.g. “Person”)$PK: The model’s primary-key column name. (e.g. “id”)Suppose you wanted to rename all Bobs to Robert, or delete all people named Sue, without loading them all and doing a million queries.
// Suppose these are hanging out here, being retained somewhere (in the UI, maybe)
Person *bob = [Person instanceWithPrimaryKey:@123];
Person *sue = [Person firstInstanceWhere:@"name = 'Sue'"]; // you don't HAVE to parameterize everything
// ...
[Person executeUpdateQuery:@"UPDATE $T SET name = ? WHERE name = ?", @"Robert", @"Bob"];
NSLog(@"This Bob's name is now %@.", bob.name);
// prints: This Bob's name is now Robert.
[Person executeUpdateQuery:@"DELETE FROM $T WHERE name = 'Sue'"];
NSLog(@"Sue is %@.", sue.deleted ? @"deleted" : @"around");
// prints: Sue is deleted.
FCModel is not designed to handle this automatically. You’re meant to write this from each model’s implementation as appropriate. This gives you complete control over schema, index usage, automatic fetching queries (or not), and caching.
If you want automatic relationship mappings, consider using Core Data. It’s the right tool for that job, and FCModel isn’t.
Each FCModel instance is unique in memory by its table and primary-key value. If you load Person ID 1, then some other query loads Person ID 1, they’ll be the same instance (unless the first one got deallocated in the meantime).
FCModels are safe to retain for a while, even by the UI. You can use KVO to observe changes. Just check instances’ deleted property where relevant, and watch for change notifications.
FCModels are inherently cached by primary key:
NSArray *allBobs = [Person instancesWhere:@"name = ?", @"Bob"];
// executes query: SELECT * FROM Person WHERE name = 'Bob'
Person *bob = [Person instanceWithPrimaryKey:@123];
// cache hit, no query executed
…but only among what’s retained in your app. If you want to cache an entire table, for instance, you’ll want to do something like retain its allInstances array somewhere long-lived (such as the app delegate).
FCModels can be used from any thread, but all database reads and writes are serialized onto the main thread, so you’re not likely to see any performance gains by concurrent access.
FCModel’s notifications are always posted on the main thread.
None, officially, but I’m happy to answer questions here on GitHub when time permits.
…are welcome for consideration, with the following guideline:
More than anything else, I’d like to keep FCModel small, simple, and easy to fit in your mental L2 cache.