How to generate Mock-up Data for your Database ? |
Database developers often face the challenge of not having enough data in Development environment. Due to this any queries that are developed and tested in Development environment, might perform below expectation in the higher environments. This problem is often caused by the fact that Development databases usually have poor quality of data as well as low volume of data.
This issue can be solved to a great extent by generating synthetic/artificial data in the development environment. In this video, we are going to see how we can generate mock-up datasets in a simple and quick manner using the python library Fake2DB.
COMMANDS USED:
Create python virtual environment: python -m venv datagen
Activate to virtual environment: datagen\Scripts\activate
Install Fake2DB: pip install fake2db
Install psycopg: pip install psycopg2
IMPORTANT LINKS:
GIT repo of Fake2DB: https://github.com/emirozer/fake2db
List of attributes: https://github.com/emirozer/fake2db/b...
If you like this video, please remember to Like this video, share it with friends & colleagues and please do subscribe
Link to this same video in ಕನ್ನಡ - • Video
Link to Video List - https://docs.google.com/spreadsheets/...
Link to Telegram Group - https://t.me/dataupskill