Re: Cloud computing: scalable DB

2010-05-21 Thread David C.
> In particular I am looking at using Amazon - either their > SimpleDB, > or their Relational Database > Service, > but maybe also Google equivalent services?

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 i

Re: Cloud computing: scalable DB

2010-05-19 Thread Ruslan Zasukhin
On 19/5/10 10:04 PM, "Andre Garzia" 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 records. And on

Re: Cloud computing: scalable DB

2010-05-19 Thread Ruslan Zasukhin
On 19/5/10 9:47 PM, "Brian Yennie" 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 managing large am

Re: Cloud computing: scalable DB

2010-05-19 Thread Ruslan Zasukhin
On 19/5/10 9:36 PM, "Andre Garzia" 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 development since mos

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 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 o

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 wr

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
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 emails

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 suffe

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 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 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 instance)

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 vis

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 y

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: Regards, Scott Rossi Creative Director Tactile Media, UX Design Recently, David Bovill wrote: > I'm looking into an applica

Re: Cloud computing: scalable DB

2010-05-18 Thread Ruslan Zasukhin
On 18/5/10 4:48 PM, "Andre Garzia" 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 php, if > we had Rev

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 av

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 protocol

Re: Cloud computing: scalable DB

2010-05-18 Thread Ruslan Zasukhin
On 18/5/10 4:04 PM, "David Bovill" 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 Garcia points few key-value

Re: Cloud computing: scalable DB

2010-05-18 Thread David Bovill
Thanks Andre: On 18 May 2010 13:18, Andre Garzia 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 really Amazon S

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 http://www.mongo