Any tips on how to host with supabase?

[njiels]

Hello,

I've been trying to create a pruvious website using supabase as database. I cannot use digitalocean right now, that's why i wanted to go with supabase and vercel or netlify. With both those services i fail to deploy. My database does work in dev mode (although it takes a while before connecting to the database).
During the hours i've spent on the deployment i figured it is probably going wrong in build mode because connection to the database goes slower then expected.

This is my nuxt.config:

export default defineNuxtConfig({
  compatibilityDate: '2024-07-15',
  devtools: { enabled: false },
  ssr: true,

  nitro: {
    preset: 'netlify'
  },
  
  modules: ["pruvious", "nuxt-swiper"],
  
  css: [
    '@/assets/main.css'
  ],


  runtimeConfig: {
    private: {
      pruviousDatabaseUrl: process.env.NUXT_DB_URL, 
    },
    public: {

    }
  },
  pruvious: {
    // LAAT DIT LEEG!
  }
})

This is my package.json:

{
  "name": "nuxt-app",
  "private": true,
  "type": "module",
  "scripts": {
    "build": "nuxt build",
    "dev": "nuxt dev",
    "generate": "nuxt generate",
    "preview": "nuxt preview",
    "postinstall": "nuxt prepare"
  },
  "dependencies": {
    "nuxt": "~3.19.0",
    "nuxt-swiper": "^2.0.1",
    "pg": "^8.16.3",
    "pruvious": "^3.15.5",
    "vue": "^3.5.13",
    "vue-router": "^4.5.0"
  }
}

Does anyone knows how i can deploy to netlify or vercel? Tips are very welcome!
I am basically at lost how to deploy my website so the CMS is still usable. static rendering works allright, and I am also trying it on a server but there the pruvious command won't work. Ive installed a simple ubuntu v20 server on hetzner but it keeps claiming it can't find file or directories and mentions https.

[njiels]

valuable info: at vercel i keep getting an error 500, no matter what connection uri from supabase i use

[njiels]

I am also aware about the differences between my nuxt version and pruvious version. However, i can't really seem to install nuxt 3.15. lowest version that works is 3.19

[murisceman]

Hello!

I cannot use digitalocean right now, that's why i wanted to go with supabase and vercel or netlify. With both those services i fail to deploy.

Pruvious v3 doesn't work properly on Vercel: #4 (comment)

Netlify is possible, but other users have reported it's tricky to set up: #10

During the hours i've spent on the deployment i figured it is probably going wrong in build mode because connection to the database goes slower then expected.

This is expected. When your server and database are in different locations, each query takes longer due to network latency. On startup, Pruvious runs database migrations and makes many queries, which causes these delays.

valuable info: at vercel i keep getting an error 500, no matter what connection uri from supabase i use

Have you tried adding ?sslmode=require to your connection URI?