I was actually thinking about updating local database with raw data, but now that you mention it, I think I'd rather not.
On Friday, August 2, 2013 5:58:38 AM UTC-7, Branko Majic wrote: > > On Thu, 1 Aug 2013 17:50:35 -0700 (PDT) > Ji Park <jhp...@gmail.com <javascript:>> 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 <javascript:> > Please use only Free formats when sending attachments to me. > > Бранко Мајић > Џабер: bra...@majic.rs <javascript:> > Молим вас да додатке шаљете искључиво у слободним форматима. > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at http://groups.google.com/group/django-users. For more options, visit https://groups.google.com/groups/opt_out.
