New topic: CubeSQL "Clone" Embeddable Server & Connector Classes
<http://forums.realsoftware.com/viewtopic.php?t=45753> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message simulanics Post subject: CubeSQL "Clone" Embeddable Server & Connector ClassesPosted: Mon Oct 29, 2012 5:19 am Joined: Sun Aug 12, 2007 10:10 am Posts: 783 Location: Boiling Springs, SC As part of the RSDS Library (viewtopic.php?f=1&t=43980&start=90) I have been baffled at how to create a "peer-to-peer" database sharing server method...I am quite fond of SQLite and CubeSQL... Since I cannot distribute an embeddable server with limitless connections...I have developed a set of classes to replicate the CubeSQL Server (connections and limits are set by the user ) No external plugins are needed except the realsqldatabase plugin and classes built into real studio. I threw together a quick example that utilizes the rsds library included in the zip to retrieve and access sql queries via socket. Like CubeSQL, this enables unlimited (at least the limitations of RS) connections and multi-user access capabilities. The example is basic...will update the example to show it loads images and files from the library...and will add an example of username and password requirements... Am adding Json and XML support for requests as well (in addition to the current custom binary/text methods in place)... I only put a couple SQL command examples, any can be entered into the textfield. You can also add sqlite databases to the example by dropping them in the datacenter folder and refreshing the db list or restart the example. In the example screenshot, I made a request for ALL data in the table (54.95MB)...on the same network the transaction took between 4-7 seconds...from one remote host the transaction took 17 seconds...and a really distant host; the transaction took almost a minute (58 seconds). Using standard queries, data streams without notice of the transaction. (By the way, my method of loading the items into a combobox is a slow bad data processing method...in place for demo purposes ) I'm wondering how useful something like this would be for others? Demo Source: http://www.realstudiodevspot.com/demos/ ... server.zip _________________ Matthew A. Combatti Real Studio 2012 r1.1 Visit Real Studio Developer's Spot! Systems: Windows XP/Windows Vista/Windows Server 2008 r2/Windows 7/Windows 8 Beta Mac OSX 10.5/Mac OSX 10.6/Mac OSX Server/Ubuntu/Debian/Suse/Red Hat/ Windows Server 2011/CentOS 5.4 /ReactOS/SimOS ~All REAL Compatible~ Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
