Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

they're adding functionality, like functions, pretty often. i don't know of any breaking changes

there's always changes that require attention.

right. ok ill just keep going in same. proj for now and see if anything breaking happens down the line

You can always export your data and then start a new project and import it again. It would be best if they made it possible to upgrade projects to the latest versions and that’s probably something they are already aware of.

that sounds nice. Yeah i guess theyre pretty smart so not like old proj will just die and theyll prob figure stuff out like that

yeah, it's likely on their todo list, along with a million other things

Overall I generally appreciate the things that they are focusing on. Deno functions was an amazing choice for example even if I’m currently not using it. It’s easy to focus on what’s missing but I try to be patient given their impressive track record.

i do hope they enable bulk uploads after creating a table

when making a new table in Supabase, you can upload a CSV file to the database. it works very well and is quite fast.

but after a table is made, we can't upload bulk data (like a CSV file) using Supabase

we must write scripts or use tools like Archtype

fauna has really cool bulk upload feature they just released.

Ah I see. I was thinking that there is nothing preventing you from using a script but if it’s about the Studio I understand.

yeah, i've been getting errors with a script lately, and it's been frustrating. fauna has a pre-check feature that makes the process much easier

if you've got any advice that would be cool

Btw, I spent a few good weeks on fauna before moving to supabase. That was about a year ago. I really like a lot of what fauna had to offer but the performance was really unstable when I used it and dev xp was weird too with the long index creation times.

I usually use the psql command to execute a script and then inside the sql script you can have a copy statement. Here is how that can look. First line is the psql command you run in command line. Second line is the copy/import statement.

```
psql -f my-script.sql

copy restaurants from './input_data/restaurants.txt' delimiter E'\t' CSV HEADER;
```

Actually, if you are new to Postgres I recommend using something like this https://tableplus.com

You can connect to your supabase db and they provide GUI for importing from csv into existing tables.

is there a upload speed difference between script and TablePlus?

Not that I have noticed. I think it’s just pretty clean GUI layer on top of the command line stuff. The free version should be enough to get you started. If you get paid version eventually their chat support is great too.

Saw that I missed your questions here. The performance was not amazing in most of their regions, like 200ms+ for most stuff. I studied their documentation for a few days and it was still really easy to write queries that are not optimal. If I write what feels the most “natural”, it would eat up the credits really fast. This is a really bad onboarding experience for new devs imo. In general I don’t like software where I have to be mindful about every query I send.

I don’t want to stan supabase too much but after a few weeks of writing the data layer in fauna and running into too many walls, I literally rewrote everything in supabase in a weekend.

fauna just did it very nicely, but i imagine that's not a hugely requested feature

Are there any alternatives to Discourse (open-source) built with supabase?  Specifically, solutions that robustly handle email notifications and where you can interact with the forum using email only?  (e.g. sending an email creates a thread on the forum, sending a reply email adds a comment on a thread, etc?)

Nope there is no alternative, otherwise i don't remember

Hm, the docker instance of supabase gives a magic-link starting with x-webdoc:// and the cloud version starts with https://.. The webdoc:// doesn't work. What did i miss in configuring the docker version of supabase?..

Yes i did it! Needed to dig a little bit further, but i needed to set the following values inside docker-compose.yml file:
      API_EXTERNAL_URL: http://192.168.1.119:8000
      GOTRUE_SITE_URL: com.company.app://login-callback/
Maybe an idea to put these attributes inside the docker-compose.yml and .env in the future? 🙂

I've never used Docker, so can't say what do do (seems like a good idea), but I'm happy it worked out

Hey Ricket, would it be possible to move the discussion in <#843999948717555735> please? It's not the best channel to ask help 😅

Wordwrap button in code snippets in docs is nice touch

General is not the place for specific questions

all good no worries, 👍 for moving the message to the correct channel

A new discord event is ready! Checkout <#867348870262030337>! <:supafire:979110896762757121>

I will react <:supafire:979110896762757121> to every meme sticker

Please use the <#843999948717555735> channel for help related questions

tks, sorry to spam, I don't know about <#843999948717555735> channel
thanks <@107176742342402048>