# Syncing

Noloco offers two robust methods for syncing data from external sources to your custom applications: **Scheduled Syncing** and **Live Syncing**. Understanding how these processes work can help you maximize the efficiency and reliability of your data flow, ensuring your application always reflects the most current information in your data source.

| Data Source   | Live Syncing | Scheduled Syncing |
| ------------- | :----------: | :---------------: |
| Airtable      |       ✅      |                   |
| Google Sheets |              |         ✅         |
| Hubspot       |       ✅      |                   |
| MySQL         |              |         ✅         |
| PostgreSQL    |              |         ✅         |
| REST APIs     |              |         ✅         |
| SmartSuite    |       ✅      |                   |
| Stripe        |       ✅      |                   |
| Xano          |              |         ✅         |

## Scheduled Syncing

Scheduled syncing is enabled for data sources that require regular data updates;

* [Google Sheets ](/~/revisions/4ycMT0EcUe4aYSGLpT5Z/data/google-sheets.md)
* [MySQL](/~/revisions/4ycMT0EcUe4aYSGLpT5Z/data/mysql.md)
* [PostgreSQL](/~/revisions/4ycMT0EcUe4aYSGLpT5Z/data/postgresql.md)
* [API Collections](/~/revisions/4ycMT0EcUe4aYSGLpT5Z/data/rest-apis.md) 
* [Xano](/~/revisions/4ycMT0EcUe4aYSGLpT5Z/data/xano.md) 

### How Scheduled Syncing Works

* **Frequency**: The frequency of scheduled syncing depends on your [Noloco subscription plan](https://guides.noloco.io/account/pricing#understanding-database-records-limits). Each plan offers different syncing intervals (priority or standard), allowing you to choose one that best fits your business needs.
* **Process**: On the set schedule, Noloco reads all of the data in your external data source. It checks for any new or updated data since the last sync. This includes additions, deletions, or modifications to the records in your tables.
* **Application Update**: Once the syncing process is complete, the changes are reflected in your Noloco application, ensuring your data remains current up to the latest sync.

## Live Syncing

For businesses requiring their applications to reflect data changes almost instantly, live syncing is the ideal solution. This method is supported exclusively for [Airtable](/~/revisions/4ycMT0EcUe4aYSGLpT5Z/data/airtable.md) and [SmartSuite](/~/revisions/4ycMT0EcUe4aYSGLpT5Z/data/smartsuite.md), and [Stripe](/~/revisions/4ycMT0EcUe4aYSGLpT5Z/data/stripe.md) data sources with limited support for [Hubspot](/~/revisions/4ycMT0EcUe4aYSGLpT5Z/data/hubspot.md) too

### How Live Syncing Works

* **Real-time Updates**: Unlike scheduled syncing, live syncing listens for changes in your external data source in real-time. When a change occurs, it's immediately communicated to Noloco and reflected in your application.
* **Setup**: Live syncing is enabled by default for Airtable and SmartSuite, providing an effortless setup for instant data updates.

## Schema Syncing

In addition to syncing data content, Noloco also periodically syncs the schema (structure) of your external data sources. This ensures that any changes to the tables or fields in those tables are accurately reflected in your Noloco application.

* **Periodic Checks**: Noloco periodically reviews the schema of your connected external data sources for any changes every few minutes.
* **Automatic Updates**: If a change is detected, Noloco automatically updates your application to align with the new schema, ensuring structural consistency.

### Updating or creating data in Noloco

When you make changes to any data source in your Noloco app, or through our [Make](/~/revisions/4ycMT0EcUe4aYSGLpT5Z/integrations/make.md) or [Zapier](/~/revisions/4ycMT0EcUe4aYSGLpT5Z/integrations/zapier.md) integration or through the [API](/~/revisions/4ycMT0EcUe4aYSGLpT5Z/api-documentation/api-overview.md) the data will **instantly** be updated in your external data source too. 

For example, if you use Airtable as an external data source and create a new record in your Noloco app, that record will be instantly created in Airtable and stored in Noloco.

## Manual Syncing

Despite the efficiency of scheduled and live syncing, there might be instances where an immediate update is necessary, or an inconsistency arises.

* **Immediate Action**: In such cases, Noloco allows for manual syncing. Users can initiate a manual sync for a specific table or the entire data source directly from the data table in their application.
* **Problem Resolution**: This feature is particularly useful for quickly resolving any discrepancies or ensuring data is up-to-date following unforeseen changes.

### How do I manually sync a table?

{% @arcade/embed flowId="2PZDMWlw9GHMwSx0BCHD" url="<https://app.arcade.software/share/2PZDMWlw9GHMwSx0BCHD>" %}

### How do I manually sync a data source?

{% @arcade/embed flowId="A2zS2NaVQnqHF5w60F7I" url="<https://app.arcade.software/share/A2zS2NaVQnqHF5w60F7I>" %}

### How do I manually sync a data source schema?

{% @arcade/embed flowId="Qif28L07BcPq9LLqkQcI" url="<https://app.arcade.software/share/Qif28L07BcPq9LLqkQcI>" %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://guides.noloco.io/~/revisions/4ycMT0EcUe4aYSGLpT5Z/data/data-overview/syncing.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.