LWN.net Logo

Grumpy?

Grumpy?

Posted Jul 9, 2004 21:14 UTC (Fri) by brouhaha (subscriber, #1698)
Parent article: A look at PostgreSQL

While I'm reluctant to suggest heaping more work on our esteemed editor, I would really welcome a "Grumpy Editor's Guide to Databases". I've used MySQL, but don't really know much about PostgreSQL, MaxDB (formerly SAP DB), or Firebird.

Or perhaps a good comparison article already exists somewhere?


(Log in to post comments)

Grumpy?

Posted Jul 9, 2004 21:25 UTC (Fri) by corbet (editor, #1) [Link]

Databases are definitely on the list. The GE articles are a lot of work to write, though, and this one would be worse than many. So I have no idea when it might be possible to get it done; not anytime soon, certainly.

Grumpy?

Posted Jul 10, 2004 16:59 UTC (Sat) by yodermk (subscriber, #3803) [Link]

What I would also like to see is a "grumpy editor's" comparison of database front ends. Ease of designing forms and reports and scripting events should be considered. That one would likely be a bear to write though.

My organization was looking at replacing Access with an open source tool, but the consensus was that there isn't a suitable alternative at this time. :( Would love to be proven wrong on that!

It would need to work on 'Doze for now, which would seem to eliminate Knoda and Kexi and Rekall, and OOo is just a tad bit klutzy...

Grumpy?

Posted Jul 11, 2004 18:50 UTC (Sun) by james (subscriber, #1325) [Link]

Would it help to post a paying-subscribers-only "article" mentioning that you are planning a Grumpy Editor's guide to (say) databases, and asking for subscribers' comments?

That could help you find all the possible projects (Grumpy Editor articles are particularly valuable when they review low-profile projects that could do with more publicity), and give you a series of features that LWN users like (or have noticed are often absent).

James

Grumpy Guide to Databases

Posted Jul 16, 2004 20:20 UTC (Fri) by ringerc (guest, #3071) [Link]

I find it difficult to imagine a topic more fraught with pitfalls, due to
the impressive complexity of the subject matter and the wide range of
users needs. It's also the only topic I can think of that's likely to
result in MORE fuss than a KDE/GNOME article.

Such an article would need to extremely clearly set out the evaluation
criteria, user experience, and user needs before beginning. Comparing
feature lists is IMHO almost useless without knowing what those features
will do for you. Even constructing feature tables is almost impossible to
do in a way that is both comprehensive and vaguely comprehensible (ie not
a 5000 entry table) because what to one person is irrelevent is to another
person the straw that breaks the camel's back.

Also, lots of the things people say about databases are quite subjective.
For example, one frequently hears MySQL being described as incredibly
fast... but that depends to a huge extent on your workload. It's very fast
for many SELECTS on tables that don't see much write activity, but pays
for that in write performance, especially for concurrent clients. At
least, that's my impression. Therein lying the root of the problem - good,
meaningful benchmarks (especially up-to-date ones) are hard to come by.

Meh. It'd still be a really interesting article, it suspect it'd just be a
huge job to do well.

Grumpy?

Posted Jul 10, 2004 0:11 UTC (Sat) by dlang (subscriber, #313) [Link]

there really aren't any good comparisons. all of the comparisons that are out there are old enough that both MySQL and Postgres have changed drasticly since the reviews (MySQL has gotten many new features that were missing at the time, but Postgres has moved on in features and drasticly improved it's speed)

also it's hard to think of a topic that people are going to be more passionate about (well, I guess you could do a GNOME vs KDE article ;-)

a happy postgres user since postgres 7.0
David Lang

Copyright © 2008, Eklektix, Inc.
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds
Powered by Rackspace Managed Hosting.