HNHacker News
TopNewBestAskShowJobs

amypinka

30 karma · joined August 1, 2016

submissionscomments
amypinka··on Would you quit a job three months in?
Yes, businesses only seem to care what you've been up to lately. If you jump onto something else, this 3 month stint will be meaningless within a few years.
amypinka··on Ask HN: Favorite audio book for long drives?
The Steve Jobs biography. Listened to it while backpakcing in SE Asia.
amypinka··on Ask HN: Do You Trust Grammarly?
I trust it more than I trust myself to spot issues.
amypinka··on Ask HN: Best experience learning a skill online?
I watched ~25 Moog Grandmother videos by Once Upon a Synth on YouTube. It really helped me drive deep into subtractive analog synthesis.
amypinka··on Ask HN: What are the pieces of software that may last forever?
Libc, zlib, sqlite3
amypinka··on Time on Unix
https://outline.com/hhXnJ7
amypinka··on Ask HN: What's an unsolved problem in your field?
Just stop paying devs by the hour.
amypinka··on Ask HN: Perfect tooling for high-availability statistics?
Kdb
amypinka··on Benchmarking shell pipelines and the Unix “tools” philosophy
The full path calls a GNU tool, the other calls your shell's builtin function.
amypinka··on Ask HN: Fired from my first job – how do I talk about it during interviews?
You should only go to work to make money and further your career. Your next interview should know they've only got you in front of them because there is a pay rise on offer.

Don't spend more than a sentence or two discussing your previous role. Describe their business model and leave it at that.

90% of your interview should be finding out what skills and tech your new employer needs and explaining to them why you're perfect for delivering those skills.

amypinka··on Ask HN: Is There Really a Coder Shortage?
Its fine to leave gaps, the latest role is the most important. The .net work doesn't add much to a DS role so there isn't much weight in mentioning it and it shows you spent less than 100% of your focus on DS. If there aren't other candidates then that's fine but there are 10s of candidates that are more or less DS-only on paper.

If candidates could see the other applicant's CVs it would kick off an arms race.

amypinka··on Ask HN: Is There Really a Coder Shortage?
If you put a job spec out in London for anything technical you can easily get 1000s of CVs coming back. Location is super easy to filter on.

If you apply for a job, the experience you list should match the tech stack in the job spec. Don't list roles that aren't relevant (i.e. no .net if it's a Python role).

I helped hire a DS this week. Their CV was among 20 excellent candidates all in London with their latest role matching most of the tech stack we're looking for. All the candidates are in London. This is what you're competing against.

amypinka··on Ask HN: How do I improve our data infrastructure?
In benchmarks I've seen CStore is about 50% slower than Parquet on Spark.

Where is the transactional requirement? This person is working with a copy of the real data.

ETLs only need to be written once and if he decided on a PSQL approach he'd be writing ETLs to send the data there too. He's probably going to find a number of consistency problems so trying to normalise all this data again will just result in more work that won't make his team of DS' more productive.

If he's at ~1 TB of data today, where will he be in a few years time? What's the point of putting infrastructure in place that won't last for the next 10+ years?

amypinka··on Ask HN: How do I improve our data infrastructure?
I don't know your ratio of HDF5 to Parquet files but remember for every GB of parquet you have it will equate to about 10 GB of space needed in CSV or PostgreSQL's internal format. So your data set is probably closer to 1 TB than 100 GB.

Storing that data on S3 is probably 50% the price of storing it on EBS and you won't have the durability guarantees of S3 when you're using PostgreSQL on EBS volumes.

If you're both exploring data and building models then Spark is fine. Its APIs are no more complicated that anything else out there for these tasks.

Hive is doing nothing more than offering schema on read and shouldn't be something you're thinking much about.

PostgreSQL is row-oriented and won't be able to offer features like row-group statistics that allow queries to get minimum and maximum values for every 10-15K rows of data for the columns their interested in. This gives queries a huge speed up over needing to scan over rows rather than just the statistics for the columns their interested in.

Remember that you can have a single engineer run a single query on Spark and distribute it across several servers. This allows you to scale CPU and memory bandwidth in a way you won't be able to with PostgreSQL.

It sounds like your data isn't well organised. If you moved it around and put some consistent naming conventions in place that could help. You could also look to build an atlas of the data for newcomers to get an overall picture of what data you're storing and where it lives.

amypinka··on Homebrew 1.9.0
From: https://docs.brew.sh/Linuxbrew

> Linuxbrew does not currently support 32-bit x86 platforms. It would be possible for Linuxbrew to work on 32-bit x86 platforms with some effort. An interested and dedicated person could maintain a fork of Homebrew to develop support for 32-bit x86.

amypinka··on Pandas dropping Python 2 support
There was a call asking for volunteers to continue to support 2.7. There's something like 60K lines of Python code in the project so perhaps coding standards keeping the 3.x-specific syntax to a minimum means the project can continue to support a wide installation base without a great deal of overhead for any would-be 2.7 maintainer.
amypinka··on Ask HN: How do you send email in your early stage startup?
SES works for me. Do any of the cloud providers even allow SMTP from their IPs?
amypinka··on The Q Language
Seems plenty fast to me: http://tech.marksblogg.com/benchmarks.html
amypinka··on The Q Language
Documentation for kdb+/q. MS had a posting for their new Q# language today on HN so that might have inspired someone to post this.
amypinka··on The Q Language
The next time you buy some stock, thank the Q language for making it happen.