posting an update here --
I DROPped the insert_fts TRIGGER, and now the db works fine. No more
crash on inserting a new row. So, the error was because of the trigger
CREATE TRIGGER insert_fts
AFTER INSERT ON pages
BEGIN
INSERT INTO fts_pages (rowid, page_text)
VALUES (new.page_id,
Dan,
On 3/2/08, Dan <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I tried this script here with the latest CVS version and
> it didn't crash:
>
>CREATE TABLE pages(page_id INTEGER PRIMARY KEY, page_name TEXT,
> page_text TEXT);
>CREATE VIRTUAL TABLE fts_pages USING fts3(page_name,
On Mar 2, 2008, at 4:42 AM, Shawn Wilsher wrote:
> Hey all,
>
> Over at Mozilla we've been seeing a large amount of crashes in
> sqlite3_enable_shared_cache. The stack frames don't make a whole lot
> of sense to me, so I thought I'd inform you and hope that you might
> have a better idea as to
Hi,
I tried this script here with the latest CVS version and
it didn't crash:
CREATE TABLE pages(page_id INTEGER PRIMARY KEY, page_name TEXT,
page_text TEXT);
CREATE VIRTUAL TABLE fts_pages USING fts3(page_name, page_text);
CREATE TRIGGER delete_fts
AFTER DELETE ON pages
BEGIN
On Mar 3, 2008, at 12:55 AM, Kee Wee wrote:
>
> I would be very interested to follow-up this subject closely,
> as we are actually performing the same kind of work as you are
> looking for.
>
> One of the answer you got was that it is not possible to reuse a
> prepared
> statement from one
On Thu, 21 Feb 2008 11:40:45 -0700, Dennis Cote
<[EMAIL PROTECTED]> wrote:
>select exists (SELECT * FROM sqlite_master WHERE type='table' AND
>lower(name)=?)
>
>This will always return one row with one column with a value that is
>either 0 or 1.
Thanks guys for the help.
On Sun, 2 Mar 2008 21:07:03 -0500, "Samuel Neff"
<[EMAIL PROTECTED]> wrote:
> I would go the ADO.NET route 'cause it'll fit into your .NET application much
>better. The overhead is minimal compared to the normal cost of running
>database queries (in any database).
The reason I'm concerned about
The System.Data.SQLite wrapper that others have mentioned is wonderful. I
would go the ADO.NET route 'cause it'll fit into your .NET application much
better. The overhead is minimal compared to the normal cost of running
database queries (in any database).
However, if you really want to skip
Gilles
I am a .Net developer and I use an excellent implementation
System.Data.SQLite http://sqlite.phxsoftware.com/
Regards
On Mon, Mar 3, 2008 at 7:50 AM, Gilles Ganault <[EMAIL PROTECTED]>
wrote:
> On Sun, 2 Mar 2008 08:13:18 -0800 (PST), Jalil Vaidya
> <[EMAIL PROTECTED]> wrote:
> >There
I have a fairly simple db with fts3
TABLE pages (page_id INTEGER PRIMARY KEY, page_name TEXT, page_text TEXT);
VIRTUAL TABLE fts_pages USING fts3 (page_name, page_text);
and the following triggers --
CREATE TRIGGER delete_fts
AFTER DELETE ON pages
BEGIN
DELETE FROM fts_pages WHERE rowid =
I think you are misinterpreting this. It says:
"Every time the database is opened, all CREATE INDEX statements are
read from the sqlite_master table and used to regenerate SQLite's
internal representation of the index layout."
This does not say it recreates the index, just the internal
Hello sqlite-users,
is it true, that in sqlite3 indices are not stored in the database-file?
When reading the section http://sqlite.org/lang_createindex.html it
seems that CREATE INDEX statements are only stored in the sqlite_master
table and the index will be generated every time the database
On Sun, 2 Mar 2008 08:13:18 -0800 (PST), Jalil Vaidya
<[EMAIL PROTECTED]> wrote:
>There are ADO.NET providers available for SQLite.
Thanks guys for the input.
___
sqlite-users mailing list
sqlite-users@sqlite.org
P Kishor wrote:
>
> try
>
> SELECT * FROM dictionary WHERE Word = '"eleven"';
>> I am sure this is due to the fact that I am an idiot, but I could use
>> some help.
>>
It worked.
I was correct. I am an idiot.
Thank you for the help. Lesson learned.
George
---
On 3/2/08, 7150 <[EMAIL PROTECTED]> wrote:
> I have created a database: norsk.db
>
> a table: dictionary
>
> sqlite> .schema
> CREATE TABLE dictionary(Ord varchar(255), Word varchar(255), GV
> varchar(255), Part varchar(255), PrTDS varchar(255), PaTIP varchar(255),
> PPDP varchar(255));
>
I have created a database: norsk.db
a table: dictionary
sqlite> .schema
CREATE TABLE dictionary(Ord varchar(255), Word varchar(255), GV
varchar(255), Part varchar(255), PrTDS varchar(255), PaTIP varchar(255),
PPDP varchar(255));
sqlite>
The table contents were imported from a UTF-8 csv file.
I would be very interested to follow-up this subject closely,
as we are actually performing the same kind of work as you are looking for.
One of the answer you got was that it is not possible to reuse a prepared
statement from one database to another.
This answer was too quick, and did not
On 2-Mar-2008, at 3:55 AM, Rael Bauer wrote:
> It seems that fts3 is now (3.5.6) included in the windows
> binary .dll. I'd like to know since when was fts3 included in the
> binary?
>
> Also, since when did the amalgamation include the fts3 sources?
According to the web page, 3.5.3.
There are ADO.NET providers available for SQLite. That would be the way to go
if you want to use SQLite in .NET (any language). Check out these links:
http://sqlite.phxsoftware.com/
http://adodotnetsqlite.sourceforge.net/
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers - Scroll down to .NET
"Adam Megacz" <[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
> "Igor Tandetnik" <[EMAIL PROTECTED]> writes:
>>> I have an application that absolutely must not return from a certain
>>> call until the results of an update are safely committed to disk.
>
>> Open a separate connection to
> I don't know anything about .Net, and I'd like to build a quick app
> with Visual Studio 2005 or 2008 to check how well it performs with
> SQLite. If performance and deployment prove to be good enough, we'll
> use VB.Net for new projects and finally dump VB6.
I have almost no experience
Hi,
It seems that fts3 is now (3.5.6) included in the windows binary .dll. I'd
like to know since when was fts3 included in the binary?
Also, since when did the amalgamation include the fts3 sources?
Thank you
Rael
-
Looking
En/na Jerry Krinock ha escrit:
> How can I manually lock the database using the C API? I can't find
> any "lock" function.
In think you could just execute a "BEGIN EXCLUSIVE" query, then do your
thing then execute a "COMMIT" (or a "ROLLBACK" if something failed).
Bye
--
Luca Olivetti
Jerry Krinock wrote:
> That's easy enough to detect with API from the OS, but a conflict can
> still occur if they launch and start reading while I am in the middle
> of writing something I don't want to stop. I need to lock the
> database so that they get SQLITE_BUSY until I'm done.
>
>
"Igor Tandetnik" <[EMAIL PROTECTED]> writes:
>> I have an application that absolutely must not return from a certain
>> call until the results of an update are safely committed to disk.
> Open a separate connection to the same database, perform the update on
> this connection.
I am in an
Hello,
due to my recent problem
http://thread.gmane.org/gmane.comp.db.sqlite.general/35992
I tried to download 3.5.6 and compiled it with --enable-threadsafe.
While with 3.3.8 a vacuum cleared all errors reported by "PRAGMA
integrity_check", 3.5.6 doesn't:
$ sqlite3 almacen.db.malo
SQLite
26 matches
Mail list logo
