-
Is there a way to use EXPLAIN for query analysis?
This evening my brother is going to give me some tutoring on optimizing queries. He mentioned a command called EXPLAIN and said it's helpful for figuring out the problematic statements. Is that a thing in Xano? I'm not finding it in the documentation.
-
How many records can be stored in the table?
Hello There is a table that stores statistical data, and about 100,000 records are stacked now. I think if there are more records, the driving speed or other unexpected problems may occur, so could you tell me how many records are appropriate for one table? If we keep going like this, we'll be able to reach 1 million soon.…
-
How can I retrieve the entire Auth Token?
I want to be able to retrieve the entire token Bearer ey..... that was sent to the Xano API endpoint. Is there a function that allows me to do this?
-
Pricing plans
Hi Can you please consider a pricing plan between Launch and Scale 1x. When you architect a system correctly you require a test and live environment and also the need to do version (branching) API's for new changes in order to avoid impact to live customers. We where on the Launch version not getting close to system…
-
Turn off growler messages?
Is it possible to turn off these growler messages? It is very difficult to work in the bottom corner. Some extra whitespace at the bottom would also help so I can scroll up a bit.
-
Best Practices for environments and deployment?
Is there a posting or video that goes over the best way to manage versioning and deployment? If not, this would be valuable to the community. I'm particularly interested in the following: * How to manage different environment variables between test and production * How to set up a different set of endpoints for test and…
-
Xano and its connection to the frontend
On the Xano home page, it says: "Connection to Xano is done through the API, which in Xano's case is a REST API - nearly all front-ends are able to ingest RESTful APIs making Xano front-end agnostic." I would have some questions as a non-tech individual: 1. If Xano is connected to the frontend through an API how are other…
-
Tutorials with Flutter/React Native as frontend
While searching for tutorials using frontend frameworks such as Flutter/React Native and Xano as a backend, I only found an old video using Flutter. Nothing from the Xano official channel. IMO it would be very helpful if the Xano team published some videos with simple demo apps using these frontend tools. It would give a…
-
What are the limits of Fuzzy Search?
I've got a shopping/price comparison website I'm building so search is a big part of the magic. Rolling out Fuzzy Search for Xano was HUGE for this! I'm wondering if there is a way to influence the "rank" of my search results beyond just matching text. For example, if a user searches "gaming monitors" Xano is currently…
-
The future of Xano Marketplace
Hey just wondering if your going to add the ability to allow agencies to sell endpoint packs on the marketplace. And if so will you make it so the logic in those endpoints can’t be seen? Bubble kind of does this with plugins and although there are some drawbacks I know that it has been a large part of their growth,…
-
Merging branches
Hello, Is there a way to merge api endpoints / function between branches? Here's the case: • i'm working on a branch named "business" and add some business logic to a function • my coworker working on an another api endpoint on a branch named "apis" When i'm done, i want him to get all my modifications in his branch…
-
Tonight's Meeting Link
Can you send me tonight's zoom link tried to sign up but could not for office hours
-
How to Get Better with Using Xano's Postgres DB Options?
Good Morning ! I want to get better with using Xano as I want, and one of my challenges that I am encountering is what I want to happen does not, and so I wanted to ask few questions and would ❤️ your advice, recommendations, and resources. (1) Do you think if I took some basic Postgres SQL online courses,…
-
Handling Guest Users On eCommerce Site
Hi All, I am currently building the backend of an eCommerce marketplace using Xano. I need to implement the ability for guests to add items to a cart and proceed to payment without the need to create an account. I was wondering what the best practice for this would be. I was thinking of creating a temp user in the user…
-
Fuzzy Search / Words not in order
Hi. Anyone know how to search when the input words don't match up to positions in the string to search? Problem: Example database value: "The quick brown fox jumps over the lazy dog" Input string of "quick brown" -- should return this record Input string of "brown quick" -- should return this record Input string of "fox…
-
Xano Disk Full Issue
Hey guys, Xano is giving me error when I try to run a function is debugger or when I am trying to save changes in the function stack. The error goes as follows: SQLSTATE[53100]: Disk full: 7 ERROR: could not extend file "base/16384/20477": No space left on device HINT: Check free disk space. I am currently at 86% of disk…
-
Connect to SFTP
Hey folks! I have an integration coming up where I need to upload a flat file via an SFTP connection. How can I make that happen within Xano?
-
Who are the Xano power users
Hey all, I’ve been around the bubble scene for around 6 years and learnt everything I know on the forum. Over that time I’ve come to know that there are those special individuals who have been around the block and are experts always willing to help. You could call them influencers or even heroes. I’d love to know who those…
-
Export Query (to use later with Import Query)
Hello people, When creating an API endpoint, there's an option to Import Query - "You import any API endpoint you've exported using the three-dot menu". What three-dot menu would that be? I've been using Xano for about an year and I still don't know how to export a query to YAML format.
-
Custom database queries
I have a large table (1M+ records). I'd like to analyze it. Nothing too sophisticated but something like: select distinct(foo), count(bar) as count from table group by foo order by count descI only see a way to define custom `where` clauses in the product. If it's not possible, I can always take the data out and figure it…
-
CVS Import "limit" working too well
Hey people I have a 'nonprofits' table I'd like to fill with data. My "free plan" record count states my limit is "10,000 records" In all my tables I have under 150 records for testing purposes but I'm unable to upload a CVS file with 9430 records - 9580 records total - less than the 10,000 limit. Not sure what's going on…
-
Environment Variables in Snippets
I created a snippet for one of my endpoints. In it, I use an environment variable. That variable got added to the new workspace that installed the snippet — that's good. What I didn't expect to happen is that the *value* of that environment variable got copied as well. Is that the expected behavior or a bug?
-
Migrating a Wordpress database to Xano
Hi all, The current website we’re working on is built using Wordpress. We want to move it to WeWeb and FlutterFlow front-ends with a Xano back-end. Can anyone point me to the right direction re: migration? Of interest in particular is that the Wordpress website has a TON of images that we need to migrate also to the new…
-
regex_matches unintuitive
What am I supposed to put in Subject? Where do I put the regex? [image.png]
-
BASE64 Image From WebHook
Using an endpoint URL for a Webhook post out of the forms provider, I've mapped the relevant fields and receive a 200 for incoming JSON blobs. The base64 image is not inserting an image into the table and I'm not sure what direction to go next. The resulting webhook post leaves the image field empty. I've tried variations…
-
Has anyone implemented a hierarchical category system?
Looking for advice.... How can one implement a hierarchical category system where one can search for items in the parent category and match all items in any of the child categories? Example: Clothing | -> Hats | -> Baseball Cap | -> Fedora | -> Stetson | -> Jackets | -> Bomber | -> Denim | -> Windbreaker Here are some of…
-
Are tasks running on a weak server?
Hi there, I have a function that when I execute it in my browser, it takes roughly 5-8secs, but when I execute the very same function through an automated Task within Xano, the task history says it takes 400-500secs. I also severely reduced the amount of data that is being worked on in this function/task, because otherwise…
-
🔐 How to make the Xano db/APIs private with a static bearer token
👋 community! I'm looking for a solution to make all APIs/dbs private in Xano with one single bearer. Has anyone found a way to create a static bearer token so it can be authenticated in the front-end request headers? Thank you!
-
Slice big file on several chunks
Hi all! I need to upload a big video on linkedin and i should use upload by several chunks. Is there any method which i can do that I also find the solution that i can slice file on JS - is Lambda function right for this and i will can implement my own JS code for some specific functions?
-
xano Community Hours Using Same Link
Hello, It would be nice to have a permanent link for xano community hours as opposed to having signup each time I want to join. Thank you, Inayet