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.