Die Holländer

and now you want to Create Delphi Azure functions with Azure SQL database (Delphi webbroker app) Getting Started with Azure Cloud Development with Delphi But I didn't find the proper solution (configuration..)

Deploy Azure SQL Database for free We access the database with a limit number of users (3-5) and I don't know if this is limited.

I use Azure cloud with MSSQL (free edition), FireDac and works great. I pay about 5 Euro per month. Very nice is it's Database Management Studio.

I always drop a Jedi's JvFormStorage on my form and that's it.. and the position and state..

Is it me or are there others that have problems by highlighting a line of text by clicking LMB and dragging the mouse along that line and at the same time use the scroll wheel to scroll vertically downwards. Somehow my fingers can't handle this process very well. Should I buy another mouse?

Youtube Embarcadero: Best practices and top tips when developing mobile apps.

Which MSSQL database version and driver are you using?

Maybe such is possible..

"Bulk insert" is another term. Maybe you know it...

The Batchmove is mostly used when you have to dump a large dataset into an table once. I think what you want is to sync tables, so when something is changed in the one table there will be the same change in the other table automatically. First you make the tables the same with the data and then the trigger does the rest. The trigger must also work for two databases, especially when they are on the same database server. I'm also not familiar with SQLite but do a Goolge search on like "SQLite INSERT, UPDATE, DELETE trigger two tables" I can DM you an example of a MSSQL trigger that does this if you wish.

Is it not possible in sqlite to create a INSERT, UPDATE, DELETE trigger on the source table to sync it to the destination table?

ah, FMX

Using Windows? You can take a look to it's "Credentialmanager". The Credential data is read/writeable (easy with Delphi) when logged in the machine and encrypted when outside the OS.

Some databases support JSON tables where you can insert JSON strings and query them with normal SQL and is VERY fast. Google for example "MSSQL database JSON" >>Additionally, how can I extract only the needed data from a large JSON response without parsing the entire object? You can exactly do this with the database, because you have to create a kind of mapping to use the SQL and you can map only the fields that you need..