Re: [GENERAL] Humor me: Postgresql vs. MySql (esp. licensing)

>>>- Define a 32-bit field in MySQL. Insert a 64-bit number instead. >>>Common sense tells you the value would be rejected. Yet MySQL happily >>>folds it in and carries on its merry way. >> >> That's unacceptable. To me, this is a complete show-stopper because I >> simply won't tolerate data los

Re: [GENERAL] Export CSV from psql

[sNip] > I have been playing with this lately, and I have found that if you use > > \f , > \o /tmp/output.csv > > it opens fine in excel, it just bypasses the need to go > next, next, finish when opening from a TAB separated .txt file Have you tested other Spreadsheet applications? If

Re: [GENERAL] Where is Postgesql ? - MYSQL SURPRISES WITH MAXDB /

[sNip] > * My favorite - TABLESPACES!! [sNip] This is one feature I dearly wished PostgreSQL had because it would allow for some additional performance tuning options. One thing I really liked about Oracle's Table Spaces was that I could specify a full path to it and the entire

Re: [GENERAL] SCSI vs. IDE performance test

>>> "we have no portable means of expressing that exact constraint to the >>> kernel" >> Does this mean that specific operating systems have a better way of >> dealing with this? Which ones and how? > > I'm not aware of any that offer a way of expressing "write these > particular blocks before th

Re: [GENERAL] Humor me: Postgresql vs. MySql (esp. licensing)

[sNip] > For exsample, if I have a product that I built for a customer, I would > have to give it to them under the GPL. But I also have the choice to not > give it to them AT ALL. So, they pay me to get it, and the license is > the GPL. Their other choice, if they didn't pay me, would be to not

Re: [GENERAL] Humor me: Postgresql vs. MySql (esp. licensing)

>>Here's an interesting response from mysql.com sales. Frankly, I don't see >>how using it on multiple internal servers violates the GPL?!?: > > You're talking to a sales droid, a suit, someone whose brain > cells have died off because his tie was tied to tight. [sNip] That's an official

Re: [GENERAL] Humor me: Postgresql vs. MySql (esp. licensing)

[sNip] > "We have all the features they do! Nobody uses views or triggers!" Which cave has that person been hiding in all these years? Views are a very important part of SQL, and any SQL server that doesn't support Views is, in my view (sorry, I couldn't resist), simply isn't suitable

Re: [GENERAL] Humor me: Postgresql vs. MySql (esp. licensing)

Thanks for this information, it's very helpful. I've included some additional comments to further demonstrate how a qualified business planner may look at this... >> I'm preparing to enter a discussion with management at my company >> regarding going forward as either a MySql shop or a

Re: [GENERAL] Humor me: Postgresql vs. MySql (esp. licensing)

[sNip] >> Do a shutdown -h on a live database machine with pg. It will gracefully >> shut itself down. > > Is that true for all OS flavors and is it dependent upon the DBA having > set up proper shutdown scripts? [sNip] When I tested this on PostgreSQL on Novell NetWare 6 it shut down gr

Re: [GENERAL] Good open source mailing list system PHP / Postgresql

> An ISP I belong to uses Majordomo for their mailing list system. I'd like > to encourage them to move to a system that uses a database, preferably > psql which they already run on their server. Anything out there in Php? I doubt there's anything in PHP since PHP is a language purely us

Re: [GENERAL] Picture with Postgres and Delphi

>> There is no need for manually storing files on filesystem, because >> large objects are doing that for You. I am storing whole binary files >> in blobs(synonym for large objects from some other platforms), and I do >> not remember that I had a single problem with that. Do not forget that >> libp

Re: [GENERAL] CASE tools

> FYI I have found 2 CASE tools that support PostgreSQL > > CASE Studio 2 > > > DDS-Lite > > > However, they are both for Windows. > > Can you point me to others? Hopefully multi-platform ones. I like this one a l

Re: [GENERAL] Oracle and regular expressions ???

> New features in version 10g (commin soon) : > > SQL Regular Expressions > ... Hmm, I wonder if they've been influenced by PostgreSQL? ;-D -- Randolf Richardson - [EMAIL PROTECTED] Inter-Corporate Computer & Network Services, Inc. Vancouver, British Columbia, Canada http://www.8x.ca/