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 w
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-dep
> -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 alrea
> 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
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 r
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 a
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 wit
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 s
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
htt
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 ad
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 d
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=5
12 matches
Mail list logo