database.yml.example-优快云博客

本文链接：https://blog.youkuaiyun.com/wbj0110/article/details/84595886

本文提供了一个示例文件database.yml，用于配置Rails应用中的MySQL、PostgreSQL和SQLite3数据库连接。包括了开发、测试和生产环境的具体配置参数。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

database.yml.example mysql2

 
         # MySQL. Versions 4.1 and 5.0 are recommended.
        
         #
        
         # Install the MySQL driver:
        
         # gem install mysql2
        
         #
        
         # And be sure to use new-style password hashing:
        
         # http://dev.mysql.com/doc/refman/5.0/en/old-client.html
        
         development:
        
         adapter: mysql2
        
         encoding: utf8
        
         reconnect: false
        
         database: test-mysql2_development
        
         pool: 5
        
         username: root
        
         password:
        
         socket: /tmp/mysql.sock
        
         # Warning: The database defined as "test" will be erased and
        
         # re-generated from your development database when you run "rake".
        
         # Do not set this db to the same as development or production.
        
         test:
        
         adapter: mysql2
        
         encoding: utf8
        
         reconnect: false
        
         database: test-mysql2_test
        
         pool: 5
        
         username: root
        
         password:
        
         socket: /tmp/mysql.sock
        
         production:
        
         adapter: mysql2
        
         encoding: utf8
        
         reconnect: false
        
         database: test-mysql2_production
        
         pool: 5
        
         username: root
        
         password:
        
         socket: /tmp/mysql.sock

database.yml.example postresql

 
         # PostgreSQL. Versions 7.4 and 8.x are supported.
        
         #
        
         # Install the pg driver:
        
         # gem install pg
        
         # On Mac OS X with macports:
        
         # gem install pg -- --with-pg-config=/opt/local/lib/postgresql84/bin/pg_config
        
         # On Windows:
        
         # gem install pg
        
         # Choose the win32 build.
        
         # Install PostgreSQL and put its /bin directory on your path.
        
         development:
        
         adapter: postgresql
        
         encoding: unicode
        
         database: test-postgres_development
        
         pool: 5
        
         username: test-postgres (or your username if PostgreSQL installed by Homebrew)
        
         password:
        
         # Connect on a TCP socket. Omitted by default since the client uses a
        
         # domain socket that doesn't need configuration. Windows does not have
        
         # domain sockets, so uncomment these lines.
        
         #host: localhost
        
         #port: 5432
        
         # Schema search path. The server defaults to $user,public
        
         #schema_search_path: myapp,sharedapp,public
        
         # Minimum log levels, in increasing order:
        
         # debug5, debug4, debug3, debug2, debug1,
        
         # log, notice, warning, error, fatal, and panic
        
         # The server defaults to notice.
        
         #min_messages: warning
        
         # Warning: The database defined as "test" will be erased and
        
         # re-generated from your development database when you run "rake".
        
         # Do not set this db to the same as development or production.
        
         test:
        
         adapter: postgresql
        
         encoding: unicode
        
         database: test-postgres_test
        
         pool: 5
        
         username: test-postgres (or your username if PostgreSQL installed by Homebrew)
        
         password:
        
         production:
        
         adapter: postgresql
        
         encoding: unicode
        
         database: test-postgres_production
        
         pool: 5
        
         username: test-postgres
        
         password:

database.yml.example sqlite3

 
         # SQLite version 3.x
        
         # gem install sqlite3
        
         development:
        
         adapter: sqlite3
        
         database: db/development.sqlite3
        
         pool: 5
        
         timeout: 5000
        
         # Warning: The database defined as "test" will be erased and
        
         # re-generated from your development database when you run "rake".
        
         # Do not set this db to the same as development or production.
        
         test:
        
         adapter: sqlite3
        
         database: db/test.sqlite3
        
         pool: 5
        
         timeout: 5000
        
         production:
        
         adapter: sqlite3
        
         database: db/production.sqlite3
        
         pool: 5
        
         timeout: 5000