> 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 power
> 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 f
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 she
-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
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
-Da
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
http://sqlite.org:8080/cgi-bin/mailman/
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 3.5.
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, J
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 on AFP?
Following up:
>
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
temp_store_direc
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
___
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
http://www.s
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 Visua
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-users@sqlite
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 Object
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 Edi
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 E
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, d
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 th
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 col
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 th
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 column_i
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 t
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
b
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,
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 a
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,
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 increm
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 lo
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. T
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,
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.
unl
> 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 va
"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 expe
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, a
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
"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
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 s
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 sqli
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 sy
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
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 SQL
42 matches
Mail list logo