-1

I am creating a web application that is accessing a SQLite database in the server. I also have "clients" that updates this same database. As we know SQLite locks the entire database during INSERTs which are done by the clients and the web application is also trying to make some UPDATEs at the same time. So my problem now is about concurrency in database access. I would like to use an embeddable database like SQLite. Any suggestions.

Improve this question

6 Answers 6

Reset to default
9

H2 database the new thing from the creator of Hypersonic SQL: H2 stands for Hypersonic 2, however H2 does not share code with Hypersonic SQL or HSQLDB. H2 is built from scratch.

Improve this answer
Sign up to request clarification or add additional context in comments.

5 Comments

How do you compare H2 database with HSQLDB or JavaDB. I am more interested in concurrency since I don't want the database to be locked for UPDATEs when I am doing INSERTs. I believe SQLite locks the database when you perform any write to the database.
see h2database.com/html/features.html#comparison for a detailed comparison with Derby and others (not SQLite though), it details locking there.
have you personally used it in production environment? how was it?
myself not in production. But look at other's experience stackoverflow.com/questions/827220/…
@Lukas, are you sure concurrent sessions are not supported?? You really mean I cannot open two sessions to the same db?
3

HSQLDB

Improve this answer

Comments

2

If you value convenience over raw performance the database bundled with Java 6, JavaDB/Derby, may work well for you. It offers row-level locking and has it enabled by default.

Improve this answer

Comments

1

You've got to the point where I would be switching to using a separate database server. The SQLite wiki has a page on when to use SQLite and when not; highly concurrent writes are one of the times when you're beyond its architecture (which deliberately doesn't handle this case well so it can do better at others).

PostgreSQL and MySQL are probably your first ports of call.

Improve this answer

Comments

-1

Try Oracle's Berkeley DB.

Improve this answer

Comments

-1

Thought about MySQL? We're using it in our application an it works great.

Improve this answer

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.