Re: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev
On Sat, May 22, 2010 at 11:17 PM, Lynn Fredricks lfredri...@proactive-intl.com wrote: Valentina on On-Rev is still a topic on the table. The reality is that a malicious curveball launched from a location in California is causing a momentary distraction to all parties. Thanks Lynn for your comments. To be brutally honest, most of my comments here are purely to create noise. I can fully appreciate that Kevin has a LOT more important things on his plate right now. Given your connection with both RunRev and Paradigma I figure that some sort of tie up is inevitable, it's just a matter of when, in what form and for what cost. I was just beating the drum in expectation that the band would start soon ;-) ___ 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: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev
Andre, thanks for the pointers. Got everything working plus after playing with phpPgAdmin found a few more features. Much appreciated. On Wed, May 19, 2010 at 9:20 PM, Andre Garzia an...@andregarzia.com wrote: Hi There Kay, What is the format of the data? Is it a csv file or something? Because if it is a text file, then you can upload the text file to your on-rev account and then use a SQL command such as COPY to parse and load the file. You don't need a option in phpPgAdmin to do it, you can just write the SQL command there. Check out http://www.postgresql.org/docs/8.1/static/sql-copy.html With this you'll be able to load a csv (or similar) file into postgresql It is not as straight forward as LOAD DATA INFILE but it is close. Cheers andre On Wed, May 19, 2010 at 5:01 AM, Kay C Lan lan.kc.macm...@gmail.com wrote: I'm guessing Andre is the guru to answer this one. How does one populate a postgreSQL db on On-Rev in bulk? MySQL's phpMyAdmin gives you both an Import option and the ability to enter raw SQL commands, ie LOAD DATA LOCAL INFILE, but the postgreSQL's phpPgAdmin has neither option. I'm not going to manually type in thousands of records. Thanks in advance And Ruslan, if you're reading, if On-Rev offered Valentina Free Server, I'd be trying to figure out how to do this with Valentina rather than postgreSQL, especially as I'd assume it would be as easy as using Valentina Studio's Connect to... Server option. ___ 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 -- http://www.andregarzia.com All We Do Is Code. ___ 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: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev
On Sat, May 22, 2010 at 12:54 AM, Bob Sneidar b...@twft.com wrote: I wouldn't look at it that way. You can get an all day ticket at Disneyland. You can ride all the rides, or just some of them, or none at all. You can't get a cheaper ticket if you promise not to ride some of the rides. It's kind of like that. Well it would be if Disneyland offered 'sepecial pensioners' day ticket for $72. Pensioners, who are unlikely to run around like mad and get on as many rides as possible, might think that this a good deal and conclude that Disney are doing the right thing by pensioners - but the normal day ticket is $72. [THE ABOVE IS HYPOTHETICAL, DISNEY DO NOT DO THIS] mySQL offers it's db free for non-profit. If I were a non-profit I would assume that it would cost me less to use mySQL than for a commercial outfit. I appreciate that for LAN use, a non-profit can use mySQL free whilst a commercial adventure has to pay. I'm just surprised that a commercial enterprise can save money by moving it's db off a LAN and onto a web host and have someone else pay their mySQL licensing fees. ___ 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: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev
On 22/5/10 1:25 PM, Kay C Lan lan.kc.macm...@gmail.com wrote: [THE ABOVE IS HYPOTHETICAL, DISNEY DO NOT DO THIS] mySQL offers it's db free for non-profit. If I were a non-profit I would assume that it would cost me less to use mySQL than for a commercial outfit. I appreciate that for LAN use, a non-profit can use mySQL free whilst a commercial adventure has to pay. I'm just surprised that a commercial enterprise can save money by moving it's db off a LAN and onto a web host and have someone else pay their mySQL licensing fees. I will not say that below 100% true, but I believe I have read that on different lists and mySQL license site * free for not profit? Okay. but do you know that on their site was said: if developer have developed app for use in company (!) of that developer -- license must be paid. * mySQL server is free for ISP itself. but if ISP now give access to his clients, clients should pay commercial license. May be something was changed after Oracle get mySQL, I did not check last year. -- 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: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev
On Sat, May 22, 2010 at 6:39 PM, Ruslan Zasukhin ruslan_zasuk...@valentina-db.com wrote: * mySQL server is free for ISP itself. but if ISP now give access to his clients, clients should pay commercial license. That seems sensible to me. I was just replying to comments made by Bob and in many respects made by yourself in another Thread. Andre mentioned using Valentina Free Server on On-Rev, but you countered that On-Rev was commercial therefore it should be Valentina Office Server. So given that Valentina offers Valentina Free Server for non-profits, like churches, how is possible for a church to create an online Address Book db, if you've stated that On-Rev would have to use the commercial Valentina Office Server? I'd love to see Valentina offered as an option on On-Rev, but if it is at additional cost, because it's Officer Server, then I'll have to continue with postgreSQL because my dbs are all non-profit. ___ 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: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev
On 22/5/10 2:15 PM, Kay C Lan lan.kc.macm...@gmail.com wrote: On Sat, May 22, 2010 at 6:39 PM, Ruslan Zasukhin ruslan_zasuk...@valentina-db.com wrote: * mySQL server is free for ISP itself. but if ISP now give access to his clients, clients should pay commercial license. That seems sensible to me. I was just replying to comments made by Bob and in many respects made by yourself in another Thread. Andre mentioned using Valentina Free Server on On-Rev, but you countered that On-Rev was commercial therefore it should be Valentina Office Server. So given that Valentina offers Valentina Free Server for non-profits, like churches, how is possible for a church to create an online Address Book db, if you've stated that On-Rev would have to use the commercial Valentina Office Server? If REV-ONLINE will use Valentina Office Server (on any agreement) Then we do not care how many dbs/users is used there. We sale - instance of vserver. So as far as I see, usage of vserver should not change price model of rev-online seri I'd love to see Valentina offered as an option on On-Rev, but if it is at additional cost, because it's Officer Server, then I'll have to continue with postgreSQL because my dbs are all non-profit. As far as I see, REV can pay once for single copy of vserver and after that start earn on that. Postgre always is a good choice now, because nobody even discuss yet really usage of vserver there. Only we here on list :) -- 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: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev
Hi Kay, That seems sensible to me. I was just replying to comments made by Bob and in many respects made by yourself in another Thread. Andre mentioned using Valentina Free Server on On-Rev, but you countered that On-Rev was commercial therefore it should be Valentina Office Server. So given that Valentina offers Valentina Free Server for non-profits, like churches, how is possible for a church to create an online Address Book db, if you've stated that On-Rev would have to use the commercial Valentina Office Server? I'd love to see Valentina offered as an option on On-Rev, but if it is at additional cost, because it's Officer Server, then I'll have to continue with postgreSQL because my dbs are all non-profit. Business guy here, Valentina hat on :-) Valentina on On-Rev is still a topic on the table. The reality is that a malicious curveball launched from a location in California is causing a momentary distraction to all parties. What Ruslan is talking about is how other products are licensed to ISPs, who then make choices about how they handle passing those costs onto their customers. Too many variables at this point to make much of it as of today. Another consideration is that On-Rev is currently a combination of app server licensing + ISP. A new dimension appears when/if On-Rev's App Server becomes available for licensing to customers so they can run it on their own. 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: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev
Kay C Lan wrote: mySQL offers it's db free for non-profit. Kinda sorta. MySQL is released under the GPL, so you can grab the source for free, compile it yourself, and sell it for $1000 if you like. But there's one catch: anything you make with it must also have its source available, and anyone could download your source and sell it too. Or give it away. Or modify it so it draws dancing chickens all over the user's screen if that's what they want to do, so long as they also make their source available. GPL moves the cost-of-entry from cash to skills: rather than be required to pay for it with money, you can pay for it with time to set up a C compiler and run a make file. It's only for closed-source projects that a copy of MySQL can be obtained under a separate proprietary license. -- Richard Gaskin Fourth World Rev training and consulting: http://www.fourthworld.com Webzine for Rev developers: http://www.revjournal.com revJournal blog: http://revjournal.com/blog.irv ___ 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: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev
Sure but read my recent posts on the limitations of a remote SQL server. Not a speed demon by any means. On-rev SQL is really primarily intended as a backend database for you web based apps. The way I am going at it has shown me that with certain applications I face serious limitations using a remote SQL. I should add a disclaimer to my app, don't try this at home! Bob Sneidar IT Manager Calvary Chapel CM Sent from iPhone On May 22, 2010, at 3:25, Kay C Lan lan.kc.macm...@gmail.com wrote: I appreciate that for LAN use, a non-profit can use mySQL free whilst a commercial adventure has to pay. I'm just surprised that a commercial enterprise can save money by moving it's db off a LAN and onto a web host and have someone else pay their mySQL licensing fees ___ 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: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev
Folks, I apologise, I post then depart for a couple of days and am unable to reply. I don't mean to be rude. Andre, Yes it's a plain tab delimited text file so I'll follow your link and give it a go. Thanks. On Thu, May 20, 2010 at 2:12 AM, Bob Sneidar b...@twft.com wrote: On-Rev is paying the fees to mySQL as a commercial venture, so the licensing restrictions have been satisfied. You ARE paying for mySQL use because you pay for On-Rev. Well this is interesting. As far as I can tell mySQL is just an option On-Rev offers, you are not charged more for using it, so what you are suggesting is that all the On-Rev users who don't use dbs, and those who use postgreSQL rather than mySQL are all subsidising the mySQL users. Seems to me then that the claims that non-profits can use these dbs for free are false. In fact it's probably worse than that, non-profits who don't even use dbs at all, like individuals/clubs who might have a simple web page, are subsidising commercial ventures that use mySQL. ___ 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: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev
I wouldn't look at it that way. You can get an all day ticket at Disneyland. You can ride all the rides, or just some of them, or none at all. You can't get a cheaper ticket if you promise not to ride some of the rides. It's kind of like that. I saw a great video of an English man trying to get the price down on a tooth extraction. He said that getting the cost down was of primary importance. After talking the dentist into not using an assistant, having no anesthetic, taking only 15 minutes as opposed to an hour, and making clear that the procedure would be excruciatingly painful this way, but after all low price was of paramount importance, he talked the dentist down from 1400 pounds to just 200! Once they had settled all that the man said, Excellent! I will send my wife right over! Bob On May 21, 2010, at 5:07 AM, Kay C Lan wrote: Well this is interesting. As far as I can tell mySQL is just an option On-Rev offers, you are not charged more for using it, so what you are suggesting is that all the On-Rev users who don't use dbs, and those who use postgreSQL rather than mySQL are all subsidising the mySQL users. Seems to me then that the claims that non-profits can use these dbs for free are false. In fact it's probably worse than that, non-profits who don't even use dbs at all, like individuals/clubs who might have a simple web page, are subsidising commercial ventures that use mySQL. ___ 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: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev
On 21/05/2010 19:54, Bob Sneidar wrote: I wouldn't look at it that way. You can get an all day ticket at Disneyland. You can ride all the rides, or just some of them, or none at all. You can't get a cheaper ticket if you promise not to ride some of the rides. It's kind of like that. I saw a great video of an English man trying to get the price down on a tooth extraction. He said that getting the cost down was of primary importance. After talking the dentist into not using an assistant, having no anesthetic, taking only 15 minutes as opposed to an hour, and making clear that the procedure would be excruciatingly painful this way, but after all low price was of paramount importance, he talked the dentist down from 1400 pounds to just 200! Once they had settled all that the man said, Excellent! I will send my wife right over! Bob I did better than that in Carbondale, Illinois in 1995. I was due to have a root canal and they were going to charge me $2000 ( a sum I didn't have) and were unable to understand why I felt that was expensive (it's cheap because the University dentistry is subsidised). I told them there was absolutely no way I could pay that for a root canal and a crown; but if they could just kill the nerve and plug the hole my Father-in-law would do the rest in Bulgaria for nothing. Bless them; they killed the nerve and plugged the hole (and 2 weeks' later Tatko put in a post and a gold crown which is with me still - although, sadly he is not) and charged me nothing. I still don't have $2000; but I have bought a pair of pliers so my kids get the gold when I move on! And the lesson is: always let a Scotsman in a kilt who has connections in Bulgaria off the hook . . . :) ___ 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
[SQL][On-Rev] Bulk import into PostgreSQL on On-Rev
I'm guessing Andre is the guru to answer this one. How does one populate a postgreSQL db on On-Rev in bulk? MySQL's phpMyAdmin gives you both an Import option and the ability to enter raw SQL commands, ie LOAD DATA LOCAL INFILE, but the postgreSQL's phpPgAdmin has neither option. I'm not going to manually type in thousands of records. Thanks in advance And Ruslan, if you're reading, if On-Rev offered Valentina Free Server, I'd be trying to figure out how to do this with Valentina rather than postgreSQL, especially as I'd assume it would be as easy as using Valentina Studio's Connect to... Server option. ___ 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: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev
On 19/5/10 11:01 AM, Kay C Lan lan.kc.macm...@gmail.com wrote: Hi Kay, About postgre -- may be you can prepare db on local computer then upload to server? And Ruslan, if you're reading, if On-Rev offered Valentina Free Server, I'd be trying to figure out how to do this with Valentina rather than postgreSQL, especially as I'd assume it would be as easy as using Valentina Studio's Connect to... Server option. Well, A) REC community you can ask for that REV team. The more requests the better. Right? :) B) as far as I see On-Rev is a commercial service. Right? So it cannot use Valentina Free Server. But I do not see problems why Lynn and Rev Team cannot make agreement on usage of Valentina Office Server for some small fees. -- 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: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev
On Wed, May 19, 2010 at 5:06 PM, Ruslan Zasukhin ruslan_zasuk...@valentina-db.com wrote: About postgre -- may be you can prepare db on local computer then upload to server? I'm new to On-Rev and I couldn't see where the db files were stored. I'm hoping Andre or someone else can lead me in the right direction. Well, A) REC community you can ask for that REV team. The more requests the better. Right? :) Exactly - which is why I posted to the Rev Use List. I saw On-Rev and Valentina mentioned in another thread on the List so I figured it could hurt to add to the noise :-) B) as far as I see On-Rev is a commercial service. Right? So it cannot use Valentina Free Server. But I do not see problems why Lynn and Rev Team cannot make agreement on usage of Valentina Office Server for some small fees. Well, and I admit I don't understand it fully, but I think this is where some of the ambiguity of mySQL licensing comes in. I have a local mySQL db, it's non-commercial, so I don't pay licensing fees. If I set up a server at home and accessed it over the internet, it would still be non-commercial and I still wouldn't pay mySQL licensing fees. But that is more expensive than paying for a hosting service, so I use On-Rev. IMO On-Rev serves my content, they are not too involved with what that content is, be it html files, zip file or db files. To me, On-Rev is NOT a commercial DB Server, they are just a Server, if I use the Server to place my Commercial DB, then it is for me to pay licensing fees, not me + On-Rev to both pay fees to mySQL. I can see that this could be difficult to police, but I assume it's no different to me storing and distributing music/movies on a Server. Should On-Rev pay distribution fees for movies I store on their Server which I then download when I'm out of town for the return plane trip? If I let anyone download the movies, then it is me who should be paying the fees. It would be nice if you could come to some workable agreement. ___ 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: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev
Hi There Kay, What is the format of the data? Is it a csv file or something? Because if it is a text file, then you can upload the text file to your on-rev account and then use a SQL command such as COPY to parse and load the file. You don't need a option in phpPgAdmin to do it, you can just write the SQL command there. Check out http://www.postgresql.org/docs/8.1/static/sql-copy.html With this you'll be able to load a csv (or similar) file into postgresql It is not as straight forward as LOAD DATA INFILE but it is close. Cheers andre On Wed, May 19, 2010 at 5:01 AM, Kay C Lan lan.kc.macm...@gmail.com wrote: I'm guessing Andre is the guru to answer this one. How does one populate a postgreSQL db on On-Rev in bulk? MySQL's phpMyAdmin gives you both an Import option and the ability to enter raw SQL commands, ie LOAD DATA LOCAL INFILE, but the postgreSQL's phpPgAdmin has neither option. I'm not going to manually type in thousands of records. Thanks in advance And Ruslan, if you're reading, if On-Rev offered Valentina Free Server, I'd be trying to figure out how to do this with Valentina rather than postgreSQL, especially as I'd assume it would be as easy as using Valentina Studio's Connect to... Server option. ___ 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 -- http://www.andregarzia.com All We Do Is Code. ___ 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: [SQL][On-Rev] Bulk import into PostgreSQL on On-Rev
On-Rev is paying the fees to mySQL as a commercial venture, so the licensing restrictions have been satisfied. You ARE paying for mySQL use because you pay for On-Rev. Bob On May 19, 2010, at 4:07 AM, Kay C Lan wrote: To me, On-Rev is NOT a commercial DB Server, they are just a Server, if I use the Server to place my Commercial DB, then it is for me to pay licensing fees, not me + On-Rev to both pay fees to mySQL. ___ 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