Basedash
Basedash keeps pushing its data out of the workspace — now to people without accounts
Comparison · Analytics
fmtr vs NocoDB
A side-by-side editorial comparison of fmtr and NocoDB — release velocity, themes, recent moves, and the top alternatives to consider.
fmtr vs NocoDB: at a glance
What is fmtr?
Rebuilding SAS's formatting layer in R, one format specification at a time
fmtr applies formats to R data the way SAS applies them: named format catalogues, format lists, and an fapply() that maps a specification onto a vector. It is part of a family of packages that reconstruct SAS reporting idioms in R, and it shares infrastructure with them — labels.data.frame() was moved out to the common package, which fmtr now depends on. The recent releases have been closing specific gaps against SAS's own format vocabulary.
What is NocoDB?
Interfaces gets the permissions layer it needed, one release after launching.
NocoDB ships monthly, and the last two releases are a launch and its follow-through. 2026.08.0 introduced Interfaces, custom app surfaces built over a base; 2026.08.1 gives that layer what it was missing — per-dashboard visibility and editing permissions, field edit permissions enforced on interface pages, team-granted access, and page reordering. Alongside it the grid gains realtime presence with per-collaborator colours and jump-to-cursor, folders for grouping tables and views, up to three frozen fields, and nested records in List View.
fmtr vs NocoDB: editorial side-by-side
fmtr
0.0ANALYTICS
Rebuilding SAS's formatting layer in R, one format specification at a time
◆ Current state
fmtr applies formats to R data the way SAS applies them: named format catalogues, format lists, and an fapply() that maps a specification onto a vector. It is part of a family of packages that reconstruct SAS reporting idioms in R, and it shares infrastructure with them — labels.data.frame() was moved out to the common package, which fmtr now depends on. The recent releases have been closing specific gaps against SAS's own format vocabulary.
◆ Where it's heading
The direction is parity, pursued in small increments. Quarter format codes were added because base R has none; the SAS best. format was reimplemented, then hardened against the variations people actually write; statistical summary helpers like fmt_mean_sd() and fmt_mean_stderr() cover the cell contents clinical tables need. The structural work is largely behind it, including the breaking 2022 move that handed labelling to a sibling package, so what remains is vocabulary coverage.
◆ Prediction
The pattern of adding a SAS format, then a release to handle its variants, suggests the next releases continue filling in format codes and summary helpers rather than changing how formats are applied.
NocoDB
6.3ANALYTICS
Interfaces gets the permissions layer it needed, one release after launching.
◆ Current state
NocoDB ships monthly, and the last two releases are a launch and its follow-through. 2026.08.0 introduced Interfaces, custom app surfaces built over a base; 2026.08.1 gives that layer what it was missing — per-dashboard visibility and editing permissions, field edit permissions enforced on interface pages, team-granted access, and page reordering. Alongside it the grid gains realtime presence with per-collaborator colours and jump-to-cursor, folders for grouping tables and views, up to three frozen fields, and nested records in List View.
◆ Where it's heading
The pattern is consistent: NocoDB launches a surface, then spends the next release making it governable and usable at team scale. Presence and folders are collaboration parity rather than new direction — the directional bet was Interfaces, and this release is that bet being made safe for the eighty people who only need to approve something. The permission system is now the same one across tables, fields, dashboards, and interface pages, which is the consolidation that makes the app layer sellable.
◆ Prediction
Write-back actions and embedding are the remaining pieces app builders expect from Interfaces, and the availability tables in each release suggest they land on the paid tier.
Alternatives to fmtr and NocoDB
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 fmtr or NocoDB.
RStudio
RStudio ships through release branches, and the notes are commit messages
dbt Core
dbt Fusion's second beta is adapter work: ClickHouse gets materializations, indexes, and catalogs
Fulcrum
Fulcrum is betting its whole map stack on Esri, with a hard Google Maps cutoff on September 1.
Holistics
Holistics keeps fencing in the AI layer it spent the summer building.
Dovetail
Dovetail spent July opening doors to other tools and August making its own rooms easier to enter.
Recent activity from fmtr and NocoDB
Latest ship moves from both products, interleaved chronologically. ⚡ = editorial spark.
- 14h agoNocoDB2026.08.1 : Introducing Realtime Presence and Folders
- 14d agoNocoDB2026.08.0 : Introducing Interfaces ⚡
- 1mo agoNocoDB2026.07.0 : Introducing Calendar Sync & Image Annotations
- 1mo agoNocoDB2026.06.2 : Introducing Oracle Database Support
- 2mo agoNocoDB2026.06.1: tsgo typechecking and rspack bump
- 2mo agoNocoDB2026.06.0: Bounded group-by fetch retries
- 10mo agofmtrMean and standard error helper, plus best-format variants
- 11mo agofmtrSAS best. format reimplemented in fapply()
- 2y agofmtrQuarter format codes %q and %Q added
- 2y agofmtrFormat lists become readable and writable files
- 2y agofmtrDocumentation and examples expanded
- 2y agofmtrvalue() can return results as a factor
Frequently asked questions
What is the difference between fmtr and NocoDB?
They serve adjacent needs but don't currently overlap on shipped themes. NocoDB is currently shipping more aggressively (velocity 6.3 vs 0.0), with 1 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 fmtr better than NocoDB?
Sparkpulse doesn't pick a winner — we score release velocity, not feature parity. NocoDB is currently shipping more aggressively (velocity 6.3 vs 0.0), with 1 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 fmtr?
Top fmtr alternatives in Analytics are ranked by recent ship velocity. Browse the "fmtr alternatives" section above for the current picks, or visit /alternatives/fmtr for the full list with editorial commentary on each.
What are the best alternatives to NocoDB?
Top NocoDB alternatives in Analytics are ranked by recent ship velocity. Browse the "NocoDB alternatives" section above for the current picks, or visit /alternatives/nocodb for the full list with editorial commentary on each.