Hello, I am developing a tool* in C++ and one of its features will be that it will load an SQL script (CREATE TABLE, INSERT), execute it, then execute some queries and print results.
The SQL script might be long and I do not want to load it whole in the memory. Usually it will easily fit, but the tool should be capable to process longer scripts with constant memory usage. What is recommended way? I see that there is sqlite3_complete() function, which can detect complete query, but I would have to check the input using this function character by character, to stop exactly at the semicolon and then execute. Or I can try to execute what I have loaded and if it fails, load more – but this way I risk that I load incomplete statement, which could be valid and mistakenly executed (e.g. DELETE or SELECT without WHERE condition). So this will also not work. Franta *) if anyone interested, it is free software, described here: <https://relational-pipes.globalcode.info/> sources: <https://hg.globalcode.info/relpipe/relpipe-tr-sql.cpp/> _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users