Apibara blog

News and updates about Apibara

PostgreSQL indexers improvements

This week we release two improvements to PostgreSQL indexers.

This new release adds support for batching writes to Postgres. This changes follow the MongoDB changes described in the previous changelog. Developers can use the --batch-seconds flag to flush data to PostgreSQL at the provided interval, reducing the number of writes to the database. Notice this behavior is used only for finalized blocks, live blocks will always be flushed to database as they are produced.

The PostgreSQL sink has now a new uniqueColumns: boolean option to control how insert conflicts are handled. If the flag is true, the insert query will ignore any conflict.


Apibara is the fastest platform to build production-grade indexers that connect onchain data to web2 services.

© 2024 GNC Labs Limited. All rights reserved.