Difference between revisions of "Programming/Kdb/Installing kdb"
Tag: Manual revert |
|||
Line 1: | Line 1: | ||
=Kdb+/q= | =Kdb+/q= | ||
'''Kdb+/q''' can be downloaded from https://kx.com/developers/download-licenses/ | '''Kdb+/q''' can be downloaded from <span class="plainlinks">https://kx.com/developers/download-licenses/</span>. | ||
In particular, there are two free versions of kdb+/q: the 32 Bit Personal Edition and the 64 Bit Personal Edition (On-Demand). | In particular, there are two free versions of kdb+/q: the 32 Bit Personal Edition and the 64 Bit Personal Edition (On-Demand). | ||
Line 25: | Line 25: | ||
* Linux/Mac/Windows versions are available. | * Linux/Mac/Windows versions are available. | ||
The 32 Bit Personal Edition can be downloaded immediately, whereas for the 64 Bit Personal Edition (On-Demand) you would need to request a license. Both editions are available via https://kx.com/developers/download-licenses/ | The 32 Bit Personal Edition can be downloaded immediately, whereas for the 64 Bit Personal Edition (On-Demand) you would need to request a license. Both editions are available via <span class="plainlinks">https://kx.com/developers/download-licenses/</span>. | ||
=Integrated development environments (IDEs)= | =Integrated development environments (IDEs)= | ||
Line 33: | Line 33: | ||
==Q Insight Pad (Windows-only)== | ==Q Insight Pad (Windows-only)== | ||
[http://www.qinsightpad.com/ Q Insight Pad] (sometimes referred to simply as qPad) by [http://olegzakharov1974.narod.ru/ Oleg G. Zakharov] is a kdb+ client, written in C++ to run under Windows; as a result, it is fast, memory-efficient and easy to use. The author makes a special emphasis on providing a Windows-style GUI that is visual, simple and intuitive. | <span class="plainlinks">[http://www.qinsightpad.com/ Q Insight Pad]</span> (sometimes referred to simply as qPad) by <span class="plainlinks">[http://olegzakharov1974.narod.ru/ Oleg G. Zakharov]</span> is a kdb+ client, written in C++ to run under Windows; as a result, it is fast, memory-efficient and easy to use. The author makes a special emphasis on providing a Windows-style GUI that is visual, simple and intuitive. | ||
Q Insight Pad provides simple but useful visualization capabilities. | Q Insight Pad provides simple but useful visualization capabilities. | ||
An unregistered but fully functional version (working with free versions of q) can be downloaded for free from http://www.qinsightpad.com/ | An unregistered but fully functional version (working with free versions of q) can be downloaded for free from <span class="plainlinks">http://www.qinsightpad.com/</span>. | ||
This version expires every 3 months. If you want to license Q Insight Pad for use in your organization, contact the author: http://www.qinsightpad.com/contact.html | This version expires every 3 months. If you want to license Q Insight Pad for use in your organization, contact the author: <span class="plainlinks">http://www.qinsightpad.com/contact.html</span>. | ||
==qStudio== | ==qStudio== | ||
<span class="plainlinks">[http://www.timestored.com/qstudio/ qStudio]</span> by [http://www.timestored.com/ TimeStored] is an intelligent code editor for kdb+/q that provides: | <span class="plainlinks">[http://www.timestored.com/qstudio/ qStudio]</span> by <span class="plainlinks">[http://www.timestored.com/ TimeStored]</span> is an intelligent code editor for kdb+/q that provides: | ||
* q syntax highlighting; | * q syntax highlighting; | ||
* q code completion; | * q code completion; | ||
Line 55: | Line 55: | ||
** qUnit — a unit testing framework for kdb. | ** qUnit — a unit testing framework for kdb. | ||
qStudio can be downloaded from http://www.timestored.com/qstudio/ | qStudio can be downloaded from <span class="plainlinks">http://www.timestored.com/qstudio/</span>. | ||
qStudio Pro can be purchased from http://www.timestored.com/qstudio/buy | qStudio Pro can be purchased from <span class="plainlinks">http://www.timestored.com/qstudio/buy</span>. | ||
This application requires a Java Runtime Environment 1.8.0_66 or above. | This application requires a Java Runtime Environment 1.8.0_66 or above. | ||
Line 63: | Line 63: | ||
==Studio for kdb+== | ==Studio for kdb+== | ||
[https://github.com/CharlesSkelton/studio Studio for kdb+] is a rapid development environment for kdb+. In the style of commonly used SQL clients, it allows you to | <span class="plainlinks">[https://github.com/CharlesSkelton/studio Studio for kdb+]</span> is a rapid development environment for kdb+. In the style of commonly used SQL clients, it allows you to | ||
* connect to kdb+ processes; | * connect to kdb+ processes; | ||
* execute selected text from the editor window; | * execute selected text from the editor window; | ||
Line 80: | Line 80: | ||
* immediate charting of grid data. | * immediate charting of grid data. | ||
Studio for kdb+ is free, provided under the Apache 2 license, and can be downloaded from https://github.com/CharlesSkelton/studio | Studio for kdb+ is free, provided under the Apache 2 license, and can be downloaded from <span class="plainlinks">https://github.com/CharlesSkelton/studio</span>. | ||
The program is portable and comes in the form of a JAR file. You need the Java runtime environment (JRE) to run it: | The program is portable and comes in the form of a JAR file. You need the Java runtime environment (JRE) to run it: |
Revision as of 14:25, 17 June 2021
Kdb+/q
Kdb+/q can be downloaded from https://kx.com/developers/download-licenses/.
In particular, there are two free versions of kdb+/q: the 32 Bit Personal Edition and the 64 Bit Personal Edition (On-Demand).
Both editions are licensed for personal use.
The 32 Bit Personal Edition:
- is permitted to run on-premises;
- is permitted to run on cloud;
- provides access to KX Fusion interfaces and integrations;
- provides access to community support;
- Linux/Mac/Windows/Raspberry pi versions are available.
The main limitation of the 32 Bit Personal Edition and, more generally, of any 32-bit program, is that it can only ever use up to 4 GB of memory. That's due to the 32-bit address space, since 2^32 = 4,294,967,296 bytes. For some use cases this may be a serious limitation.
The 64 Bit Personal Edition (On-Demand):
- requires "always on" internet connection;
- is permitted to run on-premises;
- is compatible with KX Developer and KX Dashboards Direct;
- provides access to KX Fusion interfaces and integrations;
- provides access to community support;
- gives regular access to upgrades;
- Linux/Mac/Windows versions are available.
The 32 Bit Personal Edition can be downloaded immediately, whereas for the 64 Bit Personal Edition (On-Demand) you would need to request a license. Both editions are available via https://kx.com/developers/download-licenses/.
Integrated development environments (IDEs)
There is no one-size-fits-all IDE for kdb+/q. Therefore we recommend that the reader download some/all of the tools listed above and give them a try.
Q Insight Pad (Windows-only)
Q Insight Pad (sometimes referred to simply as qPad) by Oleg G. Zakharov is a kdb+ client, written in C++ to run under Windows; as a result, it is fast, memory-efficient and easy to use. The author makes a special emphasis on providing a Windows-style GUI that is visual, simple and intuitive.
Q Insight Pad provides simple but useful visualization capabilities.
An unregistered but fully functional version (working with free versions of q) can be downloaded for free from http://www.qinsightpad.com/.
This version expires every 3 months. If you want to license Q Insight Pad for use in your organization, contact the author: http://www.qinsightpad.com/contact.html.
qStudio
qStudio by TimeStored is an intelligent code editor for kdb+/q that provides:
- q syntax highlighting;
- q code completion;
- ability to query servers direct from the editor;
- server browser for viewing server objects;
- charts for displaying your data;
- database management tools to modify your database structure;
- a data loader for importing large data files easily;
- language programming tools to increase programmer productivity:
- qDoc for generating HTML documentation;
- qUnit — a unit testing framework for kdb.
qStudio can be downloaded from http://www.timestored.com/qstudio/.
qStudio Pro can be purchased from http://www.timestored.com/qstudio/buy.
This application requires a Java Runtime Environment 1.8.0_66 or above.
Studio for kdb+
Studio for kdb+ is a rapid development environment for kdb+. In the style of commonly used SQL clients, it allows you to
- connect to kdb+ processes;
- execute selected text from the editor window;
- view results as tables, charts, or classic console style.
The editor component is based on the NetBeans editor component, and includes the following features:
- find/search/replace;
- cut/copy/paste;
- undo/redo;
- syntax highlighting for the q language;
- most recent files menu.
Additionally, the application features:
- export to Excel;
- drag and drop;
- immediate charting of grid data.
Studio for kdb+ is free, provided under the Apache 2 license, and can be downloaded from https://github.com/CharlesSkelton/studio.
The program is portable and comes in the form of a JAR file. You need the Java runtime environment (JRE) to run it:
java -jar studio.jar