I looking for some advice regarding using a disconnected java application running on Postgres.
Scenario: A Java web application read/writes a PG database in a transactional environment. To be more specific, status information about clients is looked up from some table(s), and a number of lines are then entered into an order. The items that can be ordered are in another table, which must also be available offline. Lastly the completed order must of course also be available offline, for submission later when an internet connection is available again. Now this application should be able to work when disconnected from the server. Of course the application can be written to create offline copies of the data in a local file, but basically that would cause some problems, since it would involve a lot of coding firstly, but also mean that different code would be required for online and offline operation. My question is, is there any technology that would allow this type of funtionality with Postgres, like some type of caching enjine, or something else, acting as a sort of mini "middleware" of sorts (to borrow that term) to do this for me. Thanks Roland Giesler
