From 28ebae4525f35672acd6253b3022bdb8cdc1cbd1 Mon Sep 17 00:00:00 2001 From: James Barnett Date: Wed, 28 Feb 2018 21:32:48 +0000 Subject: Update readme. Fix result parsing bug. Rearrange files - Prefix query result fields with an underscore to avoid clashing with JS builtin property/function names which causes issues with Tabulator - Move html files into their own dir --- README.md | 43 ++++++++++++++++++++++++++++++++++++++++++- 1 file changed, 42 insertions(+), 1 deletion(-) (limited to 'README.md') diff --git a/README.md b/README.md index 52a6337..260cb70 100644 --- a/README.md +++ b/README.md @@ -1 +1,42 @@ -# sql-plus-plus \ No newline at end of file +# SQL++ +[![Build Status](https://travis-ci.org/jamesbarnett91/sql-plus-plus.svg?branch=master)](https://travis-ci.org/jamesbarnett91/sql-plus-plus) + +A simple cross platform SQL editor and statement runner. +Currently for Postgres only, but MySQL and Oracle support planned. + +

+ VS Code in action +

+ +# Features +- Rich editor features. Syntax highlighting, autocomplete, bracket matching etc. +- Cross platform. Linux (.deb), Windows and MacOS binaries available. +- Simple editor interface. Doesn't have a huge array of GUI features like pgAdmin or Toad. For people who prefer a clean way to edit and run SQL. +- Sortable and resizable query results table. + +# Installation +Download one of the binary distributions from the releases page. +Or, to run locally: +```sh +$ git clone https://github.com/jamesbarnett91/sql-plus-plus && cd sql-plus-plus +$ npm install +$ npm start +``` + +# Roadmap +- [x] Store connection config +- [x] Handle multiple simultaneous connections +- [ ] Add schema tree view (listing tables>columns, packages, sequences etc.) +- [ ] Load/Save .sql files +- [ ] Improve autocomplete to be more schema aware +- [ ] Support MySQL +- [ ] Support Oracle +- [ ] Save and display query history +- [ ] CSV download of query results +- [ ] 'Interpreter' mode. Run single queries with a CLI type interface (like Postgres psql and Oracle SQL*Plus) +- [ ] Build .rpms + +# Note +This is just a personal project, and a work in progress. There might be a few bugs in the result parsing, so don't rely on it for anything important unless you enjoy living on the edge. + +Connection details (including passwords) are stored encrypted, but the key is in the source code so it's only a basic level of obfuscation. I wouldn't connect to any prod databases with this. \ No newline at end of file -- cgit v1.2.3