/ - Repository - BIEN 3 - NCEAS Projects

Name	Size	Revision	Age	Author	Comment
_archive		1598	over 12 years	Aaron Marcuse-Kubitza	Moved _archive/tapir2flatClient/trunk/client/ t...
bin		3069	about 12 years	Aaron Marcuse-Kubitza	csv2db: Reanalyze table, so that query planner ...
config		272	over 12 years	Aaron Marcuse-Kubitza	Moved bien_password to new config dir
inputs		3052	about 12 years	Aaron Marcuse-Kubitza	inputs/import.stats.xls: Updated for most recen...
lib		3068	about 12 years	Aaron Marcuse-Kubitza	sql.py: Added analyze()
mappings		2529	about 12 years	Aaron Marcuse-Kubitza	mappings/DwC2-VegBIEN.specimens.csv: Removed _t...
schemas		2980	about 12 years	Aaron Marcuse-Kubitza	Added temp schema to store intermediate tables ...
to_do		2547	about 12 years	Aaron Marcuse-Kubitza	to_do/timeline.doc: Updated to reflect the mont...
Makefile	10.2 KB	2983	about 12 years	Aaron Marcuse-Kubitza	main Makefile: Added explicit schemas/temp/rein...
README.TXT	2.76 KB	2976	about 12 years	Aaron Marcuse-Kubitza	README.TXT: Changed documentation to use make s...
map	978 Bytes	1979	about 12 years	Aaron Marcuse-Kubitza	root map: Fill in defaults for inputs from VegB...

#	Date	Author	Comment
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
3061	06/25/2012 07:27 PM	Aaron Marcuse-Kubitza	sql_gen.py: Added Coalesce class and use it in EnsureNotNull
3060	06/25/2012 07:15 PM	Aaron Marcuse-Kubitza	sql_gen.py: Added coalesce and use it in EnsureNotNull

root @ 3069