Skip to main content
Software Engineering

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

5
  • 4
    What benefit is this "app SQL" indirection supposed to bring? This sounds like some part of a deployment/update process is painful, so someone has found they can bypass this friction by storing SQL fragments in a table (as opposed to, say, using stored procedures or maintaining stable interfaces via views). The main purpose of backend servers is a security barrier (control who can run which queries), but this "app SQL" hack provides none of that because the end user's device remains responsible for issuing the actual queries directly to the DB. Commented Jul 28, 2024 at 16:42
  • @amon I guess the deemed benefit was to somewhat decouple the app from the DB. But don't expect me to advocate for our design. I believe I made it clear in my question that I don't consider our design the right one and seek opinions on what it's supposed to be instead Commented Jul 28, 2024 at 17:08
  • 1
    @SergeyZolotarev, generally speaking, problems with "coupling" relate either to a disorderly coupling between application layers - and where the remedy is a more orderly coupling, certainly not decoupling - or it relates to a completely different notion of "vendor lock-in" where the remedy is ensuring that the application is not unreasonably reliant on an expensive third-party technology whose rent must be periodically renegotiated with the vendor. Commented Jul 28, 2024 at 17:23
  • Is there a specific need to have a fat client? For example, does your client need to access local hardware resources? This sort of requirement will greatly affect the answer to your question. Ideally you'd have no client at all (other than a browser) to make it easier for the IT department to support. Commented Jul 29, 2024 at 21:03
  • @JohnWu the facilities' hardware must be stored on the premises, if that what you're asking Commented Jul 30, 2024 at 2:57