, I'd like to understand it. Having no answer at all is a
bit frustrating...
[1] Richard Hipp, 2012-10-08 22:12 +0200, on this mailing list
--
Yves Goergen - nospam.l...@unclassified.de - http://unclassified.de
___
sqlite-users mailing list
sqlite-users@sqlit
s here. (Thankfully!)
--
Yves Goergen - nospam.l...@unclassified.de - http://unclassified.de
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ect it to
maintain all foreign key references, if possible. That's probably even
more work from the outside as a normal database user. (You know, the
engine can trust the things it does itself (at least I hope so), but it
doesn't necessarily trust the things a user does.)
--
Yves Goergen - nospa
d I regularly produce and find bugs due to that. But also in
PHP, I carefully select the appropriate type (i.e. don't rely on
auto-conversion too much) and rely on it being preserved. That allows me
to add my own type-checking and find bugs a lot faster.
--
Yves Goergen - nospam.l...@unclassified
columns
through SQL after all these years? Do the SQLite developers have strong
arguments against it, and which? Are there technical limitations (I
can't believe that)? Is there some kind of religion behind it?
--
Yves Goergen - nospam.l...@unclassified.de - http://unclassified.de
can group by a day of all months, for example. But the best knowledge
about interpreting a local date representation is surely still in your
application, not in any database system.
--
Yves Goergen "LonelyPixel" <nospam.l...@unclassified.de>
Visit my web laborat
rawing elements, then that might take good
> advantage of multi-cores and multi-processors.
Reading is what takes most of the time for me, plotting is pretty fast.
--
Yves Goergen "LonelyPixel" <nospam.l...@unclassified.de>
Visit my web laborat
On 07.02.2012 23:36 CE(S)T, Joe Mistachkin wrote:
> That issue was fixed prior to release 1.0.77.0, here:
>
> http://system.data.sqlite.org/index.html/info/13a3981ec0
>
> If possible, I recommend using the latest released version, 1.0.79.0.
Thanks, that did help. :-)
-
the other connections alone.
--
Yves Goergen "LonelyPixel" <nospam.l...@unclassified.de>
Visit my web laboratory at http://beta.unclassified.de
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ng, or is it a bug in
SQLite.NET?
I am currently using System.Data.SQLite version 1.0.76.0 on Windows XP
x86 with .NET 4.0.
--
Yves Goergen "LonelyPixel" <nospam.l...@unclassified.de>
Visit my web laboratory at http://beta.unclassified.de
_
e there was a reader lock on them? Did any other process access
the database (and thus hold any locks) while you did the checkpointing?
(Wild guess. I've only learned about WAL and started using it yesterday.
I've read the whole WAL documentation page [1] though.)
[1] http://sqlite.org/wal.ht
ne. On Linux. I still need the "normal" DLL for
Windows I think.
Is there a way to use the "managed-only" System.Data.SQLite.dll assembly
for both Linux and Windows? That would simplify my deployment process
across platforms a bit.
--
Yves Goergen "LonelyPixel" &l
MSBuild.exe System.Data.SQLite\System.Data.SQLite.[year].csproj
> /t:Rebuild /p:Configuration=Release /p:UseInteropDll=false
> /p:UseSqliteStandard=true
Thank you, that worked surprisingly fast.
So, where could I have found that information if not here?
--
Yves Goergen "LonelyPixel" <nospam
es and I'm uncomfortable with compiling 10 MB of
SQLite source code and 500 kB of mine.
So what should I do about Mono/Linux support for SQLite in C#?
--
Yves Goergen "LonelyPixel" <nospam.l...@unclassified.de>
Visit my web laboratory at h
On 12.11.2011 16:00 CE(S)T, Yves Goergen wrote:
> Could somebody please send me an older version 3.6.x of the SQLite
> Windows shell client?
Thank you.
--
Yves Goergen "LonelyPixel" <nospam.l...@unclassified.de>
Visit my web laboratory at http:
l more the same
than mailing lists. Usability is also about learning, but you cannot
learn things that change all the time.
Sorry for the spam, but today I really made enough bad experience with
mailing lists for a whole month.
--
Yves Goergen "LonelyPixel" <nospam.l...@unclassifi
ou get no immediate feedback, all mail from the
list is either delayed or my message was ignored. It's no fun reading
two pages of stuff I need to do until I can participate at the list.
("Copy this text and send a mail to that address, or reply, or do
nothing, or wait, or this or that...")
no result for my query with HAVING, but 3.7 does. I cannot
upgrade the older version so I'd just downgrade the other to be able to
compare anything.
--
Yves Goergen "LonelyPixel" <nospam.l...@unclassified.de>
Visit my web laboratory at http://beta
ublished e-mail address (spam etc.)
>
> Forums get forum spam. They also tend to come with ads.
Tend is something the forum admin can control. And forum spam can be
deleted later, mailing list spam (or e-mail spam) not.
--
Yves Goergen "LonelyPixel" <nospam.l...@unclassified.d
t I couldn't find any
historic downloads on the SQLite website.
--
Yves Goergen "LonelyPixel" <nospam.l...@unclassified.de>
Visit my web laboratory at http://beta.unclassified.de
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://
attraction of this list is that I don't have to think
> "Oh, I want to read a lot of SQLite-related stuff now !".
What do you mean? I don't get it.
--
Yves Goergen "LonelyPixel" <nospam.l...@unclassified.de>
Visit my web laboratory at http://beta.unclassified.de
__
t, but I'm far too little into this community. I'm just a reader
and rare questioner... But you'd need a few moderators to operate a
forum anyway.
--
Yves Goergen "LonelyPixel" <nospam.l...@unclassified.de>
Visit my web laboratory at http://beta.unclassified.de
___
should only be
of interest here if you cannot write to disk, but when using SQLite you
obviously can do that.
--
Yves Goergen "LonelyPixel" <nospam.l...@unclassified.de>
Visit my web laboratory at http://beta.unclassified.de
___
sqlite
me soon but
I'll look into it then.
I'm wondering why I get all the data back but SQLite can't count its
characters... And the image I get back from SQLite looks error-free so
it probably didn't make a single mistake handling it as text data.
--
Yves Goergen "LonelyPixel" <nospam.l...@unclassified.d
data then.
I don't want my INSERT to fail, I want SQLite to see that I'm inserting
binary data. There is only one way to insert data with PHP/PDO. I give
it binary data and it's supposed to do it right.
--
Yves Goergen "LonelyPixel" <nospam.l...@unclassified.de>
Visit my w
uot; VARCHAR(255),
> "ModerationState" TINYINT NOT NULL DEFAULT 0,
> "Draft" BOOLEAN NOT NULL DEFAULT FALSE,
> "ContentType" VARCHAR(255),
> "Data" BLOB);
The column in question is "Data".
I can verify
long, that's just the file header length.
Is this a bug or should I use another function on binary data?
The SQLite version is 3.6.20 from PHP 5.3.1 on Windows XP.
--
Yves Goergen "LonelyPixel" <nospam.l...@unclassified.de>
Visit my web laboratory at http://beta
On 03.01.2011 13:15 CE(S)T, Drake Wilson wrote:
> Quoth Yves Goergen <nospam.l...@unclassified.de>, on 2011-01-03 13:01:17
> +0100:
>> So I have foreign keys from message_revision to message and the other
>> way around. This obviously won't work because when defin
Hi,
I'm wondering whether SQLite supports the XML functions ExtractXML and
UpdateXML. I couldn't find them in the manual and not in the web. Is it
true that I would need to provide them as user functions? Are there any
existing implementations for PHP PDO?
--
Yves Goergen "Lonely
do it with triggers but it would be way easier if the system did
that for me.
--
Yves Goergen "LonelyPixel" <nospam.l...@unclassified.de>
Visit my web laboratory at http://beta.unclassified.de
___
sqlite-users mailing list
sqlite-users@sqlite.org
htt
s, you already have the entire engine in your hands. And the
other one doesn't need any additional files, it's just one .NET
assembly. And a huge one. So I cannot imagine that it's just some
bindings to a native DLL.
--
Yves Goergen "LonelyPixel" <nospam.l...@unclassified.de>
Visit my
.NET at
http://sqlite.phxsoftware.com/ ?
--
Yves Goergen "LonelyPixel" <nospam.l...@unclassified.de>
Visit my web laboratory at http://beta.unclassified.de
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
e SQLite engine does all that on its
own, how would that be? :-)
--
Yves Goergen "LonelyPixel" <nospam.l...@unclassified.de>
Visit my web laboratory at http://beta.unclassified.de
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://
has this feature I think that it will become even more popular.
You can already use referential integrity with SQLite - just in a very
complicated way, using numerous handcrafted triggers. How it works is
documented somewhere in the Wiki, IIRC.
--
Yves Goergen "LonelyPixel" <nospam.l..
lumn; inconsistent results"
Another bug I reported was indeed replied quickly, but the forum didn't
notify me although specified. (I'll now do what the reply says...) So
the new forum software has other bugs, too.
http://sqlite.phxsoftware.com/forums/t/866.aspx
"Something's not cleaned up
n replied to for weeks. The one bug should have been fixed,
but isn't. But these errors are not critical and can be worked around in
the application code (probably decreasing the performance).
Still, this is my recommendation for using SQLite in .NET.
--
Yves Goergen "LonelyPixel" <[EMAIL PR
it's
not usual that the file can't be deleted or that a database error would
occur in my particular case, but it's an interesting question in
general, I believe.
--
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>
Visit my web laboratory
the
current conditions so that I can safely delete the file?
Would that work with nested transactions or are integrity checks also
deferred to the most outer transaction? I never used nested transactions
so I have no experience with it.
--
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]&
On 31.08.2007 10:45 CE(S)T, Yves Goergen wrote:
> Maybe I should retry it with a plain SQLite console and figure out
> whether the bug is in the .NET wrapper (just as the previous one I've
> found...). Stay tuned...
When I do that from an SQLite console, it works as expected. So I'll
On 31.08.2007 06:03 CE(S)T, Dan Kennedy wrote:
> On Fri, 2007-08-31 at 00:09 +0200, Yves Goergen wrote:
>> CREATE TEMPORARY TABLE attached_db.temp_table
>
> I'm not sure where that table is created - in the temporary
> namespace or as part of attached_db. Checking...
>
posing the previous SQLiteCommand object from
"INSERT INTO ... SELECT * FROM ..." doesn't help here.
Maybe I should retry it with a plain SQLite console and figure out
whether the bug is in the .NET wrapper (just as the previous one I've
found...). Stay tuned...
--
Yves Goergen "LonelyPix
On 31.08.2007 00:23 CE(S)T, RaghavendraK 70574 wrote:
> Pls see if u hv an open sqlite3 terminal.sometimes this can also
> cause a prob with begin tx and just kept it open.
Really, I don't. Trust me. :)
--
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>
Visit my
ly one that opens it. It doesn't use
multiple threads so there also can't be another thread locking it.
--
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>
Visit my web laboratory at http://beta.unclassified.de
ress
> DROP TABLE attached_db.table1; -- Error: Table is locked
--
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>
Visit my web laboratory at http://beta.unclassified.de
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
or not 592k is "lightweight", it's
> definitely not in the heavyweight category either.
Sure, I don't have any special problem with it. 7zip compresses it down
to 250 kB and that's what often goes over the internet. Disk space and
memory bandwidth really aren't a problem in that sc
ess
severe/important? I can't figure that out from the complete listing.
--
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>
Visit my web laboratory at http://beta.unclassified.de
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
emory and having it
sorted and filtered there (which ADO.NET propagates) instead of having
that done directly in the source database engine...
--
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>
Visit my web laborator
On 25.06.2007 00:57 CE(S)T, [EMAIL PROTECTED] wrote:
> Yves Goergen <[EMAIL PROTECTED]> wrote:
>> Oh, well, I just realised that this will only sort numbers "naturally"
>> at the beginning of strings, but not in the middle or at the end. It
>> will be a bit
On 24.06.2007 00:17 CE(S)T, Yves Goergen wrote:
> CREATE TABLE "t a" ("c a", """cb""");
> (...)
And this may take forever to still not finish:
DROP TABLE "t a";
It then worked in a second try.
--
Yves Goergen
ing PRAGMA table_info("t a") will show the correct column names though.
I could not see any problems yet in my short tests with spaces and
double quotes in column names, but when the double quotes are the first
and last character of a column's name, things start to get crazy.
Is this a bu
On 22.06.2007 17:48 CE(S)T, Yves Goergen wrote:
> Match m1 = Regex.Match(param1, "^([0-9]+)");
> if (m1.Success)
> {
> Match m2 = Regex.Match(param2, "^([0-9]+)");
> if (m2.Success)
> {
> int cmpNum = int.Parse(m1.Gr
On 12.05.2007 22:57 CE(S)T, Ingo Koch wrote:
> Yves Goergen wrote:
>
>> I guess that doesn't work when I'm accessing the database through the
>> System.Data.SQLite interface in .NET?
>
> Fortunately your guess is wrong. ;-) System.Data.SQLite supports
> user defin
On 13.05.2007 17:19 CE(S)T, Chris Wedgwood wrote:
> On Sun, May 13, 2007 at 05:07:16PM +0200, Yves Goergen wrote:
>
>> Ah, now I realised that I'd also like to have that "natural sorting",
>> meaning this:
>>
>> 2
>> 8
>> 9
>> 10
>&
On 12.05.2007 22:57 CE(S)T, Ingo Koch wrote:
> Yves Goergen wrote:
>
>> I guess that doesn't work when I'm accessing the database through the
>> System.Data.SQLite interface in .NET?
>
> Fortunately your guess is wrong. ;-) System.Data.SQLite supports
> user defin
On 12.05.2007 17:33 CE(S)T, Igor Tandetnik wrote:
> Yves Goergen <[EMAIL PROTECTED]>
> wrote:
>> I'm trying to get my table sorted the way how for example Windows
>> Explorer or other file managers are sorting names. Most of all,
>> accented characters should not be
and NOCASE. Is there something else?
--
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>
Visit my web laboratory at http://beta.unclassified.de
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
On 11.04.2007 21:38 CE(S)T, Igor Tandetnik wrote:
> No. The other table affects the result of the query, so the join still
> has to be performed.
I see. I haven't thought of that effect. Thank you for the reply.
--
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>
Visit my
or will
the optimiser remove it? I haven't seen anything about this in the
"query optimiser overview" documentation.
--
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>
Visit my web laboratory at http://beta.unclassified.de
--
but keeping the entire
file twice may take much disk space. Maybe using two files, one for
current e-mails and one as growing archive (that doesn't change often),
would be a possibility.
--
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>
Visit my web laboratory at http://beta
php on line 4
---
It means the : behind the \' I guess. Removing all \' helps to execute
the query.
So how can I insert ' characters into a table other than by \'?
PS: Subscription to this list has not replied my anything within an
hour, I home I'll get replies to this post. Please CC me to be sure
60 matches
Mail list logo