Hstore basically gives you a schema-less data store in your PostgreSQL DB. This allows you to store the Hash in a Database column. If you want to query Model records, it is very difficult if you use Serialize to store dynamic attributes. Hstore acts same as Serialize but we can additionally query the model records using […]
Optimize the DBMS – Whoosh! goes the App
As we all are aware, SQL optimizations are required for speeding up applications. There situations in my career where we felt like MySQL’s MyISAM engine is not fast enough! There are multiple factors that may slow down the SQL. They could be categorized into three categories. The database Software/Engine The database design/architecture The SQL used […]
