Re: [sqlite] SQLite in VS2015 Server Explorer (Bugs)

[Stephan Beal]

On Tue, Aug 23, 2016 at 4:13 PM, Tyler Merle  wrote:

> I believe I’ve uncovered two bugs when using VS2015’s Server Explorer to
> design a SQLite schema.
>
> 1. When adding more than one relationship to a table, the first
> relationship’s “to” table name is used for all new relationships
> 2. The right-click -> design option for tables doesn’t open the table
> design on the first try. Takes two right-click -> design selections to open
> the designer
>

Wrong mailing list. This is the list for the sqlite library and its shell
program (neither of which include a schema design tool). Server Explorer is
a 3rd-party product.

-- 
- stephan beal
http://wanderinghorse.net/home/stephan/
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite in VS2015 Server Explorer (Bugs)

[Drago, William @ CSG - NARDA-MITEQ]

> -Original Message-
> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
> Behalf Of Stephan Beal
> Sent: Wednesday, August 24, 2016 6:37 AM
> To: SQLite mailing list 
> Subject: Re: [sqlite] SQLite in VS2015 Server Explorer (Bugs)
>
> On Tue, Aug 23, 2016 at 4:13 PM, Tyler Merle  wrote:
>
> > I believe I’ve uncovered two bugs when using VS2015’s Server Explorer
> > to design a SQLite schema.
> >
> > 1. When adding more than one relationship to a table, the first
> > relationship’s “to” table name is used for all new relationships 2.
> > The right-click -> design option for tables doesn’t open the table
> > design on the first try. Takes two right-click -> design selections to
> > open the designer
> >
>
> Wrong mailing list. This is the list for the sqlite library and its shell 
> program
> (neither of which include a schema design tool). Server Explorer is a 
> 3rd-party
> product.

This is also the list for System.Data.SQLite. System.Data.SQLite supports 
design time components for VS2015, so this may be the correct list for 
questions regarding issues with using SQLite and Visual Studio's server 
explorer.

--
Bill Drago
Staff Engineer
L3 Narda-MITEQ
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 / william.dr...@l-3com.com
CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any 
attachments are solely for the use of the addressee and may contain information 
that is privileged or confidential. Any disclosure, use or distribution of the 
information contained herein is prohibited. In the event this e-mail contains 
technical data within the definition of the International Traffic in Arms 
Regulations or Export Administration Regulations, it is subject to the export 
control laws of the U.S.Government. The recipient should check this e-mail and 
any attachments for the presence of viruses as L-3 does not accept any 
liability associated with the transmission of this e-mail. If you have received 
this communication in error, please notify the sender by reply e-mail and 
immediately delete this message and any attachments.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite in VS2015 Server Explorer (Bugs)

[Tyler Merle]

I believe I’ve uncovered two bugs when using VS2015’s Server Explorer to design 
a SQLite schema. 

1. When adding more than one relationship to a table, the first relationship’s 
“to” table name is used for all new relationships
2. The right-click -> design option for tables doesn’t open the table design on 
the first try. Takes two right-click -> design selections to open the designer
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite in VS2015 Server Explorer (Bugs)

[Simon Slavin]

On 24 Aug 2016, at 12:33pm, Drago, William @ CSG - NARDA-MITEQ 
 wrote:

> This is also the list for System.Data.SQLite. System.Data.SQLite supports 
> design time components for VS2015, so this may be the correct list for 
> questions regarding issues with using SQLite and Visual Studio's server 
> explorer.

Sort-of agreed, but the bugs here are definitely not bugs in 
System.Data.SQLite, which can do both of those underlying tasks without error.  
So the bugs must be elsewhere.

Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] importing csv

[Simon Slavin]

On 24 Aug 2016, at 11:04pm, Alan  wrote:

> Firstly I am very new to sqlite, but I have a problem when trying to
> 
> import a .csv file into a database, getting  "cannot open (file).csv"
> 
> I am using Windows10 and wondering if anyone else has had this problem.

