Re: [sqlite] Resources for learning SQLite

[Chris Locke]

I'm a VB.Net developer (so don't hate me...) but use SQLite quite
extensively at work - works really well (well, obviously...)
If you know SQL Server, then SQLite isn't that miuch different, and the
class wrappers I use are identical, apart from the connection strings,
which I could pass on.  The wrappers are quite basic (no pun intended) so
depends on your requirements and development needs..

Thanks,
Chris



On Thu, Mar 29, 2018 at 6:20 PM, Jay Kreibich  wrote:

>
> > On Mar 29, 2018, at 12:06 PM, Mike Clark 
> wrote:
> >
> > I suspect there are already threads on this, so apologies for the
> potential
> > duplicate...
> >
> > I'm a long-time C# developer who has used Sql Server for decades, but I'm
> > just getting started with SQLite. Does anyone have any recommendations
> for
> > books or online resources?
> >
> > I'm particularly interested in resources that use C#.
> >
> > I've been working with "Using SQLite" by Jay A. Kreibich, and it's very
> > useful, but if there's something more advanced I'd love to know about it.
>
> Glad it’s useful.  It’s also a bit out of date, as it was published in
> 2010 when the latest version was 3.6.  The core stuff is still valid, but
> there have been a LOT of advancements in the last eight years.
>
>   -j
>
> ___
> 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] Resources for learning SQLite

[Damien Garwood]

Hi,
The SQLite documentation has a whole section on the SQL syntax that it 
supports. If you're working with C#, I believe system.data.sqlite is what's 
used there, but having made my bed in attempting to learn C and C++ so not 
having any reason to use that, I can't say how detailed and/or in-depth they 
are.
While we're on the topic of documentation, is the SQLite SQL syntax laid out 
in actual text anywhere, or is it just the syntax diagrams? At the moment I 
can only find the diagrams which are no good to me (using a screen reader) 
and so the rest I'm having to try to piece together from the usage notes and 
my limited knowledge of MySQL.

Cheers.
Damien.
-Original Message- 
From: Mike Clark

Sent: Thursday, March 29, 2018 6:06 PM
To: sqlite-users@mailinglists.sqlite.org
Subject: [sqlite] Resources for learning SQLite

I suspect there are already threads on this, so apologies for the potential
duplicate...

I'm a long-time C# developer who has used Sql Server for decades, but I'm
just getting started with SQLite. Does anyone have any recommendations for
books or online resources?

I'm particularly interested in resources that use C#.

I've been working with "Using SQLite" by Jay A. Kreibich, and it's very
useful, but if there's something more advanced I'd love to know about it.

Thanks!

--
Mike Clark 
Twitter: @Cyberherbalist
Blog: Cyberherbalist's Blog 
-
"Free will, though it makes evil possible, is also the only thing that
makes possible any love or goodness or joy worth having."
*- C. S. Lewis*
___
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] Resources for learning SQLite

[Drago, William @ CSG - NARDA-MITEQ]

> -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 already threads on this, so apologies for the potential
> duplicate...
>
> I'm a long-time C# developer who has used Sql Server for decades, but I'm
> just getting started with SQLite. Does anyone have any recommendations for
> books or online resources?
>
> I'm particularly interested in resources that use C#.
>
> I've been working with "Using SQLite" by Jay A. Kreibich, and it's very 
> useful,
> but if there's something more advanced I'd love to know about it.
>
> Thanks!
>

Start by downloading the help file from

http://system.data.sqlite.org/

(Don't forget to unblock it) And look at the introduction, especially "Getting 
the best performance out of SQLite."

I use SQLite with C# and get it either with NuGet, or I copy the files myself. 
NuGet is a little easier.

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



> --
> Mike Clark 
> Twitter: @Cyberherbalist
> Blog: Cyberherbalist's Blog 
> -
> "Free will, though it makes evil possible, is also the only thing that makes
> possible any love or goodness or joy worth having."
> *- C. S. Lewis*
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
CONFIDENTIALITY NOTICE: This email and any attachments are for the sole use of 
the intended recipient and may contain material that is proprietary, 
confidential, privileged or otherwise legally protected or restricted under 
applicable government laws. Any review, disclosure, distributing or other use 
without expressed permission of the sender is strictly prohibited. If you are 
not the intended recipient, please contact the sender and delete all copies 
without reading, printing, or saving..

Beginning April 1, 2018, L3 Technologies, Inc. will discontinue the use of all 
@L-3Com.com email addresses. To ensure delivery of your messages to this 
recipient, please update your records to use william.dr...@l3t.com.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Resources for learning SQLite

[Jay Kreibich]

> On Mar 29, 2018, at 12:06 PM, Mike Clark  wrote:
> 
> I suspect there are already threads on this, so apologies for the potential
> duplicate...
> 
> I'm a long-time C# developer who has used Sql Server for decades, but I'm
> just getting started with SQLite. Does anyone have any recommendations for
> books or online resources?
> 
> I'm particularly interested in resources that use C#.
> 
> I've been working with "Using SQLite" by Jay A. Kreibich, and it's very
> useful, but if there's something more advanced I'd love to know about it.

Glad it’s useful.  It’s also a bit out of date, as it was published in 2010 
when the latest version was 3.6.  The core stuff is still valid, but there have 
been a LOT of advancements in the last eight years.

  -j

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

[sqlite] Resources for learning SQLite

[Mike Clark]

I suspect there are already threads on this, so apologies for the potential
duplicate...

I'm a long-time C# developer who has used Sql Server for decades, but I'm
just getting started with SQLite. Does anyone have any recommendations for
books or online resources?

I'm particularly interested in resources that use C#.

I've been working with "Using SQLite" by Jay A. Kreibich, and it's very
useful, but if there's something more advanced I'd love to know about it.

Thanks!

-- 
Mike Clark 
Twitter: @Cyberherbalist
Blog: Cyberherbalist's Blog 
-
"Free will, though it makes evil possible, is also the only thing that
makes possible any love or goodness or joy worth having."
*- C. S. Lewis*
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] .dump command and user_version

