Welcome to the Slashdot Beta site -- learn more here. Use the link in the footer or click here to return to the Classic version of Slashdot.

Thank you!

Before you choose to head back to the Classic look of the site, we'd appreciate it if you share your thoughts on the Beta; your feedback is what drives our ongoing development.

Beta is different and we value you taking the time to try it out. Please take a look at the changes we've made in Beta and  learn more about it. Thanks for reading, and for making the site better!



PostgreSQL 9.0 Released

TheFuzzy Re:So.. (344 comments)

Well, you can always do ad-hoc materialized views ... I'm coding some now.

However, better matview management is currently under development. We had a Google Summer Of Code project to write code to manage the updating of materialized views. In a couple of releases, we might have matviews as good as Oracle's.

Of course, if you're a PostgreSQL user and you want better matview support, then we could really use your help developing it.

--Josh Berkus
      PostgreSQL Project

more than 3 years ago

PostgreSQL 9.0 Released

TheFuzzy Re:As always... (344 comments)


You're absolutely correct that such a comparison would be a real asset to users. However, it would also be a Herculean task. Several people have tried to do similar things, but the number of indexes you need to compare (features, reliability, performance, etc.) is too large. And some things are so different it's hard to compare them meaning fully. Imagine trying to do a head-to-head comparison of all OSes in every way.

Here's a few comparison links, but they just scratch the surface:

about 4 years ago

PostgreSQL 9.0 Released

TheFuzzy I guess we really are the leader now (344 comments)

PostgreSQL *must* be the leading open source SQL database, now. People are bashing us on Slashdot. That's always a sign of success.

Thanks, guys!

--Josh Berkus
    PostgreSQL contributor

about 4 years ago

Half a Million Database Servers 'Have no Firewall'

TheFuzzy Re:So what? (322 comments)


Sorry, no.

Speaking as a database contributor (PostgreSQL), databases should absolutely secured at the network level. If not by firewall, by making them only available on localhost, or only by VPN or SSL connection.

DBMSes are designed to be feature-ful, fast, and secure ... **in that order**. Which means that no DBMS is designed to stand up to a protracted, determined, knowledgable attack on an open port (athough some of us do better than others). At the very least, an attacker could DOS you by simply attempting a connection thousands of times a second, forcing the database to fork processes or threads.

Further, the most popular DBMSes (SQL Server, Oracle and MySQL) pretty much always have outstanding security exploits on their bug lists, and far more which were patched in the most recent update most people haven't applied. Even we fix 1-2 exploits per update these days, some of which are quite dangerous with an attacker who really knows their stuff.

Developers are *terrible* about setting good DB passwords. I absolutely can't tell you the number of times I've seen "temp/temp" as an authentication string in a production database, or "trust" authentication for the right IP (which can be spoofed) because a developer wanted a back door which didn't require typing his password.

For that matter, web developers are supposed to set up different permissions for the web user vs. the database owner, but this is a rare thing to see in practice.

So it's *way* important to firewall your database. Better yet, don't have it listen to the internet at all: set up the database to only listen to localhost or the private network.

--Josh Berkus

more than 6 years ago



PostgreSQL 8.4 Out

TheFuzzy TheFuzzy writes  |  more than 5 years ago

TheFuzzy writes "PostgreSQL version 8.4 is now out and available for download. The main cool features in this version are: recursive queries (for doing trees etc.), windowing functions (for doing reports, more here), column-level permissions, parallel database restore (more here), a beta in-place upgrade tool, and a host of administrative improvements. And, of course, better performance, mainly on reporting queries. Some of the over 200 new or enhanced features are listed here."
Link to Original Source

Finally ... PostgreSQL 8.4

TheFuzzy TheFuzzy writes  |  more than 5 years ago

TheFuzzy writes "Another year, another major release. The PostgreSQL development team has finally released PostgreSQL 8.4 (and there was much rejoicing). This version contains windowing functions for the Biz Intelligence types, and recursive queries for everyone else doing a web application. Postgres has also put a lot of work into changing many of the things which made it "hard to use" in the past. Try it and see if you agree."
Link to Original Source


TheFuzzy has no journal entries.

Slashdot Login

Need an Account?

Forgot your password?

Submission Text Formatting Tips

We support a small subset of HTML, namely these tags:

  • b
  • i
  • p
  • br
  • a
  • ol
  • ul
  • li
  • dl
  • dt
  • dd
  • em
  • strong
  • tt
  • blockquote
  • div
  • quote
  • ecode

"ecode" can be used for code snippets, for example:

<ecode>    while(1) { do_something(); } </ecode>