temp table

[BlueShadow]

Hi,

I get some information from constantly updating files. (this part works already) Some of these information I want to save in a temp db table. 

So once the user opens the "temp table site" he should get an overview about all information in the temp table and decide for each entry if its taken over to the main db table or if it should be deleted.

How would you guys tackle this problem?

thanks for the help.

[Leonel Câmara]

Instead of using a database you can store it in the session. An alternative is to use a sqlite mem adapter temp_db = DAL('sqlite:memory:').

[Kevin Bethke]

storing it in a session is probably not a good idea since the the action from the user should be 2-4 times a month the update of the file is every hour. but creating a new temp database will probably work.

On Thu, Mar 19, 2015 at 12:28 PM, Leonel Câmara <leonel...@gmail.com> wrote:

Instead of using a database you can store it in the session. An alternative is to use a sqlite mem adapter temp_db = DAL('sqlite:memory:').

--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/oAkIM2MdibM/unsubscribe.
To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Leonel Câmara]

Another simple solution is to just use the regular database. Except you would add a boolean "published" field to all the tables. Records that are not published would not show up in the main website.