exporting data from one DB to another asynchronously
От | Nagita Karunaratne |
---|---|
Тема | exporting data from one DB to another asynchronously |
Дата | |
Msg-id | b2990fb00603051324m5b411fe3r3c0379594fca5731@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: exporting data from one DB to another asynchronously
|
Список | pgsql-novice |
I have three problems that I need to solve that are closely related There are tasks: Task 1) Salesman access an application to submit information on a sales they made. This information includes data about the customer (name, address etc) data about the product (color, model, part number etc) and a picture. This is private information and I want to remove the information daily. 2) an email needs to be sent to the customer 3 days later that takes a form letter template and merges with it information about the transaction (customer name, product, salesman picture etc.). There will be a link on the email that directs the customer to a form where they can refer another potential customer to the salesman. For each referral they will be put in the draw for the monthly prize. 3) The customer will get login information to a website. Once the customer logs in they will be asked to complete a survey, they will be asked to referr others that may be interested in the product. For each referral the will be put in the draw for a monthly price. I would like to make these three separate applications for simplicity and reliability. The question is that I don't want to keep the customers information online in (Task 1) so I will download and clear each order every day. Every day I would like to move the daily transactions from Task 1 application to the Task 2 application so that email can be sent 3 days later. I would also like to move the data from Task 1 to Task 3 application. Is this possible with postgresql? Thanks
В списке pgsql-novice по дате отправления: