Re: [sqlite] Resources for learning SQLite

> -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Mike Clark > Sent: Thursday, March 29, 2018 1:07 PM > To: sqlite-users@mailinglists.sqlite.org > Subject: [EXT] [sqlite] Resources for learning SQLite > > I suspect there are

Re: [sqlite] String Too Long

> My guess is that it's a limitation of SQLiteCommand a.k.a > Microsoft.Data.Sqlite . You might want to ask about the problem in a forum > on C#, .NET or Microsoft.Data.* . Or try System.Data.SQLite instead of the Microsoft version. You can download it directly or use NuGet. -- Bill Drago

Re: [sqlite] Clarification on Storage

> What I'm interested in finding out, without changing my code at this time, is > if > SQLITE3.EXE is handling things differently than what SQLite Expert is. It absolutely is. I am a heavy user of SQLite Expert and was stumped by weird problems in my databases until I realized the SQLite Expert

Re: [sqlite] Microsoft.Data.SQLite was Vetting SQLite

> Microsoft's own .NET library is Microsoft.Data.SQLite but not all of > Microsoft's > own tools use it since it is part of a long dependency chain which makes > compiled apps rather large. > > Simon. > That's very interesting, thanks. I couldn't find out much about it, though. I can't even

Re: [sqlite] Vetting SQLite

To all that replied, thank you. Open source, not open contribution is a plus, so is the wide deployment and well known users (Airbus). There were many other good ideas mentioned like examining the source for network calls, etc. All of this will help me build a case in favor of SQLite. No one

[sqlite] Vetting SQLite

All, I've been using/loving SQLite for years, but the use of open source software is highly discouraged where I work, and now I have to prove to our IT dept. that SQLite is reliable and secure. The reliable part is easy because there is enough information on the SQLite website about testing,

Re: [sqlite] Many ML emails going to GMail's SPAM

> -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Keith Medcalf > Sent: Wednesday, November 22, 2017 11:33 AM > To: SQLite mailing list > Subject: Re: [sqlite] Many ML emails going to

Re: [sqlite] Many ML emails going to GMail's SPAM

> There is nothing wrong with email - but there is an awful lot wrong with gnail > and Google's ideas on how email is done. (Not to mention Yahoo, but it > seems that MS have the sense to leave the underpinnings of hotmail as they > were.) > > To put it simply - friends don't let friends use

Re: [sqlite] Many ML emails going to GMail's SPAM

> I really need to come up with an alternative to the mailing list. > Perhaps some kind of forum system. Suggestions are welcomed. > -- > D. Richard Hipp > d...@sqlite.org Please, not a forum. The email list is instant, dynamic, and convenient. I don't think checking into a forum to stay

Re: [sqlite] Best way to develop a GUI front-end

