Hacker News Reader

nimajalalion SQL: One of the most valuable skills

I’d add LATERAL JOINs to the list.

For those unaware of LATERAL JOINs, it’s like a for each loop in SQL. Blew my mind and opened up so many possibilities.

nimajalalion A Performance Cheat Sheet for PostgreSQL

Not exhaustive but this has come in handy: https://www.braintreepayments.com/blog/safe-operations-for-h...

nimajalalion Ask HN: What is your Golang web-dev tech stack?

go-kit https://gokit.io/

nimajalalion Introducing Soylent 1.6 Powder

Check out Keto Chow. https://www.thebairs.net/

nimajalalion Show HN: CanvasFlip 2.0 – UX Analytics Tool For Prototypes

https?

Also had a hard time figuring out if you supported Desktop based prototypes. Had to create an account and attempt to add a new prototype before seeing that Desktop was a supported option.

nimajalalion Ask HN: Best option for networking power outlets?

Ubiquitis mFi line of products. Each wall outlet cost ~$60, little over your budget but it's a great product. https://www.ubnt.com/mfi/inwall/

nimajalalion Ask HN: Moving where there is no internet

Yup. Specifically for this I would use one of their NanoStations, which one depends on a bunch of factors but the locoM5 is a solid choice when there's no obstructions and plenty of clearance.

nimajalalion Ask HN: Moving where there is no internet

If you can find someone willing to share their internet within line of site of your new place you could do a point to point.

Ubiquiti has great antennas that are relatively cheap. Unfortunately most ISP's won't allow you to use/share/resell your connection beyond your property, so be aware.

nimajalalion Ask HN: Best Home Surveillance Cam?

Mobotix makes great cameras. Not the cheapest but their cameras have an onboard computer which allows them to operate independently. Send emails, upload to ftp, etc...

nimajalalion Show HN: Instabug – easy in-app feedback. What do you think?

Will take a stab at it tonight.

nimajalalion Ask HN: Why is Bitcoin so volatile?

I think the volatility stems from people misusing the currency.

Bitcoin was designed to be a currency, a means of immediate exchange, however it is becoming more and more apparent that people are using it as a short term (possibly long term) investment.

nimajalalion Show HN: Instabug – easy in-app feedback. What do you think?

Very cool. Will be useful.

One side note is that the registration and login pages don't use https. Sending from the app to your service should be secure as well but not as important as the register and login pages.

nimajalalion Ask HN: how to best prepare for a technical interview at a top software company

Not sure how much time you have but this has helped me a lot.

http://codingforinterviews.com/

It doesn't look like they have historic emails but if you shoot me an email I'll forward them to you.

nimajalalion Ask HN: Freelancer? Seeking freelancer? (April 2013)

SEEKING FREELANCER. Remote or Local in Orange County, CA.

Need some talented people to help get an AngularJS web app out the door.

If you're interested shoot me an email with your rates and any past projects in AngularJS (nima AT jalali DOT net).