Looking for SQL assistance on a demo | Remix | Page 1

weary bane Dec 4, 2022, 1:42 AM

#

I recently started a little project to demo a full-stack application on CF using the new D1 and R2 offerings. I'm having a lot of fun but my lack of exposure to databases the last few years is starting to show. I'm running multiple queries for things that should probably be joins, running into FK delete constraints, etc.

If you are a SQL "pro" or are even "intermediate" in level and just looking to have some fun, please reach out to me if this is something you'd like to collaborate on: https://twitter.com/ebey_jacob/status/1599214361243168769

Jacob.lol 🤣 (@ebey_jacob)

Anyone good with SQL and want to design a schema / queries for a @remix_run @Cloudflare D1 / R2 demo?

Having quite a bit of fun but my lack of DB exposure the last few years is really starting to show.

frigid juniper Dec 4, 2022, 12:47 PM

#

I know you can’t use prisma with those dbs but would it help using prisma against an SQLite db and print the raw queries? That would unblock you at least

spiral perch Mar 6, 2023, 7:51 PM

#

@weary bane Do you have that code public on github? Or do you know about any good example using Remix with R2? Thx!

weary bane Mar 6, 2023, 7:58 PM

#

@spiral perch that code is not public but you can check out these repos to get up and running on CF + R2:
https://github.com/jacob-ebey/remix-d1-northwind (Pages + D1)
https://github.com/jacob-ebey/remix-dashboard-d1 (Workers + D1) this is a bit out of date

#Looking for SQL assistance on a demo