DbConn = ref object
  profile*: DbConnProfile    ## A profile that the database connection was opened with
  conn*: lib.Sqlite3         ## The actual database connection itself
  cache*: Table[string, Stmt] ## A cache of statements, enhances performance.

DbConnProfile {.pure.} = enum
  Default,                  ## Doesn't activate any options
  Minimal,                  ## Enables WAL and foreign keys, this allows for greater concurrency when using SQLite anywhere but a network. Ideally used for short-lived database connections.
  Server                     ## WAL, foreign keys, normal synchronous mode and other options that are typically great for web apps. Ideally used for long-lived database connections.

DbError = object of CatchableError

DbPool = object
  conns*: seq[DbConn]
  lock*: Lock
  cond*: Cond

DbRow = seq[DbValue]

DbValue = object
  case kind*: DbValueKind
  of Text:
    strVal*: string
  of Integer:
    intVal*: int64
  of Blob:
    blobVal*: seq[byte]
  of Float:
    floatVal*: float64
  of Null:
    nil

DbValueKind {.pure.} = enum
  Text,                     ## String values
  Integer,                  ## Integer value
  Blob,                     ## Binary data
  Float,                    ## Float (decimal) data
  Null                       ## A literal `NULL` character from SQLite