Viewing profile — burmecia

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 …

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

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

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, …

Hi HN, I'm excited to share a project I've been working on for the past few months: https://insights.hn/ , a real-time analytics platform for Hacker News posts and comments. Why di…

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

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

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.

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

| 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 Supaba…

| How well do foreign data wrappers work with Postgres's query planner? You can provide table size estimation to Postgres's query planner in wrappers using `get_rel_size()` functio…

Another interesting term not mentioned is 'qual', which basically has same meaning as 'restrictions'.

Our price model based on database usage which includes db egress, so we use it to monitor db egress traffic just for now. We are all db fans and we like put things into db, so all …

I like old solid tech like Postgres, libpcap and etc. Putting them together with new tech like Rust and pgx is also fascinating.

That's a nice approach, thanks for sharing with us.

Yes, you need root to grant capture permission to Postgres, but Postgres doesn't need to run as root. The main purpose is to easily ingest network traffic data into Postgres for fu…

Hey HN, I have spent some time to search for a tool that can ingest realtime network traffic data to Postgres but have no luck, so I developed this extension and used it internally…

pg_netstat is a Postgres extension to monitor database network traffic. It uses libpcap to capture packets and aggregates at user-specified interval.

I am building an encrypted file system that runs inside application ( https://github.com/zboxfs/zbox ). It focus on security, privacy and reliability. The interesting part is it ca…

Totally agree. To make file system crash-proof you really need an ACID compatible underlying storage layer or implement it inside the file system itself. In fact, file system and d…

I am using Rust building a privacy focused in-app file system ZboxFS( https://github.com/zboxfs/zbox ). The fun part is not only joyfulness Rust bring to me, but also learned a lot…

Database and filesystem share a lot similarity, but still have their own characteristics. To use database as a back-end for filesystem has some benefits, such as reliable persisten…

I don't think the encrypt-then-dedup is a safe way to protect data privacy. In this case, identical blocks need to produce same cipher text, this will actually leak your data patte…

I think any applications need store confidential files on client or remote can adopt it. Web and mobile app might be the best to use it at this moment. As there is transaction cont…

I think the best approach is never save unencrypted data on cloud. Always encrypted on client first. But by that way we lost dedup capability, so we have to do everything, such as …