Presented by:

242885f7716f6869ae5d3ca66667eaee

Pavish Kumar R

from Mathesar

Generalist, open-source enthusiast, and loves identifying problems and building solutions.

Currently building Mathesar, an open-source project that aims to make PostgreSQL accessible to users of all skill levels.

No video of the event yet, sorry!

Every application developer and DB admin comes across the scenario where you're expected to be an intermediary between the database and your non-technical colleagues.

Have you ever faced these situations:

  • Run queries to answer questions for business teams, and they often have a lot of questions.
  • Receive urgent emails asking us to fix something in production data, because a business team member made a mistake in the data they provided to you earlier.
  • Receive large spreadsheets that you have to end up cleaning and importing into the database, and you continue receiving updates in form of spreadsheets.
  • End up building custom in-house products to make it easier for your non-technical colleagues to edit values of a single column in a table.

All of these are tasks that hinder us from doing the jobs we were hired to do, supporting technical infrastructure. In an ideal world, we'd expect our non-technical colleagues to be able to use the database themselves, and PostgreSQL has elaborate access mechanisms for that very purpose, but that's still a distant dream.

How do we bridge this barrier and make the power of databases accessible to non-technical people (and make life easier for developers)?

With databases being around for over six decades, and PostgreSQL being in active development for over 35 years, why is it only accessible to people who are tech savvy?

Why isn't using a database as common and popular as using a spreadsheet?

My talk will take a stab at answering these questions, provide reasons why it's important to make business teams know what a database is, showcase lessons learnt from interacting with users of all skill levels, and provide ideas on things you can do to make your non-technical colleagues start using databases in a way that wouldn't affect your workflow.

I'll also talk about tools that you can use to achieve these outcomes, including (but not limited to) Mathesar, the open source project I work on.

Date:
2024 March 1 - 14:45
Duration:
40 min
Room:
Robusta + Arabica
Conference:
PGConf India, 2024
Language:
Track:
Case Study
Difficulty:
Easy

Happening at the same time:

  1. Real Time Data processing using Go and PostgreSQL
  2. Start Time:
    2024 March 1 14:45

    Room:
    Grand Victoria A

  3. Harnessing the power of Postgres for GIS
  4. Start Time:
    2024 March 1 14:45

    Room:
    Grand Victoria B