Updating DataTable with flask and sqlalchemy?

nat5142

I'm working on a project in which I'm requesting user input (containing database query parameters) from an HTML form, POSTing that input to flask, then querying a populated database accordingly. My database is very large (107 million+ records) so I'd like to implement AJAX to load ~100 rows per page, then process the subsequent pages on the server-side based on the client's request. Basically, I want the user to hit page 2 and load records #101-200 in place of records #1-100.

I stumbled upon this description, which was helpful, but I was hesitant to use because it referenced an old version of DT, and because I'm using MySQL instead of MongoDB.

I figure this is a big shot in the dark, and I'd be more than happy to provide code if there are any flask users still checking the DT discussion boards.

Thanks to all in advance.

tangerine

You might want to look at this:
https://datatables.net//forums/discussion/43214

nat5142

Wow, thanks so much @tangerine ! This looks like it'll be a huge help.