iOS Database Persistence Layer with SQLite, your next Persistence Layer!
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Failed to load latest commit information.
CTPersistance.xcodeproj sql语句中有汉字时result=SQLITE_ERROR Jul 12, 2018
CTPersistance 189 Sep 1, 2018
CTPersistanceTests modification Aug 27, 2018
.gitignore added migration test Sep 13, 2017
CTPersistance.podspec 189 Sep 1, 2018
LICENSE 142 Sep 13, 2017
Podfile modification May 8, 2018 modification May 28, 2018 142 Sep 13, 2017

pod "CTPersistance"

CTPersistance is a sqlite wrapper which help you to handle with database.

I'm still writing this document, you can check test case for usage.

Async Operation in CTPersistance




CTPersistance provide CTPersistanceAsyncExecutor to do the async staff.


[[CTPersistanceAsyncExecutor sharedInstance] read:^{
    NSInteger count = COUNT;
    while (count --> 0) {
        TestRecord *record = (TestRecord *)[self.testTable findWithPrimaryKey:@(count) error:NULL];
        NSLog(@"%@", record.primaryKey);


[[CTPersistanceAsyncExecutor sharedInstance] write:^{
    NSInteger count = COUNT;
    while (count --> 0) {
        NSNumber *primaryKey = [self.testTable insertValue:@"casa" forKey:@"name" error:NULL];
        NSLog(@"%@", primaryKey);

see AsyncTestViewController for demo

run CTPersistance project in Simulator, and async test is the live demo for async operation.

Target-Action in CTPersistance

CTPersistance use CTMediator to handle how the database migrate, what secret key to encrypt, where to place the database file.

You should create a target, and just put it into your project, no more code and CTMediator will call your target.

the different database name should have different target, and the target should conform to protocol CTPersistanceConfigurationTarget. see here CTPersistance.h:43

the name of the target object is based on the name of your database file.for example:

say you have a database file which name is:

`aaa.sqlite`, and the target should be `Target_aaa`

`aaa_bbb.sqlite`, and the target should be `Target_aaa`

`aaa_bbb`, and the target should be `Target_aaa`

``, and the target should be `Target_aaa`

`aaa`, and the target should be `Target_aaa`

Available Actions:

  • - (NSString *)Action_filePath:(NSDictionary *)params

return the absolute file path as you want. The database file name will be send in the params.

If CTPersistance can not call this method, CTPersistance will find database in [[NSSearchPathForDirectoriesInDomains(NSLibraryDirectory, NSUserDomainMask, YES) firstObject] stringByAppendingPathComponent:databaseName] folder, if still not found, CTPersistance will create the database file in this path with the database file name.

  • - (CTPersistanceMigrator *)Action_fetchMigrator:(NSDictionary *)params

return the class name of migrator manager for database migration.

see Target_MigrationTestDatabase.m:20

  • - (NSArray *)Action_secretKey:(NSDictionary *)params

return secret key to encrypt the database file.

if you have changed the secret key, keep the old key and append new key in a array and return it.

say you encrypt the database in version 1 (it's the version about your app) by the key oldkey, and you changed this key to newkey in version 2. Some days later you changed the key to newkey2 in version3, you should return an array like this:


see Target_TestDatabase.m:13


CTPersistance's record does not have to be a specific object. Any object who conforms to CTPersistanceRecordProtocol can be handled by CTPersistance.

That means you can handle any object like UIViewUIViewController with CTPersistance as long as they conforms to CTPersistanceRecordProtocol. For example you can insert a UIView, and fetch the same data as a dictionary or even UIViewController.

Though CTPersistance does not require your object to inherit from a specific model, CTPersistance provide you CTPersistanceRecord if you do not want to implement the protocol.

CRUD Operations

Create : see here

Read : see here

Update : see here

Delete : see here

Upsert : see here

Other Operations

Database Migration : see here

Index of Columns : see here

Transaction : see here

Change Key of Encryption : see here