pysqsh / News: Recent posts

Python Sqlite Shell - a drop-in replacement for the standard sqlite shell (www.sqlite.org), expanded to allow user defined SQL functions to be easily created within the shell or within a SQL script using an in-line python function definition, and with expanded .import functionality supporting CSV file import, the skipping or discarding of input records, and allowing custom imports by specifying a python defined record-to-field import function (.importfn). ... read more

Python Sqlite Shell - a drop-in replacement for the standard sqlite shell (www.sqlite.org), expanded to allow user defined SQL functions to be easily created within the shell or within a SQL script using an in-line python function definition, and with expanded .import functionality supporting CSV file import, the skipping or discarding of input records, and allowing custom imports by specifying a python defined record-to-field import function (.importfn). ... read more

Python Sqlite Shell - a drop-in replacement for the standard sqlite shell (www.sqlite.org), expanded to allow user defined SQL functions to be easily created within the shell or within a SQL script using an in-line python function definition, and with expanded .import functionality supporting CSV file import, the skipping or discarding of input records, and allowing custom imports by specifying a python defined record-to-field import function (.importfn).... read more

Python Sqlite Shell - a drop-in replacement for the standard sqlite shell (www.sqlite.org), expanded to allow user defined SQL functions to be easily created within the shell or within a SQL script using an in-line python function definition, and to allow .import to support CSV file import; or you can specify a python defined record-to-field import function for further customization.

Release 0.6.4 extends the .import command adding --skip and --discardmax options, so for example ".import file table --skip=1" will import the file but skip the first line of the file.... read more

Python Sqlite Shell - a drop-in replacement for the standard sqlite shell (www.sqlite.org), expanded to allow user defined SQL functions to be easily created within the shell or within a SQL script using an in-line python function definition, and to allow .import to support CSV file import; or you can specify a python defined record-to-field import function for further customization.

Release 0.6.3 adds support for the standard SQLite html and insert output .modes and implements an additional xml output .mode. It can be downloaded from https://sourceforge.net/project/showfiles.php?group_id=244384 ... read more

Python Sqlite Shell - a drop-in replacement for the standard sqlite shell (www.sqlite.org), expanded to allow user defined SQL functions to be easily created within the shell or within a SQL script using an in-line python function definition, and to allow .import to support CSV file import; or you can specify a python defined record-to-field import function for further customization.

Release 0.6.2 starts the addition of .mode functionality, now handles escaped characters within dot commands, and fixes some minor bugs; it can be downloaded from https://sourceforge.net/project/showfiles.php?group_id=244384 ... read more

Python Sqlite Shell - a drop-in replacement for the standard sqlite shell (www.sqlite.org), expanded to allow user defined SQL functions to be easily created within the shell or within a SQL script using an in-line python function definition, and to allow .import to support CSV file import; or you can specify a python defined record-to-field import function for further customization.

Release 0.6.1 is a small bug fix release; it can be downloaded from https://sourceforge.net/project/showfiles.php?group_id=244384 ... read more

Python Sqlite Shell - a drop-in replacement for the standard sqlite shell (www.sqlite.org), expanded to allow user defined SQL functions to be easily created within the shell or within a SQL script using an in-line python function definition, and to allow .import to support CSV file import; or you can specify a python defined record-to-field import function for further customization.

Release 0.6.0 adds database persistence of .def'd functions along with a number of minor bug fix and feature enhancements and can be downloaded from https://sourceforge.net/project/showfiles.php?group_id=244384 ... read more