https://supabase.com/ logo
Join Discord
Powered by
# help
  • j
    Yeah this is def really frustrating. Now you have to essentially deploy to production to be able to test things :/ :/ big no no
  • j
    Hi folks, how are you handling state in React Native apps, what tools, tips, tricks ?
  • b
    here is the code im using to grab the club and all the club_pages rows
    • 1
    • 5
  • y
    MobX ftw, you can get very far with just context and hooks too though, throw in a data-fetching lib like React Query or useSWR and you've got all bases covered. I default to the latter nowadays
  • j
    Thanks man
  • n
    One question to the @User , when saving for example an index.html file in the bucket is there some option which when we take the link gives us the exact html instead of it being inside of the tag and another html ?
  • d
    @User The Storage service does not modify the contents of the files you store. Any html mangling is an artifact of how browsers render the contents. e.g.
    Copy code
    $ curl -o - https://_______.supabase.in/storage/v1/object/_/_/index.html
<html>foo</html>
    Note that we don't support serving HTML directly off the storage buckets, so a browser won't be able to render the HTML file you're uploading.
  • t
    Hi there @User, Is there a way to download folder files from storage as in I have a folder filled with images/txt files and I want to download all of them at once?
  • h
    Hey! Is there a way to do a query on an array e.g. I have a table with an array of ids and i'd like to select all where the array includes X is there a way todo that?
  • b
    Search in PostgreSQL Array
    Copy code
    SELECT
    name,
    phones
FROM
    contacts
WHERE
    '(408)-589-5555' = ANY (phones);
    from https://www.postgresqltutorial.com/postgresql-array/
  • z
    is there a way to execute raw sql in the supabase dart library?
  • z
    as in, directly run 
    select column from table
    without any of the extra functions
  • h
    how would you do it with the SDK?
  • n
    can you download more files at the same time from the buckets? As in if we have a subfolder with 2-3 files, something like:
    Copy code
    js
const { data, error } = await supabase
  .storage
  .from('storage')
  .download(['test/item1', 'test/item2', 'test/item3'])
    Or:
    Copy code
    js
const { data, error } = await supabase
  .storage
  .from('storage')
  .download('test/item1')
  .download('test/item2')
  .download('test/item3')
    Hope I kinda got the point across 🙂
  • b
    I think you would add the 
    .cs('array_column', ['array', 'contains'])
    filter to the function.
  • h
    Where do you put the value?
  • h
    Also it dosen't seam to work on this query:
    Copy code
    ts
const { data, error } = await supabase
        .from<MentionedMessageType>("messages")
        .select(messageQuery);
  • b
    Copy code
    const { data, error } = await supabase
  .from('table_name')
  .select(*)
  .cs('ids_array_column', ['X'])
  • h
    X being the value?
  • b
    yes, and I think that if it is numeric data in the array column and not strings, you can omit the single quotes around it and you might even be able to drop the square brackets if you are searching for a single value. more like 
    .cs('ids_array_column', X)
  • b
    I don't have anything handy to test this with, so I am just chucking my best guess up here.
  • h
    Yup it works
  • h
    Thanks ❤️
  • b
    Glad to help, and now I know a bit more too, thanks for asking.
  • h
    Np, hopefully this helps more people in the future
  • n
    @User would you know how to retrieve multiple files from a specific bucket?
  • n
    if we have a folder and want 2-3 files out of it
  • b
    I don't, but it looks like you would probably need to fetch a list of files first, then download each one that matches your criteria. https://supabase.io/docs/reference/javascript/storage-from-list then https://supabase.io/docs/reference/javascript/storage-from-download I am not sure if you can add a filter function to the 
    from.list()
    function. If you could, that would be awesome! Something like...
    Copy code
    const { data, error } = await supabase
  .storage
  .from('avatars')
  .list('folder', {
    limit: 100,
    offset: 0,
    sortBy: { column: 'name', order: 'asc' },
  })
  .filter('name', 'contains', 'filename')
    If there isn't a way to filter in the 
    .storage
    call, then I would probably get the list of files in the 
    data
    variable and use JS code to reduce that down to what I want from it and then run the 
    .from.download()
    function to download the files or the 
    from.createSignedUrl()
    function to get a set of URLs to provide to someone to download those files to their local device.
  • n
    What I need essentially is the values of the files and download is just for me to retrieve the values and I thought maybe there is a json response with all the files (3) and for each file I can get the text() easily and display it then
  • n
    I kinda cannot call download directly after the list
1...104105106...316Latest