Real Time Charting of PostgreSQL Database » Database Charting Examples

SqlDashboards is longer actively being maintained. It is in limited maintenance mode for existing customers only.
Pulse is the replacement. Pulse allows building interactive data tools fast.

See: A live PostgreSQL dashboard demo of Pulse.

In this demo we will create one table in PostgreSQL and display the data in sqlDashboards. It's intended only as simple proof of how sqlDashboards works with PostgreSQL, we advise viewing our other examples to see the full range of features offered.

Real-Time PostgreSQL Database Charts

Creating our PostgreSQL Stock Database

For this demo we are going to use oracle stock price as our data source. You can download the full SQL. Which includes steps for creating our database:

-- DROP DATABASE stockdb;
CREATE DATABASE stockdb;

-- DROP TABLE stock;

CREATE TABLE stock
(
  sym text NOT NULL,
  date date NOT NULL,
  open double precision NOT NULL,
  high double precision NOT NULL,
  low double precision NOT NULL,
  close double precision NOT NULL,
  volume bigint NOT NULL,
  adjclose double precision NOT NULL
);

Next we insert our data. e.g.

insert into stock values('ORCL','2016-05-02',39.900002,40.43,39.830002,40.299999,10431600,40.299999);
insert into stock values('ORCL','2016-04-29',40.169998,40.169998,39.369999,39.860001,12828700,39.860001);
insert into stock values('ORCL','2016-04-28',40.360001,40.970001,40.169998,40.330002,9024200,40.330002);
insert into stock values('ORCL','2016-04-27',40.509998,41.00,40.509998,40.849998,8740600,40.849998);
insert into stock values('ORCL','2016-04-26',40.82,40.849998,40.43,40.650002,8363800,40.650002);
insert into stock values('ORCL','2016-04-25',40.59,40.830002,40.470001,40.779999,10876200,40.779999);
insert into stock values('ORCL','2016-04-22',40.790001,41.43,40.669998,40.700001,15003300,40.700001);

Creating our PostgreSQL Chart

First add our PostgreSQL server

Then add a time-series chart and we are done.

SELECT date,adjclose FROM stock WHERE sym='ORCL';