Hacker News Reader

misframeron Ask HN: Which countries have salaries $150k+ for software engineers

How common is that though? Your example doesn’t necessarily make the parent comment wrong.

misframeron Ask HN: What is the best DB for versioned time series?

Yeah. You can treat the version as just another attribute to identify the series.

misframeron Why Not to Build a Time-Series Database

Some of those we’ve looked at before and decided not to go with because of unknown observability, high operational requirements, or cost. But yeah, no real problems with data models or queries.

I think Druid has come the closest to the most ideal system for the requirements I’ve had to deal with, but haven’t used it yet.

Thanks, by the way! This helps a lot.

misframeron Why Not to Build a Time-Series Database

I understand. Can you give an example of a “modern distributed relational column-oriented database”?

Two capabilities that are important in my work are roll-ups (reducing resolution of data) and fast bulk deletes of old data.

misframeron Why Not to Build a Time-Series Database

> All the features you mentioned are already part of distributed column-oriented databases.

I disagree, but even if that was the case, not all of them perform well. For example, we could've used Cassandra for our use case at my previous employer but the lack of push-down aggregations (at the time, not sure if they're supported now) would've been terrible for our top-K aggregate queries.

misframeron Why Not to Build a Time-Series Database

It really depends. Capabilities like time-series-specific compression, automatic rollups, complex aggregations and/or ranking, stable storage in S3, clustering, and replication vary a lot and I think that's why we see so many TSDBs out there. I maintain a list of TSDBs[0] and it started as an evaluation of what already available for my previous employer to use. We didn't find one that fit our exact use case, so we ended up building our own on top of MySQL.

[0] https://misfra.me/2016/04/09/tsdb-list/

misframeron Ask HN: Best alternative to Gmail?

Their static file hosting is great too. Automatic Let’s Encrypt support!

misframeron Running a database on EC2? Your clock could be slowing you down

RDS doesn't support extensions like TimescaleDB or (as someone else mentioned) Citus.

misframeron Handling Notch on iPhone X, XS, XR, XS Max

I don't miss the button. What didn't you like about the missing button?

misframeron How We Made Joins Faster, Part Three

TimescaleDB can’t do distributes joins like CrateDB as described in this post.

misframeron SQLite Release 3.25.0 adds support for window functions

Expensify uses SQLite for their core database.

https://blog.expensify.com/2018/01/08/scaling-sqlite-to-4m-q...

misframeron Ask HN: Anyone been recruited by VC firms to work for their portfolio companies?

I haven’t been recruited that way but I have been contacted this way. I don’t have any experience with this process besides that.

Why wouldn’t you go through a VC firm? I think it seems fine, but then again I’ve never been through the entire process.

misframeron Algorithms Behind Modern Storage Systems

> That's the reason, for example, why Cassandra doesn't even offer range reads

This is not true. The reason why Cassandra doesn't support that is because of hashing of keys across the cluster -- you'd have to query all shards and merge the results. That has nothing to do with the LSM storage.

misframeron Amazon Aurora Backtrack

This takes advantage of log-structured storage so there isn't any "undoing".

misframeron Amazon Aurora Backtrack

Aurora uses a log-structured storage system, so they just point to a previous version that they haven't garbage collected.

misframeron DigitalOcean Introduces Kubernetes Product

Awesome! The TechCrunch article [0] shows "16GB -> 192GB" in the screenshot so I just wanted to confirm.

[0] https://techcrunch.com/2018/05/02/digital-ocean-launches-its...

misframeron DigitalOcean Introduces Kubernetes Product

Will there be a minimum size for a worker node?

misframeron We saved $50k/year with a Go microservice coded in a hackathon

According to [1] Oracle doesn't have transactional DDL either.

[1] https://stackoverflow.com/questions/4711447/oracle-ddl-and-t...

misframeron Ask HN: What investing tools do you use?

I just use Vanguard and their target retirement date fund for my age. I don’t have to manage anything or make any decisions.

Day-to-day I use Google Finance for quotes, but I might switch to Yahoo Finance because I’m not a fan of Google’s recent changes.

misframeron Show HN: Deploy a Go Lambda to Ping a Site in 20 Seconds

API Gateway isn't much at that rate.

(1 month) / (5 minutes) = 8760

"$3.50 per million API calls received, plus the cost of data transfer out, in gigabytes." [0]

8760 * ($3.50 / 1000000) = $0.03.

[0] https://aws.amazon.com/api-gateway/pricing/

misframeron Do or undo – there is no VACUUM

MySQL too (with InnoDB).

misframeron Ask HN: Is it possible to train oneself to be calmer/kinder?

I agree. I recommend reading "The Daily Stoic" as a good introduction, and the format makes you think about the principles on a daily basis.

misframeron Bootstrap 4

I started using Pure. https://purecss.io/

misframeron The hidden costs of serverless

Probably not the case with Serverless Aurora!

https://aws.amazon.com/blogs/aws/in-the-works-amazon-aurora-...

misframeron Ask HN: What do you use/do for keeping your eyes healthy

I have perfect vision but I use +1.00 reading glasses. That way my eye muscles aren't working hard all the time to focus up close.

misframeron Apple’s New iPhones Get a Lukewarm Reception from Buyers

Couldn't they have gotten more of them too?

misframeron Eight years of Go

I've been using Go at work and for my personal projects for over 4.5 years. I rarely have to sort. It's not a big deal for me.

misframeron Google's latest iPhone rival off to a rocky start

I have a 2015 rMBP and its audio sounds as good as through my CEntrance DACport Slim. Maybe my headphones aren't audiophile quality (Grado SR80i, Sony MDR-7506)?