Currently the code base supports SQLITE_DEFAULT_RECURSIVE_TRIGGERS
which controls the default setting for PRAGMA recursive_triggers.
Can someone please add similar support for a
SQLITE_DEFAULT_FOREIGN_KEYS compiler define that allows the default
setting of PRAGMA foreign_keys to be controlle
Hey thanks for the advice after further testing I found this to be a
windows file system issue. windows made a boo boo and had discrepancy
between what could be accessed on the command line and what was shown
in windows
On Thu, Apr 1, 2010 at 3:11 PM, Tim Romano wrote:
> I should add that when yo
* sub sk:
> Somehow no one seems to have mentioned it on this mailing list so far!?
> Here is the scoop...
>
> On March 23, Oracle announced the latest release of Oracle® Berkeley
> DB - 11g Release 2 - which introduces a new SQL API, based on lo and
> behold, SQLite v3 API. What this means is t
I should add that when you create a SQLite database outside of Adobe and use
INT PK, in Adobe's implementation joins will return perfectly plausible yet
often completely inaccurate results, grabbing rows from the joined table
with the RowID not the actual PK.
http://forums.adobe.com/message/236598
I don't know what your specific problem may be but check to make sure that
you are using INTEGER [exactly I-N-T-E-G-E-R] primary keys (not INT or any
other variant form). I documented on Adobe's bug database and in their AIR
discussion forum a problem with the Adobe implementation of SQLite --Adobe
Hello!
On Thursday 01 April 2010 18:04:10 Adam DeVita wrote:
> How does
> $ time sqlite3 test32k.db "select count(1) from role_exist"
> perform?
Equal to count(*).
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqli
That's not the issue i am 100 percent certain i am pointing to the file
On Apr 1, 2010 1:17 PM, "Igor Tandetnik" wrote:
Felipe Aramburu wrote:
> So heres the basica scenario:
>
> 1. i update my data...
My guess would be, you actually have two different database files (maybe
with the same name b
>Both of these tools show a version of the database that is different
>from what i see in the command line and they are equivalent in their
>discrepancies (they are different from the command line but the same
>as each other).
>
>So heres the basica scenario:
>
>1. i update my database with the co
Felipe Aramburu wrote:
> So heres the basica scenario:
>
> 1. i update my database with the code i wrote
> 2. those changes are reflected in the command line
> 3. those changes are not reflected in Lita/SEP
>
> 1. I update information in Lita/SEP on that same database file
> 2. those changes are
I have some code that is using flex sdk 3.2 and I am updating and
inserting into a database with the following queries:
stmt.text = 'INSERT INTO Question( hotlist, name, label, datatypeid,
advanced, multivalue, measurementtypeid) VALUES (@hotlist,
@name,@label,@datatypeid,@advanced,@multivalue,@me
On Thu, Apr 01, 2010 at 10:44:51AM -0400, Pavel Ivanov scratched on the wall:
> > So 58s for count of all records! The count(*) for all records may use
> > the counter from primary key b-tree, is't it?
>
> What does this mean? I believe there's no any kind of counters in
> b-tree. If you meant cou
On Apr 1, 2010, at 12:33 PM, Noah Hart wrote:
> Maybe SQLite could implement a PRAGMA to use the
>
> physical memory locator (CHS# - Cylinder, Head, Sector) as data-access
> keys as well
>
>
>
> Could even be faster than the INTEGER PRIMARY KEY now used.
>
>
>
> What do you think?
>
We don't do
Maybe SQLite could implement a PRAGMA to use the
physical memory locator (CHS# - Cylinder, Head, Sector) as data-access
keys as well
Could even be faster than the INTEGER PRIMARY KEY now used.
What do you think?
http://thedailywtf.com/Articles/Announcing-APDB-The-Worlds-Fastest-Datab
Hello,
how to load the spatialite extension from python using QtSql? Anyone has
code examples?note that I'm talking about QtSQl not pysql2 or sqlite3 or
apsw. Thank you
Marcelo
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080
Hi, sorry to bump this thread, but I thought I'd just try once more to see
whether anybody might have some insight on the problem I'm having with
Lemon, as detailed in the original post below. I'm sure posts that languish
on this mailing list quickly get snowed under! I appreciate its not an
Sqli
> So 58s for count of all records! The count(*) for all records may use
> the counter from primary key b-tree, is't it?
What does this mean? I believe there's no any kind of counters in
b-tree. If you meant counter from auto-increment key then how about
gaps in the middle?
Pavel
On Thu, Apr 1,
How does
$ time sqlite3 test32k.db "select count(1) from role_exist"
perform?
On Thu, Apr 1, 2010 at 5:52 AM, Alexey Pechnikov wrote:
> Hello!
>
> $ time sqlite3 test32k.db "select count(*) from role_exist"
> 1250
>
> real0m58.908s
> user0m0.056s
> sys 0m0.864s
>
> $ sqlite3 test
Hi!
SQL Maestro Group announces the release of SQLite PHP Generator 10.3, a GUI
frontend that allows you to generate high-quality PHP scripts for the
selected SQLite tables, views and queries for the further working with these
objects through the web.
http://www.sqlmaestro.com/products/sqlite/p
Hello!
$ time sqlite3 test32k.db "select count(*) from role_exist"
1250
real0m58.908s
user0m0.056s
sys 0m0.864s
$ sqlite3 test32k.db
SQLite version 3.6.23
sqlite> .schema role_exist
CREATE TABLE role_exist (
id INTEGER PRIMARY KEY,
uid BLOB NOT NULL DEFAULT (randomblob(16)) U
On Apr 1, 2010, at 2:39 PM, Radovan Antloga wrote:
> I did not find any info about my situation in page
> http://www.sqlite.org/lockingv3.html
>
> I would just like a confirmation if this is expected
> behaviour.
>
> I have locking mode = normal. Steps are:
>
> 1. open database
> 2. open statemen
On 4/1/10 4:12 , "Neville Franks" wrote:
> Thursday, April 1, 2010, 12:16:13 PM, you wrote:
>
> JJD> On Wed, Mar 31, 2010 at 8:50 AM, Wiktor Adamski
> JJD> wrote:
There were many problems with
that approach:
>>> ...
(3) Each table and index is in a
separate file so your "da
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Navaneeth Sen B wrote:
> Could somebody explain this to me :
Which bit in particular is confusing?
SQLITE_MAX_SQL_LENGTH is a C define so you can change it by adding
"-DSQLITE_MAX_SQL_LENGTH=999" to the compiler invocation for sqlite3.c.
The reason
(drop table T2)
I get SQLite error 6 database table is locked.
So while statements are in progress it is not possible
to drop any tables.
Best Regards
Radovan Antloga
__ Informacija od ESET NOD32 Antivirus, zbirka virusnih definicij 4990
(20100401) __
To sporočilo je preveril
23 matches
Mail list logo