qolor

KO | EN

gitlite — search

#javascript #python #hacktoberfest #react #ai #typescript #llm #go #golang #android #machine-learning #rust #deep-learning #linux

★ 16 Open GitHub ↗

An atom package to color your queries!

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# Qolor

[![Join the chat at https://gitter.im/qolor-atom/Lobby](https://badges.gitter.im/qolor-atom/Lobby.svg)](https://gitter.im/qolor-atom/Lobby?utm_source=badge&utm_medium=badge&utm_campaign=pr-badge&utm_content=badge)
![](https://img.shields.io/apm/dm/qolor.svg)
![](https://img.shields.io/apm/v/qolor.svg)
[![Build Status](https://travis-ci.org/DavidLGoldberg/qolor.svg?branch=master)](https://travis-ci.org/DavidLGoldberg/qolor)

An atom package to color your SQL queries!

Qolor applies semantic highlighting to your SQL queries by matching tables to
their aliases.

![Qolor in action!](https://raw.githubusercontent.com/DavidLGoldberg/qolor/master/_images/qolor.png "Qolor - Semantic highlighting for SQL")

All colors of tables are deterministic and based on their name.
They will be the same on any Atom editor anywhere!

Qolor has a few outstanding issues but it's usable and I want to launch it in
the spirit of MVP.
I say it's usable because it doesn't throw errors or pop up the inspector.
If you see it doing this please report ASAP.
Please feel free to create issues of broken coloring cases with screen shots
or text samples (remember to check out the TODO below and the open
[issues](https://github.com/DavidLGoldberg/qolor/issues)).

## Installation

apm install qolor

## Settings

Two stylistic flavors.  Underline (default) or a border box.
The border box is more of a placeholder for now.
I only built it to facilitate pull requests etc.

## Optional Keymap To Toggle

Go to Atom -> Open Your Keymap and enter the following:

```coffeescript

'atom-workspace':
  'ctrl-alt-q': 'qolor:toggle'

# Careful, don't override your existing 'atom-workspace'!

```

## How to Auto Associate File Types in Atom

Go to Atom -> 'Init Script...' and add in:

```coffeescript

# This example associates all mustache files with 'SQL (Mustache)'.
atom.workspace.observeTextEditors (editor) ->
  if editor.getPath()?.match(/\.mustache$/)
    editor.setGrammar(atom.grammars.grammarForScopeName('source.sql.mustache'))

```

## Prior Art / Related Works

I got the idea for Qolor while working with a large query.
We all play a frustrating game of connect the dots while mentally parsing ("grokking") aliases to their tables.  Colors can help you hunt down the aliases.

Later a friend pointed out that a lot of related work in the area of
"semantic highligting" already exists!
Although, I have yet to find one that does this semantic highlighting for SQL in this table to alias manner.
Let me know if it does!

Here are some of the related links:

*   [Coding in Color](https://medium.com/programming-ideas-tutorial-and-experience/coding-in-color-3a6db2743a1e)
*   [Semantic Highlighting in KDevelop](http://zwabel.wordpress.com/2009/01/08/c-ide-evolution-from-syntax-highlighting-to-semantic-highlighting/)
*   [Sublime-Colorcoder](https://github.com/vprimachenko/Sublime-Colorcoder)
*   [recognizer (Brackets)](https://github.com/equiet/recognizer)
*   [Polychromatic (Xcode)](https://github.com/kolinkrewinkel/Polychromatic)
*   [language-javascript-semantic (Atom)](https://atom.io/packages/language-javascript-semantic)

## How it works

Qolor uses the [language-sql](https://github.com/atom/language-sql)
grammar built into Atom (actually it evolved from textmate/sublime).
The code performs a double pass.
First pass for the table names and second pass for the aliases.

I don't know of any SQL parsers in node usable for this project.

The code is ugly.  `language-sql` suffices for syntax coloring, but it's tokens
aren't always accurate. I try to make a layer of rules on top.

It should work for most cases, but please report any issues.

Your performance should be unaffected because qolor utilizes the debounced api
for observing the grammar and because well, computers are fast.

## TODO

*   [BUG] Cartesian products / cross joins don't work.
They are particularly troublesome without aliases.  This is due to existing
limitations in the `language-sql` grammar.  I have an idea of how to address
this but prefer to see if anyone has a suggestion of how to integrate
a real parser.

*   Custom styling of underline / border.

*   Better handling of colors.  Possibly hue blending etc.  Leverage theme
information.  I still want these to be deterministic but for example,
perhaps a marginal shift of the colors to play nicely with the themes.
Pull requests?

*   Jump to and from matching tables and aliases under cursor.

*   List number of references in the status bar.

*   Add qolor to the minimap.

*   Stats report of all tables or projected fields.
Maybe visual like a minimap?  Query execution plans etc.

*   Some treatment of matching or applicable fields names?

## My other Atom package :)

*   [Jumpy](https://atom.io/packages/jumpy)

## My VS Code version of Jumpy :))

*   [Jumpy2](https://marketplace.visualstudio.com/items?itemName=DavidLGoldberg.jumpy2) (Jumpy for VS Code from it's original author!)

qolor

Explore Similar Repositories

Was this content helpful?

Recent Feedback

Download README