https://supabase.com/ logo
Join Discord
Powered by
# off-topic
  • e
    can u help me here?
  • e
    I'm in hurry
  • e
    where?
  • g
    This is a user helping user forum, no guarantee any will or can help you, but usually it works out. My guess is you have an extra space in one of the website strings or it got inserted after your select query. Please follow up in #1006358244786196510 with a new topic if you need to followup with more info.
  • e
    Copy code
    https://psmmnrrwbkrttzexjlzd.supabase.co/rest/v1/budget?services=eq.website&select=*
  • e
    no space
  • e
    but i'm getting 3 values in filter
  • y
    i'm so glad i realized how to use views properly as opposed to doing weird stuff with supabase-js and then formatting returned data in js or even using functions and rpc's when it wasn't necessary
  • y
    now my queries and formatting are all in one place 🙂
  • r
    I meant regenerating the auth, storage, etc schemas.
  • y
    do you guys think using jsonb is a better alternative to using an EAV model? especially since I'm using functions like this in my eav queries
    Copy code
    sql
      jsonb_agg(jsonb_build_object(
      'name', so.name,
      'value', sov.value,
      'unit_type', sov.unit_type)) AS option_values
    to build json data in queries anyway? I kind feel like i'm working twice now, but not sure of the pros and cons yet... i'll have to do more googling
  • a
    supabase is really great but some things just break and I always end up confused. Finally got a function to run (im just trying to convert address into a geocode so I can do something with lat and lng) and just returned nulls in the end. Can't really look into where things failed in detail, unless someone knows a way?
  • y
    should post your query/code in #1006358244786196510 , i'm going to use lat and lng soon as well. would be cool to see similar functions
  • y
    most of my errors arent supabase but bad SQL (doesn't help that sql errors are like .. "Error near somewhere in the query") 😂
  • a
    ill def do that as i have hit a brick wall, its pretty tricky knowing if I even SHOULD convert my addresses to lat and longs
  • a
    How do you/how is it typically managed on that end
  • y
    i haven't gotten to that component yet but from quick research previously, i was going to use a library to convert addresses to latitude / longitude then use postgis or similar to store it as a Point in the db, and then iirc theres a function in postgis that calculates distances (otherwise theres some examples here to do it on server: https://stackoverflow.com/questions/18883601/function-to-calculate-distance-between-two-coordinates)
  • a
    the distance/index side i have figured out. its the geocodes that are messing me up, nothing returns anything!
  • s
    Please don't do this when asking for help. Gary already directed you where to ask your question.
  • i
    is the website super slow in canada rn for anyone?
  • j
    Hello chat
  • o
    Hey How you guys are doing?
  • j
    Im pretty good
  • j
    Hbu @Olyno
  • j
    Im just really confused
  • j
  • o
    I'm good haha, what are you confused about?
  • j
    Everything
  • j
    Im learning everything at once
  • o
    Oh damn, isn't it too hard? xD
1...355356357...392Latest