Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I've been considering PostgreSQL for an application I am writing in .NET WinForms, and the app is intended to be standalone with occasional sync-ing with a web service. I plan to use Sql Server for the web server (since I already have it available), but would like to use a DBMS with a smaller footprint on the client WinForms app -- thus PostgreSQL.

So is a good option for my intentions?

share|improve this question
1  
Isn't SQLite a better option for this? –  dezso Apr 22 '13 at 5:54
    
It might be... I'm still fishing for a good choice. Never considered PostgreSQL before, though, so it set me to wondering. –  Starwatcher Apr 22 '13 at 6:14
    
If you where fishing for options you should ask that as a question. This question, as it is now, is hard to answer with anything but "yes" or "no". –  trygvis Apr 22 '13 at 6:30
    
I've tried "shopping list" questions before on StackExchange sites, and they invariably get closed because they are too "open-ended" and so on. And if I complain they chew me out. So I am asking a specific question that can be answered definitively. Sort of. So, Yes or No? Anything else constructive will be welcome, too. –  Starwatcher Apr 22 '13 at 6:33

1 Answer 1

(this is just too long for a comment)

Postgres works very well on a workstation - it also works very well on the server.

You should be aware that Postgres, being a full blown server DBMS does require some kind of installation - and it requires to start the server process in order to use it. You don't really need a Windows service and you can start and stop the server from within your application (by calling pg_ctl).

For our development team I have prepared a little batch file that gets a Postgres server up and running from the ZIP distribution without any installation hassles. Something like that should be suitable for your needs as well). If your are interested, I can add it to this answer.

Although I really like Postgres (and would chose it over SQL Server any time), I agree with dezso that an embedded engine like SQLite (or even SQL Server CE) might be more suitable, due to smaller installation requirements (and thus less possible problems). But they are less powerful as well.

share|improve this answer
    
Power isn't quite as important as ease of installation and small footprint. I hadn't thought of Sql Server CE, but maybe I better. I was just looking over Sqllite, and it looks like a good candidate for my purposes. Because Jeff Atwood is going to use Postgres for his new discussion forum software made me want to check it out. –  Starwatcher Apr 22 '13 at 7:03

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.