LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > LinuxQuestions.org > LQ Suggestions & Feedback
User Name
Password
LQ Suggestions & Feedback Do you have a suggestion for this site or an idea that will make the site better? This forum is for you.
PLEASE READ THIS FORUM - Information and status updates will also be posted here.

Notices

Reply
 
Search this Thread
Old 05-26-2005, 08:27 PM   #1
jonaskoelker
Senior Member
 
Registered: Jul 2004
Location: Denmark
Distribution: Ubuntu, Debian
Posts: 1,524

Rep: Reputation: 46
seaching by SQL queries


Hi.

I would like to propose a more advanced search facility. I think interpreting SQL requests from the users is the power I would like, but since I haven't had the database course yet, I'm not sure

A concrete example: I would like to say things like
"threads fulfilling: contains 2+ posts by jonaskoelker and 1+ post by padma"
"(same): contains posts only in date range 9 months to 12 months old"
"all closed threads in forum <foo> which doesn't contains text <bar> in any post"
the general idea: much finer granularity.

If this measn I'll have to learn SQL before my database course (*gasp* learning stuff that's not homework ), so be it.

Also, since I don't know SQL, I'm not aware of the security implications, but I suspect this will be the strongest argument against.

Just an idea,

Jonas Kölker
 
Old 05-26-2005, 11:17 PM   #2
trickykid
Guru
 
Registered: Jan 2001
Posts: 24,133

Rep: Reputation: 199Reputation: 199
Oh my.. allow users to run their own SQL searches.. not only a security risk but I can only imagine how long it would take for the server to crash..

My last job, they took away the Support Departments privileges and a a very large majority of the Development groups rights to run SQL statements on their production servers cause they didn't know how to run proper statements. Some were causing load issues, others were causing servers to hang and crash.. I hope you get the point.. I'll bet 1 Million dollars I don't have that Jeremy would never open this up cause well, not even Moderators have access to run SQL statements on this site..
 
Old 05-26-2005, 11:23 PM   #3
vharishankar
Senior Member
 
Registered: Dec 2003
Posts: 3,142
Blog Entries: 4

Rep: Reputation: 121Reputation: 121
Quote:
Oh my.. allow users to run their own SQL searches.. not only a security risk but I can only imagine how long it would take for the server to crash..
Just a doubt. Wouldn't running SQL queries directly require the database password? Now just imagine Jeremy giving away the database password to all of us
 
Old 05-27-2005, 01:15 AM   #4
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,414

Rep: Reputation: 1966Reputation: 1966Reputation: 1966Reputation: 1966Reputation: 1966Reputation: 1966Reputation: 1966Reputation: 1966Reputation: 1966Reputation: 1966Reputation: 1966
well you can always have read-only, resource limited access, but either way, i really can't see this being a realistic option.
 
Old 05-27-2005, 09:20 AM   #5
jeremy
root
 
Registered: Jun 2000
Distribution: Debian, Red Hat, Slackware, Fedora, Ubuntu
Posts: 10,447

Rep: Reputation: 2632Reputation: 2632Reputation: 2632Reputation: 2632Reputation: 2632Reputation: 2632Reputation: 2632Reputation: 2632Reputation: 2632Reputation: 2632Reputation: 2632
While we do plan to improve the search in the future, requiring users to understand database schema and SQL is just not a viable option.

--jeremy
 
Old 05-27-2005, 09:38 AM   #6
jonaskoelker
Senior Member
 
Registered: Jul 2004
Location: Denmark
Distribution: Ubuntu, Debian
Posts: 1,524

Original Poster
Rep: Reputation: 46
Quote:
*requiring* users to understand ...
(emphasis added)

I was thinking it more as an alternative offer to those who knew it already or would take the time to learn--while keeping the old search facility as the default method (possibly with improvements).

(the intent of keeping on is just to make sure we don't misunderstand each other; dismiss my suggestion on grounds of a flaw in what I actually meant and I'll shut up)

--Jonas
 
Old 05-27-2005, 09:52 AM   #7
trickykid
Guru
 
Registered: Jan 2001
Posts: 24,133

Rep: Reputation: 199Reputation: 199
Quote:
Originally posted by jonaskoelker
I was thinking it more as an alternative offer to those who knew it already or would take the time to learn--while keeping the old search facility as the default method (possibly with improvements).
I would hope that LQ would never open up its database to users to peform SQL statements for learning purposes. Anyone that has access to such things even more advanced users, running one statement that goes wrong could bring a site of any size to a halt, even if you think its a simple query, etc.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL: tables and queries in school project cold Programming 1 10-29-2005 07:58 PM
SQL queries per page (PHP, MySQL) Silent1 Programming 2 06-27-2004 11:15 PM
JSP: sql queries markus1982 Programming 0 11-05-2003 05:20 AM
php post data sql queries... bulliver Programming 2 01-03-2003 02:18 AM
sql queries in C program dnewman5 Programming 0 09-14-2001 01:34 PM


All times are GMT -5. The time now is 09:03 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration