Systems | Development | Analytics | API | Testing

Community project showcase: an Ably-Postgres connector to stream DB changes to millions of clients in realtime

Built by our long-time community expert Apoorv Vardhan, the Ably-Postgres connector can listen to changes in a Postgres table and publish realtime messages on Ably channels whenever a change occurs. The connector enables building database-driven realtime applications where long-term storage and update triggers from previously published messages are essential. One such example is an editable chat app, which we’ll talk about later in this article.

How to connect Mongo DB to Heroku Postgres

Every computer application must have a method of storing, managing and using data. This requires an application and at least one database that can communicate with each other. Managing this connection can be difficult, especially with multiple databases. Fortunately, there are platforms that can manage databases and connections applications more efficiently. Heroku offers a Postgres management system for creating, managing, and using databases.

What is eventual consistency and why should you care about it?

Distributed systems have unlocked high performance at a large scale and low latency. You can run your applications worldwide from the comfort of your Amazon Web Services (AWS) platform in California, but the user adding an item to their shopping cart in Japan will not notice any delay or system faults. However, distributed systems - and specifically distributed database systems - also malfunction.

Securing Your SQL Server Application: Enabling Client-Initiated Encrypted Connections

In the previous article we discussed how to enable a server initiated encrypted connection to a Microsoft SQL Server. But what if we have a scenario where we do not want to incur the overhead of encryption for every application? In that scenario instead of configuring the server to force encryption we will instead need the client to initiate the encrypted connection.