Results 1 to 4 of 4
  1. #1
    vishnubrett is offline Member
    Join Date
    Mar 2012
    Posts
    8
    Rep Power
    0

    Default Embedded Database : SQLite or Derby Database

    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

  2. #2
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,450
    Rep Power
    19

    Default Re: Embedded Database : SQLite or Derby Database

    600 rows is nothing in database terms.
    I'd go for the platform independence of Derby, personally.
    Please do not ask for code as refusal often offends.

  3. #3
    vishnubrett is offline Member
    Join Date
    Mar 2012
    Posts
    8
    Rep Power
    0

    Default Re: Embedded Database : SQLite or Derby Database

    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 :)

  4. #4
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,450
    Rep Power
    19

    Default Re: Embedded Database : SQLite or Derby Database

    Well, it is the database that Android uses, so there must be something in it.
    :)
    Please do not ask for code as refusal often offends.

Similar Threads

  1. SQLite database at FTP server
    By Matko in forum JDBC
    Replies: 11
    Last Post: 02-14-2012, 09:42 AM
  2. Derby database problem
    By rjain in forum New To Java
    Replies: 1
    Last Post: 09-22-2011, 12:36 PM
  3. Deploy derby database
    By Muaz.Sh in forum NetBeans
    Replies: 11
    Last Post: 03-17-2011, 06:02 PM
  4. Embedded Database ?
    By Prajin in forum JDBC
    Replies: 8
    Last Post: 09-27-2010, 06:44 AM
  5. Using Derby Database in Netbeans
    By DavidG24 in forum New To Java
    Replies: 1
    Last Post: 09-14-2009, 01:29 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •