minimum hardware requirements for small postgres db

[Paul Smith]

I am having difficulty finding documentation stating the minimum hardware
requirements to run pg under Windows. (I did look in the FAQ & User Manual)

I seek an open source RDBMS with close adherance to ANSI standards, good
free graphic design tools for drawing of the ER Diagram, validation of the
ERD model, and generation of the SQL required to build the DB.

I only want to design a few small DB Apps using about 20 tables, for
single-user offline environment, hopefully runnable on Nettop class
hardware under WinXP or Win7 32bit.

I want to access the db via a Forms driven GUI and a Report-writer with
features comparable to old versions of Access, but preferably also
open-source.

If Atom class nettop not sufficient, would like to know the minimum class
of CPU, RAM, GPU required.

Thank you in advance for any assistance

[Daniel Staal]

--As of February 20, 2013 10:50:12 AM -0300, Paul Smith is alleged to have

Post by Paul Smith
I seek an open source RDBMS with close adherance to ANSI standards, good
free graphic design tools for drawing of the ER Diagram, validation of
the ERD model, and generation of the SQL required to build the DB.
I only want to design a few small DB Apps using about 20 tables, for
single-user offline environment, hopefully runnable on Nettop class
hardware under WinXP or Win7 32bit.  
I want to access the db via a Forms driven GUI and a Report-writer with
features comparable to old versions of Access, but preferably also
open-source.

--As for the rest, it is mine.

While Postgres would probably work for you, I suspect it's probably
overkill. I'll let others answer your direct question, but I want to
suggest that you take a look at SQLite as something likely closer to your
needs: <http://www.sqlite.org/>

Not saying Postgres isn't great - it is. But sometimes you need an
industrial-grade nailgun, and sometimes all you need is a hammer.

Daniel T. Staal

---------------------------------------------------------------
This email copyright the author. Unless otherwise noted, you
are expressly allowed to retransmit, quote, or otherwise use
the contents for non-commercial purposes. This copyright will
expire 5 years after the author's death, or in 30 years,
whichever is longer, unless such a period is in excess of
local copyright law.
---------------------------------------------------------------

[Wolfgang Keller]

Post by Paul Smith
I seek an open source RDBMS with close adherance to ANSI standards,
good free graphic design tools for drawing of the ER Diagram,
validation of the ERD model, and generation of the SQL required to
build the DB.

Database design and development tools are (imho unfortunately) not
included with the PostgreSQL project.

There are a lot of free ones (besides commercial ones) listed here that
work with PostgreSQL:

http://www.databaseanswers.org/modelling_tools.htm

On "weak" hardware, I would avoid anything that's Java-based.

Post by Paul Smith
I only want to design a few small DB Apps using about 20 tables, for
single-user offline environment, hopefully runnable on Nettop class
hardware under WinXP or Win7 32bit.
I want to access the db via a Forms driven GUI and a Report-writer
with features comparable to old versions of Access, but preferably
also open-source.

LibreOffice Base comes with a native PostgreSQL driver.

If you want to implement "real" applications, there are a bunch of
database RAD frameworks available for Python:

using PyQt (& Sqlalchemy):
Pypapi: www.pypapi.org
Camelot: www.python-camelot.com
Qtalchemy: www.qtalchemy.org

using PyGTK:
Sqlkit: sqlkit.argolinux.org (also uses Sqlalchemy)
Kiwi: www.async.com.br/projects/kiwi

using wxPython:
Dabo: www.dabodev.com
Defis: sourceforge.net/projects/defis (Russian only)
GNUe: www.gnuenterprise.org

Pypapi, Camelot, Sqlkit and Dabo seem to be the most active and best
documented/supported ones.

On "weak" hardware, wxpython (Dabo) and GTK (SQLkit) will probably
be more suitable than PyQt.

Sincerely,

Wolfgang