topic SQL Query vs Data Table Component in Integration and Testing

SQL Query vs Data Table Component

SimonBritto — Sun, 24 Nov 2019 11:04:25 GMT

I was wondering what is the best way to access a database. We have a MySQL database on a web server and are running a local app accessing the data over the internet. I was wondering what is the advantages and disadvantages of using SQL Queries vs Data Table Component.

In Delphi, you have components that allow you to access a database. You can use a query component and a table component.

The query component allows you to run SQL code to fetch data from the database. I imagine this data is then kept in local memory.

The table component opens up an active connection to a table in the database. In this case, I think you are working directly with the data on the server.

Re: SQL Query vs Data Table Component

papaleo — Mon, 25 Oct 2021 07:51:37 GMT

Hello,

I got an answer from Delphi programmers. About my assignment on TTable vs TQuery. And ORM frameworks may help you make this almost automatic.

https://theessayservice.org/buy-term-paper/ view my assignment

Re: SQL Query vs Data Table Component

Carroll888 — Tue, 26 Oct 2021 06:38:40 GMT

@myloweslife wrote:
I was wondering what is the best way to access a database. We have a MySQL database on a web server and are running a local app accessing the data over the internet. I was wondering what is the advantages and disadvantages of using SQL Queries vs Data Table Component.
In Delphi, you have components that allow you to access a database. You can use a query component and a table component.
The query component allows you to run SQL code to fetch data from the database. I imagine this data is then kept in local memory.
The table component opens up an active connection to a table in the database. In this case, I think you are working directly with the data on the server.

It's a spectrum, it's not just split into basic and advanced.

Generally I would say with any topic you get into advanced when questions stop being Boolean and are about weighing up the options. Things like performance tuning, indexing, maintainance ect