# How to Plot an ASCII Bar Chart with SQL

DevFeed: [How to Plot an ASCII Bar Chart with SQL](<https://devfeed.tech/articles/how-to-plot-an-ascii-bar-chart-with-sql-28944.md>)

Original publisher: [Read original article](<https://blog.jooq.org/how-to-plot-an-ascii-bar-chart-with-sql/>)

Author: lukaseder

Published: 2022-09-01T08:25:29Z

Content type: tutorial

Language: en

Sources: [jOOQ](<https://devfeed.tech/sources/jooq.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [data](<https://devfeed.tech/topics/data.md>)

Tags: [ascii-charts](<https://devfeed.tech/tags/ascii-charts.md>), [charts](<https://devfeed.tech/tags/charts.md>), [coding](<https://devfeed.tech/tags/coding.md>), [configuration](<https://devfeed.tech/tags/configuration.md>), [database](<https://devfeed.tech/tags/database.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [plotting](<https://devfeed.tech/tags/plotting.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

A tutorial showing how to use a PostgreSQL SQL query to render ASCII bar charts directly in a SQL editor. It explains the query's data, configuration, and chart-generation sections, using revenue data from the Sakila database and discussing date handling and gap filling.

## Source excerpt

No need for expensive Tableau subscriptions. Ditch Microsoft Excel. Just use native PostgreSQL to quickly visualise your data! Here's an idea I had for a while. As you may know, jOOQ can produce fancy charts from your jOOQ results. But that requires you use jOOQ, and you may not be using jOOQ, because you're not ... Continue reading How to Plot an ASCII Bar Chart with SQL ->