SQLite appears to have a ":memory:" keyword for in-memory databases.
It looks like a minor change to sql.py to change the way it parses the
uri from db=SQLDB('slqlite://something') so that it can say
sqlite3.Connection(":memory:") when required.
SQLite "virtual tables" also look interesting. See
http://www.sqlite.org/cvstrac/wiki?p=VirtualTables
MySQL has an equivalent ENGINE=MEMORY. See
http://dev.mysql.com/doc/refman/5.0/en/memory-storage-engine.html
On Nov 18, 2:01 pm, mdipierro <[EMAIL PROTECTED]> wrote:
> If sqlite can create a database in ram than this is possible. I will
> take a look.
>
> Massimo
>
> On Nov 18, 7:33 am, billf <[EMAIL PROTECTED]> wrote:
>
>
>
> > I don't think you can - as you say itemize takes tables and an
> > optional query. I think you will have to create your own "itemize"
> > that works off your results. Looking at T2.itemize, it should not be
> > difficult.
>
> > Would it be nice if one could create a database and table in ram cache
> > (disk cache wouldn't be much better than a conventional temp table?)
> > and access it like a normal database. Maybe that is possible already
> > but I don't think so.
>
> > On Nov 18, 11:47 am, Baron <[EMAIL PROTECTED]> wrote:
>
> > > hello,
>
> > > My app calculates temporary data that I want to display to the user.
> > > There is a lot of it so paginating it with t2.itemize sounds like a
> > > good idea. But itemize takes a database table as input.
>
> > > So, I could write the data to a table and then query it to get the
> > > right form, but that would be wasteful. How can I instead wrap the
> > > data directly for itemize?
>
> > > thanks,
> > > Baron- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
