Tut # 7: jQuery, Ajax, xml, Perl, databases and utf8

I've tried to cover significant interactions between the topics mentioned in the Title above:

Tutorial # 7

The tutorial includes references to various now more-or-less standard documents, or collections thereof, pertaining to Perl, databases and utf8.

Perl && jQuery && XML && ! taconite

Hi All

If you're in a hurry, jump to my latest (6th) Perl + jQuery tutorial.

In short: I don't use the clever jQuery add-on taconite because it supports only commands (verbs) and I needed conditional execution (an 'if').

Nevertheless, I pinched-er-adapted the idea to unilaterally update some parts of the DOM, and to conditionally update other parts.

Happy reading...

Visualising SQL joins

Hi All

Here's an image displaying various options re SQL joins.

Wish I'd see this years, nay, decades, ago.

5 jQuery tutorials for budding Perlmeisters

Click keep reading to, errr, keep reading.

This is because I put the text of the entry in MT's 'Extended', and now I've just added this stuff to 'Body'.

Also, the 5th tut is on Autocomplete.

GraphViz2 and the dread MusicBrainz db

Hi All

OK. After a bit of pain I've set up an empty database for the
MusicBrainz database.

In particular, where they say 'sudo cpan Carton' you probably want 'cpanm Carton'.

This exercise was because, astonishingly, one of the users of my module GraphViz2 had doubts about it handling 149 tables spread over 4 schema.

The version of dbi.schema.pl shipped with GraphViz2 V 2.07 needed a patch to handle multiple schema, but after fixing that, you…