I'm thinking about starting a swing app and I was wondering how to handle the data. I'm familiar with server-side relational DBs, but I'd like to know if you guys can recommend something light for the desktop, that I could redistribute with my app and that wouldn't need any extra config. I've read about SQLLite, which also stores everything in a single file, which is good.
Or perhaps an RDBMS is not an appropriate choice here? How do small swing apps usually handle persistent data?
I remember now that I didn't like SQLite because, although the SQL seemed to be standard (remembering that there isn't really a standard SQL) a lot of the SQL keywords either didn't do anything or they did something other than what you would expect.
I believe that no matter how you declared a field type, all of the fields were the same, and some of the SQL keywords could be entered into your CREATE TABLE statement, but they wouldn't do anything.
So SQLite was kinda compatible with SQL, but it didn't really do what you would think.