Lists: | pgsql-general |
---|
From: | "Theodore H(dot) Smith" <delete(at)elfdata(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Why can't I connect to postgres? |
Date: | 2006-07-24 16:57:52 |
Message-ID: | 101FFE54-54C0-4767-A22F-FA1521E40DC0@elfdata.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Well I tried NaviCat and some others, they seem to work. Perhaps the
problem was with REALbasic.
I can connect via perl, also, which is good.
What's a good way to store the database logic?
Say for example, I want to do something to the database, can I just
say something like DataBasePleaseTryRegisterUser( "name", "details",
"serial", "etc" ); where DataBasePleaseTryRegisterUser would be some
kind of function stored in the database itself?
Or should I put the logic into my perl files? And treat the database
as just that, a blind database which can store invalid data.
From: | "Raymond O'Donnell" <rod(at)iol(dot)ie> |
---|---|
To: | "Theodore H(dot) Smith" <delete(at)elfdata(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Why can't I connect to postgres? |
Date: | 2006-07-24 17:28:12 |
Message-ID: | 44C5113C.19483.80B017@rod.iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
On 24 Jul 2006 at 17:57, Theodore H. Smith wrote:
> Say for example, I want to do something to the database, can I just
> say something like DataBasePleaseTryRegisterUser( "name", "details",
> "serial", "etc" ); where DataBasePleaseTryRegisterUser would be some
> kind of function stored in the database itself?
>
> Or should I put the logic into my perl files? And treat the database
> as just that, a blind database which can store invalid data.
You can do either. I suppose which you go for depends on what you
want your application to do - For example, I frequently have to log
all changes to the data, in which case I find it best to write a
function which doe the logging and then call that function from
within other functions that do the updates - this way the log is
written within the same transaction as the update, with the resulting
peace of mind a major benefit!
--Ray.
----------------------------------------------------------------------
Raymond O'Donnell
Director of Music, Galway Cathedral, Galway, Ireland
rod(at)iol(dot)ie
----------------------------------------------------------------------
From: | John DeSoi <desoi(at)pgedit(dot)com> |
---|---|
To: | Theodore H(dot) Smith <delete(at)elfdata(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Why can't I connect to postgres? |
Date: | 2006-07-24 17:28:30 |
Message-ID: | 6C98F656-1326-469E-AE9E-D1C4CA873AE3@pgedit.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
On Jul 24, 2006, at 12:57 PM, Theodore H. Smith wrote:
> Well I tried NaviCat and some others, they seem to work. Perhaps
> the problem was with REALbasic.
I don't know the details of REALBasic, but perhaps it uses ODBC or
some other "generic" connection method. In this case, you probably
have to do some additional setup and configuration.
>
> I can connect via perl, also, which is good.
>
> What's a good way to store the database logic?
>
> Say for example, I want to do something to the database, can I just
> say something like DataBasePleaseTryRegisterUser( "name",
> "details", "serial", "etc" ); where DataBasePleaseTryRegisterUser
> would be some kind of function stored in the database itself?
>
> Or should I put the logic into my perl files? And treat the
> database as just that, a blind database which can store invalid data.
PostgreSQL has excellent stored procedure/function support. I prefer
to use that whenever possible. The starting points are CREATE
FUNCTION and pl/pgsql:
http://www.postgresql.org/docs/8.1/interactive/sql-createfunction.html
http://www.postgresql.org/docs/8.1/interactive/plpgsql.html
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL