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 options, it's
confusing. Good interfaces hide complexity from the end user.
From: Jerry Schwartz [mailto:jschwartz@stripped]
Sent: Thursday, August 27, 2009 8:08 AM
To: 'Kelly Jones'; mysql@stripped
Subject: RE: Viable alternatives to SQL?
>From: Kelly Jones [mailto:kelly.terry.jones@stripped]
>Sent: Thursday, August 27, 2009 9:44 AM
>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
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
>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
>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=1
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
The information contained in this transmission may contain privileged and confidential
information. It is intended only for the use of the person(s) named above. If you are not
the intended recipient, you are hereby notified that any review, dissemination,
distribution or duplication of this communication is strictly prohibited. If you are not
the intended recipient, please contact the sender by reply email and destroy all copies of
the original message.