LearnDB is a web front-end to Postgres databases. It allows users to run queries on any Posgres server. It also allows users to change their password on any Postgres server.
LearnDB is still in early stages of development, but the features listed above are functional.
At present, LearnDB is composed of two separate servers which are integrated such that end users do not need to launch the servers separately.
- Query server: A query server to let users connect to any Postgres database and query it. This sever combines pgweb with a proxy server.
- Change-Password server: A customer Node.Js server to let users change password. The goal is to evolve this Node.js server to provide all the services.
The following figure depicts the current architecture.
LearnDB uses Node.js, pgweb, and Postgres, all of which can be run on any operating system. The proxy server uses Microsoft Internet Information Server (IIS), which requires Windows server.
The Query server and Change-Password server are installed and run separately.
See the README in directory src/pgweb_proxy for instructions to install
the Query server.
The Change-Password server is a Node.js Express web server (tested with LTS Version 10.16.2). Follow these steps to install and run the server:
- Install Node.js with npm. Use the installer defaults.
- Open a terminal or command window (as administrator if using Windows)
- Install the server by running the following command from the
srcdirectory in your clone of this repo:npm install - Start the server using the following command:
npm start
By default, the Change-Password server listens on localhost:5000, unless
a different IP address and port are specified in code or in the environment.
The four components--proxy, pgweb, Change-Password server, and Postgres-- could all be run on the same machine, or they could each be run on a different machine.
LearnDB is developed at the Data Science & Systems Lab (DASSL, read dazzle).
LearnDB was conceived by and is designed by Sean Murthy. The following undergraduate students at Western Connecticut State University contributed to the implementation:
Contributions and ideas are welcome. Please mail a summary of your thoughts to the address shown on the DASSL web site. Please mention "LearnDB" in the subject line.
LearnDB is distributed under Creative Commons License BY-NC-SA 4.0.
PROVIDED AS IS. NO WARRANTIES EXPRESSED OR IMPLIED. USE AT YOUR OWN RISK.