is it fine
If i use google spreadsheet as database for my application -
I would have around 2000 rows and user(s) can search thru these records.
Search is perfomed thru web component and on textchange event
3.how many concurrent connection are allowed to a single spreadsheet (how many users can perform a search at same time?)
This was developed using fusion table earlier but since google is removing/deprecating fusion tables, i choose going with google spreadsheet.
I used a database at Google spreadsheet with a big count of rows and there is not a count for concurrent connections, because you are working with queries.
One big negative point is that you can’t authenticate your user and the database is accessible to everyone.