Question : I have a project in heroku. I have the URI that enables me to connect with the database […]
Tag: rails
What postgres sync solution should I use to duplicate production, but read it from another application?
Question : I’m a little out of my league with my current problem, but I’m looking for a solution where […]
re-write active record query to PostgreSQL
Question : I want to rewrite the active record query to Actual PostgreSQL query Camera.joins(“left JOIN users on cameras.owner_id = […]
Duplicate Relationships in Rails/MySQL Healthcare Application
Question : Overview of the Application I am building a Ruby on Rails application to organize medications, using MySQL. The […]
What can I do to monitor “out of shared memory” issues?
Question : I’m new to database administration and I would really like some advice on what tools I could use […]
Multiple Joins with Sums
Question : Here is my basic schema wbs_item +—-+———–+———–+ | id | name | parent_id | +—-+———–+———–+ | 1 | […]
MySQL: How to decrease sleep process’s time out?
Question : When I run ‘show processlist;’, then I get so many sleep processes. I set wait_timeout and interactive_timeout to […]
Database Design – I have a question regarding joining tables
Question : Forgive me for my dumb question but I am new to Ruby on Rails and data design. We […]
Flashcards and templates
Question : I’m having trouble with an appropriate DB design for flashcards that display their data with one of numerous […]
Postgresql Query getting slow execution time
Question : I did the explain analyze for this query, it was giving 30ms, but if the data is more […]