Results 1 to 3 of 3
Like Tree1Likes
  • 1 Post By Wnt2bsleepin

Thread: Storing large amounts of data in a user application

  1. #1
    Zyril is offline Senior Member
    Join Date
    Oct 2011
    Location
    Sweden
    Posts
    124
    Rep Power
    0

    Default Storing large amounts of data in a user application

    Hello everyone, this is not a question regarding any code, but a question where I hope some of you more experienced developers can give me some tips on how to accomplish what I want.

    I have previously coded an application in java that lets the user keep a record of their wine cellar. This works well, though I want to add more functionality and features to it so that it supports some other end users desires.
    Basically, I need to figure out a way to store data in a good way. What would be nice is to work with an SQL-database, but of course, this is a serverless application so that is not an option. I've previously worked with MS Access and Java connections to it, and that would work. The thing with this is that every user would need the JDBC-driver installed to be able to let the program access the MS Access .accdb-file. Therefore, I do not really see this as an option.

    In my previous version, I've stored all the data in an ArrayList that is serialized to a file. I get the feeling that this is a "clumsy" way of sorting things out, and that there is a more simple and straightforward solution for my task. I've looked into SQLite, for a standalone internal database, but it seem that it cannot support more than a few datatypes (String, short, int, float and double are supported. [Source]

    The good thing with a database is that I would be able to write simple queries to fetch the data that I need to be displayed to the user. This way I do not need to read a special file containing the serialized ArrayList.


    Any thoughts and hints on what I can use to achieve this would be helpful!

    Thank you! =)

    /Z

  2. #2
    Wnt2bsleepin is offline Senior Member
    Join Date
    Feb 2012
    Posts
    219
    Rep Power
    3

    Default Re: Storing large amounts of data in a user application

    I believe that SQlite can store Binary data. Perhaps the wrapper you are looking at doesn't support it, but I am sure it can. Another option is to use SQL to store the location of a file. That way if you wanted to pull X user's data, you would look in the table for X user and it would have the directory or path of the file you need.
    Zyril likes this.

  3. #3
    Zyril is offline Senior Member
    Join Date
    Oct 2011
    Location
    Sweden
    Posts
    124
    Rep Power
    0

    Default Re: Storing large amounts of data in a user application

    I will look into SQLite a bit more, thank you Wnt2bsleepin!

    Any other tips are welcome!

Similar Threads

  1. Searching Through Large Amounts of Data
    By atomant in forum New To Java
    Replies: 17
    Last Post: 06-11-2012, 11:28 AM
  2. Thoughts about how to bit shift large amounts of data
    By whytheheckme in forum New To Java
    Replies: 3
    Last Post: 07-08-2011, 12:48 AM
  3. How to save large amounts of similar objects?
    By nieuwenhuizen-jk in forum New To Java
    Replies: 12
    Last Post: 05-13-2011, 03:21 PM
  4. Replies: 1
    Last Post: 12-28-2008, 10:25 AM
  5. parsing/storing large text data
    By hkansal in forum New To Java
    Replies: 4
    Last Post: 10-19-2008, 06:34 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
  •