|
|
|
|
|
|
| Author |
Message |
Lorance Stinson
*nix forums beginner
Joined: 18 Jun 2006
Posts: 5
|
 Posted: Sun Jun 18, 2006 5:34 pm Post subject:
A new version of SHQL
|
|
|
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/ |
|
| Back to top |
|
 |
Chris F.A. Johnson
*nix forums Guru
Joined: 20 Feb 2005
Posts: 2268
|
| Posted: Sun Jun 18, 2006 5:59 pm Post subject:
Re: A new version of SHQL
|
|
|
On 2006-06-18, Lorance Stinson wrote:
| Quote: | 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/
|
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 |
|
| Back to top |
|
|
Lorance Stinson
*nix forums beginner
Joined: 18 Jun 2006
Posts: 5
|
| Posted: Sun Jun 18, 2006 6:24 pm Post subject:
Re: A new version of SHQL
|
|
|
Chris F.A. Johnson wrote:
| Quote: | The link to the tarball, <http://lorance.freeshell.org/shql/shql-2b1.tar.gz
does not work. It goes to <http://myspace.com/redmartian>.
|
Sorry about that and thanks for catching it. I forgot to rename the
file. It has been fixed now. |
|
| Back to top |
|
|
bsh
*nix forums Guru Wannabe
Joined: 01 Mar 2005
Posts: 125
|
| Posted: Tue Jun 20, 2006 1:17 am Post subject:
Re: A new version of SHQL (long)
|
|
|
Lorance Stinson wrote:
| Quote: | 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/
|
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.unix.shell/tree/browse_frm/thread/cd2ec46d1d6f7ac6/11acbcbdd6b659a4?rnum=11&_done=%2Fgroup%2Fcomp.unix.shell%2Fbrowse_frm%2Fthread%2Fcd2ec46d1d6f7ac6%2F190dfc2c9477807e%3F#doc_11acbcbdd6b659a4
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@sevasoftware.com>
"dbops.{awk,c}",,http://www.simtech-soft.com/dbops.shtml,$450.00,"RDBMS:
ASCII","William F. Simmons" <wfs@simtech-soft.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@users.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@strozzi.it,carlos@linux.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@rand.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@cfa.harvard.edu>
"jdb.pl",1.13,http://www.isi.edu/~johnh/SOFTWARE/JDB/;http://www.freshports.org/databases/,$0,"RDB:
ASCII","John Heidemann" <johnh@isi.edu>
=Brian |
|
| Back to top |
|
|
Lorance Stinson
*nix forums beginner
Joined: 18 Jun 2006
Posts: 5
|
| Posted: Tue Jun 20, 2006 3:14 am Post subject:
Re: A new version of SHQL (long)
|
|
|
bsh wrote:
| Quote: | 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! 
|
I was just having fun playing with it. Shell script fascinates me and
can be relaxing after an anoying days work.
| Quote: | 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 !!!
|
I have that script. An amazing piece of work.
| Quote: | 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.
|
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.
| Quote: | BTW, did you see that recent post of mine, giving other
examples of scripts implementing RDBs, including the
above kshsql?
|
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. |
|
| Back to top |
|
|
Lorance Stinson
*nix forums beginner
Joined: 18 Jun 2006
Posts: 5
|
| Posted: Sat Jul 15, 2006 5:25 pm Post subject:
Re: A new version of SHQL
|
|
|
I have released a new version with some bug fixes and a few new
features.
Lorance Stinson wrote:
| Quote: | 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/ |
|
|
| Back to top |
|
|
bsh
*nix forums Guru Wannabe
Joined: 01 Mar 2005
Posts: 125
|
| Posted: Sun Jul 16, 2006 12:34 am Post subject:
Re: A new version of SHQL
|
|
|
Lorance Stinson wrote:
| Quote: | I have released a new version with some bug fixes and a few new
features.
|
Thanks!
(Is it more efficient now?)
=Brian |
|
| Back to top |
|
|
Lorance Stinson
*nix forums beginner
Joined: 18 Jun 2006
Posts: 5
|
| Posted: Tue Jul 18, 2006 11:02 pm Post subject:
Re: A new version of SHQL
|
|
|
bsh wrote:
| Quote: | (Is it more efficient now?)
|
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. |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Mon Dec 01, 2008 11:53 pm | All times are GMT
|
|
Myspace Layouts | MPAA | Mortgage | Online Advertising | Per Insurance
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Programming
»
shell
