Re: Cloud computing: scalable DB

2010-05-21 Thread David C.
In particular I am looking at using Amazon - either their SimpleDBhttp://developer.amazonwebservices.com/connect/entry.jspa?externalID=2552categoryID=146, or their Relational Database Servicehttp://aws.amazon.com/rds/?ref_=pe_8050_15319810, but maybe also Google equivalent services? Anyone

Re: Cloud computing: scalable DB

2010-05-20 Thread Bob Sneidar
heh heh. The SQL would practically kill you, and we need you programming in Rev these days. Bob On May 19, 2010, at 2:03 PM, Andre Garzia wrote: oh and this is to the Brazilian public, I don't think we send anything overseas... it is mostly promotions and ads for big shops and companies in

Re: Cloud computing: scalable DB

2010-05-19 Thread David Bovill
Thanks for the pointer Mark - seems comparable price wise. I think as I am looking for the easiest migration strategy from small community cheap start-up costs to global scalability - I'd prefer either the ability to use MySQL, or the simplicity of SimpleDB (which is also free for a basic

Re: Cloud computing: scalable DB

2010-05-19 Thread Andre Garzia
Ruslan, Thanks for the quick reply. I am commenting your comments mixed in the quote below. I also have a shot to claim my deadliest database schema record Thanks for dropping in the thread. One thing that I think is stopping some rev developers moving to valentina is that there's no

Re: Cloud computing: scalable DB

2010-05-19 Thread Bob Sneidar
I thought this was EXACTLY what SQL was created to do? Bob On May 19, 2010, at 11:36 AM, Andre Garzia wrote: Now, check out this screen shot I just took: http://andregarzia.on-rev.com/shots/msdb.jpg This is ONE MASSIVE DATABASE with mind melting amount of information, tables with 55

Re: Cloud computing: scalable DB

2010-05-19 Thread Brian Yennie
Warning, bad analogy on the way... That's kind of like observing a truck full of loose boulders ready to fly out the back. Isn't that what trucks are for, carrying heavy loads? Point being that yes, SQL is one means towards managing large amounts of tables, rows, data, etc -- but it still

Re: Cloud computing: scalable DB

2010-05-19 Thread Andre Garzia
I need a sanity check for many reasons, that is one. Just imagine that I am working on a company that sends email marketing and that we send about 10 million emails per day... it all comes from that database you saw. 6 thousand tables governing the process of mailing and tracking 10 Million

Re: Cloud computing: scalable DB

2010-05-19 Thread Bob Sneidar
SO YOU are the one sending me all that junk mail! Bob On May 19, 2010, at 12:04 PM, Andre Garzia wrote: I need a sanity check for many reasons, that is one. Just imagine that I am working on a company that sends email marketing and that we send about 10 million emails per day... it

Re: Cloud computing: scalable DB

2010-05-19 Thread Andre Garzia
guilt as charged... but our doubleoptout works, so people can actually unsubscribe. We just provide the system to some really big companies here, think wall mart big (Actually wall mart is one of the customers and responsible for 2,5 million emails) On Wed, May 19, 2010 at 5:44 PM, Bob Sneidar

Re: Cloud computing: scalable DB

2010-05-19 Thread Andre Garzia
oh and this is to the Brazilian public, I don't think we send anything overseas... it is mostly promotions and ads for big shops and companies in here... now, if you think I am sending you email, you can send me your email and I will search the 55 Million email database to check if you're in any

Re: Cloud computing: scalable DB

2010-05-19 Thread Brian Yennie
Andre, If you mean by this that the bottleneck is READ access for sending the emails, would replication be an option? You could set up a second slave DB which shouldn't affect WRITE much unless you are already saturated on that end as well. Then when you need that burst of data, just alternate

Re: Cloud computing: scalable DB

2010-05-19 Thread Ruslan Zasukhin
On 19/5/10 9:36 PM, Andre Garzia an...@andregarzia.com wrote: Hi Andre, Ok I see. So we agree that Valentina can be used, of course, for WEB development in any way including Revolution, What you cannot now is to use vserver with rev-online service. I think that David is doing some web

Re: Cloud computing: scalable DB

2010-05-19 Thread Ruslan Zasukhin
On 19/5/10 9:47 PM, Brian Yennie bri...@qldlearning.com wrote: Warning, bad analogy on the way... That's kind of like observing a truck full of loose boulders ready to fly out the back. Isn't that what trucks are for, carrying heavy loads? Point being that yes, SQL is one means towards

