Serverless Databases

​

Key Features

​

Supported Database Types

• PostgreSQL: A robust, scalable database solution ideal for structured data and complex queries.
• MongoDB: A managed NoSQL database designed for unstructured data, supporting flexible schemas and JSON-like documents.

​

PostgreSQL

• Serverless architecture with built-in scaling.
• Supports advanced query capabilities.
• Fully managed backup and performance optimization.

​

MongoDB

• Fully managed instances.
• Integrated Movestax MongoDB Explorer for seamless data management.
• Flexible schema and horizontal scaling for modern applications.

​

How to Set Up a Database

1. Navigate to Database Setup:
   • Go to your Project Dashboard.
   • Select Databases from the sidebar.
   • Click on Create New Database.
2. Choose Database Type:
   • Select either PostgreSQL or MongoDB.

​

For PostgreSQL:

• Enter a secure password for your database.
• Your PostgreSQL instance will be created with:
  • Default User: postgres
  • Database Name: postgres
  • Default Port: 5432
  • Password Authentication: Enabled
  • TLS Encryption: Enabled
• Important: Store your password securely, as it will be required to connect to the database. If lost, you will need to contact Movestax support for a reset.

​

For MongoDB:

• Enter a username and password to secure your instance.
• You will receive a connection string in the format: mongodb://[username]:[password]@deploymentid.mongodb.movestax.app
• Note: Movestax does not store your password. If you lose it, you must contact support for a reset.

1. Finalize Setup:
   • Click Create Database to complete the setup process.
   • Access connection details directly in the dashboard.

​

Managing Your Databases

​

PostgreSQL Management:

• Access:
  • Navigate to Project Dashboard > Databases.
  • Select the PostgreSQL database you wish to manage.
• Features:
  • View and edit tables, functions, triggers, and indexes.
  • Perform backups (SQL export only).
  • Run vacuum and analyze commands for optimization.
  • Monitor performance metrics.

​

PostgreSQL Connection Options

• Direct Connection Ideal for applications with persistent, long-lived connections, such as those running on virtual machines or long-standing containers. postgresql://postgres.deploymentid:[YOUR-PASSWORD]@postpool.movestax.app:5432/postgres
• Transaction Pooler Ideal for stateless applications like serverless functions where each interaction with Postgres is brief and isolated. postgresql://postgres.deploymentid:[YOUR-PASSWORD]@postpool.movestax.app:6543/postgres
• REST API RESTful interface for your PostgreSQL database. Use standard HTTP methods to interact with your data. API URL: https://deploymentid.postrest.movestax.app API Key: [YOUR-DATABASE-API-KEY]

​

MongoDB Management:

• Access:
  • Navigate to Project Dashboard > Databases.
  • Select the MongoDB database you wish to manage.
• Options:
  • Use MongoDB Compass with the provided connection string.
  • Manage data directly using the Movestax MongoDB Explorer.
• Features:
  • Create, view, and manage databases, collections, and documents.
  • Import/export data in JSON or CSV format.
  • Visualize schema and indexes.
  • Perform aggregations, filters, and updates directly within the Movestax interface.

​

Backup and Restore

​

PostgreSQL:

• Backups are available as .sql exports.
• Navigate to Project Dashboard > Databases, select your database, and click on Backup.

​

MongoDB:

• Export collections in JSON or CSV format via the Movestax MongoDB Explorer.
• Import data using supported .json files.

​

Important Notes

• Passwords:
  • Movestax does not store database passwords. Ensure you store them securely.
  • Contact support if you require a password reset.
• Limits:
  • Database instances are limited based on your plan.
  • PostgreSQL is available as a serverless instance, while MongoDB is provided as a managed service.

​

Plans and Availability

​

Stay Updated