SHQL is an SQL database written in shell script. I have been using and
expanding it and with the original authors permission I am making my
changes available on the internet. I have added many new features and
expanded it in many ways. For more information please see the shql part
of my website:
http://lorance.freeshell.org/shql/

On 2006-06-18, Lorance Stinson wrote:
The link to the tarball, <http://lorance.freeshell.org/shql/shql-2b1.tar.gz>
does not work. It goes to <http://myspace.com/redmartian>.

--
Chris F.A. Johnson, author <http://cfaj.freeshell.org>
Shell Scripting Recipes: A Problem-Solution Approach (2005, Apress)
===== My code in this post, if any, assumes the POSIX locale
===== and is released under the GNU General Public Licence

Chris F.A. Johnson wrote:
Sorry about that and thanks for catching it. I forgot to rename the
file. It has been fixed now.

Lorance Stinson wrote:
Thank you; I am pleased that this script has continued to
live on to impress upon those who doubt the power of what
can be accomplished with time, effort, ...and ADD!

It reminds me of an implementation of dc(1) (!) written in
sed(1) (!!) and authored by Greg Ubben. And it's _faster_
than some ports. HA !!!

My major contribution is, that the script needs to be rewritten
in kornshell/bash to get the best performance and portability
from it. sh(1) has problematic syntax, especially regarding
process substitution (`...`) and the (lack of) functional scoping.

My major question is: how does it compare to Dana French's
"kshsql" -- a similar rewrite -- now at:

http://freshmeat.net/projects/kshsql/

BTW, did you see that recent post of mine, giving other
examples of scripts implementing RDBs, including the
above kshsql?

http://groups.google.com/group/comp....acbcbdd6b659a4

There are so many others, including:

"plod.py",,http://www.kryogenix.org/code/plod.py.html,$0,"RDBMS:
utilizes CVS.py"

"arunadb.ruby",0.80,http://www.arunadb.com/;http://www.sevasoftware.com/arunadb/;http://www.downloaddatabase.com/databasesoftware/download-arunadb.htm,$0,"RDBMS:
ASCII","Michael Davis" <mdavis (AT) sevasoftware (DOT) com>

"dbops.{awk,c}",,http://www.simtech-soft.com/dbops.shtml,$450.00,"RDBMS:
ASCII","William F. Simmons" <wfs (AT) simtech-soft (DOT) com>

"txtSQL.php",3.0.0b,http://txtsql.sourceforge.net/;http://chibiguy.dotgeek.org/;http://www.n-e-x.co.uk/files/txtsql.zip,$0,"RDBMS:
OO, SQL and PHP","Faraz Ali" <farazali (AT) users (DOT) sourceforge.net>

"nosql.mawk",4.0.12,http://www.scriptaworks.com/cgi-bin/wiki.cgi/NoSQL/HomePage?from=NoSQL.NoSQL;http://www.strozzi.it/users/carlo/nosql/;http://www.scriptaworks.com/shared/nosql/;http://www.scriptaworks.com/cgi-bin/wiki.cgi/NoSQL/DocumentationIndex,$0,"RDB:
ASCII","Carlo Strozzi" <noseequel (AT) strozzi (DOT) it,carlos (AT) linux (DOT) it>

"RDB-Hobbs.pl",2.6d,ftp://ftp.rand.org/pub/RDB-hobbs/RDB-2.6d.tar.gz;ftp://ftp.netbsd.org/pub/NetBSD/packages/1.6.1/sparc/All/rdb-2.6.4.tgz;http://www.cse.ucsc.edu/research/compbio/rdb/,$0,"RDB:
ASCII","Walter V. Hobbs" <hobbs (AT) rand (DOT) org>

"RDB.pl;rdbstats;rdb2latex",,http://hea-www.harvard.edu/MST/simul/software/docs/rdb.html,$0,"RDB,
based on rdb-hobbes","Diab Jerius" <djerius (AT) cfa (DOT) harvard.edu>

"jdb.pl",1.13,http://www.isi.edu/~johnh/SOFTWARE/JDB/;http://www.freshports.org/databases/,$0,"RDB:
ASCII","John Heidemann" <johnh (AT) isi (DOT) edu>

=Brian

bsh wrote:
I was just having fun playing with it. Shell script fascinates me and
can be relaxing after an anoying days work.

I have that script. An amazing piece of work.

I have not messed with the korn shell yet. Also neither korn nor bash
is installed every where. I have attempted to use portable syntax and
thus far my additions work every place I have tested them.

I will have to try that some time. My changes actually cause shql to
slow down. I've been working on speeding things back up again. The real
speed killer is the bit that handles SQL functions. They can be nested
and thus some interesting trickery is used to make it work.

Yes, I did. While most of those look interesting I don't touch PHP,
have never tried Ruby or Python and avoid windows when I can. I have
played with RDB and NoSQL but never really cared for them. JDB looks
interesting but is rather similar to RDB NoSQL.

I have released a new version with some bug fixes and a few new
features.

Lorance Stinson wrote:

Lorance Stinson wrote:
Thanks!

(Is it more efficient now?)

=Brian

bsh wrote:
No, and it likely never will be. Each column in a select or where
statement is checked in a function that is called in a sub shell. This
was the only way I could find to add nested function calling. This
makes my version much slower but adds functionality I want.

I have released a Caller ID app I developed for SHQL. I have been using
it for a while now and finally worked out a few bugs that kept me from
releasing it. It consists of a small program that watches a modem and
waits for Caller ID information, storing the information in an SHQL
database. And a small program that watches the database for new calls.
More information can be found at <http://lorance.freeshell.org/cid/>.
Since this is a small application I wrote for my own use the only
documentation is on that page and in the comments in the scripts.