Have you, a sensible developer, noticed how horribly bad LLM-generated code is?

Then you should have a pretty good idea how I, a database administrator, feel when I see the queries your ORM has generated.

#SQL
#Database
#LLM
#ORM

Earlier in Djangonaut Space we had a great talk by Simon Charette "Demystifying the Django ORM"

A very interesting Q&A followed

The session was recorded, and I hope it'll be published

Photo permission requested by Priya

CC @djangonaut

I just wrote a single QuerySet annotation containing Coalesce(), Cast(), Sum(), Count(), Round() and NullIf() I went back to my roots #django #orm

Psycopg 3.2 has been released
https://www.psycopg.org/articles/2024/06/30/psycopg-32-released/

I can't wait to test it with Django 5.1b1

#PsycoPG #Python #PostgreSQL #Postgres #Django #ORM

CC @psycopg

Tailwind is to CSS as ORMs are to SQL; a red flag that tells you that someone on the team doesn't understand how to properly use one of the core technologies of the platform.

Anže Pečar is presenting the talk "Django, SQLite, and Production" at DjangoCon Europe 2024

#DjangoConEurope2024 #DjangoConEurope #DjangoCon #Django #SQLite #ORM #Fedidevs

CC @djangoconeurope @django @anze3db @fedidevs

I published my latest article in the series on database-generated columns, using PostgGIS, GeoDjango, and the GeneratedField added in Django 5.0

Send feedback
https://www.paulox.net/2023/12/11/database-generated-columns-part-3-geodjango-and-postgis/

Django 5.0 has been released

After months of work, everyone can use this great new version

My favorite features are:
• generated fields
• database default values
• prefetch related for generic foreign keys

Which are your favorite features?
https://www.djangoproject.com/weblog/2023/dec/04/django-50-released/

I published my second article about database generated columns, using PostgreSQL and new generated fields added in Django 5.0

I'd be very happy to have your feedback
https://www.paulox.net/2023/11/24/database-generated-columns-part-2-django-and-postgresql/

After Django 5.0rc1 release, I updated my generated fields article

I also tried to improve the titles as suggested by @adamchainz whom I thank

All feedback is welcome

https://www.paulox.net/2023/11/07/database-generated-columns-part-1-django-and-sqlite/

I published an introduction to database generated columns, using SQLite and the new GeneratedField added in Django 5.0

I'd be very happy to have your feedback on my article

https://www.paulox.net/2023/11/07/database-generated-columns-part-1-django-and-sqlite/

I didn't know about this SQLite fork. ⎇

I wonder if it can be used with the same SQLite backend for the Django ORM.

You can read more about our goals and motivation in the announcement article
https://itnext.io/sqlite-qemu-all-over-again-aedad19c9a1c

I found my second bug in Django 5.0 after the feature freeze

It's related to GeneratedField and DecimalField and maybe you can help to fix it
https://code.djangoproject.com/ticket/34877

I found my first bug in Django 5.0 after the feature freeze

It's related to GeneratedField and JSONField and maybe you can help to fix it
https://code.djangoproject.com/ticket/34861

fluffy rambles: Publ's insurmountable technical debt https://beesbuzz.biz/blog/8325-Publs-insurmountable-technical-debt #Python #Blog #Publ #SQL #ORM

Laurent Tramoy is holding the workshop "Mastering the Django ORM with PostgreSQL" at DjangoCon Europe 2023 in Edinburgh

#DjangoCon #DjangoConEU #DjangoConEurope #Django #ORM #Postgres #PostgreSQL

CC @djangoconeurope

https://pretalx.com/djangocon-europe-2023/talk/DK3XET/

@actuallyautistic

There is a term, "impedance mismatch", in #SoftwareEngineering, previously borrowed from electrical engineering, which is used to describe the problems that are often run into when using an #ORM. (Fellow geeks may recognize this acronym. The rest of you, don't sweat it; I'll explain the part that matters.)

In lay terms, imagine trying to copy a shape built with tinkertoys, but you have to use Legos instead. While you may be able to get the general shape right, there are going to be a lot of differences, not only in the details of the surface, but in the very approach you take to construct the shape. This failure to line up between the two methods of constructing shapes captures the essence of what we mean when we say #ImpedanceMismatch.

I think an impedance mismatch is the core reason that #autistic and non-autistic people have trouble communicating with each other. We are using different elemental building blocks to form our thoughts. They don't line up.

The new @psycopg v3 backend for @django 4.2 is quite ready

It would be very useful if you could test it in your own project to find any errors and measure variations in performance

You can already find some tests in the PR

#Django #Psycopg #PostgreSQL #Async #ORM #Database #Python #Postgres

https://github.com/django/django/pull/15687