Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » Fields of the same name in diff tables
Re: Fields of the same name in diff tables [message #21722 is a reply to message #21719] Tue, 02 June 2009 14:27 Go to previous messageGo to previous message
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
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Weird Date bevaviour in Sqlite
Next Topic: SqlLite3 crashes on Fetch()
Goto Forum:
  


Current Time: Thu Jan 28 15:48:34 CET 2021

Total time taken to generate the page: 0.00830 seconds