In order to have dynamic UI you either have to use jQuery or SPA library like Vue or similar.

For me the major advantage of vuejs over jquery is the way data drives UI

But... people had dynamic UIs before jQuery and Vue. The main benefit of jQuery was back in the days when the browsers were so different from each other, but that's not the case anymore. I'd recommend learning some vanilla JS before thinking that you need jQuery/Vue/React to create dynamic UIs.

The difference is imperative vs reactive UI. The impact of this is hard to overstate.

Why do you need jQuery for this?

You don't strictly need jQuery for this. jQuery simply has a terser API than the standard DOM. That's why I still use it.

Absolutely agree with your statement about Sequel and Roda. Both are true software masterpieces.

It's true for me too. While I love ruby for its beauty and elegance, I love Sequel even more. I find Sequel to be the most powerful and most flexible tool to make RDB queries.

I wouldn't be strong enough to make this work. Quitting smoking was exactly opposite for me. After several unsuccessful attempts to quit, my frustration grew bigger and bigger and I finally had to say to myself "I WILL NEVER EVER SMOKE AGAIN", and threw away remaining cigarettes. Everything was easy after that. My brain switched mode to "NEVER EVER" and cravings stopped completely. That was back in 1995.

If you are writing RDBMS centric apps, the way your app interact with your DB matters a lot, maybe even more than choice of a programming language. This is where ruby has real superstars, Sequel and ActiveRecord. Nothing I've seen in other languages comes close to Sequel's power, expressiveness and flexibility to query databases. This is the main reason I use ruby. On top of that, ruby is so elegant, it often puts a smile on your face, when you realize how elegantly you have solved a particular problem.