PostgreSQL Database Interface
3 Attachment(s)
This driver is now included in SourceMod starting with version 1.11.0.6666.
This extension provides PostgreSQL database support to SourceMod. There is a bug report open for this, but i don't use pgsql so i can't test it in a production environment. Putting it up here to see if someone got a use for it and confirms it does what you expect. The extension is currently compiled against postgresql 9.3.2. It registers a "pgsql" database driver. To use this, just set the "driver" key in the databases.cfg section to "pgsql" like this: Code:
"pgtest" 1. Drag & Drop Due to syntax differences in the SQL flavours between MySQL, sqlite and PostgreSQL you can't be sure that all plugins will run out of the box with pgsql. You might need to slightly alter your queries depending on the used database driver. Just like you already have to do with different sql syntax between mysql and sqlite! Latest builds against SM 1.10 and PostgreSQL 9.6.9 HERE. This extension is compiled against SourceMod 1.6 and won't run on SM 1.5. This is due to some refactoring of the DBI system in 1.6 and me being too lazy to backport the extension to 1.5! |
Re: PostgreSQL Database Interface
Sorry if this is a newb question but what is the big difference between MySql and PostgreSQL
Also do they use the same sql queries, format etc? |
Re: PostgreSQL Database Interface
Quote:
http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL https://www.scriptrock.com/articles/postgres-vs-mysql/ https://www.udemy.com/blog/mysql-vs-postgresql/ |
Re: PostgreSQL Database Interface
Quote:
|
Re: PostgreSQL Database Interface
Can i recompile with 9.4 driver easily?
|
Re: PostgreSQL Database Interface
(This is a repost from a PM I sent, in case anyone else has this issue)
Hello Peace-Maker, I was wondering about the current state of the PostgreSQL driver for sourcemod. When I do threaded queries against it, the server crashes and gives me this error. Quote:
Thank you for your time, printf P.S. I forgot to mention that I also rebased it on 1.7-dev. The patches applied okay, and I didn't think there would be problems. (Since there's not much recent commit history to the MySQL driver) EDIT2: It also happens when I rebase to 1.6-dev. |
Re: PostgreSQL Database Interface
2 Attachment(s)
This is compiled against PostgreSQL 9.6.0. Give it a try and see if it still crashes! It's compiled against SM master so requires SM 1.8+.
https://github.com/alliedmodders/sourcemod/pull/32 |
Re: PostgreSQL Database Interface
Quote:
Code:
(gdb) bt |
Re: PostgreSQL Database Interface
I can't frequently fail to upload files to the forum. Try this one.
|
Re: PostgreSQL Database Interface
Quote:
I've converted all of my queries to work in PostgreSQL, but I still get odd things like this in parsing: Code:
row number 135 is out of range 0..134 |
All times are GMT -4. The time now is 06:05. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.