> So do you script everything and do nothing using the GUI? Not initially, the design of the tables and all that I do in the GUI, but once all done I try to do as much as I can with scripts, which you can put in a source control application.
> Have you ever tried building the first version of your > database in Enterprise Manager, then exporting the SQL script > and making minor adjustments to it there? That's how I do it ;-) > I'm really interested in getting the DB to do more work for > me, but am just wondering about the best way to approach it... > > Currently I use the database for very little except storing > the data... all the logic and validity checking is done in > the application. I know > should be using it for more, which is why I'm learning more > about it now. I still suggest to have it to do everything but the validity checking, I see that as unneeded traffic to the database. > Its interesting when you talk to people who manage databases > for big companies... for them, the database is the where > every single bit of processing takes place, and any > applications that access the DB are extremely thin. > > In a way that can make your development more portable, I mean > list all the major enterprise RDBMS's out there.. I can think > of MS-SQL, Oracle, Postgres, Informix, probably a few more... > now think of all the ways you could be asked by a client to > access that data: Cold Fusion, ASP, ASP.NET, PHP, Perl, MS > Access front end, Flash, etc..., you get the idea? From what > I can tell there are far more choices at the Presentation > Logic tier than at the Data Access tier.. talking in a rough > approximation of the N-tier application architecture. > Wouldn't it make more sense to do all the gutsy processing at > the level that is less likely to change? Also, if you develop > your database using ANSI standards, it should translate > pretty well between vendors... Hmm, you don't get to take advantage of the RDBMS if you stick to ANSI compliant SQL, I don't think you'll find an application anywhere that is 100% ANSI compliant. OK in the end you won't be able to move the application from database to database, but I don't believe in portability between diffirent platforms and rdbms's, portability between servers and portability between development phases yeah! My 2c very early in the morning! --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
