edibble
A grammar for experimental design that learned to compose designs and track its own provenance.
Comparison · Analytics
rolap vs secuTrialR
A side-by-side editorial comparison of rolap and secuTrialR — release velocity, themes, recent moves, and the top alternatives to consider.
Shared themes:r-package
rolap vs secuTrialR: at a glance
What is rolap?
A star-schema modelling package grew a query language, a deployment path, and then a map layer.
rolap builds dimensional models — star databases and constellations — from flat tables inside R. Over 2023 it acquired a multidimensional query interface, the ability to deploy models into relational databases, incremental refresh, and geographic layers exportable as GeoPackage. Since early 2024 it has been quiet, with the only 2025 release removing a test that clashed with another package.
What is secuTrialR?
A Swiss clinical-trial data reader that surfaces once every couple of years to clear check notes.
secuTrialR reads and prepares data exports from the secuTrial clinical data management system for analysis in R. Development is sporadic and maintenance-shaped: the 2025 release bundles six pull requests covering dependency breakage, quote handling in free text fields, a generalised URL builder and CRAN check notes. Its release notes are largely merge messages and submission records rather than descriptions of what changed.
rolap vs secuTrialR: editorial side-by-side
rolap
0.0ANALYTICS
A star-schema modelling package grew a query language, a deployment path, and then a map layer.
◆ Current state
rolap builds dimensional models — star databases and constellations — from flat tables inside R. Over 2023 it acquired a multidimensional query interface, the ability to deploy models into relational databases, incremental refresh, and geographic layers exportable as GeoPackage. Since early 2024 it has been quiet, with the only 2025 release removing a test that clashed with another package.
◆ Where it's heading
The 2023 releases trace a deliberate progression from modelling to operating: first a common data model and flat table class, then role-playing dimensions, then incremental refresh, then querying and deployment, then geography, then slowly changing dimensions. That is essentially the feature checklist of a data warehouse, assembled in about six months and documented with a vignette at each step. The pace since has dropped to almost nothing, which reads as a project that reached its intended scope rather than one that stalled.
◆ Prediction
Given eighteen months in which the only release was a test removal, the next release is more likely to be maintenance than another warehouse feature — though the entries give no clear signal either way.
secuTrialR
0.0ANALYTICS
A Swiss clinical-trial data reader that surfaces once every couple of years to clear check notes.
◆ Current state
secuTrialR reads and prepares data exports from the secuTrial clinical data management system for analysis in R. Development is sporadic and maintenance-shaped: the 2025 release bundles six pull requests covering dependency breakage, quote handling in free text fields, a generalised URL builder and CRAN check notes. Its release notes are largely merge messages and submission records rather than descriptions of what changed.
◆ Where it's heading
The visible history has two distinct phases. The 2020 releases are a CRAN review loop — four submissions in two weeks, each note recording only the submission itself. After that the package goes quiet for years at a time, resurfacing when R or its dependencies break something. The one substantive thread is robustness against real-world export data, with the free-text quote fix as the clearest example. The 2025 release's own changelog spans 1.1.1 to 1.3.3, so several intermediate versions exist that this feed never showed.
◆ Prediction
Expect the next release when a dependency or CRAN check forces one, since that has triggered every release since 2020; the notes give no indication of planned feature work.
Alternatives to rolap and secuTrialR
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 rolap or secuTrialR.
flightsbr
Brazil's flight-data package keeps working around what ANAC publishes and when.
kwb.db
A water-research lab's ODBC helper, still fighting Windows database drivers a decade in.
r2dii.match
PACTA's loan-book matcher opened up to sector taxonomies other than its own.
r2dii.plot
PACTA's climate-alignment charting layer split prep from plotting, then settled into stable.
mcmcensemble
An ensemble sampler just admitted its walkers were barely talking to each other.
See all rolap alternatives → · See all secuTrialR alternatives →
Recent activity from rolap and secuTrialR
Latest ship moves from both products, interleaved chronologically. ⚡ = editorial spark.
- 1y agorolapConflicting test temporarily removed
- 1y agosecuTrialRQuote handling in free text and dependency fixes
- 2y agorolapSlowly changing dimension structure added
- 2y agorolapGeographic layers and GeoPackage export
- 2y agorolaprolap 2.4.0 ⚡
- 2y agorolapIncremental refresh for star databases
- 2y agorolapFlat table class and a shared data model
- 3y agosecuTrialRCRAN check notes cleared
- 3y agosecuTrialRWarning added for overwritten variables
- 6y agosecuTrialRFourth CRAN submission, accepted
- 6y agosecuTrialRThird CRAN submission after review
- 6y agosecuTrialRSecond CRAN submission after review
Frequently asked questions
What is the difference between rolap and secuTrialR?
Both compete on the same themes — r-package — within Analytics. rolap and secuTrialR 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 rolap better than secuTrialR?
Sparkpulse doesn't pick a winner — we score release velocity, not feature parity. rolap and secuTrialR 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 rolap?
Top rolap alternatives in Analytics are ranked by recent ship velocity. Browse the "rolap alternatives" section above for the current picks, or visit /alternatives/rolap for the full list with editorial commentary on each.
What are the best alternatives to secuTrialR?
Top secuTrialR alternatives in Analytics are ranked by recent ship velocity. Browse the "secuTrialR alternatives" section above for the current picks, or visit /alternatives/secutrialr for the full list with editorial commentary on each.