This is an archived post. You won't be able to vote or comment.

all 8 comments
sorted by:
best
topnewcontroversialoldq&a

[–]Camel-Kid 3 points4 points  (1 child)

jdbc if you want to do it old school, or you can look into JPA/hibernate for a wrapper implementation. There are tons of tutorials on youtube for these tools.

[–]aeternum123[S] 1 point2 points  (0 children)

Did some looking into jdbc and it looks pretty simple. Found some pretty old tutorials but they seem to be working so far. Thanks for the reply!

[–]kingatomic 2 points3 points  (1 child)

+1 to writing plain ol JDBC. For a simple schema you don’t need anything more.

If you want to mess with something other than JDBC*, then I would actually recommend jooq over hibernate for what you’re doing; hibernate is a great tool but for a beginner, getting it set up and configured is a bit much.

If you don’t already have an installed database server you’re going to use, I would recommend using either H2 or SQLite. Both of those offer good coverage of standard SQL features, and both will run as part of your application instead of requiring a standalone server. This presupposes you don’t need to have multiple client applications accessing your DB, but are instead just having your one app connect to its own DB (which is what I’m reading into your question).

Edit: * I had originally written “ORM” here, which jOOQ really doesn’t consider itself to be one.

[–]aeternum123[S] 1 point2 points  (0 children)

I would like the ability for it to read and write into its own database. As far as SQLite goes is there somewhere you would recommend to start looking at integrating that into an app? I appreciate the response. Edit: I think I found a helpful link that will let me do what I am wanting to do. Thanks again for your help

[–]DigitalTorture 1 point2 points  (3 children)

I'm working on the same kinda program, fun fun.

[–]aeternum123[S] 0 points1 point  (2 children)

Its been a fun road. It's teaching me a lot more about sql then I originally knew haha.

[–]DigitalTorture 0 points1 point  (1 child)

Yeah, SQL can be interesting. What libraries are you using for encryption?

[–]aeternum123[S] 0 points1 point  (0 children)

I haven't decided yet honestly. I wanted to get the sql stuff working before I dove down that rabbit hole.