Hi, What kind of information are you looking for? You could look at the internal Javadocs of H2, you can create them using ./build.sh javadocImpl. Then there is the source code of course.
Currently, I think SQLite is a bit faster than H2 for simple operations, partially because the virtual machine (Dalvik) doesn't optimize H2 as much as a modern JVM, and partially because the storage engine of H2 is not optimal for Android. I would probably use SQLite unless it doesn't provide the features you need. Generally, H2 has more features than SQLite (even thought SQLite does provide some features that H2 currently doesn't support). I'm working on a new storage engine, MVStore, and I think this will make H2 faster than SQLite on Android. It will also allow you to bypass SQL as an intermediary language, so you can use the java.util.Map interface if you want. See also https://groups.google.com/forum/?fromgroups=#!searchin/h2-database/MVStore Regards, Thomas On Fri, Sep 14, 2012 at 9:45 AM, Pratik Patodi <[email protected]>wrote: > This is Pratik from IIT Bombay, Indai. > Trying to find out the best database for android devises (which comes with > SQLite as a native database). > Looked on various databases available like TouchDb (but can't find any > technical paper and it is under development and not many test are > conducted), H2 database (can't find any technical paper again), Berkeley DB > JE (again can't find technical papers but some white papers from Oracle) > Can you help me to figure out some queries: > 1. Benife > 2. For which type of android application H2 is better the SQLite. > 3. For which type of android application SQLite is better the H2. > > PS: Can you please share some of the sources where I can get technical > papers on H2. or sources of your android applications. > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/h2-database/-/rU7bNTj9LFkJ. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
