Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

Re^3: What is your favourite Linux or cross-platform database? (postgresql)

by Anonymous Monk
on May 12, 2010 at 02:37 UTC ( #839526=note: print w/ replies, xml ) Need Help??


in reply to Re^2: What is your favourite Linux or cross-platform database? (postgresql)
in thread What is your favourite Linux or cross-platform database?

Per the 80/20 rule, I would go with SQLite for the majority case and then postgresql for the minority case. For the outlier 110+, Cassandra is looking good these days for NoSQL. For the majority NoSQL solution, I would vote for the module called y_serial at http://yserial.sourceforge.net -- definitely the easiest to implement, and fast in terms of development time. As for the BLOB issue, yserial seems to handle it well via compression. From a database performance perspective, you want BLOB under 2M, otherwise one is better off using files.


Comment on Re^3: What is your favourite Linux or cross-platform database? (postgresql)

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (13)
As of 2015-07-30 07:44 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (270 votes), past polls