Get Started

Your Linux System

Supported platforms are:

• Debian GNU/Linux on 64-bit x86, and 32- and 64-bit ARM.
• Red Hat Enterprise Linux on 64-bit x86
• SUSE Linux Enterprise on 64-bit x86
• Ubuntu on 64-bit x86

For supported versions of each platform, check the platforms section of the release notes for the current YottaDB release.

Prerequisite Software

YottaDB and its plugins require a number of common Linux utility programs, tools, shared libraries, and header files. The ydbinstall / ydbinstall.sh script for installing YottaDB checks for prerequisites needed by the software requested to be installed, and reports any that are missing. Use the package manager of your Linux distribution to install any missing prerequisites.

With prerequisites installed, see the Install YottaDB section below to install YottaDB.

Use YottaDB

YottaDB includes APIs for C and M.

C

Download the sayhelloC.C program, compile it, and run it:

wget https://docs.yottadb.com/AcculturationGuide/sayhelloC.c
gcc $(pkg-config --libs --cflags yottadb) -o sayhelloC sayhelloC.c -lyottadb
./sayhelloC

Go

Download the sayhelloGo.go program, compile it, and run it:

wget https://docs.yottadb.com/AcculturationGuide/sayhelloGo.go
go build sayhelloGo.go
./sayhelloGo

Lua

Download the sayhelloLua.lua program and run it:

wget https://docs.yottadb.com/AcculturationGuide/sayhelloLua.lua
lua sayhelloLua.lua

M

Download the sayhelloM.m program to the r/ subdirectory (which is created by the Initializing a YottaDB Environment step and exists in the Docker container), and run it.

wget -P $ydb_dir/r/ https://docs.yottadb.com/AcculturationGuide/sayhelloM.m
yottadb -run sayhelloM

Node.js

Downlad the sayhelloNode.js program and run it:

wget https://docs.yottadb.com/AcculturationGuide/sayhelloNode.js
node sayhelloNode.js

Perl

Download the sayhelloPerl.pl program, make it executable, and run it:

wget https://docs.yottadb.com/AcculturationGuide/sayhelloPerl.pl
chmod +x sayhelloPerl.pl
./sayhelloPerl.pl

Python

Download the sayhelloPython.py program, and run it.

wget https://docs.yottadb.com/AcculturationGuide/sayhelloPython.py
python3 sayhelloPython.py

Rust

Create a package for the sayhello_rust.rs program. Using cargo to compile and run the program downloads the API.

cargo new sayhello_rust
cd sayhello_rust
echo 'yottadb = "2.0.0"' >> Cargo.toml
curl https://docs.yottadb.com/AcculturationGuide/sayhello_rust.rs >src/main.rs
cargo run
cd ..

For other languages, install APIs for your preferred language.

Use Octo

The Docker Container includes Octo as well as the tables and data from the Northwind database adapated for Octo. With Octo installed on your machine or virtual machine you can download the data, and the SQL DDL statement to create tables:

wget https://gitlab.com/YottaDB/DBMS/YDBOcto/-/raw/master/tests/fixtures/northwind.zwr
wget https://gitlab.com/YottaDB/DBMS/YDBOcto/-/raw/master/tests/fixtures/northwind.sql
mupip load northwind.zwr # load the data
octo -f northwind.sql    # laod the table definitions

You can now run Octo in a terminal session following examples in the Octo user documentation, e.g.

ydbuser@ydbdev:~$ octo
OCTO> SELECT * FROM Products WHERE ProductName LIKE 'L%';
PRODUCTID|PRODUCTNAME|SUPPLIERID|CATEGORYID|UNIT|PRICE
65|Louisiana Fiery Hot Pepper Sauce|2|2|32 - 8 oz bottles|21.05
66|Louisiana Hot Spiced Okra|2|2|24 - 8 oz jars|17
67|Laughing Lumberjack Lager|16|1|24 - 12 oz bottles|14
74|Longlife Tofu|4|7|5 kg pkg.|10
76|Lakkalikööri|23|1|500 ml |18
(5 rows)
OCTO> SELECT * FROM Customers WHERE Country='France'LIMIT 5;
CUSTOMERID|CUSTOMERNAME|CONTACTNAME|ADDRESS|CITY|POSTALCODE|COUNTRY
7|Blondel père et fils|Frédérique Citeaux|24, place Kléber|Strasbourg|67000|France
9|Bon app'|Laurence Lebihans|12, rue des Bouchers|Marseille|13008|France
18|Du monde entier|Janine Labrune|67, rue des Cinquante Otages|Nantes|44000|France
23|Folies gourmandes|Martine Rancé|184, chaussée de Tournai|Lille|59000|France
26|France restauration|Carine Schmitt|54, rue Royale|Nantes|44000|France
(5 rows)
OCTO> exit
ydbuser@ydbdev:~$ 

With the Rocto server running, you can connect using a client such as SQL Workbench/J. On this page are screenshots of the connection screen using the PostgreSQL driver, showing the userid and password, as well as a screenshot of the same Northwind database query as the last example. You can also connect using DBeaver, SquirrelSQL, as well as Microsoft PowerBI and Excel.