JS

JSON spreadsheets with vi bindings (proof of concept)

Hacker News

JSON spreadsheets with vi bindings (proof of concept)

Hi folks! I'd like to share a proof of concept for an idea I've thought about for a long time. Think of a new form of spreadsheets where the primary data structure is not a rigid grid but a free-form JSON-like structure (but with first class tables support of course). I'm linking here a demo which uses vi style hotkeys for interaction, although of course the idea is not limited to that mode of interaction. The addresses end up being JSON paths. The layout is currently rigid because it's just a PoC but ideally you'd have much more control over it, kind of like a canvas. Expressions can refer to other cells via their JSON based address, even relative to their current address. There is no expressions support in the PoC yet but a table in the example does show a dynamic column. Since you have arbitrarily nested arrays/hashes anyway, you can reserve tables to represent arrays of homogenous records, and some of the columns can be dynamically calculated (or have a default dynamic calculation) based on other columns. The expressions are just JavaScript functions, but they can be anything that works with JSON types. This is very far from finished. I'm just been trying to share early these days and I think many of you'd find the idea itself interesting. Why? I think spreadsheets are great but they are underutilized because of their rigidity. They are not suitable for version control, being authoritative data sources, powering APIs etc. I don't know if this is the right direction either. I'd be happy to hear your thoughts! The code is 100% manually written by me (except for the CSS background which I copied from SO). If there is sufficient interest in collaboration, I'd be happy to put up the source on codeberg.

Share card

Actual performance

1points
Did not reach leaderboard

Launch Intel predictions

Analyze your own launch →
Product HuntOn track for Day 1 leaderboard · Strong signals: new, code, apis · Missing: mac, agents, macos
81%81% predicted probability of success on Product Hunt, based on ML models trained on real launch data.
best fitHighest predicted score across all platforms for this description.
Indie HackersFits the IH revenue-focused audience · Missing: supports, reddit linkedin, podcasting
59%59% predicted probability of success on Indie Hackers, based on ML models trained on real launch data.
Hacker NewsStrong engagement from HN community · Strong signals: ide, io · Missing: https docs, excited, just released
55%55% predicted probability of success on Hacker News, based on ML models trained on real launch data.
nativeThis product was originally launched on this platform.
AppSumoMay struggle as an AppSumo deal · Missing: plus, platform, intuitive
30%30% predicted probability of success on AppSumo, based on ML models trained on real launch data.
TrustMRRLess likely to generate early MRR · Strong signals: way · Missing: mobile apps, ios, personal
29%29% predicted probability of success on TrustMRR, based on ML models trained on real launch data.
Acquire.comPre-revenue stage for this audience · Strong signals: arr · Missing: mrr, revenue, profit
14%14% predicted probability of success on Acquire.com, based on ML models trained on real launch data.
BetaListMay not resonate with beta-testers · Missing: web3, chat, crypto
0%0% predicted probability of success on BetaList, based on ML models trained on real launch data.

Incorrect prediction on native model

Similar products

CR
CRUD Spreadsheets72%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

CRUD Spreadsheets

Hacker News4
Bi
Billion Cell Spreadsheets with Incremental Computation86%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Billion Cell Spreadsheets with Incremental Computation

Hacker News15
No
No more emailing spreadsheets around82%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

No more emailing spreadsheets around

Hacker News1
Sh
SheetBest – Convert Google Spreadsheets into JSON APIs69%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

SheetBest – Convert Google Spreadsheets into JSON APIs

Hacker News6
Ge
Get a Merkle-Proof from Ethereum36%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Get a Merkle-Proof from Ethereum

Hacker News2
Bu
Burni – Proof-of-Burn Ethereum NFTs35%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Burni – Proof-of-Burn Ethereum NFTs

Hacker News2
Xt
Xtract – Proof of Concept for Filterable Iterator in Golang34%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Xtract – Proof of Concept for Filterable Iterator in Golang

Hacker News1
Pr
Proof of God51%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Proof of God

Hacker News4
I
I implemented gmaxwell's "solvency proof scheme"50%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

I implemented gmaxwell's "solvency proof scheme"

Hacker News29
FL
FLP Impossibility Theorem Proof in Coq26%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

FLP Impossibility Theorem Proof in Coq

Hacker News38