Update the PostgreSQL Database every hour via python script or using django models?

Question

I am setting a web server based on Django Framework with PostgreSQL. I need to update the models in my Django app every hour and I am wondering if is it better way to update the database from another script file using python and psycopg2 or using script that directly connects to Django models and update them using Django API for models? I use this Database only in Django web server.

Summarizing... What is better logic?

update_db.py that contains:
- connect to database via psycopg2, update the tables
update_db.py that contains:
- connect to Django app models, update them using Django API for models

I will run script every hour using Cron, and the Django Project is already connected to that specific database and it works fine. I am just asking for better performance and better way in logic sense. Data won't be updated very often but it would have big jsons.

you can be more pythonic if you use celery perioidic task docs.celeryproject.org/en/latest/userguide/periodic-tasks.html number 2 is better as they are handling connection pools and disconnect — Yugandhar Chaudhari
– Yugandhar Chaudhari, Commented Jan 16, 2019 at 7:31
@YugandharChaudhari using a complex and costly system when a simple, well-known and stable one exists is definitly not pythonic. — bruno desthuilliers
– bruno desthuilliers, Commented Jan 16, 2019 at 9:13

bruno desthuilliers · Accepted Answer · 2019-01-16 09:23:47Z

Unless you have very compelling reasons to do otherwise, the obvious solution here is to use a custom management command and the ORM - your code will be at the obvious place (for someone else having to work on the project), can be tested as part of your whole project's test suite, and won't require having to mentally "translate" from raw SQL to Django ORM code (not to mention that you'll have more chance to catch a mismatch between your Django models and your script's code when your schema changes - from experience, raw sql scripts that aren't under test are usually forgotten when doing a schema migration).

FWIW, optimizing "for performances" doesn't really makes sense in your case, unless your updates are long and complex and do block access to the site - but even then the overhead of the ORM is certainly not going to be the main bottleneck (just make sure you use properly).

Collectives™ on Stack Overflow

Update the PostgreSQL Database every hour via python script or using django models?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related