GSoC 2019 Blog

In 2019, I participated in the Google Summer of Code (GSoC) program, during which I implemented the cross-DB JSONField. This is the documentation of my journey.

  1. Revisions

    In this post, I explain how I found a vulnerability in contrib.postgres.fields.JSONField that allowed SQL injections to be performed.

  2. Key, index, and path transforms

    In this post, I explain how I implemented key, index, and path transforms to allow querying with JSON values.

  3. Contains and contained by lookups

    In this post, I explain the containment lookups, i.e. contains and contained_by.

  4. Null values and HasKey lookups

    This week, I polished my code, incorporated some tests from contrib.postgres, and implemented HasKey, HasAnyKeys, and HasKeys lookups on all database backends.

  5. Form field and database feature

    In these past two weeks, I've added a form field for my JSONField. I have also done some improvements to the tests and the field itself.

  6. Writing JSONField from scratch

    This week, I tried to create a unified JSONField from scratch.

  7. Drafting a POC JSONField for SQLite

    Since my project is to bring a cross-DB JSONField, the django-jsonfallback project is very useful for me as a starting point.

  8. Community Bonding and getting started

    In the official GSoC timeline, there's a Community Bonding period on May 7–27.

  9. Initial commit

    Hello, world!