Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > Designer> SQLite support
 

Pages: 1 2
Designer
SQLite support
Page:2/2 

  Print all messages in this thread  
Poster Message
Emmanuel
User



Location:
Ottawa, Canada
Joined on:
13-Jan-2006 23:14:31
Posted:
167 posts
# Posted on: 04-Jul-2012 15:52:42.  
Any news on SQLite support? We have a client who'd consider adopting LLBLGen if SQLite support was included.
  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37866 posts
# Posted on: 05-Jul-2012 09:45:08.  
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.


Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
rblock
User



Location:
Nuremberg, Germany
Joined on:
13-Mar-2009 13:16:18
Posted:
71 posts
# Posted on: 05-Jul-2012 09:56:07.  
Or Microsoft SQL Server Compact 4.0 Wink

( 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)
  Top
bentos
User



Location:
United Kingdom
Joined on:
12-Jul-2006 12:13:40
Posted:
125 posts
# Posted on: 17-Feb-2013 15:20:33.  
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 Wink

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? Regular Smiley

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



Regards,

Matthew Waring
 
Top
daelmo
Support Team



Location:
Guatemala City
Joined on:
28-Nov-2005 23:35:24
Posted:
8109 posts
# Posted on: 18-Feb-2013 04:01:15.  
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 Wink

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
David Elizondo
LLBLGen'ing (articles and code snippets) | linkedin | twitter
 
Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37866 posts
# Posted on: 18-Feb-2013 14:11:56.  
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.

Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
Pages: 1 2  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.12172008 Final.