Question 1

How does Bemi compare to using PostgreSQL triggers for audit logging?

Accepted Answer

Bemi is more reliable and non-invasive since it uses the WAL for 100% change capture without performance hits or schema changes, but it requires additional infrastructure compared to triggers, which are simpler but can impact performance.

Question 2

How to set up Bemi with a Node.js application using an ORM?

Accepted Answer

Install the Bemi ORM package for your framework (e.g., Prisma or Sequelize) from the docs, configure it to send context, and ensure your PostgreSQL database has logical WAL enabled and REPLICA IDENTITY FULL set on tracked tables.

Question 3

Does Bemi work with managed PostgreSQL services like AWS RDS?

Accepted Answer

Yes, but you must enable logical replication (wal_level = logical) on the PostgreSQL instance and set proper permissions for CDC, as noted in the system dependencies section.

Question 4

What is the latency for change tracking with Bemi?

Accepted Answer

Changes are captured asynchronously from the WAL, typically within seconds, but this depends on the Bemi worker configuration and messaging system load, as it uses NATS JetStream for processing.

Question 5

Can Bemi be used for real-time data streaming?

Accepted Answer

Yes, Bemi implements CDC and streams changes in real-time via NATS JetStream, supporting use cases like live dashboards or event-driven architectures without altering your database schema.

Question 6

Is Bemi truly open-source and what are the licensing implications?

Accepted Answer

Bemi is licensed under SSPL-1.0, which requires that if you modify and distribute the software, you must open-source the entire service, similar to MongoDB's license, potentially affecting commercial deployments.

bemi

What is bemi?

Overview

Use Cases

Best For

Related Projects

Found a gem we're missing?

Not Ideal For

Pros & Cons

Pros

Cons

Frequently Asked Questions