Edwin Eyan Moragas uttered:
hi group,
i have several small questions for the group any
experiences or thoughts shared would be greatly
appreciated.
1) anybody used sqlite as a sql server? i'm thinking
of say using the embedded sqlite in PHP5 or similar.
2) anybody ever implemented something like a single
process of sqlite doing queries for a lot of networked
clients?
A few people have implemented such a solution. It loses one of the
benefits of SQLite, however, in that SQLite is no longer admin free.
3) how big has your sqlite database grown? have you had any trouble
managing the db? any bad experiences as to stability of
the db file?
Stability of the file? In what sense? Compatibility? Or resistence to
corruption? Or size, perhaps?
i am asking all of these is because i'm seriously considering
sqlite to be used as my sql server for a project.
how i'll implement it looks something like this:
components of app:
embedded web server
sqlite
some scripting language
there will only be one sqlite process which will be forked
when the web server is launched. queries to sqlite will
be sent to the sqlite process via sockets.
You can do this, but you may find it easier to embed SQLite right into
your app, using whatever wrapper language binding your app is written in.
That is how it's designed to be used. It'll also be faster that way as
well, and easier to manage.
i can see that the queries will be sequential. no problems there. i'm
not worried with speed at the moment. i just want to know if this has
been done before and i'd like to solicit wisdom from the group.
I have thoughts on wrapping SQLite with FreeTDS, in order to provide
networked access to legacy apps that expect a TDS server to talk to. But
that is more for legacy reasons. You don't have this legacy burden by the
sounds of it, so just embed SQLite.
thank you.
./e
Christian
--
/"\
\ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST MS ATTACHMENTS
/ \
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
