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

Stuart McLachlan stuart at lexacorp.com.pg
Mon Sep 26 00:39:19 CDT 2016


That sums it up very well.   It does have a lot of uses.

On 25 Sep 2016 at 22:10, Doug Steele wrote:

> By coincidence, this just came up on HackerNews:
> 
> https://sqlite.org/whentouse.html
> 
> Doug
> 
> On Sat, Sep 24, 2016 at 4:43 AM, Stuart McLachlan
> <stuart at lexacorp.com.pg> wrote:
> 
> > 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
> > >
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list