[epclust.git] / data / curves_to_db / README

0] Precondition: current folder, containing init_db.sql and curves2db.R
   must be readable by the postgres user (some other weird restrictions ...)

1] Initialization:
  a) log in as postgres user:
	      sudo -i -u postgres
	b) launch PostgreSQL shell:
	      psql
	c) execute init script:
	      \i /path/to/init_db.sql

2] Launch DB-filling script:
  a) check/tune parameters at the beginning of curves2db.R
	b) run the script

=====

WARNING: very slow for large datasets

read_db.R: example usage to read curves from DB
Commit	Line	Data
b7cd987d BA	1	0] Precondition: current folder, containing init_db.sql and curves2db.R
	2	must be readable by the postgres user (some other weird restrictions ...)
	3
	4	1] Initialization:
	5	a) log in as postgres user:
	6	sudo -i -u postgres
	7	b) launch PostgreSQL shell:
	8	psql
	9	c) execute init script:
	10	\i /path/to/init_db.sql
	11
	12	2] Launch DB-filling script:
	13	a) check/tune parameters at the beginning of curves2db.R
	14	b) run the script
	15
	16	=====
	17
	18	WARNING: very slow for large datasets
	19
	20	read_db.R: example usage to read curves from DB