Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p><strong>[Update]</strong></p> <p>While the solution under "old answer" will work for general problems, this section is to answer your specific question after clarification from your comment.</p> <p>You should be able to set environment variables exactly like you specify in your question. As an example, I have a Heroku app that uses HTTP basic authentication.</p> <pre><code># app/controllers/application_controller.rb class ApplicationController &lt; ActionController::Base protect_from_forgery before_filter :authenticate def authenticate authenticate_or_request_with_http_basic do |username, password| username == ENV['HTTP_USER'] &amp;&amp; password == ENV['HTTP_PASS'] end end end # config/initializers/dev_environment.rb unless Rails.env.production? ENV['HTTP_USER'] = 'testuser' ENV['HTTP_PASS'] = 'testpass' end </code></pre> <p>So in your case you would use</p> <pre><code>unless Rails.env.production? ENV['admin_password'] = "secret" end </code></pre> <p>Don't forget to restart the server so the configuration is reloaded!</p> <p><strong>[Old Answer]</strong></p> <p>For app-wide configuration, you might consider a solution like the following:</p> <p>Create a file <code>config/application.yml</code> with a hash of options you want to be able to access:</p> <pre><code>admin_password: something_secret allow_registration: true facebook: app_id: application_id_here app_secret: application_secret_here api_key: api_key_here </code></pre> <p>Now, create the file <code>config/initializers/app_config.rb</code> and include the following:</p> <pre><code>require 'yaml' yaml_data = YAML::load(ERB.new(IO.read(File.join(Rails.root, 'config', 'application.yml'))).result) APP_CONFIG = HashWithIndifferentAccess.new(yaml_data) </code></pre> <p>Now, anywhere in your application, you can access <code>APP_CONFIG[:admin_password]</code>, along with all your other data. (Note that since the initializer includes <code>ERB.new</code>, your YAML file can contain ERB markup.)</p>
    singulars
    1. This table or related slice is empty.
    1. POIs it possible to set ENV variables for rails development environment in my code?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMichelle Tilley
    1. USMichelle Tilley
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POIs it possible to set ENV variables for rails development environment in my code?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COWell, I'm using Heroku and they allow you to set some ENV variables for things like passwords that you don't want checked into source control. I'm trying to figure out the best thing to do on my dev machine. And yes, I am trying to use the data inside my app.
      singulars
      1. PO
      1. USLan
    2. COThe answer has been updated to match your new details.
      singulars
      1. PO
      1. USMichelle Tilley
    3. COGlad to hear it! If you feel an answer is correct, you should mark it by checking the check mark next to the question. It will earn you and the answerer reputation and also help people who find this question in the future locate the correct answer.
      singulars
      1. PO
      1. USMichelle Tilley
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload