Guestbook post results in 500 Server Error - was missing guestbook SQL.

kevinzunigacuellar / astro-supabase

Astro and Supabase auth and database demo

https://astro-supabase-auth.vercel.app

MIT License

182 stars 49 forks source link

Guestbook post results in 500 Server Error - was missing guestbook SQL. #5

Closed jjaimealeman closed 9 months ago

jjaimealeman commented 9 months ago

CREATE TABLE guestbook (
    id SERIAL PRIMARY KEY,
    name TEXT NOT NULL,
    message TEXT NOT NULL,
    created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP
);

I'm guessing this is what's needed?!

It's working fine now ;)

kevinzunigacuellar commented 9 months ago

Thanks for raising an issue. I really appreciate the helpful comment.

While including the SQL to generate the guestbook table could be helpful for some, this demo was not meant to be copied as is but rather to serve as reference for building other Supabase apps. With that goal in mind, I don't believe adding the SQL would provide much benefit.