markspace<-@.> wrote:
On 2/26/2011 9:12 PM, harryos wrote:
Is it a good idea to use rdbms in a desktop app?
I wrote a similar app a while back for myself. I didn't use a RDBMS.
It seemed far too complicated for just a little time keeping app.
Instead, I just used POJO domain objects, and serialized the object
graph to disc. Simple and easy. Now if you have more sophisticated
needs than I did, maybe an RDBMS makes sense. But I'd try it with POJOs
first, it might work just fine.
Why write the code required to try it with POJOs? An RDBMS provides
far more functionality and consists of documented, extensively tested,
code. Even a little time keeping app probably requires referential
integrity to ensure that, for example, the project you say you are
working on exists. You can use a tool like OpenOffice Base to write
test data, check your program's output and produce ad-hoc reports. In
addition, many of the embedded RDBMS's can be adapted for multiple
users with almost no extra effort. If you choose Derby and a modern
version of Java you already have it on your computer.
<http://profectus.com.au/ee_freedbms.html#Java>
Looks like it's been a while since that site was updated. I suggest you
provide current links.