HNHacker News
TopNewBestAskShowJobs

mjirv

1,361 karma · joined June 21, 2014

Software and analytics engineer

https://delphihq.com

submissionscomments
mjirv··on Ask HN: What advice would you give to a computer science undergraduate?
Ironically this is the exact opposite advice I would give, as someone 3 years out of undergrad with lots of SWE and non-SWE (PM, consultant, banker) friends.

If a college student told me "I want to optimize for a career where I don't feel like a commodity, have lots of bargaining power (high wages, short hours, easy to switch jobs), and can easily start a business or consult on my own if I desire," I'd tell them: study computer science. SWEs I know at the big tech companies are being paid the same as my banker friends for half the hours (or less). The consultants and PMs are working longer hours for half the money and way less job security.

By definition if you're selling your labor on the job market you're being a commodity. I can't predict the future, but for now at least being a SWE seems the best way for a recent graduate to win some bargaining power back.

mjirv··on Show HN: OctoSQL – Query and join multiple databases and files, written in Go
This is great. I keep the following in my bash profile for querying CSVs with SQL, which works OK, but this is probably better:

  function csv_to_sqlite() {
    echo "used as csv_to_sqlite PATH_TO_CSV TABLE_NAME"
    sqlite3 -csv -cmd ".import $1 $2" -cmd ".headers on"
  }
Two suggestions:

1. It would be a lot more useful if I could link an entire database rather than just tables

2. Sometimes I just want to query a single CSV, so a command line argument where I can just specify the path would be nice

mjirv··on We Can Do Better Than SQL
I'm confused by this:

> In EdgeQL, sets are flat, i.e. a set (including an empty one) cannot be an element of another set

It seems like in the last example, they're returning a set (of movies) that contains other sets (directors, cast, reviews). Am I misunderstanding? I guess it would be helpful to see what the output looks like for these examples.

mjirv··on Armatron – ETL Done Well
To the folks at TrueCar who made this: are you planning to open source it or make it available for others to use? I can see it being useful in a lot of other industries.
mjirv··on Common mistakes in PostgreSQL
Anyone know which of these are true for Redshift as well?
mjirv··on Tableau Software Threatened? Rival Growing at 70% Just Raised $103M
Has anyone used Arcadia Data (the other company mentioned in the article) and have thoughts on it? I work in BI and had never heard of it before reading this.
mjirv··on Tableau Software Threatened? Rival Growing at 70% Just Raised $103M
Looker's API functionality is pretty extensive if that's something you care a lot about.
mjirv··on If you want to be massively successful, do not set ambitious goals
Has anyone read the book this is based on ("Why Greatness Cannot Be Planned")? I'm worried that this article is making a leap from "most successful people got there by pursuing novelty rather than goals" to "pursuing novelty is a better way than goals to become successful."
mjirv··on Q: Run SQL Directly on CSV Files
Maybe my bash just isn't good enough anymore, but I do this all the time. In fact, I was just doing some work this morning where I needed to load a CSV into SQLite for analysis.

Since I still had the file, I ran some queries on the same file via Q to test it out. And it works great! (With some handholding to get quoting and delimiters right). The major downside was it's pretty slow, presumably because it reloads the file into a SQLite database each time you run a command. So, I'll probably stick with loading CSVs into SQLite myself, but I could see this being a useful tool for running one-off analysis on data from stdin.

mjirv··on Who needs democracy when you have data?
It's also worth noting that Trump actually lost by the (small-d) democratic measure: the popular vote. What gave him the election was the Electoral College, an institution designed precisely to "protect" against "tyranny of the majority."

So if anything, Trump's election is a point in favor of more democracy, not less.

mjirv··on Founder to CEO: How to build a great company from the ground up
This is key. I suspect one could start a really effective startup (while paying significantly below market for good talent) with a policy like "work six hours from 10-4 and then leave to do something that recharges you."

In practice that's what many engineers (and some non-engineers) would be doing anyway whether or not they're physically in the office.

mjirv··on Prototyping a YC Startup Each Day
This is super cool and I'm looking forward to giving it a try. I support our finance team, and an easy way to create a GUI around API calls to our different systems would be great to automate/make self-service tasks that are really manual or that only I can do today as a programmer.

Right now I'd typically spin up a quick rails and/or react app for that, so I'm excited to see how Anvil compares. Personally I wish it supported Ruby, but I understand why you'd start with Python.

The number of tools that try to do something like this keeps growing (Bubble comes to mind, or Appian in a slightly more enterprise space), and for good reason. This space is all about execution really--I suspect within the next 5 years or so it'll become pretty easy and mainstream for semi-technical folks to easily create a web app, and I'll be interested to see what that solution looks like.

mjirv··on Joiner makes cross-database joins effortless. Here's why.
Hey, author/founder here. Actually... I agree (if I understand you correctly). Joiner exists to make cross-database joins really easy for an individual analyst, not to compete with the scalability of a traditional EDW. On the backend, it works by querying all those databases directly, rather than making copies of everything.

There's very likely a better phrase to describe it than "data warehouse."

mjirv··on Connecting data is hard. What if it wasn't?
Hey everyone, thanks for reading. I started Joiner to solve a problem for data analyst: it takes too long to get a traditional data warehouse set up, and the other options for joining across databases isn't great.

Like I mentioned in the article, Joiner can connect Postgres, MySQL, SQL Server, and Redshift right now, plus CSV uploads.

If this sounds useful, you can sign up for the beta at www.getjoiner.com. If not, I'd love to hear your feedback!

- Michael

mjirv··on New Zealand Study Provides More Support for Lead-Crime Hypothesis
The article implies men tended to have higher lead levels than women (otherwise, adjusting for sex wouldn't have done anything).

Does anyone know why this would be the case?

mjirv··on Ontario announces that it will begin a basic income trial in 2016
Assuming a progressive tax system they're basically the same thing. (1) is a simpler description, if less precise.
mjirv··on “RIP Twitter”: Twitter to Introduce Algorithmic Timeline as Soon as Next Week
Makes sense for Twitter to do this, with a couple conditions: 1. Keep existing users happy by letting them opt-in but not forcing them to, and letting them easily switch back 2. Default new users to the algorithmic timeline to get them hooked by providing good content right away (note: from people they aren't following?).

As an existing Twitter user with a highly curated timeline that I'm very happy with, I have no problem with this at all unless they force me to start using it.

mjirv··on Ad Blocking: A Primer
> Mani Gandham is co-founder and CEO of Instinctive.

The entire post is a native ad.

mjirv··on Getting ahead vs. doing well
Studies also show that people are happier when their income makes them relatively most wealthy compared to their peers, so this seems reasonable.
← PreviousPage 4 of 4