From: | "ray joseph" <ray(at)aarden(dot)us> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Looking for Suggestion on Learning |
Date: | 2011-02-06 02:22:47 |
Message-ID: | 94F0D5582989409E9E6BDB2B5222699F@corp.kbr.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> On Saturday, February 05, 2011 9:30:13 am ray wrote:
> > I have built a few databases with MS Access and I would like to learn
> > how to use pgsql. I have found some examples but they have been too
> > complex to follow or to abstract with no specific details.
> >
> > I would like to find a simple example that would take me from an open
> > source design tool to a simple method to implement the design.
> >
> > I would like to find a simple guide, tutorial or example and will
> > appreciate any help.
> >
> > ray
>
> It will be difficult to find a simple drop in replacement for what you had
> with
> Access. The closest thing I can think of is OpenOffice/LibreOffice Base
> (http://help.libreoffice.org/Common/Database_1) and that is not as well
> integrated. Most Open Source development tend to use chains of tools,
> admin/creation --> driver/middle layer --> GUI design, with each aspect
> handled by a different program. I tend to handle admin/creation with text
> files run through psql. I work with Python so my database driver is
> psycopg2. This n turn gets used by a framework. For desktop apps I use
> Dabo > (http://dabodev.com/)
> Since the final output is determined by mix and match it is hard to find a
> 1-2-3 tutorial. My suggestion is to make a list of your needs and work
> bck from there:
>
> 1) What OS(s) do I want to deploy on?
> 2) What programming language(s) do I want to work with?
> 3) Where do I want to deploy, desktop/Web?
> 4) What do I want to build, simple SOHO apps .... enterprise apps?
>
> With answers to these questions it would be possible to narrow the field a
> bit. Unfortunately, it is one of those good news/bad news situations.
> Good news, Open Source is about a variety of choices. Bad news, Open
> Source is about a variety of choices.
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)gmail(dot)com
Adrian,
Thank you for the clarifications. I would like to address the guiding
questions you presented:
1) What OS(s) do I want to deploy on? Windows, right now XP.
2) What programming language(s) do I want to work with? Python.
3) Where do I want to deploy, desktop/Web? Desktop at first.
4) What do I want to build, simple SOHO apps .... enterprise apps? SOHO at
first.
My responses represent what I expect a learning path to take. Although I
will probably not be programming for web or enterprise, what I build may be
a prototype for such. I am not looking for the tools to build the big apps,
I just want to learn the basics, or more important right now, the simple.
Please help me understand what you mean by " I tend to handle admin/creation
with text files run through psql."
I looked at Dabo and it looks like it is for developing applications. Is
there a tool for designing a database?
Ray
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2011-02-06 04:09:22 | Re: unable to publish layer |
Previous Message | Rob Sargent | 2011-02-06 01:32:24 | Re: CRUD functions, similar to SQL stored procedurs, for postgresql tables? |