Re: [sqlite] SQLite/LINQ?

2012-04-25 Thread Taleeb Anwar
Oh sorry! there is no update of dbLinq (as you noted) for some time now. What about dotconnect for sqlite Thanks & Regards Taleeb Anwar *Hai Ab bhi Tera "Shwarma" Afsana Khwan Humara!!* On Thu, Apr 26, 2012 at 10:12 AM, Taleeb Anwar

Re: [sqlite] SQLite/LINQ?

2012-04-25 Thread Taleeb Anwar
I've never tried it - but dblinq seems to be one option worth trying. Thanks & Regards Taleeb Anwar *Hai Ab bhi Tera "Shwarma" Afsana Khwan Humara!!* On Thu, Apr 26, 2012 at 5:13 AM, Ken godee wrote: > Is there any way to

Re: [sqlite] Logging of sqlite3 commands

2012-04-25 Thread Richard Hipp
On Wed, Apr 25, 2012 at 4:59 PM, Champ Lee wrote: > Hello List, > > I am using the sqlite3 client on MS windows from a command prompt. I > frequently issue a number of select commands while exploring data, and > before I know it, have entered several dozen, fairly complex

[sqlite] SQLite/LINQ?

2012-04-25 Thread Ken godee
Is there any way to use SQLite/LINQ/C# - programmatically? I'm new to the C# world and once I read about LINQ it sure seemed the way to go. Maybe I'm missing something but I've really beat this to death trying to find a solution. I'm not using Visual Studio. DBLing is dead. LingPad

Re: [sqlite] Logging of sqlite3 commands

2012-04-25 Thread Mircea Neacsu
Personally, I do it the other way around: I keep a text editor opened and type my commands there, than paste it into the sqlite prompt window. In the end I have a list of nicely formatted commands in my text editor. Mircea On 25/04/2012 4:59 PM, Champ Lee wrote: Hello List, I am using the

[sqlite] Logging of sqlite3 commands

2012-04-25 Thread Champ Lee
Hello List, I am using the sqlite3 client on MS windows from a command prompt. I frequently issue a number of select commands while exploring data, and before I know it, have entered several dozen, fairly complex select commands. I would like to capture all of those commands into a file. Is

Re: [sqlite] sqlite3 column widths

2012-04-25 Thread Tim Streater
On 25 Apr 2012 at 17:36, Pete wrote: > So I guess that's a "No" then? > > I'm fully aware of how sqlite3 treats datatypes and column width > specifications, but surely if someone defines a column with a specific max > width, it's reasonable to assume that's the max width

Re: [sqlite] sqlite3 column widths

2012-04-25 Thread Pete
So I guess that's a "No" then? I'm fully aware of how sqlite3 treats datatypes and column width specifications, but surely if someone defines a column with a specific max width, it's reasonable to assume that's the max width they want, otherwise why bother defining it? That would seem to be a

Re: [sqlite] CSV to SQLite to web page display

2012-04-25 Thread Niall O'Reilly
On 24 Apr 2012, at 15:53, b2 wrote: > I have data that is exported to comma delimited format(CSV) daily / > weekly and want to be able to display on the web. If all you need to do is to transform some data from one text format (CSV) to another (HTML), I don't see why you would

Re: [sqlite] CSV to SQLite to web page display

2012-04-25 Thread Simon Slavin
On 24 Apr 2012, at 3:53pm, b2 wrote: > I have data that is exported to comma delimited format(CSV) daily / > weekly and want to be able to display on the web. > > Read only with no calculations but more readable date & price formats. > Number of records will be less

Re: [sqlite] Possible bug when rebuilding amalgamation without triggers or altertable

2012-04-25 Thread Stephan Beal
On Wed, Apr 25, 2012 at 7:09 AM, nn6eumtr wrote: > Steps to recreate: > http://www.sqlite.org/compile.html#omitfeatures says: *Important Note: The SQLITE_OMIT_* options do not work with the amalgamation or with pre-packaged C code

[sqlite] Possible bug when rebuilding amalgamation without triggers or altertable

2012-04-25 Thread nn6eumtr
Steps to recreate: 1) wget -nd -nH -c -t 0 -w 1 http://www.sqlite.org/src/tarball/SQLite-9fb7da6904e479f4.tar.gz?uuid=9fb7da6904e479f4671eeebf1a4b7e4e4e4f2b7b 2) mv -v SQLite-9fb7da6904e479f4.tar.gz?uuid=9fb7da6904e479f4671eeebf1a4b7e4e4e4f2b7b SQLite-9fb7da6904e479f4.tar.gz 3) tar -xzf

[sqlite] CSV to SQLite to web page display

2012-04-25 Thread b2
I have data that is exported to comma delimited format(CSV) daily / weekly and want to be able to display on the web. Read only with no calculations but more readable date & price formats. Number of records will be less than 100. MySQL is an overkill for this and I was hoping that SQLite might