http://www.dnamique.com what is Soft in Software Thu, 12 Nov 2009 06:00:57 +0000 http://backend.userland.com/rss092 en PostgreSQL is a: Sophisticated open-source Object-Relational DBMS supporting almost all SQL constructs, including subselects, transactions, and user-defined types etc... The Problem You have just installed PostgrelSQL. You have generated your rails app rails myApp -d postgresql You try to run the server ruby script/server You add your DB details in config/database.yml and you notice this note. On Windows: # ... http://www.dnamique.com/setting-up-postgresql-8-with-ruby-on-rails/ If you are on a MAC, using the easy going XAMPP and need that rails app to get up and running using mysql, then read on. So Rails 2 does not come with the mysql gem installed. You run: gem install mysql and to your shock you get: ERROR: Error installing mysql: ERROR: Failed to ... http://www.dnamique.com/installing-mysql-gem-on-mac-os-xampp/ I am posting this method here just so we never ever ever ever... forget what Albert Einstein once said Everything should be made as simple as possible, but not simpler. Exporting data to Excel files from a database can be done in so many different ways, using so many libraries and classes such ... http://www.dnamique.com/cakephp-export-data-to-excel-the-easy-way/ I have spent all day yesterday looking for a good(any) Ruby on Rails file explorer or browser for a web application but did not find anything. Few people mentioned Boxroom which looks great except it is an entire web application. Then I bumped to jQuery File Tree. jQuery File Tree is a ... http://www.dnamique.com/file-browser-for-ruby-on-rails/