Re: [sqlite] Single large table vs. several smaller tables

r particular data. But if you can > rationalize that these pieces of data are best written on a 3x5 note > card by itself, then create a table and join them. It's not all about > efficiency. > > just my opinion > > On Thu, Oct 9, 2014 at 11:03 AM, Drago, William @ MWG - NARDAEAST

Re: [sqlite] Single large table vs. several smaller tables

> > The question I have is, should I lump everything together in one > table just like the .csv file or should I create several smaller tables > that group similar parameters? I'm not sure what would normally be > done. I think the database is normalized properly in either case. > > For SQLite,

Re: [sqlite] Single large table vs. several smaller tables

qlite.org] On Behalf Of Clemens Ladisch > Sent: Thursday, October 09, 2014 10:46 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Single large table vs. several smaller tables > > Drago, William @ MWG - NARDAEAST wrote: > > An automatic test system that I designed generates

Re: [sqlite] Single large table vs. several smaller tables

gt; thought on why it is reasonable to split up such data, I'd be > interested to hear it too. > > Have a great day! > Ryan > > > On 2014/10/09 16:25, Drago, William @ MWG - NARDAEAST wrote: > > All, > > > > An automatic test system that I designed generates 25

[sqlite] Single large table vs. several smaller tables

All, An automatic test system that I designed generates 25 data elements for each unit tested. We test about 50 units/day. This data is currently being stored in a csv file. I'd like to move this over to an SQLite database. The question I have is, should I lump everything together in one table

Re: [sqlite] Reinstalling My Build Environment

That was an excellent response, Joe. I think Paul Bainter gave up way too quickly and his conclusion that System.Data.SQLite is unsupported is unwarranted, but I can understand if he felt alienated by comments like: "You may have found a library built on SQLite...Whatever you found isn't

Re: [sqlite] Reinstalling My Build Environment

> Please help me. At this point, I'm desperate for an installation where > I can copy the compiled files from the bin directory to a clean machine > and have it run. I use VS2013, but I don't use EF6, so this may not work for you, but maybe it will help in some way anyway. Based on what you

Re: [sqlite] Simple SQLite-based spreadsheet?

I use the personal edition of this: http://www.sqliteexpert.com/ And I use this as well because the built-in graph is handy: http://sqlitebrowser.org/ -- Bill Drago Senior Engineer L3 Communications / Narda Microwave East 435 Moreland Road Hauppauge, NY 11788 631-272-5947 /

[sqlite] CREATE INDEX Placement

All, Does it matter if I group all of my CREATE INDEX statements at the end of my .sql file or should they appear right after each CREATE TABLE statement? Does SQLITE care one way or another? Thanks, -- Bill Drago Senior Engineer L3 Communications / Narda Microwave

[sqlite] What NuGet package adds VS design-time components?

All, I'd like to generate a database diagram from an SQLite database. Is this possible with one of the packages that install the Visual Studio design-time components? If so which NuGet package is it? I'm going to guess it's EF6 (x86/x64) package, but I want to be sure before I do anything.

Re: [sqlite] SQL Join question

[sqlite] SQL Join question > > > On 28 Jul 2014, at 9:10pm, Drago, William @ MWG - NARDAEAST > <william.dr...@l-3com.com> wrote: > > > Can someone tell me what the purpose of line 2 is in the following > example? It seems redundant to me since what is wanted f

[sqlite] SQL Join question

All, Can someone tell me what the purpose of line 2 is in the following example? It seems redundant to me since what is wanted from the Customers table is specified on line 1. 1: SELECT Customers.CustomerName, Orders.OrderID 2: FROM Customers 3: INNER JOIN Orders 4: ON

Re: [sqlite] Preferred cast in C#

> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Simon Slavin > Sent: Tuesday, July 15, 2014 2:35 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Preferred cast in C# > > > On 15 Jul 2014, at

Re: [sqlite] capturing and testing a hot journal

This may be a bit simplistic, but it does give me a reasonable degree of confidence that hot journal files are being handled correctly in my application. I simply put a 1/0 on the line before my commit to purposely crash my app. Sure enough there's a journal file after the crash (I have a

Re: [sqlite] Basic SQLite/EF6 question

Steven Davisworth wrote: > Hi Joe > I've just upgraded PC to 64bit (new PC) and installed VS2013. I've > followed standard install instructions as outlined in web posts I've > come across for > EF6. Is there an official, or at least known good, set of instructions somewhere that we can use

Re: [sqlite] SQLite and BLOBs

Whether to use internal or external blobs is application dependant. In my test & measurement application testing 1 widget generates 140 small (1.2kB to 14kB) blobs. Multiply that by hundreds of widgets and you can see that storing and managing these as individual files would be a big headache

