in reply to How to handle relationships
The thing that really irks me is that, when developing an application, no matter how "standard" the SQL you use is, it's always a huge hassle to move from one back-end to another. If there were a sort of "driver" that wrote working SQL for you, it would be a simple matter of dropping a new one in. Mostly. Of course, nothing is perfect.my $table = SQL::Table->new(name => "client"); push(@{$table->columns}, SQL::Column->new(name => "id", type => { char + => 50 }); $table->commit();
|
|---|