akartasov

5 ms·

1.
by akartasov 5y ago
It's also a great tool. However, as far as I know, Testcontainers just manages container-based dependencies but doesn't prepare the data in any way.
2.
by akartasov 5y ago
There are several ways to process PII for use in the Database Lab, including masking and data obfuscation. The main approaches can be found here: https://postgres.ai/docs/database-lab/masking .
3.
by akartasov 5y ago
Absolutely agreed. In addition, I know some Data Scientists who use thin clones from Database Lab to get data at a specific time for their models
4.
by akartasov 5y ago
There are several public Case Studies of real users (from small teams to quite large companies): https://postgres.ai/resources/ For more real-life feedback, welcome to the Database Lab Community Slack: https:/&#x
5.
by akartasov 5y ago
I agree that this is a possible way. The main difficulty of the generated data is related to their quality and structure. Namely, how artificial data correspond (quantitatively and qualitatively) to real data. Random data may give incorrect
6.
by akartasov 5y ago
You are absolutely right. Depending on the current environment, you should think about the protection of sensitive data (for example, data masking and obfuscation, access control). Database Lab Engine provides some possible solutions to pro
7.
by akartasov 5y ago
I think it will work well for verifying DB changes and optimizing SQL on real data. This seems like a great tool to eliminate the risk of database-related downtime.
8.
by akartasov 7y ago
Joe, a chatops bot that allows troubleshooting optimizing SQL performance using fast thin clones of full-size databases (cloning of 10 TiB takes only a couple of seconds), updated to version 0.6.0. Two new commands were added, "plan&qu
9.
Postgres query optimization assistant Joe now supports hypothetical indexes(postgres.ai)
5 points by akartasov 7y ago|1 comments
10.
by akartasov 7y ago
I've just tried the live demo in the Database Lab Community Slack. It looks amazing! Keep it up!