Description
SQL can seem like an obscure but somehow useful language. In this talk we will look into things that SQL can do, sometimes more easily than using python, and how to get it in your ORM, running in your application. During this talk we will use an application analysing the lyrics of my favorite teenage band and show fun examples of these SQL statements, and how to integrate them in your code
Abstract
This talk has as a goal to go into the SQL language and see what ORMs (django, sql alchemy) support them.
At the end of the talk what I would like is:
for developers to understand SQL, and how ORM executes SQL better
to discover fun SQL things that they might not know, and what can or can't be used with simple ORMs call
and if it's not (yet) in the ORM, how can I execute it beautifully
The talk will take an example of analysing song lyrics of an artist, with fun queries on frequency of words over the years, most common patterns etc. There will be a simple django app and I will show how the following can be done, and how it is useful:
joins
group by
aggregations
window functions
lateral joins
ctes
grouping sets