These are chat archives for django/django

14th
Feb 2017
Alex Lee
@createall
Feb 14 2017 01:54
@aptiko Really Thank you for your sincere answer! I've been a web developer since 2000 and I always made database procedure on oracle, sqlserver and mysql to make billing, accounting and SCM, CMS like system. They all have complex and many database tables(about 100~200) and thier relation is so complicated and also have many rows(over billian rows). Can ORM handle complicated and big data within reasonable response time? And I also wonder how can I change database schema in live environment? Could you recommend articles or books which explain about more live environment.
Alex Lee
@createall
Feb 14 2017 02:02
@aptiko And One more question. How does django handle complex database transaction? ex) In database procedure detail resource lock managing is available.
Fabian
@fabiand93
Feb 14 2017 04:17
Hello everybody. I need to get a table from a DB and save the data with encryption on a new DB connected to the same server. How can I do it. Still learning. Any tutorial or commentary please.
Batur
@Batur24
Feb 14 2017 04:48
data_a = ModelA.objects.all()
for data in data_a:
    ModelB.objects.create(...)# write data to it
@fabiand93
Fabian
@fabiand93
Feb 14 2017 10:11
@Batur24 How do I bind this with psycopg2?
Batur
@Batur24
Feb 14 2017 10:13
You need to config your database on settings.py, and then write code on model.py based on your postgres tables. finally, you can use this orm to handle your postgres database.
@fabiand93
Antonis Christofides
@aptiko
Feb 14 2017 11:18
@createall While I'm confident that Django's ORM does what you want, I don't know of any books to recommend. And I don't know what you mean by "change database schema in live environment". You want to change the schema during a software upgrade? Or do you want to be changing the schema during normal operation? I've heard of the latter requirement before, but I think it's bad practice and it violates all the theory and practice of RDMBS's. BTW, I wouldn't trust MySQL with a billion rows (in fact I don't trust it with anything at all), and there's no reason when there's PostgreSQL around (I've written a bit about this in https://djangodeployment.com/2016/12/23/which-database-should-i-use-on-production/).
Fabian
@fabiand93
Feb 14 2017 13:06
Thanks @Batur24