# li6185377/LKDBHelper-SQLite-ORM

全自动的插入,查询,更新,删除， an automatic database operation  thread-safe and not afraid of recursive deadlock

Repository: https://github.com/li6185377/LKDBHelper-SQLite-ORM
Canonical: https://ross.abutalabs.com/products/lkdbhelper-sqlite-orm
Language: Objective-C
License: MIT
License Family: permissive
Last push: 2026-05-06T10:09:05+00:00

## Health v2 (maintenance only)
Score: 74/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 81, release rhythm 49, longevity 100
- inputs: {"age_days": 4888, "days_push": 119, "days_rel": 261, "gap_med": 39, "n_releases_24m": 4}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1209, forks 285 (observed 2026-08-28T04:03:59.926306+00:00)

## What it is
LKDBHelper is an automatic SQLite ORM library for iOS written in Objective-C, built on FMDB. It provides thread-safe automatic insert, query, update, and delete operations for a wide range of property types, plus database corruption recovery and performance tuning options.

## Use cases
- persist Objective-C model objects to SQLite without writing SQL
- automatically save and load models with NSArray, NSDictionary, NSDate, UIImage and other property types
- use a thread-safe SQLite ORM that avoids recursive deadlocks
- encrypt a local SQLite database with SQLCipher
- repair a corrupted SQLite database (SQLITE_CORRUPT / malformed disk image)
- tune SQLite performance with PRAGMA settings like mmap_size, cache_size, and WAL mode

## When to choose
- building an iOS app in Objective-C that needs simple automatic SQLite persistence
- you want an ORM that handles many property types (collections, images, structs) without manual mapping
- you need battle-tested stability for high-traffic production apps
- you require optional database encryption or corruption recovery tooling

## When to avoid
- developing for Android, cross-platform, or non-Apple platforms
- your project requires Swift-native or Core Data integration
- you need a reactive or async-first database layer like Realm or GRDB
- targeting iOS versions below 12 without pinning older FMDB and LKDBHelper versions

## Facets
- artifact type: library
- maturity: active
- function: orm, database, database-driver
- domain: databases, mobile-development, developer-tools
- platform: -
- tags: sqlite, objective-c, fmdb, thread-safe, sqlcipher, database-recovery, ios, mobile

## Member repositories
- li6185377/LKDBHelper-SQLite-ORM (main) score 74

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:03:59.926306+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T06:18:35.569147+00:00, confidence not recorded.
  - readme: https://github.com/li6185377/LKDBHelper-SQLite-ORM (fetched 2026-08-28T04:03:59.926306+00:00, sha 9e210f6bb132)
- Data as of 2026-08-30T08:39:29.467469+00:00.