Re: Django App - Accessing Remote MySQL Database

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> 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
Молим вас да додатке шаљете искључиво у слободним форматима.

--
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+unsubscribe@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.