Programming/Kdb/Installing kdb - Revision history

Admin at 22:11, 21 December 2021

2021-12-21T22:11:46Z

← Older revision		Revision as of 22:11, 21 December 2021
Line 3:		Line 3:
	==Downloading==		==Downloading==

	'''Kdb+/q''' can be downloaded from ~~<span class="plainlinks">~~https://kx.com/developers/download-licenses/~~</span>~~.		'''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).		In particular, there are two free versions of kdb+/q: the 32 Bit Personal Edition and the 64 Bit Personal Edition (On-Demand).
Line 27:		Line 27:
	* 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 ~~<span class="plainlinks">~~https://kx.com/developers/download-licenses/~~</span>~~.		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/.

	==Installing kdb+/q==		==Installing kdb+/q==
Line 38:		Line 38:
	* You have the 32 Bit Personal Edition for non-commercial use. It does not require a license-key file.		* You have the 32 Bit Personal Edition for non-commercial use. It does not require a license-key file.

	The first step is to download kdb+/q from ~~<span class="plainlinks">~~https://kx.com/developers/download-licenses/~~</span>~~.		The first step is to download kdb+/q from https://kx.com/developers/download-licenses/.

	Once you have downloaded the archive, unzip it to:		Once you have downloaded the archive, unzip it to:
Line 113:		Line 113:
	</pre>		</pre>

	For more details on how to run 32-bit programs on Ubuntu 64-bit, see ~~<span class="plainlinks">~~https://askubuntu.com/questions/454253/how-to-run-32-bit-app-in-ubuntu-64-bit~~</span>~~.		For more details on how to run 32-bit programs on Ubuntu 64-bit, see https://askubuntu.com/questions/454253/how-to-run-32-bit-app-in-ubuntu-64-bit.

	===<tt>rlwrap</tt>===		===<tt>rlwrap</tt>===