Re: [sqlite] Threads and System.Data.SQLite

gt; > > On 3 Jun 2014, at 11:05pm, Drago, William @ MWG - NARDAEAST > <william.dr...@l-3com.com> wrote: > > > "You May create multiple threads, and those threads can create their > own SQLiteConnection and subsequent objects for accessing a database. > Multiple c

[sqlite] Threads and System.Data.SQLite

All, In the Provider Limitations section of the SQLite.NET help file it says: "You May create multiple threads, and those threads can create their own SQLiteConnection and subsequent objects for accessing a database. Multiple connections on multiple threads to the same database file are

Re: [sqlite] New DLLs and sources. Was: SQLite version 3.8.5 beta

> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Warren Young > Sent: Wednesday, May 28, 2014 2:26 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] New DLLs and sources. Was: SQLite version 3.8.5 >

Re: [sqlite] DELETE & INSERT vs. REPLACE

E > > > On 27 May 2014, at 9:12pm, Drago, William @ MWG - NARDAEAST > <william.dr...@l-3com.com> wrote: > > > Let me rephrase the question by asking, how should I overwrite > existing data? For example, Jane has 5 guitars in her instrument table. > She trades her 5 gu

Re: [sqlite] DELETE & INSERT vs. REPLACE

gt; To: General Discussion of SQLite Database > Subject: Re: [sqlite] DELETE & INSERT vs. REPLACE > > > On May 27, 2014, at 8:11 PM, Drago, William @ MWG - NARDAEAST > <william.dr...@l-3com.com> wrote: > > > Is there any difference between using REPLACE as opposed to delet

Re: [sqlite] DELETE & INSERT vs. REPLACE

t; > On Tue, May 27, 2014 at 2:11 PM, Drago, William @ MWG - NARDAEAST < > william.dr...@l-3com.com> wrote: > > > All, > > > > Is there any difference between using REPLACE as opposed to deleting > > records and then inserting new ones to take their place? >

[sqlite] DELETE & INSERT vs. REPLACE

All, Is there any difference between using REPLACE as opposed to deleting records and then inserting new ones to take their place? Thanks, -- Bill Drago Senior Engineer L3 Communications / Narda Microwave East 435 Moreland Road Hauppauge, NY 11788 631-272-5947 /

[sqlite] My first hot journal, what do I do with it?

All, Well, it finally happened. I had a program crash and was left with a hot journal file. A while back there was a post by Richard Hipp detailing something that could/should be done before trying to use the database to assure that SQLite does the rollback. I can't find that post now. Any

Re: [sqlite] SQLite Datareader problems with Int?

I'm willing to bet that the problem is in your C# code. The variable receiving the INTEGER column is probably declared as an INT instead of LONG or ULONG. -Bill > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Werner

Re: [sqlite] duplicate row in sqlite3 database

ated to the point that you see here. I just have to assume that an error on INSERT is due to a duplicate row. There's nothing else I can do. > > > On 2014/05/09 19:52, Drago, William @ MWG - NARDAEAST wrote: > > When I deliberately try to insert a duplicate row I get the following

Re: [sqlite] duplicate row in sqlite3 database

s-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of RSmith > Sent: Friday, May 09, 2014 12:06 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] duplicate row in sqlite3 database > > > On 2014/05/09 17:58, Drago, William @ MWG - NARDAEAST wrote:

Re: [sqlite] duplicate row in sqlite3 database

> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Igor Tandetnik > Sent: Thursday, May 08, 2014 9:48 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] duplicate row in sqlite3 database > > On 5/8/2014 5:14 AM, techi

[sqlite] Could not open registry key

All, I tried running the installer in sqlite-netFx20-binary-bundle-Win32-2005-1.0.92.0.zip and received the following error: Installer.exe: #047 @ 2014.05.07T16:29:59.4744965: TraceOps.ShowMessage: could not open registry key:

Re: [sqlite] Is there a single file version of System.Data.SQLite?

e file version of > System.Data.SQLite? > > > Drago, William @ MWG - NARDAEAST wrote: > > > > Is there a way to use the "System.Data.SQLite.dll" mixed-mode > assembly > outside > > of the GAC? Or is there a 32 bit only single file version of SQLite? > >

[sqlite] Is there a single file version of System.Data.SQLite?

All, Is there a way to use the "System.Data.SQLite.dll" mixed-mode assembly outside of the GAC? Or is there a 32 bit only single file version of SQLite? I'm running a 32 bit, non-managed code interpreted language that can't find the SQLite.Interop.dll files if I start my program from a

