Re: About the gambas web apps

[T Lee Davidson <t.lee.davidson@xxxxxxxxx>]

On 3/26/25 6:42 AM, gaucho wrote:
> Is it good or bad from a performance point of view to have multiple
> connections to DB?

That depends on how many "multiple" is, the web server, and the database engine. Hundreds or thousands of connections would not 
likely be an issue. A more important performance issue is how many rows of data need to be processed across how many multiple 
tables, for any particular query. And, that is where database normalization and optimization comes into play.


> How is the architecture of systems that have a database, a web app and
> a smartphone app? How does a rest API fit into all this?
> I mean if I have a database on a server and a program that “talks” with
> it and then I have a web program that also “talks” with the database
> and a smartphone that also talks with the database, wouldn't it be
> better that the web and the smartphone app communicate with an
> intermediate program through an API?

That depends on how many different people or groups of people are developing the applications. If there are just a few in-house 
developers, then IMO adding a REST API server would only serve to add unnecessary complexity. On the other hand, if there are 
hundreds or even thousands of (unknown) clients all wanting to develop apps using their own preferred programming language, then 
implementing a REST API would probably make sense.


--
Lee

--- Gambas User List Netiquette [https://gambaswiki.org/wiki/doc/netiquette] ----
--- Gambas User List Archive [https://lists.gambas-basic.org/archive/user] ----