Re: [sqlite] integrity_check: Beating the system

> All: > I need to check a database for readability before my application > starts. I was originally going to keep an MD5 on the database and > check it each time at powerup. This seems to take a great deal of > time so instead I thought abou having the database do an integrity > check at

Re: [sqlite] integrity_check: Beating the system

> Couldn't you go ahead and do your quick check on startup and then do the > integrity check later when the database is otherwise unoccupied? I was thinking of doing a hybrid as you suggested. > If your database is smaller than system memory then there is also value > in just reading the entire

Re: [sqlite] Client/Srever SQLite

slowness is fixed. Can't tell the difference between client/server speed from library. On Sat, Jun 14, 2008 at 8:32 PM, Alex Katebi <[EMAIL PROTECTED]> wrote: > Hi All, > >Looks like there is some interest. I will announce when I release it. > Currently I am developing an interactive user

Re: [sqlite] integrity_check: Beating the system

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Rich Rattanni wrote: > This seems to take a great deal of > time so instead I thought abou having the database do an integrity > check at powerup, however this too takes a great deal of time. Couldn't you go ahead and do your quick check on startup

Re: [sqlite] SQLite3 to SQLite2?

On Mon, Jun 16, 2008 at 6:18 PM, Gilles Ganault <[EMAIL PROTECTED]> wrote: > We have an application that can only read SQLite2 databases. Is there > an easy way to convert a SQLite3 database file into the SQLite2 > format? This might work: echo .dump | sqlite3 input.db | sqlite output.db

[sqlite] SQLite3 to SQLite2?

Hello We have an application that can only read SQLite2 databases. Is there an easy way to convert a SQLite3 database file into the SQLite2 format? Thank you. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Display all the columns of the table in single line.

On Mon, Jun 16, 2008 at 04:52:56PM -0700, Joanne Pham scratched on the wall: > Thanks Igor, > Do I need to upgrade to latest vresion of SQLite? > I have to rebuild the SQLite library again. What version that I > need to upgrade to for group_concat function group_concat() became official in

Re: [sqlite] Display all the columns of the table in single line.

Thanks Igor, Do I need to upgrade to latest vresion of SQLite? I have to rebuild the SQLite library again. What version that I need to upgrade to for group_concat function Thanks, JP - Original Message From: Igor Tandetnik <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Monday,

[sqlite] Fwd: SQLite bug on AFP?

Can the Mac OS X locking problem please be fixed in the standard build and source code? See below. Thanks, Tom BareFeet From: BareFeet <[EMAIL PROTECTED]> Date: 12 June 2008 10:50:40 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite bug

[sqlite] temp_store_directory issue with SQLite 3.5.9

Hello, We came across an issue last week with SQLite 3.5.9 on Windows. A program stopped working on Windows when we upgraded from SQLite 3.4.1 to SQLite 3.5.9. It turned out that the cause was that SQLite 3.5.9 (and perhaps SQLite 3.5.x in general) was not fully honoring the

Re: [sqlite] Display all the columns of the table in single line.

Joanne Pham <[EMAIL PROTECTED]> wrote: > I got this error message. I had 3.5.2 SQLite. > sqlite> select group_concat(appName) from CDB.appMapTable; > SQL error: no such function: group_concat Upgrade to more recent SQLite version. group_concat is fairly new. Igor Tandetnik

Re: [sqlite] Source code for 3.4.2

Okay, I found an old post on mail-archive.com (http://www.mail-archive.com/sqlite-users@sqlite.org/msg02844.html) which stated that I should just use the date. So for version 3.4.2, I used 2007-08-13 18:00 UTC which is marked at Version 3.4.2 according to the timeline of the wiki (see

[sqlite] Strange issue with sqlite3_column_text16 on Mac

I'm using sqlite3 for the first time and I've been having an aggravating problem I hope someone can help with. I'm doing a simple query on a database I created using the sqlite3 command line utility. sqlite3_column_text16 produces garbage on Mac OS 10.5 using XCode 3, but with windows xp and

Re: [sqlite] Display all the columns of the table in single line.

Hi Igor, I got this error message. I had 3.5.2 SQLite. sqlite> select group_concat(appName) from CDB.appMapTable; SQL error: no such function: group_concat Any ideas what was the problem here. Thanks, JP - Original Message From: Igor Tandetnik <[EMAIL PROTECTED]> To:

[sqlite] Segmentation Fault when using mod_python / mod_wsgi

I'm trying to solve a RedHat Enterprise Linux 4 issue where I have built, from source, Python 2.5.2, mod_python v3.2.8, and SQLite 3.5.9. SQLite works fine in the Python 2.5.2 interpreter, but when running from mod_python (I also tried mod_wsgi), I get a segmentation fault in the Python file

[sqlite] Windows VC++ 2008 Express Edition compile howto?

Hi all, I would like to compile sqlite and spatialite using Windows VC++ 2008 Express Edition. I looked around on the website and wiki but knowing almost nothing about these tools there was no obvious answer to me. Does anyone have a step by step howto compile sqlite with VC++ 2008 Express

[sqlite] Source code for 3.4.2

Sorry ahead of time for a silly question, but how do I get version 3.4.2 of the source code? I didn't see any tags in CVS (but I'm not a CVS user, so that may be user error on my part). Any help with the exact command would be appreciated. Thanks, Eric Holmberg Applications Engineer, Arrow

