I’m following this tutorial to get started with Django, but I’m very confused about how to integrate MySQL. Doing this in the context of virtualenv (which is new to me) seems to complicate things even further. I’m running on Ubuntu and the MySQL server is on another host. Here are my specific questions: What packages do I need to install
Tag: mysql
memory-efficient built-in SqlAlchemy iterator/generator?
I have a ~10M record MySQL table that I interface with using SqlAlchemy. I have found that queries on large subsets of this table will consume too much memory even though I thought I was using a built-in generator that intelligently fetched bite-sized chunks of the dataset: To avoid this, I find I have to build my own iterator that
About mysql cursor and iterator
Imagine I have a mysql cursor and data read. The amount of data might be very big that I want to deal with one line each time. An easy and straight forward way might be like this: But this doesn’t look good, so I wonder whether this way works as imagined: The thing I want to know is: if I
Can one use the Django database layer outside of Django?
I’ve got a nice database I’ve created in Django, and I’d like to interface with it through some python scripts outside of my website stuff. I’m curious if it’s possible to use the Django database API outside of a Django site, and if so does anyone have any info on how it can be done? Google hasn’t yielded many useful
Python and MySQL: is there an alternative to MySQLdb?
Is there a module written purely in Python that will allow a script to communicate with a MySQL database? I’ve already tried MySQLdb without success. It requires too much: GCC, zlib, and openssl. I do not have access to these tools; even if I did, I don’t want to waste time getting them to work together. I’m looking for tools