On Thu, 2005-12-01 at 19:00 -0800, Mark wrote:
> So followup question: are any of these other systems good
> with large'ish databases? I have multi-TB Oracle databases that
> I'd like to explore on a "free" database. Is that realistic?
> My current system relies heavily on partitions, bitmap inde
On 12/1/05 10:00 PM, Mark wrote:
> For example, I have a ~10 billion row, ~1TB table, time partitioned,
> with about 10-20 million rows per day. I need "interactive"
> performance (2-10 seconds) response on queries that are confined
> to 2-3 days data. Obviously, I can't scan a TB table each time
Sam Vilain wrote:
There are some clearly defined areas where this certainly is the right
answer. Oracle still has some killer OLAP features in its Enterprise
product compared to Postgres; off the top of my head:
- bitmap indexes (though the latest version of Bizgres, a Postgres
extension,
On Wed, 2005-11-30 at 10:34 -0600, Jesse, Rich wrote:
> Being from primarily an Oracle background (as far as DBs go), I'd say
> overall "Oracle". Free? Yes! There's now a free Express Edition
> ("XE") currently for Linux and Winders (beta) which can be downloaded
> from http://www.oracle.com/tec
ED]
Sent: Tuesday, November 29, 2005 7:02 PM
To: dbi-users@perl.org
Cc: cgiapp@lists.erlbaum.net
Subject: What's the best "free" DB for a web-based app?
Hi - I'm soon to be doing a Perl app on the Internet, that'll need
database. We want the db to be as "free"
You'd be remiss not to look at Firebird.
Mysql5, Firebird 1.5+ and Postgres are what you should be
comparing and testing in my opinion.
ability and flexibility.
HTH! GL!
Rich
-Original Message-
From: John Armstrong [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 29, 2005 7:02 PM
To: dbi-users@perl.org
Cc: cgiapp@lists.erlbaum.net
Subject: What's the best "free" DB for a web-based app?
Hi - I'm s
rong
<[EMAIL PROTECTED]>
com>cc: dbi-users@perl.org,
cgiapp@lists.erlbaum.net
Subject: Re: What's the best
&q
I'd just like to ask anyone thinking of replying to this thread to *please*
only do so if you can add something useful that's not already been said,
and do so politely, with consideration for the validity of other peoples views.
Tim.
On Tue, Nov 29, 2005 at 05:02:23PM -0800, John Armstrong wrote:
On 2005-11-29 18:13:04 -0800, Darren Duncan wrote:
> At 5:02 PM -0800 11/29/05, John Armstrong wrote:
> >Hi - I'm soon to be doing a Perl app on the Internet, that'll need
> >database.
>
> If you want something that's trivially easy to use, try SQLite.
[...]
> Its also faster than anything else fo
tely change the platform just by changing the DSN.
Josh
--
Josh Danziger
[EMAIL PROTECTED]
-Original Message-
From: John Armstrong [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 29, 2005 8:02 PM
To: dbi-users@perl.org
Cc: cgiapp@lists.erlbaum.net
Subject: [cgiapp] What's the best
postgreSQL!
On Tue, 29 Nov 2005, John Armstrong wrote:
Hi - I'm soon to be doing a Perl app on the Internet, that'll need
database. We want the db to be as "free" as possible, but still fully
multi-user (web-based). Would the best route be MySql on Linux? Random
access files? Something else? W
At 5:02 PM -0800 11/29/05, John Armstrong wrote:
Hi - I'm soon to be doing a Perl app on the Internet, that'll need
database. We want the db to be as "free" as possible, but still fully
multi-user (web-based). Would the best route be MySql on Linux? Random
access files? Something else? We want no
John Armstrong <[EMAIL PROTECTED]> wrote:
> Hi - I'm soon to be doing a Perl app on the Internet, that'll need
> database. We want the db to be as "free" as possible, but still fully
> multi-user (web-based). Would the best route be MySql on Linux? Random
> access files? Something else? We want no
On Tue, 29 Nov 2005 20:09:26 -0500, Josh Danziger wrote:
Hi Josh
> arbitrary SQL statements on the database a breeze. I've heard
> arguments that postgresql is a better database platform; the claim
> is that postgres is more functional and runs faster (I don't know
> how this changed with MySQL
MySQL, since it's easiest to find
help should you need it.
Ted Behling
-Original Message-
From: John Armstrong [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 29, 2005 8:02 PM
To: dbi-users@perl.org
Cc: cgiapp@lists.erlbaum.net
Subject: What's the best "free" DB for
Hi - I'm soon to be doing a Perl app on the Internet, that'll need
database. We want the db to be as "free" as possible, but still fully
multi-user (web-based). Would the best route be MySql on Linux? Random
access files? Something else? We want no licensing obligations (no Oracle,
Sequal Server,
17 matches
Mail list logo
