komsit37 / sublime-q-2

sublime text plugin for q/kdb
MIT License
5 stars 0 forks source link

Use Sublime Text 2 as q IDE

DEPRECATED: A new version which works with sublime text 3 is available here. I won't be updating this version anymore. Use the new version unless you really need sublime text 2.

Cmd + Enter or Cmd + e to send highlighted text or block text.
Cmd + Alt + s to quickly switch between connections (configured in Preferences->Package Settings->sublime-q) Cmd + Alt + c to edit selected kdb connection
Syntax higlighing (based on kimtang's https://github.com/kimtang/sublime-q)
shows rows, column, time at status bar

Image of screenshot

Use Exxeleron's python q api http://www.devnet.de/exxeleron/qpython
Only works with Sublime 2.

Installation

Clone this git repository into your Sublime Text 2/Packages or Sublime Text 3/Packages directory.

git clone https://github.com/komsit37/sublime-q.git

Then you will need to download and install numpy 1.8 for python2.6. OSX yosemite comes with default numpy 1.6 for python 2.6

*You need Python 2.6 since this is what sublime text uses Installing the correct version of numpy in osx is a pain since it came with numpy 1.6. I removed numpy 1.6 first (by going to your python2.6 package folder and remove the folder directly). I downloaded .tar.gz from http://sourceforge.net/projects/numpy/files/NumPy/1.8.1/ and then run (if i remembered correctly)

python2.6 setup.py install

Only tested on OSX

Troubleshoot

to check your numpy version and installed directory, open console from sublime text cmd + ` (sublimetext may use different versions from your osx terminal)

import numpy
numpy.version
'1.6.2'
numpy.file
'/System/Library/Frameworks/Python.framework/Versions/2.6/Extras/lib/python/numpy/init.pyc'

to remove numpy 1.6.2
open terminal
cd /System/Library/Frameworks/Python.framework/Versions/2.6/Extras/lib/python/
sudo mv numpy numpy_old

Update: Since OSX El Captain, you can't remove default python package with root. You will need to reboot into recovery mode (Command-R at startup logo), and run csrutil disable in terminal. see below link for more details https://apple.stackexchange.com/questions/193368/what-is-the-rootless-feature-in-el-capitan-really