Gert Van Assche wrote:
2012/10/31 Clemens Ladisch clem...@ladisch.de
UPDATE World
SET TreeNode = CAST((SELECT COUNT(DISTINCT Continent)
FROM World w2
WHERE w2.Continent = World.Continent) AS TEXT);
this w2 table you are using, what is this and where
UNIX is basically a simple operating system, but you have to be a genius to
understand the simplicity - Dennis Ritchie
Genius might have limitations, but stupidity is no handicap
Eat Kosher
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]
Hello,
I recently updated my project to use the latest version of
System.Data.SQLite (1.0.82.0). But it seems that there is a bug in this
version. After I open an sqllite database and perform any query, the
database stays locked until the process ends.
Here is a C# code sample to reproduce
What's your question on SQLite?
(The sqlite-users@sqlite.org address is fairly straightforward. It's sort
of like a forum style of help, where you ask your question via e-mail and
90-95% of the answers come from roughly 10 seemingly never-sleeping experts
from around the English-speaking world.
Clemens,
not any teacher could have explained this any better!
Thanks
gert
2012/11/1 Clemens Ladisch clem...@ladisch.de
Gert Van Assche wrote:
2012/10/31 Clemens Ladisch clem...@ladisch.de
UPDATE World
SET TreeNode = CAST((SELECT COUNT(DISTINCT Continent)
FROM
Hello All,
Can you give suggestions on where to look for information on connecting to
a SQLite database from within a Java application? I'm new to both Java
SQLite and am wondering where is the best place to start? I have been
programming in C++ a long time using SQL Server so I'm not a
Since you have a development team that's built complex software on top
of sqlite, why not instrument it to see how many seeks it's doing per
query operation?
This can be done relatively easily by writing a custom vfs shim that
can collect stats for the read/write seeks. This stat collected over a
On 1 Nov 2012, at 2:53pm, Ryan Kool rk...@us.ibm.com wrote:
Can you give suggestions on where to look for information on connecting to
a SQLite database from within a Java application?
They're usually called 'wrappers'. Google the two words
Java SQLite
and pick one.
Simon.
Roger Binns wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 31/10/12 07:27, Jonas Malaco Filho wrote:
Maybe there could be a strict switch.
There is a ticket for a lint mode that would help catch common issues
where there are possibly problems. This is another example of something
Alex Reitbort wrote:
When running this sample with System.Data.SQLite.dll v1.0.81 everything
works ok.
When running this sample with System.Data.SQLite.dll v1.0.82, it fails on
File.Delete line with IOException: The process cannot access the file
'alex.db' because it is being used by
Hello,
it is a common practice to store datetime values as UNIX time UTC.
Maybe, Sqlite should have some shortcut for evaluating current moment?
Some alias for strftime('%s','now') ? Like, now or unixnow:
created_at DEFAULT (now()) vs created_at DEFAULT
(strftime('%s','now'))
On 1 Nov 2012, at 7:55pm, Григорий Григоренко grigore...@mail.ru wrote:
it is a common practice to store datetime values as UNIX time UTC.
Maybe, Sqlite should have some shortcut for evaluating current moment?
Please read
http://www.sqlite.org/lang_datefunc.html
Simon.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/11/12 12:33, Mark Brand wrote:
The optionality of AS when aliasing column names is not strange.
You are missing the point :-) I am not arguing for syntax changes or
anything else in the core of SQLite or SQL.
Instead in an additional lint
How about that recently preliminary infrastructure to send ORDERED commands
instead of queue draining was deleted from the kernel, because there's no
difference where to drain the queue, on the kernel or the storage side?
Send patches.
Alan
___
The optionality of AS when aliasing column names is not strange.
Oops. I see that I did not mean column names. This is about table aliases.
You are missing the point :-) I am not arguing for syntax changes or
anything else in the core of SQLite or SQL.
No, I don't don't think I am
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/11/12 14:32, Mark Brand wrote:
My point is that the proposed lint mode should worry more about 2) than
1).
I didn't think they are mutually exclusive. The class of probable errors
detected overlaps.
... as Oracle at least doesn't allow it.
On 01/11/12 14:32, Mark Brand wrote:
My point is that the proposed lint mode should worry more about 2) than
1).
I didn't think they are mutually exclusive. The class of probable errors
detected overlaps.
But the missing AS is not a probable error. It's standard and
well-established. So I
On Thu, Nov 1, 2012 at 5:18 PM, Mark Brand mabr...@mabrand.nl wrote:
Why should the missing AS even be a warning in lint mode? SQL-92 does not
mandate it. One of the most important implementations does not even accept
it. Do you know of any SQL implementation that requires an AS here?
To catch
Nico Williams wrote:
On Thu, Nov 1, 2012 at 5:18 PM, Mark Brand mabr...@mabrand.nl wrote:
Why should the missing AS even be a warning in lint mode? SQL-92 does not
mandate it. One of the most important implementations does not even accept
it. Do you know of any SQL implementation that requires
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/11/12 15:46, Mark Brand wrote:
A warning for missing AS would create noise and serve no purpose.
Then ignore/don't use it for your perfect code!
Other developers do use their own code (that could have been written years
ago), other code and
Alan Cox wrote:
How about that recently preliminary infrastructure to send ORDERED commands
instead of queue draining was deleted from the kernel, because there's no
difference where to drain the queue, on the kernel or the storage side?
Send patches.
Isn't any type of kernel-side ordering
The misspelling of NATURAL would be caught by a warning for JOIN
without ON constraint.
True. And other possible errors could be caught by missing AS.
Really?
In my opinion, it's actually a good idea to leave out the AS in table
aliases since SQL-92 and many or most implementations do not
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/11/12 18:25, Mark Brand wrote:
You mentioned that this extra AS might help avoid ambiguities and
errors. The only example of this you mentioned was where aliases names
with spaces are not quoted. Do you have cases of this in mind that
23 matches
Mail list logo
