kenn

Joined 15 years ago

Karma
77
Submissions
21
Member since
Dec 27
http://twitter.com/kenn
View on Hacker News

Recent submissions

Comment · 2 years ago
Comment · 11 years ago
It would be slow on MySQL, though.

If you EXPLAIN that query, it's a DEPENDENT SUBQUERY which has to fetch N*M records. It would be mitigated if the columns are property indexed, but two separate queries (N+M) just as eager loading would be faster and more predictable than nested scans in terms of IOPS.

Comment · 11 years ago
That works, but what if there are thousands of comments? Initializing N*M AR objects could be even slower than N+1 queries.

I wish if we could do something like:

has_one :approved_comments_count, -> { select(:post_id, 'COUNT(comments.post_id) as comment_count').group(:post_id) }, class_name: 'Comment'

and

posts.includes(:approved_comments_count).map(&:comment_count)

Comment · 13 years ago
This is actually like JSON, but with better parse-ability and aggregate-ability by UNIX commands.
Comment · 14 years ago
Thank you. I think you made a good point - by not charging I may be actually making people skeptical. We even have a vibrant developer community on bots and extensions, but it's barely known (shit, I realized that it's not even mentioned on the top page). I'll have to come up with some turnaround ideas.
Comment · 14 years ago
As a founder of http://lingr.com, I know firsthand how hard to build a chat app and make it sustainable. I've been working on it since 2006, first as a startup, then as my personal side project.

I've learned to not invest too much on the project, staying with the minimum server cost, and that's the only sustainable way for me. In fact it costs me almost nothing and users have built trust on me for running it for 6 years.

I'd give her tons of credit for trying to turn it into a real business. That's what I've been failing so far, or maybe I just don't even have the guts to do. I admire her courage and thus feel really sorry.

Hopefully I'll find another course, who knows.

Comment · 14 years ago
The title is misleading. They will no longer accept new signups, but continue to work.
Comment · 14 years ago
Comment · 14 years ago
Validate if he/she's a good fit for your team first. Usually it takes time. Equity has a permanent effect and you don't want to make a decision in haste.

Live from the official Hacker News API

A modern reader for Hacker News · SvelteKit + Skeleton