Line 195:		Line 195:
	==Q Insight Pad (Windows-only)==		==Q Insight Pad (Windows-only)==

	~~<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.		[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.

	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 ~~<span class="plainlinks">~~http://www.qinsightpad.com/~~</span>~~.		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: ~~<span class="plainlinks">~~http://www.qinsightpad.com/contact.html~~</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.

	===Connecting Q Insight Pad to kdb+/q===		===Connecting Q Insight Pad to kdb+/q===
Line 232:		Line 232:
	==qStudio==		==qStudio==

	~~<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:		[http://www.timestored.com/qstudio/ qStudio] by [http://www.timestored.com/ TimeStored] is an intelligent code editor for kdb+/q that provides:
	* q syntax highlighting;		* q syntax highlighting;
	* q code completion;		* q code completion;
Line 244:		Line 244:
	** qUnit — a unit testing framework for kdb.		** qUnit — a unit testing framework for kdb.

	qStudio can be downloaded from ~~<span class="plainlinks">~~http://www.timestored.com/qstudio/~~</span>~~.		qStudio can be downloaded from http://www.timestored.com/qstudio/.

	qStudio Pro can be purchased from ~~<span class="plainlinks">~~http://www.timestored.com/qstudio/buy~~</span>~~.		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.		This application requires a Java Runtime Environment 1.8.0_66 or above.
Line 252:		Line 252:
	==Studio for kdb+==		==Studio for kdb+==

	~~<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		[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
	* connect to kdb+ processes;		* connect to kdb+ processes;
	* execute selected text from the editor window;		* execute selected text from the editor window;
Line 269:		Line 269:
	* 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 ~~<span class="plainlinks">~~https://github.com/CharlesSkelton/studio~~</span>~~.		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:		The program is portable and comes in the form of a JAR file. You need the Java runtime environment (JRE) to run it:
Line 278:		Line 278:
	==KX Developer==		==KX Developer==

	~~<span class="plainlinks">~~[https://code.kx.com/developer/ KX Developer]~~</span>~~ is a visual environment used to manage, manipulate, and explore massive datasets in real-time by exploiting kdb+'s server-based analytics technology.		[https://code.kx.com/developer/ KX Developer] is a visual environment used to manage, manipulate, and explore massive datasets in real-time by exploiting kdb+'s server-based analytics technology.

	The Developer is comprised of the following components:		The Developer is comprised of the following components:
Line 300:		Line 300:
	* KX Developer module to q script conversion.		* KX Developer module to q script conversion.

	KX Developer can be downloaded for free from ~~<span class="plainlinks">~~https://code.kx.com/developer/~~</span>~~.		KX Developer can be downloaded for free from https://code.kx.com/developer/.

	'''Note that KX Developer requires a 64-bit version of kdb+/q.'''		'''Note that KX Developer requires a 64-bit version of kdb+/q.'''

Admin at 17:06, 17 June 2021

2021-06-17T17:06:13Z

@@ Line 161: / Line 161: @@
 In our example, this will force kdb+/q to use only the cores from 0 to 11 (inclusive) and will resolve the "cores" error.
 =Integrated development environments (IDEs)=
@@ Line 175: / Line 202: @@
 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==

Admin at 16:56, 17 June 2021

2021-06-17T16:56:12Z

← Older revision		Revision as of 16:56, 17 June 2021
Line 29:		Line 29:
	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>.		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>.

	==Installing==		==Installing kdb+/q==

	Kdb+/q can be installed on Linux, macOS, or Windows.		Kdb+/q can be installed on Linux, macOS, or Windows.
Line 66:		Line 66:
	* <tt>C:\</tt> (for example)		* <tt>C:\</tt> (for example)
	** <tt>q</tt>		** <tt>q</tt>
	*** <tt>w32</tt> (or <tt>w64</tt>)		*** <tt>w32</tt> (or <tt>w64</tt>, or <tt>l32</tt>, etc.)
	**** <tt>q.exe</tt>		**** <tt>q.exe</tt>
	*** <tt>q.k</tt>		*** <tt>q.k</tt>
Line 74:		Line 74:
	*** <tt>sp.q</tt>		*** <tt>sp.q</tt>
	*** <tt>trade.q</tt>		*** <tt>trade.q</tt>

			==Installing the license file==

			If you have a license file, <tt>k4.lic</tt> or <tt>kc.lic</tt>, put it in the <tt>QHOME</tt> directory.

			Then you will end up with the following directory structure:
			* <tt>C:\</tt> (for example)
			** <tt>q</tt>
			*** <tt>w32</tt> (or <tt>w64</tt>, or <tt>l32</tt>, etc.)
			**** <tt>q.exe</tt>
			*** <tt>kc.lic</tt>
			*** <tt>q.k</tt>
			*** <tt>q.q</tt>
			*** <tt>README.txt</tt>
			*** <tt>s.k</tt>
			*** <tt>sp.q</tt>
			*** <tt>trade.q</tt>

			By default, kdb+/q looks for a license file in <tt>QHOME</tt>. To keep your license file elsewhere, set its path in the environment variable <tt>QLIC</tt>.

	==Tips and tricks==		==Tips and tricks==
Line 228:		Line 247:

	KX Developer can be downloaded for free from <span class="plainlinks">https://code.kx.com/developer/</span>.		KX Developer can be downloaded for free from <span class="plainlinks">https://code.kx.com/developer/</span>.

			'''Note that KX Developer requires a 64-bit version of kdb+/q.'''

Admin at 15:25, 17 June 2021

2021-06-17T15:25:59Z

← Older revision		Revision as of 15:25, 17 June 2021
Line 202:		Line 202:
	java -jar studio.jar		java -jar studio.jar
	</pre>		</pre>

			==KX Developer==

			<span class="plainlinks">[https://code.kx.com/developer/ KX Developer]</span> is a visual environment used to manage, manipulate, and explore massive datasets in real-time by exploiting kdb+'s server-based analytics technology.

			The Developer is comprised of the following components:
			* Workspace — local and shared repository for managing entities;
			* Importer — import datasets into the workspace;
			* Exporter — export datasets into other systems;
			* Visual Inspector — visualize massive datasets in real-time or near-real-time;
			* Interactive editor — write applications using the q programming language;
			* Debugger — debugger dramatically increases productivity;
			* Code Differ — compare multiple versions of the functions or modules.

			Contained within the KX Developer package is a set of highly useful q developer libraries and scripts for use outside of the KX Developer UI and for automated build systems. The libraries contained provide support for:
			* Code coverage;
			* Data visualization;
			* Documentation generation from source annotations;
			* Property-based testing;
			* Q static linting and syntax checker;
			* Regular expressions;
			* Run time and memory profiling;
			* Unit testing;
			* KX Developer module to q script conversion.

			KX Developer can be downloaded for free from <span class="plainlinks">https://code.kx.com/developer/</span>.

Admin at 15:19, 17 June 2021

2021-06-17T15:19:33Z

← Older revision		Revision as of 15:19, 17 June 2021
Line 110:		Line 110:

	Install <tt>rlwrap</tt> using your package manager. (Common package managers: <tt>apt</tt>, <tt>dnf</tt>, and <tt>yum</tt> for Linux; Homebrew and MacPorts for macOS.)		Install <tt>rlwrap</tt> using your package manager. (Common package managers: <tt>apt</tt>, <tt>dnf</tt>, and <tt>yum</tt> for Linux; Homebrew and MacPorts for macOS.)

			It is straightforward to "wrap" the <tt>q</tt> process into <tt>rlwrap</tt>:
			<pre>
			rlwrap ~/q/l64/q
			</pre>

	===<tt>taskset</tt>===		===<tt>taskset</tt>===

Admin at 15:18, 17 June 2021

2021-06-17T15:18:13Z

← Older revision		Revision as of 15:18, 17 June 2021
Line 130:		Line 130:
	<tt>taskset</tt> is used to set or retrieve CPU affinity of a running process given its PID or to launch a new COMMAND with a given CPU affinity. CPU affinity is a scheduler property that "bonds" a process to a given set of CPUs [or CPU cores] on the system. The Linux scheduler will honour the given CPU affinity and the process will not run on any other CPUs.		<tt>taskset</tt> is used to set or retrieve CPU affinity of a running process given its PID or to launch a new COMMAND with a given CPU affinity. CPU affinity is a scheduler property that "bonds" a process to a given set of CPUs [or CPU cores] on the system. The Linux scheduler will honour the given CPU affinity and the process will not run on any other CPUs.
	</blockquote>		</blockquote>

			For example, we could run the <tt>q</tt> process as follows:
			<pre>
			rlwrap taskset -c 0,1,2,3,4,5,6,7,8,9,10,11 ~/q/l64/q
			</pre>

			In our example, this will force kdb+/q to use only the cores from 0 to 11 (inclusive) and will resolve the "cores" error.

	=Integrated development environments (IDEs)=		=Integrated development environments (IDEs)=

Admin at 15:14, 17 June 2021

2021-06-17T15:14:43Z

@@ Line 75: / Line 75: @@
 *** <tt>trade.q</tt>
-==Caveats==
+==Tips and tricks==
 ===Running 32-bit kdb+ on 64-bit Linux===
@@ Line 95: / Line 95: @@
 For more details on how to run 32-bit programs on Ubuntu 64-bit, see <span class="plainlinks">https://askubuntu.com/questions/454253/how-to-run-32-bit-app-in-ubuntu-64-bit</span>.
 =Integrated development environments (IDEs)=

Admin at 14:54, 17 June 2021

2021-06-17T14:54:42Z

@@ Line 74: / Line 74: @@
 *** <tt>sp.q</tt>
 *** <tt>trade.q</tt>
 =Integrated development environments (IDEs)=

Admin at 14:48, 17 June 2021

2021-06-17T14:48:24Z

@@ Line 31: / Line 31: @@
 ==Installing==
-On Windows, it is customary to install kdb+/q under <tt>C:\</tt>, so you end up with the following directory structure:
+Kdb+/q can be installed on Linux, macOS, or Windows.
 * C:\
-** q
+There are three installation scenarios:
-*** w32
+* You are a commercial user, with a <tt>k4.lic</tt> file.
-**** q.exe
+* You have the 64 Bit Personal Edition On Demand for non-commercial use. This is enabled by a <tt>kc.lic</tt> license-key file and requires an always-on internet connection. (This version of kdb+ is not licensed for use on cloud servers.)
-*** q.k
+* You have the 32 Bit Personal Edition for non-commercial use. It does not require a license-key file.
 *** q.q
-*** README.txt
+The first step is to download kdb+/q from <span class="plainlinks">https://kx.com/developers/download-licenses/</span>.
 *** s.k
-*** sp.q
+Once you have downloaded the archive, unzip it to:
-*** trade.q
+* <tt>~/q</tt> on Linux;
 =Integrated development environments (IDEs)=

Admin at 14:35, 17 June 2021

2021-06-17T14:35:12Z

← Older revision		Revision as of 14:35, 17 June 2021
Line 31:		Line 31:
	==Installing==		==Installing==

	On Windows, it is customary to install kdb+/q under <tt>C:\</tt>, so you end up with		On Windows, it is customary to install kdb+/q under <tt>C:\</tt>, so you end up with the following directory structure:
			* C:\
			** q
			*** w32
			**** q.exe
			*** q.k
			*** q.q
			*** README.txt
			*** s.k
			*** sp.q
			*** trade.q

	=Integrated development environments (IDEs)=		=Integrated development environments (IDEs)=