Perl Monk, Perl Meditation | |
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
Developing large client/server database GUI programs with Powerbuilder on NT4WS Hm. I can't really help you with that one, since I don't know Powerbuilder. For me, the main pain with proprietary builder tools is always that the editors they have suck so unbelievably. Therefore, I have had to come up with a standard method to circumvent this. Basically, it works like this:
Writing zillions of lines of SQL (using the RapidSQL Editor) for stored procedures using a Sybase ASE database See procedure from above. Especially the part on the versioning system. CVS works great with Windows Clients, too. I am not so much in favor of generating SQL statements with GUI tools. Usually, I am much faster typing them in directly. If it comes down to generating SQL for pre-existing objects (e.g., from GUI specifications), then of course a generator is cool. See Chapter 17 (Template Driven Code Generation) of Advanced Perl Programming. But for real SQL programming, a nice set of editor macros tailored to your needs is much more efficient then a generator, IMHO. Routinely having to diff our DEV and TST directories to see which procs we've made changes to on the DEV side that have to be copied to TST and then also compiled on the test database (this one, of course, screams for a program that can manage all of that) AHHHH! Horrors! Use CVS! This is exactly what CVS handles very well. And, use automated build procedures (Makefiles, Ant, your own scripts, whatever you want) to rebuild any system state. For me, make (or rather, nmake on Win32 systems) is a real saver. It is easy to program (I think), it is widely available, and coupled with your special scripts (e.g., for a database rebuild) can do almost everything. Another thing I found very useful is including a link to the following DOS batch file in the send-to folder (this saves the content of a file in the clipboard):
Example code for editor macro saving whole buffer/file to clipboard: Emacs:
vi (gvim):
Christian Lemburg In reply to Re: Using Perl with Proprietary Development Tools
by clemburg
|
|