pins
pins keeps adding a storage backend per release while retiring its original API
Comparison · Analytics
bigrquery vs dtplyr
A side-by-side editorial comparison of bigrquery and dtplyr — release velocity, themes, recent moves, and the top alternatives to consider.
Shared themes:performance
bigrquery vs dtplyr: at a glance
What is bigrquery?
bigrquery went MIT, then handed its slowest path to the BigQuery Storage API
bigrquery is the R client for Google BigQuery. Version 1.5.0 was the structural release - MIT relicensing, removal of the long-deprecated non-bq_ API, and a move to the second edition of the dbplyr interface with a much fuller DBI implementation. Since then the work has been about the two things that hurt in practice: download throughput and cost visibility.
What is dtplyr?
dtplyr stopped hijacking data.table objects and became an opt-in translator
dtplyr converts dplyr and tidyr code into data.table syntax, and 1.3.0 redrew its boundary: verbs no longer dispatch to dtplyr translations just because dtplyr is loaded, so lazy_dt() has to be called explicitly. Since then the work has been translation coverage — reframe(), case_match(), consecutive_id() — plus a long tail of correctness fixes in grouping and .by.
bigrquery vs dtplyr: editorial side-by-side
bigrquery
0.0ANALYTICS
bigrquery went MIT, then handed its slowest path to the BigQuery Storage API
◆ Current state
bigrquery is the R client for Google BigQuery. Version 1.5.0 was the structural release - MIT relicensing, removal of the long-deprecated non-bq_ API, and a move to the second edition of the dbplyr interface with a much fuller DBI implementation. Since then the work has been about the two things that hurt in practice: download throughput and cost visibility.
◆ Where it's heading
The package is settling into being a well-behaved DBI and dbplyr backend rather than a bespoke API wrapper, and offloading its hard parts to specialist packages - clock for date parsing, bigrquerystorage for bulk downloads, gargle for auth. The recent additions read like responses to production use: job labels for cost allocation, microsecond timestamp precision, a configurable quiet option.
◆ Prediction
Expect bigrquerystorage to move from optional to expected for large reads, and further work on upload fidelity, where digits and timezone handling have needed repeated correction.
dtplyr
0.0ANALYTICS
dtplyr stopped hijacking data.table objects and became an opt-in translator
◆ Current state
dtplyr converts dplyr and tidyr code into data.table syntax, and 1.3.0 redrew its boundary: verbs no longer dispatch to dtplyr translations just because dtplyr is loaded, so lazy_dt() has to be called explicitly. Since then the work has been translation coverage — reframe(), case_match(), consecutive_id() — plus a long tail of correctness fixes in grouping and .by.
◆ Where it's heading
The package is trailing dplyr's own feature releases rather than leading them, adding each new verb once it settles upstream. Performance work is targeted at specific verbs where data.table has a faster primitive: setorder() for arrange(), reference drops for select(), rleid() for consecutive_id(). Release cadence has thinned considerably since 2023.
◆ Prediction
Expect further one-for-one translations as dplyr adds verbs, and continued fixes around .by and non-standard column names; the entries show no sign of a broader redesign.
Alternatives to bigrquery and dtplyr
Other Analytics products tracked by Sparkpulse, ranked by recent ship velocity. Each card links to a full editorial trajectory and lets you pivot into a head-to-head comparison with either bigrquery or dtplyr.
tsibble
tsibble shipped one release in five and a half years - the data structure is finished
yardstick
yardstick made fairness metrics a first-class part of tidymodels evaluation
tune
tune extends tuning past the model itself to postprocessors, and adds a second parallel backend
leaflet
leaflet relicensed to MIT and finished migrating off R's retired spatial stack
ggpubr
ggpubr reached 1.0.0 with p-value formatting presets for specific journals
See all bigrquery alternatives → · See all dtplyr alternatives →
Recent activity from bigrquery and dtplyr
Latest ship moves from both products, interleaved chronologically. ⚡ = editorial spark.
- 3mo agobigrqueryJob labels for cost allocation; microsecond upload precision
- 11mo agodtplyrreframe(), case_match() and consecutive_id() gain translations
- 11mo agobigrqueryUses bigrquerystorage automatically for large downloads
- 11mo agobigrqueryDevelopment snapshot advancing 1.4.0 deprecations
- 2y agobigrqueryForward compatibility with an upcoming dbplyr release
- 2y agobigrqueryMIT relicensing, dbplyr second edition, full DBI support ⚡
- 3y agobigrquerySyncs with gargle's OAuth client rename
- 3y agodtplyrcrayon dependency dropped
- 3y agodtplyrVerbs stop auto-dispatching; lazy_dt() now required ⚡
- 3y agodtplyrdtplyr 1.2.2
- 4y agodtplyrdtplyr 1.2.1
- 4y agodtplyrEight tidyr verbs gain data.table translations
Frequently asked questions
What is the difference between bigrquery and dtplyr?
Both compete on the same themes — performance — within Analytics. bigrquery and dtplyr are shipping at a similar cadence (velocity 0.0 vs 0.0, both within Sparkpulse's "active" band). See the at-a-glance table above for a side-by-side breakdown of velocity, recent sparks, and editorial themes.
Is bigrquery better than dtplyr?
Sparkpulse doesn't pick a winner — we score release velocity, not feature parity. bigrquery and dtplyr are shipping at a similar cadence (velocity 0.0 vs 0.0, both within Sparkpulse's "active" band). For your specific use case, the alternatives sections above list other Analytics products to evaluate alongside.
What are the best alternatives to bigrquery?
Top bigrquery alternatives in Analytics are ranked by recent ship velocity. Browse the "bigrquery alternatives" section above for the current picks, or visit /alternatives/bigrquery for the full list with editorial commentary on each.
What are the best alternatives to dtplyr?
Top dtplyr alternatives in Analytics are ranked by recent ship velocity. Browse the "dtplyr alternatives" section above for the current picks, or visit /alternatives/dtplyr for the full list with editorial commentary on each.