Connecting Sanity CMS + Database Setup (Supabase → PostgreSQL)

Databases & SQL, Web Programming — incorrectly specified categories?

Project translated automatically. Log in or register, to view the original

Initial Data:

The site is built with React + Vite + Tailwind (repository on GitHub).
The frontend source code is available.
The project is registered on Sanity.io.
Hosting is on Hostinger, with the option to create a PostgreSQL database.

Tasks:

1. Set up Sanity CMS:

Create data schemas:
- Show (exhibition): name, dates, location, description, brands, organizer, image.
- Organizer (organizer): name, description, website, logo.
- Brand (brand): name, description, website, logo.
- BlogPost (blog post): title, text, publication date, author, cover image.
Link data between schemas (for example, brands linked to shows).

2. Set up and connect PostgreSQL database:

Create a new database on Hostinger.
Prepare table structures for storing:
- Shows
- Organizers
- Brands
- (optional) users/tickets/purchases (for future).
Transfer existing data from Supabase:
- If possible — using pg_dump and pg_restore.
- If not — export CSV and import into the new database.

3. Integrate site with CMS and database:

Connect the site to Sanity via API to fetch content.
Connect the site to the new PostgreSQL database for storing and processing dynamic data (if needed: for example, ticket bookings, applications, etc.).
Ensure secure access to the database (connect via backend, without direct frontend access).

4. Update the site:

Convert static pages to work through Sanity (event cards, blog).
Verify that the site correctly displays data from CMS and database.

5. Documentation:

Write a short instruction:
- How to add and edit records in Sanity.
- How to work with the database (if needed).

Expected outcome:

✅ The site dynamically loads data from Sanity.
✅ PostgreSQL database is set up, data transferred.
✅ Everything works correctly on the production server on Hostinger.
✅ Documentation for the project owner.

*Currently, the database is empty — only test examples.

Proposals 4

Andrey K.

1 299 1

Budget: 8000 UAH Deadline: 7 days

Hello. I have extensive experience with React/Node.js. Can I see the project?

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Current freelance projects in the category Databases & SQL

Automation of the entry of income invoices in 1C 8.3 via the API of the document recognition service

10 proposals 0:36

335 USD
Updating Joomla version

Content Management Systems 26 proposals 5 August

16 USD
Senior AI Systems Architect (Project Lead) Needed to Complete an Existing Unfinished Global Service

Gaming Apps 19 proposals 3 August

Not specified
Development of the CRM module "Requests" in custom 1C (bus center)

Client Management & CRM 20 proposals 31 July

Not specified
Support for Samotur and its servers

17 proposals 27 July

22 USD

Mark Tidler
Odessa, Ukraine

Projects 7
Rating -
Rating 298

Andrey K.

Proposals are currently absent

Current freelance projects in the category Databases & SQL

Automation of the entry of income invoices in 1C 8.3 via the API of the document recognition service

Updating Joomla version

Senior AI Systems Architect (Project Lead) Needed to Complete an Existing Unfinished Global Service

Development of the CRM module "Requests" in custom 1C (bus center)

Support for Samotur and its servers