On 23 Oct 2011, at 5:06am, Paul Linehan wrote: > Is there a way of storing SQLite data (tables) as ASCII text rather > than as binary data? > > I want to be able to run scripts against my data as well as use SQLite.
I recommend you script the sqlite3 shell tool to pipe whatever data you want, or to make a text file of it which you can then read: http://www.sqlite.org/sqlite.html download it from here: http://www.sqlite.org/download.html > If it's not available as a "normal" option, is there a patch on the interweb > somewhere? > > If it does not exist, I respectfully suggest that it is worthy of > consideration > as a feature - maybe along the lines of MySQL storage engines? My guess is that it would slow down SQLite by a factor of three or more. Feel free to write it, and contribute your code. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users