Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re^2: Caching Format

by sundialsvc4 (Abbot)
on Jan 12, 2012 at 15:25 UTC ( [id://947554]=note: print w/replies, xml ) Need Help??


in reply to Re: Caching Format
in thread Caching Format

I second that motion.   SQLite isn’t an SQL database server.   What it is, is a public-domain(!) single file format which supports a rather full SQL-database model within that file (or files), including reliable transactions and therefore locking and known-good file sharing.   You don’t have to install anything beyond a package.   Since the database is “just a disk file,” in the same way that the file that you are now contemplating is just a disk file, this approach would give you tremendous “bang for your buck” and I would argue that no proprietary approvals of any kind would be necessary ... even in the most “hardened” business environment.   You are storing the data “in a file,” as originally contemplated, but now that file happens to be an extremely smart file.   Furthermore, the odds that SQLite is already there, even for run-of-the-mill purposes like hosting the cpan modules database, are pretty near 100%.

P.S.:   Yes, I said public domain.   There is no license.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others wandering the Monastery: (3)
As of 2024-03-19 04:44 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found