Posted about 10 years ago by Arne Hartherz.

...always use Time.current instead of Time.now, etc. Why? Because of the way Rails and MySQL deal with time zones you would need to take care to use Time.zone.now in projects...

Posted about 7 years ago by Arne Hartherz. edgeguides.rubyonrails.org

...json and array take away a lot of the pain that you had on MySQL projects. Example use cases for array are tags or storing foreign keys (instead of a...

Posted about 4 years ago by Emanuel De.

This is an extension to PostgreSQL vs MySQL: How to UPDATE using a JOIN. UPDATE employees SET department_name = departments.name, department_area = areas.name FROM departments, areas WHERE employees.department_id = departments.id...

Posted over 5 years ago by Henning Koch. github.com

...to migrate to Minidusen, which extracts those parts from Dusen. Minidusen is compatible with MySQL, PostgreSQL and Rails 3.2, 4.2 and 5.0. If you are looking for a full text...

Posted over 5 years ago by Henning Koch. til.hashrocket.com

...second SELECT statement with a subselect. Note that sub-queries are extremely slow in MySQL, but they can make cases easier where performance does not matter so much (e.g. a...

Posted about 6 years ago by Thomas Eisenbarth.

...pg_database ORDER by size_in_mb DESC; Want to see database sizes in MySQL...

Posted about 7 years ago by Henning Koch.

In the tradition of our PostgreSQL cheat sheet for MySQL lamers, here is a cheat sheet for Jasmine when you're used to RSpec. Note that Jasmine syntax has changed...

Posted over 7 years ago by Thomas Eisenbarth.

Open a MySQL root shell and use this command: PURGE BINARY LOGS BEFORE DATE(NOW() - INTERVAL 3 DAY) + INTERVAL 0 SECOND...

Posted about 8 years ago by Martin Straub.

...Spreewald database.sample.yml has changed) Fix Change cucumber to test in your databse.yml test: # <--- adapter: mysql2 database: spreewald_test encoding: utf8 host: localhost username: root password: password

Posted almost 9 years ago by Henning Koch. highscalability.com

...supported; consistently good performers; failure free as possible; free. Using these criteria they selected: MySQL, Solr, Memcache, and Redis. Cassandra and Mongo were dropped...

Posted over 9 years ago by Henning Koch.

...scope chain, it only mashes together strings that mostly happen to look like a MySQL query in the end. I don't generally advice against using scopes with JOINs. What...

Posted over 9 years ago by Henning Koch.

...have existing data that needs to be cleaned, do it in a migration, using MySQL's TRIM function: class StripWhitespaceFromOrganisation < ActiveRecord::Migration def change update 'UPDATE organisations SET name = TRIM...

Posted over 9 years ago by Arne Hartherz.

...actually never be written to the database, because we disconnected during an unfinished transaction. MySQL will for good reason not simply commit any open transactions when you disconnect (you might...

Posted about 10 years ago by Arne Hartherz.

...as_geocodable using plain Graticule will just do the job. Support from the database MySQL 5 has spatial support. This involves custom data types and funny SQL syntax.

Posted over 10 years ago by Tobias Kraze.

...to you database and database table charsets to UTF8. You can check in the MySQL console with SHOW VARIABLES LIKE "character_set_database"; SHOW TABLE STATUS; Also update your nbsp...

Posted over 10 years ago by Kim Jahn.

...sudo gem install rails -v=2.3.12. You will also need Ubuntu development packages for MySQL, RMagick, etc. The bundle install call will otherwise fail for such projects...

Posted over 10 years ago by Ulrich Berkmueller.

...NUMBER'] %> appended to the database name in the test section. # ./config/database.yml ... test: &TEST adapter: mysql database: my_database_name_test<%= ENV['TEST_ENV_NUMBER'] %> encoding: utf8 username: xxx password: yyy...

Posted almost 11 years ago by Lexy. agileweboperations.com

...technical tasks which cannot be directly linked to customer value. Things like “Upgrade to MySQL 6.0″ or “replace magic numbers with enums” need to be done. How can you prioritize...

This website uses short-lived cookies to improve usability.
Accept or learn more