Pages

Thursday, April 18, 2024

New best story on Hacker News: Show HN: PostgreSQL index advisor

Show HN: PostgreSQL index advisor
399 by kiwicopple | 95 comments on Hacker News.
This is a Postgres extension that can determine if a query should have an index. For example, for this table: create table book( id int primary key, title text not null ); You can run `index_advisor()` to see if there should be an index on a select statement: select * from index_advisor('select book.id from book where title = $1'); And it will return (summarized): {"CREATE INDEX ON public.book USING btree (title)"} It works particularly well with pg_stat_statements[0] which tracks execution statistics of all SQL statements executed on your Postgres database. It leans heavily on HypoPG[1], an excellent extension to determine if PostgreSQL will use a given index without spending resources to create them. [0] pg_stat_statements: https://ift.tt/Sz1mBA9... [1] https://ift.tt/YIer6Tj

Thursday, April 11, 2024

New best story on Hacker News: Show HN: I made a new sensor out of 3D printer filament for my PhD

Show HN: I made a new sensor out of 3D printer filament for my PhD
519 by 00702 | 98 comments on Hacker News.
Here's a "behind-the-scenes" look at my development of a cool sensor during my PhD (electrical engineering). This sensor is only about 1/3 of my total research for my degree and took about a year. I've been on HN for a while now and I've seen my fair share of posts about the woes of pursuing a PhD. Now that I'm done with mine I wanna share some anecdotal evidence that doing a PhD can actually be enjoyable (not necessarily easy) and also be doable in 3 years. When I started I knew I didn't want to work on something that would never leave the lab or languish in a dissertation PDF no one will ever read. Thanks to an awesome advisor I think I managed to thread the needle between simplicity and functionality. Looking back, the ideas and methods behind it are pretty straightforward, but getting there took some doing. It’s funny how things seem obvious once you've figured them out! Oh, I love creating GUIs for sensor data and visualizations as you'll see -- it's such a game changer! pyqtgraph is my go-to at the moment - such a great library.

New best story on Hacker News: Ask HN: What is the most useless project you have worked on?

Ask HN: What is the most useless project you have worked on?
587 by panqueca | 639 comments on Hacker News.
If you're feeling useless, remember that I exist. Let me give you some context. I work in the pipeline automation department of a company. Last month, our team decided to deprecate an internal tool due to several maintenance issues. So we created a pipeline that automates the implementation of this legacy tool, in case other teams needed to use it. (WHAT???) This month, a guy in my team found some improvement scenarios in the automation. So I was chosen to implement this changes in this legacy internal tool. The thing is, after I finished the adjustments, my pull requests are not getting approved due to adjustments meticulously requested by this guy in my team. Adjustments to make the pipeline automation even more resilient in complete unlikely scenarios. But this same week, my TL sent notices to all the other teams informing them that this internal tool has been deprecated and they should no longer use it. So what sense does it make to have a pipeline automation that implements the use of the deprecated tool? And if it has been deprecated, why would I need to make an adjustment for the automation to be even resilient if no one should be able to use it anymore? So why am I being allocated to work on in such waste of time like it? (WTF???) This makes me wonder, how many people have to work on something that they see no sense in doing at all. So once again, if you're feeling useless, remember that I exist.

New best story on Hacker News: Ask HN: What is the most useless project you have worked on?

Ask HN: What is the most useless project you have worked on?
572 by panqueca | 634 comments on Hacker News.
If you're feeling useless, remember that I exist. Let me give you some context. I work in the pipeline automation department of a company. Last month, our team decided to deprecate an internal tool due to several maintenance issues. So we created a pipeline that automates the implementation of this legacy tool, in case other teams needed to use it. (WHAT???) This month, a guy in my team found some improvement scenarios in the automation. So I was chosen to implement this changes in this legacy internal tool. The thing is, after I finished the adjustments, my pull requests are not getting approved due to adjustments meticulously requested by this guy in my team. Adjustments to make the pipeline automation even more resilient in complete unlikely scenarios. But this same week, my TL sent notices to all the other teams informing them that this internal tool has been deprecated and they should no longer use it. So what sense does it make to have a pipeline automation that implements the use of the deprecated tool? And if it has been deprecated, why would I need to make an adjustment for the automation to be even resilient if no one should be able to use it anymore? So why am I being allocated to work on in such waste of time like it? (WTF???) This makes me wonder, how many people have to work on something that they see no sense in doing at all. So once again, if you're feeling useless, remember that I exist.

Thursday, April 4, 2024