Effect-db-schema NPM

Requirements

Being able to reuse a Effect Schema to a db schema through a magic function
We want to be able to map multiple flavors, including representing a struct just as a string column, or a json column
The system takes care of transforming the struct into the db shape and back
Concrete DB flavours (e.g. SQLite, Postgres, etc) are implemented separately

High-level API

export const User = Schema.Struct({
  id: Schema.String,
  name: Schema.String,
})

const user: User = Schema.decodeSnyc({
  id: 'bob',
  name: 'Bob',
})(User)

// save user
await magicDbFunction.persist(user)

// get user
const myUser: User = await magicDbFunction.get(user)

`tableFromStruct`: DB Table derived from Struct Schema

Caveats
- Only works for structs
- No control of number types (always uses reals/floats)

Codegen

dbcli codegen --schema ./src/db-schema.ts --output ./src/drizzle-db-schema.ts

import {gen} from 'framework'

gen(struct, './lol.ts')

MVP

Contributors

Thanks a lot to @timsuchanek for contributing the initial version of the Drizzle codegen tool

dprint-node

@everything-registry/sub-chunk-1556 @livestore/common @livestore/livestore @livestore/sql-queries @livestore/utils

8 months ago

8 months ago

8 months ago

9 months ago

9 months ago

9 months ago

9 months ago

9 months ago

9 months ago

9 months ago

9 months ago

9 months ago

9 months ago

9 months ago

9 months ago

9 months ago

9 months ago

9 months ago

9 months ago

9 months ago

10 months ago

10 months ago

10 months ago

10 months ago

10 months ago

10 months ago

10 months ago

11 months ago

11 months ago

11 months ago

11 months ago

11 months ago

11 months ago

11 months ago

11 months ago

11 months ago

11 months ago

11 months ago

11 months ago

11 months ago

12 months ago

12 months ago

12 months ago

11 months ago

11 months ago

12 months ago

12 months ago

12 months ago

12 months ago

12 months ago

12 months ago

12 months ago

12 months ago

12 months ago

12 months ago

12 months ago

12 months ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

12 months ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

1 year ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

Requirements

High-level API

tableFromStruct: DB Table derived from Struct Schema

Codegen

MVP

Contributors

`tableFromStruct`: DB Table derived from Struct Schema