Mathesar

An intuitive and accessible data manipulation toolkit for anyone that works with information.

tags: hackday-projects,hackday,open-source

プロジェクト概要 Overview：

Mathesar is an open source software project to help users store, organize, visualize, and collaborate on data. Our goal is to provide an intuitive user interface for users without any pre-existing knowledge of database concepts. Mathesar is backed by mature database software, which gives it the flexibility to be interoperable with thousands of other existing tools and applications.

Potential use cases for Mathesar include publishing and exploring public datasets, running business processes such inventory management and project tracking, providing a ready-made interface for speedy data entry and custom reporting, collecting and processing data from large groups of people, simple data cleaning and analysis, and automatic web API generation. We think it will be useful for a variety of Civic Tech applications.

Mathesar is not yet ready, we are looking for contributors to help us get to our first release in mid-2022.

Why? (なぜ始めたのか)

Data is valuable and shouldn’t be tied to using a specific proprietary service. CWe want to build an open-source data toolkit that combines a spreadsheet's ease-of-use with a database's integrity and modeling capabilities without compromising on privacy and interoperability.

Read more on our wiki

Some issues caused by using spreadsheets in Civic Tech applications that Mathesar can help solve:

• Covid-19 results lost in England due to spreadsheet limitations
• Incorrect economic policies due to a spreadsheet error from prominent economists
• Scientists rename human genes to stop spreadsheet applications from misreading them

Development (開発・バージョン)

• We are still in early development phase and will release an alpha version of the project by mid-2022.
• Our roadmap to release

Contributers

• Mathesar team.
• We have ~25 contributors total

Contact

• GitHub: https://github.com/centerofci/mathesar
• Chat: Please join our Matrix channels

---

CodeForJapan Activity log

2022/01/22 ハックデー

プロジェクトメンバー Contributers representing project：

• Brent Moran
• Joi Ito
• Mukesh Murali
• Pavish Kumar Ramani Gopal

今日の作業内容 Today's Mission：

We have selected a few issues from our roadmap that are easy for new contributors. The goal is to open pull requests to solve as many of the issues as we can by the end of the day.

• Frontend Feature: Create Menu component
• Frontend Enhancement: Wait until user is done editing a cell before saving
• Frontend Enhancement: Clicking on the name in 'Manage Schemas' page should set is as the current schema and redirect to base page
• Frontend Bug: Text overflow should be represented by ellipsis in schema selector
• Backend API change: Modify constraints API to use column id instead of column name
• Backend Feature: sort_by API param should sort strings by unicode collation instead of byte value
• Backend Bug: Tests that depend on schema fixture in import/test_csv throws up integrity error when run individually
• Backend Bug: Multiple Tables with the same OID
• Feel free to find any issue that interests you from our Github issues section

If you're interested in continuing to work on the project after today, you are welcome to join our community.

こんな人にきて欲しい People needed：

• Those who are familiar with or willing to learn any of the following technologies:
  • JavaScript
  • Python
  • PostgreSQL
• Those who are excited about Mathesar's goals.
• We also encourage beginners with low experience, who would like to contribute to open-source.

本日の成果 Today's Outcome：

• To be filled after the event