| 02:45.23 | *** join/#uphpu jbot (i=ibot@pdpc/supporter/active/TimRiker/bot/apt) |
| 02:45.23 | *** topic/#uphpu is new poll on website: march presentation topic | Utah PHP User Group | www.uphpu.org |
| 03:43.34 | *** join/#uphpu jbot (i=ibot@pdpc/supporter/active/TimRiker/bot/apt) |
| 03:43.34 | *** topic/#uphpu is new poll on website: march presentation topic | Utah PHP User Group | www.uphpu.org |
| 05:01.09 | bigdog_ut | im here |
| 05:01.38 | bigdog_ut | mindjuju, you still around? |
| 05:43.05 | bigdog_ut | ~melvin mindjuju |
| 05:43.06 | jbot | ACTION pulls mindjuju underwear up to the ceiling...and smiles |
| 06:48.29 | *** join/#uphpu tierra (n=tierra@ibaku.net) |
| 19:07.51 | mindjuju | ~seen dataw0lf |
| 19:07.59 | jbot | dataw0lf <n=dataw0lf@70.103.239.58> was last seen on IRC in channel #utah, 2d 20h 18m 47s ago, saying: '~punch sjansen '. |
| 22:00.59 | *** join/#uphpu bigdog_ut (n=bigdog@207.135.132.13) |
| 22:00.59 | *** mode/#uphpu [+o bigdog_ut] by ChanServ |
| 22:01.31 | bigdog_ut | mindjuju, you still around? |
| 22:05.47 | mindjuju | i'm here |
| 22:05.54 | mindjuju | big weekend for rolling out code for me |
| 22:05.59 | bigdog_ut | cool |
| 22:06.02 | bigdog_ut | did you need some help |
| 22:06.11 | mindjuju | wanted to ask your opinion on something |
| 22:06.17 | bigdog_ut | k |
| 22:06.35 | mindjuju | with the new mysql out, would you still say that postgreSQL was still better? |
| 22:07.11 | bigdog_ut | yes |
| 22:07.18 | bigdog_ut | very stable and better |
| 22:07.43 | mindjuju | i saw that they had some for windows and they had some for linux, which OS are you using? |
| 22:07.51 | bigdog_ut | linux |
| 22:07.59 | bigdog_ut | the windows one works fine too |
| 22:08.06 | bigdog_ut | i have a friend that is using that one |
| 22:08.58 | bigdog_ut | my thing is that mysql is just now puttin in the basic relational db features |
| 22:09.06 | bigdog_ut | pgsql has had them for years |
| 22:09.16 | bigdog_ut | they have been refined and stabilized |
| 22:09.25 | mindjuju | yeah, was reading about that. |
| 22:09.28 | bigdog_ut | mysql's features will take some time |
| 22:10.07 | mindjuju | so, one thing i was looking for in pgsql was datatypes, specifically, one that could hold xml data |
| 22:10.35 | mindjuju | didn't see anything off hand, but then, mysql didn't have one either |
| 22:10.36 | bigdog_ut | if you just want to put in xml data then there is always the text datatypes |
| 22:10.44 | bigdog_ut | there is not a specific xml datatype |
| 22:10.50 | mindjuju | yup, that's what i was thinking, save as text |
| 22:11.58 | bigdog_ut | u might want to search on pgsql and xml |
| 22:12.09 | bigdog_ut | i htink there is some stuff being done with it |
| 22:12.24 | bigdog_ut | but i just store the xml |
| 22:12.46 | bigdog_ut | if you really want xmldb support there are xml databases that would do the job |
| 22:13.11 | mindjuju | well, the company i work for was about to spend 5k on ms sql2k5, but now that i know what they are using it for, i put that purchase on hold and looking for other solutions that are just as reliable and could offer more in the way of security |
| 22:13.15 | bigdog_ut | http://www.google.com/search?q=postgresql+xml&start=0&start=0&ie=utf-8&oe=utf-8&client=firefox-a&rls=org.mozilla:en-US:official |
| 22:15.57 | bigdog_ut | what are you wanting to do with the xml data? |
| 22:16.06 | mindjuju | use it in a web service |
| 22:16.13 | bigdog_ut | like how? |
| 22:17.33 | mindjuju | i've got to store ms word documents in XML |
| 22:17.54 | bigdog_ut | will you be searching the xml? |
| 22:17.59 | bigdog_ut | or just storing the data? |
| 22:18.17 | mindjuju | i wanted to be able to search off the xml to pull keywords and stuff |
| 22:19.50 | bigdog_ut | http://www.throwingbeans.org/tech/postgresql_and_xml.html |
| 22:20.46 | bigdog_ut | http://keithdevens.com/weblog/archive/2003/Aug/05/XPath-PostgreSQL |
| 22:21.20 | mindjuju | when i was looking at pgsql yesterday, it seemed like it was most at home on a linux box, but with cgywin, it would work on windows. Was thinking of throwing it on a ubuntu box or freebsd box. |
| 22:21.58 | bigdog_ut | that would work great |
| 22:22.06 | bigdog_ut | postgresql works good on *nix? |
| 22:22.12 | bigdog_ut | remove ? |
| 22:23.25 | mindjuju | i'll try ubuntu first, thnx for the info! |
| 22:23.33 | bigdog_ut | np |
| 22:34.45 | bigdog_ut | u should try gentoo first...lol |
| 22:59.08 | mindjuju | well, i was thinking ubuntu because of some stuff dw was saying about the package install, plus with what he knows about security, i thought it was likely to be pretty solid. was thinking freebsd from what i read about it being the most secure of the linuxes, plus mac had good things to say about it. i liked rhel 4 and it comes with a flavor of pgsql, though i've read some sites that don't like rhel flavored anything. |
| 23:00.13 | mindjuju | from distrowatch, it says that gentoo linux has advanced package management. is that what your using for your pgsql server? |
| 23:00.26 | bigdog_ut | if security is your concern then use openbsd |
| 23:00.35 | bigdog_ut | yeah |
| 23:01.15 | mindjuju | well, i'm going to have it behind a pix firewall so i'm not too worried about security, but it is a concern |
| 23:01.38 | bigdog_ut | they are all solid if you are familiar with them |
| 23:01.45 | bigdog_ut | i htink you are cool with anything that you use |