New topic: Website Database Question
<http://forums.realsoftware.com/viewtopic.php?t=47117> Page 1 of 1 [ 8 posts ] Previous topic | Next topic Author Message jerryab Post subject: Website Database QuestionPosted: Thu Feb 28, 2013 10:49 pm Joined: Mon Dec 12, 2011 7:25 pm Posts: 165 Location: Grand Rapids MI Area What I would like to do is have a encrypted sqlite database on my website. The database would have a table with 2 fields in it. I am not sure how to read the database from my program. Can anyone direct me on how to do this ? _________________ iMac 27" (2.8GHz Intel Core i5, 16GB RAM, 1TB Drive) OS X Lion 10.7.3 and Windows 7 Toshiba Laptop Running Windows 7 & WinXP SP3 REAL Studio Enterprise Edition 2012r1 http://www.theultimatecampgroundlog.com Being rewritten for the Mac Top Zack.H Post subject: Re: Website Database QuestionPosted: Thu Feb 28, 2013 11:10 pm Joined: Sun Jun 15, 2008 1:50 am Posts: 112 jerryab wrote:What I would like to do is have a encrypted sqlite database on my website. The database would have a table with 2 fields in it. I am not sure how to read the database from my program. Can anyone direct me on how to do this ? Why don't you check the examples provided in the RealStudio docs? http://docs.realsoftware.com/index.php/ ... _Reference Has everything you'd need to know in it. Top jerryab Post subject: Re: Website Database QuestionPosted: Thu Feb 28, 2013 11:28 pm Joined: Mon Dec 12, 2011 7:25 pm Posts: 165 Location: Grand Rapids MI Area I know how to work with the database on a local machine. Just not from the website. _________________ iMac 27" (2.8GHz Intel Core i5, 16GB RAM, 1TB Drive) OS X Lion 10.7.3 and Windows 7 Toshiba Laptop Running Windows 7 & WinXP SP3 REAL Studio Enterprise Edition 2012r1 http://www.theultimatecampgroundlog.com Being rewritten for the Mac Top npalardy Post subject: Re: Website Database QuestionPosted: Thu Feb 28, 2013 11:34 pm Real Software Engineer Joined: Sat Dec 24, 2005 8:18 pm Posts: 7744 Location: Canada, Alberta, Near Red Deer Are you planning on writing a web app & running it ON your web site ? _________________ Norman Palardy (Real Software) ââââââââââââââââââââââââââââââââââââââââââââââââââ Real Studio Developer Conference - April 23 - 26, 2013 http://www.realsoftware.com/community/realworld.php Top jerryab Post subject: Re: Website Database QuestionPosted: Fri Mar 01, 2013 12:09 am Joined: Mon Dec 12, 2011 7:25 pm Posts: 165 Location: Grand Rapids MI Area No, I just want to get information from the encrypted database that is on my website. I create the database and store it on the web and have a local program read the database stored on the web. The database will only ever be written by me never from the local program. _________________ iMac 27" (2.8GHz Intel Core i5, 16GB RAM, 1TB Drive) OS X Lion 10.7.3 and Windows 7 Toshiba Laptop Running Windows 7 & WinXP SP3 REAL Studio Enterprise Edition 2012r1 http://www.theultimatecampgroundlog.com Being rewritten for the Mac Top Zack.H Post subject: Re: Website Database QuestionPosted: Fri Mar 01, 2013 12:17 am Joined: Sun Jun 15, 2008 1:50 am Posts: 112 jerryab wrote:No, I just want to get information from the encrypted database that is on my website. I create the database and store it on the web and have a local program read the database stored on the web. The database will only ever be written by me never from the local program. So if I understand you correctly, You want to have the database hosted remotely(on the server) while you edit it locally(on your machine) Top jerryab Post subject: Re: Website Database QuestionPosted: Fri Mar 01, 2013 12:42 am Joined: Mon Dec 12, 2011 7:25 pm Posts: 165 Location: Grand Rapids MI Area No. the database will just be stored there to read data from it. If there is any data to add to it I will add it locally with another program. The database on the website will be encrypted and all I want is for my local program to read from it. Thats it. No writing will be done to it. _________________ iMac 27" (2.8GHz Intel Core i5, 16GB RAM, 1TB Drive) OS X Lion 10.7.3 and Windows 7 Toshiba Laptop Running Windows 7 & WinXP SP3 REAL Studio Enterprise Edition 2012r1 http://www.theultimatecampgroundlog.com Being rewritten for the Mac Top Zack.H Post subject: Re: Website Database QuestionPosted: Fri Mar 01, 2013 2:48 am Joined: Sun Jun 15, 2008 1:50 am Posts: 112 jerryab wrote:No. the database will just be stored there to read data from it. If there is any data to add to it I will add it locally with another program. The database on the website will be encrypted and all I want is for my local program to read from it. Thats it. No writing will be done to it. The only way I can think about reading from it is to download it ( even if just to memory although I don't know if the RealSQL classes will support a db stored in memory ). Unless you setup a read only user and use that but I have no idea if that's even possible with standard RealSQL stuff and you might wanna look into using an actual DB Engine on the server side for that (MySQL, Postgres, or such) Another thing I'd like to make note to is if you do plan on going down the route of downloading the RealSQL/SQLite database, is that even if it's encrypted the data isn't protected if you're trying to stop prying eyes from getting stuff. They can reverse engineer your application and pull out the key, the same goes for MySQL and Postgres or any other database except for in those cases you can restrict what the user has access to read from while this still isn't an optimal security conscious solution. My thought on this would be to have either a PHP script or WE web app open the DB remotely and serve the content to you over the /special/ url so that the key to the database is never passed on the client side. Best way in my opinion to do such would be use JSON or such. If you did it this way you'd setup all the select statements for reading in your RS-WE app, and you could even code in a login system to be processed over JSON that way if you wanted to you could edit it from any where as long as you were logged in and just send the data back up to the RS-WE app using JSON to process the new data to be inserted into the DB. Essentially if you went this route your RS-WE app would pretty much be simulating a DB server for a flat file db. Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 8 posts ]
-- 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]
