The best Hacker News stories from Show from the past day
Latest posts:
Show HN: My Go SQLite driver did poorly on a benchmark, so I fixed it
<a href="https://github.com/ncruces/go-sqlite3">https://github.com/ncruces/go-sqlite3</a> was doing poorly on this benchmark that was posted yesterday to HackerNews [1].<p>With the help of some pprof, I was able to trace it to a serious performance regression introduced two weeks ago, and come up with the fix (happy to field questions, if you're interested in the nitty gritty).<p>It's not the fastest driver around, but it's no longer the slowest: comfortably middle of the pack.
It's based on a WASM build of SQLite, and thanks to <a href="https://wazero.io" rel="nofollow noreferrer">https://wazero.io</a> doesn't need CGO.<p>[1]: <a href="https://news.ycombinator.com/item?id=38626698">https://news.ycombinator.com/item?id=38626698</a>
Show HN: My Go SQLite driver did poorly on a benchmark, so I fixed it
<a href="https://github.com/ncruces/go-sqlite3">https://github.com/ncruces/go-sqlite3</a> was doing poorly on this benchmark that was posted yesterday to HackerNews [1].<p>With the help of some pprof, I was able to trace it to a serious performance regression introduced two weeks ago, and come up with the fix (happy to field questions, if you're interested in the nitty gritty).<p>It's not the fastest driver around, but it's no longer the slowest: comfortably middle of the pack.
It's based on a WASM build of SQLite, and thanks to <a href="https://wazero.io" rel="nofollow noreferrer">https://wazero.io</a> doesn't need CGO.<p>[1]: <a href="https://news.ycombinator.com/item?id=38626698">https://news.ycombinator.com/item?id=38626698</a>
Show HN: My Go SQLite driver did poorly on a benchmark, so I fixed it
<a href="https://github.com/ncruces/go-sqlite3">https://github.com/ncruces/go-sqlite3</a> was doing poorly on this benchmark that was posted yesterday to HackerNews [1].<p>With the help of some pprof, I was able to trace it to a serious performance regression introduced two weeks ago, and come up with the fix (happy to field questions, if you're interested in the nitty gritty).<p>It's not the fastest driver around, but it's no longer the slowest: comfortably middle of the pack.
It's based on a WASM build of SQLite, and thanks to <a href="https://wazero.io" rel="nofollow noreferrer">https://wazero.io</a> doesn't need CGO.<p>[1]: <a href="https://news.ycombinator.com/item?id=38626698">https://news.ycombinator.com/item?id=38626698</a>
Show HN: Hacker News Git Blame
One night I was deep in a rabbit hole, reading old HN comments. I eventually ended up scraping a bunch of usernames and building a game!<p>Please suggest any other users who you'd want to see/upstanding members of the community who deserve to be featured.
Show HN: Hacker News Git Blame
One night I was deep in a rabbit hole, reading old HN comments. I eventually ended up scraping a bunch of usernames and building a game!<p>Please suggest any other users who you'd want to see/upstanding members of the community who deserve to be featured.
Show HN: Octopus – a directed acyclic graph for app development
Directed acyclic graphs are muched discussed in comp-sci, but octopus appears to be the first reusable, turnkey, ready-to-wear, off-the-shelf implementation of a DAG for application development, in any language, that I'm aware of.<p>This is remarkable because DAGs hit a sweet spot in the middle of the three common programming paradigms (OO, event-driven, functional). Let's have a DAG as the top-level structure of our applications. Data-fetching and onChange handlers live in DAG nodes, next to the data they act on. The UI flows out from the DAG with fine-grained reactivity. Our app state is effortlessly consistent, because any outside change (user action, api result) unleashes a graph traversal. Our UI components become much simpler, because they just need to dumbly reflect values in the graph.<p>I'm putting this up for a second time. Absolutely no-one bit the first time, which can't be right :-)
Show HN: Octopus – a directed acyclic graph for app development
Directed acyclic graphs are muched discussed in comp-sci, but octopus appears to be the first reusable, turnkey, ready-to-wear, off-the-shelf implementation of a DAG for application development, in any language, that I'm aware of.<p>This is remarkable because DAGs hit a sweet spot in the middle of the three common programming paradigms (OO, event-driven, functional). Let's have a DAG as the top-level structure of our applications. Data-fetching and onChange handlers live in DAG nodes, next to the data they act on. The UI flows out from the DAG with fine-grained reactivity. Our app state is effortlessly consistent, because any outside change (user action, api result) unleashes a graph traversal. Our UI components become much simpler, because they just need to dumbly reflect values in the graph.<p>I'm putting this up for a second time. Absolutely no-one bit the first time, which can't be right :-)
Show HN: Airdraw
Hey Everyone! I wanted to show my passion project I made a few years back and recently turned into a web app.<p>Airdraw is an app that takes in your hand gestures and converts it into real time drawing capabilities.<p>There are tons of stuff I want to build with this, but most importantly just put it out into the world! Hope you all enjoy :)<p>Tested on my MacOS with Chrome, Safari, and FF<p>I included a link to the original GH project I wrote here - <a href="https://github.com/arefmalek/airdraw">https://github.com/arefmalek/airdraw</a>
and a link to the blog where I explained how I made it here - <a href="https://arefmalek.github.io/blog/Airdraw/" rel="nofollow noreferrer">https://arefmalek.github.io/blog/Airdraw/</a><p>If anyone has issues with loading, try again with this link - <a href="https://web-draw-e58vy7q9m-arefmalek.vercel.app/" rel="nofollow noreferrer">https://web-draw-e58vy7q9m-arefmalek.vercel.app/</a>. AFAIK, IOS livestream doesn't allow a canvas overlay so you would be able to draw, but not see anything until you exit the livestream. Hope someone has a sol for that ¯\_(ツ)_/¯
Show HN: Airdraw
Hey Everyone! I wanted to show my passion project I made a few years back and recently turned into a web app.<p>Airdraw is an app that takes in your hand gestures and converts it into real time drawing capabilities.<p>There are tons of stuff I want to build with this, but most importantly just put it out into the world! Hope you all enjoy :)<p>Tested on my MacOS with Chrome, Safari, and FF<p>I included a link to the original GH project I wrote here - <a href="https://github.com/arefmalek/airdraw">https://github.com/arefmalek/airdraw</a>
and a link to the blog where I explained how I made it here - <a href="https://arefmalek.github.io/blog/Airdraw/" rel="nofollow noreferrer">https://arefmalek.github.io/blog/Airdraw/</a><p>If anyone has issues with loading, try again with this link - <a href="https://web-draw-e58vy7q9m-arefmalek.vercel.app/" rel="nofollow noreferrer">https://web-draw-e58vy7q9m-arefmalek.vercel.app/</a>. AFAIK, IOS livestream doesn't allow a canvas overlay so you would be able to draw, but not see anything until you exit the livestream. Hope someone has a sol for that ¯\_(ツ)_/¯
Show HN: Airdraw
Hey Everyone! I wanted to show my passion project I made a few years back and recently turned into a web app.<p>Airdraw is an app that takes in your hand gestures and converts it into real time drawing capabilities.<p>There are tons of stuff I want to build with this, but most importantly just put it out into the world! Hope you all enjoy :)<p>Tested on my MacOS with Chrome, Safari, and FF<p>I included a link to the original GH project I wrote here - <a href="https://github.com/arefmalek/airdraw">https://github.com/arefmalek/airdraw</a>
and a link to the blog where I explained how I made it here - <a href="https://arefmalek.github.io/blog/Airdraw/" rel="nofollow noreferrer">https://arefmalek.github.io/blog/Airdraw/</a><p>If anyone has issues with loading, try again with this link - <a href="https://web-draw-e58vy7q9m-arefmalek.vercel.app/" rel="nofollow noreferrer">https://web-draw-e58vy7q9m-arefmalek.vercel.app/</a>. AFAIK, IOS livestream doesn't allow a canvas overlay so you would be able to draw, but not see anything until you exit the livestream. Hope someone has a sol for that ¯\_(ツ)_/¯
Show HN: Airdraw
Hey Everyone! I wanted to show my passion project I made a few years back and recently turned into a web app.<p>Airdraw is an app that takes in your hand gestures and converts it into real time drawing capabilities.<p>There are tons of stuff I want to build with this, but most importantly just put it out into the world! Hope you all enjoy :)<p>Tested on my MacOS with Chrome, Safari, and FF<p>I included a link to the original GH project I wrote here - <a href="https://github.com/arefmalek/airdraw">https://github.com/arefmalek/airdraw</a>
and a link to the blog where I explained how I made it here - <a href="https://arefmalek.github.io/blog/Airdraw/" rel="nofollow noreferrer">https://arefmalek.github.io/blog/Airdraw/</a><p>If anyone has issues with loading, try again with this link - <a href="https://web-draw-e58vy7q9m-arefmalek.vercel.app/" rel="nofollow noreferrer">https://web-draw-e58vy7q9m-arefmalek.vercel.app/</a>. AFAIK, IOS livestream doesn't allow a canvas overlay so you would be able to draw, but not see anything until you exit the livestream. Hope someone has a sol for that ¯\_(ツ)_/¯
Show HN: I scraped 25M Shopify products to build a search engine
Hi HN! I built Agora as a side-project leading up to the holiday season. I wanted to find an easier way to find Christmas gifts, without needing to go store-by-store.<p>My wife asked me for a a pair of red shoes for Christmas. I quickly typed it into Google and found a combination of ads from large retailers and links to a 1948 movie called 'Red Shoes'. I decided to build Agora to solve my own problem (and stay happily married). The product is a search engine that automatically crawls thousands of Shopify stores and makes them easily accessible with a search interface. There's a few additional features to enhance the buying experience including saving products, filters, reviews, and popular products.<p>I've started with exclusively Shopify stores and plan to expand the crawler to other e-commerce platforms like BigCommerce, WooCommerce, Wix, etc. The technical challenge I've found is keeping the search speed and performance strong as the data set becomes larger. There's about 25 million products on Agora right now. I'll ramp this up carefully to make sure we don't compromise the search speed and user experience.<p>I'd love any feedback!
Show HN: Django Ninja CRUD – Rethinking CRUD Operations in Django
I've developed Django Ninja CRUD, a tool to simplify CRUD operations in Django by leveraging Django Ninja's strengths. It aims to make CRUD operations more intuitive, modular, and efficient, especially for large-scale projects.<p>Key aspects:
- Declarative, intuitive CRUD operations.
- Modular approach with composition-over-inheritance.
- Enhanced testing capabilities for robust applications.<p>The tool is designed to transform Django development workflows, improving efficiency and maintainability.<p>Read more about the development, features and roadmap here: <a href="https://medium.com/@hbakri/introducing-django-ninja-crud-ee937bd2ea65" rel="nofollow noreferrer">https://medium.com/@hbakri/introducing-django-ninja-crud-ee9...</a><p>GitHub Repository: <a href="https://github.com/hbakri/django-ninja-crud">https://github.com/hbakri/django-ninja-crud</a><p>I'm eager to hear your feedback and hope it adds value to your Django projects!
Show HN: Django Ninja CRUD – Rethinking CRUD Operations in Django
I've developed Django Ninja CRUD, a tool to simplify CRUD operations in Django by leveraging Django Ninja's strengths. It aims to make CRUD operations more intuitive, modular, and efficient, especially for large-scale projects.<p>Key aspects:
- Declarative, intuitive CRUD operations.
- Modular approach with composition-over-inheritance.
- Enhanced testing capabilities for robust applications.<p>The tool is designed to transform Django development workflows, improving efficiency and maintainability.<p>Read more about the development, features and roadmap here: <a href="https://medium.com/@hbakri/introducing-django-ninja-crud-ee937bd2ea65" rel="nofollow noreferrer">https://medium.com/@hbakri/introducing-django-ninja-crud-ee9...</a><p>GitHub Repository: <a href="https://github.com/hbakri/django-ninja-crud">https://github.com/hbakri/django-ninja-crud</a><p>I'm eager to hear your feedback and hope it adds value to your Django projects!
Show HN: Play Othello in your web browser (made with Mithril)
Show HN: Play Othello in your web browser (made with Mithril)
Show HN: PyApp – runtime installer for Python applications
Show HN: PyApp – runtime installer for Python applications
I benchmarked six Go SQLite drivers
Show HN: Advent of Distributed Systems
Hey! I built a playground called Advent of Distributed Systems (<a href="https://aods.cryingpotato.com/" rel="nofollow noreferrer">https://aods.cryingpotato.com/</a>) where you can work through the Fly.io distributed systems challenges (<a href="https://fly.io/dist-sys/1/">https://fly.io/dist-sys/1/</a>) directly in your browser. Running challenges like this directly in the browser has often been the best way for me to get the activation energy to start them since it bypasses all the annoying dev environment setup that has to happen as a precursor to working on it.<p>The coding environment was built with another project I'm working on called Cannon (<a href="https://cannon.cryingpotato.com/" rel="nofollow noreferrer">https://cannon.cryingpotato.com/</a>) that aims to let you embed codeblocks of any language in your browser. Right now the Go environment runs on a Modal backend using their sandbox, but I'm hoping to use the excellent work done on Hackpad (<a href="https://github.com/hack-pad/hackpad/tree/main">https://github.com/hack-pad/hackpad/tree/main</a>) to run the whole thing in your browser, with no network calls necessary, soon.<p>Let me know what you think - week 3 is coming out soon!