{"id":961,"date":"2014-10-26T23:33:13","date_gmt":"2014-10-26T23:33:13","guid":{"rendered":"http:\/\/phoenixgamedevelopment.com\/blog\/?p=961"},"modified":"2014-10-26T23:39:41","modified_gmt":"2014-10-26T23:39:41","slug":"p-152-virtual-world-concept-update-9-sql-server","status":"publish","type":"post","link":"https:\/\/phoenixgamedevelopment.com\/blog\/p-152-virtual-world-concept-update-9-sql-server\/","title":{"rendered":"P-152: Virtual World Concept Update 9: SQL Server"},"content":{"rendered":"<p>I have just completed setting up and testing an SQL server in T3D.<\/p>\n<p>I had to first install Ubuntu linux on a server machine I had (it used to run Windows). I then had to install and configure mysql and mysql workbench.<\/p>\n<p>I had never used Ubuntu before now, and so far, I am likingit. It&#8217;s a nice operating system, fast, responsive, and powerful. I like the Software center, which makes installing software a breeze, I don&#8217;t even have to search websites. I did have an issue with installing mysql which required a few uninstalls\/reinstalls, but that may have been due to my inexperience.<\/p>\n<p>I used <a href=\"http:\/\/www.garagegames.com\/community\/blogs\/view\/13528\">THIS<\/a>\u00a0resource to set up mysql in T3D. It is the most straightforward and easy to use resource I have found to add mysql support to T3D.<\/p>\n<p>Something to be aware of when using mysql is licencing. I am not an expert on the legal issues present here, however, my understanding is that if a developer releases mysql code to a client, the developer is required to purchase a licence, which costs several thousand dollars. To avoid this, what I and other developers have been doing, is adding the mysql code to the servers only, and not the clients.<\/p>\n<p>The way this works is that instead of a program using client-side code to directly communicate with a database, it instead communicates with a game server. The game server then uses mysql to communicate with the database. Since the code on the game server is never released, the client never gets access to the mysql code, which means the developer doesn&#8217;t need to purchase a licence, even for a commercial game. This approach is also far more secure, since it prevents malicious users from modifying the client sql requests, and tampering with the database.<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/phoenixgamedevelopment.com\/blog\/wp-content\/uploads\/2014\/10\/PhoenixGameDevelopment01-Oct.-26-23.18.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-965\" src=\"https:\/\/phoenixgamedevelopment.com\/blog\/wp-content\/uploads\/2014\/10\/PhoenixGameDevelopment01-Oct.-26-23.18-300x232.jpg\" alt=\"PhoenixGameDevelopment01 Oct. 26 23.18\" width=\"300\" height=\"232\" srcset=\"https:\/\/phoenixgamedevelopment.com\/blog\/wp-content\/uploads\/2014\/10\/PhoenixGameDevelopment01-Oct.-26-23.18-300x232.jpg 300w, https:\/\/phoenixgamedevelopment.com\/blog\/wp-content\/uploads\/2014\/10\/PhoenixGameDevelopment01-Oct.-26-23.18-1024x793.jpg 1024w, https:\/\/phoenixgamedevelopment.com\/blog\/wp-content\/uploads\/2014\/10\/PhoenixGameDevelopment01-Oct.-26-23.18.jpg 1040w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a> <a href=\"https:\/\/phoenixgamedevelopment.com\/blog\/wp-content\/uploads\/2014\/10\/Screenshot-from-2014-10-26-23_05_41.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-964\" src=\"https:\/\/phoenixgamedevelopment.com\/blog\/wp-content\/uploads\/2014\/10\/Screenshot-from-2014-10-26-23_05_41-300x175.png\" alt=\"Screenshot from 2014-10-26 23_05_41\" width=\"300\" height=\"175\" srcset=\"https:\/\/phoenixgamedevelopment.com\/blog\/wp-content\/uploads\/2014\/10\/Screenshot-from-2014-10-26-23_05_41-300x175.png 300w, https:\/\/phoenixgamedevelopment.com\/blog\/wp-content\/uploads\/2014\/10\/Screenshot-from-2014-10-26-23_05_41.png 1024w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a> <a href=\"https:\/\/phoenixgamedevelopment.com\/blog\/wp-content\/uploads\/2014\/10\/Screenshot-from-2014-10-26-23_05_17.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-963\" src=\"https:\/\/phoenixgamedevelopment.com\/blog\/wp-content\/uploads\/2014\/10\/Screenshot-from-2014-10-26-23_05_17-300x175.png\" alt=\"Screenshot from 2014-10-26 23_05_17\" width=\"300\" height=\"175\" srcset=\"https:\/\/phoenixgamedevelopment.com\/blog\/wp-content\/uploads\/2014\/10\/Screenshot-from-2014-10-26-23_05_17-300x175.png 300w, https:\/\/phoenixgamedevelopment.com\/blog\/wp-content\/uploads\/2014\/10\/Screenshot-from-2014-10-26-23_05_17.png 1024w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a> <a href=\"https:\/\/phoenixgamedevelopment.com\/blog\/wp-content\/uploads\/2014\/10\/Screenshot-from-2014-10-26-23_03_08.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-962\" src=\"https:\/\/phoenixgamedevelopment.com\/blog\/wp-content\/uploads\/2014\/10\/Screenshot-from-2014-10-26-23_03_08-300x175.png\" alt=\"Screenshot from 2014-10-26 23_03_08\" width=\"300\" height=\"175\" srcset=\"https:\/\/phoenixgamedevelopment.com\/blog\/wp-content\/uploads\/2014\/10\/Screenshot-from-2014-10-26-23_03_08-300x175.png 300w, https:\/\/phoenixgamedevelopment.com\/blog\/wp-content\/uploads\/2014\/10\/Screenshot-from-2014-10-26-23_03_08.png 1024w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I have just completed setting up and testing an SQL server in T3D. I had to first install Ubuntu linux on a server machine I had (it used to run Windows). I then had to install and configure mysql and mysql workbench. I had never used Ubuntu before now, and so far, I am likingit. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,10],"tags":[],"class_list":["post-961","post","type-post","status-publish","format-standard","hentry","category-astral-realms","category-software-and-games","has-post-title","has-post-date","has-post-category","has-post-tag","has-post-comment","has-post-author",""],"aioseo_notices":[],"builder_content":"","_links":{"self":[{"href":"https:\/\/phoenixgamedevelopment.com\/blog\/wp-json\/wp\/v2\/posts\/961"}],"collection":[{"href":"https:\/\/phoenixgamedevelopment.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phoenixgamedevelopment.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phoenixgamedevelopment.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/phoenixgamedevelopment.com\/blog\/wp-json\/wp\/v2\/comments?post=961"}],"version-history":[{"count":2,"href":"https:\/\/phoenixgamedevelopment.com\/blog\/wp-json\/wp\/v2\/posts\/961\/revisions"}],"predecessor-version":[{"id":969,"href":"https:\/\/phoenixgamedevelopment.com\/blog\/wp-json\/wp\/v2\/posts\/961\/revisions\/969"}],"wp:attachment":[{"href":"https:\/\/phoenixgamedevelopment.com\/blog\/wp-json\/wp\/v2\/media?parent=961"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phoenixgamedevelopment.com\/blog\/wp-json\/wp\/v2\/categories?post=961"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phoenixgamedevelopment.com\/blog\/wp-json\/wp\/v2\/tags?post=961"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}