On 2014-08-27 23:02, Richard Hipp wrote:
On Wed, Aug 27, 2014 at 6:18 PM, jus...@postgresql.org wrote:
This is in process now:
https://github.com/sqlitebrowser/sqlitebrowser/pull/83
Might need a few code extra code tweaks (unsure), but we'll get it
done and push out an updated release with
On Sun, Aug 31, 2014 at 11:49 AM, jus...@postgresql.org wrote:
On 2014-08-27 23:02, Richard Hipp wrote:
On Wed, Aug 27, 2014 at 6:18 PM, jus...@postgresql.org wrote:
This is in process now:
https://github.com/sqlitebrowser/sqlitebrowser/pull/83
Might need a few code extra code tweaks
On 2014-08-26 16:18, jus...@postgresql.org wrote:
On 2014-08-25 17:04, Richard Hipp wrote:
Thank you for creating this project. I downloaded a copy. It seems
very nice.
NOW, PLEASE CHANGE THE NAME!!!
SQLite is a trademark. You are welcomed and encouraged to use the
code for SQLite, but not
On Wed, Aug 27, 2014 at 6:18 PM, jus...@postgresql.org wrote:
This is in process now:
https://github.com/sqlitebrowser/sqlitebrowser/pull/83
Might need a few code extra code tweaks (unsure), but we'll get it
done and push out an updated release with the new name sometime
in the next few
A thin SQLite wrapper for Swift:
https://github.com/ryanfowler/SwiftData
Uses Swift variable types. You have to explicitly say what type you want your
value as.
Implements variable binding for security purposes.
Implements a date class. I have not checked out how well it does this.
On 2014-08-25 17:04, Richard Hipp wrote:
Thank you for creating this project. I downloaded a copy. It seems
very nice.
NOW, PLEASE CHANGE THE NAME!!!
SQLite is a trademark. You are welcomed and encouraged to use the
code for SQLite, but not the name SQLite.
This is not just a legal
See also
https://news.ycombinator.com/item?id=8226962
for discussion.
On Tue, Aug 26, 2014 at 9:09 AM, Simon Slavin slav...@bigfraud.org wrote:
A thin SQLite wrapper for Swift:
https://github.com/ryanfowler/SwiftData
Uses Swift variable types. You have to explicitly say what type you
Hi all,
SQLite Database Browser v3.3.0 has been released. :)
https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.3.0
This has several bug fixes in it around table parsing,
which fixes several it crashes when I open my db type
problems. (Oops) ;)
Plus a lot of general
Thank you for creating this project. I downloaded a copy. It seems very
nice.
*Now, Please Change The Name!!!*
SQLite is a trademark. You are welcomed and encouraged to use the code
for SQLite, but not the name SQLite.
This is not just a legal exercise. A project like your SQLite Database
Dear all
PLease let me know if there is a version of SQLite for OpenVMS 8.x. Has anyone
got it to work?
Thank you
Keshav
ktadim...@aim.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
Hi Clemens,
thanks for the link!
Regards,
Hartwig
Am 22.08.2014 um 22:26 schrieb Clemens Ladisch clem...@ladisch.de:
skywind mailing lists wrote:
I hoped that somebody already tried to implement a nearest neighbor
algorithm.
Typically, objects are not axis-aligned rectangles, and the
Hello,
I hoped that somebody already tried to implement a nearest neighbor algorithm.
Is the format of the shadow tables somewhere documented or do I have to analyze
the source code?
Regards,
Hartwig
Am 22.08.2014 um 02:58 schrieb Richard Hipp d...@sqlite.org:
On Thu, Aug 21, 2014 at 8:54
skywind mailing lists wrote:
I hoped that somebody already tried to implement a nearest neighbor
algorithm.
Typically, objects are not axis-aligned rectangles, and the R-tree is
just an index based on the bounding boxes. Computing the (nearest)
distance would require the actual geometries.
Hello,
does anybody have any experience with implementing a nearest neighbor search
using SQLite's RTree functionality? Is a nearest neighbor search possible?
Regards,
Hartwig
___
sqlite-users mailing list
sqlite-users@sqlite.org
On 21 Aug 2014, at 10:32pm, skywind mailing lists mailingli...@skywind.eu
wrote:
does anybody have any experience with implementing a nearest neighbor search
using SQLite's RTree functionality? Is a nearest neighbor search possible?
How much have you read ? Are you familiar with SpaciaLite
with it...
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin
Sent: quinta-feira, 21 de Agosto de 2014 23:09
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Sqlite RTree nearest neighbour
On 21 Aug 2014, at 10
According to R-Trees: Theory and Applications by Yannis Manolopoulos,
Alexandros Nanopoulos, Apostolos N. Papadopoulos and Yannis Theodoridis, there
are a number of algorithms for efficiently determining the nearest neighbor(s)
using an R-Tree (an internet search on the two terms will pull up
On Thu, Aug 21, 2014 at 8:54 PM, Peter Aronson pbaron...@att.net wrote:
1. You would need to access SQLite's R-Tree shadow tables
(xx_node, xx_parent, xx_rowid) directly in to perform the traversals
required by all of the algorithms -- I don't know if this is officially
supported by
I started to worry about this issue, because I am in a middle of an
application development, and yesterday, it started to work, and I only SELECT
a few times, and it makes a noticeable disk access. I'm still on magnetic HDD,
but the application will be running on SSD or Flash drive.
Let me start
On Tue, Aug 19, 2014 at 10:34 AM, Levente Kovacs leventel...@gmail.com
wrote:
I started to worry about this issue, because I am in a middle of an
application development, and yesterday, it started to work, and I only
SELECT
a few times, and it makes a noticeable disk access. I'm still on
On Tue, Aug 19, 2014 at 10:38 AM, Richard Hipp d...@sqlite.org wrote:
On Tue, Aug 19, 2014 at 10:34 AM, Levente Kovacs leventel...@gmail.com
wrote:
I started to worry about this issue, because I am in a middle of an
application development, and yesterday, it started to work, and I only
On 08/19/2014 11:00 AM, sqlite-users-requ...@sqlite.org wrote:
10. Re: Long time to drop tables. (Jonathan Moules)
12. Re: Long time to drop tables. (Simon Slavin)
--
Long time for me too!
This was run on an 11.7GB
On Fri, Aug 15, 2014 at 10:45 AM, Levente leventel...@gmail.com wrote:
I am thinking about putting an SQLite database on a flash drive (SD card).
I would like to know what kind of file system is the optimal. I want to
query a lot, and insert or update a few times per minute.
Not directly
On 16 Aug 2014, at 9:32pm, Baruch Burstein bmburst...@gmail.com wrote:
On Fri, Aug 15, 2014 at 10:45 AM, Levente leventel...@gmail.com wrote:
I am thinking about putting an SQLite database on a flash drive (SD card).
I would like to know what kind of file system is the optimal. I want to
Simon Slavin wrote:
On 16 Aug 2014, at 9:32pm, Baruch Burstein bmburst...@gmail.com wrote:
On Fri, Aug 15, 2014 at 10:45 AM, Levente leventel...@gmail.com wrote:
I am thinking about putting an SQLite database on a flash drive (SD card).
I would like to know what kind of file system is the
I am thinking about putting an SQLite database on a flash drive (SD card).
I would like to know what kind of file system is the optimal. I want to
query a lot, and insert or update a few times per minute.
The goal is to minimize disk writes, which leads the FLASH to wear out.
After some googling
...@sqlite.org] On Behalf Of Petite Abeille
Sent: Tuesday, 12 August, 2014 12:15
To: General Discussion of SQLite Database
Subject: Re: [sqlite] SQLite relative dates and join query help
On Aug 12, 2014, at 7:38 PM, Ben sqlite_l...@menial.co.uk wrote:
The result I'm after is:
id, prod_code
On Aug 13, 2014, at 3:43 AM, Keith Medcalf kmedc...@dessus.com wrote:
I don't think you want max() around collections.book_in_date. You want the
max(collection_date) but the book_in_date from that row. Since the
collection_date is unique, the book_in_date can only come from one record.
I'm trying to solve the following problem in SQLite:
Items are being produced with a short, fixed shelf life. Say 50 days.
Item can be collected every two weeks, where each item must be registered a
week before.
I am trying to create a query where I can list current items and the latest day
On 12-8-2014 19:38, Ben wrote:
I'm trying to solve the following problem in SQLite:
Items are being produced with a short, fixed shelf life. Say 50 days.
Item can be collected every two weeks, where each item must be registered a
week before.
I am trying to create a query where I can list
On Aug 12, 2014, at 7:38 PM, Ben sqlite_l...@menial.co.uk wrote:
The result I'm after is:
id, prod_code, creation_date, last_book_in_date, last_collection_date
Where the final two columns are from the collection which is the farthest in
the future, but still within the 50-day period
[mailto:sqlite-users-
boun...@sqlite.org] On Behalf Of Petite Abeille
Sent: Tuesday, 12 August, 2014 12:15
To: General Discussion of SQLite Database
Subject: Re: [sqlite] SQLite relative dates and join query help
On Aug 12, 2014, at 7:38 PM, Ben sqlite_l...@menial.co.uk wrote:
The result I'm after
hello,
Maybe i did a wrong manipulation.
Using latest beta dll on windows / python3.3, I get this strange error :
import sqlite3 as sqlite
File
C:\Users\famille\Documents\winpython\WinPython-32bit-3.3.5.0\python-3.3.5\lib\sqlite3\__init__.py,
line 23, in module
from sqlite3.dbapi2
complementary information :
- compiling manually sqlite.dll , I have no issue,
- so the problem, if problem, is the official Sqlite.dll downloadble from
sqlite.org.
___
sqlite-users mailing list
sqlite-users@sqlite.org
@sqlite.org
Subject: Re: [sqlite] SQLite 3.8.6 beta
hello,
Maybe i did a wrong manipulation.
Using latest beta dll on windows / python3.3, I get this strange error :
import sqlite3 as sqlite
File
C:\Users\famille\Documents\winpython\WinPython-32bit-3.3.5.0\python-
3.3.5\lib\sqlite3\__init__.py
-users@sqlite.org
Subject: Re: [sqlite] SQLite 3.8.6 beta
hello,
Maybe i did a wrong manipulation.
Using latest beta dll on windows / python3.3, I get this strange error :
import sqlite3 as sqlite
File
C:\Users\famille\Documents\winpython\WinPython-32bit-3.3.5.0\python-
3.3.5\lib\sqlite3
regards
Paolo
2014-08-07 18:25 GMT+02:00 Simon Slavin slav...@bigfraud.org:
On 7 Aug 2014, at 2:34pm, Paolo Combi paolo.co...@ipratico.it wrote:
i have 1 sqlite file on my ipad and when i download this file i find some
other version of this file .
*.sqlite
*.sqlite-shm
*-sqlite-wal
On 8 Aug 2014, at 8:11am, Paolo Combi paolo.co...@ipratico.it wrote:
thank you so much for your reply , i'm very interesting about close this
connection under iOS because i work together with the guys that do this app.
our problem is do this :
APP working -- call backup function -close
On Fri, Aug 8, 2014 at 9:11 AM, Paolo Combi paolo.co...@ipratico.it wrote:
APP working -- call backup function -close sqlite- download sqite -
reopen sqlite - APP working
Do you know about http://www.sqlite.org/backup.html? Just in case...
Not quite your problem, but related a little. Hope
hi Jose,
The SQL request with a in() that is improved by 5x in the latest beta
is of form :
select * from a , b where a.field1 in (b.column1, b.column2, b.column3,
b.column4, 'fixed value')
___
sqlite-users mailing list
sqlite-users@sqlite.org
A bit thanks to E.Pasma who found a performance regression in 3.8.6, which
has now been fixed (with added test cases to prevent a recurrence). Fresh
snapshots are now on the download page (http://www.sqlite.org/download.html).
Please continue to test the latest snapshots and report any issues you
On Wed, 6 Aug 2014 20:56:24 -0400
Richard Hipp d...@sqlite.org wrote:
http://www.perfectyourenglish.com/vocabulary/backward-backwards.htm
Two countries divided by a common tongue.
Except, I speak Southern English, not British English. And I can
promise you that we southerners prefer to
big stone wrote...
hi Jose,
The SQL request with a in() that is improved by 5x in the latest beta
is of form :
select * from a , b where a.field1 in (b.column1, b.column2, b.column3,
b.column4, 'fixed value')
Hi Big Stone,
This is what I am running with an ATTACHed DB as client...
Op 6 aug 2014, om 02:57 heeft Richard Hipp het volgende geschreven:
Version 3.8.6 was originally scheduled for September. But the
change log (
http://www.sqlite.org/draft/releaselog/current.html) is getting
rather long
and there are a number of important bug fixes. So we might try to get
Richard Hipp wrote...
32-bit and 64-bit DLLs are the latest 3.8.6 beta are now available on the
download page. http://www.sqlite.org/download.html
All works great. No visible speed increase for WHERE .. IN () as reported
by someone, but nonetheless, all is well. Thanks.
On Tue, Aug 5,
Richard Hipp wrote:
On Wed, Aug 6, 2014 at 8:33 PM, James K. Lowden jklow...@schemamania.org
wrote:
On Wed, 6 Aug 2014 07:40:43 -0400
Richard Hipp d...@sqlite.org wrote:
PS: backward compatibility, no s, no?
A google search shows that you see it both ways - with and without the
Hello,
i have one problem.
i have 1 sqlite file on my ipad and when i download this file i find some
other version of this file .
*.sqlite
*.sqlite-shm
*-sqlite-wal
i see if i use a firefox plugin this file will be merge together and i want
to do the same things with php .
is possibile?
best
On 7 Aug 2014, at 2:34pm, Paolo Combi paolo.co...@ipratico.it wrote:
i have 1 sqlite file on my ipad and when i download this file i find some
other version of this file .
*.sqlite
*.sqlite-shm
*-sqlite-wal
i see if i use a firefox plugin this file will be merge together and i want
On Thu, Aug 7, 2014 at 9:34 AM, Paolo Combi paolo.co...@ipratico.it wrote:
Hello,
i have one problem.
i have 1 sqlite file on my ipad and when i download this file i find some
other version of this file .
*.sqlite
*.sqlite-shm
*-sqlite-wal
The -shm and -wal files are journals left over
On Thu, Aug 7, 2014 at 10:01 AM, E.Pasma pasm...@concepts.nl wrote:
I have a case where a primary key index is no longer used where it was
used before.
Thank you for the test case!
This problem should now be addressed on trunk and in the pre-release
snapshots. Please retry using the latest
FWIW, the Zumero test suite is fairly abusive and it passes all test cases
with 3.8.6 beta.
--
E
On Thu, Aug 7, 2014 at 11:59 AM, Richard Hipp d...@sqlite.org wrote:
On Thu, Aug 7, 2014 at 10:01 AM, E.Pasma pasm...@concepts.nl wrote:
I have a case where a primary key index is no longer
On Wed, Aug 6, 2014 at 2:57 AM, Richard Hipp d...@sqlite.org wrote:
Please review the change log and speak up if you see anything amiss.
The new doc mentioned by http://www.sqlite.org/draft/lang_expr.html#hexint
may have a 1-char typo:
However, for backwards compatibility, the Ox
src/func.c: The comment on top refers to sqliteRegisterBuildinFunctions()
but the actual call seems to have been renamed to
sqliteRegisterGlobalFunctions()
___
sqlite-users mailing list
sqlite-users@sqlite.org
Richard Hipp wrote...
Version 3.8.6 was originally scheduled for September. But the change log
(
http://www.sqlite.org/draft/releaselog/current.html) is getting rather
long
and there are a number of important bug fixes. So we might try to get
3.8.6 out the door sooner rather than
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
boun...@sqlite.org] On Behalf Of Richard Hipp
Sent: 06 August 2014 01:58
To: General Discussion of SQLite Database; sqlite-dev
Subject: [sqlite] SQLite version 3.8.6 coming soon
Version 3.8.6
Unless I'm misusing it, I believe the shell readfile() function reads a file
as text, not binary. I haven't checked writefile() for the same problem on
writing.
This is how I use it, is this not correct?
create table t1(a blob);
insert into t1 values(readfile('binfile'));
select * from t1;
On Wed, Aug 6, 2014 at 6:34 AM, Tony Papadimitriou to...@acm.org wrote:
Unless I'm misusing it, I believe the shell readfile() function reads a
file as text, not binary. I haven't checked writefile() for the same
problem on writing.
This is how I use it, is this not correct?
create table
On Wed, Aug 6, 2014 at 3:26 AM, Dominique Devienne ddevie...@gmail.com
wrote:
PS: backward compatibility, no s, no?
A google search shows that you see it both ways - with and without the
s. I've always used the s.
--
D. Richard Hipp
d...@sqlite.org
Hello,
I am developing an .NET Framework 3.5 application for a Windows CE x32 PC. Can
I get a Library of SQLite for that System?
Best regards,
Tobias Stüker
Beckhoff Automation GmbH | Managing Director: Dipl. Phys. Hans Beckhoff, Arnold
Beckhoff
Registered office: Verl, Germany | Register
Hello,
I am developing a .NET Framework 3.5 application for a Windows CE 32bit (x86)
PC.
Can I get a Library of SQLite for that System?
Best regards,
Tobias
Beckhoff Automation GmbH | Managing Director: Dipl. Phys. Hans Beckhoff, Arnold
Beckhoff
Registered office: Verl, Germany | Register
Did you already read
https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki#sqlite-netFx35-binary-PocketPC-ARM-2008
?
On Tue, Aug 5, 2014 at 10:32 AM, Tobias Stüker t.stue...@beckhoff.com
wrote:
Hello,
I am developing an .NET Framework 3.5 application for a Windows CE x32 PC.
32-bit and 64-bit DLLs are the latest 3.8.6 beta are now available on the
download page. http://www.sqlite.org/download.html
On Tue, Aug 5, 2014 at 11:11 PM, jose isaias cabrera
jic...@cinops.xerox.com wrote:
Richard Hipp wrote...
Version 3.8.6 was originally scheduled for September.
Richard Hipp wrote...
32-bit and 64-bit DLLs are the latest 3.8.6 beta are now available on the
download page. http://www.sqlite.org/download.html
Thank you very much, Dr. Hipp.
josé
On Tue, Aug 5, 2014 at 11:11 PM, jose isaias cabrera
jic...@cinops.xerox.com wrote:
Richard Hipp
Hello Sqlite team,
My specific need relies on a rather complex combination of in, and with
the new beta I go from 50 seconds down to 10 seconds.
(a 5x improvement)
== Is that sort of gain possible with the recent in omtimisation, or
shall look deeper if result is still right ?
Regards,
On Wed, Aug 6, 2014 at 5:35 PM, big stone stonebi...@gmail.com wrote:
Hello Sqlite team,
My specific need relies on a rather complex combination of in, and with
the new beta I go from 50 seconds down to 10 seconds.
(a 5x improvement)
== Is that sort of gain possible with the recent in
On Wed, 6 Aug 2014 07:40:43 -0400
Richard Hipp d...@sqlite.org wrote:
PS: backward compatibility, no s, no?
A google search shows that you see it both ways - with and without the
s. I've always used the s.
http://www.perfectyourenglish.com/vocabulary/backward-backwards.htm
Two
On Wed, Aug 6, 2014 at 8:33 PM, James K. Lowden jklow...@schemamania.org
wrote:
On Wed, 6 Aug 2014 07:40:43 -0400
Richard Hipp d...@sqlite.org wrote:
PS: backward compatibility, no s, no?
A google search shows that you see it both ways - with and without the
s. I've always used
On Wed, Aug 6, 2014 at 6:56 PM, Richard Hipp d...@sqlite.org wrote:
On Wed, Aug 6, 2014 at 8:33 PM, James K. Lowden jklow...@schemamania.org
wrote:
On Wed, 6 Aug 2014 07:40:43 -0400
Richard Hipp d...@sqlite.org wrote:
PS: backward compatibility, no s, no?
A google
ok,
output comparison
Size is different :
- before28 488 559
- now with beta 28 711 111
== delta = 222 552 ... which is my number of ouput lines
The change in Newline Output policy (from CR to CR+LF) did generate a
suspens.
WinMerge says output is identical otherwise.
So my 5x
Version 3.8.6 was originally scheduled for September. But the change log (
http://www.sqlite.org/draft/releaselog/current.html) is getting rather long
and there are a number of important bug fixes. So we might try to get
3.8.6 out the door sooner rather than later.
Please test! Recent
Richard Hipp wrote...
Version 3.8.6 was originally scheduled for September. But the change log
(
http://www.sqlite.org/draft/releaselog/current.html) is getting rather
long
and there are a number of important bug fixes. So we might try to get
3.8.6 out the door sooner rather than later.
There is an issue that if entry is selected in Table view then editing in
Query view and clicking delete key then it doesn't delete query but asks to
delete database entry which is not expected behavior.
___
sqlite-users mailing list
On Wed, Jul 30, 2014 at 8:53 AM, Oto _ oto...@gmail.com wrote:
There is an issue that if entry is selected in Table view then editing in
Query view and clicking delete key then it doesn't delete query but asks to
delete database entry which is not expected behavior.
It sounds as if you are
-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Oto _
Sent: Wednesday, July 30, 2014 8:53 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] Sqlite querie delete bug
There is an issue that if entry is selected in Table view then editing in Query
view and clicking delete
hi
C:\!dc-db\db-sqlite-corrupt\db-uniq-bugsqlite3 --version
3.8.5 2014-06-04 14:06:34 b1ed4f2a34ba66c29b130f8d13e9092758019212
C:\!dc-db\db-sqlite-corrupt\db-uniq-bugsqlite3.exe FlylinkDC.sqlite
0test-uniq-3.sql
CREATE TABLE fly_hash_block(tth_id integer PRIMARY KEY NOT NULL, tth number
NOT
On Wed, 30 Jul 2014 09:10:29 +0400
Pavel Pimenov pavel.pime...@gmail.com wrote:
CREATE TABLE fly_hash_block(tth_id integer PRIMARY KEY NOT NULL, tth
number NOT NULL);
INSERT INTO fly_hash_block VALUES(1,1);
INSERT INTO fly_hash_block VALUES(2,2);
INSERT INTO fly_hash_block VALUES(3,2);
I think the point is that attempting to create the unique index should fail
(with an error) and the index not be created rather than creating a unique
index with duplicates (or whatever it is doing) causing subsequent queries to
return incorrect results.
On Wed, 30 Jul 2014 09:10:29 +0400
To whom it may concern,
We are using SQLite 3.7.13 with an amalgamation version of sqlite3.c. We
discovered a type mismatch security issue with a recent Fortify scan. The
problem is on lines 22407, 51807, 63005, 93150 of sqlite3.c.
For example, the function strHash() in sqlite3.c is declared
On Fri, Jul 25, 2014 at 9:50 AM, Yunjiao Xue yunjiao...@hotmail.com wrote:
To whom it may concern,
We are using SQLite 3.7.13 with an amalgamation version of sqlite3.c. We
discovered a type mismatch security issue with a recent Fortify scan. The
problem is on lines 22407, 51807, 63005, 93150
On Thu, Jul 17, 2014 at 5:10 AM, Micka mickamus...@gmail.com wrote:
Well,
All of my process are using Mutex to protect sqlite from concurrent access.
What kind of mutex are you using that works across processs? All the
mutexes I know about only work for a single process.
--
D. Richard
Sorry, I mean semaphore = sem_open(pszSemaphoreName, O_CREAT, S_IRWXU |
S_IRWXG | S_IRWXO, 0);
On Fri, Jul 18, 2014 at 11:45 AM, Richard Hipp d...@sqlite.org wrote:
On Thu, Jul 17, 2014 at 5:10 AM, Micka mickamus...@gmail.com wrote:
Well,
All of my process are using Mutex to protect
Richard Hipp wrote:
On Thu, Jul 17, 2014 at 5:10 AM, Micka mickamus...@gmail.com wrote:
Well,
All of my process are using Mutex to protect sqlite from concurrent access.
What kind of mutex are you using that works across processs? All the
mutexes I know about only work for a single
Well,
All of my process are using Mutex to protect sqlite from concurrent access.
That why I don't understand why I get SQLITE_BUSY error .
Micka,
On Tue, Jul 8, 2014 at 11:44 PM, Simon Slavin slav...@bigfraud.org wrote:
On 8 Jul 2014, at 8:39pm, Micka mickamus...@gmail.com wrote:
i'm
i sent a sqlite db from server to client using c program .. in this how i
set a password for the db to open in sqlite browser...
On Fri, May 9, 2014 at 6:05 PM, Simon Slavin slav...@bigfraud.org wrote:
On 9 May 2014, at 1:23pm, Sky Meena sky.me...@gmail.com wrote:
i working in server
On 17 Jul 2014, at 10:10am, Micka mickamus...@gmail.com wrote:
Well,
All of my process are using Mutex to protect sqlite from concurrent access.
That why I don't understand why I get SQLITE_BUSY error .
Micka,
On Tue, Jul 8, 2014 at 11:44 PM, Simon Slavin slav...@bigfraud.org
On 17 Jul 2014, at 10:47am, Sky Meena sky.me...@gmail.com wrote:
i sent a sqlite db from server to client using c program
SQLite does not involve a server. It runs on one computer and takes
instructions only from that computer.
.. in this how i
set a password for the db to open in
On Thu, 17 Jul 2014 15:17:07 +0530, Sky Meena sky.me...@gmail.com
wrote:
i sent a sqlite db from server to client using c program .. in this how i
set a password for the db to open in sqlite browser...
In short: you can't.
SQLite does not implement SQL access control (GRANT/REVOKE). The
i will explain.. i created a sqlite db.. now i should tranfer it also
transfered.. while opening a db it should ask password.. for that while
creating db i should enable some password or read only mode..
On Thu, Jul 17, 2014 at 4:27 PM, Kees Nuyt k.n...@zonnet.nl wrote:
On Thu, 17 Jul 2014
thank you.. how can i use sqlite_db_readonly function..
On Thu, Jul 17, 2014 at 5:40 PM, Sky Meena sky.me...@gmail.com wrote:
i will explain.. i created a sqlite db.. now i should tranfer it also
transfered.. while opening a db it should ask password.. for that while
creating db i should
Hi Sky,
The read-only mode for opening the database is simply you telling the sqlite engine that you do not intend to write to this database
and so it doesn't try to acquire write-locks on it during the life of that connection, and your connection cannot make changes to it
in any way (even if
Hi,
I am building a winrt app using sqlite, I need to use FTS3/FTS4 with
unicode61 tokenize.
Throws error when i try to create a table shown below with tokenize
unicode61
create virtual table if not exists Address USING fts4 (Address1 TEXT,
DATE_CREATED INTEGER,CHANGED_DATE
As promised last week, I set out to do testing of memory usage on SQLite DBs.
A quick overview of the methods used follows (in short mostly as to avoid the
boring bits):
Create three tables, one main table storing 1 Int PK, 2 columns of random string data along with 2 Int keys that link the
On Fri, Jul 11, 2014 at 12:23 AM, RSmith rsm...@rsweb.co.za wrote:
Next up, I proceeded to use the 64-bit DLL in a 64-bit build of the
testbed and redid the DB and data population (just in case the DB itself
was affected by 32-bitness, though unlikely since both DBs were equal in
size and
On 10 Jul 2014, at 11:23pm, RSmith rsm...@rsweb.co.za wrote:
Special Omission: I was unable to devise a query or cache requirement larger
than the machine's physical memory and thus unable to test it for function
and error reporting - but I would assume when you plan to use insanely large
I do understand its a bad DB design and i should be actually doing what you
have mentioned. But as mentioned in SQLite site it is possible to increase
column limit during compile time. So i just need to know out of curiosity
how it can be done in SQLite jar (jdbc) 3.7.2?
--
View this message in
Hi,
when I run this query:
select * from (
WITH Processes AS (
SELECT DISTINCT d.SummaryId, d.ProcessId, d.Client
FROM ProfileDetail d
WHERE d.Client 'unknown'
)
SELECT q.*, p.Client
FROM QueryTrace q
INNER JOIN Processes p ON q.SummaryId = p.SummaryId
AND q.ProcessId
Output from
.explain
explain query plan select...
explain select...
would be interesting
-Ursprüngliche Nachricht-
Von: Nissl Reinhard [mailto:reinhard.ni...@fee.de]
Gesendet: Dienstag, 08. Juli 2014 11:46
An: sqlite-users@sqlite.org
Betreff: [sqlite] sqlite-3.8.5: query takes quite
Hi, How can I find this in the statement ? Will BEGIN immediate get
an exclusive lock.? or like Igor specified if I call Delete * from where
0 will it be able to get an immediate lock on the table. Srikanth From
docs: After a BEGIN IMMEDIATE, no other database connection will be
Am using SQLite jdbc 3.7.2 and in a scenario i have a table with 2300 column
which eventually throwed too many columns exception since the maximum
allowed column count is 2000.
Is there any workaround available for this? Maybe a query to increase column
limit in SQLite jdbc?
Thanks in advance!
Gunter
Gesendet: Dienstag, 8. Juli 2014 11:58
An: General Discussion of SQLite Database
Betreff: Re: [sqlite] sqlite-3.8.5: query takes quite a while to execute
although there is a limit 0 clause
Output from
.explain
explain query plan select...
explain select...
would be interesting
201 - 300 of 6223 matches
Mail list logo