Feedback

[sckott]

hey @Alectoria @EDiLD

moving SQL stuff here to this new pkg - because it's just too hard to integrate SQL stuff with such a big package as taxize

This pkg at least right now won't try to replicate the API based calls in taxize, but rather helps the user download data, load into a SQL database, then create an src class that can be plugged directly into dplyr for easy manipulation

let me know what you think

• We do have some SQL queries for ITIS so we can replicate some of the API methods they provide, but not all
• Theplantlist doesn't have a SQL db, I just made one from flat files
• COL hasn't given me their SQL queries
• NCBI isn't in here yet, they're DB setup is painful

[sckott]

also paging for feedback/thoughts, esp. if you'd use this (no worries if you'd never user this setup)

@zachary-foster @ibartomeus @johnbaums @jimmyodonnell @fmichonneau @pmarchand1 @ljvillanueva @dlebauer

[ibartomeus]

Didn't know of its existence, but looks useful for heavy queries!

[sckott]

@ibartomeus just started it :) but on taxize issues for a few years :( https://github.com/ropensci/taxize/issues?q=label%3Asql+is%3Aclosed

[zachary-foster]

Hi @sckott, I am not too good at SQL and have not used any SQL features in taxize, so I might not be the best tester for this.

[sckott]

@zachary-foster okay, no worries, hopefully this pkg (eventually) will make it easy enough for those that don't know SQL, but yeah users still need to install a SQL database, though that gives me an idea - possibly use a in memory SQLite storage engine as an option...hmmmm

[johnbaums]

Sounds useful, and I like the idea of sqlite.

[sckott]

@johnbaums cool, if you have a chance to try it, let me know what you think