> > This will work with any .NET/Visual Studio language (C#/F#/VB): > > Not sure this will work with VBA though. > VB .NET is very different from VBA (or VB6), so that won't be that easy, > unless I am missing something. > > RBS It's not that hard to go from VBA to VB .NET. The part I failed to

Re: [sqlite] Best way to develop a GUI front-end

> -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Bart Smissaert > Sent: Monday, November 13, 2017 6:52 PM > To: SQLite mailing list > Subject: Re: [sqlite] Best way to develop a GUI

[sqlite] Doc typos

The word hold should be holds in the first sentence of section 3. The Rollback Journal. In the 3rd sentence give should be given: http://sqlite.org/fileformat.html -- Bill Drago Staff Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 /

Re: [sqlite] Could not load file or assembly error

> -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Paul J. McMillan, Sr. > Sent: Thursday, June 22, 2017 1:51 PM > To: sqlite-users@mailinglists.sqlite.org > Subject: [sqlite] Could not load file or assembly error > > Hi, > > > >

Re: [sqlite] .DUMP displays floats differently from SELECT

> -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Simon Slavin > Sent: Wednesday, May 03, 2017 12:30 PM > To: SQLite mailing list > Subject: Re: [sqlite] .DUMP displays floats differently

Re: [sqlite] System.data.SQLite documentation

> -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Mickey Feldman > Sent: Thursday, February 23, 2017 7:46 AM > To: sqlite-users@mailinglists.sqlite.org > Subject: [sqlite] System.data.SQLite documentation > > I am not able to

Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

> -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Bart Smissaert > Sent: Tuesday, February 14, 2017 4:24 PM > To: SQLite mailing list > Subject: Re: [sqlite] Problem compiling 3.17.0 in MSVS

Re: [sqlite] SQLite3 Pros / Cons

> -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Clyde Eisenbeis > Sent: Saturday, February 04, 2017 2:58 PM > To: SQLite mailing list > Subject: [sqlite] SQLite3 Pros / Cons > > I'm new to

Re: [sqlite] Need help with System.Data.SQLite

> -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Burtsev, Dmitriy > Sent: Monday, January 09, 2017 10:10 AM > To: 'SQLite mailing list' > Subject: [sqlite] Need help with System.Data.SQLite

Re: [sqlite] problem with sqlite 4

> The current version of SQLite Expert Personal is 4.2.0, available here: > > http://www.sqliteexpert.com/download.html > > They don’t appear to give any clues as to which version of SQLite the > application is using. The SQLite version is displayed just below the ribbon on the right hand side of

Re: [sqlite] Anybody know why mono SQLite uses SqliteConnection but Windows uses SQLiteConnection?

> -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Jim Henderson > Sent: Saturday, November 19, 2016 12:16 AM > To: SQLite mailing list > Subject: Re: [sqlite] Anybody know why mono SQLite

Re: [sqlite] Anybody know why mono SQLite uses SqliteConnection but Windows uses SQLiteConnection?

> > Do any of you know why the two different versions of SQLite have different > case in the method names? > > Thanks, > Jim > Is there a reason why you can't use this one which should have the correct case?

Re: [sqlite] Wish List for 2016: High Level API for Object Oriented Interactive Languages

I skimmed through this entire thread and didn't see any mention of System.Data.SQLite which is the ADO.NET provider for SQLite and written/maintained by the authors of SQLite. http://system.data.sqlite.org/ Perhaps I missed it or perhaps it's not really what you are looking for. I thought I

Re: [sqlite] sqlite importing csv

After opening your command prompt type: cd C:\jt65logger Then start SQLite and try importing your csv file. I see JT65 and DXCC, so I know this is ham related. Contact me directly if you'd like to discuss the ham aspects of your project. -- Bill Drago - W2KWD Staff Engineer L3 Narda-MITEQ 435

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

Re: [sqlite] Bad db feature request

> boun...@mailinglists.sqlite.org] On Behalf Of Dominique Devienne > Sent: Wednesday, June 29, 2016 10:52 AM > To: SQLite mailing list > Subject: Re: [sqlite] Bad db feature request > > On Wed, Jun 29, 2016 at 4:28 PM, Simon Slavin > wrote: > > I wish for the day SQLite has

Re: [sqlite] How to use "cursors" in c#

> -Original Message- > From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users- > boun...@mailinglists.sqlite.org] On Behalf Of R Smith > > As an aside - I've always prescribed generating your own ID's. There is no > requirement for using AUTOINCREMENT in any DB - It's a

Re: [sqlite] How to use "cursors" in c#

> -Original Message- > From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users- > boun...@mailinglists.sqlite.org] On Behalf Of R Smith > Sent: Tuesday, June 28, 2016 7:33 AM > To: sqlite-users@mailinglists.sqlite.org > Subject: Re: [sqlite] How to use "cursors" in c# > > >

Re: [sqlite] Correct, best, or generally accepted database structure for groups of things

> -Original Message- > From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users- > boun...@mailinglists.sqlite.org] On Behalf Of John McKown > Sent: Friday, June 17, 2016 9:35 AM > To: SQLite mailing list > Subject: Re: [sqlite] Correct, best, or generally accepted database

Re: [sqlite] Correct, best, or generally accepted database structure for groups of things

> -Original Message- > From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users- > boun...@mailinglists.sqlite.org] On Behalf Of Chris Locke > Sent: Friday, June 17, 2016 2:37 AM > To: SQLite mailing list > Subject: Re: [sqlite] Correct, best, or generally accepted database

[sqlite] Correct, best, or generally accepted database structure for groups of things

All, Say I had a table of apples: CREATE TABLE Apples ( ID INTEGER PRIMARY KEY, Color TEXT COLLATE NOCASE, --Could be Red, Green, or Yellow Height REAL, --Measured in cm Width REAL --Measured in cm Weight REAL --Measured in grams ); And say I had a function that looks at the Apples table and

