I found a lot of comparisions here, but not this one; So, what is best in each one?
+1
A:
There's a full comparison at SQLite's site.
SQLite is much more restricted, as it only supports a small subset of SQL92, whether Derby (now JavaDB) has full support of SQL92 and SQL99.
mgv
2010-04-26 14:49:45
Nice! Of course I would like to know if the Derby team point of view about this comparison.. but thanks anyway :)
Tom Brito
2010-04-26 14:51:56
Here's a thread in the derby user mailing lists: http://old.nabble.com/Derby-v-SQLite-td13496423.html
mgv
2010-04-26 14:54:58
@mgv still not what I expected, but thanks!
Tom Brito
2010-04-27 19:56:47
A:
One thing you should keep in mind about SQLite is that, besides supporting only a subset of SQL92, only the thread that created the SQLite database may access it. If you can live with that, then take it for its better performance.
PaoloVictor
2010-08-16 17:53:41