ggalign
Composable aligned layouts, rebuilt on S7 while ggplot2 4.0 lands underneath.
Comparison · Infra & APIs
aftables vs pr2database
A side-by-side editorial comparison of aftables and pr2database — release velocity, themes, recent moves, and the top alternatives to consider.
aftables vs pr2database: at a glance
What is aftables?
Accessible government spreadsheets in R, rebuilt on openxlsx2 and renamed along the way.
aftables generates spreadsheets that meet the UK Analysis Function's accessibility guidance, taking structured input and producing a formatted workbook with cover, contents, notes and table sheets. Version 2.0.0 replaced the workbook engine with openxlsx2 and added configuration through a config.yaml file, with create_config_yaml() exporting a template and generate_workbook() gaining arguments to point at it. The package was previously called a11ytables and was renamed in 1.0.2, with function names changed to match.
What is pr2database?
The protist reference database keeps widening past the rRNA gene it was built on.
PR2 curates ribosomal reference sequences for eukaryotes, distributed as flat files and through a web interface, with each release crediting the specialists who curated individual clades. Since 2022 the structural changes have outweighed the curation: one combined SSU database replaced the separate ones, the taxonomy moved from eight levels to nine, and companion databases for ribosomal operons, mixoplankton and mitochondrial COI have been linked in.
aftables vs pr2database: editorial side-by-side
aftables
0.0INFRA · APIS
Accessible government spreadsheets in R, rebuilt on openxlsx2 and renamed along the way.
◆ Current state
aftables generates spreadsheets that meet the UK Analysis Function's accessibility guidance, taking structured input and producing a formatted workbook with cover, contents, notes and table sheets. Version 2.0.0 replaced the workbook engine with openxlsx2 and added configuration through a config.yaml file, with create_config_yaml() exporting a template and generate_workbook() gaining arguments to point at it. The package was previously called a11ytables and was renamed in 1.0.2, with function names changed to match.
◆ Where it's heading
The history reads in two phases. As a11ytables the work was about what belongs in an accessible spreadsheet, adding arbitrary pre-table metadata rows and enforcing rules such as rejecting tab titles that start with a numeral. Since the rename the work has been structural: a new backend, and configuration moved out of function arguments into a file that can be version-controlled and shared across a team. That second phase suits the audience, since government analysts producing recurring statistical releases want the same document properties applied every time rather than re-specified per run.
◆ Prediction
Expect the config.yaml surface to grow to cover more of what is currently passed as arguments, given it arrived alongside alternative author, title and keywords arguments that it plainly supersedes. With the openxlsx2 migration complete, further releases are likely to be formatting fixes surfaced by real departmental publications, as 2.0.1 already was.
pr2database
0.0INFRA · APIS
The protist reference database keeps widening past the rRNA gene it was built on.
◆ Current state
PR2 curates ribosomal reference sequences for eukaryotes, distributed as flat files and through a web interface, with each release crediting the specialists who curated individual clades. Since 2022 the structural changes have outweighed the curation: one combined SSU database replaced the separate ones, the taxonomy moved from eight levels to nine, and companion databases for ribosomal operons, mixoplankton and mitochondrial COI have been linked in.
◆ Where it's heading
The database is becoming a hub rather than a single file. Each recent release integrates something maintained elsewhere, with the ROD, EukRibo, Mixoplankton and now eKOI databases reachable through the same interface, while the SSU flat files themselves change little between versions. Curation continues underneath, clade by clade, at a pace set by which specialist contributed that cycle.
◆ Prediction
Expect the next release to integrate or refresh another linked database while the SSU files see routine curation, following the pattern of the last three.
Alternatives to aftables and pr2database
Other Infra & APIs 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 aftables or pr2database.
prioritizr
Conservation planning absorbs the literature's target-setting rules as code.
jSDM
Joint species distribution models in Gibbs-sampled C++, quiet since 2023.
rsofun
An ecosystem model starts tracking carbon isotopes and land-use change.
usmap
Ten years in, US mapping splits its data out and finally adds Puerto Rico.
trackeR
Fitness-tracking analysis in slow maintenance, still absorbing upstream breakage.
See all aftables alternatives → · See all pr2database alternatives →
Recent activity from aftables and pr2database
Latest ship moves from both products, interleaved chronologically. ⚡ = editorial spark.
- 4mo agoaftablesrlang import restored for older R versions
- 5mo agoaftablesWorkbook engine moved to openxlsx2; config.yaml introduced ⚡
- 9mo agopr2databaseeKOI mitochondrial COI database reachable from the interface
- 1y agopr2databaseRibosomal Operon Database 1.2 integrated; ten clades curated
- 1y agoaftablesPackage renamed from a11ytables to aftables
- 2y agoaftablesTab titles beginning with a numeral now rejected
- 2y agoaftablescustom_rows allows arbitrary pre-table metadata
- 2y agoaftablesTable count spelled out; README spelling corrected
- 2y agopr2databaseTaxonomy restructured from eight levels to nine ⚡
- 3y agopr2databaseNew web interface at app.pr2-database.org
- 4y agopr2databaseOne SSU database for nuclear, organelle and bacterial sequences ⚡
- 5y agopr2database2,966 sequences added and 3,817 removed across four clades
Frequently asked questions
What is the difference between aftables and pr2database?
They serve adjacent needs but don't currently overlap on shipped themes. aftables and pr2database 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 aftables better than pr2database?
Sparkpulse doesn't pick a winner — we score release velocity, not feature parity. aftables and pr2database 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 Infra & APIs products to evaluate alongside.
What are the best alternatives to aftables?
Top aftables alternatives in Infra & APIs are ranked by recent ship velocity. Browse the "aftables alternatives" section above for the current picks, or visit /alternatives/aftables for the full list with editorial commentary on each.
What are the best alternatives to pr2database?
Top pr2database alternatives in Infra & APIs are ranked by recent ship velocity. Browse the "pr2database alternatives" section above for the current picks, or visit /alternatives/pr2database for the full list with editorial commentary on each.