[Baypiggies] request for opinions re python-web server-database

[Grant Jenks]

I too built something similar for a non-profit. It was a food-pantry-type
database system.

Stack was:

* cherrypy - Good-enough webserver for a localhost deploy. Really easy to
use and configure.
* django - Web framework with built-in ORM. I was already familiar with
this so it was an easy choice. I don't think the benefits of Flask outweigh
its use if you're also going to also need SQLAlchemy. You also benefit
automatically from Django's admin interface.
* sqlite - Rock-solid, built-in to Python and easy compatibility with
Django.
* py2exe - Great for deployment if it's going to a Windows machine. I made
it so that I deployed simply an exe that the end-user double-clicked. This
would spawn a Chrome browser in kiosk mode and the webserver backend.

I open sourced my implementation here:
https://github.com/grantjenks/emmaus_house_food_pantry

Hope that helps,
Grant

On Sat, Apr 12, 2014 at 5:19 PM, AM <ams.fwd at gmail.com> wrote:

> On 04/12/2014 12:03 PM, jim wrote:
>
>>
>> [rudimentary questions]
>>
>>     I have a client for whom I'm cooking up the following:
>> * on a dedicated computer with no LAN connection
>> * some (hopefully) lean web server with a set of web
>>   pages that get data from the user and to a local
>>   database and another set of web pages used to get
>>   data and format reports, both using javascript to
>>   get and present data
>> * some python module(s) that interface between the
>>   (lean) web server and the database
>> * some (hopefully simple but bulletproof) database
>>   management system, (again, hopefully) not mysql
>>   and postgresql is okay though I hope for something
>>   simpler. Data is primarily strings and integers. The
>>   need could be satisfied with a set of flat files (plain
>>   text ASCII) colon-delimited or some such, but I hope
>>   not to reinvent too many wheels.
>>
>>     Go opinions on a good, lean web server and a
>> compatible python module and rdbms system?
>>     Or an alternative approach (it'd be fine with me if I
>> can do everything by typing in some Python files, tho'
>> Django is a learning curve that I hope to avoid for
>> this project).
>>
>> Hopefully, with thanks,
>> jim
>>
>>
>> _______________________________________________
>> Baypiggies mailing list
>> Baypiggies at python.org
>> To change your subscription options or unsubscribe:
>> https://mail.python.org/mailman/listinfo/baypiggies
>>
> When I built something exactly like this for a non-profit circa 2002 the
> simplest and easiest thing was zope :) especially if you use the management
> interface to do everything instead of writing modules and doing things the
> naive way instead of the right way.
>
> As to 'lean' I think that will depend on what your baseline is. If its
> j2ee frameworks almost everything is lean, if its bottle, well almost
> nothing is lean.
>
> HTH
> AM
>
> _______________________________________________
> Baypiggies mailing list
> Baypiggies at python.org
> To change your subscription options or unsubscribe:
> https://mail.python.org/mailman/listinfo/baypiggies
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/baypiggies/attachments/20140413/45350dd5/attachment.html>