antoaravinth

Hello HN,

I was looking @ how reddit repo[1] evolved in the past, as we all know its closed now. I was just wondering, if there are any other open source projects that is very good at architecture level (like reddit which was very good) that is interesting to read on.

Thanks for your answer.

[1]:https://github.com/reddit/reddit

Hello All,

I have a fundamental knowledge on RDMS and have done data modelling in Postgresql (to some extend). I could able to make sense of what is Normalization, Joins, locks (specifically optimistic locking) etc.

I have learnt all these in my side projects mainly, or in production where the data isn't much huge. I haven't got any chance to debug a slow query or even select Indexing strategies etc which I guess is really important to understand RDMBS or postgresql in general.

I wanted to know are there any open source datasets, which will helpful for self studying or even debugging slow queries / seeing their indexing strategies etc.

Any answer would be appreciated.

Hi,

I'm trying to learn Progressive web app by building a simple HN application. I'm wondering whether the firebase HN Api does support push notifications. If so, any such examples would be really great.

Thanks.

Hi, Often I see experienced Java developers asking us to develop the system using Interfaces rather than starting with classes. Yes, I do create interfaces, I know whats its usecases are etc. However the term "design your system using interfaces" is somewhat confusing to me. Is it a pattern for designing robust application in Java world? How should one learn it?

If so are there any online books / blogs regarding the same?

Note: I had already asked the question in Java Subreddit, but I want to get HN community thoughts as well.