DEV Community

Cover image for Migrating from Supabase and Prisma Accelerate to Convex

Migrating from Supabase and Prisma Accelerate to Convex

Ricardo Esteves on February 02, 2024

Hello DEV Community, I'm Ricardo Esteves, I love to constantly explore and adopt new technologies and tools within my preferred stack ecosystem. ...
Collapse
 
aditya_raj_1010 profile image
A.R

very brief information ... thanks @ricardogesteves Esteves

Collapse
 
ricardogesteves profile image
Ricardo Esteves

Thank you.

Collapse
 
aditya_raj_1010 profile image
A.R

welcome you can Follow back for more insightful discussion

Collapse
 
ianmacartney profile image
Ian Macartney • Edited

Very cool Ricardo! Were there any syntax pieces in particular that felt like a downside? Or anything in migrating that you felt we could more easily enable?

Collapse
 
ricardogesteves profile image
Ricardo Esteves

Here's the corrected version of your text:

Thank you, @ianmacartney. Well, it depends on the use case. Let's say that you are used to working with relational database structures and relationships between tables, and with RLS (row level security) policies. If the answer is yes, then it will be a bit challenging to figure out how you will implement the same logic for your data structures.

But if you are used to working with NoSQL object-oriented data structures, it will be a breeze. The only challenge, or one of the top challenges, was to figure out how to implement RLS Policies, also with JWT Claims because Convex just supports some claims and you need to implement a workaround, other than that, everything is pretty smooth.

A feature that I found awesome was the separation of concerns between front and back. The auto-creation of schemas/tables for fast prototyping and the internal queries and mutations from the internal API are also impressive.

Collapse
 
ianmacartney profile image
Ian Macartney • Edited

Gotcha. Thanks so much for clarifying. And glad you like those features! I've been trying to help people manage relationships and RLS with articles like:

Out of curiosity, was stack.convex.dev discoverable as you were learning the platform? If not, where would have been a good place to link you to it?

Thread Thread
 
ricardogesteves profile image
Ricardo Esteves • Edited

Thank you @ianmacartney for sharing those insightful articles! I appreciate the effort you're putting into helping people manage relationships and Row-Level Security (RLS). The links you provided seem like valuable resources, and I'll definitely check them out.

To answer your question, I did come across stack.convex.dev during my learning journey, and I found it to be a great source of information. However, it's always beneficial to have a direct link for quick access. Maybe incorporating it into platform tutorials or documentation could help others discover it more easily.
It would be really helpful if there were some tutorials here on dev or at medium and also maybe some youtube videos.
Also, it would be nice to be able to access metadata from user object in the identity object, that would solve unnecessary workarounds.

Once again, thanks for the useful content, and I look forward to exploring more on stack.convex.dev.