Re: [sqlite] Trouble coding conditional UNIQUE

te] Trouble coding conditional UNIQUE > > On Tue, 14 Jun 2016 16:27:29 +0000 > "Drago, William @ CSG - NARDA-MITEQ" <william.dr...@l-3com.com> > wrote: > > > Once the part has been grouped into a set (Matched=1) it receives a > > unique permanent serial number

Re: [sqlite] Trouble coding conditional UNIQUE

te] Trouble coding conditional UNIQUE > > On Mon, 13 Jun 2016 19:11:29 +0000 > "Drago, William @ CSG - NARDA-MITEQ" <william.dr...@l-3com.com> > wrote: > > > I need UNIQUE(B, C) only when E=0. > > A conditional constraint is evidence that you have tw

Re: [sqlite] Trouble coding conditional UNIQUE

13 9:16 PM, R Smith wrote: > > > > > > On 2016/06/13 9:11 PM, Drago, William @ CSG - NARDA-MITEQ wrote: > >> All, > >> > >> I am having trouble figuring out how to implement a conditional > >> UNIQUE constraint. > >> > >> Assum

[sqlite] Trouble coding conditional UNIQUE

All, I am having trouble figuring out how to implement a conditional UNIQUE constraint. Assume the following table: CREATE TABLE myTable ( A INTEGER PRIMARY KEY, B TEXT NOT NULL COLLATE NOCASE, C TEXT NOT NULL COLLATE NOCASE, D TEXT NOT NULL COLLATE NOCASE, E INTEGER, F TEXT COLLATE NOCASE, G

[sqlite] (Solved) How to get 1 row with no null columns

To all who replied, thanks for all the help. Naming the columns in not a problem. It's easy enough to get the column names and build the appropriate select statement. Thanks again, -- Bill Drago Staff Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at

[sqlite] Fastest way to backup/copy database?

Rob, I have a continuously running application that simply writes the same data to two different databases; one in the primary location and the other in the backup location. This is obviously not a perfect solution (a man with two watches never really knows what time it is) but it's good

[sqlite] How to register System.Data.SQLite as a data source?

> Drago, William wrote: > > > > I always reference System.Data.SQLite directly and have no idea how to > > register it as a data source and what the implications of doing so are > > (will it break applications that reference the .NET assy directly)? > > Can anyone advise? > > > > A data source for

[sqlite] How to register System.Data.SQLite as a data source?

All, I always reference System.Data.SQLite directly and have no idea how to register it as a data source and what the implications of doing so are (will it break applications that reference the .NET assy directly)? Can anyone advise? Thanks, -- Bill Drago Staff Engineer L3 Narda-MITEQ 435

[sqlite] CTE for a noob

Have you seen this tutorial? https://blog.expensify.com/2015/09/25/the-simplest-sqlite-common-table-expression-tutorial/ -- Bill Drago Staff Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at L-3COM.com > -Original Message- > From:

[sqlite] Are BLOB stored inline with the rest of the record fields?

I haven't seen any anyone else mention this yet. Another consideration when working with large blobs is to make those columns that last ones in your schema. To quote Dr. Hipp: "make the BLOB columns the last column in your tables. Or even store the BLOBs in a separate table which only has two

[sqlite] s::[i] Why SQLite does not use a web-based forum?

Send your question to a mailing list and a large number of people see it right away. Discussion follows as quickly as email can be sent and rec'd. You get the answer to your question in the least possible time. Post your question on a web-based forum and it will take much longer for the same

[sqlite] No Sqlite.dll for VS 2015 C# console application

Is System.Data.SQLite.dll in your bin folder along with the x86, x64 folders and corresponding SQLite.Interop.dll files? -- Bill Drago Staff Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at L-3COM.com > -Original Message- > From:

[sqlite] The Simplest SQLite Common Table Expression Tutorial

David, Thank you for sharing that. I found it very helpful. Regards, -- Bill Drago Staff Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at L-3COM.com > -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org

[sqlite] sqlite3 file as database

Why do people use .db3 for sqlite database files? In my experience .db3 is the file extension for dBase III database files. -- Bill Drago Staff Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at L-3COM.com > -Original Message- > From:

[sqlite] index for OR clause

If case is not important would adding COLLATE NOCASE to column c improve performance? -- Bill Drago Staff Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at L-3COM.com > -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org

[sqlite] Broken link on System.Data.SQLite homepage

I'm getting a 404 on the link to sqlite.phxsoftware.com. -- Bill Drago Staff Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at L-3COM.com CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER

[sqlite] why does SQLite support VARCHAR(X) when the doc says it ignores it?

I am one of those people. I use SQLite and MS SQL Server and it is very convenient to have this cross compatibility. -- Bill Drago Staff Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at L-3COM.com > Lots of people take SQL code originally intended

[sqlite] Slow real world performance - Any suggestions please (warning long)

Keith & Simon, Excellent explanations. Thank you. -- Bill Drago Staff Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at L-3COM.com > -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite- > users-bounces at

[sqlite] Reader.GetBytes() - when is a byte not a byte?

Lots of good replies. My problem is solved, thank you. My assumption was that GetBytes() could be used to read the bytes of any column regardless of type. What difference should column type or affinity make if I'm asking for bytes? If I'm using GetBytes() on a column with REAL affinity, it

[sqlite] Mozilla wiki 'avoid SQLite'

> -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite- > users-bounces at mailinglists.sqlite.org] On Behalf Of david at andl.org > Sent: Monday, June 15, 2015 2:28 AM > To: 'General Discussion of SQLite Database' > Subject: Re: [sqlite] Mozilla wiki

