Re: [sqlite] SQLite Options

in my SQLite.dll library program. On Tue, Feb 21, 2017 at 2:42 PM, Clyde Eisenbeis wrote: > I don't recall how I obtained the SQLite files ... was two years ago. > > When I have SQLite installed on my genealogy program and on my SQLite > .dll library, it works fine. > > When I

Re: [sqlite] SQLite Options

I don't recall how I obtained the SQLite files ... was two years ago. When I have SQLite installed on my genealogy program and on my SQLite .dll library, it works fine. When I don't have SQLite installed on my genealogy program, I get an exception "Unable to load DLL 'SQLite.Interop.dll': ... "

Re: [sqlite] SQLite Options

Are you using NuGet or downloading the binaries from System.Data.Sqlite.org? Ah. You'll have to excuse me, it's been a while since I actually started a new project and set SQLite as a dependency. I'm not sure if things have changed, or if my memory is terrible, but what I said may not have been

Re: [sqlite] SQLite Options

Thanks for the good info! I can't find SQLite.Interop.dll ... is referenced at https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki, but don't see a download. On Mon, Feb 20, 2017 at 12:30 PM, Barry Smith wrote: > I would use system.data.sqlite in that

Re: [sqlite] SQLite Options

I would use system.data.sqlite in that situation. But I would also say it depends on what you already have written, and what your strengths are. I am under the impression from your first email that you already have something written using system.data.sqlite. i.e. Using the class

Re: [sqlite] SQLite Options

Thanks for the clarification. In my case: 1) Speed is not an issue. Size is not an issue. 2) This is a personal use database (genealogy). 3) Typically I create .dll's that serve as a library (WPF Custom Control Library) ... easy to use for different programs. 4) For example, I have an Excel

Re: [sqlite] SQLite Options

Strange, I replied to this earlier... Perhaps my messages are not getting through. You cannot include a .c file for compilation in a c# project. You'd have to do use a separate DLL and do some pinvoke stuff to get to the raw SQLite interface, but in my opinion you're better off using the

Re: [sqlite] SQLite Options

Sorry for the slow response. My code is in C#. I don't know if the amalgamation source code in C can be compiled so it is compatible with C#. If it can, I'd be interested in details. Thanks! On Sat, Feb 18, 2017 at 1:29 AM, R Smith wrote: > > > On 2017/02/18 12:45 AM,

Re: [sqlite] SQLite Options

On 2017/02/18 12:45 AM, Warren Young wrote: On Feb 17, 2017, at 7:32 AM, R Smith wrote: You can even checkout the latest commits via SVN There’s a Subversion mirror of the official Fossil code repository for SQLite? Apologies, force of habit nomenclature. Have fallen

Re: [sqlite] SQLite Options

On Feb 17, 2017, at 7:32 AM, R Smith wrote: > > You can even checkout the latest commits via SVN There’s a Subversion mirror of the official Fossil code repository for SQLite? I tried to search the web for it, but since Subversion uses SQLite internally to manage its own

Re: [sqlite] SQLite Options

(A little bit off topic) On Fri, Feb 17, 2017 at 9:32 AM, R Smith wrote: > . though some wrappers exist for almost all programming languages and > they are relatively easy to use too - *but for brute speed and control, > use the API directly.* > Ever since I found

Re: [sqlite] SQLite Options

System.Data.SQLite is the package you want if you just want a .Net style (i.e. Using the standard .net db interfaces) wrapper around SQLite. You can find it on NuGet. The entity framework is a library that maps database entries and relations to OOP style objects. Look up object relational

Re: [sqlite] SQLite Options

On 2017/02/17 4:11 PM, Clyde Eisenbeis wrote: Is SQLite Version 3 the same as SQLite3? ... http://www.sqlite.org/download.html. Yes. You have been using SQLite3 through a wrapper, a good one by the way, but the core API comes as a single C file which can be compiled into your program

Re: [sqlite] SQLite Options

Is SQLite Version 3 the same as SQLite3? ... http://www.sqlite.org/download.html. On Thu, Feb 16, 2017 at 3:01 PM, Simon Slavin wrote: > > On 16 Feb 2017, at 8:40pm, Clyde Eisenbeis wrote: > >> Is there an SQLite version that is comprised of fewer dlls,

Re: [sqlite] SQLite Options

On 16 Feb 2017, at 8:40pm, Clyde Eisenbeis wrote: > Is there an SQLite version that is comprised of fewer dlls, etc.? ... > Perhaps SQLite3? If you’re writing C or C++ code all you need is the amalgamation source code files from the SQLite3 site. You compile them into your

[sqlite] SQLite Options

I started writing SQLite code about two years ago (Visual Studio 2013, C#, WPF) ... with a significant delay, since then, because of a physical move. The code is written for a specific use on my computer ... no other users. SQLite was chosen so my sons could eventually install this program on