Goutom Roy goutomroy

Son, Brother, Husband, Engineer, Smoker

43 followers · 172 following

Gdansk, Poland
medium.com/@goutomroy

View GitHub Profile

Recently created

Least recently created

Recently updated

Least recently updated

goutomroy / medium_django_db_optimization_get.py

Created June 7, 2019 21:33


	try:
	one_entry = Entry.objects.get(blog=2000)
	except Entry.DoesNotExist:
	# query did not match to any item.
	pass
	except Entry.MultipleObjectsReturned:
	# query matched multiple items.
	pass
	else:

goutomroy / medium_django_db_optimization_f_expression.py

Last active June 7, 2019 22:48

	# Don't
	for entry in Entry.objects.all():
	entry.likes += 1
	entry.save()

	# Do
	Entry.objects.update(likes=F('likes') + 1)

goutomroy / medium_django_db_optimization_aggregation.py

Last active June 7, 2019 22:52

	# Don't
	most_liked = 0
	for entry in Entry.objects.all():
	if entry.likes > most_liked:
	most_liked = entry.likes
	# Do
	most_liked = Entry.objects.all().aggregate(Max('likes'))['likes__max']

goutomroy / medium_django_db_optimization_count_exist.py

Last active June 7, 2019 22:52


	# Don't
	count = len(Entry.objects.all()) # Evaluates the entire queryset

	# Do
	count = Entry.objects.count() # Executes more efficient SQL to determine count

	# Don't
	qs = Entry.objects.all()
	if qs:

goutomroy / medium_django_db_optimization_delete_update.py

Last active June 7, 2019 22:51

	# Don't.Delete one by one.
	for entry in Entry.objects.all():
	entry.delete()

	# Do.Delete all at once.
	Entry.objects.all().delete()

	# Don't
	for entry in Entry.objects.all():
	entry.likes += 1

goutomroy / medium_django_db_optimization_bulk_create.py

Last active June 8, 2019 11:34


	# Don't
	for i in range(20):
	Blog.objects.create(name="blog"+str(i), headline='tagline'+str(i))

	# Do
	blogs = []
	for i in range(20):
	blogs.append(Blog(name="blog"+str(i), headline='tagline'+str(i)))
	Blog.objects.bulk_create(blogs)

goutomroy / medium_django_db_optimization_related_add.py

Last active June 8, 2019 11:35

	author1 = Author(name='author1')
	author2 = Author(name='author2')
	author3 = Author(name='author3')
	entry = Entry.objects.get(id=1)

	# Don't
	entry.authors.add(author1)
	entry.authors.add(author2)
	entry.authors.add(author3)

goutomroy / medium_django_db_optimization_model.py

Created June 8, 2019 11:22

	class Author(models.Model):
	name = models.CharField(max_length=200)
	email = models.EmailField()

	def __str__(self):
	return self.name

	class Blog(models.Model):
	name = models.CharField(max_length=100)
	tagline = models.TextField()

goutomroy / medium_django_db_optimization_foreign_key_values.py

Last active June 8, 2019 11:54

	# Don't. Needs database hit
	blog_id = Entry.objects.get(id=200).blog.id

	# Do. The foreign key is already cached, so no database hit
	blog_id = Entry.objects.get(id=200).blog_id

	# Do. No database hit
	blog_id = Entry.objects.select_related('blog').get(id=200).blog.id

goutomroy / Step By Step Virtualenv, Django, Postgres, NGINX, Gunicorn, HTTPS on DigitalOcean

Created June 15, 2019 09:55 — forked from davemerwin/Step By Step Virtualenv, Django, Postgres, NGINX, Gunicorn, HTTPS on DigitalOcean

This is every step, in detail, to create a Django App with Postgres, NGINX, Gunicorn, and HTTPS on Digital Ocean. The only thing I don't go over is how to create a droplet and manage the domain.

	Reference:
	Django/Postgres/Nginx/Gunicorn in Ubuntu: https://www.digitalocean.com/community/tutorials/how-to-set-up-django-with-postgres-nginx-and-gunicorn-on-ubuntu-16-04
	Encryption: https://www.digitalocean.com/community/tutorials/how-to-secure-nginx-with-let-s-encrypt-on-ubuntu-16-04

	Where you see "user", "myproject" and "myprojectuser" replace that with what is relevent to what you are working on.

	User Setup

	$ ssh root@SERVER_IP_ADDRESS
	Complete login process

Older Newer