[sqlite] Error help

[Daniel Telvock]

Understood, thanks.

Clearly, I am a neophyte at this stuff and have not learned how to use SQL
with the command line. I was taught the basics in SQLite with Firefox, and
am already disappointed that I can't really do what I want to do with the
Firefox plug in.

I guess I can try to learn Microsoft Access.

Dan Telvock
Environment Reporter
Investigative Post <http://www.investigativepost.org/>
Twitter: @dantelvock
716-831-2626 ext. 3


On Mon, Apr 4, 2016 at 2:27 PM, Simon Slavin  wrote:

>
> On 4 Apr 2016, at 7:22pm, Daniel Telvock 
> wrote:
>
> > Even when trained to use SQLite I was told it could handle large CSV
> files,
> > and this one was only 1000 rows
>
> SQLite handles it fine.  I have a 39 Gigabyte database using SQLite.
>
> The thing you're using is not SQLite.  It's a program which does a lot of
> things, using SQLite but also lots of code written by people who have
> nothing to do with SQLite.  The error you reported is not an SQLite error.
> The 'NS' at the beginning of the error name is a hang over from back when
> Mozilla was called 'NetScape'.
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] Error help

[Daniel Telvock]

Using the non plugin option is a little above my head. I haven't been
trained to use the command line.

Even when trained to use SQLite I was told it could handle large CSV files,
and this one was only 1000 rows

Dan Telvock
Environment Reporter
Investigative Post 
Twitter: @dantelvock
716-831-2626 ext. 3


On Mon, Apr 4, 2016 at 2:21 PM, Richard Hipp  wrote:

> On 4/4/16, Simon Slavin  wrote:
> >
> > On 4 Apr 2016, at 6:17pm, Richard Hipp  wrote:
> >
> >> It is.  Don't confuse SQLite with the Firefox plugin for SQLite.  The
> >> limit you have reached seems to be a limitation with the Firefox
> >> plugin, not with SQLite itself.
> >
> > I confirm that the NS_ERROR_STORAGE_CONSTRAINT error is generated by the
> > Mozilla codebase (i.e. Netscape).  If you would like to download the
> SQLite
> > shell tool and try the import using that, you'll probably have no trouble
> > importing your data.
> >
>
> And once you get the data imported, probably the Firefox plugin will
> work fine for querying and general maintenance.
>
> --
> D. Richard Hipp
> drh at sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] Error help

[Daniel Telvock]

Not sure of size. But I had thought one of benefits of using SQLite was
ability to import larger CSV files or worksheets that slow down in Excel



Dan Telvock
Environment Reporter
Investigative Post <http://www.investigativepost.org/>
Twitter: @dantelvock
716-831-2626 ext. 3


On Mon, Apr 4, 2016 at 12:52 PM, Stephen Chrzanowski 
wrote:

> Large CSV?  How large?  Because the constraint error is probably coming
> from the browser for an upload constraint on size versus SQLite throwing an
> error.
>
>
> On Mon, Apr 4, 2016 at 12:26 PM, Daniel Telvock <
> dtelvock at investigativepost.org> wrote:
>
> > I am using the Firefox plugin of SQLite and this is a large CSV file
> that I
> > am importing in the wizard. When I try to import, I get that error
> >
> > CHECK constraint failed: REDCs_refined ]
> > Exception Name: NS_ERROR_STORAGE_CONSTRAINT
> > Exception Message: Component returned failure code: 0x80630003
> > (NS_ERROR_STORAGE_CONSTRAINT) [mozIStorageStatement.execute]
> >
> > Dan Telvock
> > Environment Reporter
> > Investigative Post <http://www.investigativepost.org/>
> > Twitter: @dantelvock
> > 716-831-2626 ext. 3
> >
> >
> > On Mon, Apr 4, 2016 at 12:21 PM, Simon Slavin 
> > wrote:
> >
> > >
> > > On 4 Apr 2016, at 5:04pm, Daniel Telvock <
> dtelvock at investigativepost.org
> > >
> > > wrote:
> > >
> > > > When you have a columns that has lengthy text, is there a way to
> label
> > it
> > > > so SQLite won't spit it out as an error?
> > >
> > > There is no problem with storing lengthy text in a SQLite field.  It
> > makes
> > > no difference how you label the column since everything gets converted
> to
> > > TEXT anyway.  Whatever your problem is it's not related to labelling.
> > >
> > > Please state your platform and development environment.
> > >
> > > Simon.
> > > ___
> > > sqlite-users mailing list
> > > sqlite-users at mailinglists.sqlite.org
> > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> > >
> > ___
> > sqlite-users mailing list
> > sqlite-users at mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] Error help

[Daniel Telvock]

I am using the Firefox plugin of SQLite and this is a large CSV file that I
am importing in the wizard. When I try to import, I get that error

CHECK constraint failed: REDCs_refined ]
Exception Name: NS_ERROR_STORAGE_CONSTRAINT
Exception Message: Component returned failure code: 0x80630003
(NS_ERROR_STORAGE_CONSTRAINT) [mozIStorageStatement.execute]

Dan Telvock
Environment Reporter
Investigative Post <http://www.investigativepost.org/>
Twitter: @dantelvock
716-831-2626 ext. 3


On Mon, Apr 4, 2016 at 12:21 PM, Simon Slavin  wrote:

