4 Replies Latest reply on Aug 31, 2011 10:05 AM by jaikiran

    SQLite in 4/6/7

    frankthetank

      Hello again,

       

      for one of our projects I have been contemplating the possibility of using SQLite. The simple justifications are that we need to conserve space and the amount of data we have to persist is not very much, as most data is 'runtime' level.

      We also do not need a lot of the features offered by many DBs.

       

      Has any one else tried this out? What were the results?

       

      thanks!

        • 1. Re: SQLite in 4/6/7
          alesj

          I only played with SQLite on Android, and it was pretty simple and had good results.

          My generic "ORM" code is here:

          * https://github.com/capedwarf/capedwarf-green/tree/master/sqlite

          1 of 1 people found this helpful
          • 2. Re: SQLite in 4/6/7
            frankthetank

            @Ales:

            Thanks for the info. After doing some hacking myself I have been having some progress.

             

            In order to focus on my EJB persistence I changed jms to null-persistence for now. Then I create a type mapping for SQLite based on your list and also what I could find in the SQL documentation.

            I'm no DB expert so I'm shooting from the hip.

             

            Everything looks ok, though I did have to remove any ref to a schema name. Also, the auto-create/update of the schema did not work, though that might be related to my config (yet there were no exceptions, so maybe it was not).

             

            First critical issue: OOTB SQLite does not support foreign key relations. While it could be worked around, the current system needs it.

            This it is on ice for now. I'll continue with the next candidate: H2.

             

            If anyone is interested, I could share what little I have.

             

            some further info:

            http://docs.autodesk.com/MAP/2012/ENU/filesMUG/GUID-F6214F21-DBDA-47EB-A8CD-D28897FBD60-257.htm

            • 3. Re: SQLite in 4/6/7
              jaikiran

              Frank Henry wrote:

               

              This it is on ice for now. I'll continue with the next candidate: H2.

               

              If you are looking at H2, then you can try out AS7 which already has an example datasource backed by H2.