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-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

[GENERAL] Database Selection

2006-04-24 Thread IvoD
n database? Best Regards IvoD ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org