Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
fdr
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
49 ms
·
391.
▲
by
fdr
15y ago
If you could imagine designing Postgres to be more enjoyable and productive to use in the earlier stages, what would you want?
392.
▲
by
fdr
15y ago
I agree. There was no WAL logging, for instance. Most people consider 7.4 the first actually-possibly-not-a-terrible-idea release. Then again, Postgres -- the project -- did not try to position itself (was there even such a thing as "posi
393.
▲
by
fdr
15y ago
It has a pretty good user experience, except for all the details. But the model isn't bad; it should be learned from. On the other hand, there is no trade-off made by Mongo that I'm aware of that is not fundamentally unavailable to more m
394.
▲
by
fdr
15y ago
My general feeling coincides with yours, I can't see how someone can look at Ruby and say it's consistent , although it's not the up to the insanity of C++ or Perl (people only make it that way with a combination of poor judgement and dyna
395.
▲
by
fdr
15y ago
These guys are small fry compared to other users of the Olson database software: IBM, Oracle, Apple, Google. There's your $500bn in market capitalization right there.
396.
▲
SQL: The Successful Cousin of Haskell
(thoughts.j-davis.com)
5 points
by
fdr
15y ago
|
0 comments
397.
▲
by
fdr
15y ago
At Heroku, free applications get idled out when no request comes in for a while. As a result, when the first request comes in after some time, it can take a few seconds to find a piece of iron to run the process on, run it, and hook up all
398.
▲
by
fdr
15y ago
The license is so counterproductive that I, not being a license warrior, am very nearly convinced that it could destroy virtually any project: http://www.reddit.com/r/programming/comments/ibqp1/meet_the_... It's one thing if one doesn't
399.
▲
by
fdr
15y ago
Unfortunately there is no official approach. The problem of partitioning and inconsistency to get more scalability is still evolving quite a bit. I think things could be better, but it's not crystal clear what the right trade-off is for ma
400.
▲
by
fdr
15y ago
> But when it comes to building spacial indexes on hierarchical dimensions, or whatever, Postgres just isn’t going to have a feature for that. I’ll have to figure that one out for myself. In this case, yes it is, Postgres probably has t
401.
▲
by
fdr
15y ago
This old saw... I think most open source folks are writing the stuff while on payroll, at least by volume. Increased sharing is preventing as much work from getting re-done, which is fine because people want more programs than can be suppl
402.
▲
by
fdr
15y ago
You are right, especially if you aren't pushing much data. Your restore times be rather long though. I hope to implement a prefetching strategy to make this much, much faster, so one could do that if they absolutely wished.
403.
▲
by
fdr
15y ago
WAL archive replay is also used for the PostgreSQL hot standby feature, aka replication. Combined with streaming you can get sub-second latency, but there's no reason you could just not use streaming and use WAL-E to syndicate WAL to thous
404.
▲
by
fdr
15y ago
Yes. a double post.
405.
▲
by
fdr
15y ago
A couple of seconds is very aggressive. There is a window for data loss when the segment is incomplete. The calculus of what this means in a real system is somewhat complicated, and sketched below. Although people like to measure the data
406.
▲
by
fdr
16y ago
I used to write a reasonable amount of Lisp at my first job, in an industrial research lab, in addition to a fond exposure to it at my institution of higher learning. I really, really like Lisp. The syntax, as a result of it having been int