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

[Gustav Brock]

Hi Stuart

I see your points. And I can see, browsing the documentation, that SQLite certainly has its niche.

What struck me was, that Arthur wrote:

> SQL Express, MySQL, MariaDB, PostGreSQL, SQLite... the list goes on

and I didn't see SQLite fit in here. It has its own category.

Thank you for the clarification.

/gustav


________________________________________
Fra: AccessD <accessd-bounces at databaseadvisors.com> på vegne af Stuart McLachlan <stuart at lexacorp.com.pg>
Sendt: 24. september 2016 13:38:11
Til: Access Developers discussion and problem solving
Emne: Re: [AccessD] Basic Question (Probably) that I just don't know

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.