{"action":"created","issue":{"url":"https://api.github.com/repos/minetest/minetest/issues/2912","labels_url":"https://api.github.com/repos/minetest/minetest/issues/2912/labels{/name}","comments_url":"https://api.github.com/repos/minetest/minetest/issues/2912/comments","events_url":"https://api.github.com/repos/minetest/minetest/issues/2912/events","html_url":"https://github.com/minetest/minetest/pull/2912","id":95035789,"number":2912,"title":"PostgreSQL database backend","user":{"login":"johnnyjoy","id":13338104,"avatar_url":"https://avatars.githubusercontent.com/u/13338104?v=3","gravatar_id":"","url":"https://api.github.com/users/johnnyjoy","html_url":"https://github.com/johnnyjoy","followers_url":"https://api.github.com/users/johnnyjoy/followers","following_url":"https://api.github.com/users/johnnyjoy/following{/other_user}","gists_url":"https://api.github.com/users/johnnyjoy/gists{/gist_id}","starred_url":"https://api.github.com/users/johnnyjoy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/johnnyjoy/subscriptions","organizations_url":"https://api.github.com/users/johnnyjoy/orgs","repos_url":"https://api.github.com/users/johnnyjoy/repos","events_url":"https://api.github.com/users/johnnyjoy/events{/privacy}","received_events_url":"https://api.github.com/users/johnnyjoy/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/minetest/minetest/labels/@%20Server%20/%20Client%20/%20Env.","name":"@ Server / Client / Env.","color":"009800"},{"url":"https://api.github.com/repos/minetest/minetest/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":29,"created_at":"2015-07-14T20:43:02Z","updated_at":"2015-12-22T08:12:56Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/minetest/minetest/pulls/2912","html_url":"https://github.com/minetest/minetest/pull/2912","diff_url":"https://github.com/minetest/minetest/pull/2912.diff","patch_url":"https://github.com/minetest/minetest/pull/2912.patch"},"body":"PostgreSQL backend, Database server can be local or remote. Connection info is located in the world.mt file. Defaults to a local database, with user and database name of minetest. Performance depends on PostgreSQL server. Please contact me privately for the IP address for the server currently running the code."},"comment":{"url":"https://api.github.com/repos/minetest/minetest/issues/comments/166550187","html_url":"https://github.com/minetest/minetest/pull/2912#issuecomment-166550187","issue_url":"https://api.github.com/repos/minetest/minetest/issues/2912","id":166550187,"user":{"login":"Rogier-5","id":6202053,"avatar_url":"https://avatars.githubusercontent.com/u/6202053?v=3","gravatar_id":"","url":"https://api.github.com/users/Rogier-5","html_url":"https://github.com/Rogier-5","followers_url":"https://api.github.com/users/Rogier-5/followers","following_url":"https://api.github.com/users/Rogier-5/following{/other_user}","gists_url":"https://api.github.com/users/Rogier-5/gists{/gist_id}","starred_url":"https://api.github.com/users/Rogier-5/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Rogier-5/subscriptions","organizations_url":"https://api.github.com/users/Rogier-5/orgs","repos_url":"https://api.github.com/users/Rogier-5/repos","events_url":"https://api.github.com/users/Rogier-5/events{/privacy}","received_events_url":"https://api.github.com/users/Rogier-5/received_events","type":"User","site_admin":false},"created_at":"2015-12-22T08:12:56Z","updated_at":"2015-12-22T08:12:56Z","body":"\nOn Monday 21 December 2015 19:42:54 ShadowNinja wrote:\n> @Rogier-5: About the auto-creation issue: Yes, I'd probably fix that\n> by having it create a database with the name of the world.\n\nThat sounds like a much better idea indeed.\n\nI think there is a risk though, that a world name conflicts with the name of \nanother random database that exists on the server, and that the user has \naccess to (and where he can create tables). The owner of the database would \nnot be happy suddenly discovering an additional table :-)\n\nMaybe something like 'minetest:<worldname>-<random-number-based-on-\nworld-seed>' would be better still ? It's clear to anybody that it is minetest-\nrelated, which world it belongs to, and it has an extremely high chance of being \nunique. I checked, and postgresql accepts the ':' in a table name.\n\nAnd, I'm just thinking, maybe it would be a good idea to write the connection \nstring of the database that was just created to the world.mt file, so that \nwhatever happens next, short of corruption or loss of world.mt, the correct \ndatabase will henceforth always be used. Even if the user renames the world.\n\n"}}