Page actions

[Aesth]

Let's say I need to perform some action on the same page when I click a button, without reloading it. Does this mean I need to use some kind of script (JS, etc.) to change the appearance or state of a control? Is that correct, or does SQLPage offer other options?

[lovasoa]

Some SQLPage components have built-in interactivity, but there is no generalized intra-page interactivity mechanism provided by SQLPage. You can use libraries like datastar or htmx that fit the SQLPage paradigm quite well.

Personally, I tend to do as much as possible in the traditional server-side full-page reload way. This avoids state management issues, and can be totally transparent to the user when pages are small and fast.

Can you tell a bit more about what you are building and where you want to add interactivity ?

[Aesth]

I'm taking a short break to consider the alternatives. For now, I can only say that SQLPage's logic is generally clear and I like it, but since I'm not very experienced in web development, I'm probably asking too many simple questions.

[lovasoa]

Do not hesitate if you have any question ! What are you working on ?

[Aesth]

In a nutshell, the online service provided rather complex support for the organizational aspects of online logical paired games. The database was developed using a relational model, but processing and display required a web interface, something I hadn't encountered as a developer before.
The search for a suitable solution led me to web frameworks, but most of them are built on ORM, which I find somewhat absurd (that's a separate topic). And they're, in my opinion, too large and complex to meet the needs of every task, making them redundant and cumbersome. I even thought it would be easier to write my own without such frameworks, but that would require time to understand web development itself, which would require a significant amount of time. I've been searching for a more elegant solution for a long time, and I think I've found it in the form of SQL Page, which is very close to my experience and makes it possible to combine the elegance of a relational data model and presentation to the end user through a web interface.

[lovasoa]

So, the kind of interactivity you are looking for is in-browser logical games, like an online sudoku ?

[Aesth]

Paired correspondence strategic games: Go, Chess, Checkers, Renju. etc,. Tournaments, their organization, rules, games, participants, and informational support. The games themselves, or rather their display to users, verification, and analysis of moves, are a separate, complex task. For now, organizational and informational support remains a pressing issue.
For example, ICCF