Any news on SQLite support? We have a client who'd consider adopting LLBLGen if SQLite support was included.

If we support it, it will be in v4, which is scheduled for next year. The main problem with sqlite is that it doesn't support right joins, which our engine uses when re-ordering join fragments. I.o.w.: we have to make sure all joins are left joins and the developer specifies the joins in the right order.

btw, firebird embedded, an embedded DB, is supported (just choose firebird, at runtime use the embedded dll) which might be an alternative for your client instead of sqlite.

Or Microsoft SQL Server Compact 4.0

( http://www.microsoft.com/de-de/download/details.aspx?id=17876 or http://www.microsoft.com/en-US/download/details.aspx?id=17876 )

It's free to and even the Deutsche Post uses it for their EPOS (Electronical POst counter System = Elektronisches POstschalter System)

Hi All,

Currently getting into monotouch development for mobile (ios/andr/win) and looking at local storage solutions.

I was wondering did anything ever get done about SQLite support? from a moby dev newbie point of view would seem wonderful to just continue using llblgen skillz

Would this not be a strong plus for llblgen (you could shout about it with xamarin community) also if your magic devs could create support in about 2 days (see walaa http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=15489), surely this makes sense? no?

I have also posted this to the wrong thread (meant to be one above), would be happy with a beta version before V4 with no right joins / subset func! most of the storage / query stuff would be basic.

Will look at firebird in meantime.

UPDATE: for anybody else landing here - http://stackoverflow.com/questions/2738074/sqlite-vs-firebird

Firebird seems well loved vs SQLLite for certain scenarios, so will take a good look.

Thanks Matt

bentos wrote:

Currently getting into monotouch development for mobile (ios/andr/win) and looking at local storage solutions.

I was wondering did anything ever get done about SQLite support? from a moby dev newbie point of view would seem wonderful to just continue using llblgen skillz

No news about SQLite yet, beside what you saw in this thread.

bentos wrote:

UPDATE: for anybody else landing here - http://stackoverflow.com/questions/2738074/sqlite-vs-firebird

Firebird seems well loved vs SQLLite for certain scenarios, so will take a good look.

Those are good points, thanks for sharing Matt

the problem with SQLite is indeed the right joins, our engine changes to right joins if it needs to (due to the relationships specified by the developer), and therefore it won't work in all cases, meaning it will end up with lots of problems when queries crash due to a right join in the sql, so the developer then has to change it to a left join somewhere to make it work.