It's a HUGE month here at Alooma! We're releasing some long-anticipated new features, and we couldn't be more excited. Read on!

PostgreSQL CDC replication

Not all data is the same, and different types of data need optimized handling. That's why we support 3 data replication methods for databases, where CDC ("Change Data Capture") aka "log replication", is by far the fastest and most complete.

MySQL, Oracle, and MongoDB already support CDC replication, and now we're excited to bring PostgreSQL into the fold. For on-prem and RDS-hosted PostgreSQL you can now select "log replication" as the replication type in the UI. We'll then rely on PostgreSQL's internal WAL mechanism to get real-time events on insert, updates, and deletes. To try it for yourself, check out our guidance on adding a PostgreSQL input, or contact us if you have any questions!

Pause inputs

If you've ever found yourself wishing you could give an input a break - because you want to take it down, limit queries on it, or any other reason - now's your chance with pause inputs. Just click the "Pause input" button in the top right of an input page, and we'll stop running queries on that input.

When you resume the input, we'll pick up right where we left off, so you never lose an event. Keep in mind that the longer an input is paused, the longer it could take us to catch up!

Also note, for inputs configured to replicate via log replication like MySQL, PostgreSQL, Oracle, or MongoDB, if the input is paused for too long we may lose log position. This would mean we'd need to redump your tables, so that's something to be aware of. One more thing! This feature is not available for SDKs, Mixpanel or Localytics.

So go forth and pause! Resume! Pause! Resume! You get the idea...

Code modules in UI

Our customers write some pretty awesome code in the Code Engine to perform some powerful logic. The more code they write, however, the more difficult it becomes to manage. Customers can manage that code via separate modules, but till now that's only been available through the API.

As of this release, you can manage your code in modules through the Code Engine screen. Open existing modules, create new ones, edit and delete, all right there in the UI. And of course, any changes you make and then test on a sample event will all be run as part of the test. Once you're done, just deploy and everything will be handled on the backend.

We hope this makes your coding experience in Alooma even smoother!

Other improvements

We've continued rolling out our new and improved inputs redesign, now prettifying and adding inline help to Google Analytics, Google Adwords, Salesforce, Zendesk, and Zuora. Nice!

Our fancy newly designed storage inputs (S3, Azure, Box, and Google Drive) now also support the Avro file type.

We improved the experience of expanding an event column in the Restream Queue page to preserve the other column sizes... cause they were getting squished, and that's awkward.