[sqlite] CTE/Sudoku talk (was User-defined types -- in Andl)

I'm in NY, but just by coincidence I'll be very close to Charlotte for a graduation on the same darn day as your CTE/Sudoku talk. So close, yet so far! I am also going to miss your Git: Just say "No!" talk which I would have loved to see. So, if these talks are permanently available on YouTube

[sqlite] How to get length of all columns in a table

All, I just want to make sure everyone understands that I know how to get the length of a column and that I was only asking for a wildcard technique to get the lengths of all columns in a table without having to list all the columns (e.g. SELECT Length(*) FROM myTable). Obviously that doesn't

[sqlite] How to get length of all columns in a table - Solved

> -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite- > users-bounces at mailinglists.sqlite.org] On Behalf Of J Decker > Sent: Monday, June 01, 2015 2:48 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] How to get length of all

[sqlite] How to get length of all columns in a table

How to get length of all columns in a table > > > On 1 Jun 2015, at 4:45pm, Drago, William @ CSG - NARDA-MITEQ > wrote: > > Just to confirm, the following is the only practical way to get the > length of each column in a table: > > > > Select

[sqlite] How to get length of all columns in a table

MyTable; > > Also, you will probably want to watch for columns with null values. So > this will work: > > select coalesce(length(MyColumn1),0) + coalesce(length (MyColumn2),0) + > coalesce(length (MyColumn3),0) from MyTable; > > HTH > Martin > > > Am 01.06.2015 um 17:12

[sqlite] How to get length of all columns in a table

All, What is the correct syntax for getting the length of all columns in a table? I tried SELECT Length(*) FROM myTable; and Length(SELECT * FROM myTable); Neither one of those works, and I can't find anything on line. Thanks, -- Bill Drago Senior Engineer L3

[sqlite] Please confirm what I THINK I know about blobs

te] Please confirm what I THINK I know about blobs > > On Mon, 11 May 2015 14:00:41 +0000 > "Drago, William @ CSG - NARDA-MITEQ" wrote: > > > > Correct me if I'm wrong, but the only way to read comments is by > > reading back the entire CREATE TABLE str

[sqlite] Please confirm what I THINK I know about blobs

mailto:sqlite- > users at mailinglists.sqlite.org> > > > On 9 May 2015, at 8:12pm, Drago, William @ CSG - NARDA-MITEQ > wrote: > > > Best idea yet! Anyone see any issues with this? > > It's actually a comment, and SQLite provides ways of putting proper > commen

[sqlite] Please confirm what I THINK I know about blobs

> -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite- > users-bounces at mailinglists.sqlite.org] On Behalf Of Eric Hill > Sent: Saturday, May 09, 2015 2:14 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Please confirm what I

