Re: [sqlite] Tables as ASCII - is it possible?

2011-10-23 Thread Jay A. Kreibich
On Sun, Oct 23, 2011 at 05:06:46AM +0100, Paul Linehan scratched on the wall: > Hi all, > > 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. SQLite has drivers for most popular

Re: [sqlite] Tables as ASCII - is it possible?

2011-10-23 Thread Petite Abeille
On Oct 23, 2011, at 6:06 AM, Paul Linehan wrote: > Is there a way of storing SQLite data (tables) as ASCII text rather > than as binary data? Perhaps you might be better off with something along the lines of KirbyBase or such. http://www.netpromi.com/kirbybase_python.html _

Re: [sqlite] Tables as ASCII - is it possible?

2011-10-22 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 22/10/11 21:06, 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. Yes, and it is very easy. SQLite has s

Re: [sqlite] Tables as ASCII - is it possible?

2011-10-22 Thread Mr. Puneet Kishor
On Oct 22, 2011, at 11:34 PM, Paul Linehan wrote: > If I could go with > a scripting language, it would be Python - vastly superior IMHO > to Perl - YMMV. Yup. My mileage does vary. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.o

Re: [sqlite] Tables as ASCII - is it possible?

2011-10-22 Thread Paul Linehan
2011/10/23 Mr. Puneet Kishor : >> I want to be able to run scripts against my data as well as use SQLite. > Are you suggesting that you want to treat text data as a SQL data store? No, I'm suggesting that the SQLite engine be able to have table data available as text files - table1.txt, table2

Re: [sqlite] Tables as ASCII - is it possible?

2011-10-22 Thread Paul Linehan
2011/10/23 Simon Slavin : >> 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: Looks that this is the way to go alright! >> If it does

Re: [sqlite] Tables as ASCII - is it possible?

2011-10-22 Thread Mr. Puneet Kishor
On Oct 22, 2011, at 11:06 PM, Paul Linehan wrote: > Hi all, > > 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. > .. Are you suggesting that you want to treat text data as a S

Re: [sqlite] Tables as ASCII - is it possible?

2011-10-22 Thread Simon Slavin
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,

[sqlite] Tables as ASCII - is it possible?

2011-10-22 Thread Paul Linehan
Hi all, 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. If it's not available as a "normal" option, is there a patch on the interweb somewhere? If it does not exist, I respectfully s