Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Database normalization the easier way

by gmax (Abbot)
on Dec 17, 2001 at 17:15 UTC ( #132513=perlmeditation: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    #!/usr/bin/perl -w
    use strict;
    ...
    );
    my $norm = Normalizer->new (\%parameters);
    $norm->do();
    
  2. or download this
    perl -e 'use Normalizer; Normalizer->snew(qw(localhost music \ 
        MP3 album_id album,artist,genre tmp_albums songs 1 0 0))->do()'
    
  3. or download this
     +----------+-------------+------+-----+----------+----------------+
     | Field    | Type        | Null | Key | Default  | Extra          |
    ...
     | size     | int(11)     |      |     | 0        |                |
     | genre    | varchar(10) |      | MUL |          |                |
     +----------+-------------+------+-----+----------+----------------+
    
  4. or download this
        DROP TABLE IF EXISTS tmp_albums;
          # create the lookup table
    ...
        FROM MP3 src INNER JOIN tmp_albums lkp 
            ON (src.artist =lkp.artist and src.album =lkp.album 
                and src.genre =lkp.genre);
    

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlmeditation [id://132513]
Approved by root
help
Chatterbox?
[Tux]: None work for me. My dead key is AltGr (right Alt)
[Tux]: And I just tested, neither do other Tk apps :) (95% of my Tk Apps is either just monitoring (no input) or input of just numbers). Something to investigate then
[choroba]: Maybe something like this?
[choroba]: I vaguely remember we had problems with dead keys in Tk at $work - 2, but I forgot all the details
[choroba]: but it was worse on MSWin than on Linux
[choroba]: (and OSX didn't exist yet)
[choroba]: Also, I'd try starting the App with the US layout and switch to the dead keys layout later

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (5)
As of 2017-09-25 20:47 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    During the recent solar eclipse, I:









    Results (290 votes). Check out past polls.

    Notices?