Python and mysql 3 tier programming

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!weretis.net!feeder4.news.weretis.net!newsfeed1.swip.net!uio.no!news.tele.dk!news.tele.dk!small.news.tele.dk!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path	<gary719_list1@verizon.net>
X-Original-To	Python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.004
X-Spam-Evidence	'H': 0.99; 'S': 0.00; 'python.': 0.02; 'subject:Python': 0.06; 'mysql,': 0.07; 'advance': 0.07; 'archiving': 0.09; 'cursor': 0.09; 'sql,': 0.09; 'python': 0.11; 'django': 0.11; 'stored': 0.12; '2.7': 0.14; 'mostly': 0.14; 'apache': 0.15; 'received:206.46': 0.16; 'received:206.46.173': 0.16; 'subject:programming': 0.16; 'tier': 0.16; 'code.': 0.18; 'year,': 0.18; 'all,': 0.19; 'trying': 0.19; 'packages.': 0.19; 'seems': 0.21; 'programming': 0.22; 'header:User-Agent:1': 0.23; 'css,': 0.24; 'script.': 0.24; 'stick': 0.24; 'java': 0.24; "i've": 0.25; 'first,': 0.26; 'tables': 0.26; "i'm": 0.30; 'comments': 0.31; 'gary': 0.31; 'linux.': 0.31; 'figure': 0.32; 'interface': 0.32; 'linux': 0.33; 'framework': 0.33; 'trouble': 0.34; 'problem': 0.35; 'basic': 0.35; 'problem.': 0.35; 'but': 0.35; 'html,': 0.36; 'thanks': 0.36; 'two': 0.37; 'list': 0.37; 'starting': 0.37; 'architecture': 0.38; 'server': 0.38; 'to:addr :python-list': 0.38; 'rather': 0.38; 'does': 0.39; 'use.': 0.39; 'to:addr:python.org': 0.39; 'system.': 0.39; 'users': 0.40; 'photos,': 0.60; 'gone': 0.61; 'visa': 0.61; 'year.': 0.61; 'further': 0.61; 'received:206': 0.63; 'different': 0.65; 'finally': 0.65; 'levels': 0.65; 'talking': 0.65; 'between': 0.67; 'background:': 0.68; '100': 0.79; 'trial': 0.83; 'received:192.168.1.7': 0.84
Date	Wed, 21 Aug 2013 18:54:19 -0700
From	Gary Roach <gary719_list1@verizon.net>
User-Agent	Mozilla/5.0 (X11; Linux i686 on x86_64; rv:17.0) Gecko/20130704 Icedove/17.0.7
MIME-version	1.0
To	Python-list@python.org
Subject	Python and mysql 3 tier programming
Content-Type	text/plain; charset=ISO-8859-1; format=flowed
Content-transfer-encoding	7bit
X-Mailman-Approved-At	Thu, 22 Aug 2013 04:25:31 +0200
X-BeenThere	python-list@python.org
X-Mailman-Version	2.1.15
Precedence	list
List-Id	General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe	<http://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive	<http://mail.python.org/pipermail/python-list/>
List-Post	<mailto:python-list@python.org>
List-Help	<mailto:python-list-request@python.org?subject=help>
List-Subscribe	<http://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups	comp.lang.python
Message-ID	<mailman.113.1377138332.19984.python-list@python.org> (permalink)
Lines	33
NNTP-Posting-Host	2001:888:2000:d::a6
X-Trace	1377138332 news.xs4all.nl 15937 [2001:888:2000:d::a6]:56044
X-Complaints-To	abuse@xs4all.nl
Xref	csiph.com comp.lang.python:52805

Show key headers only | View raw

Hi all,

I'm now to the list so apologies if I don't always follow the local 
protocol. My problem is the interface between python and mysql using a 
three tier model. First, some background:

System Debian Wheezy Linux
Python 2.7
Mysql 5.5.31
Apache Server

I am somewhat conversant with html, css, SQL, mysql, Apache and Debian 
Linux. Actually I have been using Debian for over 10 year. I spent over 
5 year, prior to retirement, programming database based applications in 
Foxpro. I can also struggle through Java Script. I am just starting to 
use python. I've started with development of a rather complicated 
document archiving system with about 5 different levels of users and 
over 100 years of documents. photos, etc. The database setup has gone 
smoothly and other than one trial web page I'm leaving that for later. 
Finally to the problem. Where does python start and mysql stored 
procedures stop and visa versa. I'm trying to stick to a 3 tier 
philosophy but am having trouble figuring out where the dividing line is 
between the two packages. Further python seems to like cursor tables a 
lot and Oracles Mysql 5.5 discourages their use. Are they talking about 
the same thing.

My problem is mostly with the basic architecture of the system. I think 
I will be able to figure out the code. Also, any comments on the use of 
the Django framework for this project.

Thanks in advance

Gary R.

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

Python and mysql 3 tier programming Gary Roach <gary719_list1@verizon.net> - 2013-08-21 18:54 -0700

csiph-web