Re: Cgi and Database (stick to standards)

2008-02-19 Thread Ruslan Zasukhin
On 19/2/08 9:54 PM, "Hershel Fisch" <[EMAIL PROTECTED]> wrote: Hi Hershel, > On 2/19/08 2:29 AM, "Ruslan Zasukhin" <[EMAIL PROTECTED]> wrote: >> I wonder where you have found info that mySQL is worse of others (SqlLite or >> Postgre) on grow of db size ???> >> I do not think exists significant d

Re: Cgi and Database (stick to standards)

2008-02-19 Thread Hershel Fisch
On 2/19/08 2:29 AM, "Ruslan Zasukhin" <[EMAIL PROTECTED]> wrote: > On 19/2/08 12:01 AM, "Hershel Fisch" <[EMAIL PROTECTED]> wrote: > > Hi Hershel, > > I wonder where you have found info that mySQL is worse of others (SqlLite or > Postgre) on grow of db size ???> > I do not think exists signific

RE: Cgi and Database (stick to standards)

2008-02-19 Thread Lynn Fredricks
> If you think about hosting, Valentina is unlikely choice. > Only if you have own server. > > Valentina (we believe) is the best, first of all, for > *application* developers which will later distribute many > copies of app. You can request your ISP to support Valentina on a virtual host too

Re: Cgi and Database (stick to standards)

2008-02-18 Thread Ruslan Zasukhin
On 19/2/08 12:01 AM, "Hershel Fisch" <[EMAIL PROTECTED]> wrote: Hi Hershel, > On 2/15/08 3:41 AM, "Ruslan Zasukhin" <[EMAIL PROTECTED]> wrote: > That¹s what they say on there site, but I could understand only on small > files or records, my mistake. > Then I might go with PostgreSQL which is a b

Re: Cgi and Database (stick to standards)

2008-02-18 Thread Hershel Fisch
On 2/15/08 5:55 PM, "Sadhunathan Nadesan" <[EMAIL PROTECTED]> wrote: > FYI > > PostgreSQL is free. > > Sadhu Thanks, I'm using it a while and its good as well > > > >> >> From: Hershel Fisch <[EMAIL PROTECTED]> >

Re: Cgi and Database (stick to standards)

2008-02-18 Thread Hershel Fisch
On 2/15/08 3:41 AM, "Ruslan Zasukhin" <[EMAIL PROTECTED]> wrote: That¹s what they say on there site, but I could understand only on small files or records, my mistake. Then I might go with PostgreSQL which is a bit slower then MySql on smaller db's but doesn't slow down as much as database grows l

Re: Cgi and Database (stick to standards)

2008-02-16 Thread Ruslan Zasukhin
On 16/2/08 11:52 AM, "viktoras didziulis" <[EMAIL PROTECTED]> wrote: Hi Victoras, > from my experience mysql is faster than sqlite in joins, unless you > manually optimise your sql queries for sqlite ;-), in most cases using > subqueries. I am ready to see example :-) If you want on Valentina l

Re: Cgi and Database (stick to standards)

2008-02-16 Thread viktoras didziulis
and sometimes postrgresql (which people say is slower than mysql...). Viktoras Sadhunathan Nadesan wrote: FYI PostgreSQL is free. Sadhu From: Hershel Fisch <[EMAIL PROTECTED]> Subject: Re: Cgi and Database (stick to standards) To: How to use Revolution Bernard

Re: Cgi and Database (stick to standards)

2008-02-15 Thread Sadhunathan Nadesan
FYI PostgreSQL is free. Sadhu > >From: Hershel Fisch <[EMAIL PROTECTED]> >Subject: Re: Cgi and Database (stick to standards) >To: How to use Revolution > >> > Bernard Devlin wrote: >>> >> I'm not sure what kind of database require

RE: Cgi and Database (stick to standards)

2008-02-15 Thread Lynn Fredricks
> I want again repeat one point for SqlLite fans. If db world > was so simple that SqlLite engine in 300K beats mySQL then > ask self why mySQL/Oracle/MS SQL/Sybase/DB2/Ingres/ Valentina > developers bother self developing s complex DB > systems???!!! May be tasks are not so simple when yo

Re: Cgi and Database (stick to standards)

