Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'd like to use a database-enabled version of a particular application (http://idimager.com), but it requires Microsoft SQL Server. My home ecosystem is powered by a Gentoo Linux server, and I'm curious what my options are.

The ones I can think of are:

  • Get another box running Windows (Yuck - nothing against Windows, but I don't need two full time servers)
  • Switch my Linux box to Windows (I do love my Gentoo tho, so I'd rather not)
  • Run SQL Server under Wine (I'm scared that'll be slow, however...?)

Are there any other options?

share|improve this question
    
Running a Virtual machine would be a good option in your case, I think. –  nikhil Feb 6 '12 at 4:25
    
sql server will not run under Wine –  Keltari Sep 11 '13 at 15:22

1 Answer 1

IDimager is already a Windows application. Why not just run the DB on the same system as the application?

Also, the application seems to support using SQLite as well as MS SQL Server. Why not use that?

share|improve this answer
    
I don't leave my PC on all the time, and I have multiple PC's I want to access it from. Using SQLite won't solve my problem as the database isn't central. –  Eddie Parker Mar 2 '12 at 4:18
1  
The SQLite DB can be stored on your server, but SQLite is generally not geared towards concurrent writers. As long as you don't have multiple people trying to modify the DB (import, tag, or organize images) at the same time, it should be safe. If you can live with that particular constraint, you should be able to use SQLite. –  afrazier Mar 2 '12 at 15:13

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.