Re: [sqlite] When to open/close connections

> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Yuriy Kaminskiy > Sent: Monday, April 28, 2014 8:36 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] When to open/close connections > > Simon Slavin wrote: > > On

[sqlite] Documentation typo

In section 2 of http://sqlite.org/foreignkeys.html the word "separately" appears twice in the following sentence: Foreign key constraints are disabled by default (for backwards compatibility), so must be enabled separately for each database connection separately. -- Bill Drago Senior Engineer

Re: [sqlite] foreign keys

More information about this here: http://sqlite.org/foreignkeys.html -Bill > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Dominique Devienne > Sent: Friday, April 25, 2014 4:31 AM > To: olivier Ménard; General

Re: [sqlite] BLOBs and NULLs

/23/2014 10:21 AM, Drago, William @ MWG - NARDAEAST wrote: > > If I was sure I wouldn't be merging data I might use timer ticks > as my ID, but I'm not sure and I can't take the chance. > > > > -Bill > > Would it be possible to use INTEGER PRIMARY KEY AUTOINCREMENT

Re: [sqlite] BLOBs and NULLs

The possibility of having to merge data from several independent test stations is what made me think of using GUID in the first place. I don't think there's a better way. As for wasted space, the few extra bytes needed by GUID is a drop in the bucket compared to the blobs I'm storing. If I was

Re: [sqlite] BLOBs and NULLs

...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of RSmith Sent: Tuesday, April 22, 2014 1:57 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] BLOBs and NULLs On 2014/04/22 19:12, Richard Hipp wrote: > On Tue, Apr 22, 2014 at 1:07 PM, Drago, William @ MWG - NARDAEAST < > w

Re: [sqlite] BLOBs and NULLs

and NULLs On Tue, Apr 22, 2014 at 12:55 PM, Drago, William @ MWG - NARDAEAST < william.dr...@l-3com.com> wrote: > Cool. So it's treating each 2 digit pair as a single byte hex value, > but what does blob do with the dashes? > Since the dashes carry no information, you could leave

Re: [sqlite] BLOBs and NULLs

To: General Discussion of SQLite Database Subject: Re: [sqlite] BLOBs and NULLs On Tue, Apr 22, 2014 at 5:35 PM, Drago, William @ MWG - NARDAEAST <william.dr...@l-3com.com> wrote: >>I myself prefer create table foo (guid blob primary key [NOT NULL], ...). > > If a genuine GUID looks l

Re: [sqlite] BLOBs and NULLs

org] On Behalf Of Dominique Devienne Sent: Tuesday, April 22, 2014 5:07 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] BLOBs and NULLs On Mon, Apr 21, 2014 at 4:58 PM, James K. Lowden <jklow...@schemamania.org> wrote: > On Mon, 21 Apr 2014 13:30:15 +0000 > "

Re: [sqlite] BLOBs and NULLs

ite.org] On Behalf Of James K. Lowden Sent: Monday, April 21, 2014 10:59 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] BLOBs and NULLs On Mon, 21 Apr 2014 13:30:15 + "Drago, William @ MWG - NARDAEAST" <william.dr...@l-3com.com> wrote: > Should I spl

[sqlite] BLOBs and NULLs

All, One of the tables in my database has 4 columns that will hold small (under 5K) BLOBs. In many cases there will be no data at all in one or more of these columns (see sample below). Does this present any kind of problem? Should I split this table up into smaller tables to eliminate the

[sqlite] What does Installer.exe do in the binary packages?

I just downloaded sqlite-netFx20-binary-Win32-2005-1.0.92.0.zip and in addition to the core SQLite .dll files there are a lot of other files including an installer. This is a binary package, not a setup or bundle package, so what does the installer do? I read the information on the download

Re: [sqlite] How to speed up a bulk import

I do 12.3 million inserts with a single commit in approx 1 minute using prepared statements and parameters in accordance with the "Getting the best performance out of SQLite" section of the SQLite.NET.chm help file, which is available here:

Re: [sqlite] System.Data.SQLite fails to load

ad Drago, William @ MWG - NARDAEAST wrote: > > I solved this problem by deploying the "System.Data.SQLite.dll" > mixed-mode assembly to > the GAC. I know this is not recommended, but it's the only thing that works. > It should be OK, the mixed-mode assembly is desig

Re: [sqlite] System.Data.SQLite fails to load

I solved this problem by deploying the "System.Data.SQLite.dll" mixed-mode assembly to the GAC. I know this is not recommended, but it's the only thing that works. My question now is, I used gacutil.exe instead of the installer that comes with SQLite. Was that a mistake? Should I have used the