pushcx · GitHub

We've kicked around the idea of migrating the site to postgresql. I'd like to discuss it more thoroughly and permanently. Let's make a list some pros and cons with small/medium/large effect:

  • Medium pro: common table expressions so the Replies feature can be turned off when any-level parent goes to a negative score instead of just the immediate parent. A bad reply rarely goes negative fast enough to prevent prompting for replies. This could also be extended to email notifications.
  • Large con: The time and effort to migrate. I merged a bunch of changes to make the codebase portable between the two when I started Barnacles, but I haven't pulled changes into there since a few months after. The views with the scenic gem will certainly need attention.
  • Unknown: Better full-text searching?
  • Unknown: Lower RAM usage?

I'm certain I'm forgetting things we've discussed. Pinging @hmadison and @alanpost who've talked about this.

Read the original on github.com ↗