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: 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 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Newsgroups: comp.lang.python Message-ID: 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 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.