Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

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

by roboticus (Canon)
on Nov 29, 2012 at 03:30 UTC ( #1006152=note: print w/ replies, xml ) Need Help??


in reply to Passing queries and data from a web server to a db server and back again...

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.


Comment on Re: Passing queries and data from a web server to a db server and back again...
Re^2: Passing queries and data from a web server to a db server and back again...
by Shuraski (Scribe) on Nov 30, 2012 at 00:04 UTC

    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...

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1006152]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (10)
As of 2014-07-23 22:41 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (154 votes), past polls