PostgreSQL Database Integration API Starter

The PostgreSQL Database Integration API Starter demonstrates how effortlessly developers can create APIs in RAW that connect to PostgreSQL Database instances and execute SQL queries. This template is designed for both individual developers and teams who want a hands-on introduction to RAW's PostgreSQL Database integration capabilities, making it a simple starting point for building APIs that interact with custom database schemas. It is ideal for:

• Developers building APIs that connect to PostgreSQL Database instances.
• Developers who want to use SQL queries to access and manipulate data from their PostgreSQL Database.
• Teams needing to build APIs quickly that interact with PostgreSQL Database schemas.

This starter includes prebuilt endpoints that demonstrate RAW’s PostgreSQL Database integration features. It uses a placeholder SQL query to simulate database interaction, which can be easily replaced with custom SQL queries for live use cases. It includes:

• Prebuilt Queries: Includes examples for retrieving data, with a default query built-in.
• Query Parameters: Provides the ability to add and customize query parameters for dynamic data retrieval.
• Integration Flexibility: Seamlessly customize SQL queries to access tables and views from your PostgreSQL Database.

What You Get

By deploying this template, you’ll receive:

With this starter, you’ll receive:

• ‍Ready-to-Use REST API: A fully deployed API within your RAW account, complete with working data endpoints.‍
• Sample Data Endpoints: Example endpoints showcasing various capabilities.‍
• Integrated Development Environment:‍
  • Modify the source code of each API endpoint easily.
  • Create new endpoints, view, test, and debug them quickly.
  • Add metadata to your API, and export it as an OpenAPI catalog for easy development of client applications.
  • And much more, including security, team collaboration features, etc.
• ‍And It's Free! The template is free to use and deploy.‍

‍How to Get Started

1. Deploy the API:‍
   • Click the “Get Started” button to deploy the template.
   • If you don’t have an account, you’ll be prompted to create one for free. Deployment and account setup are seamless—just one click away!‍
2. Explore the API:‍
   • Access your API immediately inside the RAW application.
   • View endpoint details and invoke them directly to see how they function.‍
3. Customize as Needed:‍
   • Modify the API to suit your requirements!
   • Once you’re satisfied, re-publish the changes to make your new mock API available instantly.

The source code for this template is available on GitHub.

‍