demos

demos copied to clipboard

Our connection examples should show comprehensive connection options, like cluster, schema, transaction isolation, and application name. Application name is especially helpful in tandem with the new Query History feature in...

chuck-alt-delete

Connection examples: SQLalchemy boilerplate

1

Here is some basic boilerplate for connecting to Materialize via SQLalchemy. ```python from sqlalchemy import create_engine, text from sqlalchemy.orm import sessionmaker from dotenv import dotenv_values from pathlib import Path from...

chuck-alt-delete

I'm running a [Streamlit application](https://github.com/joacoc/stripe-streamlit/blob/main/main.py) using `SUBSCRIBE`, and it crashes after 985 updates. ``` 2023-11-27 10:30:58.326 Uncaught app exception Traceback (most recent call last): File "/home/adminuser/venv/lib/python3.9/site-packages/streamlit/runtime/scriptrunner/script_runner.py", line 534, in _run_script...

joacoc

In addition to the updated [Debezium v2.x documentation](https://github.com/MaterializeInc/materialize/pull/22434) I decided to also add a simple hands-on example so people could also have it as a reference along side the documentation...

bobbyiliev

ENVELOPE UPSERT makes it much easier to work with subscribes. Can we update our connection-examples to use this instead of the custom state management they currently do?

chuck-alt-delete

Create a schema.sql shortcut file

5

Sometimes I want to just create all the sources, views, matviews right away. I think it'd be nice to standardize by creating a `schema.sql` file for each demo that lets...

ruf-io

Hey team, I have two suggestions for the NodeJS subscribe example: 1. Our current example could be made much simpler with the use of the new `SUBSCRIBE ... ENVELOPE UPSERT...

chuck-alt-delete

Under the grafana and datadog integrations, we should have a query that lets people monitor OOMing clusters. We should be able to rig something up in Grafana with SUBSCRIBE mz_internal.mzcluster_replica_statuses...

chuck-alt-delete

Some diagrams are out of date, eg - mention deprecated `materialized` binary - show services running locally when the demo has been reworked to use cloud services

chuck-alt-delete

Using the existing [RDS Terraform module](https://github.com/bobbyiliev/terraform-materialize-rds) create a step-by-step demo on how to Setup a new RDS instance + Postgres connection in Materialize using the [Materialize Terraform Provider](https://github.com/MaterializeInc/terraform-provider-materialize).

bobbyiliev