Jun-20-2019, 01:28 AM
When I scarp a web page I'm getting data similar to below lists.
I'm thinking of how to store in a database in order to do searches afterward.
Eg. If my keyword (eg. "Lane 1") matches database column "Address1" I should be able to get an entire data point.
I'm not sure what is the database software suitable for this.
Do I have to get elements of lists and save in several columns and create SQLite/PostgreSQL type database or can I save this data in a MongoDB or similar NoSQL type database?
Appreciate if you can give some inputs
MainID = [[1]] AddrID = [['1'], ['2']] Address1 = [['Lane 1'], ['Lane 2']] Address2 = [['State 1'], ['State 2']]Example of the table view shown in the attached picture
I'm thinking of how to store in a database in order to do searches afterward.
Eg. If my keyword (eg. "Lane 1") matches database column "Address1" I should be able to get an entire data point.
I'm not sure what is the database software suitable for this.
Do I have to get elements of lists and save in several columns and create SQLite/PostgreSQL type database or can I save this data in a MongoDB or similar NoSQL type database?
Appreciate if you can give some inputs