sql database backend recommendation
I am currently working with the refine demo page for a custom crm im building but it does not yet have a backend. Any recommendations ? My current dataset is in postgresql and don’t have much knowledge on what best yet to use for my backend
3 Replies
Hi @TheRedPanda. I'm kapa.ai, your friendly support bot. I will try to answer your question by searching through the knowledge base. :wave:
----------------------
For your custom CRM project using Refine, since your current dataset is in PostgreSQL, I recommend using Supabase as your backend. Supabase is an open-source Firebase alternative that provides backend features, including a PostgreSQL database, authentication, and more. It integrates seamlessly with Refine, offering built-in data provider support and handling all required data service methods out-of-the-box.
Here are the steps to set up Supabase for your Refine project:
1. Sign Up and Create a Project on Supabase:
- Sign up at Supabase (https://app.supabase.com/).
- Create a new project and set up your PostgreSQL database.
2. Set Up Your Database:
- Create the necessary tables and relationships in your Supabase database. You can follow the Supabase quickstart guide (https://supabase.com/docs/guides/with-react#create-a-project) for detailed instructions.
3. Integrate Supabase with Refine:
- Use the
create refine-app
CLI tool to initialize your project with Supabase as the backend. Here is an example of how to do it:
- Choose the following options during the setup:
4. Configure Supabase in Your Refine Project:
- Ensure that the necessary Refine packages for Supabase are added to your package.json
:
For more detailed instructions, you can refer to the Refine documentation on Supabase (https://refine.dev/docs/data/packages/supabase/#introduction).
By following these steps, you should be able to set up a robust backend for your CRM application using Supabase and Refine.
If you need further assistance, feel free to check out the Refine documentation (https://refine.dev/docs/) or the Supabase documentation (https://supabase.com/docs).
----------------------
Note: you can ask me a follow up question by @ mentioning me again :speech_balloon:
----------------------<@455605520426860556> kapa.ai is still learning and improving, please let us know how it did by reacting below
sunny-green•2mo ago
Our CRM example uses nestjs-query package for generating graphql backend. It's relatively simple and saves a lot of time.