Re: [sqlite] SQLite3 Pros / Cons

[Jens Alfke]

> On Feb 5, 2017, at 5:27 AM, Clyde Eisenbeis  wrote:
> 
> I posted "[sqlite] Retrieve INTEGER PRIMARY KEY" a few days ago.  The
> only solution proposed appears to use sqlite3.

I think you’re confusing sqlite3 the library with its C API.

You’re _already_ using the sqlite3 library, in the form of a .NET library that 
wraps around it providing a C# API.
What you’re saying here is that the solution for your problem requires calling 
the C API, because there’s no C# API equivalent to it.
I don’t know if that’s true or not … but it’s going to be easier to discuss the 
issue if you use terminology that makes sense to us.

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

Re: [sqlite] SQLite3 Pros / Cons

[Clyde Eisenbeis]

This is good information!

I posted "[sqlite] Retrieve INTEGER PRIMARY KEY" a few days ago.  The
only solution proposed appears to use sqlite3.

On Sat, Feb 4, 2017 at 5:34 PM, Joe Mistachkin  wrote:
>
> Random Coder wrote:
>>
>> And in case it's not obvious: System.Data.Sqlite _is_ sqlite3
>>
>
> To clarify and expand upon the above reply:
>
> System.Data.SQLite is an ADO.NET based managed wrapper around the
> SQLite.
>
> It includes the SQLite core library, compiled with a few extra
> options and loadable extensions, and some extra code to help it
> integrate better with the .NET Framework.  The file name for the
> native portions of System.Data.SQLite (also known as the "interop
> assembly") is typically "SQLite.Interop.dll" (i.e. this file name
> is used instead of "sqlite3.dll" by the P/Invoke integration).
>
> --
> 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-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite3 Pros / Cons

[Joe Mistachkin]

Random Coder wrote:
>
> And in case it's not obvious: System.Data.Sqlite _is_ sqlite3 
>

To clarify and expand upon the above reply:

System.Data.SQLite is an ADO.NET based managed wrapper around the
SQLite.

It includes the SQLite core library, compiled with a few extra
options and loadable extensions, and some extra code to help it
integrate better with the .NET Framework.  The file name for the
native portions of System.Data.SQLite (also known as the "interop
assembly") is typically "SQLite.Interop.dll" (i.e. this file name
is used instead of "sqlite3.dll" by the P/Invoke integration).

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

Re: [sqlite] SQLite3 Pros / Cons

[Random Coder]

On Feb 4, 2017, at 12:47 PM, Drago, William @ CSG - NARDA-MITEQ 
 wrote:

>> -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 SQLite ... started using it a few months ago.  I was unaware of
>> SQLite3 until I joined the SQLite mailing list.
>> 
>> What are the pros / cons of SQLite3?
>> 
>> If I switched from "using System.Data.SQLite" to SQLite3, are all of the
>> functions in a .dll I could download and use?
> 
> You're probably better off sticking with System.Data.SQLite because it will 
> be easier to make your code compatible with other databases. It's also 
> simpler in my opinion than using the SQLite 

And in case it's not obvious: System.Data.Sqlite _is_ sqlite3
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite3 Pros / Cons

[Drago, William @ CSG - NARDA-MITEQ]

> -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 SQLite ... started using it a few months ago.  I was unaware of
> SQLite3 until I joined the SQLite mailing list.
>
> What are the pros / cons of SQLite3?
>
> If I switched from "using System.Data.SQLite" to SQLite3, are all of the
> functions in a .dll I could download and use?

You're probably better off sticking with System.Data.SQLite because it will be 
easier to make your code compatible with other databases. It's also simpler in 
my opinion than using the SQLite3 .dll.

--
Bill Drago
Staff Engineer
L3 Narda-MITEQ
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 / william.dr...@l3t.com



> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
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.

Effective immediately my new email address is william.dr...@l3t.com. Please 
update your records.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite3 Pros / Cons

[Clemens Ladisch]

Clyde Eisenbeis wrote:
> What are the pros / cons of SQLite3?

http://www.sqlite.org/whentouse.html

> If I switched from "using System.Data.SQLite" to SQLite3, are all of
> the functions in a .dll I could download and use?

http://www.sqlite.org/howtocompile.html
http://www.sqlite.org/download.html


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

Re: [sqlite] SQLite3 Pros / Cons

[Simon Slavin]

On 4 Feb 2017, at 7:57pm, Clyde Eisenbeis  wrote:

> I'm new to SQLite ... started using it a few months ago.  I was
> unaware of SQLite3 until I joined the SQLite mailing list.
> 
> What are the pros / cons of SQLite3?

You might find this useful:



Pay special attention to the middle session which tells you when to use 
something else.

Simon.

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