Re: Passing queries and data from a web server to a db server and back again...

[roboticus]

I'd suggest moving to a database that supports network connections and just use the DBI package. I'm sure MySQL and PostgreSQL would be good. If your company already supports other databases, you might use one of those. I assume you're already using DBI to access SQLite, so if that's the case you'd just have to build your database on the database server and figure out the connection strings for DBI.

On the other hand, if your application doesn't require much in the way of data, and you don't expect it to grow beyond the capabilities of SQLite, then I guess you could always use DBD::Proxy so you can run SQLite on the database machine and your Catalyst app on the web server machine.

...roboticus

When your only tool is a hammer, all problems look like your thumb.

[Shuraski]

Thanks for the suggestion, did the conversion over to MySQL today. Come to think of it, now I remember hearing this about SQLite at some point -- good for quick development but not for deployment. So now I know. I am already using DBI for access, and will use that for MySQL as well.

Will keep you posted if I run into any glitches... I will also check out the features of DBD::Proxy -- never know when that might come in handy...