I would like to use the jquery database (http://datatables.net/
). However, my tables are huge so, I will have to use the server side processing option.
I found this script on the website http://datatables.net/release-datatables/examples/server_side/server_side.html
but is written for MYSQL.
The script uses some function that are not available in SQLite (SQL_CALC_FOUND_ROWS ,SELECT FOUND_ROWS())
How can I convert this script to use SQLITE.