Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
fdr
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
41 ms
·
361.
▲
by
fdr
14y ago
> What end-user rights does the GPL grant or protect that the BSD license doesn't? The right to receive a copy of the implementation of the program they are using and re-distribute it freely. I say "right" here, because in the case of B
362.
▲
by
fdr
14y ago
Hm. That example is entertaining and creative, but not really consistent with the actual viewpoints of the FSF[0]. Choice statement: > Distributing free software is an opportunity to raise funds for development. > Don't wa
363.
▲
by
fdr
14y ago
I also do not care for the pull requests, for much the same reasons. I like there is a way to bring a branch to a maintainer's attention and updating its commit range in event of updates before it is accepted, but the way messages that res
364.
▲
by
fdr
14y ago
It'd be nice if it were an HTML magazine, or at least the PDF was simply linked and recirculated...the flash is...well... I uploaded this to Scribd at http://www.scribd.com/doc/92958129/Pgmag-01-Letter-web for my own convenience, but eith
365.
▲
by
fdr
14y ago
What Heroku features, products, or enforced architectural choices (like no permanent disk on the spawned processes) do you see as causing lock-in that you would plan around avoiding or taking into consideration for a migration off Heroku?
366.
▲
by
fdr
14y ago
> Some of the people try and get burned because features that MySQL did without anyone noticing now take so much time that one wonders if he triggered some strange bug that caused db to do full table scan where one is unnecessary. Then
367.
▲
by
fdr
14y ago
> The only grudge I have with PostrgreSQL is that when confronted with this problem PostgreSQL fans respond with "We've got MVCC so it is supposed to be slow. Stop thinking it's supposed to be fast." not with "Hmm... Maybe we should int
368.
▲
by
fdr
14y ago
As the other posters have said, it has been around forever, but was rewritten to be much faster and support a payload in 9.0.
369.
▲
by
fdr
14y ago
I basically find your sentiment accurate: databases with high concurrency support need to do a lot of work to do an accurate count(*). However, many that were not postgres supported index-only scans to do it. That doesn't change the algor
370.
▲
by
fdr
14y ago
> And then support it. This especially. I have been left quite bitter by the support situation on Android. When one takes into consideration that the low-end, but current-generation iPhone and a new Android phone cost about the same it
371.
▲
by
fdr
14y ago
To clear up a potential misconception, the availability characteristics of the new dev plan will probably be about the same as before. It is just that historically Heroku has had a hair-trigger about reporting any shared database being o
372.
▲
by
fdr
14y ago
> fast count() is possible via index-only scans in 9.2 I'd like to expand on this. It will be faster, but still involves an O(n) over the qualifying data, but it'll be a lot less data, particularly for tables with wider rows. To some e
373.
▲
by
fdr
14y ago
> - Windows functions: They are wonderful and I love them. But it is not an important factor at all. I disagree or would choose to qualify a number of the things you wrote, but I'll choose this one because I think it's the most interest
374.
▲
by
fdr
14y ago
It's seldom necessary and often impractical to have full-blown shared-everything everywhere. There is a yawning gap going from simple key-value to the relatively rich constraints and transaction processing SQL standardizes that is probably
375.
▲
by
fdr
14y ago
Internally there is also an interesting mechanism: when one connects, the backend hands you a "backend key", which is a 64 bit number. The client is intended to remember that number. Cancellations are processed by sending a cancel request
376.
▲
by
fdr
15y ago
Fair. Then what's the name of the implementation? The same as the language? How do I refer to: * Go, the specification * gccgo * 6g and friends: the compilers
377.
▲
by
fdr
15y ago
I don't think so; I think Golang could use a more well-optimized parser implementation, even if it remains written in Go.
378.
▲
by
fdr
15y ago
The most obvious balm is a logical replication solution. Unfortunately those require non-trivial implementation, but it's something that is in its broad generalities not controversial for inclusion. Dimitri Fontaine has posted a large patc
379.
▲
by
fdr
15y ago
Postgres was just not popular enough, I think; it's still considerably less popular than MySQL, and familiarity and operations counts for a lot. So I think the number of "marquee" names falls about in line with what one would expect. Face
380.
▲
by
fdr
15y ago
To some extent true, but when core counts increase, they tend to double. Given the very new version of PG and Linux required to get these scalability benefits, it is nice to seem them pipelined ahead of the EC2 curve...it takes a long time
381.
▲
by
fdr
15y ago
If I read the bill correctly, it only reduces oversight when there are 2000 or so investors: quite easily not enough to really enable the Kickstarter-startup vision.
382.
▲
by
fdr
15y ago
SOX is pretty extreme. I don't think it even applies to organizations that go over the 500 (soon to be 2000 with this bill, is that actually enough for super-microfunded kickstarter style startups?) investor limit, but I am no expert. I'm
383.
▲
by
fdr
15y ago
I'd like to dispute your assessment of "all north American cities." Consider San Francisco: http://maps.google.com/maps?q=mcdonalds+san+francisco,+ca... This is not a large number of McDonalds for a city this size. Most of the estab
384.
▲
by
fdr
15y ago
I, too, am weary of this provision. If there is no obligation to make information available, all this will do is embolden the inside-track of investors who can get information at the expense of everyone else. There will be strong pressure
385.
▲
by
fdr
15y ago
I refer to compressed artifacts in general, here. I do not consume "scene" artifacts. I am merely positing that there is no technical reason for the choice in this era. But having lived through the last one, I can understand why it bec
386.
▲
by
fdr
15y ago
Rar has become one of my hot-buttons, so I'll respond as a consumer of compressed files in general: Multi-file volumes are good and useful for many things, but last I checked, RAR doesn't offer a compelling advantage in performance, compres
387.
▲
by
fdr
15y ago
> Additionally, if fsync = on in this test, then you're mixing a file system test with a database test. Which is reasonable, given that file systems of any reasonable performance level (read: not user-space file systems) still tend to b
388.
▲
by
fdr
15y ago
I'm glad you like wal-e. I tried rather hard to make it as easy as I could to set up. Please send feedback or patches, I'm happy to work with someone if they had an itch in mind. If one has a lot of data, EBS becomes much more attractive b
389.
▲
by
fdr
15y ago
I agree with you insomuch as it's ideal for an extension, and argued for its inclusion as a 9.3 feature (looks like Christmas might come early, though). However, I concluded with this: Right now the perception of Postgres...actually, d
390.
▲
by
fdr
15y ago
I like the design of the Metro UI. I can find my way around, the transitions and layout is basically informative and attractive. In my mind, it beats the tar out of Android in those dimensions. I'm not sure if I could even call it inferi
More ›