12 replies

Switching from SQLite to PostgreSQL in create-effect-app projects: Issues with DateTime and Schem...

Hello, everyone! I'm sure I'm missing something, but: should it be possible to use create-effect-app to create a project from the HTTP template, then simply replace SQLite with PostgreSQL, assuming you change the

SqlLive

SqlLive

configuration appropriately? My team has tried it, and with no other changes, we get errors because an ISO-8601 encoded DateTime is not actually quoted when it is inserted into a table (as a default value for a

createdAt

createdAt

column). Looking at the

Model

Model

based table definitions and chasing down the source code, it's hard to see how it could work, as the various

Model

Model

methods don't seem to account for, e.g. the database dialect at all, and in the code I found related to it, the only dialect that's treated differently is MySQL. So this leads to a second question: what's the preferred means of specifying database schemas now? I see uses of

Model

Model

Schema

Schema

pgTable

pgTable

... and could use some general guidance as well as an understanding of what I should expect to be able to do just using the create-effect-app HTTP example template. Thanks!

Effect Community•7mo ago•

12 replies

Paul Snively

Switching from SQLite to PostgreSQL in create-effect-app projects: Issues with DateTime and Schem...

SqlLive

SqlLive

createdAt

createdAt

column). Looking at the

Model

Model

based table definitions and chasing down the source code, it's hard to see how it could work, as the various

Model

Model

Model

Model

Schema

Schema

pgTable

pgTable

... and could use some general guidance as well as an understanding of what I should expect to be able to do just using the create-effect-app HTTP example template. Thanks!

Switching from SQLite to PostgreSQL in create-effect-app projects: Issues with DateTime and Schem...

Similar Threads

Switching from SQLite to PostgreSQL in create-effect-app projects: Issues with DateTime and Schem...

Similar Threads

Similar Threads

Similar Threads