Re: exporting data from one DB to another asynchronously - Mailing list pgsql-novice

On Sun, 5 Mar 2006 13:24:04 -0800
"Nagita Karunaratne" <nagita.k@gmail.com> wrote:

> 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
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 1: if posting/reading
> through Usenet, please send an appropriate subscribe-nomail command
> to majordomo@postgresql.org so that your message can get through to
> the mailing list cleanly

Nagita,

You are asking the right questions of the wrong group.  Postgresql is a
database. Or more completely and Object-Relational Database Management
System.  Postgresql keeps track of data.  Your "problems" or tasks are
more appropriately in the area of application.  So if you want it to
postgresql can store your data that your salesman collects, that gets
e-mailed to customers, and that comes in via the web.  But in and of
itself it won't collect, send, or provide a web interface.

Good luck.

John

--
Well, anyway, I was reading this James Bond book, and right away I
realized that like most books, it had too many words.  The plot was the
same one that all James Bond books have: An evil person tries to blow
up the world, but James Bond kills him and his henchmen and makes love
to several attractive women.  There, that's it: 24 words.  But the guy
who wrote the book took *thousands* of words to say it.
    Or consider "The Brothers Karamazov", by the famous Russian
alcoholic Fyodor Dostoyevsky.  It's about these two brothers who kill
their father. Or maybe only one of them kills the father.  It's
impossible to tell because what they mostly do is talk for nearly a
thousand pages.  If all Russians talk as much as the Karamazovs did, I
don't see how they found time to become a major world power.
    I'm told that Dostoyevsky wrote "The Brothers Karamazov" to
raise the question of whether there is a God.  So why didn't he just
come right out and say: "Is there a God? It sure beats the heck out of
me." Other famous works could easily have been summarized in a few
words:

* "Moby Dick" -- Don't mess around with large whales because they
symbolize nature and will kill you.
* "A Tale of Two Cities" -- French people are crazy.
        -- Dave Barry