Embedded Database : SQLite or Derby Database

[vishnubrett]

Hi, its me again. Pardon me for asking silly question if you feel.

My project requires embedded database, so that i can port my application to another system where i can create tables and ensure data can be entered, displayed(analysed).

I am using netbeans 7.1.1. I have already installed sqlite supporing JDBC. But now i am in confusion whether to go with SQLite or Derby database for my project. Both are new for me. I worked with Mysql before and read SQLite & Derby are not different either. So, no problems in that.

Using Derby, will make my project platform independent, right?
I will saving the data (lots of tables created, each table containing minimum 10 rows, 5 columns to maximum 600 rows, 20 colums) for future use... so which one will be better? Derby or SQLite?
Which one is faster? (Don't want my application hang in middle :) )

I have already finished 40% of coding with MYSQL database. Hope, now switching to either SQLite or Derby won't give me lot of headache in debugging :)

Thanks,

Vishnu Kumar

[Tolls]

600 rows is nothing in database terms.
I'd go for the platform independence of Derby, personally.

[vishnubrett]

Thanks for reply Tolls)... I too like to make my project platform Independent.

I figured a way to work with SQLite. But i will try with Derby next week, because for now i need to submit the code(50%) during my review on April 2nd.

Btw, SQLite is really cool :)

[Tolls]

Well, it is the database that Android uses, so there must be something in it.
:)