Viable alternatives to SQL?

Many sites let you search databases of information, but the search
queries are very limited.

I'm creating a site that'll allow arbitrary SQL queries to my data (I
realize I'll need to handle injection attacks).

Are there other viable ways to query data? I read a little on
"Business System 12" (BS12), Tutorial D, and even something called
T-SQL (I think), but they all seem theoretical and not fully
implemented.

I want a query language that non-techies can use easily, but also
supports arbitrarily complex queries. Does such a language exist?

--
We're just a Bunch Of Regular Guys, a collective group that's trying
to understand and assimilate technology. We feel that resistance to
new ideas and technology is unwise and ultimately futile.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Viable alternatives to SQL?

Kelly Jones wrote:
> Many sites let you search databases of information, but the search
> queries are very limited.
>
> I'm creating a site that'll allow arbitrary SQL queries to my data (I
> realize I'll need to handle injection attacks).
>
> Are there other viable ways to query data? I read a little on
> "Business System 12" (BS12), Tutorial D, and even something called
> T-SQL (I think), but they all seem theoretical and not fully
> implemented.
>
>
T-SQL stands for Transact-SQL, which is Microsoft's implementation of SQL
> I want a query language that non-techies can use easily, but also
> supports arbitrarily complex queries. Does such a language exist?
>
>
http://en.wikipedia.org/wiki/SQL#Alternatives_to_SQL


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: Viable alternatives to SQL?

>-----Original Message-----
>From: Kelly Jones [mailto:kelly.terry.jones@gmail.com]
>Sent: Thursday, August 27, 2009 9:44 AM
>To: mysql@lists.mysql.com
>Subject: Viable alternatives to SQL?
>
>Many sites let you search databases of information, but the search
>queries are very limited.
>
>I'm creating a site that'll allow arbitrary SQL queries to my data (I
>realize I'll need to handle injection attacks).
>
[JS] Taking you literally, wouldn't that presume that your users have
knowledge of the underlying database structure?

If not, then I think you'll need to go with "fill in the blanks" type of
query form.

Regards,
 
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
 
860.674.8796 / FAX: 860.674.8341
 
www.the-infoshop.com




>Are there other viable ways to query data? I read a little on
>"Business System 12" (BS12), Tutorial D, and even something called
>T-SQL (I think), but they all seem theoretical and not fully
>implemented.
>
>I want a query language that non-techies can use easily, but also
>supports arbitrarily complex queries. Does such a language exist?
>
>--
>We're just a Bunch Of Regular Guys, a collective group that's trying
>to understand and assimilate technology. We feel that resistance to
>new ideas and technology is unwise and ultimately futile.
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql?unsub=jschwartz@the-
>infoshop.com





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: Viable alternatives to SQL?

Isn't that basically the same as pointing phpmyadmin at a read-only copy of=
the data?

There's a reason most searches are limited; when you most people too many o=
ptions, it's confusing. Good interfaces hide complexity from the end user.


-----Original Message-----
From: Jerry Schwartz [mailto:jschwartz@the-infoshop.com]
Sent: Thursday, August 27, 2009 8:08 AM
To: 'Kelly Jones'; mysql@lists.mysql.com
Subject: RE: Viable alternatives to SQL?

>-----Original Message-----
>From: Kelly Jones [mailto:kelly.terry.jones@gmail.com]
>Sent: Thursday, August 27, 2009 9:44 AM
>To: mysql@lists.mysql.com
>Subject: Viable alternatives to SQL?
>
>Many sites let you search databases of information, but the search
>queries are very limited.
>
>I'm creating a site that'll allow arbitrary SQL queries to my data (I
>realize I'll need to handle injection attacks).
>
[JS] Taking you literally, wouldn't that presume that your users have
knowledge of the underlying database structure?

If not, then I think you'll need to go with "fill in the blanks" type of
query form.

Regards,

Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341

www.the-infoshop.com




>Are there other viable ways to query data? I read a little on
>"Business System 12" (BS12), Tutorial D, and even something called
>T-SQL (I think), but they all seem theoretical and not fully
>implemented.
>
>I want a query language that non-techies can use easily, but also
>supports arbitrarily complex queries. Does such a language exist?
>
>--
>We're just a Bunch Of Regular Guys, a collective group that's trying
>to understand and assimilate technology. We feel that resistance to
>new ideas and technology is unwise and ultimately futile.
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql?unsub=3Djschwartz@the-
>infoshop.com





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgtowey@ffn.com


The information contained in this transmission may contain privileged and c=
onfidential information. It is intended only for the use of the person(s) n=
amed above. If you are not the intended recipient, you are hereby notified =
that any review, dissemination, distribution or duplication of this communi=
cation is strictly prohibited. If you are not the intended recipient, pleas=
e contact the sender by reply email and destroy all copies of the original =
message.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg