Advogato: Simple SQL Protocol

Posted 18 Sep 2002 at 12:09 UTC by sarum

Why is there no SSQLP? If you look at all the other basic networked servers there is a simple tcp/ip connection system. What happened to the one for DBs?

Recently I have got more involved with DBMS and like a lot of people (I assume) I keeping hit my head against the wall with ODBC, ADO etal connection systems. If you don't happen to have the correct drivers/ COM objects for the correct OS, and the wind is in a good direction, and you have not spent the last 6 years of your life using it, it never seams to setup correctly first time. I don't know how much time I have waste with MySQL and SQL Server attempting to get ASP and Perl, locally and remotely to talk to an remote ISPs configuration.

Last night it struck me, if there was a simple protocol like SMTP, POP3, FTP etc then it would be a dodle.

It would need a USER/PASS, you would then be ADMIN mode and could connect, create, remote a DATABASE. Once in DATABASE mode you could send SQL statements and get results back as lines of CSV until a line with a '.'.

May be this is just a pipe dream or maybe ODBC/ADO is this. If so why does it seam so difficult to setup?

RFC 2259, posted 4 Nov 2002 at 06:26 UTC by jbucata »

(Now that I'm certified as an Apprentice I can reply directly instead of relying on my diary.)

Check out RFC 2259--it's basically what you're after, I think. Not that anybody implements it, but if you're the enterprising type it's certainly a good starting point.

Thanks, posted 12 Dec 2002 at 17:16 UTC by sarum »

Just spotted your suggestion. That is just what I meant, thanks :)

Simple SQL Protocol

Posted 18 Sep 2002 at 12:09 UTC by sarum

RFC 2259, posted 4 Nov 2002 at 06:26 UTC by jbucata » (Apprentice)

Thanks, posted 12 Dec 2002 at 17:16 UTC by sarum » (Journeyer)