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

[Stuart McLachlan]

For websites, it's worth noting that:

The SQLite3 extension is enabled by default as of PHP 5.3.0. 

Windows users must enable php_sqlite3.dll in order to use this extension. This DLL is 
included with Windows distributions of PHP as of PHP 5.3.0. 

-- 
Stuart

On 26 Sep 2016 at 15:28, Stuart McLachlan wrote:

> The relevant part in this context ( we were discussing a website
> database) is this part:
> 
> SQLite works great as the database engine for most low to medium
> traffic websites (which is to say, most websites). The amount of web
> traffic that SQLite can handle depends on how heavily the website uses
> its database. Generally speaking, any site that gets fewer than 100K
> hits/day should work fine with SQLite. The 100K hits/day figure is a
> conservative estimate, not a hard upper bound. SQLite has been
> demonstrated to work with 10 times that amount of traffic.
> 
> The SQLite website (https://www.sqlite.org/) uses SQLite itself, of
> course, and as of this writing (2015) it handles about 400K to 500K
> HTTP requests per day, about 15-20% of which are dynamic pages
> touching the database. Each dynamic page does roughly 200 SQL
> statements. This setup runs on a single VM that shares a physical
> server with 23 others and yet still keeps the load average below 0.1
> most of the time. 
> 
> 
> 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
> > 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>