[RESOLVED] is this useful ???

[kakki]

hello @ all,

i've created a new tool ... which no one ( except me ... of course :D )
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

[bradgrafelman]

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.

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?

[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 ...