SQLDeveloper 1.5.1

It's Rockin' Awesome.

I went to the ODTUG presentations that Sue Harper did on SQLDeveloper and was very impressed with some of the features that I didn't know about and also the stuff that is on its way.

When she showed how to import data from Excel (ok, it is broken in the current patch, but it rocks) and then showed the Normalize feature, I was blown away.

Combine that with the upcoming (unofficial) Data ing tool (which I've been previewing/using in the JDeveloper 11g technical preview), and I'm ready to throw away Designer. No offense, but currently, we use Designer for very little. I've built separate scripts to take care of building audit columns. I need to build a script that will build a Journal table and then I'll be done with Designer forever, since we were really only using it for ing and the auditing/journaling API's that id built.

It also inspired me. Between APEX and SQLDeveloper, there is NO reason to create data and maintain business-critical in Excel. Now, Excel becomes just another output method in my opinion. And Word -- seriously, I'm blown away that anyone would store data in Word. Word is a great Word Processor, not a data storage system.

I love that Code Templates and configurable Tab sizes are available in the newer versions of SQLDeveloper. Those were among my two biggest complaints about a year ago. Petty, I know, but Code Templates are such a huge time-saver. I mean, there are certain things you do as a developer thousands of times in your career. If you hand-type them every time, then you are 1) Dumb, and 2) Going to forget something and build a bug.

Saw a meteor on Sunday

http://www.ksl.com/?nid=148&sid=3496031

It was way cool.

Firefox 3, Release Candidate 1

So far, I like it. Before I installed it, I uninstalled all of my other Firefox installations. Both Firefox 2 and Firefox 3, beta 5 were unstable, but I think part of it is my fault for having them both installed.

I am, however, having trouble with certificates on one of our development we sites. With version 2, it would let me 'allow' the site, but with 3, it blocks me entirely.

tikiwiki on Oracle -- part 13.5

This is a bunch of garbage. They say you can install TikiWiki on Oracle, but I don't see how their install scripts have ever run. They use reserved words extensively as column names, and a bunch of syntax that isn't even supported.

I've been searching for other wikis that will install on Oracle (without re-writing the dumb thing) and so far, not much luck.

Here's the deal. Why is oracle hosting their wiki on wetpaint.com? Kinda makes me think that there is not a very good fit of 'Oracle' products to do the job.

tikiwiki on Oracle -- part 13

Just got back from vacation and started playing with this again. I've been having PHP trouble. When I uninstalled EasyPHP, it didn't clean up the registry correctly and so PHP scripts weren't running right. It also left registry entries for the old version of Apache, even though it had been uninstalled.

I also had problems with the database setup scripts. I had to strip them of the ' " ' character, as it was loading all object names with ' " ' at the front and back.

So, I dropped the user, cleaned out the EasyPHP stuff that I can find, re-installed the database objects, and have uninstalled everything else.

Here we go....

tikiwiki on Oracle -- continued

Hey, someone commented. I'm all excited now.

This morning, I uninstalled Apache and EasyPHP. This also broke my previous lame attempt at installing the Zend Core, so I had to uninstall that.

I was worried that my APEX interface to XE had tapped into one of the Apache installations and was using it as its server. No problem, though, as it had installed with the database web server and was unaffected by all of the uninstalling.

Re-installed Apache 2.2.8. I got a syntax error on line 86 of in http.conf file. Since I don't know what LoadModule anon_auth_module modules/mod_auth_anon.so does, I commented it out.

Now I'm having a problem with something blocking port 80. Probably either something in the firewall here, or one of my virus scanners, filters, etc., so, since this is just a proof of concept anyways, I tried port 88. Apache started.

I re-installed the Zend Core as well, using the new Apache server.

Hmmm...now what?

Tikiwiki on an Oracle Database?

I love Wikis. They rock. I use tiddlywiki for ad-hoc note-taking and for a journal file. In combination with Keybreeze, I can make a journal entry almost as fast as I have the thought.

But, I'm an Oracle database programmer. I work in a place with a documentation problem. To me one of the big obstacles with documentation is Word. As a Developer, the thought Process is something like this:

• I need to document that.
• Open Word
• Where is that documentation template that we agreed on in our Programming Standards.
• What was I doing?
• Oh screw it.

So, I've given myself the challenge of trying to convince management here that a wiki could help with the documentation. The benefits being:

• Consistent, clean output.
• Backup -- happens with the database.
• Fast, simple formatting.
• Easy to get to -- it's just a URL.

Here is what I'm looking at for the initial Proof of Concept:

• Oracle XE on my laptop.
• Tikiwiki
• Oracle's endorsed PHP Zend [NOTE: I forgot -- I have EasyPHP installed from a former attempt -- I'll use that for the proof of concept.]
  
• Apache, of course.

So far, I downloaded Oracle XE -- it went off without a hitch. Very impressive, Oracle. Thank you.

Then, I ran the tiki database install script just to see if it would go. It wants to throw indexes on some of the LOB objects, which isn't supported (at least on XE). I'm worried that may be a problem down the road, but we'll see. I don't know that an Oracle index would really do any good on a LOB, though, since you are probably looking for something in the middle of the LOB, which wouldn't use the index anyways. We'll have to see if it totally messes up searches.

Now, I need to install the PHP and configure Apache. Yuck.