PandaSuite Database

The PandaSuite Database is not a traditional database. It’s a data model you create in PandaSuite Studio, which gets copied to each device. Each user owns their own local version that they can modify without impacting others.

How does it really work?

Think of the PandaSuite Database as a starter template for your data:

1. In PandaSuite Studio: you design a schema (structure) with default values.
2. On download: each user receives a personal copy of this template.
3. During use: changes remain local to each device.

Key takeaways

• Each device = an independent copy: user changes do not affect others.
• Persistent data: it survives app closure (but not uninstallation).
• Optional synchronization: you can fetch model updates from PandaSuite Studio.
• No server required: everything works locally, even offline.

Two main use cases

User’s local storage

To save information specific to each user:

• Scores & progress: game level reached,
• Preferences: chosen language, dark mode enabled,
• App state: tutorial completed, pre-filled forms.

Content that drives your app

To create dynamic content from PandaSuite Studio:

• Product catalog: regularly updated list of items,
• Dynamic pages: editorial content without rebuilding the app,
• Configuration: app settings editable remotely.

Create your database

Add the database

In the Database panel, choose PandaSuite Database.
The component is added at the Project level so it’s accessible everywhere.

Click the arrow to open your database.

Define the structure

1. Click the + Add property button
2. Choose the data type (Text, Number, Array, Image…)
3. Rename and set the default value if needed.

Manipulate data

All operations are triggered from the Actions panel — no code required.

Create / Edit data (local)

This action edits data only on the user’s device.
It’s the most common action for handling scores, preferences, or app state.

1. Trigger
   Select any trigger — e.g., On Tap of a “Validate” button.

2. Action
   Interact with a data source → PandaSuite Database → Create/Edit data (local)

3. Target
   Pick the property to modify in your database.

4. Function to apply

For simple values (text, number…)

• Set: fully replaces the value
  Example: change the player’s name

• Increment / Decrement: adds or subtracts a number
  Example: increase the score by 10 points

  ⚠️ Works only on Number data types.

  

For arrays (lists):

• Add: appends an item to the list
  Example: add a product to the cart

• Remove by value: removes a specific item
  Example: remove “Apple” from the shopping list

• Remove by id: removes an item by its unique ID
  Example: remove product #42 from the cart

For any data type:

• Delete: completely deletes the data
  Example: reset user preferences

5. Value
   Define what you want to store:

• Fixed text: Hello
• Dynamic value: bind to a form field
• Function: timestamp for current date, random for a random number

Fetch remote data

This action retrieves updates to the model from Studio — especially useful for dynamic content.

How does synchronization work?

You have two options:

1. Overwrite all: completely replaces local data with data from PandaSuite Studio

   • ✅ Ideal for: product catalog, editorial content
   • ❌ Beware: overwrites local changes (scores, preferences)

2. Merge: intelligently combines local and remote data

   • ✅ Keeps: user changes
   • ✅ Adds: new items from Studio
   • ✅ Updates: default values not modified locally

When to sync?

Moment	Why
On app launch	Retrieve the latest updates
“Refresh” button	Let the user trigger it manually
After regaining internet	If the app was used offline

Export data (local)

This action creates a CSV file containing all the user’s local data. Useful for:

• Analytics: understand how users interact with the app
• Support: troubleshoot issues
• Backup: let the user save their progress

Delete your database

Go to the Project tab and select your database.
Click the delete icon.

Understand the limits (and how to work around them)

What the PandaSuite Database does NOT do

1. No automatic sync between users

   • ✅ Solution: use Firebase or an API to share data.

2. No complex queries (like SQL)

   • ✅ Solution: keep data simple and use component filters.

3. No automatic cloud backup

   • ✅ Solution: offer a CSV export or connect to a cloud service.

Its strengths

• Simplicity: no server management required
• Performance: local data = instant access
• Offline-friendly: works without internet
• Free: included in PandaSuite

Learn more

• Variables
• Collection / List
• Data binding
• Bookmark / Favorite
• API & Offline data