Has anyone experimented at all with embeded databases? I have done a bit of work with systems built in other languages and was wondering if anyone has tried something like the Derby Embedded Database Engine or another system with Knime?
Would the data storage size and speed of the application suffer greatly? A nice benefit I see is that one could manipulate data in the Knime platform with SQL. There would be no discontinious workflow of writing out to a database and then reading the data back in via your SQL statement. There are some things that can be done in a very small ammount of SQL that take much effort in a more traditional language and in some cases a new node would have to be created to handle the work.
Anyways I would be very interested in hearing everyone's comments.