HNHacker News
TopNewBestAskShowJobs

zapstar

223 karma · joined September 19, 2019

Current project: playbookwriter.com
submissionscomments
zapstar··on Do you really need Redis? How to get away with just PostgreSQL
I have done something similar to this to implement queues in Postgres. And at quite a large scale with lots of workers all pulling items off the queue at once.

One huge advantage over, say, SQS, is that you also get easy visibility! You can query and see what’s been completed, what’s still not worked on, etc.!

Oh, and do you want a priority queue? Just add a priority field and sort before picking an item! Do you need to change the priority of an item while it’s already in the queue? Go right ahead. Do you want to enforce some constraints so that duplicates don’t get added to the queue? It’s a database — add the constraints.

If you’re already using a relational database, and now you need a queue, start with this approach. Odds are, it’ll work just fine, and it’ll give you the perks above.

zapstar··on Someone attacked our company
What would the motivation be for such an attack? Any thoughts on who could be behind it?
zapstar··on Show HN: Create a 3D book cover and embed it on your website
Is there an example or demo? The home page appears to be just text and no images.
zapstar··on Show HN: okaycup.com – Price analysis for mediocre cups of coffee
After experimenting with Amazon price tracking with my other project [0], I decided to dive a bit deeper within a specific product category -- k-cups! I spent a lot of time pulling together the many brands and flavors, although there's certainly more.

My goal was to make it somewhat reminiscent of restaurant menus (remember those?), but highlighting the price that you pay per pod. I find this site useful for myself, so that's why I made it. (Yes, I drink k-cups... But hey, I have two young kids, so I think I have an excuse. I had to put a pause on the french press.)

For all of you who are also working from home and drinking k-cups non-stop, I'm hoping you, too, will find this site useful. I'd love to hear any feedback you have, good or bad!

[0] https://unitprice.org

zapstar··on Amazon’s $23M book about flies (2011)
Thank you! One day I hope to expand beyond the US Amazon!
zapstar··on Amazon’s $23M book about flies (2011)
While working on my side project [0], I regularly find some pretty outlandish prices on Amazon. This post makes me want to add further analysis on 3rd party prices and how they relate to one another.

[0] https://unitprice.org

zapstar··on Show HN: My Indie Hacker goal - Earn $100 a day to keep your desk job away
"This might look small sometimes and easy to achieve but it's not"

I would never think that. $200 a day is fantastic! And $300 seems like quite a goal! Good for you. This must have required a lot of work, and I'm sure there were failures along the way.

What's your secret? How do you decide which projects to work on?

zapstar··on Lego IKEA Bygglek – First Look
100% agree. A few have slipped into our collection, and they are very noticeable.

Buying the Creative sets [0] are a fairly cheap way to get brand new official Lego and build out your collection. 4 cents a piece isn’t too bad!

[0] https://unitprice.org/lego/sets/creative

zapstar··on Show HN: LeetDeals – Price Tracking for PS4 Games
How are you getting updated pricing from Target? Do they have an API, or are you scraping?

I've thought about adding Target prices to my website [0], but Amazon's API is so nice, and scraping is a frustrating alternative.

[0] https://unitprice.org

zapstar··on Lego IKEA Bygglek – First Look
Absolutely. You can also find great deals at thrift stores. But there’s nothing like having your kid open up a brand new set of Legos.
zapstar··on Lego IKEA Bygglek – First Look
I love your math! My website [0] does literally only this calculation. I’m super excited about this collaboration between LEGO and IKEA.

[0] https://unitprice.org/lego

zapstar··on Ask HN: Successful one-person online businesses?
I do not scrape Amazon. That would be practically impossible, especially if you want to keep your costs low.

