/ - Repository - BIEN 3 - NCEAS Projects

Name	Size	Revision	Age	Author	Comment
_archive		1598	almost 13 years	Aaron Marcuse-Kubitza	Moved _archive/tapir2flatClient/trunk/client/ t...
bin		3071	over 12 years	Aaron Marcuse-Kubitza	cat_csv: Support overwriting the existing heade...
config		272	about 13 years	Aaron Marcuse-Kubitza	Moved bien_password to new config dir
inputs		3052	over 12 years	Aaron Marcuse-Kubitza	inputs/import.stats.xls: Updated for most recen...
lib		3068	over 12 years	Aaron Marcuse-Kubitza	sql.py: Added analyze()
mappings		2529	over 12 years	Aaron Marcuse-Kubitza	mappings/DwC2-VegBIEN.specimens.csv: Removed _t...
schemas		3070	over 12 years	Aaron Marcuse-Kubitza	schemas/vegbien.sql: Added location.location_co...
to_do		2547	over 12 years	Aaron Marcuse-Kubitza	to_do/timeline.doc: Updated to reflect the mont...
Makefile	10.2 KB	2983	over 12 years	Aaron Marcuse-Kubitza	main Makefile: Added explicit schemas/temp/rein...
README.TXT	2.76 KB	2976	over 12 years	Aaron Marcuse-Kubitza	README.TXT: Changed documentation to use make s...
map	978 Bytes	1979	over 12 years	Aaron Marcuse-Kubitza	root map: Fill in defaults for inputs from VegB...

#	Date	Author	Comment
3071	06/25/2012 09:35 PM	Aaron Marcuse-Kubitza	cat_csv: Support overwriting the existing header using a separate header file
3070	06/25/2012 08:49 PM	Aaron Marcuse-Kubitza	schemas/vegbien.sql: Added location.location_coords index to speed up large imports by providing an index for merge joins
3069	06/25/2012 08:43 PM	Aaron Marcuse-Kubitza	csv2db: Reanalyze table, so that query planner stats are up to date even though the table doesn't need to be vacuumed anymore
3068	06/25/2012 08:42 PM	Aaron Marcuse-Kubitza	sql.py: Added analyze()
3067	06/25/2012 08:11 PM	Aaron Marcuse-Kubitza	csv2db: Removed no longer needed table vacuum (cleanup_table() now avoids creating dead rows)
3066	06/25/2012 08:10 PM	Aaron Marcuse-Kubitza	sql.py: cleanup_table(): Use update()'s new in_place mode to avoid needing to vacuum the table
3065	06/25/2012 08:02 PM	Aaron Marcuse-Kubitza	sql.py: mk_update(): in_place: Support updating multiple columns at once
3064	06/25/2012 07:44 PM	Aaron Marcuse-Kubitza	sql.py: update() calls: Use in_place where possible to avoid creating dead rows, which bloats table size
3063	06/25/2012 07:37 PM	Aaron Marcuse-Kubitza	sql.py: DbConn.col_info(): Support user-defined types
3062	06/25/2012 07:33 PM	Aaron Marcuse-Kubitza	sql_gen.py: Added Nullif

root @ 3071