Friday, March 13, 2015

How to make Google Spreadsheet as searchable database

I've got this idea from this programming database https://github.com/chrislkeller/projects.chrislkeller.com/tree/master/demos/tabletop_to_datatables how to make the Excel file as database and allow users to search it's contents. Some of steps are found here http://dataforradicals.com/the-absurdly-illustrated-guide-to-sortable-searchable-online-data-tables/ how to make it works.

The good thing about Google Spreadsheet database it's totally free and easy to store data compared to SQL, Oracle, etc. It doesn't require passwords or any sort of advanced programming skills to key in the data. All you need is Google account especially the Google Drive where the spreadsheet software is available. You can import whatever data from existing Ms Office excel file by copy and paste onto the Google spreadsheet and publish it on the world wide web for display or reference purposes. This is especially for smaller and medium size data that ranges from 100 to 5000 data i.e. Sales, Restaurants, Survey, etc.



The good thing about the coding is the data will load first onto the table and that make it very fast for the search function to find its content that has been loaded. This is one of the best way to make website searches faster which almost nearly equivalent to instant searches although not exactly.

However I've come to realized that the excel is not feasible for large data as the searches will be become significantly slowed down. You can see the example here that i've done where there are 54000 data in the database it takes more than few minutes for it to load. In addition this also depending on the user internet connection where it might not load if the speed is below 1 Mb.

Disclaimer: I do not own the right to the coding and it is solely own by rightful owner https://github.com/chrislkeller/projects.chrislkeller.com/tree/master/demos/tabletop_to_datatables. This is just an educational purposes for future reference as a proof that this coding is workable and can be enhanced to suit specific needs.