Keeping database in sync

In case you missed it, come join us on Twitter Spaces and hear the Supabase team talk about building apps with Supabase https://twitter.com/AntWilson/status/1451187549314060293

Research Postgres textsearch with a ts_vector generated column as one way. There are many examples.

Hi guys, do you have any references to use supabase with graphql?

Like with a graphql client? Or make a graphql server with supabase as the database?

Make a graphql server with supabase as the database

Well you would need to find an sdk for your language and then use the service role as the key and boom you can juse use it as a database!

Do you have any resources or examples?

The docs? But no examples that I know of

All right, I'm gonna search for it. Thank you for your answer 👍

Hi

I got a question, I really enjoy supabase for local development currently, but for small commercial projects, it seems to be expensive with a minimum price of 25 dollars? Am I missing something here?

Supabase pricing

Supabase pricing model

#ASK Anyone is using Supabase with flutter in here???? I got a problem. Why i can only fetching one image and the others was getting an error because it was getting an extra String in the behind like this :

"HTTP request failed, statusCode: 400, https://ojiuxsweoqbgmknpdrnw.supabase.co/storage/v1/object/public/bookimage/fxnTgRmbvA.png%0D%0A"

As u can see i got

%0D%0A

extra string in the behind. IDK why this was happened. When i fetching with browser without this extra string, it was working. My code : Fetching image :

dart
  String? getImageUrl(String data) {
    var res = this._supabase.storage.from('bookimage').getPublicUrl(data);
    print(res.data);
    return res.data;
  }

Widget Image :

dart
CircleAvatar(
    radius: 50,
    child: Image.network(this.controller.getImageUrl(this.controller.bookList[index]['image']) ?? ''),
)

As u can see in this image two, the response from publicURL wasn't getting any new extra String......

I think i got this error because of cache. I usually using

cacheControl: '3600',

when uploading the image and in my IONIC project, it was working perfectly. IDK why in flutter it was throwing an error......

Supabase and Flutter

Hey all – I'm looking to authenticate an app/cli via Supabase by using the user's already existing browser session, I've seen best practices are to setup a localhost & redirect the auth there from the browser. Wondering if I should be generating a new/separate session for the app (not sure the easiest way to do this one) or share it between browser & app (ie, in browser: auth.session() -> pass that data back to the app via the redirect to localhost...)?

maybe as simple as auth.signIn({refreshToken: ...}, {redirectTo: "localhost:3000/credentials/"}) from the existing browser session?

hi. I am trying to build a public api for my supabase data and exploring options. I am currently using a fastify + supabase-js solution, but thinking that there may be something easier, perhaps with postgREST. has anyone seen content on that?

I'm sure that Supabase is using postgREST (or maybe a slightly modified version) for the API. Supabase-js just calls the postgREST API with postgrest-js. You can too.

Yeah I am leaning towards doing that with Postgres url as a little exploration.

Hi, how long do DB backups usually take? Mine have been running for almost 24 hours in "Backup in Progress...."

Anyone using railway with supabase? I get good response times to both of them individually (100-200ms) but it seems like when the application on railway is communicating with supabase its almost a second

I tried it a few months ago and experienced very similar performance issues (https://discord.com/channels/839993398554656828/875758805223354429/876130619120304238) I'm not sure if the situation has changed, but they had one data-centre, hosted somewhere in the US. There was a lot of routing between the US and UK (where I'm located), which meant that there was a lot of roundtrip latency being introduced. In the end, I just went back to using DigitalOcean (and around the same time, decided to setup self-hosted Supabase also on DigitalOcean). This brought my query times back down to around 100-200ms, with around 80-90% of that time being the time the database spent running the query.

Thank you. Glad to know I'm not doing something wrong. Bummer as I really enjoy each service on their own

The free database plan only pauses after 1 week, if I don't save, update or delete data from that database, am I correct?

A small note for the @User, it would be good if you guys add this to the docs that providers like for example GitHub might need some permissions enabled so that the loging/registering works 🙂 will definitely benefit many

Is there any way to view a realtime postgrest log? I can't figure out why my inserts - with triggers - are failing