Xano Documentation
Search…
Xano Documentation
Welcome
Release notes
Roadmap & Requests
Frequently Asked Questions
💡
Start here
What is Xano?
What's included
Technology
What is a Backend?
Why have a separate Backend?
🤔
Fundamentals
Getting Started with Xano
Designing your Database
Setting up your API
Connecting to a Front-End
🗄️ The Database
Database Basics
Database Tables
Table View
Adding Database Content
Database controls
Field Types
Database Relationships
Data Sources
Database Performance
Importing data
🔌
The API
API Basics
NO CODE API Builder
Webhooks
Testing your API
API Request History
Auto-Documentation
Branches
API Performance
🪄
Working with data
The Basics
Variables
Dot Notation
Functions
Filters
Addons (GraphQL-like)
Lambdas (JavaScript)
Date & Times
⚒️ Building Backend Features
Sign-up & Log in
Restricting Access
Password Reset
Passwordless Auth (Magic Link)
Payments
Email Notifications
SMS
Location
Generating CSV Files
Separating Data
🚀
Xano Features
Data Caching
Schema Versioning
Dynamic Image Transformation
Snippets (Share your API)
Background Tasks (Cron Jobs)
File Management
📕
HOW-to Guides
Full Build Tutorials
Data Manipulation
External APIs
Encryption
More Video Tutorials
☁️ Your Xano Account
Help and Support
Account Page
Billing
Upgrading an Instance
Increasing Plan Limits
Enterprise Plans
Adjust Server Performance
Agency Plan
Custom Domain
Change Server Region
Manage Team
Bandwidth Usage
Time Synchronization
API Rate Limit
Developer API
Share Xano. Make money
🔒
Security and Compliance
Best Practices
GDPR
HIPAA
ISO 27001:2013
ISO 9001:2015
PCI Compliance (ASV Network Scan)
💲
Special Discount Pricing
Non Profits
Students
🔨
Troubleshooting
Bug Bounty
Clear Cache
Powered By
GitBook
Database Basics
What is a Database?
Xano hosts your data on a
PostgreSQL
database which is the most powerful open source database in the world. It provides the flexibility of a relational database along with the Big data needs of a NoSQL solution.
Basic Database concepts to understand
Database Basics video course
Database tables and setup
- Tables are the Entities that make up your application
Table view
- A spreadsheet-like editor for the content in your Database
Field types
- The different "types" of content that you can store
Database relationships
- How to connect data together.
Video Course
Setting up the Database for your App
Part 1: Database Basics (SQL vs. NoSQL)
Part 2: Querying Data + Xano Basic Database Setup
Part 3: Relationships, Addons and Joins
Fundamentals - Previous
Connecting to a Front-End
Next
Database Tables
Last modified
4mo ago
Copy link
Contents
What is a Database?
Basic Database concepts to understand
Video Course