Re: [GENERAL] Database Selection

2006-04-27 Thread IvoD
> [EMAIL PROTECTED] (Scott Marlowe) writes: > > About the security thing. Security is a process, and you won't get > > it from using two different database engines. > > I'd argue that security is an "emergent property" which is either > supported by or undermined by particular facts/features/confi

Re: [GENERAL] Database Selection

2006-04-27 Thread IvoD
Yes, I read this opinion that MySQL is only sql interface to filesystem :-) I plan to use win1250 encoding because this is native czech windows encoding (I do not understand why M$ invents the wheel and invents new code pages (cp1250) although the code page latin2 was here all the time). BTW czech

Re: [GENERAL] Database Selection

2006-04-27 Thread IvoD
All opinions here sound good so I decided to use only one db engine (PostgreSQL 8.1) and two databases; now I must tune my database generator parameters (I use PowerDesigner by Sybase) in order to work-arround the pg's identifier case sensitivity (newsgroups app (php scripts) doesn't use quotes (de

Re: [GENERAL] Database Selection

2006-04-26 Thread Christopher Browne
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Robert Treat) belched out: > On Tuesday 25 April 2006 01:46, IvoD wrote: >> My "sixth sense" tells me that PostgreSQL is better than MySQL, >> therefore for main app I prefer PostgreSQL; but I am in doubt to >> run only one db engine for

Re: [GENERAL] Database Selection

2006-04-26 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when "IvoD" <[EMAIL PROTECTED]> would write: >> [EMAIL PROTECTED] (Scott Marlowe) writes: >> > About the security thing. Security is a process, and you won't get >> > it from using two different database engines. >> >> I'd argue that security is an "emergent prop

Re: [GENERAL] Database Selection

2006-04-26 Thread Robert Treat
On Tuesday 25 April 2006 01:46, IvoD wrote: > My "sixth sense" tells me that PostgreSQL is better than MySQL, > therefore for main app I prefer PostgreSQL; but I am in doubt to run > only one db engine for two databases. But my "inner space" tells me to > separate newsgroups system and company data

Re: [GENERAL] Database Selection

2006-04-26 Thread Jim C. Nasby
On Mon, Apr 24, 2006 at 10:46:50PM -0700, IvoD wrote: > My "sixth sense" tells me that PostgreSQL is better than MySQL, > therefore for main app I prefer PostgreSQL; but I am in doubt to run > only one db engine for two databases. But my "inner space" tells me to > separate newsgroups system and co

Re: [GENERAL] Database Selection

2006-04-25 Thread Chris Browne
[EMAIL PROTECTED] (Scott Marlowe) writes: > About the security thing. Security is a process, and you won't get > it from using two different database engines. I'd argue that security is an "emergent property" which is either supported by or undermined by particular facts/features/configurations.

Re: [GENERAL] Database Selection

2006-04-25 Thread Alban Hertroys
IvoD wrote: real experience and real enterprise applications. And last but not least - I must run db engine on Win platform (not Linux) and all the "success stories" assume Linux platform. So does somebody here know Well, for one thing... I have some experience with MySQL in that respect, and

Re: [GENERAL] Database Selection

2006-04-25 Thread Scott Marlowe
On Tue, 2006-04-25 at 01:26, IvoD wrote: > I read many web pages about both PostgreSQL and MySQL, I read also > "case studies" at pg web, but I prefer opinions of real users :-) I > installed both db engines on my PC three weeks ago and now I test it. > But I'm sure there should be "features" that

Re: [GENERAL] Database Selection

2006-04-25 Thread IvoD
My "sixth sense" tells me that PostgreSQL is better than MySQL, therefore for main app I prefer PostgreSQL; but I am in doubt to run only one db engine for two databases. But my "inner space" tells me to separate newsgroups system and company data system and run two different db engines - in light

Re: [GENERAL] Database Selection

