[Obsidian]

Hi, I'm curious to know if adding PGSQL support to sourcemod has been considered at all. I've been getting awful nervous about MySQL's maintenance and availability every since Sun was bought out by Oracle, and Oracle beginning a holy legal war about the use of Java.

I've been moving more and more of my own code to PGSQL, but with sourcemod being sqlite or mysql only, I'm a bit hindered in shutting down MySQL on my own box (and I don't like having to run 2 DBMS's).

Postgres, pretty please? ;_;

[BAILOPAN]

https://bugs.alliedmods.net/show_bug.cgi?id=3849

This had a patch in it, but there were problems - the original author kindly posted his working tree and offered it up to any takers. It would need to be re-patchified and submitted for review.

[DarkEnergy]

maintenance and availability? its definitely not going away any time soon.

[8088]

And if it will, there's MariaDB.

[Obsidian]

Originally Posted by DarkEnergy maintenance and availability? its definitely not going away any time soon.

Oracle's already removing features from some releases; MySQL Classic edition has had InnoDB support removed, specifically.

Originally Posted by BAILOPAN https://bugs.alliedmods.net/show_bug.cgi?id=3849 This had a patch in it, but there were problems - the original author kindly posted his working tree and offered it up to any takers. It would need to be re-patchified and submitted for review.

Aw, a shame. Unfortunately, my skill lies not in compiled languages, but in web apps and web app security.

I really hope that someone will pick this up and run with it.


Oh, and for what it's worth, I saw something in the ticket comments about getting the last insert id -- in the docs for PHP's PDO extension, this was suggested to get the last insert id for postgres.
Apparently you tack on "RETURNING columnname" to the end of the query, and use that to obtain the last insert id while avoiding a race condition (which would likely occur when using a second query): http://us3.php.net/manual/en/pdo.lastinsertid.php#86591

[asherkin]

Originally Posted by Obsidian Oracle's already removing features from some releases; MySQL Classic edition has had InnoDB support removed, specifically.

Except that Classic is one of the enterprise support editions and is aimed at embedded devices. Also, as far as I can tell, it's never had InnoDB support.

[klausenbusk]

I am also interested in PostgreSQL for SourceMod

[Peace-Maker]

There's acutally an postgres extension available now!
https://forums.alliedmods.net/showthread.php?t=236415

Spamming all postgres related threads!