Hi,
Did the on-disk file-format of SQLite databases change between version 3.5.4
and the latest (3.7.13)?
Will I be able to back to 3.5.4 without any special conversions?
Thanks,
Folkert van Heusden
De informatie verzonden met dit emailbericht is uitsluitend bestemd
voor de geadresseerde.
On 11/06/2012 21:48, Larry Brasfield wrote:
On June 11, rick wrote:
Something I noticed today:
sqlite select * FROM words WHERE word = id;
nothing
sqlite select * FROM words WHERE word = 'id';
13556|id
sqlite .schema
CREATE TABLE words (
id integer primary key,
word
Hi, I am new to SQLITE
Would be using Microsoft VS 2008 2010
Is it possible to safely use multiple threads in a process with each
thread making
its own connection to the same database
rc = sqlite3_open(file::memory:?cache=shared, db);
ie. does sqlite implement an alternative to f_lock
On Tue, Jun 12, 2012 at 3:54 AM, Heusden, F. van
folkert.van.heus...@mcom-nl.com wrote:
Hi,
Did the on-disk file-format of SQLite databases change between version
3.5.4 and the latest (3.7.13)?
Will I be able to back to 3.5.4 without any special conversions?
The SQLite file format
On 06/12/2012 05:41 PM, Nicholas Thompson wrote:
Hi, I am new to SQLITE
Would be using Microsoft VS 2008 2010
Is it possible to safely use multiple threads in a process with each
thread making
its own connection to the same database
rc = sqlite3_open(file::memory:?cache=shared,db);
Should
Hi Kevin,
I understand the 'NOT NULL' column constraint and the syntax diagram and
text describe it quite well. What isn't described is whether or not
specifying simply 'NULL' is truly supported. For example, the following
create table statement is accepted by SQLite and appears to behave
On Tue, Jun 12, 2012 at 7:04 AM, Paul Medynski pmedyn...@rim.com wrote:
Hi Kevin,
I understand the 'NOT NULL' column constraint and the syntax diagram and
text describe it quite well. What isn't described is whether or not
specifying simply 'NULL' is truly supported. For example, the
On 12-Jun-2012 08:08, Richard Hipp wrote:
On Tue, Jun 12, 2012 at 7:04 AM, Paul Medynskipmedyn...@rim.com wrote:
Hi Kevin,
I understand the 'NOT NULL' column constraint and the syntax diagram and
text describe it quite well. What isn't described is whether or not
specifying simply 'NULL' is
On 12 Jun 2012, at 9:52am, rick jansm...@xs4all.nl wrote:
Well, I'm not entirely a casual user, but I don't know the SQL-92 standard
or it's successors. I'm an engineer, and sqlite for me is a tool. Above
query was used a long time in a MySQL DB, where it works as (I) expected.
SQL (note
I dont' see the difference between a a single database and 2 in your example.
I would claim the delete is most certainly not unintended.
If you had just one database a user could come in one hour later and delete the
record you updated. I realize in the pure sense this may not be desirable
That's the nice thing about standards...there are so many to choose from...:-(
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems
___
sqlite-users mailing
Nicholas Thompson nick.john.thomp...@googlemail.com wrote:
Is it possible to safely use multiple threads in a process with each
thread making
its own connection to the same database
rc = sqlite3_open(file::memory:?cache=shared, db);
Every time you connect to a :memory: database, a new
On Tue, Jun 12, 2012 at 8:32 AM, Igor Tandetnik itandet...@mvps.org wrote:
Nicholas Thompson nick.john.thomp...@googlemail.com wrote:
Is it possible to safely use multiple threads in a process with each
thread making
its own connection to the same database
rc =
There was a somehow recent change in the snippets algorithm, it used to
return snippets from a number of columns in a single row if there were
multiple matches, separated with Now, it will try to find a fragment
of the row that contains ALL search terms, using snippets from the other
columns
Hello List,
I'm quite new to SQLite.
I try to convert from a MySQL DB to SQLite.
I've already done several changes to the MySQL dump but now I'm a bit stuck.
If I try to insert a row containing two subsequent exclamation marks
!!, I get the error `SQL error: unrecognized token: !!`.
I haven't
On 6/12/2012 2:45 PM, Alexander Koeppe wrote:
sqlite INSERT INTO 'gb' VALUES ('Die Alex','http://','Heisann Jungs!
\n\nIch drück euch alle meine Daumen für'
This aprostrophe terminates the string literal. The rest is part of the
SQL statement, and of course it's nonsense.
Make it für''s
On 13 Jun 2012, at 1:45am, Igor Tandetnik itandet...@mvps.org wrote:
On 6/12/2012 2:45 PM, Alexander Koeppe wrote:
sqlite INSERT INTO 'gb' VALUES ('Die Alex','http://','Heisann Jungs!
\n\nIch drück euch alle meine Daumen für'
This aprostrophe terminates the string literal. The rest is part
Am 13.06.2012 02:45, schrieb Igor Tandetnik:
On 6/12/2012 2:45 PM, Alexander Koeppe wrote:
sqlite INSERT INTO 'gb' VALUES ('Die Alex','http://','Heisann Jungs!
\n\nIch drück euch alle meine Daumen für'
This aprostrophe terminates the string literal. The rest is part of the
SQL statement,
hello, when I use sqlite3_key to crypt my sqlite database my.db and the key
is abc,
and when I use sqlitespy to open the database, then sqlitespy require me to
input the key,
when I input abc to it,but show me couldn't open the database, I don't know
why,
these following function is the
On 13 Jun 2012, at 2:27am, YAN HONG YE yanhong...@mpsa.com wrote:
hello, when I use sqlite3_key to crypt my sqlite database my.db and the key
is abc,
and when I use sqlitespy to open the database, then sqlitespy require me to
input the key,
when I input abc to it,but show me couldn't open
So for some time I've been searching for a general-purpose SQLite bridge for
javascript. When I need this I'm generally keeping the database on a computer
which is also a web server, so I just use a PHP file which I've written to act
as a bridge: make JavaScript execute an HTTP operation to
21 matches
Mail list logo