RE: Cgi and Database (stick to standards)
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. MacServe.net can also set this up for you. They have supported Valentina for a VERY long time. Best regards, Lynn Fredricks President Paradigma Software http://www.paradigmasoft.com Valentina SQL Server: The Ultra-fast, Royalty Free Database Server ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Cgi and Database (stick to standards)
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 difference between mySQL and Postgre in regard of dependence on db size... I didn't say its worse, on sqlite I read its site this info that its faster, ok I do except that it might be on small or very small db's, on postgres I did a lot of research a while ago. mySQL is a bit faster on smaller db's as it gets lager it evens out then (in the Giga's) postgres is faster because mySQL slows down a bit. Aha, so this is your own experience with Postgre. Okay. or maybe I'll look into valentina. If you think about hosting, Valentina is unlikely choice. Only if you have own server. So it looks like I'll have to stick to mySQL or PostgreSQL by the way I didn't find posgres available for a decent price mostly mySQL is used. I think this is because thanks to history mySQL is loved by ISP. This did happens about 7-10 years ago when Postgre was much worse. For example it did have huge problems with non English languages while mySQL was able support e.g. Russian encodings. So far I don't even have this problem yet because I don't know even on how to get it to work. The way it looks I'll have to redo the whole thing to php. Hershel -- Best regards, Ruslan Zasukhin VP Engineering and New Technology Paradigma Software, Inc Valentina - Joining Worlds of Information http://www.paradigmasoft.com [I feel the need: the need for speed] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Cgi and Database (stick to standards)
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] Subject: Re: Cgi and Database (stick to standards) To: How to use Revolution use-revolution@lists.runrev.com 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 grows. I wanted to use PostgreSQL but I don¹t find any body with it for a decent price ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Cgi and Database (stick to standards)
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 like MySql, or maybe I'll look into valentina. Hershel But for sure post 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 database grows. Thanks, Hershel Hi Hershel, I believe above statement is FALSE. :-) SqlLite NEVER is faster of mySQL. may be only for TINY dbs. This is odd for me to be advocate of mySQL, :-) but of course this is not true. SqlLite is TINY engine, which uses SIMPLEST algorithms. mySQL is 100-500 times bigger by size DBMS. MySQL have incredible more powerful SQL, and only this means that you can get huge benefits when you work with remote server. If talk about slow down with grow of db size, then excuse me, I self did benches. And be sure I can do them correctly :-) SqlLite start to be unacceptably slow even on tables with 10 or 100K records. Some not hardest queries take 30 seconds or even minutes. I think you was foolished by feature of SqlLite Instant Result. This means that e.g. RESULT of search on table with million records is 100K records, SqlLite finds the first and says that it have finish, But this works only for single user engine. This trick cannot be used for multi-user DBMS, which must find all 100K records, put them under RESULT for user1, and setup record locks. 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 you start move more deeply... --- Of course mySQL also is not best speed daemon :-) For example, my own ISP provider have billin system that use mySQL, on db with 2-3 Gb, mySQL starts to think minutes, so browsers just get timeouts and people cannot see results Or For example, on developer year ago have switch from mySQL to Valentina, and his 5 minutes query under mySQL not get 1 sec or even 0.1 sec. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Cgi and Database (stick to standards)
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 bit slower then MySql on smaller db's but doesn't slow down as much as database grows like MySql, 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 difference between mySQL and Postgre in regard of dependence on db size... or maybe I'll look into valentina. 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. -- Best regards, Ruslan Zasukhin VP Engineering and New Technology Paradigma Software, Inc Valentina - Joining Worlds of Information http://www.paradigmasoft.com [I feel the need: the need for speed] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Cgi and Database (stick to standards)
from my experience mysql is faster than sqlite in joins, unless you manually optimise your sql queries for sqlite ;-), in most cases using subqueries. Plus mysql is multiuser and omnipresent, which matters... To make sqlite multiuser you will have to implement your own database locking mechanism, or use tools that have it already implemented (like modsqlite for apache). Possibly valentina db is one of the best choices (and I am waiting for my valentine days license to test it without limitations :-) ), but if you buy hosting services, then I guess you are limited to mysql, sqlite 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 use-revolution@lists.runrev.com 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 grows. I wanted to use PostgreSQL but I don¹t find any body with it for a decent price ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Cgi and Database (stick to standards)
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 list. Plus mysql is multiuser and omnipresent, which matters... right To make sqlite multiuser you will have to implement your own database locking mechanism, or use tools that have it already implemented (like modsqlite for apache). Possibly valentina db is one of the best choices (and I am waiting for my valentine days license to test it without limitations :-) ), but if you buy hosting services, then I guess you are limited to mysql, sqlite and sometimes postrgresql (which people say is slower than mysql...). That is right, It seems that all depend on users tasks. I did have feedbacks from Valentina developers that yes Postgre comparing to mySQL is much slow (in times). But not so far I have hear opinion that Postgre (latest?) did win mySQL on joins. So keep always in mind that DB tasks can be VERY different. For some tasks one dbms can be better, for other tasks another. It is good, as army soldier, to have skills with few kinds of weapon :-) -- Best regards, Ruslan Zasukhin VP Engineering and New Technology Paradigma Software, Inc Valentina - Joining Worlds of Information http://www.paradigmasoft.com [I feel the need: the need for speed] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Cgi and Database (stick to standards)
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 database grows. Thanks, Hershel Hi Hershel, I believe above statement is FALSE. :-) SqlLite NEVER is faster of mySQL. may be only for TINY dbs. This is odd for me to be advocate of mySQL, :-) but of course this is not true. SqlLite is TINY engine, which uses SIMPLEST algorithms. mySQL is 100-500 times bigger by size DBMS. MySQL have incredible more powerful SQL, and only this means that you can get huge benefits when you work with remote server. If talk about slow down with grow of db size, then excuse me, I self did benches. And be sure I can do them correctly :-) SqlLite start to be unacceptably slow even on tables with 10 or 100K records. Some not hardest queries take 30 seconds or even minutes. I think you was foolished by feature of SqlLite Instant Result. This means that e.g. RESULT of search on table with million records is 100K records, SqlLite finds the first and says that it have finish, But this works only for single user engine. This trick cannot be used for multi-user DBMS, which must find all 100K records, put them under RESULT for user1, and setup record locks. 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 you start move more deeply... --- Of course mySQL also is not best speed daemon :-) For example, my own ISP provider have billin system that use mySQL, on db with 2-3 Gb, mySQL starts to think minutes, so browsers just get timeouts and people cannot see results Or For example, on developer year ago have switch from mySQL to Valentina, and his 5 minutes query under mySQL not get 1 sec or even 0.1 sec. -- Best regards, Ruslan Zasukhin VP Engineering and New Technology Paradigma Software, Inc Valentina - Joining Worlds of Information http://www.paradigmasoft.com [I feel the need: the need for speed] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
RE: Cgi and Database (stick to standards)
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 you start move more deeply... An extremely important thing to keep in mind when choosing a database is how well they scale. If you are working with a handful of records locally, you arent going to notice a huge difference between databases. When you go from a local only to a network database, it is a huge step, and if your database wasn't designed from the get-go to account for network issues its likely not going to do it as well as those that do. Likewise, handling thousands or millions or records, you really notice a difference. And those are just performance issues, before getting into the general goodie bag of features :-) Best regards, Lynn Fredricks President Paradigma Software http://www.paradigmasoft.com Valentina SQL Server: The Ultra-fast, Royalty Free Database Server ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Cgi and Database (stick to standards)
FYI PostgreSQL is free. Sadhu From: Hershel Fisch [EMAIL PROTECTED] Subject: Re: Cgi and Database (stick to standards) To: How to use Revolution use-revolution@lists.runrev.com 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 grows. I wanted to use PostgreSQL but I don¹t find any body with it for a decent price ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Cgi and Database (stick to standards)
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 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 grows. I wanted to use PostgreSQL but I don't find any body with it for a decent price Bernard -- stephen barncard s a n f r a n c i s c o - - - - - - - - - - - - ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Cgi and Database (stick to standards)
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 grows. I wanted to use PostgreSQL but I don¹t find any body with it for a decent price Bernard And with shell I'm very unfamiliar Have fun... and a bit of history: FWIW: There were discussions a year or two ago about how robust this solution could be without a persistent Revolution process someone replied that he had been using Rev CGI where a new instance was called each time. he said it scaled up to the millions of hits. No problems. Meanwhile other CGI's are doing more robust stuff like processing Credit card transactions and handling form submissions no problem... Now I can't vouch for more than 30-50 instances a second... what would happen, but we are in that range right now, Apache and the CPUs hardly blink... and see no slow down whatsoever. I'm no expert but I think a persistent Rev process will die on the first hard script error... so there are advantages to just letting Apache load rev on every single call...watch out for zombies ... if you don't close the cgi properly you can get hung What do you mean by closing and how do you do it? Rev CGI processes, but, because these are separate instances of Rev... they don't terminate your web site... just slow it down as each zombie starts eating the CPU speeds.. Thanks, Hershel ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Cgi and Database (stick to standards)
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%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 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 grows. I wanted to use PostgreSQL but I don't find any body with it for a decent price Bernard ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Cgi and Database (stick to standards)
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/pipermail/use-revolution/2008-January/106071.html If you need multi-user/multi-application update/insert access to the data, then Rev is probably not the right solution. For other situations, I would say don't dismiss Rev's native data structures without thorough testing of the speed differences when compared to a RDBMS. Bernard We use shell calls to PostGresSql on our server... from inside Rev CGI's ...it's easy if you know your SQL language... just build a query and send it to the dbase, get the result. Then you don't need to worry about drivers and paths to them Sorry for long post, but since Rev CGI is so hot... Here's a snippet (with finesse from Andre who is a wizard with format...) for a standard insert query, your insert values (params here) are coming in from the POST: function insertEntry pUser, pCode, pTime, pDescr put format(INSERT INTO event (user_id, event_code, event_time, description) VALUES ('%s','%s','%s','%s');,pUser, pCode, pTime, pDescr) into tSQLQuery put tSQLQuery into url file:/tmp/Verify.sql put format(psql -F $\'\\t\' yourDbase -f /tmp/Verify.sql) into command_string # run the SQL commands and send the results back to the calling program set shellCommand to /bin/sh put shell(command_string) after tSQLQueryResult return tSQLQueryResult end insertEntry Note the little trick of writing the query to disk and then calling it back by reading it into the SQL shell cmd. You can also push unix style variables to shell like this: put tWrappedMsg into tMsg replace cr WITH \n in tMsg put tMsg into $DailyHPIEmail --put tMsg; exit to top # Do shell stuff and send mail set the shellcommand to /bin/sh put echo -e $DailyHPIEmail | sendmail -f [EMAIL PROTECTED] (fld to of cd staticText) into tCmd this works on OSX with PostFix enabled for sending mail ... But, we never bothered to try that for psql...or maybe we did but it didn't work.. can't recall...anyway, the pattern of calling your query from a file means you can keep nicely formated normal SQL queries in files/libs (or on cards in stacks...) and you don't have to build them run time in your CGI...they are easier to read, maintain and debug as separate files... Have fun... and a bit of history: FWIW: There were discussions a year or two ago about how robust this solution could be without a persistent Revolution process someone replied that he had been using Rev CGI where a new instance was called each time. he said it scaled up to the millions of hits. No problems. We only use Rev CGI on our server... (well almost... PHP is also being called by XOOPS and PMWiki) there are no persistent processes. a new instance is called for *every* GET request for every page at http:// www.himalayanacademy.com. We use include exec SSI's to bring in page chunks, and these trigger Rev CGI's for *every* single page that is delivered.. div id=linkList !--#exec cgi=/cgi-bin/local_nav_include.cgi -- /div pulls in a unique set of side bar links depending on the realm where the page lives (anyone need that? email me off line) and meanwhile also I have a custom 404 CGI and redirect that is constantly firing to handle in coming redirects (mostly mapping short, sweet URL's published in print to their real deep locations) (I can also send you that too) Meanwhile other CGI's are doing more robust stuff like processing Credit card transactions and handling form submissions no problem... Now I can't vouch for more than 30-50 instances a second... what would happen, but we are in that range right now, Apache and the CPUs hardly blink... and see no slow down whatsoever. I'm no expert but I think a persistent Rev process will die on the first hard script error... so there are advantages to just letting Apache load rev on every single call...watch out for zombies ... if you don't close the cgi properly you can get hung Rev CGI processes, but, because these are separate instances of Rev... they don't terminate your web site... just slow it down as each zombie starts eating the CPU speeds.. I once had up to 8 hung CGI processes ... Nothing bad happened... the sites were sluggish but functional until I got back from a weekend and someone said your site turned to cold molasses or worst case scenario.. I really blew it on a script for one form and users are getting 404's for that one page only. Whereas if your persistent Rev Process died and *all* your cgi's were tied to it. then a single failure will bring down the entire framework for anything but static HTML delivery... All pages using the persistent processes will start returning errors...
Re: Cgi and Database (stick to standards)
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: 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/2008-January/106071.html This is very encouraging, as the method use describe in that post is exactly what I'll be making for a client in two weeks. That post mentions Pierre Sahores' tutorial on creating persistent Rev CGI processes - do you have the link for that handy? -- Richard Gaskin Managing Editor, revJournal ___ Rev tips, tutorials and more: http://www.revJournal.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Cgi and Database (stick to standards)
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/2008-January/106071.html If you need multi-user/multi-application update/insert access to the data, then Rev is probably not the right solution. For other situations, I would say don't dismiss Rev's native data structures without thorough testing of the speed differences when compared to a RDBMS. Bernard On 2/7/08, Hershel Fisch [EMAIL PROTECTED] wrote: Another option is to use a conventional flat file database (i.e. text file). I've been using that with Rev cgi with no problem. I don¹t think that it will work with a million record plus, db. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Cgi and Database (stick to standards)
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/pipermail/use-revolution/2008-January/106071.html This is very encouraging, as the method use describe in that post is exactly what I'll be making for a client in two weeks. That post mentions Pierre Sahores' tutorial on creating persistent Rev CGI processes - do you have the link for that handy? -- Richard Gaskin Managing Editor, revJournal ___ Rev tips, tutorials and more: http://www.revJournal.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Cgi and Database (stick to standards)
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 host it actual is a linux v? Downloaded the latest Linux from the /downloads And doesn't work on any of em, unless there is any other engines to work with or whatever. Thanks, Hershel And while we are at it, I'd like to suggest if any body has any interest to make RUN REV a bit of a standard CGI tool, I think it should be marketed separately on its own page, with its own identity,free and very well documented as well, with the benefit to use the same language for full applications for well. full price. 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, 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, since it appears the database is already inside the cgi-bin directory. For the cgi, I don't use the http because I got to understand (after a lot of struggle) that that¹s only for the apache server other then that I use the regular path, e.g. In the same folder I just put filex.x for the document folder I use /filex.x. Also I tried everything I could think of. As you could see below in the examples. Another option is to use a conventional flat file database (i.e. text file). I've been using that with Rev cgi with no problem. I don¹t think that it will work with a million record plus, db. Richard But what I do see that no way to invest in a non standard item or project unless you know it in and out other wise you might end up in trouble. I put in a lot of time and effort in a web site doing the front end and it is very nice and works good but what does it matter the face if the brain is dead. (despite the advise not to because its not standard and might end up in hot water in case I will need help and to use PHP) Thanks, Hershel On Feb 6, 2008, at 8:37 PM, Hershel Fisch wrote: Hi all I'm in the works of creating a web site rev CGI which the interface is almost done, And now I'm stuck when it comes to the database part. Have no idea how to work this out tried various different way's and E.g. #!revolution on startup put 1 getTip1() into theData # write minimal set of HTTP headers to stdout put Content-Type: text/html cr put Content-Length: the length of theData cr cr put theData end startup function getTip1 get revGetDatabaseDriverPath() return it end getTip1 function getTip2 get revOpenDatabase(sqlite,http://localhost/cgi-bin/ testdb.db, , , , ) return it end getTip2 function getTip3 get revOpenDatabase(sqlite,testdb.db, , , , ) return it end getTip3 ERROR 500 Any help would be appreciated. Hershel Fisch ___ use-revolution mailing list [EMAIL PROTECTED] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list [EMAIL PROTECTED] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list [EMAIL PROTECTED] Please visit this url to subscribe, unsubscribe and manage your subscription preferences:http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Cgi and Database (stick to standards)
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, 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, since it appears the database is already inside the cgi-bin directory. For the cgi, I don't use the http because I got to understand (after a lot of struggle) that that¹s only for the apache server other then that I use the regular path, e.g. In the same folder I just put filex.x for the document folder I use /filex.x. Also I tried everything I could think of. As you could see below in the examples. Another option is to use a conventional flat file database (i.e. text file). I've been using that with Rev cgi with no problem. I don¹t think that it will work with a million record plus, db. Richard But what I do see that no way to invest in a non standard item or project unless you know it in and out other wise you might end up in trouble. I put in a lot of time and effort in a web site doing the front end and it is very nice and works good but what does it matter the face if the brain is dead. (despite the advise not to because its not standard and might end up in hot water in case I will need help and to use PHP) Thanks, Hershel On Feb 6, 2008, at 8:37 PM, Hershel Fisch wrote: Hi all I'm in the works of creating a web site rev CGI which the interface is almost done, And now I'm stuck when it comes to the database part. Have no idea how to work this out tried various different way's and E.g. #!revolution on startup put 1 getTip1() into theData # write minimal set of HTTP headers to stdout put Content-Type: text/html cr put Content-Length: the length of theData cr cr put theData end startup function getTip1 get revGetDatabaseDriverPath() return it end getTip1 function getTip2 get revOpenDatabase(sqlite,http://localhost/cgi-bin/ testdb.db, , , , ) return it end getTip2 function getTip3 get revOpenDatabase(sqlite,testdb.db, , , , ) return it end getTip3 ERROR 500 Any help would be appreciated. Hershel Fisch ___ use-revolution mailing list [EMAIL PROTECTED] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list [EMAIL PROTECTED] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list [EMAIL PROTECTED] Please visit this url to subscribe, unsubscribe and manage your subscription preferences:http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Cgi and Database (stick to standards)
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, since it appears the database is already inside the cgi-bin directory. For the cgi, I don't use the http because I got to understand (after a lot of struggle) that that¹s only for the apache server other then that I use the regular path, e.g. In the same folder I just put filex.x for the document folder I use /filex.x. Also I tried everything I could think of. As you could see below in the examples. Another option is to use a conventional flat file database (i.e. text file). I've been using that with Rev cgi with no problem. I don¹t think that it will work with a million record plus, db. Richard But what I do see that no way to invest in a non standard item or project unless you know it in and out other wise you might end up in trouble. I put in a lot of time and effort in a web site doing the front end and it is very nice and works good but what does it matter the face if the brain is dead. (despite the advise not to because its not standard and might end up in hot water in case I will need help and to use PHP) Thanks, Hershel On Feb 6, 2008, at 8:37 PM, Hershel Fisch wrote: Hi all I'm in the works of creating a web site rev CGI which the interface is almost done, And now I'm stuck when it comes to the database part. Have no idea how to work this out tried various different way's and E.g. #!revolution on startup put 1 getTip1() into theData # write minimal set of HTTP headers to stdout put Content-Type: text/html cr put Content-Length: the length of theData cr cr put theData end startup function getTip1 get revGetDatabaseDriverPath() return it end getTip1 function getTip2 get revOpenDatabase(sqlite,http://localhost/cgi-bin/ testdb.db, , , , ) return it end getTip2 function getTip3 get revOpenDatabase(sqlite,testdb.db, , , , ) return it end getTip3 ERROR 500 Any help would be appreciated. Hershel Fisch ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution