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@sqlite.org
http
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
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.de - http
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 - nospam.l
. (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
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 laboratory at http://beta.unclassified.de
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. :-)
--
Yves Goergen LonelyPixel
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 laboratory at http://beta.unclassified.de
___
sqlite
.
--
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
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
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 nospam.l...@unclassified.de
Visit my web laboratory at http
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.html
--
Yves Goergen LonelyPixel nospam.l
\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.l...@unclassified.de
Visit my web
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 http://beta.unclassified.de
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://beta.unclassified.de
, mailing list spam (or e-mail spam) not.
--
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
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.unclassified.de
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...)
--
Yves Goergen LonelyPixel
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...@unclassified.de
Visit my web laboratory
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://sqlite.org:8080/cgi-bin
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
___
sqlite-users mailing list
sqlite-users
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
___
sqlite-users mailing list
sqlite
can do that.
--
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
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.unclassified.de
that the entire image file has been stored as it is
entirely returned in a SELECT query and displayed in the web browser.
--
Yves Goergen LonelyPixel nospam.l...@unclassified.de
Visit my web laboratory at http://beta.unclassified.de
___
sqlite-users mailing list
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 web laboratory at http://beta.unclassified.de
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.de
Visit my web laboratory at http
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 defining the table
message, the table
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 LonelyPixel nospam.l
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
http://sqlite.org:8080/cgi-bin
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 web laboratory at http
/ ?
--
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
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://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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...@unclassified.de
Visit my web laboratory
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 PROTECTED]
Visit my web
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 correctly
--
Yves Goergen
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 at http://beta.unclassified.de
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]
Visit my web
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 web laboratory at http
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...
SQLite version 3.4.2
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 LonelyPixel [EMAIL PROTECTED]
Visit my
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
head over
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]
-
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
-
To unsubscribe, send email
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 scale. :)
--
Yves Goergen
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 laboratory at http://beta.unclassified.de
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]
-
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 more complex to do that. Maybe I find a sort
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 LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
.
Is this a bug or am I simply not supposed to use such column names? (I
was reading the formal SQL-92 syntax definition recently and thought,
why not just try it out...)
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
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 defined collation sequences. See
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.Groups[1].Value) -
int.Parse(m2.Groups[1
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 defined collation sequences. See
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
11
23
select from col from table order by cast(col as text);
I'm not sure what
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 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 listed at the end of the list but
near
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
-
To unsubscribe, send
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 web laboratory at http
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.unclassified.de
---
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. TIA
--
Yves
60 matches
Mail list logo