Re: Cloud computing: scalable DB

2010-05-19 Thread Ruslan Zasukhin
On 19/5/10 10:04 PM, Andre Garzia an...@andregarzia.com wrote: Can valentina hold 6k tables and millions and millions of records? I could create a portable version of this system, almost a portable nightmare. In theory there is no limits. I have hear about 50-100GB dbs on Valentina. With many

Cloud computing: scalable DB

2010-05-18 Thread David Bovill
I'm looking into an application which needs a highly scaleable back end database. One with low up front costs and yet won;t fall over if it suddenly takes off. I've noticed Jerry and others describing On-Rev in terms of cloud storage - but AFAIK it is a simple shared host, and there are no

Re: Cloud computing: scalable DB

2010-05-18 Thread Andre Garzia
David, I've been looking at the same things. I am a user of Amazon S3 and I made tests with SDB as well (not from rev at this time). Depending on the data you want to store, you might want to check out the following noSQL databases: * CouchDB http://couchdb.apache.org/ * MongoDB

Re: Cloud computing: scalable DB

2010-05-18 Thread David Bovill
Thanks Andre: On 18 May 2010 13:18, Andre Garzia an...@andregarzia.com wrote: * CouchDB http://couchdb.apache.org/ * MongoDB http://www.mongodb.org/ (there's a mongo db hosting service at MongoHQ ) * Cassandra http://cassandra.apache.org/ * Riak http://riak.basho.com/ I think it is only

Re: Cloud computing: scalable DB

2010-05-18 Thread Ruslan Zasukhin
On 18/5/10 4:04 PM, David Bovill da...@vaudevillecourt.tv wrote: Hi All, * I wonder if anybody from you going to setup your own 1000 computer-servers cluster(s)? Like this must do Google and Amazon If not - then excuse me, guys you have completely different tasks than google. * Andrea

Re: Cloud computing: scalable DB

2010-05-18 Thread Andre Garzia
Ruslan, Thanks for dropping in the thread. One thing that I think is stopping some rev developers moving to valentina is that there's no valentina server for revServer. The FREE Valentina server has adaptors only for ruby and php, if we had RevServer support or at least a public available

Cloud computing: scalable DB

2010-05-18 Thread Mark Stuart
on Tue May 18 06:23:14 CDT 2010, David Bovill wrote: I'm looking into an application which needs a highly scalable back end database. David, have you checked out Microsoft's Azure cloud services? http://www.microsoft.com/windowsazure/sqlazure/ Here's some info I copied from that page: SQL

RE: Cloud computing: scalable DB

2010-05-18 Thread Lynn Fredricks
Hi Andre, Thanks for dropping in the thread. One thing that I think is stopping some rev developers moving to valentina is that there's no valentina server for revServer. The FREE Valentina server has adaptors only for ruby and php, if we had RevServer support or at least a public

Re: Cloud computing: scalable DB

2010-05-18 Thread Ruslan Zasukhin
On 18/5/10 4:48 PM, Andre Garzia an...@andregarzia.com wrote: Hi Andre, Thanks for dropping in the thread. One thing that I think is stopping some rev developers moving to valentina is that there's no valentina server for revServer. The FREE Valentina server has adaptors only for ruby and

Re: Cloud computing: scalable DB

2010-05-18 Thread Scott Rossi
Not sure if this would help but Mark Smith created a Rev library for working with S3: http://runtime-revolution.278305.n4.nabble.com/ANN-libS3-td326689.html#a326 689 Regards, Scott Rossi Creative Director Tactile Media, UX Design Recently, David Bovill wrote: I'm looking into an

Re: Cloud computing: scalable DB

2010-05-18 Thread Bob Sneidar
My elephant skates quite well. I just could never teach him to stop! Bob On May 18, 2010, at 5:18 AM, Andre Garzia wrote: RDBMS are quite complex tools and sometimes they are used for the wrong job and then designing table schemas become like trying to teach an elephant to ice skate, if

Re: Cloud computing: scalable DB

2010-05-18 Thread Jim Ault
On May 18, 2010, at 2:13 PM, Bob Sneidar wrote: My elephant skates quite well. I just could never teach him to stop! Bob Ahhh, but can it do a camel ? Jim Ault Las Vegas ___ use-revolution mailing list use-revolution@lists.runrev.com Please