[AccessD] Basic Question (Probably) that I just don't know

[Stuart McLachlan]

Oh yes, I forgot to mention triggers and in-memory databases  :)


On 24 Sep 2016 at 21:38, Stuart McLachlan wrote:

> I agree it's not a good alternative for multi user systems, but SQLite
> is an excellent solution for  single user applications.  There are
> reasons why it is so ubiquitous.
> 
> It's free.  :)
> 
> The same database file is usable on many platforms including Windows,
> Linux,Android and iOS.
> 
> It's fast, lightweight and versatile.
> 
> For Windows, it's just one native 500KB DLL and no dependencies. 
> 
> While it doesn't have a huge range of dataypes, there's not much that
> you can't do with a 8 bytes integers and floats (twice the size that
> Access offers) and  a default maximum size for text  of 1 billion
> characters (try indexinga field of  more than 255 characters in
> Access), and the same size of BLOBs.  There are plenty of built in
> functions for Date manipulation that make the use of a dedicated
> Date/Time datatypes unnecessary  including UnixTime (which is a real
> PITA to handle in Access).
> 
> You're right that many (including me) use it because we "don't know
> any better".  That's because in its niche, there is no better.
> 
> :)
> 
> 
> 
> On 24 Sep 2016 at 8:35, Gustav Brock wrote:
> 
> > Hi Arthur
> > 
> > I can't add much to the comments already posted, except for one
> > thing: SQLite is certainly not an alternative for an accdb or any
> > other decent database as SQLite is severely limited regarding data
> > types. In fact, I think why so many use it, is only because they
> > just don't know better.
> > 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>