2008-02-15 Thread Ruslan Zasukhin
On 15/2/08 12:14 AM, "Hershel Fisch" <[EMAIL PROTECTED]> wrote: >> Bernard Devlin wrote: >> I'm not sure what kind of database requirements you have. > SQL rdbms, and I was thinking to use "sqLITE" because its fast even with > big bases and most hosting sites use mySql which slows down as the dat

Re: Cgi and Database (stick to standards)

2008-02-14 Thread Hershel Fisch
On 2/14/08 6:17 PM, "Stephen Barncard" <[EMAIL PROTECTED]> wrote: > How about Valentina? There was a free offer on this list recently: Before I don¹t how to use the db lib. I'll use any thing or rather don't use anything. Hershel > > http://miryesoftware.ning.com/forum/topic/show?id=1985969%3ATo

Re: Cgi and Database (stick to standards)

2008-02-14 Thread Stephen Barncard
How about Valentina? There was a free offer on this list recently: http://miryesoftware.ning.com/forum/topic/show?id=1985969%3ATopic%3A174 On 2/10/08 5:19 PM, "Sivakatirswami" <[EMAIL PROTECTED]> wrote: Bernard Devlin wrote: I'm not sure what kind of database requirements you have. SQL r

Re: Cgi and Database (stick to standards)

2008-02-14 Thread Hershel Fisch
On 2/10/08 5:19 PM, "Sivakatirswami" <[EMAIL PROTECTED]> wrote: > Bernard Devlin wrote: >> I'm not sure what kind of database requirements you have. SQL rdbms, and I was thinking to use "sqLITE" because its fast even with big bases and most hosting sites use mySql which slows down as the database

Re: Cgi and Database (stick to standards)

2008-02-10 Thread Sivakatirswami
Bernard Devlin wrote: I'm not sure what kind of database requirements you have. But in my tests using queries performing multiple joins on several tables containing between 1 million and 9 million rows each, Rev cgi completely blew away Java and relational databases: http://lists.runrev.com/pip

Re: Cgi and Database (stick to standards)

2008-02-09 Thread Bernard Devlin
Hi Richard, I have a local copy of his tutorial + stacks, but I can't find it online anymore. I've written to Pierre to ask him if it's online, and if not if I can send you my copy. I'm quite sure he'll agree. Bernard On 2/8/08, Richard Gaskin <[EMAIL PROTECTED]> wrote: > Bernard Devlin wrote:

Re: Cgi and Database (stick to standards)

2008-02-08 Thread Richard Gaskin
Bernard Devlin wrote: I'm not sure what kind of database requirements you have. But in my tests using queries performing multiple joins on several tables containing between 1 million and 9 million rows each, Rev cgi completely blew away Java and relational databases: http://lists.runrev.com/pip

Re: Cgi and Database (stick to standards)

2008-02-08 Thread Bernard Devlin
I'm not sure what kind of database requirements you have. But in my tests using queries performing multiple joins on several tables containing between 1 million and 9 million rows each, Rev cgi completely blew away Java and relational databases: http://lists.runrev.com/pipermail/use-revolution/20

Re: Cgi and Database (stick to standards)

2008-02-07 Thread Hershel Fisch
On 2/7/08 12:18 PM, "Tim Shields" <[EMAIL PROTECTED]> wrote: Hi, On my Mac 10.3.9, I'm using 212 what I down loaded thru hyperactiv's tutorial. And by the way I copied and unpacked the engine stuffed it into the cgi-bin but didn't work so I put back the older one. On the server where I intend to h

Re: Cgi and Database (stick to standards)

2008-02-07 Thread Tim Shields
Hi Hershel, What platform are you running on? Also, which version of revolution? There was some DB/CGI related problems with the earlier 2.9 Beta - although I think we've fixed them in the latest Beta. Regards, Tim. On 7 Feb, 16:13, Hershel Fisch <[EMAIL PROTECTED]> wrote: > On 2/7/08 10:00 AM

Re: Cgi and Database (stick to standards)

2008-02-07 Thread Hershel Fisch
On 2/7/08 10:00 AM, "Richard Miller" <[EMAIL PROTECTED]> wrote: > Hershel, Hi, and thanks, > > I'm not sure if this is the answer to your question, but I have found > problems with using http-based url's from inside the cgi folder. You > might try removing the "http://localhost/cgi-bin"; portion,