The best Hacker News stories from Show from the past day
Latest posts:
Show HN: RAM Prices
I was inspired by this discussion <a href="https://news.ycombinator.com/item?id=39066480">https://news.ycombinator.com/item?id=39066480</a> about diskprices.com last month, and decided to go ahead and make a site for RAM. It's my first time building anything like this! Any tips / suggestions / calls for complete overhaul are welcome :)
Show HN: RAM Prices
I was inspired by this discussion <a href="https://news.ycombinator.com/item?id=39066480">https://news.ycombinator.com/item?id=39066480</a> about diskprices.com last month, and decided to go ahead and make a site for RAM. It's my first time building anything like this! Any tips / suggestions / calls for complete overhaul are welcome :)
Show HN: PRQL in PostgreSQL
This extension let's you write PRQL functions in PostgreSQL.<p>When I first saw PRQL on Hacker News a few months ago, I was immediately captivated by the idea, yet equally disappointed that there was no integration for PostgreSQL. Having previous experience with writing PostgreSQL extensions in C, I thought this was a great opportunity to try out the pgrx framework and decided to integrate PRQL with PostgreSQL myself.<p>The maintainers of both PRQL and pgrx were very nice to work with. Thanks guys.
Show HN: PRQL in PostgreSQL
This extension let's you write PRQL functions in PostgreSQL.<p>When I first saw PRQL on Hacker News a few months ago, I was immediately captivated by the idea, yet equally disappointed that there was no integration for PostgreSQL. Having previous experience with writing PostgreSQL extensions in C, I thought this was a great opportunity to try out the pgrx framework and decided to integrate PRQL with PostgreSQL myself.<p>The maintainers of both PRQL and pgrx were very nice to work with. Thanks guys.
Show HN: htmz – a low power tool for HTML
Show HN: htmz – a low power tool for HTML
Show HN: htmz – a low power tool for HTML
Show HN: I create a free website for download YouTube transcript, subtitle
Show HN: Hacker News Outliers
I made a little website with a server that collects only HN submissions with > 500 upvotes chronologically.<p><a href="https://hn.moritz.pm/" rel="nofollow">https://hn.moritz.pm/</a><p>It's quite simple because I wanted to learn from the project. But I think it's useful, to get a summary of what was important over the last days.<p>The UI is almost identical to the HN frontpage, you can click on the comments to view the thread and on the username to see the profile. The rest of the cards takes you to the submitted URL.
Show HN: Domino Fit – Domino Tiling Puzzle
Domino fit is a domino tiling puzzler I spent a lot of time both making and playing. Its like sudoku but with a geometric angle, the sum of the dots must match the row and column numbers.<p>It's running on Betsy, the server under my couch, and was made with typescript. I'm proud of it.<p>I hope you give it a shot, and appreciate any thoughts or criticisms!
Show HN: Domino Fit – Domino Tiling Puzzle
Domino fit is a domino tiling puzzler I spent a lot of time both making and playing. Its like sudoku but with a geometric angle, the sum of the dots must match the row and column numbers.<p>It's running on Betsy, the server under my couch, and was made with typescript. I'm proud of it.<p>I hope you give it a shot, and appreciate any thoughts or criticisms!
Show HN: Domino Fit – Domino Tiling Puzzle
Domino fit is a domino tiling puzzler I spent a lot of time both making and playing. Its like sudoku but with a geometric angle, the sum of the dots must match the row and column numbers.<p>It's running on Betsy, the server under my couch, and was made with typescript. I'm proud of it.<p>I hope you give it a shot, and appreciate any thoughts or criticisms!
Show HN: Domino Fit – Domino Tiling Puzzle
Domino fit is a domino tiling puzzler I spent a lot of time both making and playing. Its like sudoku but with a geometric angle, the sum of the dots must match the row and column numbers.<p>It's running on Betsy, the server under my couch, and was made with typescript. I'm proud of it.<p>I hope you give it a shot, and appreciate any thoughts or criticisms!
Show HN: SlideCross – a combination of a crossword and Rubik's Cube
Hello! Try out a 3x3 puzzle and click the question mark in the top right for a tutorial.<p>I'd really appreciate any feedback! Thanks
Show HN: AI Generated (Not-Real) User Avatar Images for Development Needs
Hello,<p>There are many services that return fake avatar images, but it can be hard to get consistent names and faces.<p>In this service ChatGPT was used to generate a list of users with various characteristics and Dall-E to generate their avatars, based on those.<p>You can get a random avatar image like so:
<a href="https://avatars.tzador.com/face" rel="nofollow">https://avatars.tzador.com/face</a><p>Or request a specific size, like so:
<a href="https://avatars.tzador.com/face?size=250" rel="nofollow">https://avatars.tzador.com/face?size=250</a><p>You can ask for specific gender, like so:
<a href="https://avatars.tzador.com/face?gender=female" rel="nofollow">https://avatars.tzador.com/face?gender=female</a><p>Also you can pin point with id param to get back always the same image:
<a href="https://avatars.tzador.com/face?gender=female&id=0987654321" rel="nofollow">https://avatars.tzador.com/face?gender=female&id=0987654321</a><p>If you need a list of fake users with their names, usernames and avatars, you can get it in JSON here.
<a href="https://avatars.tzador.com/faces" rel="nofollow">https://avatars.tzador.com/faces</a><p>Hope it helps someone, runs on CloudFlare, so should be fast, built using SvelteKit.
Show HN: AI Generated (Not-Real) User Avatar Images for Development Needs
Hello,<p>There are many services that return fake avatar images, but it can be hard to get consistent names and faces.<p>In this service ChatGPT was used to generate a list of users with various characteristics and Dall-E to generate their avatars, based on those.<p>You can get a random avatar image like so:
<a href="https://avatars.tzador.com/face" rel="nofollow">https://avatars.tzador.com/face</a><p>Or request a specific size, like so:
<a href="https://avatars.tzador.com/face?size=250" rel="nofollow">https://avatars.tzador.com/face?size=250</a><p>You can ask for specific gender, like so:
<a href="https://avatars.tzador.com/face?gender=female" rel="nofollow">https://avatars.tzador.com/face?gender=female</a><p>Also you can pin point with id param to get back always the same image:
<a href="https://avatars.tzador.com/face?gender=female&id=0987654321" rel="nofollow">https://avatars.tzador.com/face?gender=female&id=0987654321</a><p>If you need a list of fake users with their names, usernames and avatars, you can get it in JSON here.
<a href="https://avatars.tzador.com/faces" rel="nofollow">https://avatars.tzador.com/faces</a><p>Hope it helps someone, runs on CloudFlare, so should be fast, built using SvelteKit.
Show HN: macOS-cross-compiler – Compile binaries for macOS on Linux
Show HN: macOS-cross-compiler – Compile binaries for macOS on Linux
Show HN: Natural Language to SQL "Text-to-SQL" API
Hi HN- Today, we are releasing the hosted API for our natural language to SQL engine, which allows you to:<p>(1) Explain Your Data: Feed in dictionaries, dbt, schemas, Confluence docs - we'll understand the business context to your data.<p>(2) Train Your AI: Fine-tune an LLM (including GPT-4) specifically for your data, increasing accuracy and lowering latency<p>(3) Trust the Answer: See confidence scores with each AI-generated query, stay in control.<p>(4) Conduct complex SQL queries<p>Problem background - Developers struggle to build NL-to-SQL into products because LLMs do not work out-of-the-box; they lack metadata and business definitions. Existing NL-to-SQL tools struggle with context, complexity, and adapting to your data.<p>For example, given the question “what was the average rent in Los Angeles in May 2023?” a reasonable human would either assume the question is about Los Angeles, CA or would confirm the state with the question asker in a follow up. However, an LLM translates this to:<p><pre><code> select price from rent_prices where city=”Los Angeles” AND month=”05” AND year=”2023”
</code></pre>
Dataherald integrates with major data warehouses, including PostgreSQL, Databricks, Snowflake, BigQuery, and DuckDB.<p>You can try it now free – no fees, no credit card, no sales pitches, just get the API key and get going. Let us know if it works for you, even your complex queries. (<a href="https://console.dataherald.ai/playground" rel="nofollow">https://console.dataherald.ai/playground</a>)<p>While the open source version works just fine (<a href="https://github.com/Dataherald/dataherald">https://github.com/Dataherald/dataherald</a>), the hosted API might be a better fit for those looking for:
(1) someone else to take care of infrastructure setup,
(2) access to an Admin UI console where you can configure and monitor performance, and
(3) ability to invite team members to a project.<p>We're looking for feedback, particularly from anyone who can compare this performance to other NL-to-SQL products. Share your thoughts and join the conversation
For more background on the release: <a href="https://www.dataherald.com/news/introducing-dhai">https://www.dataherald.com/news/introducing-dhai</a>
Show HN: I made a Pinterest clone using SigLIP image embeddings
Click an image to get similar images.<p>I crawled Tumblr and used SigLIP to get vector embeddings for many images.<p>When you click an image, it finds the most similar vector embeddings in the database, and returns the corresponding images.