39 results for “topic:materialized-views”
The Feldera Incremental Computation Engine
The database purpose-built for stream processing applications.
Distributed immutable data store with strong encryption and authentication
Advanced Database Management System ( PL/SQL )
Instant Search for Rails and ActiveRecord using SQL materialized views
Incremental view maintenance & query rewriting for materialized views in DataFusion
Postgres full-text search in Node.js and Sequelize.
:books: Manage SQL entities in Laravel with ease!
Event Sourcing(CQRS) and Materialized views with Kafka Streams
A full sample that shows how to implement real-time updated Materalized Views with CosmosDB, Change Feed and Azure Functions
CrateDB Toolkit, an SDK for CrateDB and CrateDB Cloud.
An example use case of pg-search-sequelize node library
A PostgreSQL extension for streaming tables with incremental view maintenance, powered by differential dataflow in Rust.
Refresh PostgreSQL materialized views in the correct order (topologically sorted)
This workshop aims to make use of airlines data set that is publicly available and showcase how one can make use of CDW for Open Data Lakehouse using Apache Iceberg.
Basic webapp to materialize questions in Metabase
Helpers for using database views in ActiveRecord
A spectral ClickHouse analyzer that tracks which tables are actually used and by whom. Maps queries to IPs/K8s services, flags dead tables and orphaned MVs, and helps keep your cluster clean and intentional.
This is a comprehensive loot generation system built for Re:Armed, a loot-driven multiplayer game. The system demonstrates enterprise-level architecture with PostgreSQL database integration, materialized views for performance optimization, and a sophisticated procedural generation algorithm.
Star-schema data mart on PostgreSQL built from Goodbooks CSVs. Demonstrates advanced SQL (window functions, JSONB, GROUPING SETS), indexes (covering/partial/GIN/pg_trgm), materialized views, incremental MERGE loads, pgTAP tests, and GitHub Actions CI. Includes Docker quickstart and SSH-tunnel instructions
Specification and methodology for building Analysis-Ready Datasets (ARDs) — pre-computed, enriched data products that eliminate repetitive preprocessing and enable immediate analysis. Domain-agnostic framework with reference implementations.
A project to master database views and materialized views in SQL for creating virtual tables, managing data snapshots, and implementing business logic through view-based data transformations.
Curso de PostgreSQL - Bancos de Dados
Node.js & TypeScript production-ready app demonstrating how modern PostgreSQL can replace Redis, queues, schedulers, search engines, vector databases, and more using built-in features and extensions. Learn Postgres as an application platform, not just a database. Here I explained core concepts. Will add more to it...
Built a MySQL DB from scratch for the purpose of serving football stat api
Accompanies a C# Corner article (URL TBD, stay tuned!)
Bachelor thesis on query optimization for Business Intelligence systems. Analysis of ETL, physical design (indexing, partitioning, compression, caching), and materialized views on SQL Server and Azure Synapse. Includes SQL scripts and TPC-DS evaluations.
No description provided.
Provide type-safe StarRocks access in TypeScript with schema DSL, transactions, streaming load, query building, and migration support.
📊 Analyze ClickHouse usage to uncover table relationships, discover safe cleanup options, and generate insightful visual reports effortlessly.