pg_analytics

pg_analytics (formerly named pg_lakehouse) puts DuckDB inside Postgres. With pg_analytics installed, Postgres can query foreign object stores like AWS S3 and table formats like Iceberg or Delta Lake. Queries are pushed down to DuckDB, a high-performance analytical query engine. By transforming Postgres into a performant search and analytics engine, ParadeDB frees your team from the pain of scaling and syncing Elasticsearch.

Features

Advanced data aggregation functions
Optimized for performance with large datasets
Support for custom metrics and dimensions
Real-time analytics processing
Integration with PostgreSQL databases

Project Samples

Project Activity

See All Activity >

Follow pg_analytics

pg_analytics Web Site

Other Useful Business Software

Forever Free Full-Stack Observability | Grafana Cloud

Our generous forever free tier includes the full platform, including the AI Assistant, for 3 users with 10k metrics, 50GB logs, and 50GB traces.

Built on open standards like Prometheus and OpenTelemetry, Grafana Cloud includes Kubernetes Monitoring, Application Observability, Incident Response, plus the AI-powered Grafana Assistant. Get started with our generous free tier today.

Create free account

Rate This Project

User Reviews

Be the first to post a review of pg_analytics!

Additional Project Details

Operating Systems

Linux, Mac, Windows

Programming Language

Rust

Related Categories

Rust Graph Databases

Registered

2024-11-04

Similar Business Software

Stardog

With ready access to the richest flexible semantic layer, explainable AI, and reusable data modeling, data engineers and scientists can be 95% more productive — create and expand semantic data models, understand any data interrelationship, and run federated queries to speed time to insight....

See Software
PuppyGraph

PuppyGraph empowers you to seamlessly query one or multiple data stores as a unified graph model. Graph databases are expensive, take months to set up, and need a dedicated team. Traditional graph databases can take hours to run multi-hop queries and struggle beyond 100GB of data. A separate...

See Software
KgBase

KgBase, or Knowledge Graph Base, is a collaborative, robust database with versioning, analytics & visualizations. With KgBase, any community or individual can create knowledge graphs to build insights about their data. Import your CSVs and spreadsheets, or use our API to work on data together....

See Software
ApertureDB

Build your competitive edge with the power of vector search. Streamline your AI/ML pipeline workflows, reduce infrastructure costs, and stay ahead of the curve with up to 10x faster time-to-market. Break free of data silos with ApertureDB's unified multimodal data management, freeing your AI...

See Software
RushDB

RushDB is an open-source zero-configuration graph database that instantly transforms JSON and CSV into a fully normalized, queryable Neo4j graph - without the overhead of schema design, migrations, or manual indexing. Designed for modern applications, AI, and ML workflows, RushDB provides a...

See Software
ArcadeDB

ArcadeDB is an open-source, next-generation multi-model database. Forget Polyglot Persistence — store graphs, documents, key-value pairs, search engine indexes, vectors, and time-series data all in one database with native support for every model. No translation layers, no performance...

See Software

Report inappropriate content

pg_analytics

DuckDB-powered analytics for Postgres

Get an email when there's a new version of pg_analytics

Features

Project Samples

Project Activity

Categories

Follow pg_analytics

User Reviews

Additional Project Details

Operating Systems

Programming Language

Related Categories

Registered