[sqlite] catastrophic installation on Ubuntu 11.10

Hello, I have to tell that I didn't knew SQLite at all when I started this! On an Ubuntu 11.10, I have installed: command line interface for SQLite Navigateur de bases de données SQLite Sqliteman Afterwards, I have downloaded the last version from your website and install it with make install.

Re: [sqlite] SQLite/LINQ?

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 wrote

Re: [sqlite] SQLite/LINQ?

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 use > > SQLite/LINQ/C# - pr

Re: [sqlite] Logging of sqlite3 commands

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 select > commands. I wou

[sqlite] SQLite/LINQ?

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 works

Re: [sqlite] Logging of sqlite3 commands

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 sq

[sqlite] Logging of sqlite3 commands

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 there

Re: [sqlite] sqlite3 column widths

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 they want, otherwise > w

Re: [sqlite] sqlite3 column widths

I'd imagine you could just off-load your needs to your application and parse the DDL itself. Use PRAGMA table_info() and parse out the column lengths from there...assuming you're consistently adding this info... On Wed, Apr 25, 2012 at 12:36 PM, Pete wrote: > So I guess that's a "No" then? > >

Re: [sqlite] sqlite3 column widths

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 lot

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

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 ne

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

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 than 100. > > MySQL is an o

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

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 files. SQLITE_OMIT_* c

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

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 SQLit

[sqlite] CSV to SQLite to web page display

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 do