django-q | A multiprocessing distributed task queue for Django | BPM library

It looks like you have a typo in your settings.py. Something like this:

Is using python's any function unoptimal?

The most Pythonic way would be:

Compiler is simply complaining about a build time dependency, cc1 tool should be in your system to build pyodbc.

In Ubuntu you can solve this with

I think you have a few options here, an annotate is not one of them at this time.

Is there a way to somehow 'centralize' the query and have it run only once, and still inserting it into the template file AND having it available within the function of the view?

QuerySets are lazy constructing a queryset will not make a database request, you make a query to the database if you consume the queryset, for example by enumerating over it, calling str(…), repr(…) and len(…) on it, check its truthiness with bool(…) or in an if/elif clause.

If you thus use a context processor that passes the filtered queryset to the template, and you do not use the queryset in a way described above, that will not make a query. Furthermore if the data is passed to the context, it will override the data in the context processor. So you can add it to the context in case you already evaluated it in the view, to prevent making a second database query you thus override this in the context, such that there is no reference to the "other" queryset, and the result is reused.

You need to be careful not to construct a new query if the one is evaluated. For example if qs is an evaluated queryset, you should work with qs again, if you work with qs.all() this will make a new QuerySet that will then make a query to the database.

You should probably check if the reason why you are having those errors is because of duplicate data. If that's the case, I think the ignore_conflicts parameter of bulk_create can solve your problem. It will save every valid entry and ignore those who have duplicate conflict.

Check the doc: https://docs.djangoproject.com/en/3.2/ref/models/querysets/#django.db.models.query.QuerySet.bulk_create

You are starting supervisord manually. service command won't report its status correctly.

I think it will be something like this.

As it turns out, I had to run pip install django-quill-editor in order for the code to work as expected. I am still not sure why the original command did not work but this resolved the issue for me.

You can find the official setup guide for Django quill here: https://github.com/LeeHanYeong/django-quill-editor#setup