Ask HN: Why isn't there a modern MS Access clone?

Re:Ask HN: Why isn't there a modern MS Access clone? by dustingetz on Thursday September 14, 2017 @09:15AM (#15247621)

JOIN tables, sparse tables, deeply nested JOINs - all this is needed to code link-following in the relational model. So you need an ORM to handle the JOIN pain for you, but relational db query perf degrades as your joins get deeper, so the ORM needs to make hard choices around caching and database query round tips - but the ORM doesn't have enough information about the UI to make these choices - you end up needing to code the app logic into the ORM via caching and query optimizations. And now you're writing code, that's not links and forms anymore.

At ClojureNYC last night I gave a talk about literally this! Here are the slides: https://github.com/hyperfiddle/hypercrud.browser/issues/4

[ Parent | on HN ]

Re:Ask HN: Why isn't there a modern MS Access clone? by Norther on Thursday September 14, 2017 @06:04PM (#15252888)

Dustin, wow. I can see a lot of work went into your talk. I read along for about 80% and you make some great points. Hyperfiddle looks impressive - I signed up to the dev mailing list.

As an aside, do you think traditionally built apps should be moving away from SQL and towards immutable stores like Datomic?

[ Parent | on HN ]

Re:Ask HN: Why isn't there a modern MS Access clone? by dustingetz on Friday September 15, 2017 @01:25PM (#15258971)

yes! Data driven UI (which is what this thread is about) will never succeed on sql.

[ Parent | on HN ]