• Advertisement
Sign in to follow this  

Unity [web] Database on localhost

This topic is 3813 days old which is more than the 365 day threshold we allow for new replies. Please post a new topic.

If you intended to correct an error in the post then please contact us.

Recommended Posts

Heyas Folks, I need your help concerning databases and the usage of them. This field of programming is completely new to me, so I turn again to the best programming community there ist :) I am planning to write a little tool using c# and a database. Unfortunatly I dont have a server where you can access a mySQL database using a c# tool (only using php on the local host). So if you do know a webhost that allows you to access a mySQL database with a c# tool this would bring me a whole lot closer to finishing my program. So my new approach is to download a file via ftp (i already got that part workin) in which the database should be. And after adding or altering stuff in it, I simply upload it again, and voila there i have my own sweet little database. Thats the plan however. My problem with that is: How do I actually create a database file and make use of it with ordinary sql database commands? My plan is that I instead of connecting to a sql database i simply "connect" to that file. Well as you can see by the totally unstructured posting above, I dont realy have a clue on how to use databases. Maybe you can give me some advice, article or link to read to help me out. Anything in that direction is appreciated!! Thx in advance cherio Woltan

Share this post


Link to post
Share on other sites
Advertisement
You can run MySQL locally from your machine, then if you need to create/modify your database you can use the tools available here MySQL Tools

Malal


Share this post


Link to post
Share on other sites
Hey,
an important thing i didnt mention was, that this tool i am plannin to program should be run by multible users. So I need to download the database in some form to use it on the local machine and upload the modified data afterwards.
Do you have a better idea? let me know. Of course the best would be to buy a server, but since i only want to do little things first with my tool, it seems like a waste of money.
Hope you have an idea what i could do
thx in advance
Woltan

Share this post


Link to post
Share on other sites
There are hosting services out there that supply MySQL server hoisting (without webhosting). Some are even free. Some google hits:

http://yoursequel.com
http://free-mysql.bizhostnet.com/

There are also paid one's around. Or get a cheapo old PIII, install Linux and MySQL and voila, instant server. All you need then is a line to hook it to. My home ADSL line has 1024 Kb upstream which is enough to host a small website(*). Maybe you can do that too?

(*) My website itself is hosted at a standard shared hosting somewhere in a datacenter. At home I host all the specialty stuff I cannot fit on a shared host. Subversion web access, bugzilla, etcetera.

Share this post


Link to post
Share on other sites
Hey Sander,
I checked those two sites you mentioned. The first one (http://yoursequel.com) somehow doesn't make any sence to me. And the second one, it looks like you can only establish a mysql database and connect to it with a static ip. Unfortunatly I, and the other users, do not have a static ip. So what I could do with it, i could access it from webspace, where I could publish a homepage. If i am not mistaken those services you can find anywhere on the web ourdays. And for the other idea of plugging a PII or III to my internet connection wouldn't work for me either. I looks like I will have to come up with some sort of own database, that stores data in for example an xml file. This file then, can be up and downloaded via ftp, and my tool should be able to do that. I just somehow have find a way to grant access to that xml file multiple times at the same time. If you know what i mean ;)
Well then, if there is no free mySQL or other DB site, that allows connection with a dynamic IP i will build my own database, publish it and get very very rich ;)

Unless someone of you has an idea that solves my "problem"
thx for the postings!
cherio Woltan

Share this post


Link to post
Share on other sites
Sign in to follow this  

  • Advertisement
  • Advertisement
  • Popular Tags

  • Advertisement
  • Popular Now

  • Similar Content

    • By revolverolver
      Aloha,
      First time working in 3D. Not as difficult as I thought it would be although I am pretty much a complete beginner in Blender. I chose the low poly style because I like how it looks and it is a lot easier than trying to make it look realistic.
      The gameplay is pretty much all physics driven which makes it feel satisfying to play. If it looks any fun then please check it out. I could really use a review or two.
      Here are some promo codes so that you don't have to pay a dime to download it: 
      PJW7MTMWL3W3
      A4JLYRPTXMJH
      AXRKPMAT7AAY
      YMFJPTPJ9EX3
      JY3W6FNKTM6L
       
      App store link: https://itunes.apple.com/us/app/flip-trickster/id1351027839?l=en&mt=8
       
       
    • By Innoc uous
      I'm working on a space game, and I suck at art. I would love to get some help from someone who is more skilled than me. Things I need include modular space ship parts and GUI elements. Nothing too fancy, just functional so I can get a prototype put together. This could potentially become a serious project, but for now this is just a hobby project.
       
      In this video, you can see a few things I already completed
      :2018-02-24 20-08-13.flv2018-02-24 20-08-13.flv
    • By Innoc uous
      If you want to incorporate noise into your shaders, the Turbulance Library has you covered. Using code I gathered from this library, I made a cginc file that contains all you need to easily implement noise into your unity shaders. Who knows how this stuff works, but man, does it work well!
       
      https://pastebin.com/LLCUpJut
       
      Here is an example of what you can create using these noise functions.
       
    • By Nio Martinez
      I'll be buying a new laptop as my workstation for building games, Mostly 3D but not hard core. 
       
      I'm stuck at choosing between these 2 specs below. Does this really matter and if so, can some one tell my how and why it matters. 
      Choice1:
      Intel core i5-8250U (8th gen Kabylake refresh)(6 MB Smart Cache, 1.6 GHz Base with Turbo Boost up to 3.4 GHz) 4 cores 8 threads
      RAM 8 GB DDR4 (2400 MHz)
      GPU 2 GB DDR5 Nvidia MX150 256 bit
      SSD: yes
      Choice2:
      Intel core i7-7500U 2.70GHz Base Processor (4M Cache, up to 3.50 GHz Boost) 2 Cores, 4 Threads
      RAM 4 GB DDR4 (1800 MHz)
      GPU 2 GB DDR5 Nvidia GeForce 940MX 256 bit
      SSD: No
       
    • By Manuel Berger
      Hello fellow devs!
      Once again I started working on an 2D adventure game and right now I'm doing the character-movement/animation. I'm not a big math guy and I was happy about my solution, but soon I realized that it's flawed.
      My player has 5 walking-animations, mirrored for the left side: up, upright, right, downright, down. With the atan2 function I get the angle between player and destination. To get an index from 0 to 4, I divide PI by 5 and see how many times it goes into the player-destination angle.

      In Pseudo-Code:
      angle = atan2(destination.x - player.x, destination.y - player.y) //swapped y and x to get mirrored angle around the y axis
      index = (int) (angle / (PI / 5));
      PlayAnimation(index); //0 = up, 1 = up_right, 2 = right, 3 = down_right, 4 = down

      Besides the fact that when angle is equal to PI it produces an index of 5, this works like a charm. Or at least I thought so at first. When I tested it, I realized that the up and down animation is playing more often than the others, which is pretty logical, since they have double the angle.

      What I'm trying to achieve is something like this, but with equal angles, so that up and down has the same range as all other directions.

      I can't get my head around it. Any suggestions? Is the whole approach doomed?

      Thank you in advance for any input!
       
  • Advertisement