Poor PostgreSQL Compatibility

[kawaii]

I made an attempt at patching it myself, but even after installation it turned out that there were more MySQL specific queries than I wanted to deal with.

function google_seo_plugin_install()
{
    google_seo_plugin_dependency();

    global $db;

    // Create the Google SEO table.
    $collation = $db->build_create_table_collation();

    if(!$db->table_exists("google_seo"))
    {
        $db->write_query("CREATE TABLE ".TABLE_PREFIX."google_seo(
                              active INT,
                              idtype INT NOT NULL,
                              id INT NOT NULL,
                              url TEXT NOT NULL,
                              UNIQUE (idtype, url),
                              UNIQUE (active, idtype, id)
                          );");
    }
}

Would it be possible for you to update the plugin to fully support PostgreSQL databases please? :)

[frostschutz]

postgres version? error message?

[frostschutz]

Oh right, I never even attempted to support other databases for this plugin. Sorry about that.

[kawaii]

@frostschutz haha, sorry for the confusion! I'd really appreciate it if you'd consider adding PostgreSQL support and I'd even be happy to sponsor the feature since I'm probably one of the only people running MyBB on PostgreSQL in 2019. :smile:

[jvlobo]

Are there any plans for adding PostgreSQL support in the near future? Thank you!