I utilize their product advertising API, which provides enough data for my needs (since I'm not interested in every single product and I only update once a day presently).

The manual part is figuring out how many units are in each item. For Lego, it's pieces. For Poptarts, it's individual pastries. For toilet paper, it's individual sheets of TP. Every product is slightly different, and it's often times not obvious. Once this manual part is done once for an item, I never have to do it again -- it gets an updated price from the API, calculates the unit price (because it already knows the total units), and then it updates the website.

zapstar··on Ask HN: Successful one-person online businesses?
Oh no, sorry if there was a misunderstanding. I said "sadly" because it is so unfortunate that we are all in this current situation -- a pandemic. And it feels "sad" in this specific context because I am seeing an uptick in searches for toilet paper, a result of people being unable to find it anywhere else. It's a sad state of affairs all around. I have no judgement on people buying extra toilet paper.
zapstar··on Ask HN: Successful one-person online businesses?
Define "success"... I make a few bucks a day from https://unitprice.org and it doesn't require any effort from me on a day-to-day basis. (I calculate the best price per unit on Amazon for a variety of different products, so the money I make from the affiliate links is typically enough to cover the cost of hosting plus an extra Lego set or two for my son.)

Sadly, I have seen an uptick in revenue as a result of COVID-19, because my website is showing up a lot in search results for toilet paper.

zapstar··on Amazon Isn’t the Only Shop Online
I have been very impressed with ordering online at Target. Many items that my local grocery store did not have were able to be shipped to me in 2 days. I hope maybe this can help with your situation, at least as far as non-perishable food is concerned.

(They do have warnings on every product now about potentially being out of stock, but so far, they've been able to fulfill every order I've made.)

zapstar··on Ask HN: Has Coronavirus affected your online sales?
I run a site [1] that aggregates Amazon prices for a select number of product categories, and I’ve seen more and more search engine traffic for toilet paper, which is sad to see, as they are currently all sold out. (Note: I listed toilet paper long before Coronavirus. I despise anyone trying to profit from this awful pandemic.)

[1] https://unitprice.org

zapstar··on Pure CSS Landscape – An Evening in Southwold
This is incredible. But can you explain the “groin” tag?
zapstar··on The Warby Parker clones are imploding
Any chance you could describe chromatic aberrations? I’ve had some vision frustrations, and I feel like perhaps you’ve just described what I have. So did sticking with the thicker lenses help? Rather than the thinner? (I have a very high prescription as well, and I’ve always had the thinner lenses.)
zapstar··on Ask HN: What are some best practices when you're working from home?
I like the shoe idea. Excellent tip. No putting your feet up after you have your shoes on.
zapstar··on Ask HN: What are day to day “problems” that have verified solutions?
You posted this 12 days ago and 13 days ago. So my answer would be “system that can identify duplicate submissions.”
zapstar··on Ask HN: STEM toy for a 3 years old?
LEGO! Either traditional Lego (they have some Junior sets that are perfect to have them build along with a parent at that age) or Duplo. It's led to hours and hours of fun with my 2.5 year old. Even larger Lego sets he enjoys helping me build. And then he builds his own creations after!
zapstar··on A parody Twitter account hits a nerve with Silicon Valley VCs
While perhaps not worthy of a post on Hacker News, I do see the humor in this account, highlighting the humble brags of the VC world. I think what’s important or funny is that normally these people simply humble brag and then have their flock immediately praise them for all of their good deeds and fortune. An account suddenly calls them out, and they immediately find the “block” button.
zapstar··on Ask HN: How to Decline Cofounder Requests?
Keep saying “no thanks” and stay strong. You don’t owe them a reason or anything. You know you’ve got a good idea and you’re on the right track when everyone wants to simply ride on your coattails!
zapstar··on Show HN: Profit Hunt - Get inspired by profitable online projects
Do you have a threshold for how much a project should make each month?

My project has $30 in profit a month, but hey, that’s more successful than most! (And more successful than any other project I’ve launched!)

zapstar··on Can I buy your side project?
What is your budget?
zapstar··on Ask HN: Is it always difficult to find co-founders?
I'm always confused by questions about finding co-founders... Why do you need to find a co-founder? When it doesn't happen naturally, why not go it alone?
zapstar··on Ask HN: How do you stay focused and get s**t done?
* Set up "office hours" where coworkers can come and ask you questions. Even if you don't actually have an office, this is just a set period of time that you've blocked off for people to visit you at your desk and receive assistance.

* Turn off notifications on Slack, e-mail, etc., and only check those things periodically throughout the day. If you're cruising on some new feature, don't switch over to Outlook. Keep cruising.

* Don't be afraid to say "sorry, I'm in the middle of working on this thing -- I will follow up with you later." You are the only protector of your time. Everyone else will steal as much as you allow them to steal.

* Wear headphones. People are less likely to interrupt when you wear them.

zapstar··on Ask HN: Why should my company use source control?
Yes, if you're in the position to find a job elsewhere, do it. This is an uphill battle that you don't need to fight. And there's no guarantee that you would win -- reason is of no use here. The most perfectly-constructed rebuttal will not be effective.
zapstar··on Show HN: A site that shows you gift guides connecting products from Amazon
Thank you!

I am using Amazon's Product Advertising API to retrieve prices from Amazon. There are a few hoops to jump through in order to get access, but it's the most legitimate means of acquiring their pricing data, so that's why I took that route.

I have not done much keyword research at this time, but I definitely should. I get very little traffic currently -- but I do find the website useful for myself, so that's enough to keep it going!

zapstar··on Show HN: A site that shows you gift guides connecting products from Amazon
I like the simplicity of the layout, but I think one crucial data point is missing -- the price of each item that you're recommending!

If you add that, I think you'll find that you'll get some traffic via search engines. I would target specific subsets of people. Gifts for people who love pickles. Gifts for people who don't like cilantro. Gifts for people with goldfish. The common topics of dads and moms and children are already swamped with blog posts.

← PreviousPage 2 of 3Next →