The program is probably looking at the wrong folder/directory.  Make sure you 
understand where the program thinks the file is.

What program are you using to open the file ?

Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SpeedTest1 Comparison of 32 vs 64 bit on Windows 10 13483.15

[Warren Young]

On Aug 17, 2016, at 10:38 PM, Keith Medcalf  wrote:
> 
> Same code, same compile options, same compiler version
> options -s -O3 -pipe -march=native -mtune=native -falign-functions=16 
> -falign-loops=16 -flto

Ah, good, actual science this time instead of apples-to-oranges. :)

Thank you for doing this and posting the results.

Even better, thank you for using a test program that comes with SQLite, so we 
can get numbers we can compare.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] importing csv

[Alan]

Firstly I am very new to sqlite, but I have a problem when trying to

import a .csv file into a database, getting  "cannot open (file).csv"

I am using Windows10 and wondering if anyone else has had this problem.

A friend has been able to import exactly the same csv file  but he is 
using windows7.


I would appreciate any help on this.

Alan Hughes

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] importing csv

[Simon Slavin]

I hope someone else can help.

Does that table already exist in the database file ?

Is the first line of the csv file a line of data or a line of column names ?

Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] importing csv

[Alan]

Hi Simon,

firstly both the database and the csv files are in ther same folder.

I have gone into Windows cmd

typed   sqlite3 DXCC(database)

.mode csv

.separator ,

.import anr.csv DXE(DXCC table)

I have also tried putting in the full path to the csv file and 
unfortunately


the same result.


Alan


On 25-Aug-16 10:12, Simon Slavin wrote:

On 24 Aug 2016, at 11:04pm, Alan  wrote:


Firstly I am very new to sqlite, but I have a problem when trying to

import a .csv file into a database, getting  "cannot open (file).csv"

I am using Windows10 and wondering if anyone else has had this problem.

The program is probably looking at the wrong folder/directory.  Make sure you 
understand where the program thinks the file is.

What program are you using to open the file ?

Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] importing csv

[Brian Curley]

Windows requires that you escape the \ in the path, effectively doubling
them up.

Regards.

Brian P Curley


On Aug 24, 2016 8:24 PM, "Simon Slavin"  wrote:

> I hope someone else can help.
>
> Does that table already exist in the database file ?
>
> Is the first line of the csv file a line of data or a line of column names
> ?
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] importing csv

[Michael Falconer]

Alan,

if you are new to sqlite3 then let me give you a little heads up on
something that tripped me up a couple of times in early days. I am assuming
you are the command line sqlite3 interface which will require you to set
the separator for data imports.

.separator ,

...is likely what you want if your data came from Excel or the like. The
default '|' is probably not what you will want. After that

.import 'datafile' 'table' should have a fighting chance given a good match
between column types and data fields.


On 25 August 2016 at 10:26, Brian Curley  wrote:

> Windows requires that you escape the \ in the path, effectively doubling
> them up.
>
> Regards.
>
> Brian P Curley
>
>
> On Aug 24, 2016 8:24 PM, "Simon Slavin"  wrote:
>
> > I hope someone else can help.
> >
> > Does that table already exist in the database file ?
> >
> > Is the first line of the csv file a line of data or a line of column
> names
> > ?
> >
> > Simon.
> > ___
> > sqlite-users mailing list
> > sqlite-users@mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Regards,
 Michael.j.Falconer.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite importing csv

[Alan]

HI Guys
really appreciate all your replies.What I am doing at present is to 
attempt to import a short test Excel table
of two columns with about 4 records in it, the main one I was trying to 
import had the same trouble

with, it had over 300 records in it with two columns.
the test one has headers on both columns plus 4 lots of data, and I have 
tried importing it into an existing(empty) table called DXE and then 
also into a table not existing to see if it would add it.

