Sync all your GitHub data to your Postgres database in real-time. Query your Pull Requests, Issues, and Commits with SQL or your ORM. And insert
, update
, or delete
GitHub records in both GitHub and your database simultaneously.
psql
command to connect to your database via the Proxy.
Step 2: Open your terminal, and paste the psql
command. Press Enter. This will open a connection to your database so you can write your first query:
\dt
:
_sync_cdc
table which Sequin uses to manage your sync.
Step 4: Now, write your first query. You can start with a simple select
to get your bearings:
id
, title
, state
, and repository_id
for a specific pull request:
id
for this issue in the last step of this guide.
insert
, update
, or delete
rows in your Postgres database.
When you’re connected to your database through the Sequin Proxy, the Proxy listens for changes. When you make a mutation, the Proxy applies the mutation to GitHub’s API first. If the mutation succeeds, your database is updated as well. If it fails, your database mutation will be rolled back, and you’ll receive a Postgres error.
In this example, you can update the issue
in the prior step by giving it a new state:
closed_at
.