read/write sql server

Unity Engine
1

I was wanting to know if you can write and read from a sql table. I know about the WWW form which can read from a perl script i believe correct me if Im wrong. If there is a better way to do this please let me know.

2

I think you can use c# plugin. Than just use normal function how c# connect to sql.

3

Try this
http://npgsql.projects.postgresql.org/docs/manual/UserManual.html

This works well with standalone players. However, when building, Unity puts in the dll in the wrong place, but it can be moved manually after build and then works great. I have not been able to get this working in a web player however. Perhaps there is a way, to make sure that the Npgsql.dll is built in correctly.

copy into your project :
/Applications/Unity/Unity.app/Contents/Frameworks/Mono.framework/Npgsql.dll

Also you should add : System.Data.dll to you project.

Using these, provides very fast and solid data base access for a Postgres server and handles binary data very well.

4

I dont have the directory /Applications/Unity/Unity.app/Contents/Frameworks/Mono.framework/Npgsql.dll

not sure if its because I’m doing the evaluation or maybe a newer version of Unity.

I can’t seem to find the System.Data.dll do I have to download it?

5

Has there been any progress with Npgsql on the web player?

6

Putting it in the webplayer would be kind of useless and will potentially not even work.

Here my thoughts:

  1. Why would you want to make it possible for hackers to fully access your database?
    Never forget, webplayers are executed on the client, not the server so they can actually read your whole traffic

  2. If it is meant for locally stored databases: you can’t access them, file io is not available in the webplayer at all.