Re: Re[2]: How do you organize your Perl applications?

Forgive me if this sounds pedantic, but how do you distinguish between DDL and SQL scripts? I only ask because I use a single directory (sql, although I like ddl as well) for this. Aren't they the same thing?

I also wonder if you have a sibling dml directory which has the definitions for a SQL phrasebook. To be honest, that idea only just occurred to me, but it does seems attractive. Something like:

+--sql
   +--dml  # database setup scripts and definitions here.
   +--ddl  # data files with phrasebook definitions here.
[download]

Comment on Re: Re[2]: How do you organize your Perl applications? Download Code

Replies are listed 'Best First'.
Re[4]: How do you organize your Perl applications? by PotPieMan (Hermit) on Apr 05, 2003 at 15:47 UTC
My team uses the `ddl` directory for schema definitions: tables, constraints, triggers, etc. The `sql` directory is used as storage for what might be called a phrasebook, though we haven't formally come to that concept yet. Definitely something to consider. :-) --PotPieMan	[reply] [d/l] [select]