Using Grist to Manage Publications + App Data

Industry. Publications, Personalize City Guides

Creator. Stephen S., Owner

Finding a simple self-hosted, relational data tool

Stephen and his team manage a lot of documentary data such as statistics, geolocated records, reference images, and maps. As the founder of OurQuietPlaces, a website and app in-development that will help busy urbanites find moments of respite and cultural enrichment, he’s tasked with designing and maintaining the company’s data infrastructure and organizing research and publication. For the app’s core data, he’d found a system he liked using technical tools, database, and applications, self-hosted on several Linux servers, that met his tech-forward needs. But the rest of the team needed an easy-to-use, flexible and collaborative data tool to handle various types of data such as inventories, worksheets, publishing plans, and more. It wouldn’t be cost or time effective for Stephen to build GUIs on the hosted database to meet those needs. Members of the team needed to be empowered to create and edit their own documents.

The spreadsheet made sense, but quickly ran into problems. It was unstructured, there was no way to relate data in different tables, and complicated sheets became a nightmare to modify and share. Then they tried Airtable for its relational-spreadsheet hybrid approach, which worked well, but was expensive. Worse yet, when Stephen tried to move data off of Airtable, the experience was painful. Data could only be exported as CSV tables, they lost their relational structure, and some data types did not convert well, leading to data loss. He spent days piecing it all back together.

The more I use Grist, the more I LOVE it. I have been surveying self-hosted database GUI tools, and I was consistently disappointed with their shortcomings or bugginess. Grist is the first to have tilted the balance the other way.

Stephen S.

Burned by a bad experience, Stephen looked for a spreadsheet-database product that would not sequester company data, was easy to use, robust, and low cost. If it could be self-hosted, all the better. He tried dozens of startup products such as Retool and nocoDB, but rejected all those tools either because they were very recently developed and often buggy, limited in features, or increased his database overhead. His exhaustive research led him to Grist, which met and exceeded his expectations.

Specifically, here’s what I love about Grist:

  • It is open source and self-hostable using Docker.
  • It is opinionated, providing a totally new way to manage data that is quite disruptive, but convincing, even for database specialists.
  • Thanks to Grist’s use of SQLite, data is portable and not sequestered.
  • It is modest. Grist keeps it simple and does what it does superlatively.
  • It requires only a soft learning curve with lots of potential to dig deeper with outstanding documentation.

Stephen S.

Today, OurQuietPlaces uses grist-core, the open source version of Grist, to manage its data inventory, hardware inventory, technical infrastructure (hosted apps, storage), publication schedule and writers’ assignments. Grist has been a key tool for this remote team of four who needed a real collaboration tool that made sharing easy.

Share This Post

Share on facebook
Share on linkedin
Share on twitter
Share on email

More To Explore

Using Grist to Manage Publications + App Data

Industry. Publications, Personalize City Guides Creator. Stephen S., Owner Finding a simple self-hosted, relational data tool Stephen and his team manage a lot of documentary

Grist v. Airtable

We get asked all the time how Grist compares to Airtable. Both products straddle the line between spreadsheet and relational database, and have a variety