The best Hacker News stories from All from the past day
Latest posts:
Hospitals that make profits should pay taxes
Show HN: PostgreSQL index advisor
This is a Postgres extension that can determine if a query should have an index. For example, for this table:<p><pre><code> create table book(
id int primary key,
title text not null
);
</code></pre>
You can run `index_advisor()` to see if there should be an index on a select statement:<p><pre><code> select *
from index_advisor('select book.id from book where title = $1');
</code></pre>
And it will return (summarized):<p><pre><code> {"CREATE INDEX ON public.book USING btree (title)"}
</code></pre>
It works particularly well with pg_stat_statements[0] which tracks execution statistics of all SQL statements executed on your Postgres database.<p>It leans heavily on HypoPG[1], an excellent extension to determine if PostgreSQL will use a given index without spending resources to create them.<p>[0] pg_stat_statements: <a href="https://www.postgresql.org/docs/current/pgstatstatements.html" rel="nofollow">https://www.postgresql.org/docs/current/pgstatstatements.htm...</a><p>[1] <a href="https://github.com/HypoPG/hypopg">https://github.com/HypoPG/hypopg</a>
Show HN: I made a tool to clean and convert any webpage to Markdown
My partner usually writes substack posts which I then mirror to our website’s blog section.<p>To automate this, I made a simple tool to scrape the post and clean it so that I can drop it to our blog easily. This might be useful to others as well.<p>Oh and ofcourse you can instruct GPT to make any final edits :D
Redis re-implemented with SQLite
Redis re-implemented with SQLite
Obituary for a quiet life (2023)
Obituary for a quiet life (2023)
Ford Mustang Mach-E using BlueCruise at time of crash: NTSB
Ford Mustang Mach-E using BlueCruise at time of crash: NTSB
Lessons after a Half-billion GPT Tokens
Lessons after a Half-billion GPT Tokens
XZ backdoor story – Initial analysis
Summers: Inflation Reached 18% in 2022 Using the Government's Previous Formula
The FCC needs to stop 5G fast lanes
The darker side of being a doctor
The darker side of being a doctor
Show HN: Using Google Sheets as the back end/APIs of your app
Hello everyone!<p>At a company I worked for, we needed to develop an MVP (basically a web page) and apply certain business logic to a Google Drive spreadsheet that was frequently updated by the Sales team.<p>In this case, we had two options:<p>Develop a backend to replace the current spreadsheet and have the sales team use it as a new "backoffice" - This would take a very long time, and if the hypothesis we were testing was wrong, it would be time wasted.<p>Create the web page and use Google's SDK to extract data from the spreadsheet.<p>We chose to go with the second option because it was quicker. Indeed, it was much faster than creating a new backoffice. But not as quick as we imagined. Integrating with Google's SDK requires some effort, especially to handle the OAuth logic, configure it in the console, and understand the documentation (which is quite shallow, by the way).<p>Anyway! We did the project and I realized that maybe other devs might have encountered similar issues. Therefore, I developed a tool that transforms Google spreadsheets into "realtime APIs" with PATCH, GET, POST, and DELETE methods.<p>Since it's a product for devs, I think it would be cool to hear your opinions. It's still quite primitive, but the basic features already work.<p><a href="https://zerosheets.com" rel="nofollow">https://zerosheets.com</a>
Show HN: Using Google Sheets as the back end/APIs of your app
Hello everyone!<p>At a company I worked for, we needed to develop an MVP (basically a web page) and apply certain business logic to a Google Drive spreadsheet that was frequently updated by the Sales team.<p>In this case, we had two options:<p>Develop a backend to replace the current spreadsheet and have the sales team use it as a new "backoffice" - This would take a very long time, and if the hypothesis we were testing was wrong, it would be time wasted.<p>Create the web page and use Google's SDK to extract data from the spreadsheet.<p>We chose to go with the second option because it was quicker. Indeed, it was much faster than creating a new backoffice. But not as quick as we imagined. Integrating with Google's SDK requires some effort, especially to handle the OAuth logic, configure it in the console, and understand the documentation (which is quite shallow, by the way).<p>Anyway! We did the project and I realized that maybe other devs might have encountered similar issues. Therefore, I developed a tool that transforms Google spreadsheets into "realtime APIs" with PATCH, GET, POST, and DELETE methods.<p>Since it's a product for devs, I think it would be cool to hear your opinions. It's still quite primitive, but the basic features already work.<p><a href="https://zerosheets.com" rel="nofollow">https://zerosheets.com</a>
Show HN: Mazelit - My wife and I released our first game
Hey folks,<p>About a year ago my wife and I, both closing in on 40, quit our jobs at Red Hat to start a games company and learn game development. Many things happened along the road, and about a week ago we released our first (small) game on Steam.<p><a href="https://store.steampowered.com/app/2816120/Mazelit/" rel="nofollow">https://store.steampowered.com/app/2816120/Mazelit/</a><p>The demo is free to play up to level 8 (the final game plays up to level 80) and we'd appreciate any feedback you have, whether it's for the store page or the game itself.<p>We made the game in Godot 4.2 in roughly 3 months and I was working full time next to it. Since we ran into a bunch of roadblocks, we decided to also offer the entire source code up as a DLC in case someone wants to go look how we implemented the game, mod the game, or compile it for a different platform. The only thing we can't redistribute with the game code is the Steamworks SDK, which is available for download from Steam. (The game minus integration is fully runnable without the SDK, though.)<p>Cheers and happy weekend!
Show HN: Mazelit - My wife and I released our first game
Hey folks,<p>About a year ago my wife and I, both closing in on 40, quit our jobs at Red Hat to start a games company and learn game development. Many things happened along the road, and about a week ago we released our first (small) game on Steam.<p><a href="https://store.steampowered.com/app/2816120/Mazelit/" rel="nofollow">https://store.steampowered.com/app/2816120/Mazelit/</a><p>The demo is free to play up to level 8 (the final game plays up to level 80) and we'd appreciate any feedback you have, whether it's for the store page or the game itself.<p>We made the game in Godot 4.2 in roughly 3 months and I was working full time next to it. Since we ran into a bunch of roadblocks, we decided to also offer the entire source code up as a DLC in case someone wants to go look how we implemented the game, mod the game, or compile it for a different platform. The only thing we can't redistribute with the game code is the Steamworks SDK, which is available for download from Steam. (The game minus integration is fully runnable without the SDK, though.)<p>Cheers and happy weekend!