larste

Add support for db evolutions:

Download the sqlite-dialect from here: https://github.com/gwenn/sqlite-dialect
Compile it to a jar file.
Add the jar file the app/lib folder.

larste

SELECT i.*, 
       n.title, 
       n.url, 
       'NULL' as description 
FROM items i JOIN news n ON n.item_id = i.id 
UNION ALL 
SELECT i.*, 
       j.title, 
       j.url, 
       'NULL' as description