Designing Your Database with Swiftybase

Designing a database is one of the foundational steps when building your backend. With Swiftybase, you can easily design and deploy your database directly through the UI, making it seamless to define tables, set relationships, and structure your data effectively.

Key Steps in Database Design

1. Define Your Tables
   Start by creating tables that represent entities or collections in your application. Each table can have a set of columns that define the properties of those entities. Swiftybase provides a user-friendly interface where you can create and manage tables without needing to write SQL queries manually.

2. Set Relationships
   Tables are often related to each other. Swiftybase makes it easy to define relationships between tables, such as one-to-many or many-to-many relationships, without the complexity of raw SQL commands. You can visually design these relationships and ensure that data integrity is maintained.

3. Create Custom Data Models
   After setting up tables and relationships, you can define custom data models to work with in your application. Swiftybase supports generating models that you can use in your function stack, ensuring that your data is type-safe and structured.

Deploying Database Changes

Once you’ve designed your database schema, you can deploy the changes to a PlanetScale database. Swiftybase integrates with PlanetScale, a scalable and reliable MySQL-compatible database, to ensure that your data is stored and managed securely.

1. Deploy Changes
   After creating or modifying tables in the Swiftybase UI, you can deploy the changes to your database with a single click. The deployment process automatically syncs the updates to your connected PlanetScale database.

2. Revert Changes in Case of Failure
   If something goes wrong or if you want to undo a change, Swiftybase allows you to easily revert the changes. This ensures that you can safely experiment and iterate on your database design without the fear of losing critical data.

Deploying API Changes After Database Updates

In Swiftybase, database changes and API updates are tightly connected. After deploying your database changes, you can deploy your APIs. This ensures that your database schema is in sync with your API endpoints, so that any changes to the data model are reflected in the API responses.

1. API Deployment
   Once your database is updated and deployed successfully, you can proceed to deploy your API. This deployment will automatically reflect the updated database structure, and your APIs will work with the latest data models.

2. Consistency Between Database and API
   The integration between database changes and API deployment ensures consistency. You won't need to manually update your API to reflect changes in your data models. Swiftybase takes care of it, streamlining your workflow.