Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
rbranson
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
61 ms
·
601.
▲
by
rbranson
16y ago
I also use AndChat from my phone to hit the ZNC and carry conversations as I move between locations if needed. Good tips, thanks.
602.
▲
by
rbranson
16y ago
ZNC is awesome. I have it setup to retain the last 200 lines of text on each channel and dump them out when I connect to the bouncer.
603.
▲
by
rbranson
16y ago
We've been using 1.9.2 for client projects since the release of Rails 3. It's been a great move with very few code compatibility issues. 1.9.2 provides a very solid boost in performance over 1.8.7, especially when rendering ERB templates, w
604.
▲
by
rbranson
16y ago
Perhaps millions of great ideas and billions of pieces of knowledge have been lost to the almost entirely ethereal IRC as well. The somewhat permanent nature of Usenet and, to a lesser degree, mailing lists, subliminally changes the nature
605.
▲
by
rbranson
16y ago
It's kind of misleading to say that it's "only" 1% of borrowers file, because the scope of time is focused on one year, but not only do borrowers have a much larger average lifetime, but the impacts of bankruptcy last 10 years. If we say th
606.
▲
by
rbranson
16y ago
Was it indexing the faux-enum columns? First thing I would do would be to drop the index if there is one considering it will add very little to the selectivity of the query.
607.
▲
by
rbranson
16y ago
I'll definitely agree that attempting to run OLTP and analytics queries on a single PostgreSQL server is not going to turn out well. I'm not sure if there's a way around it though, even in theory (e.g. MapReduce isn't very good for OLTP).
608.
▲
by
rbranson
16y ago
That doesn't sound right. In default conditions, PostgreSQL will shy away from doing index scans unless you're operating on <0.1% of the table. The planner builds a selectivity figure for the table based on table dimensions, index stati
609.
▲
by
rbranson
16y ago
I've definitely been in these types of situations, having to make things work in a hostile environment or to meet a deadline. I am just recommending an option to avoid these types of situations for those who are able to seek out the best pr
610.
▲
by
rbranson
16y ago
Not fully implemented? I'm pretty sure all of the billions of requests that hit nginx, varnish, haproxy, and Zeus would disagree with you. What about all those massive sites using memcached on the backend? You know -- Facebook, Twitter, Dig
611.
▲
by
rbranson
16y ago
I couldn't agree more with your last statement, but I was trying to sound unbiased ;)
612.
▲
by
rbranson
16y ago
I have written quite a few very complex long-running queries with 10-12 tables involved and 4-5 deep nested SELECTs in PostgreSQL and never encountered a case where the query planner was just plain wrong. Most of this work started on 8.2. I
613.
▲
by
rbranson
16y ago
I think /64 was the guideline for the smallest divisible network an ISP should hand out. It basically allows for a household or organization to grow indefinitely while assigning anything that can hook up to the network a real IP address, wi
614.
▲
by
rbranson
16y ago
Open source databases would have never gotten to where they are if there weren't two top-notch competing projects. Without MySQL, PostgreSQL developers would have probably not as heavily focused on performance. Without PostgreSQL, MySQL wou
615.
▲
by
rbranson
16y ago
Not really. As the other poster said, IE was intentionally abandoned after Microsoft "won" the browser war to drag out the desktop market a few more years. Honestly, until the last few years, web development technology stagnated HEAVILY bec
616.
▲
by
rbranson
16y ago
Obviously at this point it is best used for applications that essentially provide a mobile interface to a web application that utilizes some of the advancements in UI design gained from the iPhone and Android generation of smartphones. Even
617.
▲
by
rbranson
16y ago
We are by no means out of IPv4 addresses. The next step is that all of the entities who needlessly snapped up /8 space early on and sat on it for so long will be selling it off. The list includes GE, Xerox, IBM, HP, Apple, MIT, Ford, Hallib
618.
▲
by
rbranson
16y ago
Agreed. It becomes especially complex in a distributed system with multiple users having access to the same data. For instance, even a simple message exchange, which has no data interdependency issues, an undo feature requires some kind of
619.
▲
by
rbranson
16y ago
I live in Memphis, Tennessee. $45k is way above our average household income and yet it's still not a lot of money. Maybe enough to scrape by for a family of four. You're talking about around $3,000/mo after taxes & health insurance ded
620.
▲
by
rbranson
16y ago
95% of the US? Maybe land area, but not population-wise. That's not very much in any metro over 1m population.
621.
▲
by
rbranson
16y ago
So run a postfix/sendmail gateway to fork a perl script to send email through the SES API? Doesn't this seem like kind of a kludge? Why not just send mail through the original SMTP server if you're going to take the time to set it up and ma
622.
▲
by
rbranson
16y ago
While I have extreme doubts, I really hope, for humanity's sake, that this is true. If it all pans out, this would likely be the greatest invention of the 21st century.
623.
▲
by
rbranson
16y ago
I'd understand this if they were charging for it, but it's free shit. It was nice enough that they took the time to put the video together and post it online. Come on.
624.
▲
by
rbranson
16y ago
Wow, that is pretty brutal. I hope it was done as in-crowd sarcasm.
625.
▲
by
rbranson
16y ago
Apple picks technologies and features that only enthusiasts would normally appreciate, and educates consumers on why these features mean something. Their products are an embodiment of an up-sell.
626.
▲
by
rbranson
16y ago
I agree. It's definitely meh without a useful and truly scalable database. That's the hard part. SimpleDB isn't particularly useful, and RDB isn't particularly scalable.
627.
▲
by
rbranson
16y ago
To add to the list: The HTC Touch Diamond2, which was released in Oct 2009, had a 480x800, 3.2" display. The HTC Touch Diamond, which was released in May 2008, had a 480x640, 2.8" screen. Both of those screens are around 300PPI.
628.
▲
by
rbranson
16y ago
The iPhone 4's display density at it's size had precedent. A high volume, remotely affordable, production 260+ PPI panel anywhere near as large as the iPad doesn't exist anywhere.
629.
▲
by
rbranson
16y ago
I was going to say! Most parents would be overjoyed if just one of their children or even grandchildren turned out like this.
630.
▲
by
rbranson
16y ago
Writes are limited to 1 per second, so HRD is not a good match when high usage is expected. This is per entity group, and it's not a strict limitation, it's an expectation of performance.
More ›