| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12
<Leithal> MHillyer: Who are you talking to?
<MHillyer> I... don't know.
<Leithal> Therion: is the new bot using Lucene?
<inviso> Leithal: nope, been wondering where he went.. Probably slacking.. Playing CS or some such nonsense..
<Therion> Leithal: Yes
<Leithal> he's busy doing other things ;)
<Leithal> Oh no he's not, he WAS just SLACKING
<dammit> Therion: which version of it?;-)
<Leithal> like the "explain scores"
<Therion> dammit: cvs
<dammit> Therion: java?
<dammit> pylucene?
<dammit> lupy?
<dammit> ;-)
<Leithal> java
<dammit> ..
<dammit> ok!!!!!
<dammit> I wonder how cool will be if I'll load balance mysql servers with coyotepoint..
<Therion> dammit: java
<Therion> ie
<MHillyer> It will spell your DOOM! Doom I tell you!
<Therion> map select syntax
<Therion> er
<Therion> man select syntax
<dellis> Therion: (SELECT ... INTO Statement) http://dev.mysql.com/doc/refman/5.0/en/select-into-statement.html
<dellis> Therion: (Speed of SELECT Queries) http://dev.mysql.com/doc/refman/5.0/en/select-speed.html
<dellis> Therion: (SELECT INTO TABLE) http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-select-into-table.html
<dammit> wow
<Therion> Should have picked up the other one
<dammit> nice nick for a bot
<dammit> I like it.
<Therion> ie
<Therion> bah
<Therion> dammit: Heh
<dammit> man a
<dammit> man kill
<dellis> dammit: (KILL Syntax) http://dev.mysql.com/doc/refman/5.0/en/kill.html
<dellis> dammit: (mysql_kill()) http://dev.mysql.com/doc/refman/5.0/en/mysql-kill.html
<Leithal> man partitioning
<dellis> Leithal: (MySQL 5.1 Development Roadmap for MySQL Cluster) http://dev.mysql.com/doc/refman/5.0/en/mysql-5-1-cluster-roadmap.html
<dellis> Leithal: (MySQL Development Roadmap) http://dev.mysql.com/doc/refman/5.0/en/roadmap.html
<dellis> Leithal: (Log Events) http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-log-events.html
<Leithal> BAH
<dammit> nice.
<Therion> See, it's not weighting things the way it should
<Therion> So I have tweaking to do
<Therion> Leithal is my *****
<Therion> seen therion
<dellis> Therion: therion -> Leithal is my *****
<Therion> Leithal: I am going to index the 4.1, 5.0 and 5.1 manuals
<Therion> But I have to figure out how to get it to weight stuff the way I want it, first
<Leithal> Must say though, very cool
<dammit> Therion: index bk as well ;-)
<Therion> Then I'm going to add syntax help and crap to it
<Therion> Lots of stuff
<dammit> hehehe
<dammit> man concat
<dellis> dammit: (Running MySQL in ANSI Mode) http://dev.mysql.com/doc/refman/5.0/en/ansi-mode.html
<Therion> checkid dammit
<dellis> dammit: (SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION) http://dev.mysql.com/doc/refman/5.0/en/show-create-procedure.html
<dellis> dammit: (Find All Non-distributed Twins) http://dev.mysql.com/doc/refman/5.0/en/twin-pool.html
<dellis> Therion: dammit -> true
<Therion> dammit: try that command
<Therion> hehe
<dammit> checkid dammit
<dellis> dammit: You do not have permission to do that.
<Therion> Okie dokie
<Therion> bye bye
<dammit> hey, I need permissions!!!!!!
<dammit> I want to be able to kick and ban people
<dammit> and stuff
<Therion> dammit: You will have them
<dammit> ;-)
<dammit> great!
<Therion> But right now I'm sorting out the lucene issues before bothering with the fun stuff
<MHillyer> Ooh, I want them too!
<Leithal> GRANT NOTHING on freenode.#mysql TO 'dammit'@'%';
<MHillyer> Nevermind, the power would corrupt me.
<dammit> Therion: I can always offer you SearchLucene.php and MWDaemon sources ;-)
<dammit> but it's not perfect there as well
<dammit> ;-)
<Therion> It's no big deal
<dammit> usually you specify weights in your query
<Therion> I'll introduce some of the weighting stuff I have in SQL right now
<Therion> Yep
<dammit> but I guess you already know it all
<Therion> Will add some of the kludges as well
<Therion> yeah
<Leithal> Mr. Know It All!
<Therion> I just want it to be more useful than what SQL does right now
<Therion> Otherwise I'll just incorporate that
<dammit> good boy!!!
<Leithal> Well you HAVE to add !weather then
<Leithal> Life would never be the same without !weather
<dammit> and use AccuWeather for that
<dammit> !weather Vilnius, Lithuania
<SQL> Failed to lookup weather at station VILNIUS, LITHUANIA
<dammit> SQL: you ****!
<Leithal> think it looks for airport codes
<Leithal> or something stupid like that
<MHillyer> !weather yql
<SQL> Failed to lookup weather at station YQL
<dammit> !weather YMVI
<SQL> Failed to lookup weather at station YMVI
<dammit> !weather YVMI
<SQL> Failed to lookup weather at station YVMI
<Leithal> It really is pants
<Leithal> !weather BHX
<SQL> Failed to lookup weather at station BHX
<Leithal> !weather LHX
<SQL> Failed to lookup weather at station LHX
<dammit> !weather EYVI
<SQL> Current conditions at Vilnius, Lithuania: It is 7 C (46 F), windspeed is 9.66 km/h, and visibility is 3.22 km. (Information current as of 2005.10.21 2050 UTC).
<Leithal> Because Hethrow isn't one of the largest airports in the workd.
<dammit> see!
<dammit> Vilnius airport code is VNO though
<[RainMkr]> !weather DEN
<SQL> Failed to lookup weather at station DEN
<Therion> Making up stuff instead of following directions is useful
<Therion> Oh wait, no it isn't
<Therion> dammit: I was just going to use JWeather
<Therion> Leithal: I plan to retain all functionality, just add more
<dammit> ;-)
<Therion> The guy who did this bot does not, to my knowledge, maintain it anymore
<Leithal> Nice
<Leithal> In Java as well
<Leithal> You demon.
<Therion> ANd frankly I'm tired of Twisted and Python
<Therion> So, new bot, write from scratch
<dammit> wait, the bot before was twisted? :-)
<dammit> ha!
<Therion> it uses Twisted
<Therion> egads not Astinus
<NeoThermic> hmm
<NeoThermic> whats up with MySQL 5's strict mode?
<Leithal> What's down with it?
<NeoThermic> well, its odd
<NeoThermic> foo char(10) NOT NULL
<NeoThermic> in a table creation statment used to be valid
<NeoThermic> now it doesn't like it
<MHillyer> You have no DEFAULT set.
<NeoThermic> column_definition:
<NeoThermic> col_name type [NOT NULL | NULL] [DEFAULT default_value]
<NeoThermic> defatult is optional..?
<MHillyer> Well strict mode is more strict.
<NeoThermic> "If the column cannot take NULL as the value, MySQL defines the column with an explicit DEFAULT clause, using the implicit default value for the column data type."
<NeoThermic> "For string types other than ENUM, the default value is the empty string. "
<MHillyer> Will you just try adding a damn default clause rather than quote me the manual? ;)
<NeoThermic> the behaviour of strict is odd though
Return to mysql
or
Go to some related
logs:
politics
huge web "add.php"
|
|