Skip to content

Instantly share code, notes, and snippets.

View akki's full-sized avatar
🇮🇳
.

Akshesh Doshi akki

🇮🇳
.
44 followers · 31 following
View GitHub Profile
@akki
akki / index statements.rst
Last active July 23, 2016 16:13

INDEX STATEMENTS

POSTGRESQL

  • CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] idx_name ON table_name [ USING method ] ( { col_name | ( expression ) } [ opclass ] [ ASC | DESC ])
  • DROP INDEX [ IF EXISTS ] idx_name [, idx_name1, ...]
@akki
akki / Reworking Django's Indexes.rst
Last active March 28, 2017 05:53
My GSOC 2016 proposal for Django

Reworking Django's Indexes

Table of Contents

  1. Abstract
  2. Motivation
@akki
akki / example.py
Last active May 10, 2016 10:06
#model
class Student(models.Model):
name = models.CharField(max_length=200, db_index=True, unique=True)
branch = models.CharField(max_length=20, db_index=True)
college = models.CharField(max_length=100, unique=True)
year = models.CharField(max_length=100)
def __unicode__(self):
return self.name
@akki
akki / index.rst
Last active March 6, 2016 10:46
Draft for indexes (DEP)

DEP xxxx: Reworking Django's Indexes

DEP

xxxx

Author

Marc Tamlyn, Akshesh Doshi

Status

Draft

Type

Feature

Created

2016-03-03