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

[Jim Lawrence]

Good link.

Jim

----- Original Message -----
From: "Doug Steele" <dbdoug at gmail.com>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Sunday, September 25, 2016 10:10:14 PM
Subject: Re: [AccessD] Basic Question (Probably) that I just don't know

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