U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

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

Return to the default flat view

Create a new topic

Submit Reply

Re: PostgreSQL Support Classes [Experimental] [message #9056 is a reply to message #9055]

Sun, 15 April 2007 21:04

zsolt is currently offline

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

Contributor

My original idea was to have a database independent app.
So I created this SERIAL field to generate a serial id.

I put SERIAL, BIGSERIAL and CLOB into my sqlite schema also:

#define SERIAL(x)                  COLUMN("integer primary key autoincrement", int64, x, 0, 0) //int is not enough, as it is unsigned
#define SERIAL_ARRAY(x, items)     COLUMN_ARRAY("integer primary key autoincrement", int64, x, 0, 0, items)
#define SERIAL_(x)                 COLUMN_("integer primary key autoincrement", int64, x, 0, 0)
#define SERIAL_ARRAY_(x, items)    COLUMN_ARRAY_("integer primary key autoincrement", int64, x, 0, 0, items)

#define BIGSERIAL(x)               COLUMN("integer primary key autoincrement", int64, x, 0, 0)
#define BIGSERIAL_ARRAY(x, items)  COLUMN_ARRAY("integer primary key autoincrement", int64, x, 0, 0, items)
#define BIGSERIAL_(x)              COLUMN_("integer primary key autoincrement", int64, x, 0, 0)
#define BIGSERIAL_ARRAY_(x, items) COLUMN_ARRAY_("integer primary key autoincrement", int64, x, 0, 0, items)

#define CLOB(x)                    COLUMN("text", String, x, 0, 0)
#define CLOB_(x)                   COLUMN_("text", String, x, 0, 0)

I don't know if this is correct or not, but we have to find some common schema requirement for all kinds of databases to achieve portability.

Report message to a moderator

Send a private message to this user

[Message index]

		PostgreSQL Support Classes [Experimental] By: zsolt on Sun, 15 April 2007 00:28
		Re: PostgreSQL Support Classes [Experimental] By: unodgs on Sun, 15 April 2007 09:11
		Re: PostgreSQL Support Classes [Experimental] By: fallingdutch on Sun, 15 April 2007 09:19
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Sun, 15 April 2007 16:02
		Re: PostgreSQL Support Classes [Experimental] By: zsolt on Sun, 15 April 2007 17:44
		Re: PostgreSQL Support Classes [Experimental] By: unodgs on Sun, 15 April 2007 20:25
		Re: PostgreSQL Support Classes [Experimental] By: unodgs on Sun, 15 April 2007 20:49
		Re: PostgreSQL Support Classes [Experimental] By: zsolt on Sun, 15 April 2007 20:59
		Re: PostgreSQL Support Classes [Experimental] By: zsolt on Sun, 15 April 2007 21:04
		Re: PostgreSQL Support Classes [Experimental] By: zsolt on Sun, 15 April 2007 21:18
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Mon, 16 April 2007 09:20
		Re: PostgreSQL Support Classes [Experimental] By: unodgs on Mon, 16 April 2007 10:22
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Mon, 16 April 2007 10:37
		Re: PostgreSQL Support Classes [Experimental] By: unodgs on Mon, 16 April 2007 12:13
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Mon, 16 April 2007 19:44
		Re: PostgreSQL Support Classes [Experimental] By: unodgs on Mon, 16 April 2007 20:11
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Mon, 16 April 2007 20:37
		Re: PostgreSQL Support Classes [Experimental] By: unodgs on Mon, 16 April 2007 22:42
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Tue, 17 April 2007 00:01
		Re: PostgreSQL Support Classes [Experimental] By: zsolt on Mon, 16 April 2007 19:43
		Re: PostgreSQL Support Classes [Experimental] By: jibe on Mon, 16 April 2007 18:46
		Re: PostgreSQL Support Classes [Experimental] By: zsolt on Mon, 16 April 2007 19:57
		Re: PostgreSQL Support Classes [Experimental] By: jibe on Tue, 17 April 2007 09:08
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Tue, 17 April 2007 11:53
		Re: PostgreSQL Support Classes [Experimental] By: jibe on Wed, 18 April 2007 08:57
		Re: PostgreSQL Support Classes [Experimental] By: tojocky on Thu, 01 May 2008 16:53
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Thu, 01 May 2008 22:55
		Re: PostgreSQL Support Classes [Experimental] By: tojocky on Sun, 04 May 2008 10:15
		Re: PostgreSQL Support Classes [Experimental] By: zsolt on Sun, 04 May 2008 11:24
		Re: PostgreSQL Support Classes [Experimental] By: tojocky on Mon, 05 May 2008 17:12
		Re: PostgreSQL Support Classes [Experimental] By: mr_ped on Mon, 05 May 2008 20:59
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Mon, 05 May 2008 22:14
		Re: PostgreSQL Support Classes [Experimental] By: tojocky on Tue, 06 May 2008 17:24
		Re: PostgreSQL Support Classes [Experimental] By: mirek on Tue, 06 May 2008 19:45

Previous Topic:	Catch errors with Sql.Execute
Next Topic:	Newbie help with PostgreSQL example

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Tue May 14 00:37:28 CEST 2024

Total time taken to generate the page: 0.02082 seconds