Hey did Ken come over or something?

Now that I have work to do, idle blogsurfing seems somehow much MORE attractive than it did just yesterday.

Let’s see, if I were Ken, I’d…

  • chew, worry, and otherwise attend to nails, cuticles, and so forth
  • look to see if there were any obscure British humor shows on BBC America or maybe on ifc or canadian TV
  • repeatedly pick up the physical objects associated with the assignment (notes, raw materials from the client, pens) and fiddle with them while sighing heavily
  • Experience distracting itching just as I was getting into the rhythym
  • seriously consider the possibility of entering an online minesweeper tourney which offers real money
  • spend at least two hours writing something for the Illuminated Donkey instead of about the assignment
  • undoutedly other, less savory pursuits, all in the service of not getting the assignment done

Then I’d get to work and crank out the finest piece of understated technical writing that Jersey City’s ever seen.

NOT being Ken Goldstein but rather Mike Whybark, though, I’d

  • Spend several hours designing and thinking about workflow systems to allow me to to the work as fast as humanly possible
  • Spend more time musing to myself (and you guys) about that than actually developing the tools I’ve dreamt up
  • Start doing the work only to be distracted again
  • eventualy, I’d do the work

Can you guess what stage I’m in right now?

ODBC, MySQL, Mac

MacInTouch Reader Reports: ODBC and the Mac covers a couple years of struggle in Mac-land regarding the availability of ODBC drivers for providing distributed database connectivity.

I’m looking into it because I’d like to read-write to my MySQL implementation from Word, not someting I expected to succeed at since MySQL is a direct threat to SQL Server’s market.

To my surprise, it’s not impossible, only tough. First, I still use Word98 in Classic, which does not provide easy ODBC support, although you can make it work if you twist your body around into a sufficient number of uncomfortable positions.

However, in both Word 2001 and Office v.X, mac ODBC is much more readily supported via a number of routes – none super user friendly, I think; but less of a forced march. Mind you, this is some connecting of the dots going on here – I did NOT find a perfect example of a simple, user oriented how-to anyplace, except maybe here:
AugSOFT Office98/2001 docs.

The problems with these older drivers are twofold: one, they’re not free, natch; and two, they don;t offer MySQL support, since MySQL had yet to gather steam back then.

AugSOFT offers a standalone server-bridge (for wintel) that can work with MySQL, but that’s beyond my scope.

On the looks promising front, www.iodbc.org and Openlink Software both offer work in the direction of tying MySQL to ODBC connectivity; as seems to be the case for most of this, it looks as though nothing is perfectly meeting my Word-MySQL jones on the matter.

hmmm.

…like this, maybe

A PHP web GUI dev studio called DaDaBik. (Psst, I’m referencing the the previous entry… sorry for the lack of context.)

Um, sort of.

I guess the way it would work here is:

  1. design schema
  2. create tables (CLI, DaDaBik, MySQLAdmin)
  3. poke at GUI (hand, DaDaBik, Dreamweaver)
  4. repeat

Geez, that doesn’t sound real elegant.

Hm, there seems to be a family of these out there:

PHPLens makes some interesting claims for itself. Oooh! Image upload. <Homer voice>ohhh, im-age up-load</Homer voice>

Oh, nm. DaDaBik is GPL; PHPLens is mucho dinero.

Hey Geeks! Speak wise for me now.

Take part in an exciting and life-enhancing fat-chewing session! Waste valuable time pontificating on thinly-supported opinions!

You may recall my noting that shortly I’ll be performing regular news gathering, mastication, and regurgitation duties for Cinescape, which will require cruising entertainment-industry news sites for valuable lies about upcoming projects et cetera.

Much like speeding through my blogroll, actually. But now I’ll have to pay a bit more attention. Of course, those of you that took longer than most of us to learn how and why one’s shoes must be tied, the importance of good hygiene in attracting a mate, and why it’s better for your monkey-status to shoot some hoops than read a book are thinking: “Hm, I could whip up a robot that could do that in no time flat.”

Well, first, that’s what I’m thinkin’, too, beanie-bros; and second, we’re lying to ourselves.

It will actually take a significant amount of effort.

On the web, as you well know, “a significant amount of effort” means first, we design a database. (Then we screw up and lose all the data, or maybe even the data-structure, but we don’t tell anyone and it’s back together again by morning, maybe even with most of the data)

Then we adjust the design structure to reflect the actual needs of the users (well, ok, the budget doen’t actually include this, but it says right here that we should – it’s those darn suits, holding everybody down again), since we were only imperfectly able to anticipate the data structure needs.

NOW we can work on the robot.

But guess what? That whole swath of mildly amusing geekrant is just bait. Really, it’s like this.

I have to store a great deal of data, daily, for rework and attribution and so forth. There’s a decent CMS (content management system) at the mag which I’ll be using, but they want the finished product, not the raw materials. So that means I need a locally maintained database that allows me to store articles, attribute them (via URL at minimum, but possibly with greater granularity), quickly prioritize and sort, and rewrite. I can keep in mind we’ll eventually be building a little seeker-bot to grab the data as I design the storage structure.

So here’s the question: I have and use FileMaker Pro (uh, I think I’m using an older version – 4.mumble) for most of my quick and dirty database stuff, because of its’ ease of setup and UI rework. Sadly, it’s stuck in OS9 and I’m running it via the Classic environment; which really hasn’t hurt it’s core performance, but for stuff like browser-to-field drag and drop, it’s not ideal. It works fine, though.

See Jane Code! is a small visual dev studio app for PHP and MySQL. PHP and MySQL are coding langidges (and a database server) that help to run bellerophon, the overtaxed, resurrected-from-the-grave G3 laptop which serves these pages to you, my teeming tens and dozens.

Using this tool, or something similar, I can get at least 30% of the design flexibility of FMPro and have another webside app to wave in the face of oh, those many recruiters who so ignore my weekly applications for their jobs.

I prefer an organic, UI-oriented design practice, and when the client is ME, I can indulge myself.

Here’s the turnip soup: Should I stick with old FMPro 4 and take advantage of that flexibility while I fine tune my needs, at the expense of a possibly cool demo project? Or commit to an experiment and set up my data-collector as a web-oriented app from the get go?

I could use FMPro on an interim basis, you know, to get the benefit of the organic evolution; but the interface quirks of going from browser to FMPro are not conducive to data granularity.

I could also buy a new OSX-compatible version of FMPro.

Speak, you nerdly persons in your glasses! Speak! Indulge us with your deep thoughts on the matter!