Re: PostGreSQL for a small Desktop Application

David Gardner wrote:
> I'm not much of a .Net guy, but the pgsql-ODBC driver works rather well for me. Take a look at:
> http://psqlodbc.projects.postgresql.org/howto-csharp.html
>
> As for Windows XP, isn't there some limit to the number of incoming network connections?
>
> ---
> David Gardner, IT
> The Yucaipa Companies
> (310) 228-2855
>
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Gabriele
> Sent: Monday, June 11, 2007 10:45 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] PostGreSQL for a small Desktop Application
>
> I'm going to develop a medium sized business desktop client server
> application which will be deployed mostly on small sized networks and
> later eventually, hopefully, on medium sized networks.
> It will probably be developed using C#.
>
> I do need a solid DBMS wich can work with .Net framework. I do know
> PostGreSQL is a good DBMS in general (it sports most of the advanced
> DBMS features, transactions and stored procedure included) but i
> wonder if it is suited for my application.
>
> Knowledge base of my users is very low and "servers" will be standard
> class desktop computers most probably ran on Windows XP (and Vista
> later on, i suspect).
> The service should be enough lightweight to be ran on such "server"
> and I need silent installation and configuration because i can't
> expect my user to be able to configure a DBMS.
> Additionally i need a passable to good data provider to interface
> PostGreSQL with .Net which possibly provide better performance than
> ODBC (don't know if it exists and i hope it is free).
>
> Anyway performance shoudn't be a big issue, i expect low concurrency
> level (less than 10 users) and low to medium volume of rows and
> queries. If more users and more data are needed for especially big
> customer i can simply suggest bigger and dedicated server. (different
> problems will arise for the aggregated data which will feed the web
> application, but for these we will have a real server).
>
> Is PostGreSQL suited for such use? If not which alternatives are there
> to be used? When using PostGreSQL in such a way is there any
> suggestion to be followed? Links to sources which i may find
> interesting (how to make a silent install, basic hardware
> requirements, so on).
>
> Thank you!
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>
On the network connections there are limits but the only one that I have
hit is open file shares or named pipe connections. I have been able to
get the number of open sockets very high in testing (though I may be
breaking the license agreement!) to the point where I get an odd buffer
space error (I actually posted on one of the lists about it previously)
but that was under extreem load to breakpoint conditions.

FYI
We are running MS IIS, PostgreSQL, Oracle XE, all of "our" code(7-8 C++
Services) and a VM image of FC6 on a good XP Pro machine with no
complaints so far and the system is providing a real time service in
which delays/interruptions would be noticed.

For high end systems we use Windows 2003 Server

Oisin Glynn