https://supabase.com/ logo
Join Discord
Powered by
i do hope they enable bulk uploads after creating ...
# off-topic
m
i do hope they enable bulk uploads after creating a table
e
What does this mean?
m
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.
e
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.
m
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
e
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.
m
i'm new to postfres
oh, i've only played around with fauna
was their performance a regional thing?
too far from their servers?
or just their service was weak?
e
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.
Copy code
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.
m
super helpful
thank you
is there a upload speed difference between script and TablePlus?
e
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.
m
nice. thanks for the recommendation.
e
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.
PreviousNext
Powered by