2022 GSoC Project Work Summary - Jinxiao Li

[Jinxiao Li]

Hey all, 

I am Jinxiao Li, a lucky Mathesar contributor at Google Summer of Code 2022. During this three-month coding period, I am delighted to work with @Brent Moran and @Pavish Kumar Ramani Gopal to implement Mathesar database functions for JSON data types. I am very grateful for the support of every team member and the enjoyable time I spent on this project.

The works are listed below at the Github links and you can also have a look at the project description here. We implemented two main custom types for this goal: Mathesar JSON array and Mathesar JSON object. Most of the functions are settled down while a few are in progress but can be completed very soon. Feel free to leave comments and suggestions.

JSON type reading and casting implementation

• Main implementation: https://github.com/centerofci/mathesar/pull/1443
  
• Minor issue fixes: https://github.com/centerofci/mathesar/pull/1474

JSON type sorting implementation

• Sorting for JSON array type: https://github.com/centerofci/mathesar/pull/1482
• Sorting for JSON object type: https://github.com/centerofci/mathesar/pull/1565

JSON type filtering implementation

• JSON array length equals function as well as tests: https://github.com/centerofci/mathesar/pull/1493
• JSON array length <, <=, >, >= functions as well as tests: https://github.com/centerofci/mathesar/pull/1528
• JSON object filtering functions (in progress): https://github.com/centerofci/mathesar/pull/1606

Other issue fixes

• Fix reference column bug when deleted: https://github.com/centerofci/mathesar/pull/1275
• Fix loading skeleton issue when rows are deleted: https://github.com/centerofci/mathesar/pull/1351

Jinxiao Li

ruclij...@163.com

[Kriti Godey]

Thanks for sharing, Jinxiao!

Thank you also for all your hard work on this project, it is really great to have JSON support in the product.

[Kriti Godey]

I put this project report on our wiki here: https://wiki.mathesar.org/en/engineering/reports/gsoc-2022-json-type