Page 1 of 1

Raspberry PI + Java + DB

Posted: Tue Aug 05, 2014 6:52 pm
by Sarachiel
Hello there,

I've been experimenting with my RPI (rev B) latelty. I created a java application in which I used HSQLDB, but the performance is horrible. Does anyone had similar issues ? Is there any other DB to implement with Java that will run smoothly ?

Thanks in advance for Your answers :)

Re: Raspberry PI + Java + DB

Posted: Wed Aug 06, 2014 4:29 am
by ltorok
Try H2 Database Engine, url: http://www.h2database.com/html/main.html
Performance is very good!

Re: Raspberry PI + Java + DB

Posted: Sat Aug 23, 2014 1:16 pm
by henrik
Sarachiel wrote:Hello there,

I've been experimenting with my RPI (rev B) latelty. I created a java application in which I used HSQLDB, but the performance is horrible. Does anyone had similar issues ? Is there any other DB to implement with Java that will run smoothly ?

Thanks in advance for Your answers :)
JavaDB is included in the Oracle JDK that is distributed with the Raspberry Pi OS images. It's basically a branded version of Apache Derby and works fine as a simple in-memory SQL database. Plenty of tutorials etc online.

http://docs.oracle.com/javadb/10.8.3.0/ ... index.html

Henrik - Oracle Java team

Re: Raspberry PI + Java + DB

Posted: Wed Sep 03, 2014 10:55 pm
by Howard
JavaDB is included in the Oracle JDK that is distributed with the Raspberry Pi OS images. It's basically a branded version of Apache Derby and works fine as a simple in-memory SQL database. Plenty of tutorials etc online.
From my trials (not on Pi) Derby is rather large and uses lots of memory.

Of all the databases I tried I ended up with H2 - good SQL compliance, modest memory usage, supports in-memory database (use a connection URL something like: "jdbc:h2:nioMapped:h2/db;LOG=0;LOCK_MODE=0;UNDO_LOG=0") and is fast.

Re: Raspberry PI + Java + DB

Posted: Sat Jan 20, 2018 1:38 pm
by bullen
You can use my distributed HTTP JSON NIO async. to async. Java database ROOT:

https://github.com/tinspin/rupy/wiki/Storage