🗄️ Database

PostgreSQL-compatible SQL database. 50× faster with lock-free MVCC.

Quick Start

Using psql

# Connect (use API key as password)
psql -h api.44s.io -p 5432 -U user -W

# Create a table
CREATE TABLE users (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(255) UNIQUE,
    created_at TIMESTAMP DEFAULT NOW()
);

# Insert data
INSERT INTO users (name, email) VALUES 
    ('Alice', 'alice@example.com'),
    ('Bob', 'bob@example.com');

# Query
SELECT * FROM users WHERE name LIKE 'A%';

# Update
UPDATE users SET name = 'Alice Smith' WHERE id = 1;

# Delete
DELETE FROM users WHERE id = 2;

Python

import psycopg2

# Connect
conn = psycopg2.connect(
    host='api.44s.io',
    port=5432,
    user='user',
    password='44s_your_api_key',
    database='default'
)

cursor = conn.cursor()

# Create table
cursor.execute('''
    CREATE TABLE IF NOT EXISTS products (
        id SERIAL PRIMARY KEY,
        name VARCHAR(100),
        price DECIMAL(10,2),
        stock INT
    )
''')

# Insert
cursor.execute(
    "INSERT INTO products (name, price, stock) VALUES (%s, %s, %s)",
    ('Widget', 29.99, 100)
)

# Query
cursor.execute("SELECT * FROM products WHERE price < %s", (50,))
for row in cursor.fetchall():
    print(row)

conn.commit()
conn.close()

Node.js

const { Pool } = require('pg');

const pool = new Pool({
  host: 'api.44s.io',
  port: 5432,
  user: 'user',
  password: '44s_your_api_key',
  database: 'default'
});

// Query
const result = await pool.query(
  'SELECT * FROM users WHERE created_at > $1',
  [new Date('2024-01-01')]
);
console.log(result.rows);

// Transaction
const client = await pool.connect();
try {
  await client.query('BEGIN');
  await client.query('UPDATE accounts SET balance = balance - $1 WHERE id = $2', [100, 1]);
  await client.query('UPDATE accounts SET balance = balance + $1 WHERE id = $2', [100, 2]);
  await client.query('COMMIT');
} catch (e) {
  await client.query('ROLLBACK');
  throw e;
} finally {
  client.release();
}

HTTP API

Execute SQL over HTTP when you don't want to use PostgreSQL drivers.

curl -X POST https://api.44s.io:8600/sql \
  -H "Content-Type: application/json" \
  -H "X-API-Key: 44s_your_api_key" \
  -d '{"sql": "SELECT * FROM users LIMIT 10"}'

# Response
{
  "success": true,
  "columns": ["id", "name", "email", "created_at"],
  "rows": [
    {"id": 1, "name": "Alice", "email": "alice@example.com", "created_at": "2024-01-15T10:30:00Z"},
    {"id": 2, "name": "Bob", "email": "bob@example.com", "created_at": "2024-01-15T11:00:00Z"}
  ],
  "rows_affected": 2
}

curl https://api.44s.io:8600/tables \
  -H "X-API-Key: 44s_your_api_key"

# Response
["users", "products", "orders"]

Supported SQL

Data Definition

Data Types

Queries

Transactions

Full ACID transactions with MVCC (Multi-Version Concurrency Control):

BEGIN;

-- Multiple operations
UPDATE accounts SET balance = balance - 100 WHERE id = 1;
UPDATE accounts SET balance = balance + 100 WHERE id = 2;
INSERT INTO transfers (from_id, to_id, amount) VALUES (1, 2, 100);

-- Commit or rollback
COMMIT;
-- or ROLLBACK;

Performance

Performance gains from lock-free B+Tree indexes and MVCC implementation.