limitation
preventing this, 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-us
#x27;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
table, I'd expect 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 us
;t have that
advantage and 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 Goer
upport dropping 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 - ht
and grouping. You
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"
Visit my web
e graph-drawing 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"
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. :-)
-
eaving the other connections alone.
--
Yves Goergen "LonelyPixel"
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
rong, 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"
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 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.
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"
Vis
> 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&
criptive. Also they
don't provide binaries 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"
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"
Visit my web laboratory at http://beta.unclassified.de
__
ifferent as well, but still 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 "Lone
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...&quo
6 gives 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"
Visit my web laboratory at http://beta.unclassified.de
___
me
mailing list defenders are a bit selfish in that regard.
>> + No publicly published 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-m
e shell but I couldn't find any
historic downloads on the SQLite website.
--
Yves Goergen "LonelyPixel"
Visit my web laboratory at http://beta.unclassified.de
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi
rt of the 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"
Visit my web laboratory at http://beta.unclassified.de
_
age it, 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"
Visit my web laboratory at http://beta.unclassified.de
st here if you cannot write to disk, but when using SQLite you
obviously can do that.
--
Yves Goergen "LonelyPixel"
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
s anytime 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 "Lo
ng TEXTual 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 "LonelyPixe
t; VARCHAR(255),
> "ModerationState" TINYINT NOT NULL DEFAULT 0,
> "Draft" BOOLEAN NOT NULL DEFAULT FALSE,
> "ContentType" VARCHAR(255),
> "Data" BLOB);
The column in question i
ly 7 bytes 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"
Visit my web laboratory at ht
On 03.01.2011 13:15 CE(S)T, Drake Wilson wrote:
> Quoth Yves Goergen , 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
essage_revision" ADD FOREIGN KEY ("MessageId") REFERENCES
> "message" ("MessageId") ON DELETE CASCADE;
> ALTER TABLE "message_revision" ADD FOREIGN KEY ("Author") REFERENCES "user"
> ("UserId");
But SQLite doesn
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 "Lone
dy do it with triggers but it would be way easier if the system did
that for me.
--
Yves Goergen "LonelyPixel"
Visit my web laboratory at http://beta.unclassified.de
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/
QLite files, 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"
Visit my web
e ADO.NET at
http://sqlite.phxsoftware.com/ ?
--
Yves Goergen "LonelyPixel"
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
robably that the SQLite engine does all that on its
own, how would that be? :-)
--
Yves Goergen "LonelyPixel"
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
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"
Vis
/docs/8.2/interactive/errcodes-appendix.html
--
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>
Visit my web laboratory at http://beta.unclassified.de
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
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
ed 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" <[EMA
r all, 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 PROTECTE
cceed under 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" <[EM
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
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..
nals for me. Even disposing 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..
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]>
Visi
e 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]
-
n attached database?
Here's what I did:
BEGIN TRANSACTION;
CREATE TEMPORARY TABLE attached_db.temp_table (...);
INSERT INTO attached_db.temp_table SELECT * FROM attached_db.table1;
DROP TABLE attached_db.table1; -- Error: Table is locked
Using SQLite 3.4.1 with the .NET wrapper in VS2005.
-
ue whether 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 ar
or less
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]
-
ing each and every record into memory 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 PR
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 mo
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
able or
using 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
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
>
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
>
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 n
Y 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]>
Visi
l
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
plication quits 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 labor
On 17.01.2005 13:55 (+0100), Ofer Chesler wrote:
> I tried to use the tool, (...)
What is Sqlite Explorer? Sounds interesting but Google doesn't know it.
--
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>
Unclassified NewsBoard Forum --> newsboard.unclassified.de
l Basic...
p.s.
There is also "mysql_escape_string"
I did this myself by now... ;)
--
Yves Goergen <[EMAIL PROTECTED]>
BlackBoard Internet Newsboard System --> blackboard.unclassified.de
Free (GPL), easy to use and install, secure, innovative! (PHP+MySQL)
;bugs.sql')));
---
---PHP output
Warning: sqlite_query(): unrecognized token: ":" in
C:\wwwroot\projects\bugtracker\sql.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 oth
65 matches
Mail list logo