Support for JSON Data Type
- Mentors
- Brent Moran, Pavish
- Organization
- Mathesar
- Technologies
- python, postgresql, javascript, django, svelte
- Topics
- web, database
As a tool aiming to deliver database assets for non-technical personnel, Mathesar should support more data types for the purpose of straightforward operation and easy understanding to meet the different requirements of users. Currently, the data types that Mathesar can support are limited and do not include JSON. Allowing users to read and manipulate data in JSON format can significantly improve the practical value of Mathesar and meet various application scenarios. In this project, we will suport importing, adding, change a database field to a JSON object and enable data validation, modification, and browsing. Also, it will allow the grouping, filtering, and sorting operations based on JSON keys.