Re: [sqlite] DB does not get updated after many writes

sethuarun <[EMAIL PROTECTED]> wrote: > I have a peculiar problem with sqlite library. I built an application > using sqlite for DB operations. The application keeps updating the > DB. Everything goes fine for around one or two days. But after that > DB does not get updated at all. At this point,

[sqlite] Nested select performance issues

Hello, I am developing a small app for determining the available combinations of reagents stored in a sqlite database where no two reagents have the same conjugate. I have tried two approaches to this query, one has very good performance and the other is very poor. I am trying to understand why

Re: [sqlite] SQL question

Gregor, why did you do that more complicated version with the subquery and sorting et al? The short version that RBS would have worked a lot better; you just need to say? update binary_report_fmt set column_id = column_id + 1 where column_id > 1; ... and then insert a new row with

[sqlite] integrity_check: Beating the system

All: I need to check a database for readability before my application starts. I was originally going to keep an MD5 on the database and check it each time at powerup. This seems to take a great deal of time so instead I thought abou having the database do an integrity check at powerup, however

Re: [sqlite] SQL question

On Mon, 16 Jun 2008 10:36:18 -0600, you wrote: >Hi, thanks this is great. Of course I forgot to mention that the id >is a primary key, so I get an error about duplicate primary keys. > >I tried this: > >update binary_report_fmt set column_id = column_id + 1 where column_id >= (select

Re: [sqlite] Structural detection of AUTOINCREMENT

Thanks for your reply (and also thanks, Richard, for your reply about sqlite3_table_column_metadata) I've interspersed a few remarks, please see below. On Mon, Jun 16, 2008 at 4:50 PM, Dennis Cote <[EMAIL PROTECTED]> wrote: > Csaba wrote: >> Is there any way to detect, based strictly on querying

Re: [sqlite] SQL question

Hi, thanks this is great. Of course I forgot to mention that the id is a primary key, so I get an error about duplicate primary keys. I tried this: update binary_report_fmt set column_id = column_id + 1 where column_id = (select column_id from binary_report_fmt where column_id >= 3 order

Re: [sqlite] DB does not get updated after many writes

I have a peculiar problem with sqlite library. I built an application using sqlite for DB operations. The application keeps updating the DB. Everything goes fine for around one or two days. But after that DB does not get updated at all. Strangely those sqlite library calls don't return any

Re: [sqlite] SQL question

update table set id = id + 1 WHERE id > 1 RBS > Sorry about this, but this is a SQL question and not a SQLite specific > question. > > Is there a way to increment a value in a table in-situ. Without > reading it, incrementing it, writing it? > > I need to insert an entry into a table, it has

Re: [sqlite] SQL question

On 6/16/08, Gregor Brandt <[EMAIL PROTECTED]> wrote: > Sorry about this, but this is a SQL question and not a SQLite specific > question. > > Is there a way to increment a value in a table in-situ. Without > reading it, incrementing it, writing it? > > I need to insert an entry into a table,

[sqlite] SQL question

Sorry about this, but this is a SQL question and not a SQLite specific question. Is there a way to increment a value in a table in-situ. Without reading it, incrementing it, writing it? I need to insert an entry into a table, it has an id, all entries with id's >= the id need to be

Re: [sqlite] Implementing fast database rotation

Al wrote: > > I'm using sqlite to implement a fast logging system in an embbeded system. For > mainly space but also performance reason, I need to rotate the databases. > > The database is queried regularly and I need to keep at least $min rows in > it. > > What I plan, is inside my logging

Re: [sqlite] Structural detection of AUTOINCREMENT

Csaba wrote: > Is there any way to detect, based strictly on querying the structure of a > table/database > whether there is an AUTOINCREMENT set? That is to say, without analyzing > the > original SQL creation statement, and without inserting a new element into > the database. > Yes there is.

[sqlite] DB does not get updated after many writes

I have a peculiar problem with sqlite library. I built an application using sqlite for DB operations. The application keeps updating the DB. Everything goes fine for around one or two days. But after that DB does not get updated at all. Strangely those sqlite library calls don't return any error,

Re: [sqlite] what's the difference between exec and prepare-bind-step(C api)?

On Mon, Jun 16, 2008 at 06:07:46AM -0500, John Stanton scratched on the wall: > You are expecting a miracle to ask for help without being allowed to > report the problem. > > Sqlite3_exec just encapsulates prepare and step. If your code runs > slower you have a logic error somewhere.

Re: [sqlite] UPDATE TRIGGER not called on INSERT OR REPLACE statement

> Well, if I epxlicitly run DELETE and then INSERT, would you also expect > an UPDATE trigger to run? After all, "on the whole" the operation is an > update. Oh!! May be I was wrong in thinking that INSERT OR REPLACE would keep the PRIMARY KEY as it is.. Am a stupid guy.. Thanks Igor for your

Re: [sqlite] UPDATE TRIGGER not called on INSERT OR REPLACE statement

"Bharath Booshan L" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > IF INSERT OR REPLACE statement performs REPLACE operation, then again > insert_trigger is being invoked, which as per the documentation ( i.e > it > actually performs DELETE and INSERT) is fine. > > Am I wrong in

[sqlite] UPDATE TRIGGER not called on INSERT OR REPLACE statement

Hello Sqlite users, experts, I am in a state of confusion and I request you to help me out please. Can "INSERT OR REPLACE" trigger if actual operation performed is REPLACE? Say , For example, if I have 2 triggers on table T1, one trigger, say insert_trigger, is set to trigger after INSERT,

Re: [sqlite] SQlite and C works with "like" but not with "="

Thanks again Dan and Igor. Since I don't need to write to the database (only read from it atm), collate binary will do nicely. I'll keep an eye on those error messages in future! Dan On Sun, 15 Jun 2008 09:13:52 +0100, Dan <[EMAIL PROTECTED]> wrote: > On Jun 15, 2008, at 8:55 AM, Daniel White

Re: [sqlite] Something to think about: Saving Select ID Lists

"MoDementia" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > One thing that I really miss form another database is the ability to > reuse select statements. > > Select * FROM Transactions Where DateTime Between x and y Saving > Unique DataID to 1 How about create temp view view1 as

Re: [sqlite] AUTOINCREMENT detection

On Jun 16, 2008, at 4:42 AM, Csaba wrote: > Hi, I didn't get a response to my first post to this group > and I didn't get a copy, so perhaps it didn't go through... > > Is there any way to detect, based strictly on querying > the structure of a table/database whether there is an > AUTOINCREMENT

Re: [sqlite] what's the difference between exec and prepare-bind-step(C api)?

You are expecting a miracle to ask for help without being allowed to report the problem. Sqlite3_exec just encapsulates prepare and step. If your code runs slower you have a logic error somewhere. Jong-young Park wrote: > Deal all, > > I have used some SQLite application with sprintf and

Re: [sqlite] [newbie] Compiling for Windows CE

David Stephenson a écrit : > Hi, > > I'm trying to compile 3.5.9 to Windows CE using embedded C++ 4.0 and I get > the following error: > Hello David, You probably should compile for a console project ( or a dll it depends) Noël > corelibc.lib(pegwmain.obj) : error LNK2019: unresolved external

[sqlite] [newbie] Compiling for Windows CE

Hi, I'm trying to compile 3.5.9 to Windows CE using embedded C++ 4.0 and I get the following error: corelibc.lib(pegwmain.obj) : error LNK2019: unresolved external symbol _WinMain referenced in function _WinMainCRTStartup How can I resolve this? David

[sqlite] AUTOINCREMENT detection

Hi, I didn't get a response to my first post to this group and I didn't get a copy, so perhaps it didn't go through... Is there any way to detect, based strictly on querying the structure of a table/database whether there is an AUTOINCREMENT set? That is to say, without analyzing the original

[sqlite] wtl list view article on codeproject

Hello, I've written a small article to show how to connect sqlite to a wtl listview on windows. http://www.codeproject.com/KB/list/alphaview.aspx I hope it will help somebody Best wishes Noël Frankinet ___ sqlite-users mailing list