Take the 2-minute tour ×
Mathematica Stack Exchange is a question and answer site for users of Mathematica. It's 100% free, no registration required.

Installing either MySQL or PostgreSQL. My concern is just with Mathematica. I am going to be using it to store a good bit of basic data but the main thing is fast image retrieval and comparison using Mathematica as the comparing engine. Anyone have experience with any of this? Thoughts, directions or more questions?

share|improve this question
    
I use both, much prefer Postgres.The interfacing capabilities and datatype definition are pretty peerless. Probably better to ask this on their respective fora... Disclaimer: Illustra (commercialized Postgres) was one of my startups. –  rasher Jan 20 at 7:59
    
I have only ever used MySQL so cannot comment on a database comparison but as far as interfacing with Mma goes it is nice and easy. –  Mike Honeychurch Jan 20 at 8:18
    
Might be a better question for the WCommunity, since this is a subjective question. –  bobthechemist Jan 20 at 12:28
    
@bobthechemist -- I don't think we can regard this as a subjective question. MySQL and PostgeSQL have different capabilities and performance because of their inherent designs. PostgreSQL has more institutional capable performance. Head to head PostgreSQL provides a viable alternative to top tier database base platforms (including the likes of Oracle and SAP) in their core markets. MySQL doesn't really do that. All of this said, the OP has a specific need. Given that one can download both these platforms for free, why not simply test them? –  Jagra Jan 20 at 14:08
    
@Jagra Fair enough. Perhaps additional details from the OP would be helpful. Is the question "Is there a measurable difference in performance between the two database packages when retrieving <insert size> images via Mathematica?" –  bobthechemist Jan 20 at 14:26
show 1 more comment

1 Answer 1

You might also consider H2 Database. Very fast, super flexible (eg write your own functions and aggregate functions in java), administration is very convenient. I've had a lot of success using it in research to organize and store numerical data.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.