[Slashcode-development] Oracle Port Progress, April 20-21: Now Welcoming Your Comments

[Stephen C. <the...@wa...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Well, if that don't beat all -- comments work now.  I came up with a little hack
involving a global temporary table to allow me to turn a string into a CLOB for
the duplicate comment checking function, and that was the biggest hangup.

Speaking of CLOBs, I looked back at my schema and changed a bunch of places
where I thought they were overkill -- tables like vars and such.  Originally I
had done a blind s/TEXT/CLOB/g when converting from the original MySQL schema,
because CLOB was the only thing that matched TEXT (65535 characters).  But a
closer look revealed that the most likely reason TEXT was used on some of these
fields is because the next step downward is TINYTEXT (255 character max), not
nearly long enough.  So I sanity checked all the CLOB instances and replaced
most of them with VARCHAR2(4000), which should be plenty.  Obviously CLOB
remains for stuff like comment and story text.

Tomorrow I'll be pulling things full circle, taking a look at the daemon stuff
and those ugly red-headed stepchildren in Slash::DB::Static whose existence no
one wants to acknowledge.  I believe that's the last major piece of
functionality left.  With the addition of comments, the Web end of things is
pretty much feature complete.

Also tomorrow I'll supply a patch against the latest CVS for everything I've
mangled so far, if any of you out there are daring enough to try it out.  The
main reason for the rushed release is so it can all get looked over for
inclusion in 2.0.  There is a lot here (the diff at present is 138K) and the
changes to the core are significant enough that someone with more tenure needs
to take a long look at them, and I've been told that it needs to happen quite
soon (geez, this sounds like my day job :).  However, I've been testing the code
on both Oracle and MySQL and MySQL hasn't complained yet, so that's probably a
good sign that it's stable.

The unleashing commences tomorrow.  Brace yourself.

- -- 
Stephen Clouse <the...@wa...>
warpcore.org Founder, Chief Megalomaniac, and Evil Overlord

-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8

iQA/AwUBOuJwQN1EXk7JbKbMEQKIGwCfZRswSq0IWh4TtlASg+nwQVMkxf0An0aL
8fEoBpZOslv02l5ILWpTx4tX
=zzi3
-----END PGP SIGNATURE-----