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 dumped
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
>>
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 questio
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, Dav
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 he
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
