On 12 Jan 2012, at 12:19pm, Hajo Locke wrote: >> On 12 Jan 2012, at 11:16am, Hajo Locke wrote: >> >>> but my problem is now how to do this with sql-statements using multiple >>> lines with EOT >> >> Make a file with the commands in, and pipe that file to the command-line >> tool instead of trying to put the commands straight into it. > > this works but is there no other way? > i use regexp-statement 4 times in script. it is possible that this script is > running by a lot of users at the same time. > every time creating a temp-file,filling with data, deleting etc. seems to me > to be very expensive and i want to avoid this.
Using the shell tool is itself a very 'expensive' way to manipulate a SQLite database. If you're concerned about concurrent users, write proper software directly in perl to do it, rather than using perl to create a shell and execute the shell tool in it. http://mailliststock.wordpress.com/2007/03/01/sqlite-examples-with-bash-perl-and-python/ Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
