Xojo Conferences
XDCMay2019MiamiUSA

Postgresql (Real Studio network user group Mailinglist archive)

Back to the thread list
Previous thread: Re: ServerSocket
Next thread: is there any way to set a custom icon for a custom class in the RB ide?


Re: RB Company.   -   Rubber Chicken Software Co.
  Postgresql   -   Trausti Thor Johannsson
   Re: Postgresql   -   Roland Voegtli
   Re: Postgresql   -   Trausti Thor Johannsson
    Re: Postgresql   -   Maximilian Tyrtania
   Re: Postgresql   -   Andy Dent
   Re: Postgresql   -   Trausti Thor Johannsson
   Re: Postgresql   -   Trausti Thor Johannsson
   Re: Postgresql   -   Trausti Thor Johannsson
    Re: Postgresql   -   Jan-Ivar Mellingen
   Re: Postgresql   -   Jason Moehlman
   Re: Postgresql   -   Trausti Thor Johannsson
   Re: Postgresql   -   Christian Schmitz

Postgresql
Date: 04.08.09 13:02 (Tue, 4 Aug 2009 14:02:04 +0200)
From: Trausti Thor Johannsson
Like many, I am trying to move over to Postgres from Mysql. But I am having
some problems.
Like :

After I successfully connect to a server, and do an db.sqlselect("select *
from table") I get the error that the relations table does not exist. Also
I need a way to be able to list tables, list other databases and more of the
"\commands", but it seems I am not able. I know there is a $500 library out
there for doing postgres but it looks shaky and the user case is not
understandable, so I can't see if I pay per client or what. Any way, I
would like to use the RS Postgres plugin.

Anyone ?

Trausti
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>

Re: Postgresql
Date: 05.08.09 13:25 (Wed, 5 Aug 2009 14:25:35 +0200)
From: Roland Voegtli
Hi Trausti,

> After I successfully connect to a server, and do an
> db.sqlselect("select *
> from table") I get the error that the relations table does not
> exist. Also
> I need a way to be able to list tables, list other databases and
> more of the
> "\commands", but it seems I am not able.

I do use the RB postgresql plugin with postgresql 8.3 and 8.4 and
don't see
any big problems so far.

You need to adjust your mysql-thinking a bit... at least that was
needed for me
when I moved to postgres. Read a bit about schemas and the way you
reference
tables within schemas.

> Any way, I would like to use the RS Postgres plugin.

Which shouldn't be a problem in first place. Most of the "bugs" I
thought I
found showed to be based in my ignorance of postgresql. Once you get
used to
the changes, you will thank to god (or whatever you like) for doing
the switch.

cheers
®

_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>

Re: Postgresql
Date: 05.08.09 11:24 (Wed, 5 Aug 2009 12:24:56 +0200)
From: Trausti Thor Johannsson
Annual renewal, nope. Pay for X.0 version, all bug fixes and such free,
when X+1.0 comes out, I should be offered an upgrade price.Pure and simple.

Plus, the site needs quite a lot of information, huge faq and more. It
looks like it hasn't been changed in a while as you point out.

Trausti

On Wed, Aug 5, 2009 at 2:15 AM, Andy Dent <<email address removed>> wrote:

>
> On 08/04/2009, at 8:46 PM, Trausti Thor Johannsson wrote:
>
> This plugin is way WAY to expensive.
>>
> For the value it adds, provided it continues to be maintained, I think the
> pricing is reasonable.
>
> HOWEVER
>
> I would be a bit more assured if there was a statement about which versions
> of RB and Postgres it has been tested against.
> " requires REALbasic 2006r3, either Standard or Professional, and
> PostgreSQL 7.4 or later." seems a bit old!
>
> Out of interest, if it was a lot cheaper but required annual renewal, would
> you regard that as more reasonable?
>
> Speaking as a former database vendor who ended up open-sourcing the product
> because my marketing skills didn't match my coding ones...
> (OOFILE)
>
> Andy Dent - www.aussiedesignedsoftware.com
> Freelance Designer-Developer - C++, C#, Objective-C, Python, REALbasic,
> Ruby, VB.Net
>
> _______________________________________________
> Unsubscribe or switch delivery mode:
> <http://www.realsoftware.com/support/listmanager/>
> Search the archives:
> <http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>

Re: Postgresql
Date: 05.08.09 13:11 (Wed, 05 Aug 2009 14:11:23 +0200)
From: Maximilian Tyrtania
I'm using Christian's JDBC-classes to connect to PG and so far I'm as happy
as I can be. See:

http://www.monkeybreadsoftware.net/class-javaconnectionmbs.shtml

The current version of RB's pg plugin fails to read date values from my PG
8.3 db, unfortunately.

Best,

Max

am 05.08.2009 12:24 Uhr schrieb Trausti Thor Johannsson unter
<email address removed>:

> Annual renewal, nope. Pay for X.0 version, all bug fixes and such free,
> when X+1.0 comes out, I should be offered an upgrade price.Pure and simple.
>
> Plus, the site needs quite a lot of information, huge faq and more. It
> looks like it hasn't been changed in a while as you point out.


_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>

Re: Postgresql
Date: 05.08.09 01:15 (Wed, 5 Aug 2009 08:15:01 +0800)
From: Andy Dent

On 08/04/2009, at 8:46 PM, Trausti Thor Johannsson wrote:

> This plugin is way WAY to expensive.

For the value it adds, provided it continues to be maintained, I think
the pricing is reasonable.

HOWEVER

I would be a bit more assured if there was a statement about which
versions of RB and Postgres it has been tested against.
" requires REALbasic 2006r3, either Standard or Professional, and
PostgreSQL 7.4 or later." seems a bit old!

Out of interest, if it was a lot cheaper but required annual renewal,
would you regard that as more reasonable?

Speaking as a former database vendor who ended up open-sourcing the
product because my marketing skills didn't match my coding ones...
(OOFILE)

Andy Dent - www.aussiedesignedsoftware.com
Freelance Designer-Developer - C++, C#, Objective-C, Python,
REALbasic, Ruby, VB.Net

_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>

Re: Postgresql
Date: 04.08.09 13:56 (Tue, 4 Aug 2009 14:56:07 +0200)
From: Trausti Thor Johannsson
Christian,
After a bit of testing, doing
this SQLGlobalsMBS.SetPostgreSQLLibrary(GetFolderItem("/Library/PostgreSQL8/lib/libpg.a",
FolderItem.PathTypeShell))
Seems to work. Am I right ?

Trausti

On Tue, Aug 4, 2009 at 2:48 PM, Trausti Thor Johannsson <<email address removed>>wrote:

> Hi Christian,
> After a few minute testing I am not successful in connecting.
>
> I have tried to add /Library/PostgreSQL8/lib to LD_LIBRARY_PATH, even
> setting this env variable in code, no success.
> Then I try this :
>
> SQLGlobalsMBS.SetPostgreSQLLibrary(GetFolderItem("/Library/PostgreSQL8/lib/libpg.dylib",
> FolderItem.PathTypeShell))
>
> Unsuccessfully.
>
> What am I doing wrong ?
>
> Trausti
>
> On Tue, Aug 4, 2009 at 2:12 PM, Christian Schmitz <
> <email address removed>> wrote:
>
>>
>> Am 04.08.2009 um 14:02 schrieb Trausti Thor Johannsson:
>>
>> I know there is a $500 library out
>>> there for doing postgres but it looks shaky and the user case is not
>>> understandable, so I can't see if I pay per client or what. Any way, I
>>> would like to use the RS Postgres plugin.
>>>
>> Did you try the MBS REALbasic SQL Plugin?
>>
>> It loads the native postgre SQL library. And if you need a low level
>> function from that library, I could add it to the plugin.
>>
>> Greetings
>> Christian
>>
>> _______________________________________________
>> Unsubscribe or switch delivery mode:
>> <http://www.realsoftware.com/support/listmanager/>
>>
>> Search the archives:
>> <http://support.realsoftware.com/listarchives/lists.html>
>>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>

Re: Postgresql
Date: 04.08.09 13:48 (Tue, 4 Aug 2009 14:48:56 +0200)
From: Trausti Thor Johannsson
Hi Christian,
After a few minute testing I am not successful in connecting.

I have tried to add /Library/PostgreSQL8/lib to LD_LIBRARY_PATH, even
setting this env variable in code, no success.
Then I try this :

SQLGlobalsMBS.SetPostgreSQLLibrary(GetFolderItem("/Library/PostgreSQL8/lib/libpg.dylib",
FolderItem.PathTypeShell))

Unsuccessfully.

What am I doing wrong ?

Trausti

On Tue, Aug 4, 2009 at 2:12 PM, Christian Schmitz <
<email address removed>> wrote:

>
> Am 04.08.2009 um 14:02 schrieb Trausti Thor Johannsson:
>
> I know there is a $500 library out
>> there for doing postgres but it looks shaky and the user case is not
>> understandable, so I can't see if I pay per client or what. Any way, I
>> would like to use the RS Postgres plugin.
>>
> Did you try the MBS REALbasic SQL Plugin?
>
> It loads the native postgre SQL library. And if you need a low level
> function from that library, I could add it to the plugin.
>
> Greetings
> Christian
>
> _______________________________________________
> Unsubscribe or switch delivery mode:
> <http://www.realsoftware.com/support/listmanager/>
> Search the archives:
> <http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>

Re: Postgresql
Date: 04.08.09 13:46 (Tue, 4 Aug 2009 14:46:44 +0200)
From: Trausti Thor Johannsson
This plugin is way WAY to expensive.

Trausti

On Tue, Aug 4, 2009 at 2:27 PM, Jason Moehlman <<email address removed>>wrote:

>
> On Aug 4, 2009, at 8:02 AM, Trausti Thor Johannsson wrote:
>
> Like many, I am trying to move over to Postgres from Mysql. But I am
>> having
>> some problems.
>> Like :
>>
>> After I successfully connect to a server, and do an db.sqlselect("select *
>> from table") I get the error that the relations table does not exist.
>> Also
>> I need a way to be able to list tables, list other databases and more of
>> the
>> "\commands", but it seems I am not able. I know there is a $500 library
>> out
>> there for doing postgres but it looks shaky and the user case is not
>> understandable, so I can't see if I pay per client or what. Any way, I
>> would like to use the RS Postgres plugin.
>>
>> Anyone ?
>>
> Hi,
>
> I have used the Aliacta pgSQL4RB classes for years and they can't be beat.
> You can find them at:
>
> http://aliacta.com/products/pgsql4rb.htm
>
> I have not used the RB plugin, but as far as finding metadata about the DB
> the following work well. I believe your difficulty is just in the
> differences between the systems.
>
> "select * from pg_user" returns you a list of usernames and information on
> the server.
> "select * from pg_database" returns the databases available on the server.
> "select * from pg_tables" returns the tables available.
>
> The online documentation for PG is really good and has never failed to
> answer a question yet.
>
> Jason
>
> _______________________________________________
> Unsubscribe or switch delivery mode:
> <http://www.realsoftware.com/support/listmanager/>
> Search the archives:
> <http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>

Re: Postgresql
Date: 10.08.09 10:22 (Mon, 10 Aug 2009 11:22:27 +0200)
From: Jan-Ivar Mellingen
Hi.

I have been using both the RB PostgreSQL database plugin and the RB ODBC
plugin. They both work beautifully.
Personally I prefer the PostgreSQL database plugin, as I do not have to
install the correct version of the PostgreSQL ODBC drivers on the user's PC.

Perhaps you are using the wrong case in the tablename: PostgreSQL always
use lowercase unless you quote a tablename. This goes both for CREATE
TABLE and for SELECT.

If you create a table named TABLE1 with the statement "CREATE TABLE
TABLE1 ...." it will actually create a table with the name "table1". A
"SELECT * FROM TABLE1" will not find the table, you should use "SELECT
*FROM table1" instead.
If you quote the tablename when you create the table, like "CREATE TABLE
'TABLE1'..." it will retain the uppercase name and you will be able to
"SELECT ... FROM TABLE1".
Always use lowercase tablenames, or always quoute the tablename in both
CREATE TABLE and SELECT.

Hope this helps.

Regards
Jan-Ivar Mellingen

Trausti Thor Johannsson skrev:
> This plugin is way WAY to expensive.
>
> Trausti
>
> On Tue, Aug 4, 2009 at 2:27 PM, Jason Moehlman <<email address removed>>wrote:
>
>> On Aug 4, 2009, at 8:02 AM, Trausti Thor Johannsson wrote:
>>
>> Like many, I am trying to move over to Postgres from Mysql. But I am
>>
>>> having
>>> some problems.
>>> Like :
>>>
>>> After I successfully connect to a server, and do an db.sqlselect("select *
>>> from table") I get the error that the relations table does not exist.
>>> Also
>>> I need a way to be able to list tables, list other databases and more of
>>> the
>>> "\commands", but it seems I am not able. I know there is a $500 library
>>> out
>>> there for doing postgres but it looks shaky and the user case is not
>>> understandable, so I can't see if I pay per client or what. Any way, I
>>> would like to use the RS Postgres plugin.
>>>
>>> Anyone ?
>>>
>>>
>> Hi,
>>
>> I have used the Aliacta pgSQL4RB classes for years and they can't be beat.
>> You can find them at:
>>
>> http://aliacta.com/products/pgsql4rb.htm
>>
>> I have not used the RB plugin, but as far as finding metadata about the DB
>> the following work well. I believe your difficulty is just in the
>> differences between the systems.
>>
>> "select * from pg_user" returns you a list of usernames and information on
>> the server.
>> "select * from pg_database" returns the databases available on the server.
>> "select * from pg_tables" returns the tables available.
>>
>> The online documentation for PG is really good and has never failed to
>> answer a question yet.
>>
>> Jason
>>
>> _______________________________________________
>> Unsubscribe or switch delivery mode:
>> <http://www.realsoftware.com/support/listmanager/>
>>
>> Search the archives:
>> <http://support.realsoftware.com/listarchives/lists.html>
>>
> _______________________________________________
> Unsubscribe or switch delivery mode:
> <http://www.realsoftware.com/support/listmanager/>
> Search the archives:
> <http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>

Re: Postgresql
Date: 04.08.09 13:27 (Tue, 4 Aug 2009 08:27:57 -0400)
From: Jason Moehlman

On Aug 4, 2009, at 8:02 AM, Trausti Thor Johannsson wrote:

> Like many, I am trying to move over to Postgres from Mysql. But I
> am having
> some problems.
> Like :
>
> After I successfully connect to a server, and do an
> db.sqlselect("select *
> from table") I get the error that the relations table does not
> exist. Also
> I need a way to be able to list tables, list other databases and
> more of the
> "\commands", but it seems I am not able. I know there is a $500
> library out
> there for doing postgres but it looks shaky and the user case is not
> understandable, so I can't see if I pay per client or what. Any
> way, I
> would like to use the RS Postgres plugin.
>
> Anyone ?

Hi,

I have used the Aliacta pgSQL4RB classes for years and they can't be
beat. You can find them at:

http://aliacta.com/products/pgsql4rb.htm

I have not used the RB plugin, but as far as finding metadata about
the DB the following work well. I believe your difficulty is just in
the differences between the systems.

"select * from pg_user" returns you a list of usernames and
information on the server.
"select * from pg_database" returns the databases available on the
server.
"select * from pg_tables" returns the tables available.

The online documentation for PG is really good and has never failed to
answer a question yet.

Jason

_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>

Re: Postgresql
Date: 04.08.09 13:19 (Tue, 4 Aug 2009 14:19:37 +0200)
From: Trausti Thor Johannsson
I have to admit, I did not try that plugin. Will do that right now.

Trausti

On Tue, Aug 4, 2009 at 2:12 PM, Christian Schmitz <
<email address removed>> wrote:

>
> Am 04.08.2009 um 14:02 schrieb Trausti Thor Johannsson:
>
> I know there is a $500 library out
>> there for doing postgres but it looks shaky and the user case is not
>> understandable, so I can't see if I pay per client or what. Any way, I
>> would like to use the RS Postgres plugin.
>>
> Did you try the MBS REALbasic SQL Plugin?
>
> It loads the native postgre SQL library. And if you need a low level
> function from that library, I could add it to the plugin.
>
> Greetings
> Christian
>
> _______________________________________________
> Unsubscribe or switch delivery mode:
> <http://www.realsoftware.com/support/listmanager/>
> Search the archives:
> <http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>

Re: Postgresql
Date: 04.08.09 13:12 (Tue, 4 Aug 2009 14:12:52 +0200)
From: Christian Schmitz

Am 04.08.2009 um 14:02 schrieb Trausti Thor Johannsson:

> I know there is a $500 library out
> there for doing postgres but it looks shaky and the user case is not
> understandable, so I can't see if I pay per client or what. Any
> way, I
> would like to use the RS Postgres plugin.

Did you try the MBS REALbasic SQL Plugin?

It loads the native postgre SQL library. And if you need a low level
function from that library, I could add it to the plugin.

Greetings
Christian

_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>