Lighter icon indicating copy to clipboard operation
Lighter copied to clipboard

Add support for JSON columns?

Open helje5 opened this issue 1 year ago • 0 comments

Not quite sure how that would look like. Presumably we'd detect the column type JSON and then allow SQLite JSON operations on it? How would it look in the associated structure? Expose it as Data, but at least in the Lighter API provide a wrapper that allows direct access?

struct Person {
  var name: String
  var privateAddress: [ UInt8 ] // in raw API?
  var businessAddress: [ UInt8 ] // in raw API?
}

struct Address: Codable {
  var street: String
  var city: String
}

We can't use Codable directly here (and Codable is really slow anyways, so not that desirable).

helje5 avatar Oct 11 '23 15:10 helje5