The python tag has no wiki summary.
0
votes
0answers
23 views
Advice on NoSQL (Google App Engine NDB) Schema?
Some background: I am very much a novice at anything database related, my knowledge caps at creating a very basic blog with MySQL. I am currently switching from PHP/MySQL to Python and as of now I am ...
0
votes
0answers
27 views
How to use Python and XML for distributed DBMS [closed]
I have a project where 3 VMs (say VM1 VM2 and VM3) are given to me. Each with 4 GB ram, and 50 GB space. They have known static IPs.
All 3 VMs are installed with ubuntu 10.04 and MySQL. VM2 and VM3 ...
0
votes
2answers
38 views
How can I add a column to multiple tables at once in MySQL Workbench?
I have a MySQL Workbench model (diagram) that belongs to a Ruby on Rails application. I now need to add the created_at and updated_at timestamp columns to each of the tables. What is a quick and easy ...
0
votes
0answers
34 views
Match two large tables finding similar data [closed]
I have two tables in MySQL. Table 1 contains much data, but Table 2 contains huge data.
Here's the code I implement using Python
import MySQLdb
db = MySQLdb.connect(host = "localhost", user = ...
1
vote
0answers
27 views
Is there a generic SQL-92 ODBC 64-bit Mac driver for Python?
I have a 4D SQL database which implements SQL-92.
4D's ODBC driver does not work on my system because it is compiled for 32 bit (and I am on 64 bit) and it is closed source.
I wonder if there is ...
0
votes
1answer
25 views
look for missing datetime records in database
I have a python script that scrapes a webpage every minute of every day and saves the results in a postgres database.
As I browse through the database, I've noticed there are minutes here and there ...
0
votes
1answer
74 views
Cannot use python3 as stored procedure language in posgresql database
I want to have python3 in my postgresql database for writing stored procedures.
Being in the psql client, when I enter the command create extension plpython3u I get the error:
couldn't open ...
5
votes
1answer
128 views
How to best use connection pooling in SQLAlchemy for PgBouncer transaction-level pooling?
Using SQLAlchemy to query a PostgreSQL database behind PgBouncer, using transaction-level pooling.
What is the best pattern to use for this kind of set up? Should I have one-engine-per-process, ...
3
votes
3answers
134 views
What is the best way to store X509 certificate in PostgreSQL database?
I'm working on web authenticate system where users will digitally sign random tokens and this will be checked with X509 certificates stored on the server.
Therefore I have to store several X509 ...
0
votes
0answers
45 views
How to use MySQL proxy with Python
I have two questions regarding MySQL proxy:
How can I use MySQL proxy to track all data which to my server?
How can I embed the MySQL proxy into a Python script to track
all traffic which is coming ...
1
vote
3answers
105 views
Anyone want to try a script bash or python?
I need to automate master binary log purging to occur so that purging never goes back further than the last slave has the updated info for.
These slaves are mobile and there are 3 of them, and sync ...
0
votes
0answers
131 views
Tornado and Postgres [closed]
I'm using demo from facebook's tornado
But I don't want to use MySQL and trying to replace it with PG
So I went ahead and modified like this :
define("port", default=8888, help="run on the given ...
