building mySQL API for UScript need help.

[Qjahe]

Hi,

i've been looking all over for some information on how to have UScript connect and select/insert records from a mySQL server, and couldn't find anything anywhere. So I am going to attempt to do the API myself.

I was wondering if I could just somehow import mysql.h from mysql in one of my classes? Couldn't be that easy?

In last resort i'm thinking of subclassing the UBrowserBufferedTCPLink and going from there to connect to the mysql server.

I am not sure how mySQL is expecting a connection tho?
Do I just open a TCP socket on the right port and then send SQL queries and wait for the answer?

Anyone has any usefull info on this?

Thanks

Qjahe

 

[Tremor_]

don't go through al the troubles to make your own connection to a mySQL db

TCPlink --> php/asp page --> mySQL db

 

[pjmodos]

Why not?
I made direct interface to postgresql and it wasn't so hard (yes it's limited but it does what i needed).
I dunno about mysql but it shouldn't be problem, you just need to learn it's raw protocol.

 

[Qjahe]

hmmm

Why not?
I made direct interface to postgresql and it wasn't so hard (yes it's limited but it does what i needed).
I dunno about mysql but it shouldn't be problem, you just need to learn it's raw protocol.

You think it'll be faster to connect directly to mySQL server?
How do you manage to keep your DB login / pwd hidden?

COuld I see a sample of your code?

Thanks for the info...

Qjahe

 

[elmuerte]

direct access to a database has a couple issues much depending on the "what" of the thing you are going to do.

the most important one it the security.
usually you configure your database servr to only allow connections from a localhost.
another very important issue is the compatibility, unless it's for private use only, you can guarantee that the user has access to the right DBMS.