I believe in MS Access regarding its fast prototyping of relational database. You probably are not going to use MS Access in production environment due to its file based and single user restriction. But in a prototyping phase, MS Acces is one tool that is hard to beat!
Quick and easily prototype your database using MS Access, once satisfied, use this tool to convert said database into PostgreSQL DDL. You can either save it to *.sql file, dump it to console or directly execute it to PostgreSQL instance
If you use Django, you can then run python manage.py inspectdb to turn generated tables into Django models and .. voila, you can skip manually coding tedious Django models yourselves!
pip install acc2sql
python -m acc2sql --src someawesomedatabase.accdb --dump
python -m acc2sql --src someawesomedatabase.accdb --out saveto.sql
python -m acc2sql --src someawesomedatabase.accdb --host localhost --username user --password password --db db
#if you use django
python manage.py inspectdb
This package is still in early development, I may add more database source / target along the way. You can also use this to any tool necessary: for example, I am thinking to use this as PyCharm Extension.. that will be awesome!
Eko - Founder and CEO
Remote Worker Indonesia / LinkedIn / Facebook / Instagram / Twitter
FAQs
Converter from *.accdb/*.mdb to PostgreSQL *.sql
We found that acc2psql demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Research
Security News
Attackers used a malicious npm package typosquatting a popular ESLint plugin to steal sensitive data, execute commands, and exploit developer systems.
Security News
The Ultralytics' PyPI Package was compromised four times in one weekend through GitHub Actions cache poisoning and failure to rotate previously compromised API tokens.
Security News
Research
Socket researchers found a malicious Maven package impersonating the legitimate ‘XZ for Java’ library, introducing a backdoor for remote code execution.