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
    12,086
    Rep Power
    20

    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.

    ** This space for rent **

  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
    12,086
    Rep Power
    20

    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.

    ** This space for rent **

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
  •