Hi Jaiswal,
You can use the Python sqlite3 standard lib for opening this database and manipulate it, and then display data using views written with Django.
Eric
Re,
But you'll not be able to access the sqlite DB through Django models, since it will not have the proper schema.
--
Thanks for the tip, I didn't notice this management command before.
Eric
Hi,
The content of the context dict can be anything, including of course values read from the database thanks to the sqlite3 lib. What Django generic views working with templates do is transfering for you the object field values to context entries and also automating the creation of form fields based on the model introspection.
WRT to you question about the size of the data, it depends on what you want to do. If you plan to display thousands of records in a single HTML page, it will not very efficient for sure and the browser may choke in extreme situations. To work around this, you can either implement pagination by yourself, using f.i. AJAX requests to return chunks of data as JSON packets and process them by a bit of Javascript on the client side to update your page. You can also look for JS widgets implementing this for you. I remember having used Datatables (https://datatables.net/) a while ago, and it does its job pretty well.
Regards
Eric