Rails + Postgres Notes
some brief notes on getting Rails and the Postgres SQL database play nice(er) : Continue reading Rails + Postgres Notes
Category Archives: SQL
Rails Migration Rollback with compound indexes fail and fix
This is for Ruby on Rails 2.5.x, and MySQL 5, and the MySQL2 gem (there is a problem with mysql2-0.3.2. and rails 3.0.x, but using 0.2.7 for Ruby 2.5.x and 3.0.x is good). I do hope to test some of Continue reading Rails Migration Rollback with compound indexes fail and fix
PostgreSQL vs. MySQL vs. Commercial Databases: It’s All About What You Need
PostgreSQL vs. MySQL vs. Commercial Databases: It’s All About What You Need looks like a useful summary of History, Licensing, Feature Sets, Training and Support, a very brief list of who uses them. Worth passing on to your friendly neighborhood Continue reading PostgreSQL vs. MySQL vs. Commercial Databases: It’s All About What You Need
Popularity Growing For Open-Source Databases and…
Popularity Growing For Open-Source Databases and MySQL Gets Ready for Enterprise-Level Database Reliabilityhttp://update.internetweek.com/cgi-bin4/DM/y/efrp0BzAN20V30CQQA0AR Open-source database software maker MySQL AB plans to unveil nextmonth an enterprise-level capability that automatically shiftsworkloads to another database server when one fails. Four-Way Fusion Demands Discussion Continue reading Popularity Growing For Open-Source Databases and…
MySQL Profits From Open Source
Another MySQL database server article :Wired News: MySQL Profits From Open Source as the mainstream discovers that you can get what you need for $500 a server rather that thousands or tens of thousands of dollars. Also mentioned are other Continue reading MySQL Profits From Open Source
More MySQL Crash Course
Nice piece : ONLamp.com: MySQL Crash Course, Part 3 , basic selects and joins. (a review is always nice). And I saw something new : The “LIMIT” clause mysql> SELECT * FROM authors LIMIT 1; LIMIT (not part of SQL92, Continue reading More MySQL Crash Course