Has anyone been able to get this library working with SQLite.swift? about swift-tagged HOT 6 CLOSED

Thank you Stephen. For the record, one can use Tagged with GRDB 5.9.0 with the following extensions:

import GRDB
import Tagged

// Make it possible to use Tagged types as database values
// just line Int, String, Date, etc.
extension Tagged: SQLExpressible where RawValue: SQLExpressible { }
extension Tagged: StatementBinding where RawValue: StatementBinding { }
extension Tagged: DatabaseValueConvertible where RawValue: DatabaseValueConvertible { }

from swift-tagged.

Oh, and here is how MyEntity is defined:

public struct MyEntity: Codable {
  public typealias Id = Tagged<MyEntity, Int>
  public let id: Id
}

In addition, writing to a SQLite database works fine. It's only in reading the value out that I get this error.

from swift-tagged.

Here is a toy example that reproduces the crash. Just run swift test from the root of the project.

https://github.com/danramteke/TaggedSqliteSwiftStudy

from swift-tagged.

@danramteke Not sure if you still need this, but maybe someone else could find it useful. I was able to get your test passing by doing this.

extension Tagged: Value, Expressible where RawValue: Value {
  public static var declaredDatatype: String {
    return RawValue.declaredDatatype
  }

  public static func fromDatatypeValue(_ datatypeValue: RawValue.Datatype) -> Self {
    return Self(rawValue: RawValue.fromDatatypeValue(datatypeValue) as! RawValue)
  }

  public var datatypeValue: RawValue.Datatype {
    return rawValue.datatypeValue
  }
}

from swift-tagged.

I ended up switching to GRDB. It's very well thought out and supports Combine as well. https://github.com/groue/GRDB.swift

from swift-tagged.

Hi @danramteke :) GRDB is very good. SQLite.swift has some nice maintainers, but I don't think they have nearly the time to dedicate compared to the steward of GRDB these days, and I walked away from the project many years ago, when I was no longer working with SQLite in any of my projects at a capacity that necessitated a library. Going to close this out since you found an alternate solution.

from swift-tagged.