Skip to content

2022-01-02 Code for Japan Social Hack Day


Brent, Joi, Mukesh, and Pavish represented Mathesar at the January 2022 iteration of Code for Japan’s Social Hack Day. Notes from them about the event have been combined below.


Most of the event involved. discussions with other groups and a number of interesting points came up.

Use Cases

  • Mathesar has applicability in “sometimes available DBA” situations. The example use case was tracking disaster supplies. During non-disaster times, it’s likely a DBA could manage the DB and set things up. However, in a disaster it might become necessary for a non-expert to both work with the data and potentially modify the data model. We’ve previously been mostly considering scenarios where the DB management would be through Mathesar except when some functionality wasn’t available, using psql as a fallback. I thought the scenario of a “real” DBA managing the database how they want (e.g., through psql) under normal conditions, but the users being empowered to take control of the DB through Mathesar in an emergency quite compelling.
  • Real life usecases of participants which Mathesar can help solve:
    • Mapping disater recovery stockpiles
    • Conducting public surveys and sharing datasets
  • Listing public restrooms
  • Listing Sake related places, they have their own storage based out of MongoDB.

Feature Requests

  • We came across a scenario where the ability to import a database scheme that enforces some data model would be quite useful. I.e., you would be able to distribute a data model for individual admins to import into their installation and use. It might be worth setting up a user flow for that.
  • Being able to export and import schemas
  • Being able to create users that own a specific set of rows, essentially using Mathesar as a user login & data access portal for higher level applications
  • Being able to detect and maintain consistent Japanese language encoding
  • Maintain consistency of the data, for example date format, preventing null values
  • Granular permissioning

Action Items

  • Set up a bridge between the new #proj-mathesar channel in the Code for Japan Slack and our Matrix server.
  • Set up a section in our wiki for notes on events
  • Set up a team email address for people to contact us

Other Notes

  • People found Mathesar really hard to pronounce
  • We had new contributors who helped & expressed interest in translating our wiki. The About page is already translated to Japanese, see here.