[AccessD] SQLite cloud/mobile (was: Basic Question (Probably) that I just don't know)

[Gustav Brock]

Hi all

Did you know that SQLite is available even at Azure? 
Well, it is. From NuGet: Azure Mobile SQLiteStore:

    https://www.nuget.org/packages/Microsoft.Azure.Mobile.Client.SQLiteStore/

A How-To is here:

    https://blog.xamarin.com/getting-started-azure-mobile-apps-easy-tables/?wt.mc_id=AID530598_EML_4607277

Further info:

    http://azure.microsoft.com/mobile

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af Gustav Brock
Sendt: 24. september 2016 15:54
Til: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Emne: Re: [AccessD] Basic Question (Probably) that I just don't know

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.