2004/09/16
IRC [01:18] *** brunom joined the chat.
IRC [01:25] *** zoro2 joined the chat.
IRC [02:26] *** zoro2 parted the chat.
IRC [02:48] *** tekbasse joined the chat.
IRC [03:35] *** frankie joined the chat.
IRC [05:22] *** tekbasse parted the chat.
IRC [07:06] *** brunom parted the chat.
IRC [08:41] *** zoro2 joined the chat.
IRC [09:33] <zoro2> hello
IRC [09:49] *** brunom joined the chat.
IRC [10:14] * jhavard wakes up to a windy morning.
IRC [10:17] * zoro2 has a mission to complete - advocate using AOLserver for a larger project whose CEO has nothing to do with websites :)
IRC [10:32] <Dossy> morning.
IRC [10:33] <Dossy> Heh. For a project here at AOL, I used AOLserver to build a ETL tool -- the only "web page" it ever serves is a system status page. :-)
IRC [10:33] <Dossy> We made heavy use of ns_thread, ns_mutex, ns_sema, etc. -- good stuff.
IRC [10:36] <jhavard> etl?
IRC [10:36] <Dossy> ETL = Extraction, Transformation and Loading.
IRC [10:36] <Dossy> data warehousing.
IRC [10:36] <jhavard> ewww
IRC [10:37] <jhavard> data warehousing is just a scam to sell more software.
IRC [10:38] <jhavard> "BUT IT MAKES IT EASIER TO QUERY FOR REPORTS BY DENORMALIZAINING DATA!!!1"
IRC [10:42] <jhavard> Well, there is one use for "data warehousing", getting rid of data you don't need for long term use.
IRC [10:43] <jhavard> but that doesn't necessarily mean denormalizing either.
IRC [10:46] *** brunom parted the chat.
IRC [11:03] *** zoro2 parted the chat.
IRC [11:09] <jcollins> ah bind variables, good stuff
IRC [11:35] *** zoro2 joined the chat.
IRC [11:36] *** zoro2 parted the chat.
IRC [11:37] *** frankie parted the chat.
IRC [11:58] <jhavard> bind variables, as in for prepared statements?
IRC [11:58] <jcollins> yes
IRC [11:58] <jhavard> awesome.
IRC [11:59] <jcollins> it'll be nice to have them in ns_db
IRC [11:59] <jhavard> hrm, performance improvements are always.
IRC [11:59] <jcollins> but i'm more interested in getting them on the c side of ns_Db
IRC [11:59] <jcollins> on the tcl side i use ns_ora which already has them
IRC [12:01] <jhavard> But to get full advantage of prepared statements, unless you're doing a few dozen in one hit, wouldn't that need some way to prepare some statements when a db connection is initially made?
IRC [12:03] <jcollins> good question
IRC [12:03] <jcollins> i think that is correct
IRC [12:04] <jcollins> bind variables also make escaping a non-issue
IRC [12:04] <jhavard> honestly, I've never used a prepared statement.
IRC [12:05] <martinh> hmm. has nsopenssl been fixed any?
IRC [12:06] <martinh> nsopenssl 3.0, I should say. :->
IRC [12:06] <jcollins> jhavard: So really he wants to add a way to prepare, bind, execute in one shot
IRC [12:06] <jcollins> jhavard: right now it just prepares, then executes
IRC [12:07] <jcollins> in oracle at least using prepared statements allows oracle to cache them on the server side
IRC [12:07] <jcollins> so there is still that advantage
IRC [12:08] <jhavard> hrm.
IRC [12:11] *** rubick joined the chat.
IRC [12:17] <jhavard> ooh, savepoints are neat.
IRC [12:25] *** bartt joined the chat.
IRC [12:29] *** aolserver-scribe joined the chat.
IRC [12:29] * aolserver-scribe is logging
IRC [13:41] *** frodoroot joined the chat.
IRC [14:02] <Dossy> moo.
IRC [14:03] * jhavard throws out some hay
IRC [14:05] <Dossy> thank you :)
IRC [14:09] <Dossy> So, I see in the log people discussing my RFE for ns_db -- no one responded to the list. :)
IRC [14:46] <jcollins> i'm still forumlating my response
IRC [14:51] <Dossy> heh
IRC [17:28] *** zoro2 joined the chat.
IRC [18:33] *** zoro2 parted the chat.
IRC [19:02] *** frodoroot parted the chat.
IRC [20:06] *** rubick parted the chat.
IRC [21:51] *** bartt parted the chat.
IRC [22:32] *** cnk parted the chat.