[Web-SIG] SQLAlchemy Queries & HTML Data Grid

[Aaron Watters]

Thanks Randy, very interesting.

My initial reaction is that you are building a stack on top of a stack.
It's not clear to me what problem you want to solve
and your requirements are.  It's possible that
you could find it easier to abstract directly on top of SQL or alternatively
you could consider using another sort of data model like mongodb.
Building an abstraction on top of SQLAlchemy which hasn't even reached
1.0 strikes me as dubious.

Thanks again,  -- Aaron Watters

--- On Tue, 4/6/10, Randy Syring <rsyring at inteli-com.com> wrote:

From: Randy Syring <rsyring at inteli-com.com>
Subject: [Web-SIG] SQLAlchemy Queries & HTML Data Grid
To: web-sig at python.org
Date: Tuesday, April 6, 2010, 4:37 PM




I am planning on building a library that will facilitate creation of
custom queries and html display of resulting datasets from SQLAlechemy
queries.  I have some basic work done here:



https://svn.rcslocal.com:8443/svn/pysmvt/pysapp/branches/0.1/pysapp/modules/datagrid/



But I don't like the API and I don't want the library to be dependent
on pysapp.  Furthermore, I would like to have a more verbose querying
ability akin to Redmine:



http://www.redmine.org/projects/redmine/issues



Including:


  Filters
  Column Selection
  Grouping (multiple levels)
  Sorting (multiple columns)
  some kind of query saving/loading mechanism with a flexible
backend

I have done some basic table generation work here:



https://svn.rcslocal.com:8443/svn/pysmvt/pysdatagrid/trunk/



with the tests being the best place to get an idea of how it works:



https://svn.rcslocal.com:8443/svn/pysmvt/pysdatagrid/trunk/pysdatagrid/tests/test_render.py



Looking for comments, pointers to other projects, and/or possibly
interest in helping with a project like this.  I am currently working
in SVN but will most likely move to hg/git if there are others who are
interested.

-- 
--------------------------------------
Randy Syring
Intelicom
502-644-4776

"Whether, then, you eat or drink or 
whatever you do, do all to the glory
of God." 1 Cor 10:31
 

-----Inline Attachment Follows-----

_______________________________________________
Web-SIG mailing list
Web-SIG at python.org
Web SIG: http://www.python.org/sigs/web-sig
Unsubscribe: http://mail.python.org/mailman/options/web-sig/arw1961%40yahoo.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/web-sig/attachments/20100407/8a895416/attachment.html>