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

Reply via email to