Backend Studio: Visual Database Schema Builder & Instant REST APIs

const BASE_URL = 'https://apps-manager.in';
const APP_PUBLIC_ID = 'app_pub_789456';
const API_KEY = 'am_key_live_xxx';

const headers = {
  'Authorization': `Bearer ${API_KEY}`,
  'Content-Type': 'application/json',
};

// 1. Create a record
async function createProduct(productData: { title: string; price: number; inStock: boolean }) {
  const res = await fetch(`${BASE_URL}/apps/${APP_PUBLIC_ID}/db/products`, {
    method: 'POST',
    headers,
    body: JSON.stringify(productData),
  });
  return res.json();
}

// 2. Query with filtering, search, and pagination
async function queryProducts(page = 1, searchQuery = '') {
  const params = new URLSearchParams({
    page: page.toString(),
    limit: '15',
    sortBy: 'price',
    order: 'asc',
    search: searchQuery,
  });

  const res = await fetch(`${BASE_URL}/apps/${APP_PUBLIC_ID}/db/products?${params}`, {
    method: 'GET',
    headers,
  });
  return res.json();
}

// 3. Update record by ID
async function updateProduct(id: string, updates: Partial<{ price: number; inStock: boolean }>) {
  const res = await fetch(`${BASE_URL}/apps/${APP_PUBLIC_ID}/db/products/${id}`, {
    method: 'PUT',
    headers,
    body: JSON.stringify(updates),
  });
  return res.json();
}

import requests

BASE_URL = "https://apps-manager.in"
APP_PUBLIC_ID = "app_pub_789456"
API_KEY = "am_key_live_xxx"

headers = {
    "Authorization": f"Bearer {API_KEY}",
    "Content-Type": "application/json"
}

# Create a new document
item_data = {
    "title": "Wireless Gaming Mouse",
    "price": 79.99,
    "inStock": True
}
response = requests.post(
    f"{BASE_URL}/apps/{APP_PUBLIC_ID}/db/products",
    json=item_data,
    headers=headers
)
created_item = response.json()
print("Created document ID:", created_item["data"]["_id"])

# Query products with filtering
query_params = {
    "page": 1,
    "limit": 10,
    "sortBy": "createdAt",
    "order": "desc"
}
list_res = requests.get(
    f"{BASE_URL}/apps/{APP_PUBLIC_ID}/db/products",
    params=query_params,
    headers=headers
)
print("Fetched documents:", list_res.json()["data"])