Dave Bunten

icon indicating an email [email protected]

icon company University of Colorado Anschutz icon location Denver, CO icon location Research Software Engineer with the Department of Biomedical Informatics at the University of Colorado Anschutz Medical Campus

Results 24 comments of Dave Bunten

Performance issues using ORDER BY and LIMIT with large OFFSETs on wide tables

@msf best wishes on your upcoming talk at DuckCon 5! Just in case, wanted to share along a workaround which @Teggy very helpfully mentioned through the DuckDB Discord. If using...

Food Ontology Import Issue

I came across this issue when trying to run the full RTX-KG2 workflow. In addition or perhaps alongside the changes mentioned regarding a pickled version of the original data, would...

Add retry capabilities for `kg2_util.download_file_if_not_exist_locally` to avoid systemic failures

Sounds good, thank you as well @saramsey ! If it'd be helpful, may I submit a PR towards this cause? I can also understand if you wouldn't suggest it.

Add data description and provenance for "SMPDB PubMed annotations" (`SMPDB_pubmed_IDs.csv`)

Thank you @saramsey !