Build data-intensive applications and services in SQL — without pipelines or caches — using materialized views that are always up-to-date.
Materialize is a source-available streaming database written in Rust that maintains the results of a SQL query (a materialized view) in memory as the data changes. Whereas a traditional database does the evaluation when a SELECT statement is issued, Materialize asks for queries up-front and incrementally computes results as new data arrives.
Reads in Materialize are fast, scalable, and computationally free, enabling ‘reactive’ architectures where updates are pushed to clients, not polled.
Build Applications
Application developers use Materialize as a “live cache” to build and deploy data-intensive applications. Use Materialize as a pure-SQL Redis for a scalable, easily-maintained architecture.
Build with Streams
Data engineers use Materialize as a stream processor to build real-time data pipelines. Explore, query, join, and transform streams, and push data downstream to a Kafka sink.
Build Analytics
Analytics engineers use Materialize as a streaming database to go beyond dashboards to building live services. Move from batch to streaming production – all using existing SQL and tools like dbt.
Materialize uses structured data (events) as inputs. Events can come from message brokers like Kafka, change feeds of databases like PostgreSQL, or archived events from S3.
At its core, Materialize is an engine that parses SQL (joins, aggregations, transformations, computations) into dataflows, and then processes input events in order to maintain the results as an in-memory view.
Materialized views can be queried with the semantics of PostgreSQL and latency of Redis. Alternatively, updates can be streamed out, either directly into applications or as change events to Kafka.
Learn the Basics
Deep Dive into a use case:
Materialize is a source-available binary which you can install on macOS and Linux, or build on most OSes (e.g. FreeBSD). When you’re ready to move into production, Materialize Cloud hosts and maintains Materialize deployments for you, automating administration tasks like hardware provisioning, database setup, upgrades, and backups. Sign up for an account in less than 30 seconds.
Join hundreds of other Materialize users and connect directly with our engineers. Learn from our community, get help with your implementation, and let us know what you think! We’d love to hear from you.
Join our Slack Community
Josh Arenberg
Director of Engineering, DatalotStreaming data can really revolutionize this business by taking analytics that are embedded in summary tables and exposing them in a way where they can become signals that can drive other services. The vision is moving from observability of data to automation of business processes. Materialize means this can happen very quickly.
Jean-Francois Perreton
Head of Algo Quant, Kepler CheuvreuxOnce we found Materialize we were very happy because it was proper SQL and we actually are big users internally of Postgres already. One of the biggest selling points of Materialize was the fact that it offers JDBC drivers and a regular PostgreSQL facade, if you want. So it directly integrates with our third-party applications, BI tools, you name it.
Eric Dodds
Head of Growth, RudderstackAnalytics is a really obvious use-case for Materialize, but all the interesting things you can do when you enable real-time will open up a lot of creative solutions to problems that are low level plumbing problems in the stack currently – and that’s very exciting.
Tyler Richie
Co-founder and CTO, SproutfiWhat we found is that we were trying to specify data models not based on what we thought was the most correct, but what would avoid joins the most. With Materialize, this is no longer the case.
Emily Hawkins
Data Infrastructure Lead, DrizlyWorking with Materialize has been an incredibly seamless process as we can continue to write real-time SQL, exactly the same way as we already are in Snowflake with batch, so it was a much lower barrier to entry.
Ryan Gaus
Staff Software Engineer & Technical Lead, DensityWe’ve saved I-don’t-know-how-many untold quarters of trying to build our own thing.
Metabase community stories This blogpost was originally contributed to the Metabase community blog. In a previous post, we broke down how to...
Materialize allows you to frame SQL queries against continually changing data, and it will compute, maintain, and serve the answers even as ...
Data Apps describes the new wave of cloud data warehouse (CDW) consumers that build applications directly on top of the CDW. From practitio...
Materialize is a different kind of database: on the surface it presents as Postgres, but internally it maintains the results of a query as a...
Register for early access to start building real-time analytics dashboards and live applications.
What is Materialize?
Stay up to date with the latest Materialize news and developments.
