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 » Fields of the same name in diff tables

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: Fields of the same name in diff tables [message #21722 is a reply to message #21719]

Tue, 02 June 2009 14:27

jeremy_c is currently offline

jeremy_c
Messages: 175
Registered: August 2007
Location: Ohio, USA

Experienced Member

I like the idea of Ultimate++ generating table structures for me, I just think it needs a little more work and a little more documentation. Now, I am a database programmer by trade, so when it comes to an enterprise application, I doubt that UPP can ever keep up with what can be accomplished using the database, for instance, all sorts of trigger functions and other server side programming. For desktop applications w/simple databases, however, it's great.

Now, about managing SQL independent. What I do is I always have a directory structure such as:

project/docs
project/src
project/sql
project/sql/0001.sql
project/sql/0001_r.sql
project/sql/0002.sql
project/sql/0002_r.sql

0001.sql is the first version of my database schema. 0002.sql is the create/alter statements necessary to bring 0001.sql (current at the time) to my new version. So, if I were starting a new project, I could psql thedb < 0001.sql ... psql thedb < 0002.sql, etc... Now, 0001_r.sql and 0002_r.sql are "Revert" scripts which will undo the changes. I don't always make those but it's a good idea.

Jeremy

Report message to a moderator

Send a private message to this user

[Message index]

		Fields of the same name in diff tables By: jeremy_c on Mon, 01 June 2009 02:43
		Re: Fields of the same name in diff tables By: jeremy_c on Mon, 01 June 2009 05:27
		Re: Fields of the same name in diff tables By: mirek on Mon, 01 June 2009 08:41
		Re: Fields of the same name in diff tables By: jeremy_c on Mon, 01 June 2009 16:23
		Re: Fields of the same name in diff tables By: mirek on Mon, 01 June 2009 17:34
		Re: Fields of the same name in diff tables By: jeremy_c on Mon, 01 June 2009 20:34
		Re: Fields of the same name in diff tables By: mirek on Mon, 01 June 2009 23:09
		Re: Fields of the same name in diff tables By: jeremy_c on Mon, 01 June 2009 23:17
		Re: Fields of the same name in diff tables By: mirek on Mon, 01 June 2009 23:30
		Re: Fields of the same name in diff tables By: mirek on Mon, 01 June 2009 23:36
		Re: Fields of the same name in diff tables By: jeremy_c on Mon, 01 June 2009 23:58
		Re: Fields of the same name in diff tables By: andrei_natanael on Tue, 02 June 2009 07:36
		Re: Fields of the same name in diff tables By: jeremy_c on Tue, 02 June 2009 14:27
		Re: Fields of the same name in diff tables By: mirek on Tue, 02 June 2009 14:50
		Re: Fields of the same name in diff tables By: mirek on Tue, 02 June 2009 14:52
		Re: Fields of the same name in diff tables By: lectus on Thu, 20 December 2012 19:20
		Re: Fields of the same name in diff tables By: mirek on Sun, 23 December 2012 10:17
		Re: Fields of the same name in diff tables By: mirek on Tue, 02 June 2009 14:47
		Re: Fields of the same name in diff tables By: mr_ped on Tue, 02 June 2009 10:33

Previous Topic:	Weird Date bevaviour in Sqlite
Next Topic:	SqlLite3 crashes on Fetch()

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Thu Apr 18 03:51:02 CEST 2024

Total time taken to generate the page: 0.01717 seconds