[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

Under SQLite Admin Tools what is the difference between major and minor? -- Bill Drago Senior Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at L-3COM.com > -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org

[sqlite] System.Data.SQLite, Need alternate way to get field length

Thanks for the reply, Clemens. The problem is now solved. -- Bill Drago Senior Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at L-3COM.com > -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite- >

[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

Here's very good JDBC driver for SQLite: https://bitbucket.org/xerial/sqlite-jdbc -- Bill Drago Senior Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at L-3COM.com > -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org

[sqlite] Does column order matter for performance?

Read Mr. Hipp's reply to me when I asked a similar question: "Two things to be aware of: (1) When reading a row, SQLite reads from beginning to end. So if you have some small integer or boolean fields, it is better to put them first in the table. Otherwise, SQLite has to read past the big

[sqlite] Regarding testing

Never saw this before. LMAO. Will put it too good use... -- Bill Drago Senior Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at L-3COM.com > -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite- >

[sqlite] SQLite and Scientific Computing: Arrays and Complex Numbers

All, I've been enjoying this discussion and have learned a thing or two from all the suggestions. My particular problem is indeed solved. Adding a simple blob to my original table is the best solution in this case. If you think about the trace data as simply a screenshot of the analyzer

[sqlite] building SQLite DLL with Visual C++

r database objects" and an ERROR > > "Selecting Objects of type 'Table' is not supported. > > Then we get to the next part of the problem. I am in my late 70's and > have not done any SQL for over 15 years ( I was pretty good at one > time.) Where do I go from here. > > Jay >

[sqlite] building SQLite DLL with Visual C++

gt; I have been trying for 2 days and I am totally lost. > > I have NuGet Package Manager. I don't know how to use it. > > From the PM> System.Data.SQLiteI get an error. > > Can you be a little more specific. > > Jay > > On Thu, Apr 23, 2015 at 4:08 PM, D

[sqlite] Thoughts on storing arrays of complex numbers (Solved)

houghts on storing arrays of complex numbers > (Solved) > > On Fri, Apr 24, 2015 at 12:01 PM, Drago, William @ CSG - NARDA-MITEQ > wrote: > > Since the data is received from the analyzer as an array of > > real/imaginary pairs (R,I,R,I,R,I,R,I...), 3202 elements tot

[sqlite] Thoughts on storing arrays of complex numbers

mbers, > >width integer references COmplexNumbers ); > > > > Or if you need a list then something lije: > > > > create table ListHeader > > ( > >List integer primary key, > >Name text collate nocase not null unique, ); > > > > cre

[sqlite] Thoughts on storing arrays of complex numbers (Solved)

s-bounces at mailinglists.sqlite.org] On Behalf Of James K. Lowden > Sent: Friday, April 24, 2015 12:42 PM > To: sqlite-users at mailinglists.sqlite.org > Subject: Re: [sqlite] Thoughts on storing arrays of complex numbers > > On Fri, 24 Apr 2015 13:37:40 +0000 > "Drago, William @ CSG - NARDA

[sqlite] Thoughts on storing arrays of complex numbers

All, I'm trying to avoid re-inventing the wheel. Is there a best or generally accept way to store arrays of complex numbers? I'm considering the following: I could have two blob fields in my table. One for the real parts and one for the imaginary. (I don't like this.) Or, I could use a single

[sqlite] How do non-SQLite DBMS communicate?

n Wed, 22 Apr 2015 22:28:57 +0000 > "Drago, William @ CSG - NARDA-MITEQ" wrote: > > > When using SQLite the application program accesses the SQLite DBMS > via > > its .dll file. > > The DLL is a function-call library. A function is a named bit of code

[sqlite] building SQLite DLL with Visual C++

> -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite- > users-bounces at mailinglists.sqlite.org] On Behalf Of Jay Smith > Sent: Thursday, April 23, 2015 3:47 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] building SQLite DLL

[sqlite] How do non-SQLite DBMS communicate?

All, I'm not sure how to ask this question. When using SQLite the application program accesses the SQLite DBMS via its .dll file. When using something like Oracle Express (a local DBMS) the application program is communicating with Oracle Express via some sort of network protocol even though

[sqlite] Hot journal file won't go away

gt; users-bounces at mailinglists.sqlite.org] On Behalf Of Clemens Ladisch > Sent: Tuesday, April 21, 2015 4:30 PM > To: sqlite-users at mailinglists.sqlite.org > Subject: Re: [sqlite] Hot journal file won't go away > > Drago, William @ CSG - NARDA-MITEQ wrote: > > What is the reco

