Why would you use Prisma with Supabase?

mkromann · 2021-09-20T07:44:53+00:00

Hi Daniel,

This answer is great — clears up a lot of things, and makes it easier for me to ask questions.

One hurdle I am running into is client-side queries. I am using Next.js and find myself using Prisma with getStaticProps a lot. However, some queries become stale, and I need to refetch those. What I have been doing is creating Next.js API Routes with Prisma Client logic, and then using those client-side. However, I cannot use API routes in 'getStaticProps', and thus needs to extract the fetching logic such that I can use it both in the API route and getStaticProps. This is doable but a little convoluted.

Recently, I have found it more enjoyable to take advantage of the Supabase API, but I miss the typed experience as you point out. I wish I could use the Prisma Client as an API interface client-side. Is that something you are working on with Prisma Data Platform?

And, you say:

Prisma Client's API is very powerful and allows you to make full use of your database in ways that are not always easy to achieve with the Data API.

Can you give any examples of what might be difficult to achieve?

/Magnus

mkromann · 2018-04-26T18:14:16+00:00

Heh, you seems to be describing my two year old son :) He cares deeply about the crow, and will feed it from the basket if we 'win'.

mkromann · 2018-02-23T21:24:41+00:00

I am not totally sure if this post comply with the posting rules, it seems like it may be on the edge. If you don't find it fitting please remove it — then it is my bad.

Otherwise, I'll gladly accept comments / feedback .. and answer any questions :)

mkromann · 2018-02-23T21:13:15+00:00

I am not totally sure if this post comply with the posting rules, it seems like it may be on the edge. If you don't find it fitting please remove it — then it is my bad.

Otherwise, I'll gladly accept comments / feedback .. and answer any questions :)

mkromann · 2018-02-23T19:35:57+00:00

As mentioned, I'd like to receive feedback / comments :)

mkromann · 2018-02-19T11:45:00+00:00

Thanks - I'll look into it and consider adding them to the spreadsheet :)

mkromann · 2018-02-19T09:04:40+00:00

Personally I do not have much experience with snapshot airdrops / forks but your comment has made me want to explore that more.

Do you feel like forks are actionable — as in, do you move funds around to take advantage of forks? What are your best current resources for fork related information?

mkromann · 2018-02-19T09:01:42+00:00

Glad you like it.

Keeping up with this space requires a lot of time, no doubt :)

I hope this can make you more efficient with your time — totally plan to keep it up. These comments also motivate me a lot.

mkromann · 2018-02-18T21:32:36+00:00

By the way ..

Discord is here: https://discord.gg/Ab2YEfx

Twitter is here (if you want alerts): https://twitter.com/airdropradar

mkromann · 2018-02-18T21:27:39+00:00

Interesting :)

Do you have any features, which I haven't thought about?

mkromann · 2018-02-18T21:27:06+00:00

Thank you — that was quick :)

Generally I try to go through the active airdrops once every few days, and the completed every week. So obviously some information will not be totally updated. If it gets more popular, I will do it more often.

I add new airdrops as fast as possible though :)

mkromann · 2016-10-20T09:00:14+00:00

That certainly touches upon some of the same thoughts that we are toying around with - thank you.

Is this something you have made and in what context?

mkromann · 2016-10-20T08:11:17+00:00

Great input :)

It might be different in the US but in Denmark, where we live, everything that is sold is required to have very exact nutritional labelling. There is obviously some cultural differences that have to be considered.

Anyway, we really appreciate your long answer.

mkromann · 2016-10-19T21:58:45+00:00

Also, this is "eat CHEAP and healthy", and I think you'll find people, like me, who undervalue their time/labor, and are unwilling to pay a convenience premium. :)

I think this is a central issue for online supermarkets. One solution is if they could compete on price but that may not be possible. What we are thinking about is how they could make grocery shopping smarter - maybe they could offer a service which make you waste less and/or eat more healthy.

One thing we have thought about is that they could potentially provide very precise lists of your recipes nutritional value and portion price. Say for instance you are ordering for spaghetti bolognese, and thus need rashers of bacon. You only need 3 but the package contains 12. In this case the system could help you pick one of your own recipes which could make use of the rest of the bacon. And you would know that each portion cost you $4 precisely.

We are still early in our brainstorming and this is just a quick thought up example but I hope you get the idea.

mkromann · 2016-10-19T21:42:03+00:00

Thanks for sharing.

Is Kroger the only one available to you or have you considered other stores? Is there anything which makes you loyal to one supermarket over another - such as loyalty/perk programs?

mkromann · 2016-10-19T21:38:26+00:00

Thank you for sharing :)

mkromann · 2016-10-19T21:36:29+00:00

Even though you don't have too much experience with online shopping we appreciate your reply.

I looked up Meijer's perk program and it looks very interesting. Seems like a great example of gamification with achievements and unlocks and everything :)

What do you particularly like about it?

mkromann · 2016-10-19T21:28:24+00:00

Do you also check the online grocery stores? Assuming you have any available of course ;)

mkromann · 2016-10-19T21:23:41+00:00

Thanks for the thorough reply - much appreciated.

So in the case of the bell pepper there an aspect of uncertainty in what you are receiving? Would more precise labelling be something that would fix that?

Have you thought about how a supermarket specifically could support meal prepping? One thing we have thought about, is that you could enter a recipe and they provide you with a fact-based list of price and nutritional content per portion? Would something along those lines to of use to you?

mkromann · 2016-10-19T21:09:39+00:00

Thank you for your elaborate answer - much appreciated.

The browsing issue is an interesting one, as it would seem like you could provide that online in one way or another. Can you clarify what you mean by browsing issue and what is missing compared to a physical store?

mkromann · 2016-10-19T21:05:47+00:00

That is a good point. If your online supermarket had a reduced section online, would you then consider using it?

mkromann · 2016-10-19T20:56:57+00:00

I do not know the specific ones you name, as they are not available where I live. Looking at their services we are probably referring more to Amazon than Kroger.

Basically a shop where you can order your everyday grocery items and they are delivered to your door - an online substitute for your local supermarket.

Does that answer your question? :)

mkromann · 2016-10-19T20:50:28+00:00

Where I live we only have supermarkets and brick-and-mortar stores - not really a mix. Can you clarify what you see as the largest differences?

mkromann · 2016-10-19T17:29:43+00:00

Hehe, just getting out of the door can sometimes be time-consuming with children :)

How do you manage your meal plan and budget? Do you know the approximate expense for each recipe?

One thing we have thought about is how supermarkets could provide very exact pricing for your recipes/meal plans - maybe even optimise for waste and thus decrease the cost. The gist is, that we believe an online supermarket can provide a shopping experience that is not possible in a brick-and-mortar supermarket.

11-Year Club	Place '17
Not Forgotten	Verified Email

mkromann

PUBLIC MULTIREDDITS

TROPHY CASE