Re: [sqlite] graphs and sql

2010-01-10 Thread Nick Atty
Robert Citek wrote: On Sun, Jan 10, 2010 at 8:06 PM, Dan Bishop danbisho...@gmail.com wrote: Robert Citek wrote: Does anyone have any recommendations for books or other resources that deal with working with graphs (i.e. vertexes and edges) using sql? I don't think that SQL is the best

Re: [sqlite] SQLITE_ERROR with system usage

2010-01-06 Thread Nick Atty
Have you run a memory test on your system? Random failings when working hard is a classic symptom of dodgy memory (launching Firefox may cause memory to be allocated for SQLite elsewhere than when there's nothing else running). I once had a system that would segfault in the C compiler in

Re: [sqlite] mode is not changed

2010-01-02 Thread Nick Atty
Depending on how you are calling sqlite3, you should be able to feed any list of commands into it. For example, under a typical Unix shell you could do sqlite3 mydb EOF .mode csv .show EOF Here, in fact, is what happens when I type just that /var/www/canal$ sqlite3 mydb EOF .mode csv .show