KM SOFT

postgresql

Posts tagged “postgresql”.

  1. How to design a solid database for Rails application

    ruby, rails, database, postgresql

    Designing a Rails database upfront with not-null constraints, unique indexes and foreign keys, and why ActiveRecord validations alone cannot guarantee data integrity.

  2. Verifying database schema in console

    ruby, rails, migrations, psql, postgresql, mysql

    PostgreSQL and MySQL console commands for inspecting a Rails application's database: listing databases and tables, describing a table, and when it helps.