*** 91,93 **** --- 91,106 ---- Q) Is there a limit to the number of prepared statements? A) No practical limit. You have to have enough memory to hold them all. + ------ + Q) Is it possible to modify the way functions are handled in sqlite ? + My idea is to allow functions to have their own private data space to save data from row to row like the agregates have, with that we can have functions that remember last row values, create counters and totalizers that return their updated values for each row. + + Ex: + + select increment(1),* from my_table; + + select sum_and_return_row_by_row(row_value_to_sum),* from my_table; + + select current_row_value + last_row_value(current_row_value),* from my_table; + + The structure for that is already there, in fact is the same used by agregates, I was scratching the code but I could not find easily where to introduce code to push the context and recover for functions that aren't agregates, someone know how to do that ?
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|