Day 26 of hashtag#MeetTheMaintainers
Spreadsheets are great… until they try to be databases.
Databases are great… until you need to be a developer to use them.
Enter Mathesar — a friendly, open-source layer over PostgreSQL that lets anyone view, query, edit, and collaborate on data without writing code.
Built for users of all skill levels, it’s spreadsheet-simple but database-powerful.
Say hi to Pavish Kumar Ramani Gopal, one of the minds behind this magic.
Maintaining data sanity, one open table at a time.
Q: A small brief about your project
Mathesar is a web application that makes working with PostgreSQL databases both simple and powerful. It empowers users of all technical skill levels to view, edit, query, and collaborate on data with a familiar spreadsheet-like interface—no code needed. It’s self hosted, can be deployed in minutes, and works directly with PostgreSQL databases, schemas, and tables without extra abstractions. The project is 100% open source, GPLv3 licensed, and maintained by Mathesar Foundation, a 501(c)(3) nonprofit.
Q: How can someone support your project?
You don’t have to drop everything the moment someone asks for a new feature or bug fix, you can do it at your own pace and follow your own roadmap. People who value your FOSS will step up and contribute, or they’ll wait for it.
Q: Why do you do it? Why do you bother maintaining a FOSS project? What keeps you going?
In my opinion, building software is an art, just like sketching or dancing. The sheer joy of sitting in your room as a teenager, building something just for fun, for yourself, and showing it to your friends, is a feeling I’d never forget. The reason I was able to get into building software, so easily, by myself, is entirely because of FOSS and the culture around it. This eventually lead to my career in software engineering. It always fascinated me that people just built something and gave it to everyone, for free. I understand why. Just like a musicians playing in subway stations, artists drawing on deserted walls, we build software for everyone. Maintaining a FOSS project is my way of giving back to everything the community has given me. The joy you feel when a random person around the world gets excited about something you built, is still surreal. I’m grateful for the fact that I’m able to do this full-time.
Q: If your repo had a theme song, what would it be?
The “Moongil Kaadugale” tamil song, from early 2000s. The lyrics reflect the way I feel about Mathesar, from the freedom seeking sentiment that compares to Mathesar’s open source nature, to the imagery given of a moongil (bamboo) which is resilient and evokes a growth sentiment that compares to Mathesar’s aim to give non-technical people tools to adapt to the data-driven world.
Q: What’s your open-source villain origin story?
Users expecting commercial level support & treatment. We give you what we build for free, if you need something, contribute, don’t demand.
Q: If you had to use one emoji to convey what it is like to be a FOSS maintainer, what would it be?
Just a regular person. Most maintainers thanklessly maintain FOSS from their basement, for fun, which supports massive infrastructure in the real-world (like that xkcd comic).