Django SQL Dashboard

Dev tools

database query dashboard

SHOW HN2021

Django SQL Dashboard

This is my new project that adds an interactive read-only SQL querying interface to any Django+PostgreSQL…

django-sql-dashboard.datasette.io

#django#sql dashboard#postgresql#read-only sql#business intelligence

204points
27comments
#225of 2,533 in 2021
Top 9%of 2021 by points

How HN took it

LovedMost comments that take a side are positive

10 positive, 6 neutral or asking, 0 mixed, 0 critical, out of 16 comments about the project. Thread score +0.48.

Idea: 4 for, 0 againstDesign: 3 for, 0 against

The thread, comment by comment

Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.

positive neutral or mixed critical about another commenter or something else the maker

What HN said

What people liked

  • Useful lightweight alternative for ad-hoc reporting and visualisation

    From 3 comments
    • Amazing project! It's the tool that I've been missing for many years. I was a contractor for almost 7 years and most of my clients were small companies that were paying for…
      artiscode on HN
    • Yeah, this would have replaced a fairly expensive SaaS subscription at my old job which simply allowed business-side folks the ability to run SQL queries safely (in theory).
      tclancy on HN
    • Nice work, thanks for sharing. The ability to create visualizations is a great feature.
      nickphx on HN
  • Minimal, clean design

    From 2 comments
    • I love the minimal design. Which CSS framework do you use? Or is it self created? The buttons also reminded me of Goat Counter which also employs the minimal CSS things
      avinassh on HN
    • I use Django SQL Explorer pretty much every day. It's been wonderful for my needs. I'm also very happy to see django sql dashboard as an alternative and in particular the…
      bytesmith on HN

Objections

  • Much less sophisticated than Metabase

    From 1 comment

Requests

  • A browser-based Django shell with permissions

    From 2 comments
    • This looks great! In a similar vein - does anyone know of a project that will allow for a Django shell in the browser? I know Jupyter exists - but a solution like this with the…
      dacox on HN
    • That is an excellent idea. The number of times I've fired up an SSH shell on my phone to do a quick fix for a client...
      photojosh on HN

Questions

  • How does it compare to Metabase

    From 1 comment
    • Using the Django auth is neat, how would you compare this to Metabase?
      vidar on HN
  • Why use SQL when Django abstracts it away

    From 1 comment
    • Naive question from someone with a superficial understanding of Django- I thought the advantage of Django was to abstract away from SQL through Class/Model so you don't need to…
      stuartbman on HN

Alternatives named

  • Django SQL Explorer

    From 1 comment
    • Very cool! I wrote Django SQL Explorer[0], and this looks very similar in spirit, but an emphasis on visualization that Explorer does not have (to the extent it has a focus, it's…
      numlocked on HN
  • Metabase

    From 2 comments
    • Metabase – https://www.metabase.com/
      pgt on HN
    • Using the Django auth is neat, how would you compare this to Metabase?
      vidar on HN
  • Redash

    From 1 comment
    • This is cool! I've had a lot of success with http://redash.io, which is a similar (though much more complex) project. SQL backend +visualizations can be really powerful and…
      roywiggins on HN
  • Blazer

    From 1 comment
    • Seems nice. And, if you are in the Ruby (on Rails) ecosystem, I can highly recommend Blazer https://github.com/ankane/blazer
      stanislavb on HN
  • Django Data Interrogator

    From 1 comment
    • If you don't want to give your users direct access to your database using SQL, I wrote a little tool that basically exposes the ORM as a user interface and lets users query that…
      legostormtroopr on HN

Category, keywords, summaries and labels on this page were made by AI (Thread Reader v2) and not checked by hand. Each point links to the comments it came from.

Add a badge to your READMEShown on HackerShow
[![Shown on HackerShow](https://hackershow.org/badge.svg)](https://hackershow.org/show/27107428)