Raveen
Raveen
Explore posts from servers
XXata
Created by Raveen on 3/3/2025 in #help
$notExists filter having weird behavior
I have a field called description and I wanted to filter out those rows with description as null. I use $notExists. It works for the most case but for some cases. One of the values which is being filtered as notExists true is attached in the text document. Please do let me know if more info is needed for this. Thanks
1 replies
CDCloudflare Developers
Created by Raveen on 11/23/2024 in #general-help
Establishing an RDP connection from Android Remote desktop client.
I am trying to create a remote connection to my pc from my android through tunnel and I have followed all the steps here https://developers.cloudflare.com/cloudflare-one/connections/connect-networks/use-cases/rdp/#1-connect-the-server-to-cloudflare-1 For Pc there is a way to install Cloudflared and start a RDP listening port. Is there a way I can do this in Android or any other easier solution for this ?
2 replies
XXata
Created by Raveen on 10/20/2024 in #help
Search Method Cache issue
I'm using the xata.db.tablename.search method to retrieve data, and when I update or delete a data and immediately try to re-fetch records I get the old values only and only after few seconds I get the changed value. I think it might be cache, if so is there any way to clear it and get updated value ?
3 replies
XXata
Created by Raveen on 9/24/2024 in #help
Query execution issue with CTE in xata.sql
I am trying to exceute a query in xata.sql but it thorws an error where I try to use a CTE. CTE as a general works but whe, for example if I try to use select * for ProductMaxDiscount ; it is working. But if I use an alias for the cte and refer them in select or try to join with other, I get table not found error. I tried the query in other postgres env, it is working fine. Below is the query I want to execute. And below that I'll attach the ddl for quick start for testing. ```
7 replies
XXata
Created by Raveen on 9/21/2024 in #help
Unable to create text field with unique constraint from UI
No description
4 replies
XXata
Created by Raveen on 6/3/2024 in #help
Unable to get file attachment url when using xata.sql
When using xata.sql, I am not able to get the image url in the returned object, I get other attributes like enablePublicUrl: true, id: XXX', mediaType: 'image/webp', name: '759662.webp', signedUrlTimeout: 60, size: 12844, storageKey: 'XXX', uploadKey: 'XXX', uploadUrlTimeout: 86400, version: 1 }
5 replies
XXata
Created by Raveen on 4/30/2024 in #help
How to filter file column based on the size of the array with the TS SDK
xata.db.products.filter(images:, {$gt:1}) Is there something like this ?
3 replies
XXata
Created by Raveen on 3/22/2024 in #help
Error on Generated Column
No description
2 replies
XXata
Created by Raveen on 3/3/2024 in #help
Making file attachment column public by default
Hi , I have created a column for file attachment without making it as public by default, Now I want to change it to public by default, how can I achieve it ? I don't see that option in xata schema edit command
3 replies
XXata
Created by Raveen on 2/25/2024 in #help
File attachments disappearing when editing a column form web-ui
No description
4 replies
XXata
Created by Raveen on 2/15/2024 in #help
Db server in India
Hi Team, I'm from India and I find xata a very useful product in my tech stack. Unfortunately the nearest server to India I can find is Frankfurt, which is still far away and I can see it affects the latency of data retrieval. Will there be a Server setup done in India anywhere in the near future ? Thanks.
5 replies
XXata
Created by Raveen on 1/3/2024 in #help
Query syntax in Typescript sdk
Is there any way I can do this using the typescript sdk ? Basically want to filter using calculated value SELECT *, (1 - (discounted_price / original_price)) * 100 AS discount_percentage FROM products WHERE (1 - (discounted_price / original_price)) * 100 > 20;
3 replies
XXata
Created by Raveen on 12/13/2023 in #help
Is there a easier way to handle JSONData without type checking every time
No description
2 replies