3 ms·

This looks amazing! I see cloudflare people are on this post, any chance to compar D1 vs postgres in terms of DB features? Insert ... Returning Stored proced

This looks amazing! I see cloudflare people are on this post, any chance to compar D1 vs postgres in terms of DB features? Insert ... Returning Stored procedures and triggers Etc etc Would be really helpful to get a comparison like cockroachDB did here https://www.cockroachlabs.com/docs/stable/postgresql-compatibility.html https://www.cockroachlabs.com/docs/stable/postgresql-compati... Or even better, a general sql compatibility matrix like this https://www.cockroachlabs.com/docs/stable/sql-feature-support.html https://www.cockroachlabs.com/docs/stable/sql-feature-suppor... Kudos to the cloudflare team!

the_duke 4y ago
Well, it's sqlite... so presumably you will get most of the capabilities sqlite has. RETURNING is covered. Stored procedures are indirectly there by running your own code "next to the database", as mentioned in the post. Which is arguably much nicer than having to use some database specific language, given that you can run WASM on workers.
- tyingq 4y ago
  There is a layer on top of Sqlite here, so I imagine it's something less than all the capabilities sqlite has, at least initially. Plus the upsides and downsides from their approach to have a master and read replicas.
  - ranguna 4y ago
    Yes was thinking the same. Nice to see some people here actually understood the question, thank you.
- ranguna 4y ago
  > Stored procedures are indirectly there by running your own code "next to the database", "indirectly" is a keyword here, because running code when data is modified potentially won't replace triggers since they'll probably execute outside the running transaction.
Cthulhu_ 4y ago
The announcement - if you read it before posting - says it's sqlite, so that's something you can punch into google. Long story short, don't expect anything fancy. Support for alter table is limited, and concurrency can be an issue.
- ranguna 4y ago
  It is indeed sqlite but it could possibly have modification done or additions added. Please be considerate and think a little more before commenting.
pier25 4y ago
Listen/notify

the_duke 4y ago

Well, it's sqlite... so presumably you will get most of the capabilities sqlite has. RETURNING is covered. Stored procedures are indirectly there by running your own code "next to the database", as mentioned in the post. Which is arguably much nicer than having to use some database specific language, given that you can run WASM on workers.

tyingq 4y ago
There is a layer on top of Sqlite here, so I imagine it's something less than all the capabilities sqlite has, at least initially. Plus the upsides and downsides from their approach to have a master and read replicas.
- ranguna 4y ago
  Yes was thinking the same. Nice to see some people here actually understood the question, thank you.
ranguna 4y ago
> Stored procedures are indirectly there by running your own code "next to the database", "indirectly" is a keyword here, because running code when data is modified potentially won't replace triggers since they'll probably execute outside the running transaction.

Cthulhu_ 4y ago

The announcement - if you read it before posting - says it's sqlite, so that's something you can punch into google. Long story short, don't expect anything fancy. Support for alter table is limited, and concurrency can be an issue.

ranguna 4y ago
It is indeed sqlite but it could possibly have modification done or additions added. Please be considerate and think a little more before commenting.

pier25 4y ago

Listen/notify