Tag Archives: sql

Connecting Django to MSSQL as the database

by Laurence Posted on November 22, 2025

Django + MSSQL works really well thanks to the Microsoft sponsored mssql-django package. The 1.0 release dates back to Jul 2021, and the current release is 1.6 from August 2025. So it looks like Microsoft is not doing their usual … Continue reading →

Posted in Application Development | Tagged databases, django, python, sql | Comments Off

Querying Complex Data in Django with Views

by Laurence Posted on July 16, 2020

Django has a powerful ORM, but like any ORM it suffers when querying data that has complex relationships. Django supports foreign keys and many to many relationships out of the box with ease. Sometimes a report or data feed has … Continue reading →

Posted in Code, Data | Tagged django, MySQL, python, sql | Comments Off

Django Group By Having Query Example

by Laurence Posted on September 16, 2016

Example Group By Having query in Django 1.10. Let’s say you have SQL such as: SELECT DISTINCT user_id, COUNT(*) FROM my_model WHERE tag_id = 15 OR tag_id = 17 GROUP BY user_id HAVING COUNT(*) > 1 The above query finds … Continue reading →

Posted in Code | Tagged django, sql | Comments Off

Example Django Model Count and Group By Query

by Laurence Posted on June 18, 2015

The Django framework abstracts the nitty gritty details of SQL with its Model library (the M in MVC). It is straight forward for standard lookups involving WHERE clauses. 10% of the time I need it to do something fancy like a … Continue reading →

Posted in Application Development, Code | Tagged django, python, scripting, sql | Comments Off

Tag Archives: sql

Connecting Django to MSSQL as the database

Querying Complex Data in Django with Views

Django Group By Having Query Example

Example Django Model Count and Group By Query

Categories

Recent Posts

Tag Archives: sql

Categories

Tags

Recent Posts