[sqlite] Hot journal file won't go away

All, What is the recommended procedure for clearing a hot journal file? I used to do a "SELECT name FROM sqlite_master WHERE type='table' ORDER BY name" and "SELECT name FROM sqlite_master WHERE type='index' ORDER BY tbl_name" but since I upgraded from System.Data.SQLite 1.0.93.0 to 1.0.96.0

[sqlite] SQLite to SQL Server

Lite to SQL Server > > > On 13 Apr 2015, at 10:38pm, Drago, William @ CSG - NARDA-MITEQ > wrote: > > > Is there a convenient way to transfer data from SQLite to SQL Server? > I'm presently writing code to do a row by row transfer of all my > tables, but the thought cros

[sqlite] SQLite to SQL Server

All, Is there a convenient way to transfer data from SQLite to SQL Server? I'm presently writing code to do a row by row transfer of all my tables, but the thought crossed my mind that maybe there's a better way. Thanks, -- Bill Drago Senior Engineer L3

[sqlite] Transpose selected rows into columns

V0, V5, V5-V0 > from > (select SerialNumber, > max(case Stim when 'V0' then Resp else null end) V0, > max(case Stim when 'V5' then Resp else null end) V5 from MyTable > group by SerialNumber) > > > > On 4/7/2015 6:58 AM, Drago, William @ CSG - NARDA-MITEQ wrote:

[sqlite] Transpose selected rows into columns

rows into columns > > > > On 27 Mar 2015, at 3:48pm, Drago, William @ CSG - NARDA-MITEQ > wrote: > > > > SerialNumber | Stim | Resp > > -|---|- > > .| .| . > > .| .| . > > 123 | V

[sqlite] Transpose selected rows into columns

11:48 AM, Drago, William @ CSG - NARDA-MITEQ wrote: > > I want the rows containing V0 and V5 to become columns like this: > > > > SerialNumber | V0 | V5 > > -|---|--- > > 123 | 0.136 | 0.599 > > 124 | 0.126 | 0.587 > > 1

[sqlite] Transpose selected rows into columns

All, Say I have a table that looks like this: SerialNumber | Stim | Resp -|---|- .| .| . .| .| . 123 | V0 | 0.136 123 | V1 | 0.201 123 | V2 | 0.297 123 | V3 | 0.311 123 |

[sqlite] Searching for interfacing info with Liberty Basic

And this: http://www.libertybasicuniversity.com/lbnews/nl106/SQLite.htm -- Bill Drago Senior Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at L-3COM.com > -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org

[sqlite] Searching for interfacing info with Liberty Basic

This is old, but may still be useful to you: http://libertybasicuniversity.com/lbnews/nl105/sql.htm -- Bill Drago Senior Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at L-3COM.com > -Original Message- > From: sqlite-users-bounces at

[sqlite] Documentation typo

On this page: http://www.sqlite.org/queryplanner.html Under the heading 1.4 Multiple Result Rows the word "of" is missing between the words "instead" and "peaches" in the third sentence. -- Bill Drago Senior Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge,

[sqlite] When to disambiguate column names in queries?

-03-16 06:16 PM, Drago, William @ CSG - NARDA-MITEQ wrote: > > All, > > > > Some of my Select statements are pretty long and I'm starting to > think it'd be a good idea to always include table names of columns > instead of just when they are not unique. This would

[sqlite] When to disambiguate column names in queries?

All, Some of my Select statements are pretty long and I'm starting to think it'd be a good idea to always include table names of columns instead of just when they are not unique. This would make the Select statements longer, but perhaps easier to understand if the reader knows where each

[sqlite] Question about ON DELETE CASCADE

Thank you for your replies, Mr. Smith and Mr. Slavin. I made the changes and all is well. Grateful for the assistance... -- Bill Drago Senior Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at L-3COM.com > -Original Message- > From:

[sqlite] Question about ON DELETE CASCADE

All, I want to modify my database so that deleting a row from a parent table will delete all dependant rows in all child tables. According to this page: https://www.sqlite.org/foreignkeys.html It looks like I have to add ON DELETE CASCADE to the child keys of all child tables. For example:

[sqlite] SQLite error(5): database is locked in System.Data.SQLite

There is some info here: http://sqlite.org/threadsafe.html -- Bill Drago Senior Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at L-3COM.com > -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite- >