>
> On 4 Apr 2016, at 5:04pm, Daniel Telvock 
> wrote:
>
> > When you have a columns that has lengthy text, is there a way to label it
> > so SQLite won't spit it out as an error?
>
> There is no problem with storing lengthy text in a SQLite field.  It makes
> no difference how you label the column since everything gets converted to
> TEXT anyway.  Whatever your problem is it's not related to labelling.
>
> Please state your platform and development environment.
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] Error help

[Daniel Telvock]

There is a field that contains longer sentences for descriptions. It keeps
giving me an error that the NS Error Storage Constraint.

I've tried labeling the column as VarCHar and Text to not avail.


When you have a columns that has lengthy text, is there a way to label it
so SQLite won't spit it out as an error?

 CHECK constraint failed: REDCs_refined ]
Exception Name: NS_ERROR_STORAGE_CONSTRAINT
Exception Message: Component returned failure code: 0x80630003
(NS_ERROR_STORAGE_CONSTRAINT) [mozIStorageStatement.execute]


Dan Telvock
Environment Reporter
Investigative Post 
Twitter: @dantelvock
716-831-2626 ext. 3

[sqlite] Error msg help

[Daniel Telvock]

Anyone know what this is trying to tell me? I cannot import the CSV because
of this error.

Everything is labeled as VARCHAR and api_well_number is marked as the
unique identifier.



SQLiteManager: INSERT INTO "main"."WELLS" VALUES ("Adams, E.H. et
al",'Schuyler','Hector','3.11E+13','Collins 1','UM','Unknown Not
Found','DW','Dry Wildcat','8') [ UNIQUE constraint failed:
WELLS.api_well_number ]
Exception Name: NS_ERROR_STORAGE_CONSTRAINT
Exception Message: Component returned failure code: 0x80630003
(NS_ERROR_STORAGE_CONSTRAINT) [mozIStorageStatement.execute]



Dan Telvock
Environment Reporter
Investigative Post 
Twitter: @dantelvock
716-831-2626 ext. 3

[sqlite] SQLite Pronunciation

[Daniel Telvock]

I was at the Investigative Reporters and Editors Conference last week and
the presenter for SQLite courses 1 and 3 said that it is actually
pronounced SQ Lite. Even he thought that was odd considering SQL is a term
or acronym.



Dan Telvock
Environment Reporter
Investigative Post 
Twitter: @dantelvock
716-831-2626 ext. 3


On Wed, Mar 16, 2016 at 3:21 PM, Marc L. Allen 
wrote:

> I don't think anyone's making a fuss.  I certainly wasn't and apologize if
> it appeared differently.
>
> -Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:
> sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Stephen
> Chrzanowski
> Sent: Wednesday, March 16, 2016 3:09 PM
> To: SQLite mailing list 
> Subject: Re: [sqlite] SQLite Pronunciation
>
> Standards, official, or not, I've always pronounced it as Sequel.
> Ehm-Ess-Sequel, My-Sequel, Sequel-Lite, etc.
>
> IMO, S-Q-L is an acronym, as everyone knows, and since RADAR(1) is also an
> Acronym, why the fuss?  To me, it falls off the tongue easier to say Sequel
> instead of Ess-Queue-Ell.
>
> 1- http://acronyms.thefreedictionary.com/RADAR
>
>
>
> On Wed, Mar 16, 2016 at 2:55 PM, Marc L. Allen <
> mlallen at outsitenetworks.com>
> wrote:
>
> > That sounds like someone that comes from the land of Sequel. ;)
> >
> > I realize there *is* an official pronunciation, but I will probably
> > forever pronounce it as S-Q-L-light, regardless of what it really is.
> > :)
> >
> > -Original Message-
> > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:
> > sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of J Decker
> > Sent: Wednesday, March 16, 2016 2:48 PM
> > To: SQLite mailing list 
> > Subject: Re: [sqlite] SQLite Pronunciation
> >
> > more like sequel-ite
> >
> > On Wed, Mar 16, 2016 at 11:38 AM,  
> wrote:
> > > Hello,
> > >
> > > Please grant me some leeway here since as someone who has not been
> > > in an academic school for years and is mainly self taught. I have
> > > Mainly deriving information from reading manuals and occasionally
> > > viewing some videos.
> > >
> > > Maybe I'm wrong, but according to Wikepedia SQLite appears to be
> > > pronounced the same has it is spelled,
> > > (sikwl.lat).
> > > Maybe not a long A there perhaps.
> > >
> > > Where as I first heard Microsoft's MSSQL pronounce (sequent), which
> > > I have also heard in academic videos by professors.
> > > Following that logic, SQLite, (sequent.light)?
> > >
> > > Dana Proctor
> > >
> > > ___
> > > sqlite-users mailing list
> > > sqlite-users at mailinglists.sqlite.org
> > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> > ___
> > sqlite-users mailing list
> > sqlite-users at mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> >
> > This email and any attachments are only for use by the intended
> > recipient(s) and may contain legally privileged, confidential,
> > proprietary or otherwise private information. Any unauthorized use,
> > reproduction, dissemination, distribution or other disclosure of the
> > contents of this e-mail or its attachments is strictly prohibited. If
> > you have received this email in error, please notify the sender
> > immediately and delete the original.
> > ___
> > sqlite-users mailing list
> > sqlite-users at mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>
> This email and any attachments are only for use by the intended
> recipient(s) and may contain legally privileged, confidential, proprietary
> or otherwise private information. Any unauthorized use, reproduction,
> dissemination, distribution or other disclosure of the contents of this
> e-mail or its attachments is strictly prohibited. If you have received this
> email in error, please notify the sender immediately and delete the
> original.
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>