orb_fdw 0.0.3

This Release
orb_fdw 0.0.3
Date
Status
Stable
Other Releases
Abstract
A foreign data wrapper for Orb
Description
A simple open-source data wrapper that bridges the gap between your Postgres database and [Orb](https://www.withorb.com/) a leading usage-based billing solution.
Released By
tembo
License
PostgreSQL
Resources
Special Files
Tags

Extensions

orb_fdw 0.0.3
A foreign data wrapper for Orb

Documentation

LICENSE
LICENSE

README

Orb_fdw

This is a simple open-source data wrapper that bridges the gap between your Postgres database and Orb a leading usage-based billing solution.

Static Badge PGXN version

Pre-requisistes

  • have the v0.0.3 of orb_fdw extension enabled in your instance

Create the foreign data wrapper:

sql create foreign data wrapper orb_wrapper handler orb_fdw_handler validator orb_fdw_validator;

Connect to clerk using your credentials:

sql create server my_orb_server foreign data wrapper orb_wrapper options ( api_key '<orb secret Key>')

Create Foreign Table:

Customers table

This table will store information about the users.

sql create foreign table orb_customers ( user_id text, organization_id text, first_name text, email text, stripe_id text, created_at text ) server my_orb_server options ( object 'customers' );

Subscriptions Table

This table will store information about the subscriptions.

sql create foreign table orb_subscriptions ( subscription_id text, organization_id text, status text, plan text, started_date text, end_date text ) server my_orb_server options ( object 'subscriptions' );

Invoices Table

This table will store information about the subscriptions.

sql create foreign table orb_invoices ( customer_id text, subscription_id text, organization_id text, status text, due_date text, amount text ) server my_orb_server options ( object 'invoices' );