Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!feeder.erje.net!eu.feeder.erje.net!newsfeed.xs4all.nl!newsfeed2.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path: <jsf80238@gmail.com>
X-Original-To: Python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.003
X-Spam-Evidence: '*H*': 0.99; '*S*': 0.00; 'python.': 0.02; 'subject:Python': 0.06; 'mysql,': 0.07; 'archiving': 0.09; 'cursor': 0.09; 'sql,': 0.09; 'cc:addr:python-list': 0.11; 'python': 0.11; 'django': 0.11; 'stored': 0.12; '2.7': 0.14; 'mostly': 0.14; 'apache': 0.15; 'aptitude': 0.16; 'former,': 0.16; 'latter,': 0.16; 'subject:programming': 0.16; 'tier': 0.16; 'two,': 0.16; 'code.': 0.18; 'year,': 0.18; 'trying': 0.19; 'packages.': 0.19; 'retrieval': 0.19; 'seems': 0.21; 'command': 0.22; 'programming': 0.22; 'cc:addr:python.org': 0.22; 'install': 0.23; 'css,': 0.24; 'script.': 0.24; 'stick': 0.24; 'java': 0.24; 'cc:2**0': 0.24; "i've": 0.25; 'tables': 0.26; 'primary': 0.26; 'header:In-Reply-To:1': 0.27; 'message-id:@mail.gmail.com': 0.30; "i'm": 0.30; 'code': 0.31; 'comments': 0.31; 'fast.': 0.31; 'linux.': 0.31; 'probably': 0.32; 'figure': 0.32; 'linux': 0.33; 'framework': 0.33; 'trouble': 0.34; 'problem': 0.35; 'basic': 0.35; 'problem.': 0.35; 'one,': 0.35; 'but': 0.35; 'received:google.com': 0.35; 'google': 0.35; 'really': 0.36; '(e.g.,': 0.36; 'html,': 0.36; 'should': 0.36; 'two': 0.37; 'starting': 0.37; 'being': 0.38; 'architecture': 0.38; 'server': 0.38; 'rather': 0.38; 'does': 0.39; 'use.': 0.39; 'system.': 0.39; 'users': 0.40; 'photos,': 0.60; 'most': 0.60; 'gone': 0.61; 'visa': 0.61; 'year.': 0.61; 'further': 0.61; 'save': 0.62; 'different': 0.65; 'management': 0.65; 'finally': 0.65; 'levels': 0.65; 'talking': 0.65; 'between': 0.67; 'goal': 0.75; '100': 0.79; 'trial': 0.83; 'to:none': 0.92
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:cc :content-type; bh=w69uFRhb7wDUIkZjdDxpxkN7eGaGjOgfaWdIe/amjFs=; b=VJLTx9SRBGNqpohdXorL0iAifSaHWBBNSd2qMah/e6q/07J1qmFixnIVSGWOx8KRke gV9msvVSlulvMZLdHxdUPZFmwyZEMEZ65SwBZfEZ51a85Gjdig44u+dAgWvxhp5g6Vfz zGu1O1N8cMMY9SAxhnPPhQ4nRDqhhLuoyWIO56gYrCZMNJf4/4FnrK46bQgIvbfLBs3r /fEsNSmdvC10M/oP1q5lcld4c7Bz3QS2RFSjmUcqu3nK6nEyNMLcWqkpGdvCzDwHcN7z wozyorCygtde3phJk0kHyXfJudTUQucwCAMtj1vNHUd0zhLmkEx4yIpbZDUA36sZGylE ygEw==
MIME-Version: 1.0
X-Received: by 10.205.13.132 with SMTP id pm4mr54717bkb.116.1377272317572; Fri, 23 Aug 2013 08:38:37 -0700 (PDT)
In-Reply-To: <52156F4B.60107@verizon.net>
References: <52156F4B.60107@verizon.net>
Date: Fri, 23 Aug 2013 09:38:37 -0600
Subject: Re: Python and mysql 3 tier programming
From: Jason Friedman <jsf80238@gmail.com>
Cc: python-list <Python-list@python.org>
Content-Type: text/plain; charset=UTF-8
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.171.1377275551.19984.python-list@python.org>
Lines: 34
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1377275551 news.xs4all.nl 15890 [2001:888:2000:d::a6]:43660
X-Complaints-To: abuse@xs4all.nl
Xref: csiph.com comp.lang.python:52901

> 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.

Hello Gary,
Is your primary goal to write code or is it to have available to you a
document archiving solution?
If the latter, you will probably save time by using an existing system
(e.g., Google Docs).
If the former, I have a few thoughts.
One, you should probably be using Python 3 rather than 2, I think the
command is "sudo aptitude install python3".
Two, I think of stored procedures as being good at manipulating data
really fast.  With a document management system most activity will be
retrieval rather than manipulation.