John Newby wrote:
Hi, this is probably a stupid question and it has nothing to do with SQlite
per se so I apologise in advance for hijacking the emails withmy question
plus I don't even know if this is the right place to ask the question.
I have created a GUI to SQLite using VB.Net for my University project
and it
interfaces with the SQLite .dll file.
I have to now write about the architecture of my product but I am unsure as
what it would be, after reading this website I am even more confused :-
http://www.javaworld.com/javaworld/jw-01-2000/jw-01-ssj-tiers.html
Could it be one tier as both the DBMS and GUI are as one
or could it be two tier as the GUI could be the client and the DBMS the
server
or could it be three tier as the GUI could be the client and the DBMS the
server and database?
I'm really confused, so any help or information on this subject would be
really appreciated.
Many thanks
John
I would regard what you have developed as one tier. You do not have a
server and consequently do not realise the two or three tier model.
A two tier model has "fat" client and a server whereas a three tier has
a "thin" client, and application server and a dbms server.
The way you describe your application is that it is integrated and stand
alone. If you have intercept locks within in to resolve contentions
between multiple users of the database you can describe it as having
multi-user capability.