Django App - Accessing Remote MySQL Database

[Ji Park]

Hello, I'm trying to make an app that can periodically access a remote mysql database.

This app will query the remote database and copy some data to the local postgresql database.

So far I know that celery can be used to schedule periodic tasks, but I'm not sure what to do about querying the remote mysql database server.

Should I just use python's MySQLdb module, does anyone know any other python module that I can use to query mysql db?

Would this even be a good way to access remote database server from a django app? I'll have to be running a function that is within tasks.py periodically (via celery-django), would there be any better way to access remote mysql server from a django app in this case?

[Branko Majic]

Depends on whether you want ORM or not, I guess. You could use
SQLAlchemy or even Django's database abstraction for accessing the
remote database.

As a side-note, I hope you won't be pumping data directly to database
used by Django (i.e. raw) - since you'll be bypassing all model checks
that you may have built-in in your models.

Best regards

--
Branko Majic
Jabber: bra...@majic.rs
Please use only Free formats when sending attachments to me.

Бранко Мајић
Џабер: bra...@majic.rs
Молим вас да додатке шаљете искључиво у слободним форматима.

[Christian Schmitt]

You could use django's inbuild ORM:

https://docs.djangoproject.com/en/dev/topics/db/multi-db/

And just copy the database.

[Ji Park]

I was actually thinking about updating local database with raw data, but now that you mention it, I think I'd rather not.

[Ji Park]

Thanks! I've just started really getting into Django, I had no idea there was a way to connect multiple databases and still be able to use django's ORM to control them.

[Liam Griffin]

I have a MySQL server with hundreds of dbs... is there a way to be able to connect to all these without breaking DRY principles?