Re: Advantage of using DBI

Thank you for all your responses. Yes, he meant the MySQL CLI, command line interface. He has this idea that it is simpler to code using this method instead of using the DBI.

This stems from the fact as Ikegami mentioned that the CLI was meant for human interaction and it is easier for my boss to test his SQL on the CLI instead of using the DBI.

But again, thanks for your inputs.

Comment on Re: Advantage of using DBI

Replies are listed 'Best First'.
Re^2: Advantage of using DBI by mzedeler (Pilgrim) on Jul 03, 2009 at 18:58 UTC
Using the CLI to send commands from perl has two obvious problems: it is slow and its very hard (if not impossible) to use blobs. There is a host of other problems to handle that all stem from the fact that CLIs are meant run in batch or batch mode. Neither one of them is well suited for access from a script. Update: "meant to run in batch mode" should read "meant to run in interactive mode".	[reply]

Replies are listed 'Best First'.

Re^2: Advantage of using DBI
by mzedeler (Pilgrim) on Jul 03, 2009 at 18:58 UTC

Using the CLI to send commands from perl has two obvious problems: it is slow and its very hard (if not impossible) to use blobs. There is a host of other problems to handle that all stem from the fact that CLIs are meant run in batch or batch mode. Neither one of them is well suited for access from a script.

Update: "meant to run in batch mode" should read "meant to run in interactive mode".

[reply]