What are the advantages of PostgreSQl over mySQL
I currently use mySQL everywhere and it works well - at least for what I
need it for!!
Andy
On Thu, 2003-08-21 at 16:12, Toby Corkindale wrote:
> On Sun, Aug 17, 2003 at 06:03:13PM +0100, Paul Makepeace wrote:
> > On Sun, Aug 17, 2003 at 09:51:13A
Hi,
Anyone have experience of installing Perl on Irix 5.3? I'm sure there are
lots of good reasons for not even beginning to attempt this but putting that
to one side...
The latest I have on the machine, an Indigo, is 5.004 from
http://reality.sgiweb.org/scotth/info/perl5.html
I have MySQL 3.20
On Thu, 21 Aug 2003, Luis Campos de Carvalho wrote:
>I wonder about what you use to store large amounts of data.
>Could you please teach me about your
> data-{storage,classification,retrieval,maintenance} tools?
James and Pierre have given talks on the Pixie and Vx tools which Fotango
use
Toby Corkindale <[EMAIL PROTECTED]> wrote:
> On Sun, Aug 17, 2003 at 06:03:13PM +0100, Paul Makepeace wrote:
>> On Sun, Aug 17, 2003 at 09:51:13AM -0700, Randal L. Schwartz wrote:
>> > (And people who use MySQL wonder what the value of subselects are! :)
>>
>> Subselects are in MySQL 4.1 (currentl
On Fri, Aug 22, 2003 at 09:54:22AM +0100, Andy Ford wrote:
> What are the advantages of PostgreSQl over mySQL
The first few advantages that come to mind:
It scales. :D
It supports (several varieties of) transactions.
It can write internally consistent backup dumps.
It supports write-ahead-logging
I like the idea of this:
http://www.prevayler.org/wiki.jsp?topic=PrevalenceSkepticalFAQ
These guys are a little evangelical but I find the idea intriguing.
I'm still not too sure how easy it would be to remember to have the
data migrate itself when you change your classes. I think you'd need
som
> On Fri, Aug 22, 2003 at 09:54:22AM +0100, Andy Ford wrote:
> > What are the advantages of PostgreSQl over mySQL
>
> The first few advantages that come to mind:
>
> It scales. :D
> It supports (several varieties of) transactions.
> It can write internally consistent backup dumps.
> It supports w
On Fri, 22 Aug 2003, Nigel Hamilton wrote:
> And one day when I can afford a cluster I'm hoping to implement the MySQL
> DB replication Hack (outlined in Linux Server Hacks) to distribute parts
> of the database onto the nodes.
I'm using that and it works beautifully.
It'd also very easy to reco
Steve Keay sent the following bits through the ether:
> Has anything like this been done in perl? There is a ruby
> implementation of this, so it can't be that hard :).
http://search.cpan.org/dist/Class-Prevayler/
It's a nice idea with a little too much hype, but I generally don't
have database
Leon Brocard wrote:
http://search.cpan.org/dist/Class-Prevayler/
It's a nice idea with a little too much hype, but I generally don't
have databases which fit in memory. I mean, otherwise they'd be in
hashes anyway ;-)
It's a curious idea shrouded by great mountain ranges of bombast.
My main worry
On Fri, 22 Aug 2003 11:52, Steve Keay wrote;
SK> http://www.prevayler.org/wiki.jsp?topic=PrevalenceSkepticalFAQ
SK> These guys are a little evangelical but I find the idea
SK> intriguing. I'm still not too sure how easy it would be to
SK> remember to have the data migrate itself when you
On Thu, 21 Aug 2003 16:12, Toby Corkindale wrote;
TC> Ick. Have they got around to supporting transactions yet? :P
No, they're too dumb for that - but a company called InnoDB basically
re-wrote the core parts of MySQL and called it a "storage back-end".
It's free and included in the MySQL distr
> Steve Keay sent the following bits through the ether:
>
> > Has anything like this been done in perl? There is a ruby
> > implementation of this, so it can't be that hard :).
>
> http://search.cpan.org/dist/Class-Prevayler/
>
> It's a nice idea with a little too much hype, but I generally don
Andy Ford wrote:
What are the advantages of PostgreSQl over mySQL
I currently use mySQL everywhere and it works well - at least for what I
need it for!!
Hello Andy, and Perl M[ou]ngers.
IMHO, MySQL is the fastest database engine on the Open-Source and
Commercial markets.
On the other hand
On Fri, 22 Aug 2003 13:13, Nigel Hamilton wrote;
NH> Yes ... just imagine a world where we had terrabytes of RAM -
NH> everything would be stored in vast object pools.
FWIW, the NZ Stock Exchance runs on a replicated RAM database (on
Linux).
--
Sam Vilain, [EMAIL PROTECTED]
Among economists
On Fri, 22 Aug 2003 10:28, Chris Young wrote;
CY> B. Do I take older versions of the packages I need to go with my
CY> old hardware, old OS and old database?
Try DBI 1.14 or a near later version. That was the earliest known
stable version AFAIK.
--
Sam Vilain, [EMAIL PROTECTED]
An OO surge
On Fri, Aug 22, 2003 at 01:40:21PM +0100, Sam Vilain wrote:
> FWIW, the NZ Stock Exchance runs on a replicated RAM database (on
> Linux).
Is that the NZ stock exchange that crashed recently because of a
software bug (see latest RISKS)?
--
David Cantrell | Benevolent Dictator | http://www.cantre
From: Andy Ford <[EMAIL PROTECTED]>
Date: 8/22/03 8:54:22 AM
> What are the advantages of PostgreSQl over mySQL
>
> I currently use mySQL everywhere and it works well - at
> least for what I need it for!!
MySQL is just a file-based storage system with a pseudo-SQL interface.
It doesn't support
On Fri, Aug 22, 2003 at 06:20:39AM -0700, Dave Cross wrote:
> MySQL is just a file-based storage system with a pseudo-SQL interface.
> It doesn't support many of the things that you'd expect in a
> real SQL implementation, for example:
>
> * Transactions
> * Referential integrity
Innodb tables gi
> "Luis" == Luis Campos de Carvalho <[EMAIL PROTECTED]> writes:
Luis>IMHO, MySQL is the fastest database engine on the Open-Source and
Luis> Commercial markets.
Only for a loose definition of "database". Certainly not one with
transactions. When you move all your tables to InnoDB, the r
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Dave Cross
> Sent: 22 August 2003 14:21
> To: [EMAIL PROTECTED]
> Subject: Re: [OT] SQL woes
>
>
> MySQL is just a file-based storage system with a pseudo-SQL
> interface. It doesn't support many o
> "Randal" == Randal L Schwartz <[EMAIL PROTECTED]> writes:
Randal> MySQL is a fine junior SQL engine. But it really doesn't provide a
Randal> way to enforce business rules in the engine - that was not its initial
Randal> goal. And when data integrity is important, you want to ensure good
Ra
On Fri, Aug 22, 2003 at 06:45:21AM -0700, Randal L. Schwartz wrote:
>In conclusion, if you want a speedy ACID-compliant
>enforced-business-rules database with full SQL support (not a subset),
>PostgreSQL wins, and MySQL is still two or three years away.
>
>On the other hand, if you wanna be able t
> "Richard" == Richard Clamp <[EMAIL PROTECTED]> writes:
Richard> On Fri, Aug 22, 2003 at 06:20:39AM -0700, Dave Cross wrote:
>> MySQL is just a file-based storage system with a pseudo-SQL interface.
>> It doesn't support many of the things that you'd expect in a
>> real SQL implementation, fo
On Fri, Aug 22, 2003 at 02:59:14PM +0100, Roger Burton West said:
> On the third hand, if you want _real_ speed, _and_ transactions, but
> none of the other neat stuff; and if your system doesn't have much in
> the way of concurrent writes; SQLite is a whole lot easier to set up and
> admin than My
On Fri, Aug 22, 2003 at 03:07:19PM +0100, Simon Wistow wrote:
[SQLite]
>But suffers, IIRC, from concurrency problems.
On writing, yes. Hence "doesn't have much in the way of concurrent
writes".
R
Randal L. Schwartz <[EMAIL PROTECTED]> wrote:
> MySQL is *just* now getting transactions. PostgreSQL has had some
> very good experts working on transactions for years now, and they're
> much further along on the trial-and-error curve that MySQL is just now
> starting.
I'd just like to point out
On Friday, August 22, 2003, at 11:28 am, Dominic Mitchell wrote:
Toby Corkindale <[EMAIL PROTECTED]> wrote:
On Sun, Aug 17, 2003 at 06:03:13PM +0100, Paul Makepeace wrote:
On Sun, Aug 17, 2003 at 09:51:13AM -0700, Randal L. Schwartz wrote:
(And people who use MySQL wonder what the value of subsel
Well thanks for summing that up - it was an interesting read!!
Currently I use mySQL only and don't really need transactional stuff.
Now triggers I can see a need for!!
I may take a look at Pg
Thanks
Andy
On Fri, 2003-08-22 at 15:08, Randal L. Schwartz wrote:
> > "Richard" == Richard Clamp
On Fri, 22 Aug 2003 15:08, Randal L. Schwartz wrote;
RL> At a speed cost that makes it slower than Pg, and an earlier
RL> spot on the design curve which Pg has already matured on.
I think I'd rather spend the money I save on Pg DBA's on more disks.
--
Sam Vilain, [EMAIL PROTECTED]
Seeing a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* Tim Sweetman [2003-08-22 09:46]:
> My main worry is this:
> > Do you mean I can simply have my objects in RAM and forget all that
> > database hassle? That's right.
This is, of course, almost exactly what the ZODB is, except the data is
pickled^Ws
Sam Vilain <[EMAIL PROTECTED]> wrote:
> On Fri, 22 Aug 2003 15:08, Randal L. Schwartz wrote;
>
> RL> At a speed cost that makes it slower than Pg, and an earlier
> RL> spot on the design curve which Pg has already matured on.
>
> I think I'd rather spend the money I save on Pg DBA's on more d
On Fri, Aug 22, 2003 at 11:15:37AM -0400, darren chamberlain said:
> This is, of course, almost exactly what the ZODB is, except the data is
> pickled^Wserialized, and it's written for python.
Given that some kind soul has written
Python::Serialise::(Marshall|Pickle) perhaps someone could port ZO
On Fri, 22 Aug 2003, Simon Wistow wrote:
> On Fri, Aug 22, 2003 at 11:15:37AM -0400, darren chamberlain said:
> > This is, of course, almost exactly what the ZODB is, except the data is
> > pickled^Wserialized, and it's written for python.
>
> Given that some kind soul has written
> Python::Serial
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* Chris Devers [2003-08-22 11:38]:
> (Can ZODB [Zope Object DataBase] even work outside of Zope?)
Absolultely. For example, take a look at Chandler, at
www.osafoundation.org, an open source PIM that uses the ZODB as a
backend.
(darren)
- --
Help!
On Fri, 22 Aug 2003, Simon Wistow wrote:
> So, to sum up this thread :
>
> 1. PostGres has some advantages
> 2. MySql has some advantages
> 3. Oracle has some advantages
> 4. SQLite has some advantages
> 5. All of the above have disadvantages.
> 6. There will be a film. At 11.
Which will be dela
On Fri, Aug 22, 2003 at 05:13:31PM +0100, Jason Clifford wrote:
> On Fri, 22 Aug 2003, Simon Wistow wrote:
>
> > So, to sum up this thread :
> >
> > 1. PostGres has some advantages
> > 2. MySql has some advantages
> > 3. Oracle has some advantages
> > 4. SQLite has some advantages
> > 5. All of t
On Fri, Aug 22, 2003 at 02:59:14PM +0100, Roger Burton West wrote:
> On Fri, Aug 22, 2003 at 06:45:21AM -0700, Randal L. Schwartz wrote:
>
> >In conclusion, if you want a speedy ACID-compliant
> >enforced-business-rules database with full SQL support (not a subset),
> >PostgreSQL wins, and MySQL i
On Fri, Aug 22, 2003 at 06:45:21AM -0700, Randal L. Schwartz wrote:
> MySQL is *just* now getting transactions. PostgreSQL has had some
> very good experts working on transactions for years now, and they're
> much further along on the trial-and-error curve that MySQL is just now
> starting.
For v
On Fri, Aug 22, 2003 at 03:30:48PM +0100, Andy Ford wrote:
> Well thanks for summing that up - it was an interesting read!!
> Currently I use mySQL only and don't really need transactional stuff.
> Now triggers I can see a need for!!
Triggers at the db level will bite you hard at some point.
If
Hi,
As a Perl beginner who has realised I need to set up a database, I have to
add that I immediately went for MySQL due to all the attention it seems to
have, and bought a few books to get me started. The whole thing - using
installing etc etc looks hellish complicated AND I haven't even been ab
Dominic Mitchell <[EMAIL PROTECTED]> writes:
> Randal L. Schwartz <[EMAIL PROTECTED]> wrote:
>> MySQL is *just* now getting transactions. PostgreSQL has had some
>> very good experts working on transactions for years now, and they're
>> much further along on the trial-and-error curve that MySQL i
On Thu, Aug 21, 2003 at 08:51:49PM +0100, Colin Magee wrote:
>So this SQLite seems like a great idea IF it makes setting up and
>administering a dbase simple. Unfortunately I just looked up where I can
>download it, but didn't see any example code showing it working with Perl,
>or any documentati
What about Firebird?
http://firebird.sourceforge.net/
does anyone here have personal experience? On paper (well, online) it
compares favorably to PostgreSQL, and it can be easily embedded.
richard
__
Bibliocraft Ltd / www.bibliocraft.com
44 matches
Mail list logo