The Ruby Reflector

Additionally, MySQL supports POSIX regular expressions, not PCRE like Ruby. There are things (like negative lookaheads) that you simply can't do, though you probably ought not to be doing them in your SQL anyway.

In PostgreSQL

Support for regular expressions in PostgreSQL is similar to that of MySQL, though the syntax is different (e.g. email ~ '^a' instead of email RLIKE '^a' ). What's more, Postgres contains some useful functions …

• Topics: SQL, PostgreSQL, Basic Usage, Ruby, ActiveRecord

…runtime solution, containing Ruby, Apach,e Rails, and MySQL that are all pre-configured and set to run!.

Integrate FCKEditor with your Ruby on Rails application : integrator for rich text designed by Joshua M Charles

Integrating a Rich-text Widget with Struts : OReillyNet's textarea rich-text replacement

Instiki : wiki clone ; at Instiki.org

LiveTree : JavaScript/ DHTML tree widget

Locomotive : simple to use …

• Topics: JavaScript, Wiki, Content management system, Ajax, Rails Way

Netherland's biggest radio station for news and sports went live with the first Ruby on Rails installation used by the public broadcasters. I built the entire site from scratch. Almost everything is resourcefully routed. Performance is a huge concern since this website sees peak loads during major events like Tour de France. Runs on a server cluster with many Mongrel front ends and a custom tuned MySQL. Noteworthy are the huge number of feeds coming into the system every five minutes; almost 80 in total.

• Topics: Mongrel, France, Tour, Ruby on Rails

• Conversation:

Netherland's biggest radio station for news and sports went live with the first Ruby on Rails installation used by the public broadcasters. I built the entire site from scratch. Almost everything is resourcefully routed. Performance is a huge concern since this website sees peak loads during major events like Tour de France. Runs on a server cluster with many Mongrel front ends and a custom tuned MySQL. Noteworthy are the huge number of feeds coming into the system every five minutes; almost 80 in total.

• Topics: Mongrel, France, Tour, Ruby on Rails

• Conversation:

…comes with Ruby 1.8.7. Installation of 1.9.2 is made easy with RVM. MySQL was another story. I started by downloading the latest, and installing it. Then I added /usr/local/mysql/bin to my path. First problem was that building the necessary gems requires additional configuration. Once installed, it simply didn't work. Turns out to be a problem with Mysql 5.5. Uninstalling requires manually tracking down files and zapping them. Even that wasn't enough, there was one more …

• Topics: Ubuntu, Mail, Microsoft Windows, .Mac, RVM

…all. Since Akephalos uses a remote server to run the tests that need to share the same Mysql connection pool, more freakyness occurs. How about this one: Undefined method collect on NilClass

This one kept coming back, at random intervals. Sometimes it did, sometimes it didn't. This exception was raised on the following code: CareProvider.first

Yeah, that's freaky right? This was pure ActiveRecord code. After some investigation I found the culprit: ActiveRecord QueryCache. …

• Topics: jQuery, JavaScript, Ruby on Rails, ActiveRecord, DOM

…more. Most modern apps use the same types of backing services such as datastores ( MySQL, PostgreSQL, CouchDB, Redis), caching systems ( Memcached, Varnish), and queueing systems ( RabbitMQ, Beanstalkd), rather than the language- or framework-specific services of yesteryear (e.g. Erlang's Mnesia or Zope's Object Database ). There is even convergence on RPC protocols (e.g. REST, AMQP, ZeroMQ, Thrift, Protocol Buffers) and serialization protocols …

• Topics: Heroku, Clojure, Ruby, Python, Java

Cutting out MySQL

So, where are we spending out time and what can we do about it? First I'll try cutting MySQL out of the picture and use an in-memory SQLite DB for our tests. This article was a helpful starting point for me, but I discovered quickly that the spec_helper.rb addition needed must be placed in the Spork.each run block - not the Spork.prefork block.

Unfortunately, the silence_stream call winds up being superfluous because Spork has captured it already, …

• Topics: spork, rspec, Devise, Ruby, RSpec

• Conversation:

…NoSQL data stores. Our current focus is on completing our PostgreSQL 9 Beta and MySQL offerings.

MongoDB-wise, I've completed the evaluation process and laid out what our future supported installations will look like. I'm finalizing our strategy and roadmap to start working towards an alpha release.

Note: We will cover these data plans in more detail here on the blog in a few weeks.

You are very involved in the local tech community, volunteering for RailsBridge in San Francisco…

• Topics: Ruby on Rails, Engine Yard, Ruby, United States of America, Big Data

• Conversation:

…Project Automation (oldie, but goldie, this book was an eye-opener to me)

The Art of Capacity Planning

Building Scalable Websites

High Performance MySQL, 2nd. Edition

How Complex Systems Fail

On Designing and Deploying Internet-Scale Services

Shameless Plug

• Topics: Heroku, Unix, EC2, Linux kernel, activities