| |
| |
| |
|
Page: 1 2 3
Comments:
<0> I suggest change to: PostgreSQL
<1> why?
<0> because its commercial version is inferior to the GPL version due to 3rd party GPL code, its client libraries are GPL not LGPL, they scare users into thinking they need a commercial license because they consider connecting over the network to be "linking"
<0> Oracle owns innodb which provides significant functionality to mysql, and oracle has a history of killing companies after aquiring them
<0> and it's lacked basic functionality for years and years, now it's finally catching up but it's still in its infancy amongst real databases
<1> all i need is speed today
<0> it's all about instant gratification isn't it?
<1> for this app, yep
<2> heh
<1> it's a throw away
<1> just needs to run for about a month, index few billion pages and get canned
<0> I can't help you support communism
<0> sorry
<3> I was in Flint, MI driving around at 3 AM and a prostitute came up to my car and asked if i wanted a blowjob for $5. i said i only had $4. She accepted the offer
<1> heh
<1> "Postgres storage system" sounds like communism to me...
<1> and no full text support out of the box..
<0> umm
<1> that's like no toilet paper
<0> there is too a TEXT data type
<1> fulltext indexing
<0> you bum, read
<1> not out of the box
<0> yes out of box
<0> why would you want indexing on a text data type?
<1> "MySQL supports full text indexes out of the box, and PostgreSQL can support full text indexes with some changes to the database that are included with the source."
<1> ever heard of Full-Text Search?
<0> I've never heard that terminology but I'm sure I'd know what concept you're talking about once you described what you're talking about
<1> no data partitioning with postgre, OK....
<1> @google Full-Text Search Functions
<3> Search results for Full-Text Search Functions:
<3> http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html
<3> http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/functi11.htm
<3> http://livedocs.macromedia.com/cfmxdocs/CFML_Reference/functions-pt014.htm
<3> http://www.searchtools.com/info/database-search.html
<3> http://publib.boulder.ibm.com/infocenter/wsiihelp/v8r3/topic/com.ibm.websphere.ii.federation.ce.doc/administering/iiyvwug09.htm
<3> http://www.google.com/search?hl=en&ie=ISO-8859-1&q=Full-Text+Search+Functions&btnG=Google+Search
<1> stay in school
<0> inf00, I don't see how this is different then using the TEXT datatype and using LIKE or ILIKE
<1> there is a difference
<0> WHAT IS THE DIFFERENCE?
<1> speed
<1> for one
<1> with index it's much faster
<0> what benchmarks are you looking at?
<0> you can index TEXT fields
<0> in postgresql
<0> see CREATE TABLE syntax or ALTER TABLE
<0> inf00, before you say something lacks something just because it's not named the same thing as in mysql, check the SQL standard
<1> which one?
<1> :)
<1> how would you do match against type of thing with postgre? and get a match score?
<0> don't manufacture claims without backing, "x is faster! no, not looking at benchmarks, never used x, but I know!"
<0> inf00, hmm, I'd say SQL2003
<1> well we are comparing apples to oranges i think
<4> hello lads
<5> gday tb.
<4> danke
<5> hrm, got a question.
<5> how would i do a timer in php?
<4> was is?
<4> what are you timing?
<5> like.. increase a variable every N seconds
<5> and refresh the page
<5> would be easier to do it with javascript eh?
<4> ah
<4> that's client side
<4> you can't do anything after data leaves the server
<4> so you could use a meta refresh
<4> or a jscript
<5> mm. okie.
<5> if a text kept changing without the pag refreshing, its js right?
<5> page*
<4> yup
<5> note to self, need to learn js
<5> :p
<4> HaNtU]uU[, JS is easy
<4> I can help you
<4> also bear in mind, that AJAX is the ***iest ****ing thing in the world
<5> i'll look into it some time.. school's been ****ing busy
<5> tb, yeah i wanted to go into ajax, thus learn js :P
<0> I didn't see the score, point taken, although it could be ordered through aggregate functions for a similiar effect
<0> right, mysql is a toy, and postgresql is the future
<0> I agree on that one
<5> :o
<0> inf00, How about you put your money where your mouth is and fight trollboy, I'll give you $1000 if you win
<5> you're cute, poutine, you know that?
<4> and its `
<4> poutine, um
<4> wtf are you on about?
<0> trollboy, do you hate it even more now?
<4> actually yes
<4> still ****ing freezing
<4> once this storm blows over, I should be cool though
<6> what's a broken pipe?
<7> it's a pike that is no longer unbroken
<7> pipe
<7> ****.
<6> that kind of answer makes me want to kill kittens
<3> My roomates are all big sluts and I wish I could tell them. They have *** with random guys. They've all had at least 7 diff. partners in the last month. They are skanks!
<8> that's what i call a party
<8> lol
<9> bbl: son of man.
<5> note to self, go to mod_spox's roomates.
<5> hey Tb
<8> yeah?
<5> JUST HI
<5> :P
<10> hey there hantu
<5> sup rob.
<5> grr opera needs to let me tab into an address in the address bar
<5> :(
<11> here's a tip: stop using opera.
<11> ;)
<8> anyone ever see someone put on makeup using their camera phone as a mirror?
<8> if so, kill them as quickly as possible
<5> Technobabble: i killed a few.
<8> good to hear it
<0> I just got a pitbull high by force
<0> some day I hope to be responsible when it rips off a child's face
<4> Technobabble, is that what you use your phone for?
<3> online fling with delicious lawyer. want to make it offline fling. married. not sure if i still want to be. the whole thing is insanely intense.
<12> little mysql help? ...
<12> i need to pull all DISTINCT names along with their idParent column
<12> was wondering how to throw that into 1 sql
<12> SELECT DISTINCT name, idParent FROM table_name WHERE blah = 5
<12> isn't working out
<12> as i thought it would
<3> i gave my friend fart-powder in her tea. she then felt ill but i didnt say anything.
<8> lol
<3> I HATE WOMEN! EVERY WOMAN ON EARTH! The thing is i'm not gay and I could never be cause I think it's gross, But girls also gross me out cause their ****ing stupid. YOUR NOT FAT,YOUR NOT UGLY,YOUR JUST ANNOYING!.......cunt.
<8> that little confess is rad
<12> does it randomly spit **** out or is it controlled?
<12> like, will it confes on its own or does it need someone to tell it to?
<6> only BOTS change servers!
<6> you .jump-er!
<3> i wank all the time .in work a girl sits opposite me she is so ****ing hot i am going for another wank now :) good bye
<6> mod_spox: check your ntp; it's 1:15 in teh morning!
<3> I often *********e to the thought of ****ing my best friend.
<13> $var=($array['unknownIndex'])?($array['unknownIndex']):$array['default']; // will E_NOTICE Triggered here ?
<13> @php $array['default']=1;$var=($array['unknownIndex'])?($array['unknownIndex']):$array['default']; // will E_NOTICE Triggered here ?
<13> mud....
<13> eh... spox!
<6> haha
<3> My girlfriend just broke up with me and I feel like ****. She broke my heart. I want to get mad at her, but I can't. I want her back. That makes me feel even worse. I should go have another beer.
<14> [05:51] --- [Snake] (JamesDean@vw-12785.bigpond.net.au) : James Dean
<14> er
<14> bah
<14> blah, http://rafb.net/paste/results/hR5Sxw51.html - for some reason, my if-block inside fetch_depend() isn't being triggered (the "Hey, no rows returned!" if-block).
<14> there
<15> hi everybody
Return to
#php
or
Go to some related
logs:
#linux
#india
hiiiiiii josh
#photoshop
#allnitecafe
#kl
#allnitecafe
#worldchat
funny coutes
#chat-world
|
|