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 POS
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 couldn't open the data
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 s
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 state
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 rest is part of the SQL
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 (t
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'
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
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 = sqlite3_open("file::memory:?cache=shared", &db);
>
> Every time you conn
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", &db);
Every time you connect to a :memory: database, a new in-memory database is
created.
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 l
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 desirabl
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 (note that I'm talking ab
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' is truly supported.
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, the following
> create
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 as
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);
Shou
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
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 espe
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,
>>
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. Ge
21 matches
Mail list logo
