Python

Do you write SQL queries manually or use ORM?

Where can UDP be applied?

Have you encountered cases in practice where database replication affects users or the system?

How would you migrate a table with 20–80 million rows: add a new column and pre-fill it based on another field if migration is not applied?

What objects are in Python?

What will happen to the database if 10,000 updates of the same row are received?

Напиши SQL-запрос, чтобы Найти самое длительное видео из 10 наиболее коротких видео таблицы video (id, duration, author_id). with sbq as ( select id, duration, author_id from video order by duration limit 10 ) select id, duration, author_id from sbq order by duration DESC limit 1 select id, duration, author_id from video order by duration limit 1 offset 9 shortest = Video.objects.order_by('duration').values('id')[:10][-1] result = Video.objects.filter(id__in=Subquery(shortest)).order_by("-duration").first()

Why did you choose Python as your primary development language?

Tell us about OAuth: what kind of technology is it and what is it used for?