Maybe Chrismas will be in february this year :
http://bugs.python.org/issue20465
Whatever will be the answer from the python team, THANKS a lot Mr Hipp, Mr
Kennedy, and Mr Mistachkin for making it possible !
___
sqlite-users mailing list
sqlite-users@s
Dear Keith,
the point is the following
you define a sqlite field as BOOLEAN
at that poit the sqlite ADO.NET maps it to System.Boolean
and it takes into account of an integer affinity
You put a wrong "Y" in, if there is no check constraint,
sqlite is typeless and accept it.
It does not smell like an
On Fri, Jan 31, 2014 at 8:49 PM, Stephen Chrzanowski
wrote:
> I've not done anything to 'generate' a SQL statement, but I can see the use
> of this just as a debugging tool to figure out why something is taking so
> long. I might just implement that in the wrapper I use and test for DEBUG
> or
Hello,
We have a small sqlite3 database compiled into our handheld unit (system
details below).
Upgrading from 3.7.14.1 to 3.8.2 our previously sorted queries are no longer
sorted.
Testing this same database with the win7 binary 3.8.2 the query is correctly
sorted.
I have tried:
* a
On Fri, Jan 31, 2014 at 12:05 PM, Simon Slavin wrote:
>
> However, you also mention that your app generates its own commands.
> Unless you can predict things about these commands ("90% of the time users
> are going to want to sort by date") you're not in a good place to figure
> out what indexes
Indeed it does. If you insert something that smells like an integer in a
column with integer affinity, it will be stored as an integer (rather than
text, for example).
>-Original Message-
>From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
>boun...@sqlite.org] On Behalf Of Joh
Yes, pages are of 1024 bytes and checkpoint is writing 500 MB. I see that I am
unable to write data during checkpoint. Any solution?
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On
Behalf Of Dan Kennedy
Sent: Friday, January 31,
Clemens Ladisch wrote...
To:
Sent: Friday, January 31, 2014 1:32 PM
Subject: Re: [sqlite] Error: near "SELECT": syntax error
jose isaias cabrera wrote:
INSERT OR REPLACE INTO LSOpenProjects
(
SELECT ...
)
SQL does not allow parentheses here.
all records ... that the localDB UpdateDa
But sqlite is typeless... so the affinity does not change much... :-(
A constraint check in (0,1) is needed for a reliable boolean type
--
View this message in context:
http://sqlite.1065341.n5.nabble.com/Boolean-and-DataReader-tp73521p73600.html
Sent from the SQLite mailing list archive at Nab
Clemens Ladisch" wrote...
jose isaias cabrera wrote:
I would like to suggest that once a BEGIN is set, if there is a syntax
error after a BEGIN, that BEGIN gets deactivated.
This is not how the SQL standard says databases should work.
sqlite> begin;
sqlite> select foo FROM;
Error: near ";
Joseph L. Casale wrote:
>SELECT
>r.id AS foo ...
>, a.value AS a_value ...
>, t.value AS t_value
> FROM request r
> LEFT JOIN attribute a
> ON a.req_id=r.id
> LEFT JOIN action t
> ON t.req_id=r.id
> WHERE ... NOT r.id IN (SELECT DISTINCT(req_
jose isaias cabrera wrote:
> I would like to suggest that once a BEGIN is set, if there is a syntax
> error after a BEGIN, that BEGIN gets deactivated.
This is not how the SQL standard says databases should work.
> sqlite> begin;
> sqlite> select foo FROM;
> Error: near ";": syntax error
> sqlite
jose isaias cabrera wrote:
> INSERT OR REPLACE INTO LSOpenProjects
> (
>SELECT ...
> )
SQL does not allow parentheses here.
> all records ... that the localDB UpdateDate is NOT equal to the sharedDB
> UpdateDate
This description is meaningless if you do not specify which records are to b
Good point, in terms of integer affinity I think that a Boolean_INT is the
way to go.
I have posted a bugfix request on sqliteadmin forum but I don't think it is
supported any longer...
It is using a non standard Y/N :(
On c# side GetBoolean is the best approach as opposite to the bool casting.
I t
Greetings and salutations!
I have two Databases:
1. LocalDB
2. SharedDB
The SharedDB has the latest updates made from different machines and
different users. I would like to update the localDB record based on a date
field (UpdateDate) that the SharedDB has, which is the latest. I have
index
I suppose I could set the environment variables but that feels... funky
since they apply to the user as a whole.
One thing I did notice when debugging is that on these copied assemblies,
the Assembly.CodeBase property has the original location of the Assembly
before running. I'm guessing this is w
On 02/01/2014 12:13 AM, veeresh kumar wrote:
Hi All,
Below is my Sqlite settings. The current database size
is ~ 8GB
PRAGMA journal_mode = WAL
PRAGMA synchronous = NORMAL
PRAGMA wal_autocheckpoint = 50"
With the above check point, the time taken to commit
transaction to actual da
> SELECT
> r.id AS foo
> , r.col_a
> , r.col_b
> , a.name AS a_name
> , a.value AS a_value
> , t.res_id AS t_res_id
> , t.key AS t_key
> , t.value AS t_value
> FROM request r
> LEFT JOIN attribute a
>ON a.req_id=r.id
On 31-01-2014 18:26, Joseph L. Casale wrote:
use a 'inner join', in stead of a 'left join' ?
Hi Luuk,
Sorry for the ambiguity, let me clarify.
Table A yields individual rows that I am interested in. For each of these rows,
a one to many exists with table B and or C.
In this case, an inner joi
> use a 'inner join', in stead of a 'left join' ?
Hi Luuk,
Sorry for the ambiguity, let me clarify.
Table A yields individual rows that I am interested in. For each of these rows,
a one to many exists with table B and or C.
In this case, an inner join wont work as valid rows from table A don't r
Hi All,
Below is my Sqlite settings. The current database size
is ~ 8GB
PRAGMA journal_mode = WAL
PRAGMA synchronous = NORMAL
PRAGMA wal_autocheckpoint = 50"
With the above check point, the time taken to commit
transaction to actual database file after reaching a checkpoint is 2.5 to 3
Greetings!
Perhaps I have not right ask this, as I am a newbie to SQL (about 5 years),
but, I would like to suggest that once a BEGIN is set, if there is a syntax
error after a BEGIN, that BEGIN gets deactivated. For example:
sqlite> begin;
sqlite> select foo FROM;
Error: near ";": syntax e
On 31 Jan 2014, at 4:41pm, Andreas Hofmann wrote:
> I would like to fine tune table indexes. I want to make sure I got indexes
> for the columns or combined columns of all (most) where clauses. The issue
> is that the application builds dynamic SQL strings all over the place and it
> may not be
Joseph L. Casale wrote:
> I have three tables where table A is a left joined one to many relationship
> against
> two other tables. I now need to modify this to accept filtering what is
> returned
> from table A based on one of the many rows in table B and/or C.
This description is extremely vag
Hi,
I would like to fine tune table indexes. I want to make sure I got indexes
for the columns or combined columns of all (most) where clauses. The issue
is that the application builds dynamic SQL strings all over the place and it
may not be easy to find them all without reading the code very
On 31-01-2014 17:23, Joseph L. Casale wrote:
I have three tables where table A is a left joined one to many relationship
against
two other tables. I now need to modify this to accept filtering what is returned
from table A based on one of the many rows in table B and/or C.
The row from table A
I have three tables where table A is a left joined one to many relationship
against
two other tables. I now need to modify this to accept filtering what is returned
from table A based on one of the many rows in table B and/or C.
The row from table A is only valid with all the corresponding rows f
Hi,
I have run into a similar issue for a hobby application of mine. If you are
interested, you can get a look at the code.
-Database SQL DDL is included in the source as string resources (fits the
scource control & install requirement)
-Build (don't know what you expect there, you may need to ad
Sorry if some of these are no brainers, I am a sqlite newbie with some MS
SQL experience.
Our application uses 3 Sqlite dbs and System.Data.Sqlite.dll (dropped by
installer). Functionality allows users to start a new instance of one of the
databases at run time. Hence we ship empty databases i
29 matches
Mail list logo
