Обсуждение: Hardware recommendation for PostgreSQL on Windows?
I an planning to make a small Windows application and need a nice database.... I am used to using PostgreSQL under Linux and I am thinking about using this under Windows but how much resources does it use under Windows? The server will be running on the workstation along with the Windows application, so it should be lite... And I know that maybe I should be using something else, like SQLite or something but I have never used it and I don't want to spend too much time learning how to use other databases... And I am also going to use Delphi, so I am not sure how well any other db is supported....? Regards, BTJ -- ----------------------------------------------------------------------------------------------- Bjørn T Johansen btj@havleik.no ----------------------------------------------------------------------------------------------- Someone wrote: "I understand that if you play a Windows CD backwards you hear strange Satanic messages" To which someone replied: "It's even worse than that; play it forwards and it installs Windows" -----------------------------------------------------------------------------------------------
""Bj?rn T Johansen"" <btj@havleik.no> wrote >I an planning to make a small Windows application and need a nice >database.... I am used to using PostgreSQL > under Linux and I am thinking about using this under Windows but how much > resources does it use under Windows? > The server will be running on the workstation along with the Windows > application, so it should be lite... > And I know that maybe I should be using something else, like SQLite or > something but I have never used it and > I don't want to spend too much time learning how to use other databases... > And I am also going to use Delphi, > so I am not sure how well any other db is supported....? > > I am not sure how exactly you want to use PostgreSQL? In a client application or as a backend database server? Need (1) multiple-connections? (2) Need transaction? (3) SQL? Regards, Qingqing
Qingqing Zhou wrote: > ""Bjørn T Johansen"" <btj@havleik.no> wrote >> I an planning to make a small Windows application and need a nice >> database.... I am used to using PostgreSQL >> under Linux and I am thinking about using this under Windows but how much >> resources does it use under Windows? >> The server will be running on the workstation along with the Windows >> application, so it should be lite... >> And I know that maybe I should be using something else, like SQLite or >> something but I have never used it and >> I don't want to spend too much time learning how to use other databases... >> And I am also going to use Delphi, >> so I am not sure how well any other db is supported....? >> >> > > I am not sure how exactly you want to use PostgreSQL? In a client > application or as a backend database server? Well, it would be more like in a client application but I am not sure if there are going to be more than one user in the future... > Need (1) multiple-connections? See above, only one user now but might be more.. (2) Need transaction? Don't need, but nice to have the option.. (3) SQL? Well, SQL would make things easier.. > > Regards, > Qingqing > BTJ
Bjørn T Johansen wrote: >I an planning to make a small Windows application and need a nice database.... I am used to using PostgreSQL >under Linux and I am thinking about using this under Windows but how much resources does it use under Windows? >The server will be running on the workstation along with the Windows application, so it should be lite... >And I know that maybe I should be using something else, like SQLite or something but I have never used it and >I don't want to spend too much time learning how to use other databases... And I am also going to use Delphi, >so I am not sure how well any other db is supported....? > > > You should be fine using the win32 version on the same PC as the app. If you need something really lite and embedded right in your Delphi application you might want to take a look at the free embedded version of Nexus DB (Flash Filer decendent). Delphi works great with Postgresql and there are several components to choose, if you want free then Zeos is a good choice http://www.zeoslib.net or if you don't mind paying a small amount you can use PostgresDAC from http://www.microolap.com. I use PostgresDAC for development of PG Lightning Admin (http://www.amsoftwaredesign.com), so it's a good reliable choice. Hope this helps, Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql http://www.amsoftwaredesign.com