• gmsv_pg - an object-oriented PostgreSQL adapter for Garry's Mod
    2 replies, posted
I wanted to use PostgreSQL for my projects, but there wasn't an existing Linux-compatible module for PostgreSQL. So I just took libpqxx and made some binds to Lua, using the amazing gloo library to bind C++ classes to Lua. The library, as well as precompiled binaries can be found here: GitHub Usage: https://gist.github.com/MrMe0w/9fc87d510eeeb5f6b9287f4ad52319d8 Brief API overview: https://gist.github.com/MrMe0w/8f25273af29a828cad5bacb01c63a245 I hope it comes in handy! If you have any legitimate issues with the library, please use the issues section of the GitHub page to report them. Suggestions are welcome!
Is there any advantages to using this over mysql?
Postgres is generally stricter (and hence safer), covers more of the SQL standard and is faster. I tested my ORM use case with mysqloo (MariaDB on Debian 9) against my pg module (PostgreSQL 10 on Debian 9) and it was almost 2x faster. The results will obviously vary based on a lot of factors and your use case, but in general the performance is a bit better with postgres. It's also a bit better at handling /large/ amounts of data than mysql.
Sorry, you need to Log In to post a reply to this thread.