CODEWITHSUNDEEP
javahibernatesqlite
gtiwari333
gtiwari333

Reputation: 25164

sqlite and hibernate - is good idea?

I am developing a small desktop application with Java + Hibernate. I am using MySQL for development but want to replace it with light version of SQL like SQLLite . I want to do this for following reasons:

I found SQLLiteDialect, its configurations and a working sample eclipse project(uses hibernate3) on http://code.google.com/p/hibernate-sqlite/.

But when I read the comment on a question : "Since SQLite database is widely used and it is not well supported by Hibernate in java,it's not easy to use SQLite with Hibernate" I got frightened.

Can you please suggest me - is it a good idea to use SQLite here? Are there any alternative to SQLite that is well supported by Hibernate?

Upvotes: 9

Views: 5135

Answers (1)

Rens Verhage
Rens Verhage

Reputation: 5857

I think there are pros and cons to every DB out there. For embedded DB's, you could also look at HSQLDB or H2DB.

Upvotes: 3

Related Questions