Materialize connection examples

Materialize is a streaming database for real-time applications. It is wire-compatible with PostgreSQL, which means that you can connect to a Materialize instance using your favorite client libraries, ORM frameworks and other third-party tools that support PostgreSQL.

This repo is a collection of reference examples for common language-specific PostgreSQL drivers and PostgreSQL-compatible ORMs that have been tested with Materialize.

Client libraries and Frameworks

• PHP
• NodeJS
• TypeScript
• Deno
• Java
• Python
  • FastAPI
• Ruby
• Go
• Lua
• Rust

Helpful resources:

• CREATE SOURCE - syntax for creating new connections to upstream data sources.
• CREATE MATERIALIZED VIEW - syntax for creating an incrementally updating materialized view.
• SELECT - syntax for querying materialized views.
• SUBSCRIBE - syntax for subscribing to changes in a materialized view or query via a long-lived PostgreSQL transaction.
• Materialize Demos

Getting support

If you run into a snag or need support as you explore the examples in this repo, join the Materialize Slack community or open an issue!