Re: Why can't I connect to postgres?

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