condenser
Jailer
condenser | Jailer | |
---|---|---|
14 | 218 | |
299 | 2,707 | |
1.3% | - | |
1.7 | 9.6 | |
5 months ago | 3 days ago | |
Python | Java | |
MIT License | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
condenser
-
Jailer, a unique open-source database tool
[1]: https://github.com/TonicAI/condenser
-
Ask HN: What are the open source tools for database subsetting?
[1]: https://github.com/TonicAI/condenser
-
Recommendation for tool or script for sanitizing data
This may be overkill but we have used Tonic for this: https://www.tonic.ai/
-
Is it atypical to have a dev DB service on your local environment?
A tool like https://www.tonic.ai/ might help.
- Launch HN: JumpWire (YC W22) – Easily encrypt customer data in your databases
-
Anonymize test data?
I attended a presentation a month or so ago where a co-worker was advocating for tonic. I've never used it myself, but, definitely looks as though it would cover your bases. I do agree with onomazein though that this should really be handled on the infrastructure side if at all possible. Dev's, testers, anyone else should be able to pull from an already anonymized location, but, but, someone else should be responsible for setting up the environment and the initial synchronization.
-
What's the coolest automation tool you've built or been involved in?
So I built a gitlab pipeline to create a backup of this upstream db without downtime using various SQL utils. This archive is then staged into an image so the data will unpack and load on startup. I then used a data subsetter called condenser to create datasets for certain use cases. Now devs can load reliable dev data quicker, test against data that QA uses but within their unique envs (local and preview) and create datasets for their own use cases.
- Preserve the unique relationships between data columns while wiping sensitive information from those columns using randomization.
- Don't let your test data suffer - meet the Tonic and Google BigQuery partnership.
- Don't let your test data suffer - meet the Tonic.ai and Amazon Redshift partnership for Real. Fake. Data.
Jailer
- Jailer – open-source database client
- Show HN: Jailer is a unique open-source database client tool
-
DBeaver – open-source Database client
Some other tools I have also enjoyed:
DBVisualizer: https://www.dbvis.com/ (for exploring the schema)
Jailer: https://wisser.github.io/Jailer/ (for data browsing)
Aside from that, it's usually just been a mix of using specialized tools like MySQL Workbench, SQL Developer, pgAdmin and others, or something that tries to do it all like DataGrip.
Didn't actually find anything particularly amazing about DataGrip, but if I'm paying for the JetBrains Ultimate subscription, might as well use it because it's pretty okay.
- Database browsing tool with sophisticated and animated Java Swing UI
- Jailer is a unique open-source database client tool
-
Why people care about PostGIS and Postgres
I also found DBeaver to be a huge improvement over tools I used earlier.
Recently I discovered Jailer which makes it very easy to navigate complex relational structures: https://github.com/Wisser/Jailer
- Jailer, a unique open-source database tool
- Jailer is a unique open-source database tool
- FLaNK Stack Weekly for 14 Aug 2023
- UniversalProblemSolver
What are some alternatives?
Replibyte - Seed your development database with real data ⚡️
dbgate - Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application
boxball - Prebuilt Docker images with Retrosheet's complete baseball history data for many analytical frameworks. Includes Postgres, cstore_fdw, MySQL, SQLite, Clickhouse, Drill, Parquet, and CSV.
prisma-field-encryption - Transparent field-level encryption at rest for Prisma
beekeeper-studio - Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
wordscapes-bot - A Bot that Completes Levels on the Videogame WordScapes
Ebean ORM - Ebean ORM
sitcom-simulator-cli - A tool that combines GPT-3, Stable Diffusion, and FakeYou to create fully automated video. [Moved to: https://github.com/joshmoody24/sitcom-simulator]
H2 - H2 is an embeddable RDBMS written in Java.
infrastructure-tools - JumpWire deployment and installation scripts
presto - Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io) [Moved to: https://github.com/trinodb/trino]