Hi, I am designing a mobile POS application. I was hoping I can use the Postgresql database as the central transactional database.
The application itself will run on a remote mobile PC. The retail transaction data is small, it consists of the transaction timestamp, location, amount, item price, item type, etc.
There are at least 600 of these types of mobile POS required. Each of the mobile PCs DOES NOT have a stable and consistent network connection throughout the day. For example, the network may be available for 5 minutes in the morning, and no connection at all in the afternoon. However, there are at least 30 minutes of guaranteed stable connection time at midnight every day.
Each of the mobile POS when facing the consumer needs to process at most 500 transactions a day. I was hoping to use the intermittent network connection time to do system download to flag transactions, such as, stolen credit card number, etc. And, to use the stable midnight network connection time to do uploads of the mobile transactions to the central Postgresql database. The upload would require at most 600 mobile terminals times 500 transactions at most of 3,000,000 transactions a day in 30 minutes time frame.
What specific Postgresql feature can I use to process the upload transactions? should I attempt to write transaction logs or do bulk inserts. What specific features in Postgresql would help to ensure the data consistency in such a computing environment? Thanks in advance.
William Hu
Trimet.org