Django Html postgresql

Question

I have a table in a database, which I handle with postgresql. I fetch all the data and put it into my html with
{% for R in Result...
<p> {{R.name}}
<p>{{R.price}}
...
Now I would like to have three columns like:
R1.name. R2.name. R3.name
R1.price. R2.price. R3.price
I can think of some workarounds to achieve that, but I'm wondering, what is best practice?
No for loop? Fetch the data from the table in a different way?
I think there is probrably a very easy way to do that, which I just don't know, but maybe you know :)

Answer 1

The best way in my opinion would be to collect the names and prices in the server side
names = [r.name for r in your_model_name.objects.all()]
prices = [r.prices for r in your_model_name.objects.all()]
The pass the `names` and `prices` list into the context dictionary, so that you can access it in the template
Then in the html file you can do
<table>
<tr>
{% for name in names %}
<td>{{ name }}</td>
</tr>
<tr>
{% for price in prices %}
<td>{{ price }}</td>
</tr>
</table>
DISCLAIMER: I haven't done Django in a long time now (like I haven't even touched it since like 6-7 months). So there might be a better way I'm forgetting or I just don't know about. Maybe someone else can provide a better answer.

Answer 2

Thanks for your idea. I think I'll do it similar to that, unless I find an easier way. I want to keep it as dynamic/flexible as possible.