SQLite is most definitely NOT SQL Server Express.
SQLite is a small C library that implements a self-contained, embeddable,
zero-configuration SQL database engine. Features include:
* Transactions are atomic, consistent, isolated, and durable (ACID) even
after system crashes and power failures.
* Zero-configuration - no setup or administration needed.
* Implements most of SQL92. (some features not supported)
* A complete database is stored in a single disk file.
* Database files can be freely shared between machines with different
byte orders.
* Supports databases up to 2 terabytes (241 bytes) in size.
* Sizes of strings and BLOBs limited only by available memory.
* Small code footprint: less than 30K lines of C code, less than 250KB
code space (gcc on i486)
* Faster than popular client/server database engines for most common
operations.
* Simple, easy to use API.
* Bindings for many other languages available.
* Well-commented source code with over 95% test coverage.
* Self-contained: no external dependencies.
* Sources are in the public domain. Use for any purpose.
I am using it for caching and local/disconnected storage in an application
I'm developing in .NET using a very excellent .NET binding, available here:
http://sqlite.phxsoftware.com/
It's an extremely fast database and I've grown rather fond of it for the
uses to which I am putting it. Way simpler, faster and more reliable than
Access, for those of you thinking about life after 2014.
If you wanted to interface to it directly in FoxPro you could write an FLL
that interfaces to it through its C API, or through its DLL on Windows in
the same way you can interface to the Windows API DLLs etc. At least, I
hypothesize that the latter approach is possible. I know for sure if you
drop down to C you can use it because that's what it was built for
originally.
To make it behave like a client server database, you can write the server
piece and have clients connect to it via some protocol. For example, you
could put it behind a Windows Service and design your own wire protocol for
client apps to talk to it. You could write an ASP.NET Web Service that uses
it via ADO.NET with the binding I pointed to above, or write your own HTTP
server RESTful interface using SQLite for the backend storage, then any
client that can make HTTP requests and consume XML or JSON or whatever you
like as a transport can connect to it. You have to be careful about
threading but for the most part it's quite safe to use in multithreaded
scenarios when you know what you're doing.
SQLite is "public domain" which means it's free for any kind of use. It's
not viral like the GPL, so I consider it safe for commercial use.
Overall, I highly recommend it. With a little creativity it can be used to
power a variety of applications over different architectures. And another
nice feature is the database files are completely cross platform, so it
makes the data layer easy to move around as required.
- Bob
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Tom Cloud
> Sent: Saturday, July 12, 2008 7:19 AM
> To: [email protected]
> Subject: RE: anyone with experience with SQLite ?
>
> Is SQL server express the same as SQLite ?
>
>
> At 04:44 AM 7/12/2008, you wrote:
> >SQL server express creates 2 files it seems. One database and a
> transaction
> >table. Well at least its supposed to but I have seem problems where it
> makes
> >2 temp files, changes one and deletes the transaction table. Then
> moans
> >about it not being there. Silly bloody thing. Yes Ed I,m tending
> toward
> >another choice. Maybe even VFP tables for membership :)
> >M$ sql server express is a pain. Great when it works but crap when it
> >doesn't.
> >BTW for anyone playing with SQL express and asp.net for memberships,
> when
> >you go in and alter something in the web config, it errors with
> Network
> >Service does not have rights for a while after. That bit me and I
> don't know
> >why it does it. Maybe the server is too slow.
> >Allen
> >
> >-----Original Message-----
> >From: [EMAIL PROTECTED] [mailto:profoxtech-
> [EMAIL PROTECTED] On
> >Behalf Of Tom Cloud
> >Sent: 12 July 2008 11:32
> >To: [EMAIL PROTECTED]
> >Subject: anyone with experience with SQLite ?
> >
> >Does anyone on the list have experience with SQLite?
> > http://sqlite.org/
> >
> >... their home page says it is a "self-contained, serverless,
> >zero-configuration, transactional SQL database engine"
> >
> >I'm told it creates one file rather than multiple tables, which I
> don't
> >understand, as other SQL implementations use a DBC and tables ??
> >
> >This looks great -- no separate server, etc. Is there a connector for
> VFP?
> >
> >thanks,
> >Tom
>
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
