U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » PostgreSQL Support Classes [Experimental]

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Re: PostgreSQL Support Classes [Experimental] [message #9082 is a reply to message #9080]

Mon, 16 April 2007 22:42

unodgs
Messages: 1366
Registered: November 2005
Location: Poland

Ultimate Contributor

It looks fine to me! Maybe except S letter at the end sugessting multiple primary keys. But if you could add it to sql schema do it please!

Report message to a moderator

Re: PostgreSQL Support Classes [Experimental] [message #9084 is a reply to message #9082]

Tue, 17 April 2007 00:01

mirek
Messages: 13975
Registered: November 2005

Ultimate Member

unodgs wrote on Mon, 16 April 2007 16:42

It looks fine to me! Maybe except S letter at the end sugessting multiple primary keys. But if you could add it to sql schema do it please!

'S' to avoid ambiguity with PRIMARY_KEY.

Also, this is RDBMS specific (so it would have to be added for each RDBMS).

Mirek

Report message to a moderator

Re: PostgreSQL Support Classes [Experimental] [message #9095 is a reply to message #9037]

Tue, 17 April 2007 09:08

jibe
Messages: 294
Registered: February 2007
Location: France

Experienced Member

Hi zsolt,

Thanks for your reply ! Maybe I worry only because I'm just discovering UPP, and have no experience with it !

To go back to the topic :

luzr wrote on Mon, 16 April 2007 20:37

PRIMARY_KEYS("KEY1, KEY2, KEY3")

does not sound that bad...

Yes, it looks like very much what I use with Firebird, and is also common with some other databases...

unodgs wrote on Mon, 16 April 2007 22:42

It looks fine to me! Maybe except S letter at the end sugessting multiple primary keys. But if you could add it to sql schema do it please!

Yes, I think also that this S is not so usefull... Why not

PRIMARY KEY ("UNIQUE_KEY")
or
PRIMARY KEY ("KEY1, KEY2, ...")
It seems logical, and I don't see any ambiguity ? But maybe I don't know enough yet about all consequences in upp...

Report message to a moderator

Re: PostgreSQL Support Classes [Experimental] [message #9100 is a reply to message #9095]

Tue, 17 April 2007 11:53

mirek
Messages: 13975
Registered: November 2005

Ultimate Member

jibe wrote on Tue, 17 April 2007 03:08

PRIMARY KEY ("KEY1, KEY2, ...")
It seems logical, and I don't see any ambiguity ? But maybe I don't know enough yet about all consequences in upp...

There is already macro PRIMARY_KEY for single column primary keys. Well, in theory, it could be replaced by this new macro, but

a) as single-column primary keys are so much widely use, having it as special case is a good idea

b) would break all of my commercial stuff...

Mirek

Report message to a moderator

Re: PostgreSQL Support Classes [Experimental] [message #9115 is a reply to message #9100]

Wed, 18 April 2007 08:57

jibe
Messages: 294
Registered: February 2007
Location: France

Experienced Member

luzr wrote on Tue, 17 April 2007 11:53

a) as single-column primary keys are so much widely use, having it as special case is a good idea

Yes, maybe... But I don't see the problem if the same macro is used the same way for one or several colomn keys...
Seems a lot easier if there is no difference ?

luzr wrote on Tue, 17 April 2007 11:53

b) would break all of my commercial stuff...

Yes, this is a good reason ! Wink

Report message to a moderator

Re: PostgreSQL Support Classes [Experimental] [message #15619 is a reply to message #9037]

Thu, 01 May 2008 16:53

tojocky
Messages: 607
Registered: April 2008
Location: UK

Contributor

I have an error! Sorry for my incompetence but I need help!

c:\myapps\postgresql\PostgreSQL.h(7) : fatal error C1083: Cannot open include file: 'libpq-fe.h': No such file or directory

Thanks a lot!

Report message to a moderator

Re: PostgreSQL Support Classes [Experimental] [message #15633 is a reply to message #15619]

Thu, 01 May 2008 22:55

mirek
Messages: 13975
Registered: November 2005

Ultimate Member

tojocky wrote on Thu, 01 May 2008 10:53

I have an error! Sorry for my incompetence but I need help!

c:\myapps\postgresql\PostgreSQL.h(7) : fatal error C1083: Cannot open include file: 'libpq-fe.h': No such file or directory

Thanks a lot!

You are missing the correct include path (and quite likely library path, that would hit later...) in build method.

You need to have PostgreSQL installed and you need to put proper paths into the build method (in Setup menu) you are using.

Mirek

Report message to a moderator

Re: PostgreSQL Support Classes [Experimental] [message #15675 is a reply to message #15633]

Sun, 04 May 2008 10:15

tojocky
Messages: 607
Registered: April 2008
Location: UK

Contributor

Thank you! its worked! I will testing in continuation!
I have a situation: I need to make a server and client application. that in code i need decide where it will execute (server or client). Only application server can communicate with DB server, but client is connected with server. Server and client appliction need becouse:
1. The client station can/may be not so performace as server station.
2. Connection from DB server and application server can be more speedily.
If I wrong tell me please how is correct! How I can create this?

Thank you!
John!

P.S. The ultimate ++ is the most impression me!

Report message to a moderator

Re: PostgreSQL Support Classes [Experimental] [message #15677 is a reply to message #15675]

Sun, 04 May 2008 11:24

zsolt
Messages: 697
Registered: December 2005
Location: Budapest, Hungary

Contributor

I think, if you do not have more than 2000 clients, use simple client-server architecture:
- SQL database on server
- SQL clients on clients
It is not a good idea to create an over-complicated system without any reason.
Additionally, U++ doesn't implement muli-tier techhologies currently (AFAIK).

Report message to a moderator

Re: PostgreSQL Support Classes [Experimental] [message #15712 is a reply to message #15677]

Mon, 05 May 2008 17:12

tojocky
Messages: 607
Registered: April 2008
Location: UK

Contributor

On Application server I will execute massive operations with data! and client station can be not so performance. About count of clients will be more 100 (not 2000)!
Thank you for advice, Zsolt!

Report message to a moderator

Re: PostgreSQL Support Classes [Experimental] [message #15719 is a reply to message #9037]

Mon, 05 May 2008 20:59

mr_ped
Messages: 825
Registered: November 2005
Location: Czech Republic - Praha

Experienced Contributor

Massive operations with data = simulation of A-bomb or 3D game or HD video encoding or what? Smile

Unless it is top secret, I would be interested what is so "massive" that ordinary 1GHz CPU is not enough to solve it within 0.1-0.5s.

Report message to a moderator

Re: PostgreSQL Support Classes [Experimental] [message #15720 is a reply to message #15719]

Mon, 05 May 2008 22:14

mirek
Messages: 13975
Registered: November 2005

Ultimate Member

mr_ped wrote on Mon, 05 May 2008 14:59

Massive operations with data = simulation of A-bomb or 3D game or HD video encoding or what? Smile

Unless it is top secret, I would be interested what is so "massive" that ordinary 1GHz CPU is not enough to solve it within 0.1-0.5s.

Uhmps, while I think where you are heading, I have a lot of selects in my apps that cannot be optimized any further way and take more than 10s on 2Ghz machine Smile

Anyway, this of course is irrelevant here.

Mirek

Report message to a moderator