Re: [sqlite] Resources for learning SQLite

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

Re: [sqlite] Resources for learning SQLite

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

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] Resources for learning SQLite

> 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

[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

Re: [sqlite] .dump command and user_version

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

Re: [sqlite] .dump command and user_version

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

Re: [sqlite] .dump command and user_version

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

Re: [sqlite] .dump command and user_version

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

Re: [sqlite] .dump command and user_version

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

Re: [sqlite] .dump command and user_version

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

[sqlite] .dump command and user_version

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