[B! rails][PostgreSQL] patorashã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

patorash id:patorash

railsã¨PostgreSQLã«é–¢ã™ã‚‹patorashã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (12)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

Redisã¯æœ¬å½“ã«å¿…è¦ã‹ï¼ŸPostgreSQLã ã‘ã‚ã‚Œã°ååˆ†
ã“ã®è¨˜äº‹ã¯ã€è‘—è€…ã®è¨±å¯ã‚’å¾—ã¦é…ä¿¡ã—ã¦ã„ã¾ã™ã€‚ Do You Really Need Redis? How to Get Away with Just PostgreSQL Webã‚µãƒ¼ãƒ“ã‚¹ã‚„ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«å¯¾å¿œã™ã‚‹ãŸã‚ã«ã€ä½•åº¦ã‚‚è¦‹ã¦ããŸè©¦è¡ŒéŒ¯èª¤ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ãŒã‚ã‚Šã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã¨ã—ã¦ã®PostgreSQL ãƒãƒƒã‚¯ã‚°ãƒ©ã‚¦ãƒ³ãƒ‰ã®ã‚¸ãƒ§ãƒ–ã‚ãƒ¥ãƒ¼ï¼ˆãŠã‚ˆã³é™å®šçš„ãªã‚¢ãƒˆãƒŸãƒƒã‚¯æ“ä½œï¼‰ã‚’èª¿æ•´ã™ã‚‹ãŸã‚ã®Redis Redisã¯ç´ æ™´ã‚‰ã—ã„ã‚‚ã®ã§ã™ãŒã€ã“ã®ã‚¹ã‚¿ãƒƒã‚¯ã®æœ€ã‚‚ä¸€èˆ¬çš„ãªä½¿ç”¨ä¾‹ã‚’å®Ÿã¯PostgreSQLã ã‘ã§å®Ÿç¾ã§ãã‚‹ã¨è¨€ã£ãŸã‚‰ã©ã†ã§ã—ã‚‡ã†ï¼Ÿ ä½¿ç”¨ä¾‹1ï¼šã‚¸ãƒ§ãƒ–ã®ã‚ãƒ¥ãƒ¼ã‚¤ãƒ³ã‚° ç§ãŒè¦‹ã¦ããŸRedisã®æœ€ã‚‚ä¸€èˆ¬çš„ãªä½¿ã„æ–¹ã¯ã€Webã‚µãƒ¼ãƒ“ã‚¹ã‹ã‚‰ãƒãƒƒã‚¯ã‚°ãƒ©ã‚¦ãƒ³ãƒ‰ãƒ»ãƒ¯ãƒ¼ã‚«ãƒ¼ã®ãƒ—ãƒ¼ãƒ«ã¸ã®ã‚¸ãƒ§ãƒ–ã®ãƒ‡ã‚£ã‚¹ãƒ‘ãƒƒãƒèª¿æ•´ã§ã—ã‚‡ã†ã€‚ãã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆã¯ã€ï¼ˆãŠãã‚‰ãå…¥åŠ›ãƒ‡ãƒ¼ã‚¿ã‚’ä½¿ã£ã¦ï¼‰å®Ÿè¡Œã•ã‚Œã‚‹ã¹ããƒãƒƒã‚¯ã‚°ãƒ©ã‚¦ãƒ³ãƒ‰ãƒ»ã‚¸ãƒ§ãƒ–ã®
patorash 2022/07/14
ãã†ã¯ã„ã£ã¦ã‚‚Sidekiqã§RedisãŒå¿…è¦ã ã‹ã‚‰ãªãâ€¦ã€‚å¤‰æ›´ã§ãã‚‹ã‚“ã‹ãªï¼Ÿ

postgresql

redis

