[RESOLVED] is this useful ???

kakki

hello @ all,

i've created a new tool ... which no one ( except me ... of course 😃 )
seems to appreciate ...

can you give me some input on that ???

the url is:
http://sourceforge.net/projects/texql/
if the text doesnt fit, pls comment on that too ...
once you look @ the screenshots, you will get the meaning of it ...
( the "webpage" should lead to the example-installation )

thnx in advance,
kakki

kakki

hmm ....
the script grants sql-like access to text files on the filesystem ...
eg.

SELECT .....sth....... 
FROM ./ 
WHERE CONTAINS='mysql_connect' OR 'mysql_pconnect' 
     AND filename="*.php"

rulian

if SQL Lite doest have that capability, I do think that have useful applications
if you can find a case where you need so much functionality with no security issues.

kakki

well ...
this works on your system as well ...
you can look thru your sourcecode !!!

that is no db-engine ... my script creates a bash-script, which searches
the filesystem

kakki

"Also, what about those people who can't execute shell commands? Or perhaps the commands you used aren't available/are different (various distro's of Unix), or if the server is running Windows?"

yeah ... i noticed some problems on solaris recently ... but i've tested it against some
debian distris, ubuntu-distris and suse distris ... worked on all the above systems
hmm anyone with a bash shell that uses gnu commands can use it. i develop on windows myslf and i use cygwin for the bash.
this sql stuff evolved when my boss told me to maintain some php applicaitions,
that i have never seen before ... after some grepping i noticed, that nearly all
grep commands are similar, so i wrote this sql-interface for it.

kakki

"Looks like it could use some critiquing... such as removing all references to ereg/eregi functions... in fact, some places that you used ereg/eregi() didn't even need regular expressions and could be further optimized."

yes ... thats right, the code doesnt look "good" and will not run optimal.
this is still a prototype, the next release will have pregs and string operations instead of
slow regular expressions

kakki

thnx for the input ...