Constantine Nicolaou

Software, Web, Ruby, Rails, Cloud Computing, Entrepreneurship

Lebanon - France - UK


giant robots smashing into other giant robots: A grand piano for your violin

Database indexes

What are database indexes? If you’re building web apps powered by a relational database, you should know.

A database index is a data structure in the database which improves the speed of operations (typically row lookups) on a database table, or across tables. Think of it like…

Access denied for user ‘root’@’localhost’ (using password: YES)

If you ever get stuck with the following error “Access denied for user ‘root’@’localhost’ (using password: YES)” while trying to boot your Rails application, make sure the values in your DB config file are correct.

  adapter: mysql
  database: test_db
  username: root

We spent a day debugging code before noticing that the difference between development db config and test db config was the usage of:

user: root

instead of

username: root