From: | Synthesized via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org> |
---|---|
To: | PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org> |
Subject: | Synthesized TDK. Populating Test Environments with Production-Like Data |
Date: | 2023-09-27 09:41:53 |
Message-ID: | 169580771373.3727336.15635424504004199795@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-announce |
TDK provides an advanced solution for populating test environments with data that closely resembles production data, with a focus on safety and security. This solution enhances and automates the various features offered by PostgreSQL, enabling data generation, masking, and transformation using SQL and third-party extensions. We have previously discussed this topic in detail in our article [here](https://www.synthesized.io/post/test-data-generation-there-and-back).
## Key features
- **Data generation**, if you do not have enough production data in the test environment - this will allow you to test your applications, including functional and loading tests
- **Subsetting** - creating a small slice of data from a large production database while preserving all data relations and properties
- **Masking** - allows you to test, analyze, and share your production data securely
## Try it
You can try TDK for free by downloading the tool from [this](https://docs.synthesized.io/tdk/latest/download/) page. Follow the instructions for [Installation](https://docs.synthesized.io/tdk/latest/user_guide/getting_started/installation) and [Getting started](https://docs.synthesized.io/tdk/latest/user_guide/getting_started/your_first_transformation). Additionally, there are other installation and usage options for TDK:
- [Docker image](https://docs.synthesized.io/tdk/latest/user_guide/deployment/run_cli_with_docker)
- [Helm chart](https://docs.synthesized.io/tdk/latest/user_guide/deployment/run_cli_with_helm)
- [Amazon Web Services](https://aws.amazon.com/marketplace/pp/prodview-qniisetx55ofg)
- [Google Cloud Platform](https://console.cloud.google.com/marketplace/product/synthesized-marketplace-public/synthesized-tdk)
## Demo projects
We have various demo projects with different levels of complexity to provide a simpler way to start using TDK in your environments:
- **[tdk-demo-postgres](https://github.com/synthesized-io/tdk-demo/tree/main/postgres)** - Try TDK in action with legendary Pagila sample database
- **[tdk-demo-vault](https://github.com/synthesized-io/tdk-demo/tree/main/vault) -** The simple demo with Hashicorp Vault as a secret manager to store and manage database credentials
- **[tdk-demo-oracle](https://github.com/synthesized-io/tdk-demo/tree/main/oracle)** - Masking data in an Oracle database and converting it to a PostgreSQL database
- **[springjdbc-tc-tdk](https://github.com/synthesized-io/springjdbc-tc-tdk) -** The simple Java application with TDK and Test Containers for integration testing
- **[flyway-spawn-demo](https://github.com/synthesized-io/flyway-spawn-demo)** - Testing Flyway database migrations
- **[tdk-microservices-demo](https://github.com/synthesized-io/tdk-microservices-demo)** - The example of using TDK in a distributed SOA application
## Supported platforms
TDK supports not only classical PostgreSQL, but also various Postgres-based platforms and distributions, including:
- GCP Cloud SQL for PostgreSQL
- Amazon RDS for PostgreSQL
- Heroku Postgres
- Yugabyte
- Supabase
- Timescale
## Contacts and Feedback
If you have any questions, suggestions, or ideas, please feel free to send them to us [here](https://www.synthesized.io/contact-sales).
From | Date | Subject | |
---|---|---|---|
Next Message | Toshiba via PostgreSQL Announce | 2023-09-28 21:15:23 | SQLite FDW 2.4.0 released |
Previous Message | Stormatics via PostgreSQL Announce | 2023-09-25 18:58:05 | Announcing the release of v1.0 of pg_cirrus - Hassle-free PostgreSQL cluster set up |