Databases on the SBC

Supporting Java SE version 7 and up
morgan
Phidgetly
Posts: 44
Joined: Sun Nov 28, 2010 4:34 pm
Contact:

Databases on the SBC

Postby morgan » Mon Mar 03, 2014 12:23 am

Going back over my previous research, I can see I was experimenting with Derby and HSQLDB... And now I am seeing a few posts for SQLlite on the SBC3. I'm still playing around with the SBC1, so i'm not sure if SQLlite is an option to me, but I will buy an SBC3 soon.

So far in my testing, it looks like I've had the most success with HSQLDB. I was able to create a table, and add a row. However the data would not be maintained as persistent, when the app restarted, it was gone (and not due to a dropped table, etc.).

I would like a database that will maintain the data, even on power fail. It would be nice if i could choose the location for the data files, and it would be awesome if multiple userspace applications could access the same data simultaneously. is that possible?

What database should I be using? Can someone post some sample code to get connected, and I will test to see if I can save the data in the database!

Morgan

User avatar
Patrick
Lead Developer
Posts: 3049
Joined: Mon Jun 20, 2005 8:46 am
Location: Canada
Contact:

Re: Databases on the SBC

Postby Patrick » Mon Mar 03, 2014 11:50 am

SQLite allows for multiple connections: https://sqlite.org/faq.html#q5

I have always found it to be a very good embedded database, and fast.

-Patrick


Return to “Java”

Who is online

Users browsing this forum: No registered users and 1 guest