rails
ãƒªãƒ³ã‚¯
ç«¹å³¶ã®åº§æ¨™ãŒãŠã‹ã—ã„ã£ã¦è©±ã‚’èª¿ã¹ã¦ã¿ãŸ - smellman's Broken Diary
ï¼‘ï¼™ï¼ï¼•å¹´å½“æ™‚ã®ã€Œå³¶æ ¹çœŒå‘Šç¤ºã€ã‚’ï¼§ï¼°ï¼³ã§ç¢ºèªã—ãŸã‚‰ç«¹å³¶ä½ç½®ã¯ç‹¬å³¶ã¨é•ã£ãŸãžï¼ï¾„ï¾žï¾”ï½¯ ã“ã®è¨˜äº‹ã‚’èªã‚“ã§ã€ã©ã†ã›æ¸¬åœ°ç³»ã®å•é¡Œã ã‚ã†ã¨æ€ã£ã¦å¤‰æ›ã‚’ã—ã¦ã¿ãŸã®ã ã‘ã©ã€å…¨ç„¶ç«¹å³¶ã¨ã‚ã‚ãªãã£ã¦ãªã‚“ã ã‚ã†ã¨æ€ã£ãŸã‚‰ã€wikipediaã«ä»¥ä¸‹ã®ã‚ˆã†ãªè¨˜è¿°ãŒã‚ã£ãŸã€‚ ã‹ã¤ã¦æ—¥æœ¬æ”¿åºœå¤–å‹™çœã¯åŒ—ç·¯37åº¦9åˆ†ã€æ±çµŒ131åº¦55åˆ†ã¨è¨˜ã—ã¦ã„ãŸã€‚2005å¹´ï¼ˆå¹³æˆ17å¹´ï¼‰7æœˆã«æ¯Žæ—¥æ–°èžã«ã‚ˆã£ã¦èª¤ã‚ŠãŒæŒ‡æ‘˜ã•ã‚Œã‚‹ã¨ã€æ£ã—ã„è¨˜è¿°ã«è¨‚æ£ã•ã‚ŒãŸã€‚ ç«¹å³¶ (å³¶æ ¹çœŒ) - Wikipedia å¹³ãŸãè¨€ã†ã¨äººé–“ã®ãƒŸã‚¹ã§ã€ã‚‚ã†ä¿®æ£ã•ã‚Œã¦ã„ã‚‹ã‚‚ã®ãªã®ã«ã‚ã–ã‚ã–è¨¼æ‹ ã ã€œè¨¼æ‹ ã ã€œã¨è¨€ã£ã¦ã„ã‚‹ã¨ã„ã†ãªã‚“ã¦ã„ã†ã‹æ¿€ã—ãã©ã†ã§ã‚‚è‰¯ã„ã‚ªãƒã§ã—ãŸã€‚ ã¡ãªã¿ã«ç¢ºèªã«ä½¿ã£ãŸãƒ—ãƒã‚°ãƒ©ãƒ ã¯ä»¥ä¸‹ã®ã¨ãŠã‚Šã€‚Ruby on Rails+PostGISã‚¢ãƒ€ãƒ—ã‚¿ã§ã‚»ãƒƒãƒ†ã‚£ãƒ³ã‚°ã•ã‚Œã¦ã„ã‚‹ã¨ã“ã‚ã§ rails console ã§å©ãå¿…è¦ã‚ã‚Šã¾ã™ã€‚ def parse_lo
patorash 2015/04/03
æ¸¬åœ°ç³»å¤‰æ›ã®è©±ã€‚

postgis

postgresql

rails
ãƒªãƒ³ã‚¯
PostGIS and Rails: A Simple Approach
PostGIS is a geospatial extension library for PostgreSQL that allows you to perform a ton of geometric and geographic operations on your data at high speeds. For example: Compute the distance between two points Find all the points within X meters of point P Determine which points are enclosed in polygon P A million other things In Ruby land, there is a gem called RGeo that provides a ton of object
patorash 2015/04/02
postgis

database

activerecord

rails

postgresql
ãƒªãƒ³ã‚¯
ActiveRecord::Migration.maintain_test_schema! doesn't work with structure.sql by morgoth Â· Pull Request #15394 Â· rails/rails
patorash 2014/07/12
structure.sqlã ã¨å‹•ã‹ãªã„ã¿ãŸã„ã ã€‚rails4.2ã«ãªã£ãŸã‚‰ç›´ã£ã¦ãã†ã€‚

rails

postgresql
ãƒªãƒ³ã‚¯
Benchmarks: acts-as-taggable-on vs PostgreSQL Arrays
patorash 2014/03/14
postgresqlã®é…åˆ—åž‹ã¨acts_as_taggable_onã®é€Ÿåº¦æ¯”è¼ƒã€‚ã•ã™ãŒã«é…åˆ—åž‹ãŒé€Ÿã„ã€‚

