Re: Building a notification system.

2018-07-16 Thread Dave Cramer
On 15 July 2018 at 23:25, Anto Aravinth wrote: > > > On Mon, Jul 16, 2018 at 8:02 AM, Christopher Browne > wrote: > >> On Sun, Jul 15, 2018, 5:30 AM Anto Aravinth, >> wrote: >> >>> Hello Everyone, >>> >>> >>> I'm playing around with postgresql with SO datasets. In the process, I >>> have

Re: Building a notification system.

2018-07-15 Thread Anto Aravinth
On Mon, Jul 16, 2018 at 8:02 AM, Christopher Browne wrote: > On Sun, Jul 15, 2018, 5:30 AM Anto Aravinth, > wrote: > >> Hello Everyone, >> >> >> I'm playing around with postgresql with SO datasets. In the process, I >> have dumped 60M questions data onto the postgresql. I'm trying to build a >>

Re: Building a notification system.

2018-07-15 Thread Christopher Browne
On Sun, Jul 15, 2018, 5:30 AM Anto Aravinth, wrote: > Hello Everyone, > > > I'm playing around with postgresql with SO datasets. In the process, I > have dumped 60M questions data onto the postgresql. I'm trying to build a > notification system on top of this, so that, when a user edits a

Re: Building a notification system.

2018-07-15 Thread Anto Aravinth
So just maintaining a notification table along with user id would do I believe. Just notifies the user if he/she has the userid in notification table and its not in read state. On Sun, Jul 15, 2018 at 10:23 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Sunday, July 15, 2018,

Re: Building a notification system.

2018-07-15 Thread David G. Johnston
On Sunday, July 15, 2018, David G. Johnston wrote: > On Sunday, July 15, 2018, Anto Aravinth > wrote: >> >> I'm not sure, how to get started with this. Read about NOTIFY: >> https://www.postgresql.org/docs/current/static/sql-notify.html >> >> >> Not sure that fits my use case, thanks for your

Re: Building a notification system.

2018-07-15 Thread David G. Johnston
On Sunday, July 15, 2018, Anto Aravinth wrote: > > I'm not sure, how to get started with this. Read about NOTIFY: > https://www.postgresql.org/docs/current/static/sql-notify.html > > > Not sure that fits my use case, thanks for your help in this. > It doesn't. You need to record time stamps for

Building a notification system.

2018-07-15 Thread Anto Aravinth
Hello Everyone, I'm playing around with postgresql with SO datasets. In the process, I have dumped 60M questions data onto the postgresql. I'm trying to build a notification system on top of this, so that, when a user edits a question, I need to show a notification to the user when he/she logs