PkgFoundry
Catalog PyPI
Back to packageRELEASE DETAILS

0.0.8

PyPI

acc2psql

Converter from *.accdb/*.mdb to PostgreSQL *.sql

Published15 Feb 2021
Direct dependencies3
Transitive dependenciesNot calculated

README

Version 0.0.8 documentation

acc2psql

Convert Microsoft Access *.accdb or *.mdb into *.sql PostgreSQL format

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

Youtube: Everybody can code!

Spotify: Everybody can code!

swdev.balI@gmail.com

Downloads & popularity

Awaiting observations

No metric observations yet

Download counts and popularity will appear here as the collector receives them.

Declared dependencies 3

Native requirements
3 direct targetsNot calculated transitive count
Package / targetRequirementRelationship
pyodbc
Environment
{
  "extras": "",
  "marker": null,
  "requires_python": ">=3.6",
  "evaluation": "NOT_EVALUATED"
}
pyodbcruntime
click
Environment
{
  "extras": "",
  "marker": null,
  "requires_python": ">=3.6",
  "evaluation": "NOT_EVALUATED"
}
clickruntime
psycopg2-binary
Environment
{
  "extras": "",
  "marker": null,
  "requires_python": ">=3.6",
  "evaluation": "NOT_EVALUATED"
}
psycopg2-binaryruntime

Distribution files

2 collected
acc2psql-0.0.8-py3-none-any.whl

bdist_wheel · 16.56 KB · Python py3

Source file
acc2psql-0.0.8.tar.gz

sdist · 3.87 KB · Python source

Source file

Repository

PENDING
remoteworkerid/acc2psql

Shared repository data · GitHub

License detected in repository
Not collected

Metadata history

Meaningful changes
Current collected state Current

Observed since 20 Oct, 17:53 UTC

No superseded metadata states collected. Unchanged observations do not create new revisions.

Record identity

package_version:1cc41c0b3a93cbd2e9042cc4e267989a9ab4f98b39b79fd5f79e7fd4a5193013

Other collected versions

View all collected versions →