##################
# Server

my $id = 0;
while (1) {
 # do mysql query: "SELECT FROM msgs WHERE id>?", $id

 for my $msg ($results_of_mysql_query) {
  # do something with this line of data
 }
 sleep 1;
}

##################
# Client:
while (<STDIN>) {
 chomp;

 # do mysql insert: "INSERT INTO msgs VALUES(?,?)", '', $_;
}