pins
pins keeps adding a storage backend per release while retiring its original API
Comparison · Analytics
dbplyr vs themis
A side-by-side editorial comparison of dbplyr and themis — release velocity, themes, recent moves, and the top alternatives to consider.
dbplyr vs themis: at a glance
What is dbplyr?
dbplyr ends its two-year backend migration by dropping 1st edition support outright
dbplyr translates dplyr code into SQL, and 2.6.0 closes a migration that has been running since 2023: first-edition backends no longer work at all. The same release converts a long list of soft deprecations into hard failures and removes functions deprecated as far back as 2019. The releases before it were translation-quality work across SQL Server, Redshift, Snowflake, Postgres, Spark and Teradata.
What is themis?
themis is back to adding real resampling algorithms after a documentation-heavy stretch.
themis supplies recipes steps for handling class imbalance in tidymodels. The 1.0.x line was consumed by documentation accuracy, message translation and internal consistency work. Version 1.1.0 returns to substance with two new under-sampling methods.
dbplyr vs themis: editorial side-by-side
dbplyr
0.0ANALYTICS
dbplyr ends its two-year backend migration by dropping 1st edition support outright
◆ Current state
dbplyr translates dplyr code into SQL, and 2.6.0 closes a migration that has been running since 2023: first-edition backends no longer work at all. The same release converts a long list of soft deprecations into hard failures and removes functions deprecated as far back as 2019. The releases before it were translation-quality work across SQL Server, Redshift, Snowflake, Postgres, Spark and Teradata.
◆ Where it's heading
The package is trading compatibility surface for a smaller, more consistent core it can actually evolve — qualified table names were overhauled in 2.5.0, sql() and ident() were refactored internally, and the cte argument gave way to a single sql_options() entry point. Backend breadth keeps growing at the translation level even as the extension API narrows.
◆ Prediction
With the edition split finally gone, expect the next cycle to spend its budget on dialect translations and the newer Spark/Databricks path rather than on further deprecation.
themis
2.5ANALYTICS
themis is back to adding real resampling algorithms after a documentation-heavy stretch.
◆ Current state
themis supplies recipes steps for handling class imbalance in tidymodels. The 1.0.x line was consumed by documentation accuracy, message translation and internal consistency work. Version 1.1.0 returns to substance with two new under-sampling methods.
◆ Where it's heading
The package grows by adding algorithms rather than restructuring itself. tomek() was rewritten to handle multiple classes and drop the unbalanced dependency, case weights arrived at 1.0.0, and cluster-centroid and condensed-nearest-neighbour under-sampling arrive now — each shipped as both a recipes step and a direct-implementation function.
◆ Prediction
Expect further under- and over-sampling methods in the same paired form, as the package fills out coverage of the standard class-imbalance literature.
Alternatives to dbplyr and themis
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 dbplyr or themis.
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 dbplyr alternatives → · See all themis alternatives →
Recent activity from dbplyr and themis
Latest ship moves from both products, interleaved chronologically. ⚡ = editorial spark.
- 10d agothemisthemis 1.1.0 adds cluster-centroid and CNN under-sampling
- 1mo agodbplyr1st edition backends removed; a wave of deprecations goes defunct ⚡
- 11mo agodbplyrDate and aggregate translation fixes across six SQL dialects
- 1y agothemisthemis 1.0.3 corrects resampling direction in documentation
- 2y agodbplyrQualified table names overhauled; I() becomes the simple path
- 2y agodbplyrPreliminary Databricks Spark SQL backend; join fixes
- 2y agodbplyrdbplyr 2.3.4
- 2y agothemisthemis 1.0.2 makes internal consistency and speed changes
- 3y agodbplyrdbplyr 2.3.3
- 3y agothemisthemis 1.0.1 fixes upsampling errors when none is needed
- 4y agothemisthemis 1.0.0 adds case weights to up- and down-sampling
- 4y agothemisthemis 0.2.2 rewrites tomek() for multiclass, drops a dependency
Frequently asked questions
What is the difference between dbplyr and themis?
They serve adjacent needs but don't currently overlap on shipped themes. themis is currently shipping more aggressively (velocity 2.5 vs 0.0), with 0 editorial sparks in the last 30 days against 0. See the at-a-glance table above for a side-by-side breakdown of velocity, recent sparks, and editorial themes.
Is dbplyr better than themis?
Sparkpulse doesn't pick a winner — we score release velocity, not feature parity. themis is currently shipping more aggressively (velocity 2.5 vs 0.0), with 0 editorial sparks in the last 30 days against 0. For your specific use case, the alternatives sections above list other Analytics products to evaluate alongside.
What are the best alternatives to dbplyr?
Top dbplyr alternatives in Analytics are ranked by recent ship velocity. Browse the "dbplyr alternatives" section above for the current picks, or visit /alternatives/dbplyr for the full list with editorial commentary on each.
What are the best alternatives to themis?
Top themis alternatives in Analytics are ranked by recent ship velocity. Browse the "themis alternatives" section above for the current picks, or visit /alternatives/themis for the full list with editorial commentary on each.