[sqlite] HTML5 database commands as a JavaScript-SQLite bridge

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

Re: [sqlite] rekey

On 13 Jun 2012, at 2:27am, YAN HONG YE 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

[sqlite] rekey

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

Re: [sqlite] Problem with SQL error: unrecognized token: "!!"

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

Re: [sqlite] Problem with SQL error: unrecognized token: "!!"

On 13 Jun 2012, at 1:45am, Igor Tandetnik 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

Re: [sqlite] Problem with SQL error: unrecognized token: "!!"

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

[sqlite] Problem with SQL error: unrecognized token: "!!"

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

Re: [sqlite] FTS4 Questions

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

Re: [sqlite] (no subject)

On Tue, Jun 12, 2012 at 8:32 AM, Igor Tandetnik wrote: > Nicholas Thompson wrote: >> Is it possible to safely use multiple threads in a process with each >> thread making >> its own connection to the same database >> >> rc =

Re: [sqlite] (no subject)

Nicholas Thompson 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", ); Every time you connect to a :memory: database, a

Re: [sqlite] Quoting "id" versus 'id' in query

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

Re: [sqlite] Features of SQLite question

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

Re: [sqlite] Quoting "id" versus 'id' in query

On 12 Jun 2012, at 9:52am, rick 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

Re: [sqlite] Specifying a nullable column

On 12-Jun-2012 08:08, Richard Hipp wrote: On Tue, Jun 12, 2012 at 7:04 AM, Paul Medynski 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'

Re: [sqlite] Specifying a nullable column

On Tue, Jun 12, 2012 at 7:04 AM, Paul Medynski 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,

Re: [sqlite] Specifying a nullable column

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

Re: [sqlite] (no subject)

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",); Should

Re: [sqlite] 3.5.4 to 3.7.13 and back(!)

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

[sqlite] (no subject)

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", ); ie. does sqlite implement an alternative to f_lock

Re: [sqlite] Quoting "id" versus 'id' in query

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"; >> >> >> sqlite> select * FROM words WHERE word = 'id'; >> 13556|id >> >> sqlite> .schema >> CREATE TABLE words ( >> id integer primary key,

[sqlite] 3.5.4 to 3.7.13 and back(!)

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.