Since you're looking at readonly stuff, one of the faster ways I've found is to write a view on the database and create a sqlalchemy classes for it. That lets you customize and tweak the exact query for performance on the server, SqlAlchemy essentially "selects all" from it, and then you do the "to_json" trick Michael mentioned. You can also do things with CORE to further minimize the logic/mapping layer, but I've found the "view" trick to get 90% of the performance benefits with 10% of the work, and it's easier to maintain.
-- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.