postgresql

rails
ãƒªãƒ³ã‚¯
Postgres Enum Type in Rails 4 (Example)
patorash 2014/02/12
postgresql

rails

enum
ãƒªãƒ³ã‚¯
RubyonRailsã§sqliteã§ãªãã¦Postgresqlã‚’ä½¿ã†æ™‚
çµæ§‹ã‚ã‚“ã©ãã•ã‹ã£ãŸã€‚ã€‚ ãƒ¡ãƒ¢ã—ã¦ãŠãã¾ã™ã€‚ Vagrantã‚’ä½¿ã£ã¦ã€Macbookã®ãƒãƒ¼ã‚«ãƒ«ç’°å¢ƒã§é–‹ç™ºã¨ã„ã†çŠ¶æ³ã€‚ Railsã‚’Apacheã§å‹•ã‹ã™æ‰‹é †ã¯ä¸‹è¨˜ã‚’å‚ç…§ã€‚ RubyonRailsã‚’Apacheã¨Passengerã§å‹•ã‹ã™ | Workabroad.jp Vagrant, CentOS-6.4, Ruby2.0, Rails4.0, Postgresql9.3 Postgresqlã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¨æº–å‚™ yum install postgresql ã¨ã™ã‚‹ã¨ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒå¤ã„ã®ã§ã€ã¾ãšã¯ãã“ã‹ã‚‰ã€‚ å…¬å¼ã‚µã‚¤ãƒˆ PostgreSQL: The world's most advanced open source database [Download]ã‚’ã‚¯ãƒªãƒƒã‚¯ã€‚ linuxã®ä¸ã®[RedHat/CentOS/Fedora/Scientific] families Linuxã‚’ã‚¯ãƒªãƒƒã‚¯ã€‚
patorash 2014/01/30
rails

postgresql

rspec
ãƒªãƒ³ã‚¯
PostgreSQLã§ã®æ£è¦è¡¨ç¾æ¤œç´¢
DoRuby! (ãƒ‰ãƒ«ãƒ“ãƒ¼!) ã¯ç¾å ´ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã‚ˆã‚‹ã€ä¸»ã«Rubyãªã©ã®æŠ€è¡“ã«é–¢ã™ã‚‹æ§˜ã€…ãªå®Ÿè·µãƒŽã‚¦ãƒã‚¦ã‚’é›†ã‚ãŸæŠ€è¡“æƒ…å ±ã‚µã‚¤ãƒˆã§ã™ã€‚ ã“ã‚“ã«ã¡ã¯ã€cloverã§ã™ï¼ å…ˆæ—¥ä»•äº‹ã§ã€ãƒ‰ã‚³ãƒ¢ã®ã‚·ãƒ¼ã‚¯ãƒ¬ãƒƒãƒˆã‚³ãƒ¼ãƒ‰ã«å¯¾å¿œã™ã‚‹ä½œæ¥ãŒã‚ã£ãŸã®ã§ã™ãŒã€ãã®éš›ã€Œé›»è©±ç•ªå·ï¼ˆ11ã‚±ã‚¿ï¼‰ï¼‹ã‚·ãƒ¼ã‚¯ãƒ¬ãƒƒãƒˆã‚³ãƒ¼ãƒ‰ï¼ˆ4ã‚±ã‚¿ï¼‰@ãƒ‰ã‚³ãƒ¢ã€ã®4ã‚±ã‚¿ã®éƒ¨åˆ†ä»¥å¤–ã®éƒ¨åˆ†ã®ãƒžãƒƒãƒãƒ³ã‚°ãŒå¿…è¦ã«ãªã‚Šã¾ã—ãŸã€‚ LIKEæ¤œç´¢ã§ã¯é›£ã—ã„ã‹ãªãã¨æ€ã£ã¦å…ˆè¼©ã«èžã„ã¦ã¿ãŸã‚‰ã€ä½•ã¨PostgreSQLã«ã¯æ£è¦è¡¨ç¾ã§ã®ãƒžãƒƒãƒãƒ³ã‚°ãŒå‡ºæ¥ã‚‹ã¨ã®ã“ã¨ã€‚ ã¨ã„ã†ã‚ã‘ã§ã€ã¡ã‚‡ã£ã¨èª¿ã¹ã¦ã¿ã¾ã—ãŸï½ž ä¾‹ãˆã°ã€ã€Œ090123456781234@ãƒ‰ã‚³ãƒ¢ã€ã¨ã„ã†ãƒ¡ãƒ¼ãƒ«ã‚¢ãƒ‰ãƒ¬ã‚¹ãŒã‚ã£ã¦ã€ã€Œ09012345678xxxx@ãƒ‰ã‚³ãƒ¢ï¼ˆxxxxã®éƒ¨åˆ†ã¯æ•°å€¤ã§ã‚ã‚Œã°ä½•ã§ã‚‚ã‚ˆã„ï¼‰ã€ã¨ã„ã†æ¡ä»¶ã§ã€ãƒžãƒƒãƒã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãŒã‚ã‚‹ã‹ã‚’èª¿ã¹ã‚ˆã†ã¨ã—ãŸã¨ãã€ PostgreSQLã§ã¯ã€Œ~ï¼ˆãƒãƒ«ãƒ€ï¼‰ã€ã‚’ç”¨
patorash 2013/09/09
postgresql

