Sarachiel
Posts: 3
Joined: Wed Jun 04, 2014 8:03 pm

Raspberry PI + Java + DB

Tue Aug 05, 2014 6:52 pm

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 :)

ltorok
Posts: 14
Joined: Wed Aug 06, 2014 4:27 am

Re: Raspberry PI + Java + DB

Wed Aug 06, 2014 4:29 am

Try H2 Database Engine, url: http://www.h2database.com/html/main.html
Performance is very good!

henrik
Posts: 65
Joined: Tue Dec 18, 2012 4:24 pm

Re: Raspberry PI + Java + DB

Sat Aug 23, 2014 1:16 pm

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

Howard
Posts: 64
Joined: Sun Mar 04, 2012 7:38 pm
Contact: Website

Re: Raspberry PI + Java + DB

Wed Sep 03, 2014 10:55 pm

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.

bullen
Posts: 283
Joined: Sun Apr 28, 2013 2:52 pm

Re: Raspberry PI + Java + DB

Sat Jan 20, 2018 1:38 pm

You can use my distributed HTTP JSON NIO async. to async. Java database ROOT:

https://github.com/tinspin/rupy/wiki/Storage
https://github.com/tinspin/rupy - A tiny Java async HTTP application server.

Return to “Java”