Learn Xano

Querying Database Tables by a Specific Month

t: Learn how to query a database table based on a specific month using Xano, a no-code platform for building backend services. This guide covers creating input fields for month and year, defining the date format, converting to Unix timestamps, getting the first and last days of the month, and querying the database table accordingly. Xano's visual interface streamlines this process without writing code.```

Importing Test Data

Learn how to import test data from wjson.com into your Xano database for seamless backend development. This guide covers exploring wjson.com endpoints, converting JSON data to CSV, creating tables in Xano, importing data via API requests, and handling pagination. Streamline your workflow with Xano's visual interface and leverage sample data for efficient prototyping and testing.

Private vs Public Storage

Explore the differences between public and private storage in Xano, a no-code platform for building web and mobile applications. Learn how to securely manage file access, protect sensitive data, and leverage practical examples for using public storage (for open access) vs. private storage (for authorized access only). Ensure data privacy and security in your applications with Xano's powerful storage capabilities.

How to Prevent Simultaneous User Logins

Learn how to prevent password sharing in your Xano application by implementing a session key system. This comprehensive guide covers creating a session key column, modifying the login API, validating session keys, and applying the validation to secured endpoints. Enhance security and revoke access on new logins using Xano's no-code, visual authentication and authorization flows.

External Paging

Discover how to implement external paging (pagination) in your Xano app for efficient retrieval of large datasets. This guide covers optimizing database performance, improving user experience, enabling dynamic paging using external inputs, and leveraging offset functionality. Master external paging with Xano to build high-performance, user-friendly applications.

Xano + React: Upload or Assign a Profile Picture

Learn how to enhance user registration by allowing profile image uploads in your web or mobile app built with Xano. This guide covers creating database tables for images and users, adding a profile picture field, setting up the auth signup endpoint, handling custom or generic image uploads, creating user records with image metadata, and generating authentication tokens. Xano enables building backend services with a visual interface, without writing code.

Multi-tenant Security

Discover how to build secure multi-tenant applications with Xano's no-code platform. This comprehensive guide walks you through implementing a security technique that ensures users can only access data related to their associated companies. Explore the data structure, learn to create a reusable security function, implement it across endpoints, and test your implementation for robust access control. Streamline multi-tenancy with Xano's visual interface and empower businesses of all sizes to build secure, scalable applications without writing code.

Updating Nested Objects in Object Arrays

Learn how to update deeply nested objects within object lists in Xano using a step-by-step guide with a real-world example. This comprehensive tutorial covers querying parent records, looping through nested child and grandchild objects, identifying the target object, updating it, and persisting the changes back to the database. Discover best practices for data modeling and tips to avoid complex nested structures for maintainable and scalable applications on Xano's no-code platform.

FlutterFlow Custom Authentication with Xano

Learn how to build a custom authentication flow for your Flutter Flow app using Xano as the backend. This step-by-step guide covers setting up authentication APIs in Xano, integrating them into Flutter Flow, creating sign-up and login flows, fetching user data, and testing the complete authentication process. Leverage Xano's powerful authentication capabilities and Flutter Flow's no-code platform to streamline your development.