rails
ãƒªãƒ³ã‚¯
Jay Goldman
patorash 2013/07/25
rails

ruby

Mac OS X

PostgreSQL
ãƒªãƒ³ã‚¯
Rails 4.0 Sneak Peek: PostgreSQL array support - DockYard
Iâ€™m happy to announce that Rails 4.0 now has support for PostgreSQL arrays. You can create an array column easily at the time of migration by adding :array => true. Creating an array column will respect the other options you add to the column (length, default, etc). create_table :table_with_arrays do |t| t.integer :int_array, :array => true # integer[] t.integer :int_array, :array => true, :length
patorash 2013/07/24
array

postgresql

rails
ãƒªãƒ³ã‚¯
Repairing Postgresql after upgrading to OSX 10.7 Lion
I recently upgraded to OSX 10.7, at which point my rails installation completely borked when trying to connect to the psql server. When I do it from the command line using psql -U postgres it works totally fine, but when I try to run the rails server or console with the same username and password, I get this error ...activerecord-3.0.9/lib/active_record/connection_adapters/postgresql_adapter.rb:95
patorash 2013/03/18
postgresqlãŒç¹‹ãŒã‚‰ãªããªã£ãŸã‘ã‚Œã©ã€ã“ã‚Œã§ç›´ã£ãŸã€‚

postgresql

rails

mac

lion
ãƒªãƒ³ã‚¯
Rails ã§PostgreSQLã®é…åˆ—åž‹ã‚’è©¦ã™ - yuumi3ã®ãŠä»•äº‹æ—¥è¨˜
ä»Šå›žã®ä»•äº‹ã§PostgreSQLã®é…åˆ—(array)åž‹ã‚’ä½¿ãˆã‚‹ã¨ä¾¿åˆ©ãªã®ã§è©¦ã—ã¦ã¿ã¾ã—ãŸã€‚ Migration Migration ã§ Railsæ¨™æº–ã®åž‹ä»¥å¤–ã‚’ä½¿ã†ã«ã¯åž‹ã®éƒ¨åˆ†ã‚’æ–‡å—åˆ—ã§æŒ‡å®šã—ã¾ã™ã€‚ class CreateTodos < ActiveRecord::Migration def self.up create_table :todos do |t| t.date :due t.string :task t.column :opts, "integer[]" t.timestamps end end def self.down drop_table :todos end endrake db:migrateã™ã‚‹ã¨ç„¡äº‹ã« é…åˆ—åž‹ ã‚«ãƒ©ãƒ ãŒå‡ºæ¥ã¾ã—ãŸã€‚ > \d todos Table "public.todos" Column | Type | Modifiers -------
patorash 2012/10/26
Railsã§é…åˆ—åž‹ã‚’è©¦ã—ã¦ã¿ã‚‹ã®ã§ãƒ¡ãƒ¢ã€‚

postgresql

activerecord

rails

é…åˆ—
ãƒªãƒ³ã‚¯
1