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 <[email protected] <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: [email protected] <javascript:> > Please use only Free formats when sending attachments to me. > > Бранко Мајић > Џабер: [email protected] <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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/django-users. For more options, visit https://groups.google.com/groups/opt_out.
