animation
Contribution-driven maintenance on a package whose last structural change was magick support.
Comparison · Analytics
bigrquery vs lubridate
A side-by-side editorial comparison of bigrquery and lubridate — release velocity, themes, recent moves, and the top alternatives to consider.
bigrquery vs lubridate: 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 lubridate?
lubridate ships parsing fixes, timezone-data churn, and a long-overdue MIT relicense.
lubridate is R's standard package for date-time manipulation. Recent releases are dominated by parsing correctness — partial datetimes, multiple format strings, month names colliding with the %a format — and by adapting to timezone database changes in R-devel. Version 1.9.5 also relicensed the package to MIT.
bigrquery vs lubridate: 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.
lubridate
0.0ANALYTICS
lubridate ships parsing fixes, timezone-data churn, and a long-overdue MIT relicense.
◆ Current state
lubridate is R's standard package for date-time manipulation. Recent releases are dominated by parsing correctness — partial datetimes, multiple format strings, month names colliding with the %a format — and by adapting to timezone database changes in R-devel. Version 1.9.5 also relicensed the package to MIT.
◆ Where it's heading
The feature surface has been stable since 1.9.0 deprecated the roll argument for roll_dst and added integer coercion for Duration, Period and Interval. What continues is a steady stream of parsing edge cases and tzdata churn the package absorbs on its users' behalf, which is most of what a date-time library's maintenance actually is.
◆ Prediction
Expect further releases driven by tzdata and R-devel changes, with parsing fixes arriving as locale and format edge cases get reported.
Alternatives to bigrquery and lubridate
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 lubridate.
pins
pins keeps adding a storage backend per release while retiring its original API
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
See all bigrquery alternatives → · See all lubridate alternatives →
Recent activity from bigrquery and lubridate
Latest ship moves from both products, interleaved chronologically. ⚡ = editorial spark.
- 3mo agobigrqueryJob labels for cost allocation; microsecond upload precision
- 6mo agolubridatelubridate 1.9.5 relicenses to MIT and fixes timestamp order
- 6mo agolubridatelubridate 1.9.4 parses partial datetimes like as.POSIXct()
- 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 agolubridatelubridate 1.9.2 fixes month parsing when %a is present
- 3y agolubridatelubridate 1.9.1 accepts multiple formats in as_datetime()
- 3y agolubridatelubridate 1.9.0 replaces roll with an explicit roll_dst argument
- 5y agolubridatelubridate 1.7.10 fixes interval division across leap years
Frequently asked questions
What is the difference between bigrquery and lubridate?
They serve adjacent needs but don't currently overlap on shipped themes. bigrquery and lubridate 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 lubridate?
Sparkpulse doesn't pick a winner — we score release velocity, not feature parity. bigrquery and lubridate 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 lubridate?
Top lubridate alternatives in Analytics are ranked by recent ship velocity. Browse the "lubridate alternatives" section above for the current picks, or visit /alternatives/lubridate for the full list with editorial commentary on each.