Mathesar

Mentors: Student: Aritra Majumder

The Mathesar Data Explorer enables an action called “Summarize” that let a user view a summary of their data, which is in fact an aggregation of some column(s), grouped by some other column(s). Currently, the only possible aggregation functions are counting or listing. This proposal aims that at the end of GSoC '23 period, there will be more aggregation functions (Mean, Median, Sum, Min, Max) will be available to the user to transform the data.

Mentors: Student: Anshuman Maurya

Mathesar is an open-source, web-based database management tool that is easy to use, flexible, and scalable. It provides users a simple, intuitive interface for managing their databases, including creating and editing tables, defining relationships between tables, and querying data. Mathesar UI allows users to import data from CSV and TSV files. We aim to expand this functionality into importing JSON and Excel files too. The project will allow users to import JSON and Excel files and create a table from the imported data. The user can preview the table, remove/rename columns, change data types, and more. If the imported file is not in a suitable format for creating a table, we will develop algorithms to convert the file into a suitable format. If the algorithm doesn’t work, the system will refuse to import the file and give the user a readable error.

Mentors: Student: Anish Surendra Umale

Currently, Mathesar only supports creating a new table when a CSV or TSV file is imported. This project aims to enhance the capability of Mathesar’s APIs and database to support importing CSV data into an existing table for a seamless user experience. The above will be achieved by using a mix of already implemented APIs with some tweaks and implementation of some additional API endpoints along with some methods to accompany them.

Mentors: Student: Yurii Palaida

Implement a "dependency graph" functionality that will consist of API endpoints for querying dependents for specific database objects and a UI for displaying those in the form of visual graphs. It’ll serve two main goals: - Inform the user about existing dependents on the database objects that he is about to delete or modify - A separate page that can be available for experienced users

Mentors: Student: Jinxiao Li

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.