Common Workflow

Basic workflow is simple:

1. create sophia environment sp_env()
2. set options using sp_setint(), sp_setstring(), define sophia.path
3. define databases
4. sp_open() environment
5. do transaction processing using sp_document(), sp_set(), sp_get(), sp_delete(), sp_upsert(), sp_cursor(), sp_begin(), sp_commit(), sp_destroy()
6. on finish: sp_destroy() the environment object

void *env = sp_env();
sp_setstring(env, "sophia.path", "./storage", 0);
sp_setstring(env, "db", "test", 0);
sp_open(env);
void *db = sp_getobject(env, "db.test");
/* do transactions */
sp_destroy(env);