Hi Roger, [EMAIL PROTECTED] wrote:
I have reorganized the archive and got all the source into it this time.
Just downloaded it, i'll give a look at it. ...
1) This has nothing to do with the RPC based uSQLite project, which I have found has the same name! That project does seem a bit dead thougth so I shall not worry about it.
Well, I've been trying for years to download it, to me it seems more than a bit dead ;-) ...
3) When designing uSQLite, portability and the ease of implementing clients where prime considerations rather than performance. Thats why I used ASCII on sockets rather than a binary protocol or RPC's. However, I have found that the system is nontheless **very** fast. Thinking it througth, ASCII is not a handicap. Strings take the same space whilst numbers require 1 byte per digit plus terminator, i.e. they may often require less (int=42 would require 3 bytes to be sent). ASCII does make things so much simpler at the framing level however, and it's easier to debug.
I fully second this choice. I probably (well, no, for sure) would have some doubts if you used XML on the wire, but the used protocol, in machine mode should be as efficient as a binary one.
4) Am I doing the right thing? Of course I think the uSQLiteServer is the best thing since sliced bread, but then it was designed to meet my criteria :-) OTOH reception has been mixed. I have had a couple of nice replies on this list but overall feedback has been lukewarm to icy. I would be interested to know if anybody out there really is interested in the concept, otherwise I shall just keep it to myself ;-)
Well, I, for one, was waiting for the source to be available... On the other hand, I've been missing the ability to remotely connect to SQLite for a long time (I already mentioned I tried to get the other uSQLite...). As long as it is a wrapper for the base SQLite library it can be used by who is interested, without risking to affect people wanting to keep the main library simple... It would be great if the API was (whenever possible) kept aligned to the underlying one...
So, +1 to the count of people happy about it! Thanks for your work. Lorenzo