In Lumi, data is the structured information that powers the dynamic functionality of your app, including users, content, orders, and more. This information is organized within tables, which function similarly to a database or spreadsheet. Each table consists of fields (columns), and each field holds a specific type of information.

​
Working with data

​
How to add database to your project.

Generally, Lumi will automatically analyze your needs and add this function when a database is required. You can also emphasize it in the prompt, such as “Create an orders management system with a database to store orders data.”

​
Manually add a record

4 Gi
1

Navigate to Your Table

Go to Workspace → Data and select the table you want to add data to.
2

Add a New Record

Click the “Add” button and fill in the fields for the new record.
Tip: For a more user-friendly experience, you can ask the chat to build a form within your app, allowing you to add new items dynamically.

​
Manually edit a record

5 Gi
1

Navigate to Your Table

Go to Workspace → Data and select the table containing the record you wish to edit.
2

Edit the Record

Click the ✒️ Pen icon for the desired record and make your changes.

​
Deleting and batch operations

  • To delete a single record
6 Gi
1

Navigate to Your Table

Go to Workspace → Data and select the table containing the record you wish to delete.
2

Delete the Record

Click the 🗑 Trash Bin icon for the record you want to delete.
  • To make a batch deletion
7 Gi
1

Navigate to Your Table

Go to Workspace → Data and select the table from which you want to delete records.
2

Select and Delete Records

Select the checkboxes for the records you want to remove, then click the “Delete” button that appears near the selection count.
Warning: Be careful that deletion is irreversible

​
Supported field types

  1. Basic Data Types
  • String: A UTF - 8 encoded string used to store text data.
  • Integer: Includes 32 - bit and 64 - bit integers for storing integer values.
  • Double: 64 - bit floating - point numbers for storing decimal numbers or large numbers.
  • Boolean: Stores logical values true or false.
  • Null: Represents a null value or a non-existent field.
  1. Complex Data Types
  • Array: An ordered collection of elements that can contain different types of data.
  • Object (Embedded Document): A collection of key-value pairs that supports nested structures.
  • Date: Stores date and time represented as UTC milliseconds.
  1. Special Data Types
  • ObjectId: A 12 - byte unique identifier, used by default for the _id field of a document.
  • Binary Data: Stores binary data (such as images, files).
  • Regular Expression: Stores regular expressions for text matching.
  • JavaScript: Supports storing and executing JavaScript code.
  1. Extended Data Types
  • Timestamp: A 64 - bit timestamp where the first 32 bits are seconds and the last 32 bits are nanoseconds, used to record operation times.
  • Decimal128: A 128-bit high-precision decimal number, suitable for financial calculations.
  • GeoJSON: Stores geospatial data.

​
Security and table premissions

Each table includes its own security settings to control data access:
  • Read Access: Defines who is permitted to view the records within the table.
  • Write/Delete Access: Determines who can create, update, or delete records.
Image(44) Pn