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

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

> -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

[sqlite] SQLite in VS2015 Server Explorer (Bugs)

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

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

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

Re: [sqlite] importing csv

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

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

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.

[sqlite] importing csv

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

Re: [sqlite] importing csv

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

Re: [sqlite] importing csv

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.

Re: [sqlite] importing csv

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

Re: [sqlite] importing csv

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

Re: [sqlite] sqlite importing csv

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

Re: [sqlite] sqlite importing csv

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

Re: [sqlite] sqlite importing csv

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

Re: [sqlite] sqlite importing csv

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

Re: [sqlite] sqlite importing csv

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

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

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

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

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

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

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

[sqlite] bug in sqlite when

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

Re: [sqlite] bug in sqlite when

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

Re: [sqlite] bug in sqlite when

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

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

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