Dear Fred,
I am using SQLite always in conjunction with PHP for web applications.
To give you an idea about the possibilities :
a. web application for law office :
- holds history for approx. 10.000 files with regards to accounting and
timesheets referenced to those files
- holds complete accounting records for 5 years
- credit control tool with possibilities to easily extract information
b. invoice and deferral details for electronic appliances company :
- holds records of all invoicing for the last two years 10.000 + records
, plus model fro analytical redistribution
c. tracking sales and purchase orders for IT company :
- less impressive, but like the above two:
All applications rely solely on SQLite as RDBMS and prove to be very stable.
The added convenience when working with SQLITE 3 (the first application
still uses SQLITE 2 -type databases) , keeps convincing me I do not need
another system. In the past I always worked with MySQL, but never feel
the need to switch back.
I actually love SQLITE so much, I made a small tool in PHP to have
PHPMyAdmin-like functionality.
With best wishes,
Wim
FredAt schreef:
Hello All,
I have used SQLite off and on in Windows applications I have written and I
really like it. However, what I am now considering doing is using a SQLite
database to log access to one of my websites - I need to get a great deal
more information than I can get via normal log files. Doing this will
involve making the following entries to SQLite tables each time someone
views a document on my site
1. A 20 byte string providing me with information regarding the user's
computer.
2. 48 bytes of data, in three columns, in another table to allow me to track
user activity during a session.
On the server side I will be manipulating my SQLite databases using PHP. My
site currently has around a 1000 page views per day and the number is
growing. Is SQLite a good choice for the job? I like it and I want to
avoid getting messy with more heavyweight options but I need to be sure that
it is going to work. I would much appreciate any advice.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
