1👍
- If using Django, create a model based on the format of the JSON from
linkedin, if not, create the table manually via Postgres. - Create script to pull all data from linkedin API and store it in your Postgres DB.
- Use Django ORM or raw SQL to preform LIKE queries on the free text you are searching for in Postgres. Preferably, load a search engine such as ElasticSearch with all of your data so that you could do tokenized searches which return relative values against free text searches.
0👍
I think more recent versions of postgres have a JSON datatype, but I’m not sure if django supports querying it, def something to look up.
Normally integrating with a data source requires you to evaluate what sort of data you have (the json you posted)
How you are going to store your data,
How you are going to extract and transform the data from the data feed to import into your system
And actually importing it
Looking at the feed a couple of things stand out.
a Profile model with m2m to a Skills models and a m2m with a Category model
This should allow you easy quick lookup of any profiles given a specific category or skill
The django tutorial provides extremely well written examples on how to create models, interact with models, persist data using models and how to query models.
- [Answer]-Django increment one 'hit' for views in the current day
- [Answer]-Django 1.7 migration error
- [Answer]-Zinnia returned an invalid value in QuerySet.datetimes() with MySQL backend
- [Answer]-How to clear up Datetime and Timezone confusion?