http://permalink.gmane.org/gmane.comp.lang.ruby.camping.general hourly 1 1901-01-01T00:00+00:00 http://gmane.org/img/gmane-25t.png http://gmane.org http://permalink.gmane.org/gmane.comp.lang.ruby.camping.general/1929 <pre>On 4: http://api.rubyonrails.org/classes/ActiveRecord/Migration.html#label-Reversible+Migrations Looks like you just define the up, AR takes care of the rest. Never tried it, it'll save a few lines of code though. On injection, AR sanitizes almost everything I believe. The only thing I know to avoid is using a user set variable straight in a string: "thing = #{&lt; at &gt;input.user_var}" That's dangerous, you're supposed to do this: "thing = ?", &lt; at &gt;input.user_var Dave On Mon, May 21, 2012 at 4:52 AM, Dave Everitt &lt;deveritt-PAToI0hbvL4qdlJmJB21zg&lt; at &gt;public.gmane.org&gt; wrote: </pre> David Susco 2012-05-21T12:53:51 http://permalink.gmane.org/gmane.comp.lang.ruby.camping.general/1928 <pre>Thanks Nokan, Dave, Philippe for your replies, it's good to get a measure of standard practice even for things as simple as this. There just remains no. 4 (from a question by Isak Andersson http://comments.gmane.org/gmane.comp.lang.ruby.camping.general/1751) for which I'd like an opinion, since I can't find a definitive answer from the AR docs... and can only fond a reference to it on the Ember GitHub readme: https://github.com/EmberAds/acts_as_uuid or slide 21 of this AR intro: http://www.slideshare.net/blazingcloud/active-record-introduction-3 since I've only ever used 'up' and 'down' (and don't use Rails) this isn't obvious to me :-) Finally, what's a good approach to security (SQL injection?) for a public app? DaveE </pre> Dave Everitt 2012-05-21T08:52:30 http://permalink.gmane.org/gmane.comp.lang.ruby.camping.general/1927 <pre>I personally always use a config/database.yml file as I like to keep the configuration out of the code. Plus it makes it easier to switch between development and production configuration. E.g. for Heroku: dbconfig = YAML.load(File.read('config/database.yml')) # On Heroku the production database,yml is configured automatically environment = ENV['DATABASE_URL'] ? 'production' : 'development' Camping::Models::Base.establish_connection dbconfig[environment] On 5/15/2012 11:39 AM, Dave Everitt wrote: _______________________________________________ Camping-list mailing list Camping-list-GrnCvJ7WPxnNLxjTenLetw&lt; at &gt;public.gmane.org http://rubyforge.org/mailman/listinfo/camping-list</pre> Philippe Monnet 2012-05-21T01:58:15 http://permalink.gmane.org/gmane.comp.lang.ruby.camping.general/1926 <pre>Hi, Just a comment: I don't think it's a good practice to set the database details (establish_connection() call) in the application itself. It's an environmental issue, and this way you lose the possibility to move your app between dev, ((devtest)), (test) and production environments without modifications. On Tue, May 15, 2012 at 7:39 PM, Dave Everitt &lt;deveritt-PAToI0hbvL4qdlJmJB21zg&lt; at &gt;public.gmane.org&gt;wrote: _______________________________________________ Camping-list mailing list Camping-list-GrnCvJ7WPxnNLxjTenLetw&lt; at &gt;public.gmane.org http://rubyforge.org/mailman/listinfo/camping-list</pre> Nokan Emiro 2012-05-16T15:59:20 http://permalink.gmane.org/gmane.comp.lang.ruby.camping.general/1925 <pre>1) I usually do 1.3: def self.connect env App::Models::Base.establish_connection App.config[env]['db_connection'] App::Models::Base.logger = Logger.new File.dirname(__FILE__) + App.config[env]['db_log'] end def self.create env = 'dev' self.connect env self.create_schema end 2) I've never tried it without specifying the adapter, I figure it can't hurt to keep it in there. Plus it makes all the env's in my config file look the same. 3) So long as it's using migrations (the &lt; V /d after the class name) it won't delete anything by running a connect again after the db has been created. class CreateApp &lt; V 1.0 def self.up create_table User.table_name do |t| t.string :name t.timestamps end end def self.down drop_table User.table_name end end Dave On Tue, May 15, 2012 at 1:39 PM, Dave Everitt &lt;deveritt-PAToI0hbvL4qdlJmJB21zg&lt; at &gt;public.gmane.org&gt; wrote: </pre> David Susco 2012-05-15T18:49:42 http://permalink.gmane.org/gmane.comp.lang.ruby.camping.general/1924 <pre>I know this isn't Python, but I'd like to get a view on the 'one obvious' way to set up an SQLite (or other) database and its location per-app. I've got a bit lost with the Camping 2 changes and various code snippets I have kicking around. 1. is it best to set up the DB creation/connection: 1.1 at the end of the app AppName::Models::Base.establish_connection( :adapter =&gt; 'sqlite3', :database =&gt; '/path/to/my/app/myApp.db' ) run AppName #from an old snippet 1.2 OR like this (postgres) example [Magnus]: def List.create List::Models::Base.establish_connection( :adapter =&gt; "postgresql", :username =&gt; "root", :password =&gt; "toor, :database =&gt; "list" ) List::Models.create_schema end 1.3 in a config/database.yml file [Magnus] (probably not worth it for SQLite): --- adapter: postgresql username: root password: toor database: mycampingdb And then do: require 'yaml' def AppName.create AppName ::Models ::Base.establish_connection(YAML.load(File.read("database.yml"))) AppN</pre> Dave Everitt 2012-05-15T17:39:04 http://permalink.gmane.org/gmane.comp.lang.ruby.camping.general/1923 <pre>Just a note - to see changes to your app on reload you'll need a 'tmp' directory in the app's dir containing a blank text file 'always_restart.txt': www/tmp/always_restart.txt DaveE _______________________________________________ Camping-list mailing list Camping-list-GrnCvJ7WPxnNLxjTenLetw&lt; at &gt;public.gmane.org http://rubyforge.org/mailman/listinfo/camping-list</pre> Dave Everitt 2012-05-09T14:26:23 http://permalink.gmane.org/gmane.comp.lang.ruby.camping.general/1922 <pre>We'd need a syntax highlighting gem on the server, but it should be easy enough to construct such a snippet otherwise — Jenna On Wednesday, 9 May 2012 at 8:14 PM, Dave Everitt wrote: _______________________________________________ Camping-list mailing list Camping-list-GrnCvJ7WPxnNLxjTenLetw&lt; at &gt;public.gmane.org http://rubyforge.org/mailman/listinfo/camping-list</pre> Jenna Fox 2012-05-09T10:31:03 http://permalink.gmane.org/gmane.comp.lang.ruby.camping.general/1921 <pre> marking web design classes this week(!), so when I take a break I'll try it out with the blog app after using it locally then transferring to the server with the db file, and let you know... be good to have a list of available gems (unless you already did that!) Dave _______________________________________________ Camping-list mailing list Camping-list-GrnCvJ7WPxnNLxjTenLetw&lt; at &gt;public.gmane.org http://rubyforge.org/mailman/listinfo/camping-list</pre> Dave Everitt 2012-05-09T10:31:31 http://permalink.gmane.org/gmane.comp.lang.ruby.camping.general/1920 <pre> I just added a link to the github repo on my links app, but if you have a snippet to display an app's code in formatted and syntax- coloured style... and you've done that job rather well :-) DaveE </pre> Dave Everitt 2012-05-09T10:14:02 http://permalink.gmane.org/gmane.comp.lang.ruby.camping.general/1919 <pre>Heroku are the big tires, camping is the little wheels. They aren't a great fit. Heroku for example has a read-only file system and I believe no database in the free tier. This is a great little service we can build interesting things on. How about a remote server reloader? Streaming logs? Push notification stream server? View Source link for open web apps and demos. — Jenna Fox On Wednesday, 9 May 2012 at 1:30 PM, gurugeek wrote: _______________________________________________ Camping-list mailing list Camping-list-GrnCvJ7WPxnNLxjTenLetw&lt; at &gt;public.gmane.org http://rubyforge.org/mailman/listinfo/camping-list</pre> Jenna Fox 2012-05-09T05:03:03 http://permalink.gmane.org/gmane.comp.lang.ruby.camping.general/1918 <pre> On May 8, 2012, at 4:04 PM, Anthony Durity wrote: I forgot to add these important limitations: - Presently No DB Support beside sqlite and couchdb if you use it via iriscouch or a similar service; - No professional support - so it is free but beside some help that I am willing to give to make sure that the service runs properly it cannot be compared with a professional service where you pay hence you can expect support In terms of benefits thou the app should run considerably faster than on the free tier of heroku because of the non-virtualization and the SSD hard drives - in my tests sqlite and all in general ix x 5 times than in a traditional HD or on EC2. The idea is to get people to learn and use camping and deploy it /see their app live immediately. It should be a good learning tool but not to run a professional application with clients etc. or where you expect a lot of support. </pre> gurugeek 2012-05-09T03:30:48 http://permalink.gmane.org/gmane.comp.lang.ruby.camping.general/1917 <pre> On May 8, 2012, at 10:51 PM, Dave Everitt wrote: It should :) If you want to test it I will be grateful. Fixing ATM some issues with installing extra gems so trying to find a clever solution to make most app run without intervention. _______________________________________________ Camping-list mailing list Camping-list-GrnCvJ7WPxnNLxjTenLetw&lt; at &gt;public.gmane.org http://rubyforge.org/mailman/listinfo/camping-list</pre> gurugeek 2012-05-09T03:24:39 http://permalink.gmane.org/gmane.comp.lang.ruby.camping.general/1916 <pre> On May 8, 2012, at 4:04 PM, Anthony Durity wrote: My understanding is that Heroku uses a different system for what I gather mostly virtualized. This is a running on a traditional physical dedicated server. My idea of the use was to be able to deploy a camping app directly from the code in github. So once you have it in github you don't need to push it to another git (as I think it is the case on heroku) but just fetch and run it from the admin. There are some soft limitations on memory usage - mostly to avoid abuse and not to slow down the app - it is entirely free. why not? :) </pre> gurugeek 2012-05-09T03:23:46 http://permalink.gmane.org/gmane.comp.lang.ruby.camping.general/1915 <pre>So if my SQLite db file is also in my repo and the path to it is in my app, sounds like the whole lot will transfer fine - DaveE _______________________________________________ Camping-list mailing list Camping-list-GrnCvJ7WPxnNLxjTenLetw&lt; at &gt;public.gmane.org http://rubyforge.org/mailman/listinfo/camping-list</pre> Dave Everitt 2012-05-08T20:51:10 http://permalink.gmane.org/gmane.comp.lang.ruby.camping.general/1914 <pre>Is this like Heroku or something? What are the use cases for this? It's an app server? What are the limitations? How much does it cost? If it is free, why is it free? On Sun, May 6, 2012 at 1:57 AM, gurugeek &lt;1&lt; at &gt;1.ai&gt; wrote: _______________________________________________ Camping-list mailing list Camping-list-GrnCvJ7WPxnNLxjTenLetw&lt; at &gt;public.gmane.org http://rubyforge.org/mailman/listinfo/camping-list</pre> Anthony Durity 2012-05-08T14:04:51 http://permalink.gmane.org/gmane.comp.lang.ruby.camping.general/1913 <pre>Actually I did miss the fact that you had a capital B on the repo so anyway it works now in the sense that it fetches the script and shows the ruby include errors on the screen... will install the gems tomorrow and see if all works fine ! On May 7, 2012, at 2:49 AM, Jenna Fox wrote: _______________________________________________ Camping-list mailing list Camping-list-GrnCvJ7WPxnNLxjTenLetw&lt; at &gt;public.gmane.org http://rubyforge.org/mailman/listinfo/camping-list</pre> gurugeek 2012-05-07T03:21:29 http://permalink.gmane.org/gmane.comp.lang.ruby.camping.general/1912 <pre>Fixed the validation but I am having a weird error in fetching from your repo: odin install https://github.com/bluebie/whywentcamping.com.git fatal: https://github.com/bluebie/whywentcamping.com.git/info/refs not found: did you run git update-server-info on the server? Cloning of https://github.com/bluebie/whywentcamping.com.git failed Now I forked your repo on a dummy github account (1ai) and it doesn't give me this error. Yet it won't run because the config.ru file is not as per example and has a number of non working requires from /var/www/config.ru:5 from /opt/lib/ruby/gems/1.8/gems/rack-1.4.1/lib/rack/builder.rb:51:in `instance_eval' from /opt/lib/ruby/gems/1.8/gems/rack-1.4.1/lib/rack/builder.rb:51:in `initialize' from /var/www/config.ru:1:in `new' from /var/www/config.ru:1 I have fixed that (with a new config file https://github.com/1ai/whywentcamping.com/blob/master/config.ru) but there are a lot of gems not installed for users by default: require 'rubygems' require 'camping' require 'fi</pre> gurugeek 2012-05-07T01:47:32 http://permalink.gmane.org/gmane.comp.lang.ruby.camping.general/1911 <pre>A lot of repos for websites have dots in them, should fix it to support anything github can support. — Jenna On Monday, 7 May 2012 at 10:30 AM, gurugeek wrote: _______________________________________________ Camping-list mailing list Camping-list-GrnCvJ7WPxnNLxjTenLetw&lt; at &gt;public.gmane.org http://rubyforge.org/mailman/listinfo/camping-list</pre> Jenna Fox 2012-05-07T00:49:03 http://permalink.gmane.org/gmane.comp.lang.ruby.camping.general/1910 <pre> On May 7, 2012, at 2:23 AM, Jenna Fox wrote: Yes this should be easy to do - could put both I think email or username I think the check in the script doesn't allow a repository to have a points inside it ..is it very common ? Can fix this but if you want to try in the interim just use any repo without a . on it :) Thanks again for testing this out David _______________________________________________ Camping-list mailing list Camping-list-GrnCvJ7WPxnNLxjTenLetw&lt; at &gt;public.gmane.org http://rubyforge.org/mailman/listinfo/camping-list</pre> gurugeek 2012-05-07T00:30:55 http://permalink.gmane.org/gmane.comp.lang.ruby.camping.general/1909 <pre>Things: 1) It'd be super cool if the user types in their email address as the username if it still works 2) I wonder what I'm doing wrong? I enter in bluebie/whywentcamping.com in the github repo name and it says my url contains invalid characters? — Jenna On Sunday, 6 May 2012 at 10:41 AM, gurugeek wrote: _______________________________________________ Camping-list mailing list Camping-list-GrnCvJ7WPxnNLxjTenLetw&lt; at &gt;public.gmane.org http://rubyforge.org/mailman/listinfo/camping-list</pre> Jenna Fox 2012-05-07T00:23:49 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.lang.ruby.camping.general