[Ian Zimmerman]

On 2018-03-29 12:47, Wout Mertens wrote:

> I noticed that `.dump` does not output the user_version pragma. It
> seems to me that that is part of the database data?

I have run into this too.  I was trying to transport Mozilla browser
"places" database this way, and it turned out their code cares about the
user_version datum and thinks the file is corrupt if the value doesn't
match their expectation.

-- 
Please don't Cc: me privately on mailing lists and Usenet,
if you also post the followup to the list or newsgroup.
To reply privately _only_ on Usenet and on broken lists
which rewrite From, fetch the TXT record for no-use.mooo.com.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] .dump command and user_version

[Scott Robison]

On Thu, Mar 29, 2018, 8:18 AM Richard Hipp  wrote:

> On 3/29/18, Scott Robison  wrote:
> >  It seems a
> > reasonable to suggestion to add it.
>
> Version 3.23.0 is in bug-fix-only mode.  It'll have to wait.
>

Of course. I wasn't suggesting that it should be done with all haste, just
agreeing with the original suggestion.

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

Re: [sqlite] .dump command and user_version

[Simon Slavin]

On 29 Mar 2018, at 3:10pm, Scott Robison  wrote:

> Yet as he said, user_version is data. It can be queried and can be
> checked to make decisions about what to do with the data. It seems a
> reasonable to suggestion to add it.

On consideration, I see the point.  Would you want to dump

PRAGMA schema_version

too ?

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

Re: [sqlite] .dump command and user_version

[Richard Hipp]

On 3/29/18, Scott Robison  wrote:
>  It seems a
> reasonable to suggestion to add it.

Version 3.23.0 is in bug-fix-only mode.  It'll have to wait.

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

Re: [sqlite] .dump command and user_version

[Scott Robison]

On Thu, Mar 29, 2018 at 6:56 AM, Simon Slavin  wrote:
>
>
> On 29 Mar 2018, at 1:47pm, Wout Mertens  wrote:
>
>> I noticed that `.dump` does not output the user_version pragma. It seems to
>> me that that is part of the database data?
>>
>> I don't actually use it, but it might be interesting to add this for
>> completeness?
>
> .dump is for things which affect data and data integrity only.  "PRAGMA 
> foreign_keys" is one of the few PRAGMAs which affects data integrity: if a 
> database is operated with that PRAGMA not set, the data could be corrupted.
>
> Numerous PRAGMAs have no effect on integrity.  For example the journal mode 
> and page size.  They are not included in the output of .dump.

Yet as he said, user_version is data. It can be queried and can be
checked to make decisions about what to do with the data. It seems a
reasonable to suggestion to add it.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] .dump command and user_version

[Simon Slavin]

On 29 Mar 2018, at 1:47pm, Wout Mertens  wrote:

> I noticed that `.dump` does not output the user_version pragma. It seems to
> me that that is part of the database data?
> 
> I don't actually use it, but it might be interesting to add this for
> completeness?

.dump is for things which affect data and data integrity only.  "PRAGMA 
foreign_keys" is one of the few PRAGMAs which affects data integrity: if a 
database is operated with that PRAGMA not set, the data could be corrupted.

Numerous PRAGMAs have no effect on integrity.  For example the journal mode and 
page size.  They are not included in the output of .dump.

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

[sqlite] .dump command and user_version

[Wout Mertens]

I noticed that `.dump` does not output the user_version pragma. It seems to
me that that is part of the database data?

I don't actually use it, but it might be interesting to add this for
completeness?

sqlite> .dump
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
COMMIT;
sqlite> pragma user_version=50;
sqlite> pragma user_version;
50
sqlite> .dump
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
COMMIT;
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users