I'm debating something like the following as a post-process command that I can at least script up to run nightly, but don't know enough about the database structure to know if this is safe or not yet.

delete from contact_inboxes where id not in (select contact_inbox_id from conversations);
delete from contacts where id not in (select contact_id from conversations);

From looking at the scheme it looks like it /should/ be as long as the naming convention is consistent and I'm not missing a reference to contact or contact_inboxes.

EDITED to change the order of the two commands since contact_inbox_id can have references to contact_id. Otherwise, it looks like it does what I want.

Sorry, accidentally closed. Leaving open to see if there's plans to properly fix this so post-processing isn't needed.

If there's no objections, I can submit a PR to add a rake task for the Heroku scheduler: https://devcenter.heroku.com/articles/scheduler

with this:

desc "This task may be called by the Heroku scheduler add-on"
task :update_feed => :environment do
  puts "Cleaning old contacts..."
  require "sequel"
  DB = Sequel.connect ENV["DATABASE_URL"]
  DB["DELETE FROM contact_inboxes WHERE id NOT IN (SELECT contact_inbox_id FROM conversations)"]
  DB["DELETE FROM contacts WHERE id NOT IN (SELECT contact_id FROM conversations)"]
  puts "done."
  puts "done."
end

task :send_reminders => :environment do
  User.send_reminders
end

@psifertex That's associated with sessions. If you have 4k unique visitors on the website, you will have 4k session records. We initiate a session when the user first visits the webpage the first time and persist 365 days after the last visit.

Is it possible to disable session creation until the user actually either 1) opens the chat dialog, or 2) sends a message?

It can be an enhancement. I'm removing the bug as it is not a bug. I'll let @sojan-official @nithindavid evaluate the work need for the changes you mentioned.

Sounds good -- if it's actually tracking useful information I agree it shouldn't be a bug but configuration of it could be considered an enhancement. Let me know about that Suggested PR -- just adding that task would make cleanup easier for those who care.

@psifertex Please feel free to raise a PR. We are happy to take that in if that helps you.