Improving data processing with prepared SQL statements

Markus Elfring <[email protected]> Mon, 18 Mar 2024 15:56:57 +0100

Newsgroups	org.kernel.vger.smatch
Message-ID	<[email protected]>

Hello,

I took another look also at the implementation of the macro “sql_insert_helper”.
https://github.com/error27/smatch/blob/721ca29e1f857b9bda9d55dda989e0fb1c72e590/smatch.h#L1099

I got the impression then that such data processing can benefit more from
the usage of prepared SQL statements.
https://sqlite.org/c3ref/stmt.html

How do you think to adjust any design aspects accordingly?

Regards,
Markus