tidytlg
A tables-listings-graphs package that reached CRAN and then went quiet.
Comparison · Analytics
datasetjson vs orbital
A side-by-side editorial comparison of datasetjson and orbital — release velocity, themes, recent moves, and the top alternatives to consider.
Shared themes:r-package
datasetjson vs orbital: at a glance
What is datasetjson?
datasetjson rebuilt its object model to track the CDISC Dataset-JSON 1.1 schema.
datasetjson reads and writes CDISC Dataset-JSON, the JSON replacement for SAS transport files in clinical-trial submissions. The package went from a thin reader in 2023 to a redesigned interface in 0.3.0 that targets the 1.1.0 schema, uses yyjsonr as its JSON backend, and exposes column metadata as first-class arguments. Development is contributor-driven inside the Atorus and pharmaverse orbit.
What is orbital?
Turning fitted tidymodels into SQL, one model family at a time — and the boosting engines just landed.
orbital converts a fitted tidymodels workflow into a database expression so prediction runs where the data lives, no R session in the loop. Its value is entirely a function of coverage, and 0.5.0 was the largest coverage release yet: catboost and lightgbm boosted trees, rpart decision trees, earth-backed MARS, glmnet multinomial regression, and both randomForest and ranger random forests, all for numeric, class, and probability predictions. The 0.5.1 follow-up is corrective, fixing SQL that Snowflake and other engines rejected because it cast booleans directly to numeric.
datasetjson vs orbital: editorial side-by-side
datasetjson
0.0ANALYTICS
datasetjson rebuilt its object model to track the CDISC Dataset-JSON 1.1 schema.
◆ Current state
datasetjson reads and writes CDISC Dataset-JSON, the JSON replacement for SAS transport files in clinical-trial submissions. The package went from a thin reader in 2023 to a redesigned interface in 0.3.0 that targets the 1.1.0 schema, uses yyjsonr as its JSON backend, and exposes column metadata as first-class arguments. Development is contributor-driven inside the Atorus and pharmaverse orbit.
◆ Where it's heading
The package's roadmap is not its own — it tracks a CDISC standard that is still moving, and 0.3.0 is what happens when the standard revises: object model, read and write paths, and JSON backend all changed together. Performance was addressed in the same pass, which matters because submission datasets are large enough that a slow serialiser is a real constraint.
◆ Prediction
The next significant release will most likely follow the next Dataset-JSON schema revision rather than an internal roadmap, given that 0.3.0 was driven entirely by the 1.1.0 update.
orbital
0.0ANALYTICS
Turning fitted tidymodels into SQL, one model family at a time — and the boosting engines just landed.
◆ Current state
orbital converts a fitted tidymodels workflow into a database expression so prediction runs where the data lives, no R session in the loop. Its value is entirely a function of coverage, and 0.5.0 was the largest coverage release yet: catboost and lightgbm boosted trees, rpart decision trees, earth-backed MARS, glmnet multinomial regression, and both randomForest and ranger random forests, all for numeric, class, and probability predictions. The 0.5.1 follow-up is corrective, fixing SQL that Snowflake and other engines rejected because it cast booleans directly to numeric.
◆ Where it's heading
The package has been working outward in rings: recipe preprocessing steps first, then model types, then post-processing via the tailor package in 0.4.0, with show_query() added so users can inspect what actually gets sent. Recent releases show the constraint shifting from R-side translation to SQL dialect compatibility — the bugs now are about what a specific database will accept, not whether a model can be expressed. estimate_orbital_size() in 0.5.1 acknowledges the other practical limit, since generated expressions can grow large enough to matter before you generate them.
◆ Prediction
With the major boosting and ensemble engines covered, expect the next releases to keep chasing dialect-specific SQL correctness across warehouses rather than adding model families.
Alternatives to datasetjson and orbital
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 datasetjson or orbital.
Tplyr
Tplyr made clinical summary tables explain where every number came from.
rlistings
Clinical listings that keep inheriting their hardest problem — pagination — from the layer below.
hoardr
A cache-directory helper that has shipped nothing but CRAN-triggered patches for seven years.
gigs
gigs redesigned its whole conversion API for rOpenSci, then spent three releases getting the docs to build.
riem
A weather-data client that keeps rewriting its HTTP layer while slowly tightening its API.
See all datasetjson alternatives → · See all orbital alternatives →
Recent activity from datasetjson and orbital
Latest ship moves from both products, interleaved chronologically. ⚡ = editorial spark.
- 1mo agoorbitalSnowflake-compatible SQL for dummy and NA steps
- 5mo agoorbitalcatboost, lightgbm, ranger and four more model families translate to SQL ⚡
- 8mo agoorbitalCompatibility with new xgboost versions
- 8mo agoorbitalPost-processing adjustments from tailor become translatable
- 11mo agoorbitalPCA step translation bugs cleared
- 1y agodatasetjsonDataset-JSON 1.1.0 support with a redesigned object model ⚡
- 1y agoorbitalClass and probability predictions arrive, with glm and xgboost
- 2y agodatasetjsonReads and validates Dataset-JSON from URLs
- 2y agodatasetjsonInitial CRAN release
Frequently asked questions
What is the difference between datasetjson and orbital?
Both compete on the same themes — r-package — within Analytics. datasetjson and orbital 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 datasetjson better than orbital?
Sparkpulse doesn't pick a winner — we score release velocity, not feature parity. datasetjson and orbital 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 datasetjson?
Top datasetjson alternatives in Analytics are ranked by recent ship velocity. Browse the "datasetjson alternatives" section above for the current picks, or visit /alternatives/datasetjson for the full list with editorial commentary on each.
What are the best alternatives to orbital?
Top orbital alternatives in Analytics are ranked by recent ship velocity. Browse the "orbital alternatives" section above for the current picks, or visit /alternatives/orbital for the full list with editorial commentary on each.