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

in reply to Re[2]: How do you organize your Perl applications?
in thread 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]

In Section Seekers of Perl Wisdom