While I recognize Giovanni cannot run an application to act as a server, I thought I'd mention that I've developed a set of wrapper classes for the REALSQLDatabase that allow you to very easily make it into a multi-user database (or at least emulate that functionality). I haven't done extensive testing and there is no security implemented, but it works fairly well in the project for which I designed it. It uses the HTTP protocol to send requests and receive XML responses.
The functionality that is there includes most everything in the REALSQLDatabase class, RecordSet class (including Edit/Update), and DatabaseRecord class. I've not yet tested it with blob data (eg, inserting a file into the database). I've not yet decided what I plan to do with these classes. I would like to test them more before I release them (though it appears as though it all works fine), and I'm not sure whether I'll sell them or just release for free. But for those developers that are looking for some way of extending the REALSQLDatabase into a networked environment, it works pretty well. Regards, -Adam On 1/7/07, Giovanni <[EMAIL PROTECTED]> wrote:
I agree, there are thousands of Small Businesses(number of CPU's) that wont do a client-server. There are many applications that would benefit from a cross platform solution. In the US alone, there is a market for such a file-shared database that is multi-platform. When SQLPLUGINPRO have the solution, we will be purchasing it. As simple as that. Ultimately, I know the benefits for client-server, the issue is not whether is best or not, its about portability and simplicity. A jackhammer is not always a best tool for all and advocating it as such is a mistake. File-sharing DB's are here and will be staying. IMHO Andy Dent wrote: > > On 08/01/2007, at 12:33 AM, Ruslan Zasukhin wrote: > >>> From: Andy Dent <[EMAIL PROTECTED]> >>> Date: Sun, 7 Jan 2007 19:39:51 +0800 >>> > >>> My first use of c-tree Plus in shared-file mode was with a IIci as >>> server, using LocalTalk to Classics. Even with that hardware, it had >>> sub-second lookup times. >> >> For what size of dbs 0.5 - 5MB? >> and what kinds of queries? >> :-) > > Obviously that was an extreme low-end example, back in about 1992. As > I recall, those were string or number key lookups and a database of > some MB. > > However, you'd be surprised at just how efficient such engines can be > - I wouldn't waste your time getting into arguments with such engine > users - I know of databases in the 100's of MB used in shared file > situations in the education and mining sectors. Sorry, can't point to > any examples other than KIDMAP from http://www.mercator.com.au/ as the > FoxPro stories were anecdotes from friends here in WA. > >> search by indexes do WHO? Right, the CPU of client computer. >> >> This means that N pages of index must travel by network to client >> computer, > > Yes, but when an engine has been specifically written for such a task > and optimised through many years, the index storage can be optimised > for such use. > > >> So my point is that EVEN IF a DB engine is _optimized_ for shared >> access, >> this technique still a lots behind to client/server technique. > > I never argued that it was faster than client/server, just that people > radically underestimate just how fast it can be :-) > > Andy Dent BSc MACS http://www.oofile.com.au/ > OOFILE - Database, Reports, Graphs, GUI for c++ on multiple platforms > REALbasic, C++, Python, Mac and Windows development and porting > > > > _______________________________________________ > Unsubscribe or switch delivery mode: > <http://www.realsoftware.com/support/listmanager/> > > Search the archives of this list here: > <http://support.realsoftware.com/listarchives/lists.html> > _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html>
