Sqlite is very widely used as an embedded SQL database. You probably
use it already without knowing it. (Do you use Firefox?).
Be warned that the price you pay for its simplicity is that it is not
suitable for enterprise DBMS applications, like running Ebay, but is
ideal for standalone applications and very good for distributed
applications.
I would guess that it would be a very good choice for a point of sale
system provided that it is not required to be a central database for a
very large number of concurrent users. Managing a single store would be
an ideal application, but having one Sqlite database controlling all the
stores in Bali would not be such a good idea; that would be more
appropriate for something like PostgreSQL.
For example we have a distributed medical supplies system with many
local databases doing real time receipts and issues and a central global
database. That works very well using Sqlite and is very easy to
administer and backup. The local real time programs use Windows with
the Win32 API and Sqlite3, the local interactive programs are HTML and
JavaScript running in a WWW browser and the remote databases are Sqlite3
embedded in a WWW server and communicating using HTTP.
made hendra wrote:
hi
I'm a newbies in sqlite, i'm a vb programmer. I want to develop
database software (Point of Sales) under vb and sqlite.
From the sqlite official website, i fond that sqlite is great
database.
I need your opinion, is it wrong or right using sqlite as database
for my vb application. Can you give me some reference where are the
right mailing list (discussing) about vb and sqlite database.
Thanks for your sharing.
made hendra
(Balinese Programmer)
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
-
To unsubscribe, send email to [EMAIL PROTECTED]
-