> It is more a quality then quantity issue. Ironically, the app that drove > me to this viewpoint is a Visual FoxPro one. Before I get into the > particulars, let me say I was generally impressed with VFP and my limited > experience with it led me to this project. Let me also say I did not > develop the app nor did I have access to the code. The problem is that GUI > apps, especially those running on Windows(where this app exists) can be > fragile. When the enviable happened and there was a crash, bad things > happened. The biggest problem was the issue of orphaned records. This could > be attributed to the apps dependence on explicit saves. If they weren't > done then the data was left in an incomplete state. At the same time I was > dealing with this app, I was developing my own app using Postgres and a > variety of clients. One of the things I did was make automatic saves a part > of the process. We had some power issues so we had unscheduled shutdowns, > yet I never ran into the orphaned record issue. Just my 2 cents worth. > Sounds like DBF's. But even Postgres can have issues with a complete power loss. Postgres just recovers better. But it does not mean you can't lose data. . > > No I have not worked on anything that size. My guess though is that I would > hit a connection handle issue first. In this vein, does Dabo support lazy > connections or connection pooling? I agree with the local copy approach, I > just plan to make saving implicit not explicit as much as possible. I am > sure there will learning curve as to the proper balance.
It is possible to use both by using a combination of creating instances of the Dabo connections and psycopg2 pooling extentsions. That said, I have to say I have never used connection pooling as I understanding it. Also I would be concerned as how connection pooling would work with dbPostgres.py. Currently, dbPostgres.py depends on a single session of a bizObject to determine getLastInsertID(). I don't know what/how it would work with connection pooling. But like I said I haven't used connection pooling. -- John Fabiani _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]