I have saved it under Excel csv comma delimited
and the suffix of the file definitely says .csv when looking at the 
folder with  windows file explorer.
It is all part of a learning curve for me as I am trying to learn how to 
write small programs
with windows forms and feeding data into about 22 different databases, 
this particular one
I am going to try and use as a look up of information to be used 
elsewhere in other databases,

(hope I am making sense) I am not a computer guru but trying to learn (LOL).

Alan
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite importing csv

[Scott Robison]

On Aug 24, 2016 10:25 PM, "Alan"  wrote:
>
> forgot to reply to one of the questions.
>
> I am using version 3.13.0.0 and it is 64 bit
>
> I am running Windows 10 Pro
>
> computer is intel I3  3.5Ghz with 8Gb RAM.
>
> As my friend has no problem loading the same csv file with his Windows7
computer
>
> I am guessing that it may be to do with running Windows 10.

What directory are you in? Are you using an elevated command prompt?
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite importing csv

[Alan]

forgot to reply to one of the questions.

I am using version 3.13.0.0 and it is 64 bit

I am running Windows 10 Pro

computer is intel I3  3.5Ghz with 8Gb RAM.

As my friend has no problem loading the same csv file with his Windows7 
computer


I am guessing that it may be to do with running Windows 10.


Alan


___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite importing csv

[Alan]

I have created a directory for the project I am working on, and the 
Database and the csv file both reside in that directory.


I right Clicked on start and selected the windows  cmd, and as I 
understand it at the moment


by typing sqlite3 DXCC then it should be sitting in the directory or 
folder that the DXCC  database is in


so should accept the sqlite command to import the csv file that is also 
sitting in that directory.


I also tried it with the Admin cmd.


On 25-Aug-16 16:38, Scott Robison wrote:

On Aug 24, 2016 10:25 PM, "Alan"  wrote:

forgot to reply to one of the questions.

I am using version 3.13.0.0 and it is 64 bit

I am running Windows 10 Pro

computer is intel I3  3.5Ghz with 8Gb RAM.

As my friend has no problem loading the same csv file with his Windows7

computer

I am guessing that it may be to do with running Windows 10.

What directory are you in? Are you using an elevated command prompt?
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite importing csv

[Simon Slavin]

On 25 Aug 2016, at 4:03am, Alan  wrote:

> attempt to import a short test Excel table
> of two columns with about 4 records in it, the main one I was trying to 
> import had the same trouble
> with, it had over 300 records in it with two columns.


Issue this command:

sqlite3 DXCC.sqlite

then inside the SQLite shell tool do the following:

CREATE TABLE testTable (testColumn TEXT);
.once testoutput.txt
.schema
.quit

Do you find a new file called 'testoutput.txt' in the same folder as your 
anr.csv file ?


Assuming that you /do/ get the file you expected ...

Open anr.csv using NOTEPAD.

Does the file look like comma-separated values to you ?

Is the top line a line of data (probably numbers) or does it have column names ?

You're importing the data in that file into a table.

Have you already defined the table in your SQLite database before you issue the 
.import command or are you expecting SQLite to create the table for you ?

Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SpeedTest1 Comparison of 32 vs 64 bit on Windows 10 13483.15

[J Decker]

CPU Core at 100% for entire test, x64 code is ~10% faster than x32 code.

So; IO bound things 32/64 doesn't matter so much; but compute bound,
through data already in memory gets significant improvments because of
addtional general purpose registers and optimal calling conventions for
things of fewer than 4 parameters. yields a better usage of your CPU?

and at 10% I said I'd be surprised if more than 5%; but potentially more if
I have a thing that fits in cache and I scan a lot?

subquery in a select was slower oddly enough... which was mentioned already
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite in VS2015 Server Explorer (Bugs)

[Scott Robison]

