HN user

dacort

246 karma

I build stuff and run an Untitled Startup

Posts4
Comments113
View on HN

SQLite is amazingly prevalent as well. Your own phone probably has hundreds of SQLite databases on it. One challenge with SQLite, though, is you have to download the whole thing to make use of it.

Shameless plug, but I made a fun side project that allows Amazon Athena to read SQLite databases from S3. https://github.com/dacort/athena-sqlite

GitHub Audio 10 years ago

Reminds me of the (sadly) now defunct choir.io. Intro post > https://corte.si/posts/choir/intro/choir.html

They had a demo of Github realtime activity and I hooked it into a bunch of different events around the org - Salesforce/Yammer/Github/JIRA - was neat to have a "pulse" of daily activity in the background.

At what level, company size, and cash/equity split?

I'm co-founder of a local startup here w/~140 people and that's pretty comparable/above average to what I've seen depending on the cash/equity split. The big co's (Facebook, Amazon, Google, Twitter, et. al) will be higher than average due to the nature of how hard it is to hire good folks here.

Seattle is fantastic for people that enjoy the outdoors - hiking, backpacking, rock climbing, ski/snowboarding, camping. The closest ski/snow area is 45 minutes from the city. It doesn't get _too_ cold in Seattle proper - usually around 40° F. The nice thing is that you have the mountains nearby, so if you do want the cold weather it's a quick trip.

One word of caution around UW - your age is definitely on the higher end of other people that will be living in that area. Although the rents are cheap, that's usually for a reason. Reddit is a great resource for info on moving to Seattle --> https://www.reddit.com/r/Seattle/wiki/index

Would very much appreciate that as well as walk-through docs.

Got it up and running easily enough, and connected to Redshift. But seemed like creating a new "slice" required custom JSON params to define it. Unless I missed something?

edit: yep, missed something. Can "explore" a table by clicking it's link in the table listing.

Great insight into the changing landscape of a CTO as a company grows through rounds of funding in the first several years.

My experience (Series C, ~130 employees) echoes many of the points in this article.

I think one of my favorite things about this is that it actually makes product information available in the meta tags.

<meta property="twitter:item:variant1:id" value="n6NDAWFNqjkNZftJWq0BQw==" /> <meta property="twitter:item:variant1:title" value="Small" /> <meta property="twitter:item:variant1:inventory_count" value=1 /> <meta property="twitter:item:variant1:price" value=75000000 /> <meta property="twitter:item:variant1:tax_category" value="included_in_price" /> <meta property="twitter:item:variant1:last_updated" value=1409259500000 /> <meta property="twitter:item:variant1:attribute1:text" value="Small" />

JSON API 13 years ago

I was a little confused that an "author" rel would be retrieved from a "people" resource. Is there a way to define that author's are people other than the client knowing this?

I just replaced an EventMachine-based project with Celluloid::IO - it was a pretty simple replacement, although I had some issues with concurrent connections (https://github.com/celluloid/reel/issues/11).

I have yet to test it in production, but it looks pretty promising.

I had a lot of problems with EM blocking networks connections if an event loop was tying up CPU, but I suppose that's to be expected.

While I understand that real-time full-text indexing is a much more difficult problem to solve, I've got just under 1.5 billion tweets "indexed" in TweetStats. And I'm one person.

Granted, given the 30MM/day number they must be growing that index very quickly and they've likely hit that 1.5 mark pretty darn quickly.