Tagged Questions
0
votes
0answers
26 views
Python + MySQL; getting started [closed]
I recently tought myself how to scrape tables with python, now I want to use that to make databases in MySQL. I would really appreciate to get some advice on how to get started with MySQL, what are ...
0
votes
2answers
21 views
Mysql collate utf8 style string comparision in python
I have the following mysql table
mysql> show create table names;
+-------+-----------------------------------------------------+
| Table | Create Table |
...
0
votes
1answer
26 views
import mysqldb works in python 2.6 but not in 3.2 [closed]
Possible Duplicate:
MySQL-db lib for Python 3.0?
Python 3 and mysql
I just installed the python-mysqldb package on ubuntu 12.04 successfully. I tried to import the module in python3 on ...
0
votes
0answers
38 views
Django: Commands out of sync
I have a basic code which forms SQL query, which updates rows of table, and commiting it:
from myapp import Model
from django.db import connection, transaction
COUNT = Model.objects.count()
MYDATA = ...
1
vote
1answer
24 views
Pickle to file instead of using database
I'm writing a basic membership web app in python.
Is it always bad practice to abandon databases completely and simply pickle a python dictionary to a file ...
0
votes
2answers
51 views
Apps and Projects in Django
I am following The Django Book 2.0 for learning Django, and in there, we created a static website called mysite. After that, we created an app called books with a database. I understand we can create ...
2
votes
1answer
42 views
Should I be using a LEFT JOIN, RIGHT JOIN with derived tables, a different table design, or need to code? [closed]
Possible Duplicate:
MySQL pivot table
Should I be using a LEFT JOIN using derived tables, a RIGHT JOIN using derived tables, a different table design, or do I need to query the table and ...
1
vote
1answer
25 views
How to use python mysqldb to insert many values at once
I have a list of lists e.g [['a','b'],['c','d']]
I have a table called T and two fields F1, F2. The first item in the field list maps to F1, second to F2.
How in one transation insert into MySql ...
1
vote
1answer
25 views
Load data local infile does not work in Ubuntu 12.04 and MySQL
Using MySQL I cannot import a file using load data local infile. My server is on AWS RDS. This works on Ubuntu 10.04. I installed the client using apt-get install mysql-client. Same error if I use ...
2
votes
2answers
66 views
Storing MySQL Passwords [closed]
So, a friend and I are currently writing a panel (in python/django) for managing gameservers.
Each client also gets a MySQL server with their game server. What we are stuck on at the moment is how ...
-5
votes
1answer
38 views
Server for python website-developing with MySql
I need to create a website, for an univeristy course.
This website must be developed in Python, using MySQL as Database.
I would like to know what kind of server to use
I read some topics and I ...
2
votes
0answers
27 views
Mac: Eclipse error import MySQLdb works fine on command line
I have been trying to install Mysql and Python along with MySQLdb module on MAC. I have been able to do that successfully. From the command line when i do import MySQLdb it works fine. However, I ...
2
votes
2answers
40 views
Using different users for select/insert in accessing MySQL
I'm building a MySQL DB for a web app which will be written in Python.
I wanted to segregate the users functions to provide better security and maybe improve performance.
I'm thinking to do it in this ...
0
votes
1answer
69 views
Why use NoSQL instead of RDBMS? [closed]
Possible Duplicate:
NoSql vs Relational database
I have been on a couple projects where my teams chose to use a NoSQL DB (i.e. MongoDB) rather than a RDBMS like PostgreSQL or MySQL. By ...
0
votes
0answers
24 views
can't install python-mysql==1.2.3
Trying to setup mysql, django and GAE. Just finished installing mysql on my mac. However when doing
sudo easy_install mysql-python==1.2.3
or downloading mysql-python and changing the mysql_config ...
