Surreal DB

 

Surreal DB does not start on alpine container, 

use ubuntu container instead 

1. Create an Ubuntu container 

docker run -d -p 17000:8000 --name ub_surreal ubuntu tail -f /dev/null

2. Exec the container  in it mode

docker exec -it -u 0 ub_surreal sh

3. Update apt  ( this is required to install curl)

apt update

This will take some time may be 2-3 mins because apt coming with container is bare minimum

4. Install curl

 

apt install curl

Press 'Y' when prompted 

5. 

curl -sSf https://install.surrealdb.com | sh

This will install surreal db. 

6. Start surreal db

surreal start --log debug --user root --pass root memory

This will start surreal and keep it started. 

7. Open another command prompt and again open the same container with EXEC command: 

docker exec -it -u 0 ub_surreal sh

8. Now you can give the command and use surrealdb. 

For example you can give the following command: 

curl --request POST --header "Accept: application/json"    --header "NS: test" --header "DB:test" --user "root:root"  --data "INFO FOR DB;"  http://localhost:8000/sql

you should get a response like 

[{"time" : "47.432ms" , "status" : "OK" , "result" : { "d1" : {} , "dt" : {}, "sc" : {} , "tb" : {}}}]

https://www.freecodecamp.org/news/how-to-use-surrealdb-with-fresh-framework/

========================================================================

Start Surreal using dockerfile

1. Execute the following dockerfile:

========================================================================

Dockerfile

========================================================================

FROM ubuntu

RUN apt update 

RUN apt-get install -y  curl 

RUN curl -sSf https://install.surrealdb.com | sh

CMD surreal start --log debug --user root --pass root memory

========================================================================

NOTE the use of  apt and apt-get : apt-get has more features than apt, 

i.e. apt is a stripped down vesrion of apt-get

2. Build the above docker file:

docker build  -t surreal-image . 

NOTE : image name must be all smalls.

3. Run it: 

docker run -p 17000:8000 -d --name surrealdb surreal-image

4. Execute it: 

docker exec -it -u 0 surrealdb sh

5. Execute the following command on shell: 

surreal sql -c http://localhost:8000

You will be presented with surreal sql prompt. ( >) 

>info for db <Enter>

[{"time" : "23.728ms" , "status" : "ERR" , "detail" : "Specify a namespace to use"}]

6. Now exit sql shell by pressing ctrl + C and enter the following command: 

surreal sql -c http://localhost:8000 --ns test --db test

>info for db

[{"time" : "50.292ms" , "status" : "OK" , "result" : { "d1" : {} , "dt" : {}, "sc" : {} , "tb" : {}}}]

> create account set name = 'test' , created_at = time::now()

> CREATE author:john SET name.first = 'John' ,  name.last = 'Adams' , name.full = string::join(' ', name.first, name.last) , age = 29, admin  = true,  signup_at = time::now();

> select * from author, account;