tried looking for effect-sql getting started guides
are there any good resources around it?
Ideally the post would cover
- setup your db schema with effect schema
- setup db connection in code and get a client from the schema
- query db from client derived from schema
- running migrations of that schema
I was watching the effect - remix integration video and couldn't find follow ups where the objectives around SQLite integration where covered for the TODO sample. I finished the Effect based TODO sample with todo deletion, creation and editing and am now looking into persistance.
Am I expected to use raw SQL queries against an existing DB? was hoping I could use Effect.Schema for everything with effect-sql
Any pointers welcome