Tagged Questions
3
votes
0answers
52 views
Are there python libraries with spatial support for mySQL?
Is it possible to use sqlsoup or some other python MySQL Library with any of the spatial types like Geometry, Point, Polygon, etc of MySql? If so, could someone show how one would use said python ...
2
votes
0answers
41 views
Is there a Python MySQL API that returns Prepared Statements for re-use?
Neither MySQLdb nor oursql allow returning prepared statements to be filled by parameters for successive executions. Are there any others?
At least for .executemany() oursql seems to be more ...
2
votes
0answers
70 views
Why Python/Django does not raise exception on Mysql: ERROR 1205 (HY000): Lock wait timeout exceeded
I am testing locking in my MySQL db from python/django.
I have a table, I am testing on:
CREATE TABLE `test` (
`id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
...
2
votes
0answers
83 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
0answers
184 views
How to connect with passwords that contains characters like “$” or “@”?
I cannot get a connection to a MySQL database if my password contains punctuation characters in particular $ or @. I have tried to escape the characters, by doubling the $$ etc. but no joy.
I have ...
2
votes
0answers
143 views
Dynamic table names within MYSQL statement (Google Cloud SQL)
I am trying to drop/delete a table from within Google Cloud SQL using Python (App Engine) but I want the table name to be based on a variable, for simplicity I am using 'hello' here. For some reason ...
1
vote
0answers
53 views
Django: How to set foreign key checks to 0
Ok so i'm migrating database from sqlite to mysql , i had few errors but i already resolved them. Now i have problem with this option because i don't know how to disable it.
I tried
DATABASES = {
...
1
vote
0answers
17 views
Django ORM query GROUP BY multiple columns combined by MAX
I am using Django with MySQL. I have a model similar to the following:
class MM(models.Model):
a = models.IntegerField()
b = models.IntegerField()
c = ...
1
vote
0answers
58 views
MySQL Unread Result with Python
I use mysql.connector to do SQL operations.
I have a short scripts which executes the following operations (strings) on the cursor with cursor.execute(...):
"use {}".format(db)
"show tables"
...
1
vote
0answers
23 views
Caching fully formed pages or individual elements of constantly changing data
It is viable to cache full user feeds similar to website like Twitter or Facebook, since they are usually constantly changing? Would the constant rewriting or expiring of the cache be worth the small ...
1
vote
0answers
94 views
Accessing a local MySQL instance in your GAE development environment for Python
Google Developer Relations team has been very nice to put together a lot of useful sample applications to illustrate how to develop applications on Google App Engine platform. Those examples did ...
google-app-engine
1
vote
0answers
56 views
How to handle MySQL slave failover in python?
Is there a generally accepted way to handle MySQL slave db failover in python code?
Are there any good wrappers for SQLAlchemy connection pools (or other approaches) that are aware of replicas and ...
1
vote
0answers
63 views
Strange overhead from python function call
I have some strange overhead coming from nowhere. I'm running a python script and making some SQL queries using SQLAlchemy. Here is my problem:
def _create_connection(name):
connection = ...
1
vote
0answers
66 views
Is it possible that we can connect to multiple databases in django at one time
I am migrating some data from one database to another (db1 --> db2). The db1 is in a host and db2 is at another (so, the databases are in different hosts). I have to select data from db1 and insert ...
1
vote
0answers
31 views
What are the required options in order to enable djangodblog for error logging in a MySQL database?
I would like to ask a question about djangodblog used for logging real time Django exception into the application database. I use the following tools
Database: 5.5.28 MySQL Community Server
OS: ...
