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
revolution with Fossil! Ironically when I first came across a site called
FossHub I actually thought that was an attempt to make a Fossil-based
GitHub. Seems that isn't the case after all.
Cheers.
Damien.
-Original Message-
From: Richard Hipp
Sent: Tuesday, December 26, 2017 1:10 PM
a lot of time.
Cheers.
Damien.
-Original Message-
From: David Raymond
Sent: Monday, October 23, 2017 3:36 PM
To: SQLite mailing list
Subject: Re: [sqlite] Article about using sqlite3 in Python
Basic but good. execute will prepare the statement each time through,
whereas executemany
Hi,
For DotNet core, there is an implementation of sqlite for entity framework.
maybe you can dig the dependencies to find the sqlite packages.
I remember to have done this some time ago, worked well, but some features
missing.
Damien
Le 23 mai 2017 21:04, "Mark Raymond" <mar
in C.
On the other hand, searching is a necessity so it appears that encrypting
the data from the application itself is also not an option. So I think at
this point I am stuck
Cheers.
Damien.
-Original Message-
From: R Smith
Sent: Saturday, October 08, 2016 10:02 AM
To: sqlite-users
, there is the possibility that anyone sharing the computer or network
may peruse the database when you don't want them to.
Kind regards,
Damien.
-Original Message-
From: Darren Duncan
Sent: Saturday, October 08, 2016 6:54 AM
To: SQLite mailing list
Subject: Re: [sqlite] Protecting
Hi there,
My name is Damien Lindley, and I am, among other things, an independent,
hobbiest programmer. I have been blind since birth and thus all my computer
work relies on screenreader software and keyboard.
I have only just come through the brink of scripting into compiled programming
and so
, unregister it when connections are in a pool, when
connection is returned to the pool...
Do you think it is possible ? Who should I ask ?
Thanks :)
Damien
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo
Hi,
It is working for a classic application. But for a website (or a web
application), the directories x86 and x64 should be in the "~/Bin"
directory or in "~/" ?
Thanks.
Damien
2012/5/23 Joe Mistachkin <sql...@mistachkin.com>
>
> Rob Richardson wrote:
> &
2012/5/23 Joe Mistachkin <sql...@mistachkin.com>
>
> Damien wrote:
> >
> > Is there a way to have an assembly targeting "any cpu", that chooses by
> > itself the right dll to use at runtime ?
> >
>
> The System.Data.SQLite managed-only
ntime ?
I did something like this some time ago : 2 classes, one for x86 dll, one
for x64 dll, implementing same interface. And at runtime, a function to get
the right "native methods class", by trying to load one, and catch
"BadImageFormatException", t
a numeric type.
Oh, and just to clarify - in the second alter table statement, it
should have said: default '' - an error with my copying
Cheers,
Damien
On Fri, May 29, 2009 at 8:40 AM, John Machin <sjmac...@lexicon.net> wrote:
> On 29/05/2009 2:53 AM, Simon Slavin wrote:
>> On 28
sed older versions of sqlite -
is this a known issue that has been fixed in a more recent release?
Cheers,
Damien
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
,
and occasionally a once-a-minute timer was firing in that repaint
call, which selected from the database.
It would be nice if sqlite noticed a query was being run in the
progress handler and pointed out the operator error.
Cheers,
Damien
On Fri, Apr 3, 2009 at 8:21 AM, Damien Elmes <reso...@ichi2.
a,b,c, x
IIRC firebird is able to use multiple indices on the one table. Is
there a reason that sqlite doesn't? Is it too complicated? Don't get
me wrong - I find sqlite extremely useful, and I'm just curious as to
the reasons why it uses the current design.
Cheers,
Damien
_
to handle this situation any better
than it does at the moment?
Cheers,
Damien
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
allows using multiple nulls for the primary key, but
> according to their docs, it is non-standard and it says something
> about "this may change in the future". Maybe you are getting caught
> in the middle of a change that is going to occur across multiple
> revisions of SQLite.
>
;>>>> integrity_check
>>>>>>>> ---
>>>>>>>> ok
>>>>>>>> sqlite> select id, count(id) from cards group by id having
>>>>>>>> count(id)
>>>>>>>>> 1;
>>>
Sorry, my application's files are called decks, and I unwittingly used
the wrong terminology.
Any ideas about the problem?
On Sat, Mar 21, 2009 at 2:27 AM, Griggs, Donald
wrote:
>
>> However, when I ask the user to send me their deck, I find that:
>>
)s ..
etc
On Fri, Mar 20, 2009 at 8:16 PM, Dan <danielk1...@gmail.com> wrote:
>
> Does the "undolog" table, or whatever you're using in its place, have
> a primary key?
>
> On Mar 20, 2009, at 1:20 PM, Damien Elmes wrote:
>
>> Well, those 3 x the number of
Well, those 3 x the number of tables in the Db.
On Fri, Mar 20, 2009 at 3:17 PM, Damien Elmes <reso...@ichi2.net> wrote:
> Yep - but only the three listed on this page:
>
> http://www.sqlite.org/cvstrac/wiki?p=UndoRedo
>
> So they shouldn't be modifying anything in the main D
Yep - but only the three listed on this page:
http://www.sqlite.org/cvstrac/wiki?p=UndoRedo
So they shouldn't be modifying anything in the main DB, only the temporary DB.
On Fri, Mar 20, 2009 at 3:13 PM, Dan <danielk1...@gmail.com> wrote:
>
> On Mar 20, 2009, at 8:10 AM, Damien
ite> select id, count(id) from cards group by id having count(id) > 1;
sqlite>
Any ideas?
On Fri, Mar 20, 2009 at 10:00 AM, Damien Elmes <reso...@ichi2.net> wrote:
> Hi all,
>
> Some of my users have been reporting strange database problems
> recently, which seem to have g
, it's not an issue for us anymore. But I thought it's worth
reporting. Have there been any other instances of problems with the
shared cache mode?
Cheers,
Damien
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman
24 matches
Mail list logo