sensitive-blue•2mo ago

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

kapa.ai•2mo ago

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:

     npm create refine-app@latest my-crm-app

     npm create refine-app@latest my-crm-app

- Choose the following options during the setup:

     ✔ Choose a project template · Refine(Vite)
     ✔ What would you like to name your project?: · my-crm-app
     ✔ Choose your backend service to connect: · Supabase
     ✔ Do you want to use a UI Framework?: · Ant Design
     ✔ Do you want to add example pages?: · no
     ✔ Do you need i18n (Internationalization) support?: · no
     ✔ Choose a package manager: · npm

     ✔ Choose a project template · Refine(Vite)
     ✔ What would you like to name your project?: · my-crm-app
     ✔ Choose your backend service to connect: · Supabase
     ✔ Do you want to use a UI Framework?: · Ant Design
     ✔ Do you want to add example pages?: · no
     ✔ Do you need i18n (Internationalization) support?: · no
     ✔ Choose a package manager: · npm

4. Configure Supabase in Your Refine Project: - Ensure that the necessary Refine packages for Supabase are added to your package.json:

     "dependencies": {  
       "@refinedev/antd": "^5.7.0",  
       "@refinedev/core": "^4.5.8",  
       "@refinedev/react-router-v6": "^4.1.0",  
       "@refinedev/supabase": "^5.0.0",  
     }

     "dependencies": {  
       "@refinedev/antd": "^5.7.0",  
       "@refinedev/core": "^4.5.8",  
       "@refinedev/react-router-v6": "^4.1.0",  
       "@refinedev/supabase": "^5.0.0",  
     }

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: ----------------------

kapa.ai•2mo ago

<@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.