burmecia (u/burmecia)

burmecia commented on Show HN: Insights.hn – Real-time Hacker News posts and comments analytics insights.hn/... · Posted by u/burmecia

jimmySixDOF · a year ago

Love that you have been improving this idea since 2012 !! I think enriching HN is a super interesting problem I have also thought about quite a lot. The realtime angle looks really good fun to see likes/page position as it happens. I notice you show "Top Comments" in the details and wonder how you determine this since afaik there is no concept of likes for individual comments only stories from the API. I need go looking at the API again I found one method somewhere that would return the whole story with all comments fully sorted in order together in a single json so I guess if the "best" comments float to the top of their branch you could track that over time. Just curious and wanted to say this looks amazing !!

burmecia · a year ago

Thanks, the "Top Comments" is sourced from the "kids" field of the "items" endpoint. As the API docs (https://github.com/HackerNews/API?tab=readme-ov-file#items) says, it is "in ranked display order" so I just used it to sort the top comments.

burmecia commented on Show HN: Insights.hn – Real-time Hacker News posts and comments analytics insights.hn/... · Posted by u/burmecia

PeterZaitsev · a year ago

One more thing, I would suggest to make comparisons linkable - I was looking to share with folks the graph of how MySQL vs PostgreSQL is doing, sadly the URL still links to generic keyword comparison tool

burmecia · a year ago

That's a good idea, will put it on to-do list.

burmecia commented on Show HN: Insights.hn – Real-time Hacker News posts and comments analytics insights.hn/... · Posted by u/burmecia

zX41ZdbW · a year ago

This is really great!

I can suggest more ideas that will be easy to add:

- a spark line or heat map of upvotes for every thread: https://github.com/ClickHouse/ClickHouse/issues/59020

- a built-in SQL editor for custom queries;

If you need help in supporting or hosting it, write to milovidov at clickhouse.com

burmecia · a year ago

Thanks for the ideas, heat map looks great! Will also consider add custom queries, it can be quite useful.

burmecia commented on Show HN: Insights.hn – Real-time Hacker News posts and comments analytics insights.hn/... · Posted by u/burmecia

PeterZaitsev · a year ago

Very cool. I was surprised though to see keywords seems to be hardcoded, would be great to be able to graph and keywords and phrases. Any decent search engine should be able to support that

burmecia · a year ago

yes, the keywords search is using full-text searching and it is not efficient so I hardcoded them. Will consider switch to use embedding, that will be more efficient and accurate, also can support custom keywords search. Thanks for your advice.

burmecia commented on Postgres as a CRON Server supabase.com/blog/postgre... · Posted by u/jerawaj749

burmecia · 2 years ago

https://news.ycombinator.com/item?id=26385229

burmecia commented on Supabase Clippy – ChatGPT for Supabase Docs supabase.com/blog/chatgpt... · Posted by u/kiwicopple

burmecia · 3 years ago

AFAIK, ChatGPT's training data is until 2021, can it answer questions based on the latest Supabase documents?

burmecia commented on Ask HN: What would be your stack if you are building an MVP today? · Posted by u/nvln

moneywoes · 3 years ago

Maybe next js instead of supabase?

burmecia · 3 years ago

Next.js is more about frontend, but Supabase is more on backend. I cannot see any conflicts of the two, they can work with each other flawlessly.

burmecia commented on Supabase Wrappers: A framework for building Postgres foreign data wrappers supabase.com/blog/postgre... · Posted by u/yurisagalov

chrisjc · 3 years ago

Wait, you're telling me that you can create materialized views using foreign tables in Postgres?

Is there a way to propagate changes from the foreign data source through the FDW to Postgres?

Or would it just be some kind of task polls the foreign data source pulling a delta?

burmecia · 3 years ago

You can create a custom function doing all the delta logic and use pg_cron to schedule it to periodically materialize data using FDW.

burmecia commented on Supabase Wrappers: A framework for building Postgres foreign data wrappers supabase.com/blog/postgre... · Posted by u/yurisagalov

chrisjc · 3 years ago

The blog post, repo and your comment still leave me a little confused about what Supabase's wrappers project is, the intent and its current state.

So this "wrappers" project is just a framework that simplifies the development and manages the curation and distribution of Postgres Foreign Data Wrappers? At the end of the day, are these just FDWs that run on top of any Postgres instance? Do I have to run Supabase to take advantage of the FDWs created through this framework?

Additionally one of your examples is Snowflake, but I don't see a matching SF FDW in your repo? Is there a generic JDBC/SQL/etc FDW for any SQL based database like Snowflake, Oracle, etc? Or is this just to create a spark in someone's mind (guilty!) about what is possible and yet to be implemented?

Despite my confusion, this sounds like a very exciting project to follow.

burmecia · 3 years ago

| At the end of the day, are these just FDWs that run on top of any Postgres instance?

Yes, the FDWs developed by Wrappers can be used on any Postgres db.

| Do I have to run Supabase to take advantage of the FDWs created through this framework?

No, you don't need to. Those are just normal FDWs can be used on any Postgres db.

| Is there a generic JDBC/SQL/etc FDW for any SQL based database like Snowflake, Oracle, etc?

The Snowflake FDW isn't developed yet, the example is just for concept demo. It has ClickHouse and BigQuery FDWs although they are not JDBC based. Generic JDBC FDW will need JVM embedded so it is not in plan at this moment.

Disclaimer: I am Supabase developer.