<commit_before>CSB-DB LIFE CYCLE
-----------------
$Id: dev-cycle.txt,v 1.1 2004/01/08 02:18:09 rkh Exp $

                    +<----<----<----<---- PD <----<----<---<+
                    v                                       ^
 	phase:     		development   -DS-> staging       -SP->	production
    database:  		csb-dev             csb-stage           csb
----------------|-------------------|-------------------|-------------------|
Database:     	|					|					|					|
  schema      	|	RW				|	RO				|	RO				|
              	|					|					|					|
  data        	|	RW				|	RW				|	RO				|
              	|					|					|					|
  backups     	|	nightly?		|	none			|	none			|
              	|	semi-weekly?	|					|					|
              	|					|					|					|
----------------|-------------------|-------------------|-------------------|
Software:		|					|					|					|
  cvs tag		|	dev-X.Y			|	stage-X.Y		|	rel-X.Y			|
  				|					|					|					|
  API testing 	|	some			|	most			|					|
              	|					|					|					|
  command line	|	some			|	most			|					|
  tool testing	|					|					|					|
  				|					|					|					|
  web interface	|	some			|	most			|					|
  				|					|					|					|
----------------|-------------------|-------------------|-------------------|
								


in csb-dev:
- schema changes are made and tested
- data may be loaded (but may be dropped at will if csb-dev needs to be reverted)

DS: development-to-staging process
- csb-dev is RENAMEd to csb-stage

in csb-stage:<commit_msg>* added port and path info<commit_after>CSB-DB LIFE CYCLE
-----------------
$Id: dev-cycle.txt,v 1.2 2004/01/09 19:24:48 rkh Exp $

 	phase:     	|	development     |   staging         |  	production
----------------|-------------------|-------------------|-------------------|
Database:     	|					|					|					|
  db name	  	|	csb-dev         |   csb-stage       |   csb				|
              	|					|					|					|
  schema      	|	RW				|	RO				|	RO				|
              	|					|					|					|
  data        	|	RW				|	RW				|	RO				|
              	|					|					|					|
  backups     	|	nightly?		|	none			|	none			|
              	|	semi-weekly?	|					|					|
              	|					|					|					|
----------------|-------------------|-------------------|-------------------|
Software:		|					|					|					|
  cvs tag		|	dev-X.Y			|	stage-X.Y		|	rel-X.Y			|
  				|					|					|					|
  API		 	|	dev + test		|	test only		|					|
    path*	  	|	user dirs		|	?				|	site_perl		|
              	|					|					|					|
  CL tools		|	dev + test		|	test only		|					|
  				|					|					|					|
  web interface	|	dev + test		|	test only		|					|
    path*	 	|	htdocs-dev		|	htdocs-stage	|	htdocs-prod		|
    port     	|	8080			|	8040			|	8000			|
              	|					|					|					|
----------------|-------------------|-------------------|-------------------|
Cycle:	     	|	development   -DS-> staging       -SP->	production      |
				|	^										|				|
                |   |                                       v				|
                |   +<----<----<----<--- PD --<----<----<---+				|
----------------|-------------------|-------------------|-------------------|
								
* paths:
The perl API is checked out in /apps/compbio/lib/perl5/site_perl/Unison .
The web path is /usr/local/apache2/htdocs-* .
The web pages use a web-only perl5 directory (see Unison/WWW.pm) if it
exists.  Reece usually makes this a symlink to his Unison perl5 dev tree
for web development, and uses the /apps/compbio/ perl default for
production.


in csb-dev:
- schema changes are made and tested
- data may be loaded (but may be dropped at will if csb-dev needs to be reverted)

DS: development-to-staging process
- csb-dev is RENAMEd to csb-stage

in csb-stage:
{'fraction_non_alphanumeric': 0.2582639075517334, 'fraction_numerical': 0.012899758129535071, 'mean_word_length': 0.7384399813171415, 'pattern_counts': {'":': 0, '<': 18, '<?xml version=': 0, '>': 7, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 4, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5957704', 'n_tokens_mistral': 1687, 'n_tokens_neox': 1306, 'n_words': 254}