GitHub - flyerhzm/bullet: help to kill N+1 queries and unused eager loadingYou signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
DB Replication With Rails
This document summarizes a talk about using replicated databases with Rails applications. It discusses why replication is used, including for load balancing and redundancy. It covers some problems with replicated databases like conflicting primary keys and replication lag. It then discusses different solutions for handling reads and writes with replicated databases in Rails including MySQL Proxy,
francois's strokedb at master - GitHub
This repository is private. All pages are served over SSL and all pushing and pulling is done over SSH. No one may fork, clone, or view it unless they are added as a member. Every repository with this icon () is private. This repository is public. Anyone may fork, clone, or view it. Every repository with this icon () is public.
A close look at three Rails 2.1 bugs | Programming Zen
Ruby on Rails 2.1 has been out for six weeks now. Let’s take a closer look at three database related bugs that affect this release. 1. SQLite’s db creation generates false warnings This is an innocuous bug, and if you work with SQLite I’m sure that you encountered and safely ignored it. When you create a Rails application, the default adapter in use is sqlite3, unless you specify otherwise with th
Database Optimization for Rails Apps
Database Optimization for Rails Apps 20th Nov 2007 by Gwyn Morfey Summary Use STRAIGHT_JOIN if MySQL is doing something silly MySQL Datetimes are not slow MyISAM is much, much faster than InnoDB Consider MySQL partitioning; it's not hard Watch out for background optimisation and query caching Log everything you do, and why The reporting application I'm working on does a date-range select against a
Automatically — err.the_blog
Chris made migrations sexy. So sexy, in fact, that DHH committed a variation of his plugin to trunk. I’m not here to make things sexy. I’m here to make migrations drop-dead gorgeous. Remember that file that no one uses and normally leaves of subversion? No, not doc/README_FOR_APP. I’m talking about db/schema.rb of course. Turns out with this plugin I wrote, it’s the baddest file in your source cod
レガシースã‚ーマーã‹ã‚‰ãƒ¢ãƒ‡ãƒ«ã¨é–¢é€£ã‚’生æˆã™ã‚‹Magic Model Generator
./script/generate magic_model What Imagine you get offered $5,000 to write a basic website/admin application on a legacy database that has 200 interconnected tables. You’ll need to add all the associations and validations based on the existing schema. Imagine how long that would take! 1 day? 1 week? more? Try 1 minute. The Magic Model Generator does all this for you automatically. Installing $ sud
Rubyisms | MySQL-dump
Lately, I have had opportunity to evaluate a very large Ruby installation that also was growing very quickly. A lot of the work performed on site has been specific to the site, but other observations are true for the platform no matter what is being done on it. This article is about Ruby On Rails and its interaction with MySQL in general. Com_show_fields as a RoR indicator (and not cached enough?)
インデックスã®åŸºç¤ŽçŸ¥è˜
■インデックスã¨ã¯ データベースã®ä¸–ç•Œã§ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹(索引)ã¨ã¯ãƒ†ãƒ¼ãƒ–ルã«æ ¼ç´ã•ã‚Œã¦ã„るデータを 高速ã«å–り出ã™ç‚ºã®ä»•çµ„ã¿ã‚’æ„味ã—ã¾ã™ã€‚ インデックスをé©åˆ‡ã«ä½¿ç”¨ã™ã‚‹ã“ã¨ã«ã‚ˆã£ã¦SQLæ–‡ã®å¿œç”時間ãŒåŠ‡çš„ã«æ”¹å–„ ã•ã‚Œã‚‹å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚ インデックスã«ã¯B-Treeインデックスをã¯ã˜ã‚ã€ãƒ“ットマップインデックス〠関数インデックスãªã©ã®ç¨®é¡žãŒã‚ã‚Šã¾ã™ãŒã€ã“ã“ã§ã¯æœ€ã‚‚一般的ã«ä½¿ã‚ã‚Œã€ã‹ã¤ ã»ã¨ã‚“ã©ã®DBMSã§ã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã‚‹B-Treeインデックスã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ ※ CREATE INDEXæ–‡ã§ã‚ªãƒ—ションを指定ã—ãªã„å ´åˆã¯é€šå¸¸B-Treeインデックス㌠作æˆã•ã‚Œã¾ã™ã€‚ â– B-Treeインデックスã®ã—ãã¿ B-Tree(Balanced Tree)インデックスã¯æ¬¡ã®ã‚ˆã†ãªãƒ„リー状ã®æ§‹é€ ã«ãªã£ã¦ã„ã¾ã™ã€‚ ツリーã®å…ˆé ã¯ãƒ˜ãƒƒãƒ€ãƒ–ãƒãƒƒã‚¯ã¨å‘¼ã°ã‚Œã¦ã„ã¾ã™ã€‚ヘッダブãƒãƒƒã‚¯ã§ã¯ã€ã‚ー値㮠範囲
Twitter, Rails, Hammers, and 11,000 Nails per Second — Thought Palace
Twitter, Rails, Hammers, and 11,000 Nails per Second There’s an interesting kerfluffle going on regarding the scaling woes that Twitter.com is going through, especially since it’s built on Ruby On Rails. Here’s the original interview with one of the Twitter coders, the somewhat evasive reply by the lead Rails architect, and Mark Pilgrim’s cruel-but-funny dissection of the latter. Ruby is a lovely
SQL Injection Cheat Sheet
Examples; (MS) means : MySQL and SQL Server etc. (M*S) means : Only in some versions of MySQL or special conditions see related note and SQL Server Table Of Contents About SQL Injection Cheat Sheet Syntax Reference, Sample Attacks and Dirty SQL Injection Tricks Line Comments SQL Injection Attack Samples Inline Comments Classical Inline Comment SQL Injection Attack Samples MySQL Vers
Rails Migration Cheat Sheet
Make sure you view the (short) screencast by DHH VERIFY: To enable full use of ruby schema support, uncomment ‘config.active_record.schema_format = :ruby’ in your /config/environment. (Update: The rails schema mechanism is the default as of Rails 1.1) rake db_schema_dump: run after you create a model to capture the schema.rb rake db_schema_import: import the schema file into the current database (
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
eizesus.com - eizesus リソースãŠã‚ˆã³æƒ…å ±
SD Ruby | Podcast
File: README
Quoted-Printable: Seed Data in Rails
https://rubyreports.org/ruport.html
Engineering Rapleaf - Mysql Replication Adapter
Plugins - Manage Fixtures - Agile Web Development
New Plugin: MySQL Tasks | Synthesis | Scott Becker
{{#tags}}- {{label}}
{{/tags}}