On Aug 24, 2016 5:35 AM, "Simon Slavin"  wrote:
>
>
> On 24 Aug 2016, at 12:33pm, Drago, William @ CSG - NARDA-MITEQ
 wrote:
>
> > This is also the list for System.Data.SQLite. System.Data.SQLite
supports design time components for VS2015, so this may be the correct list
for questions regarding issues with using SQLite and Visual Studio's server
explorer.
>
> Sort-of agreed, but the bugs here are definitely not bugs in
System.Data.SQLite, which can do both of those underlying tasks without
error.  So the bugs must be elsewhere.

That seems reasonable at first blush, but I don't know what level of
cooperation is required from System.Data.SQLite to accommodate this
functionality. You could be right, but given past similar emails, I doubt
either of us is.

I'm sure the responsible party will see this and reply shortly with
something definitive.

>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite in VS2015 Server Explorer (Bugs)

[Joe Mistachkin]

Scott Robison wrote:
>
> I'm sure the responsible party will see this and reply shortly with
> something definitive. 
>

This is the right place and the System.Data.SQLite design-time components
are supported here.

That being said, the design-time components for System.Data.SQLite are
supported on a "best effort" basis, mostly because:

1. They were never fully completed.

2. The Visual Studio extensibility interfaces they use are very
   fragile and scarcely documented.

3. Debugging them is nefariously difficult.

--
Joe Mistachkin @ https://urn.to/r/mistachkin

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] bug in sqlite when

[Sergey Shamshyn]

Hi.
I have a big trouble using SQLite: got an error SQLITE_CORRUPT (11), I 
think this is a 100% SQLite bug, because:

- only ONE THREAD of my process is writing periodically to db file
- onlt ONE ANOTHER THREAD of my another process reads from this db file
- version 3.14.1
- PRAGMA synchronous=OFF
- *PRAGMA journal_mode=OFF* (when not execute this pragma, all is ok).
Looks like bug in PRAGMA journal_mode=OFF, because *only one thread is 
writing to DB*!

- No power crashes, or chkdsk errors on this HDD.
- In attachment example of corrupted DB



___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] bug in sqlite when

[Igor Korot]

Hi, Sergey,

On Wed, Aug 24, 2016 at 8:55 AM, Sergey Shamshyn
 wrote:
> Hi.
> I have a big trouble using SQLite: got an error SQLITE_CORRUPT (11), I think
> this is a 100% SQLite bug, because:
> - only ONE THREAD of my process is writing periodically to db file
> - onlt ONE ANOTHER THREAD of my another process reads from this db file
> - version 3.14.1
> - PRAGMA synchronous=OFF
> - *PRAGMA journal_mode=OFF* (when not execute this pragma, all is ok).
> Looks like bug in PRAGMA journal_mode=OFF, because *only one thread is
> writing to DB*!
> - No power crashes, or chkdsk errors on this HDD.
> - In attachment example of corrupted DB

This list does not accept attachments.
Can you put the DB somewhere on the file sharing service and put the link here?

Thank you.

>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] bug in sqlite when

[Richard Hipp]

On 8/24/16, Sergey Shamshyn  wrote:
> - *PRAGMA journal_mode=OFF* (when not execute this pragma, all is ok).

With journal_mode=OFF, the database may go corrupt if:

(1) The program is ever terminated (ex: using SIGKILL) while the
database is open.
(2) If a COMMIT statement ever fails due to an I/O or out-of-memory error.
(3) Failure of a constraint during an UPDATE (depending on the schema).
(4) Calling sqlite3_close() while a transaction is active.

In other words, without a journal, there are many ways to corrupt the
database file that do not involve power failures or I/O errors.
-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Final preparations for the release of System.Data.SQLite v1.0.103.0 have begun...

[Joe Mistachkin]

If you have any issues with the current code, please report them via this
mailing
list (and/or by creating a ticket on "https://system.data.sqlite.org/;)
prior to
Monday, August 29th.

Thanks.

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users