On Thu, 1 Aug 2013 17:50:35 -0700 (PDT) Ji Park <jhp...@gmail.com> wrote:
> 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? > 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 Молим вас да додатке шаљете искључиво у слободним форматима.
signature.asc
Description: PGP signature