2006-04-25 Thread IvoD
I read many web pages about both PostgreSQL and MySQL, I read also "case studies" at pg web, but I prefer opinions of real users :-) I installed both db engines on my PC three weeks ago and now I test it. But I'm sure there should be "features" that I am not able to catch (e.g. MIN() function speed

Re: [GENERAL] Database Selection

2006-04-24 Thread Tom Lane
Shane Ambler <[EMAIL PROTECTED]> writes: > On 25/4/2006 6:47, "Tom Lane" <[EMAIL PROTECTED]> wrote: >> Actually that's a misstatement --- AFAIK, Stonebraker and crew started >> from scratch when they wrote Postgres, > Bruce Momjiam say's "PostgreSQL's ancestor was Ingres" but I haven't found > any

Re: [GENERAL] Database Selection

2006-04-24 Thread Jim C. Nasby
On Mon, Apr 24, 2006 at 07:15:12PM -0400, Bruce Momjian wrote: > Jim C. Nasby wrote: > > Some food for thought: http://sql-info.de/mysql/gotchas.html > > > > Something else to consider is that there's a number of options open to > > you for getting commercial PostgreSQL support should you want it.

Re: [GENERAL] Database Selection

2006-04-24 Thread Bruce Momjian
Jim C. Nasby wrote: > Some food for thought: http://sql-info.de/mysql/gotchas.html > > Something else to consider is that there's a number of options open to > you for getting commercial PostgreSQL support should you want it. AFAIK > you're pretty much limited to Sybase or MySQL when it comes to s

Re: [GENERAL] Database Selection

2006-04-24 Thread Jim C. Nasby
Some food for thought: http://sql-info.de/mysql/gotchas.html Something else to consider is that there's a number of options open to you for getting commercial PostgreSQL support should you want it. AFAIK you're pretty much limited to Sybase or MySQL when it comes to support for their products. Plu

Re: [GENERAL] Database Selection

2006-04-24 Thread Joshua D. Drake
Bruce Momjiam say's "PostgreSQL's ancestor was Ingres" but I haven't found anything concrete one way or the other on whether Postgres started from scratch or from Ingres code (the name comes from 'post' 'gres' - after Ingres) My understanding is that we started from Ingres in the sense that we

Re: [GENERAL] Database Selection

2006-04-24 Thread Shane Ambler
On 25/4/2006 6:47, "Tom Lane" <[EMAIL PROTECTED]> wrote: > Shane Ambler <[EMAIL PROTECTED]> writes: >> If you look at the history of PostgreSQL you will find that the development >> at Berkley started with Ingres and after the code was used to start >> Relational Technologies/Ingres Corporation th

Re: [GENERAL] Database Selection

2006-04-24 Thread Tom Lane
Shane Ambler <[EMAIL PROTECTED]> writes: > If you look at the history of PostgreSQL you will find that the development > at Berkley started with Ingres and after the code was used to start > Relational Technologies/Ingres Corporation the Postgres project was born. > A later version of Postgres was

Re: [GENERAL] Database Selection

2006-04-24 Thread Shane Ambler
On 24/4/2006 16:59, "IvoD" <[EMAIL PROTECTED]> wrote: > For the first app I wanted to use MySQL, for the second one I wanted > the Sybase SQL Anywhere. But now I am in doubt. I'm playing with the > idea to substitute the Sybase SQL Anywhere by the PostgreSQL or MySQL. > I need all the SQL decoratio

Re: [GENERAL] Database Selection

2006-04-24 Thread Michael Schmidt
If you look through this mailing list, the PostgreSQL website, and Google reviews of PostgreSQL, I think you will gain a very positive appreciation of PostgreSQL.  It is stable, robust, and well-supported.  It is being used in many mission-critical applications.  Most recently, I've seen me

[GENERAL] Database Selection

2006-04-24 Thread IvoD
Hello all, I created two web database applications - first one is the company news system (as part of the company web pages), second one is the company main data system (part of the company pages, too). All (unfortunately) the M$ environment - 2003 server. The first app is managed from the web in