https://questdb.io logo
Powered by
Title
a

Animus

01/04/2023, 6:54 AM
Could someone please help me wwith deploying the questdb on raspberry pi 4 8gb?
a

Andrey Pechkurov

01/04/2023, 7:14 AM
Hi, Running QuestDB on RPi is no different from any Linux deployment on x86. You may use Docker or Linux rt binary: https://questdb.io/docs/get-started/docker https://questdb.io/docs/get-started/binaries#your-operating-system-version
j

javier ramirez

01/04/2023, 9:18 AM
Just one comment about ARM processors. QuestDB is highly optimised for performance. One of the techniques it uses is SIMD vectorisation to parallelise some query predicates. SIMD operations are only supported by QuestDB for Intel and AMD. Everything will work, but for some queries your results might not be as fast as it would be on other architectures. In any cases this should be noticeable mostly on large datasets, so it might not be an issue for you
a

Andrey Pechkurov

01/04/2023, 9:25 AM
RPi is a low-power platform and it's using SD cards as the disk. Even if it would support SIMD (ARM NEON), it wouldn't change much
j

javier ramirez

01/04/2023, 10:01 AM
I’ve seen Pis with external drives, so just in case 🙂
a

Andrey Pechkurov

01/04/2023, 10:05 AM
Those would be limited by usb 3.0, but that's not my point. The machine as a whole is low-power, so no one should expect performance miracles from it
j

javier ramirez

01/04/2023, 10:06 AM
Yep. For sure. And typically it will contain only edge data, so in any case datasets should be usually small-ish
a

Animus

01/04/2023, 3:46 PM
thanks for info. How do I get it on the Ubuntu Server running on raspberry? Sorry I am new with CLI operation systems 🙂
figgured it out 🙂
JAVA: ./java
Created QuestDB ROOT directory: /home/animus/.questdb
./questdb.sh: line 188: ./java: cannot execute binary file: Exec format error
🤔
and other version 
JAVA: ./java
Created QuestDB ROOT directory: /home/animus/.questdb
./questdb.sh: line 188: ./java: cannot execute binary file: Exec format error
This was error from other version `` JAVA_HOME is undefined ``````
a

Andrey Pechkurov

01/04/2023, 5:09 PM
Which binary did you use?
Should be 
questdb-6.6.1-no-jre-bin.tar.gz
. You also need to install jdk separately
a

Animus

01/05/2023, 5:11 AM
thanks will take a look at it later and be back with more question 🙂
a

Andrey Pechkurov

01/05/2023, 7:06 AM
Looks like the path should be 
/usr/lib/jvm/java-11-openjdk-arm64/bin/java
, not 
/usr/lib/jvm/java-11-openjdk-arm64/bin/java/bin/java
Could you check your 
JAVA_HOME
, as well as the contents of the above directory?
Try setting 
JAVA_HOME
to 
/usr/lib/jvm/java-11-openjdk-arm64
No need to add 
bin/java
a

Animus

01/05/2023, 2:22 PM
@Andrey Pechkurov /usr/lib/jvm/java-11-openjdk-arm64/bin/java/bin/java is not executable
how to I modify it?
I did modifications hoever still has bin/java/bin/java
In etc/environment I have 
PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin"
JAVA_HOME=/usr/lib/jvm/java-11-openjdk-arm64
It seems that it crashes
a

Andrey Pechkurov

01/05/2023, 2:55 PM
Why do you think it crashes?
you should start it with 
./questdb.sh start -d /<path_to_qdb_root_of_your_choice>
-d
flag stands for the root database directory
but if you're fine with the default root dir (
$HOME/.questdb
), it's ok to omit the parameter
Once you run 
./questdb.sh start
, the database should start in the background. To stop it, run 
./questdb.sh stop
. The simplest way to check if it has started is to open Web Console - http://127.0.0.1:9000
a

Animus

01/05/2023, 3:01 PM
finally got it to work thank you for all the help
a

Andrey Pechkurov

01/05/2023, 3:11 PM
that's awesome!
BTW what's your use case for QuestDB?
a

Animus

01/05/2023, 3:22 PM
OHLCV storage for our startup
a

Andrey Pechkurov

01/05/2023, 3:23 PM
Would it run on edge devices? I wonder why you're using RPi
a

Animus

01/05/2023, 3:34 PM
Its for my testing environment
18 Views
#users-publicJoin Slack
Powered by