Quix | Platforms and integrations: PostgreSQL Extensible

100% Python

No JVM, wrappers, DSL, or cross-language debugging. Quix provides a Python Streaming DataFrame API that treats data streams as continuously updating tables.

Rich stream processing features

Quix supports stateless and stateful operations, aggregations over hopping and tumbling windows, custom data processing functions, and exactly-once semantics.

Dependable at scale

Quix is scalable, highly available, and fault tolerant. It's optimized to process high-volume, high-velocity data streams with consistently low latencies.

How to consume PostgreSQL Extensible data with Quix

The PostgreSQL Extensible Telegraf plugin gathers customizable metrics from PostgreSQL, allowing for user-defined SQL queries to collect specialized database performance metrics

Quix is the Python stream processor, and it serves the following purposes:

Ingest messages from PostgreSQL Extensible
Process received messages
Send transformed data to destination systems (via Quix integrations) so it can be operationalized
Use data received from PostgreSQL Extensible to power real-time capabilities

Integration with PostgreSQL Extensible is achieved via Telegraf using the Quix Telegraf output plugin. This plugin allows Telegraf to collect data from PostgreSQL Extensible and forward it to Quix for real-time processing, analysis, and integration with downstream systems.

At InfluxData, we prioritize ‘time to awesome’ when developing InfluxDB, aiming to empower developers to quickly transition from beginners to experts and create impactful solutions. Quix perfectly aligns with this core value, offering an exceptional user experience and a seamlessly scalable platform right from the start.
‍
One of the features I appreciate the most is the built-in pandas DataFrame support. This functionality is invaluable for efficiently handling bulk transformations and enrichments of time series data within a multistage data pipeline, providing both power and simplicity.
‍
For those venturing into the realm of event streaming applications, or for anyone looking to construct a scalable task engine armed with Python’s power and flexibility for manipulating time series data, I wholeheartedly recommend Quix to the community.

Jay Clifford

Developer Advocate at InfluxData

Related resources

Get started with Quix

Explore Quix Cloud

Take a look around Quix Cloud and test out the platform for yourself in our open demo workspace.

Explore the platform

Discuss your use case

Talk with our team of experts to learn more about how companies are accelerating their product development with Quix.

Book a call

Integrate PostgreSQL Extensible with Quix

Process PostgreSQL Extensible data with Quix