> having a dedicated sql server. Has someone used sqlite with webpy? > Any issues, or gotchas? I imagine that I could run into the same > problems with open files, because sqlite uses an on-disk method > without a dedicated server, and (as I understand it) every time
With SQLite you can perform read (select..) simultaneously but not write (update, insert, delete). Therefore, when I used SQLite for several internal webpy applications I wrote my own tiny Thread-Safe-SQLite-Writer for this reason. Basically it is a simple tcp server that accepts sql statements and push them into a queue while another thread executes them one by one and empty the queue. While all the selects, are executed straightforward with web.select, update/insert/delete commands are pass to the writer. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web.py" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/webpy?hl=en -~----------~----~----~----~------~----~------~--~---
