|
== PostgreSQL support ==
* Long term possible objective using JSON datatype for rpobject.object
* ...
* Adding PostgreSQL support to Marauroa is little work
<!--
* Hallo of fame script and website need to support Postgres, too.
21:51hendrik4. Postgres support
* Website
21:51hendrikMarkus?
** Website currently uses deprecated old mysql api. It needs to be rewritten using [https://php.net/manual/de/book.pdo.php PDO] anyway to be compatible with the next PHP version
21:52markusI just had the idea of starting to support postgres.
22:01hendrikI** think mixing oldOld php mysql code and new php dbPDO code will result in doubling the number of database connectings, and having isolated transactions. ▼21:52markusOne thing postgres supports is a JSON datatype for columns which could serve as replacement for the blobs.
22:03hendrikWe** We can do that in (rather large) chunks by converting all the code that goes to the wiki-database , game-first. Then the website database, websiteand finally the game- datedatabase. ▼21:54hendrikI think adding Postgres support to Marauroa as such is quite simple and little work.
21:54balaurThat would be nice
21:54markusJSON datatype has one advantage to a blob: postgres can issue queries on JSON columns. for example: all json objects with attribute a="blah"
21:54hendrikDoes it support complex nested objects?
21:54markusI agree on that part, hendrik.
21:55hendrikI just realized, that adding postgres support to the stendhal website will be a lot of work. But we have to do that work anyway sooner or later.
21:56hendrikThe website uses deprecated mysql specific php libraries that have been removed in the next php version.
21:56markusthe documentation says, it supports RFC 4627 http://www.postgresql.org/docs/9.3/static/datatype-json.html
21:57markusI think a good first step would be to add plain postgres support before considering JSON
21:57hendrikYes, I agree.
21:58hendrikSo that is: Marauroa, Stendhal, Hall of fame script, website.
21:58hendrikI can do the Marauroa part soon.
22:00markusI could look into Stendhal to see what's needed there.
▲22:01hendrikI think mixing old php mysql code and new php db code will result in doubling the number of database connectings, and having isolated transactions.
22:02hendrikSo that will be a project for a branch. Luckily we have git nowadays.
▲22:03hendrikWe can do that in (rather large) chunks by converting all the code that goes to the wiki-database, game-database, website-date.
-->
|