Hi All
Sqlite is not running in pthread. At first time, sqlite_open will execute in
pthread. From next time, no one API is executing.
Please guide me to make SQLite run in pthread.
Please anybody help me.
Thanks Regards
Pramoda.M.A
CREST | KPIT Cummins Infosystems Limited | Bengaluru |
Following 2 statements took 400ms to be excuted on a 350M MIPS CPU and it is
a memory database:
DELETE FROM tblEvent_type WHERE eguid in (SELECT rowid FROM tblEvent_basic
WHERE sguid=11);;
DELETE FROM tblEvent_group WHERE eguid in (SELECT rowid FROM
tblEvent_basic WHERE sguid=11);;
(An index
Pramoda M. A wrote:
Hi All
Sqlite is not running in pthread. At first time, sqlite_open will
execute in pthread. From next time, no one API is executing.
Please guide me to make SQLite run in pthread.
Please anybody help me.
Pramoda ,
Would you please provide some code snip so
Hi,
We r using Fedora Linux 10. Our application is, when any device is inserted,
we will detect that create thread using pthread_create API. Which will find all
MP3 files in the device and extract the metadata present in the mp3 files and
fill a structre and send it to sqlite.
Before
2009/7/10 Pramoda M. A pramod...@kpitcummins.com:
Hi,
We r using Fedora Linux 10. Our application is, when any device is inserted,
we will detect that create thread using pthread_create API. Which will find
all MP3 files in the device and extract the metadata present in the mp3 files
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Pramoda M. A wrote:
This will run in thread. But here, entered and entered 2is printing.
But entered 3 and printing 4 both are not printing.
Some of the printfs are spelt with leading capital P and others with
lower case. Some have a trailing a
YES...
THERE COULD BE SOME SYNTX ERRORS HERE WHAT I HAVE SENT.
Thanks Regards
Pramoda.M.A
CREST | KPIT Cummins Infosystems Limited | Bengaluru | Cell: +91 91640 57663
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Simon
Eberhard, Markus (external) wrote:
I'm using SQLite in my application and I would like to fetch the
whole
result set of a select statement to memory.
I can't use sqlite3_get_table since it doesn't support BLOBs as far
as I know.
Currently I'm using function sqlite3_step to itterate
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Pramoda M. A wrote:
YES...
THERE COULD BE SOME SYNTX ERRORS HERE WHAT I HAVE SENT.
That isn't very polite :-) If your code won't even compile then we can't
tell if those syntax errors are the cause of issues or just a typo in
what you put in.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Eberhard, Markus (external) wrote:
In other
words: minimize the number of accesses to database file (but I'm not
sure if this is possible).
You could use the SQLite backup API to read the entire file into
:memory: (quickly and sequentially) and
Hi,
there is a small typo there: Rick van der Lans (just one a)
The 4th edition did not show up yet ...
Regards,
Arjen
On 2009-07-09 15:50, cmar...@unc.edu wrote:
On Thu, 9 Jul 2009, Rich Shepard wrote:
Rick van der Laans, who wrote the excellent Introduction to SQL, 4th Ed.
(and
Hello,
In version 3.3.6 of sqlite, the functions sqlite3StrICmp and
sqlite3StrNICmp were extern:
/usr/local/libnm -C libsqlite3.so | grep ICmp
0005c63c T sqlite3StrICmp
0005c744 T sqlite3StrNICmp
In more recent versions like the current one (3.6.16), those functions are
intern:
pierr wrote:
Following 2 statements took 400ms to be excuted on a 350M MIPS CPU
and it is a memory database:
DELETE FROM tblEvent_type WHERE eguid in (SELECT rowid FROM
tblEvent_basic WHERE sguid=11);;
DELETE FROM tblEvent_group WHERE eguid in (SELECT rowid FROM
tblEvent_basic WHERE
D. Richard Hipp d...@hwaci.com schrieb im
Newsbeitrag news:64f6bda6-2a04-4d46-aa08-901a6138c...@hwaci.com...
See http://www.fossil-scm.org/ for more information on
fossil. Fossil is self-hosting, btw.
It's a real nice (and small!) SCM and I consider to use it for
the planned LGPL-opening of
How could I know which SQLite3's api is reentrant?
Pavel Ivanov-2 wrote:
Why do you re-post your code as if it's another question not related
to previous one (along with the answer)?
does it mean that the sqlite3's C-api isn't reentrant or thread-safety?
If SQLite is compiled with
On Thu, 9 Jul 2009, Arjen Markus wrote:
there is a small typo there: Rick van der Lans (just one a)
Thank you. I saw that after I sent the message to the list. My apologies
to Rick.
The 4th edition did not show up yet ...
I have a copy on my bookshelf that I purchased last year.
Rich
Hello Rich,
being a countryman of Rick's it was probably easier for me to
spot the typo ;).
Regards,
Arjen
On 2009-07-10 15:14, Rich Shepard wrote:
On Thu, 9 Jul 2009, Arjen Markus wrote:
there is a small typo there: Rick van der Lans (just one a)
Thank you. I saw that after I sent
Actually, my use of the db is much simpler, and I don't need the databases at
all after the program completes.
The db is essentially a backing store for in-memory orders. I.e. I persist the
order to the db and discard the in-memory order when it looks likely I won't
need it (to avoid out of
I googled and checked the archive of this mailing list without finding an
answer to this topic.
Is there a way to automaticaly create a db from a postgres dump? Including
an appropriate conversion of the features that are different in the two
database engines.
Before starting doing it manually I
Is it possible, using SQL, to do comparisions across records?
Suppose that you had 1 field called TAX and you wanted to compare each one
to the previous one.
Record 1 = TAX (45)
Record 2 = TAX (65)
Record 3 = TAX (22)
So using the data above, I would want to compare Record 2 (65) to Record 1
Rick Ratchford r...@amazingaccuracy.com
wrote:
Is it possible, using SQL, to do comparisions across records?
Suppose that you had 1 field called TAX and you wanted to compare
each one to the previous one.
What do you mean by previous one? Records in a table don't have any
implicit ordering.
#-Original Message-
#From: sqlite-users-boun...@sqlite.org
#[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik
#Sent: Friday, July 10, 2009 2:50 PM
#To: sqlite-users@sqlite.org
#Subject: Re: [sqlite] Is it Possible in SQL...
#
#Rick Ratchford r...@amazingaccuracy.com
If you want to use the rowid to order the rows (or an
auto-incrementing primary key field), you could do something like
this:
update tst
set Direction=
(select
case when b.tax tst.tax then Up
when b.tax=tst.tax then Down
else null
end
from tst b
where b.rowid=tst.rowid-1)
Wes
On
Seems there was a question in your reply I didn't catch the first time.
#What do you mean by previous one? Records in a table don't
#have any implicit ordering. Do you have some kind of a
#timestamp field that imposes the order?
The table, each time, has been in order from oldest Date to
This will create another table TmpTable (tax, direction), using the
values from the table MarketTable:
create table TmpTable as
select tax,
(select
case when b.tax MarketTable .tax
then Up
when b.tax=MarketTable .tax
then Down
else null
end
from MarketTable b
where
On 10 Jul 2009, at 9:31pm, Rick Ratchford wrote:
After examining the above, it appears that what this does is modify
the
table itself. So I suppose then that it is not possible to create a
recordset instead that meets what I'm trying to do. If this is the
case,
I'll have to make a copy
#On 10 Jul 2009, at 9:31pm, Rick Ratchford wrote:
#
# After examining the above, it appears that what this does is modify
# the table itself. So I suppose then that it is not possible
#to create
# a recordset instead that meets what I'm trying to do. If
#this is the
# case, I'll have to make
#
#This will create another table TmpTable (tax, direction),
#using the values from the table MarketTable:
#
#create table TmpTable as
#select tax,
#(select
# case when b.tax MarketTable .tax
# then Up
# when b.tax=MarketTable .tax
# then Down
# else null
# end
# from MarketTable b
On Fri, Jul 10, 2009 at 10:15:03PM +0100, Simon Slavin scratched on the wall:
I don't understand why people keep trying to do these things inside
SQL when they're obviously ysing a programming language anyway.
Why wouldn't you? The data is in a database. SQL is how you
manipulate data
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[I changed the order of your questions]
Pierre Cart-Grandjean wrote:
What is recommended to use
instead in the client application?
Those are internal undocumented SQLite functions. For example you will
see that they are not part of the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
liubin liu wrote:
How could I know which SQLite3's api is reentrant?
As a general rule they all are. The documentation page for each api
gives further details and considerations. SQLite does the right thing
for multi-threaded applications and many
Igor Tandetnik wrote:
pierr wrote:
Following 2 statements took 400ms to be excuted on a 350M MIPS CPU
and it is a memory database:
DELETE FROM tblEvent_type WHERE eguid in (SELECT rowid FROM
tblEvent_basic WHERE sguid=11);;
DELETE FROM tblEvent_group WHERE eguid in (SELECT rowid FROM
pierr pierr.c...@gmail.com wrote:
Igor Tandetnik wrote:
pierr wrote:
Following 2 statements took 400ms to be excuted on a 350M MIPS CPU
and it is a memory database:
DELETE FROM tblEvent_type WHERE eguid in (SELECT rowid FROM
tblEvent_basic WHERE sguid=11);;
DELETE FROM tblEvent_group
On 10 Jul 2009, at 11:36pm, Rick Ratchford wrote:
I understand what you're saying Simon.
Sorry, Rick. I didn't mean to rail on you personally. Your post
happened to be the one that triggered me to post the rant. I
understand your reasoning and don't think you personally have done
Thanks Simon. I didn't take any offense or anything, and I REALLY DO
appreciate your comments and opinions.
My long reply was only to share how SQLite and the VB wrapper has been
making my life much easier on many tasks I used to do solely with loops and
arrays.
All the best.
Rick
Rick Ratchford r...@amazingaccuracy.com
schrieb im Newsbeitrag news:c9ce387e92004e7b9c16ddaa2bd36...@dolphin...
So modifying TmpTable, which will still be needed for
other procedures, is not preferred. It would be great if
a recordset could be derived from it instead that contains
the
SQLite does the right thing
for multi-threaded applications and many use it that way - you are not
the first.
Roger, note that OP is talking about re-entrance, not thread-safety.
He wants to know which functions can be called from signal handlers
which can be called in the middle of some other
I was trying to figuring out if you are doing something of graph data
analysis, I do it almost everyday in our Stock Trader applications...
I never did this way (direct SQL), cause our graph series data sources are
implement throught a common interface, that could be a SQL query, a stream,
a XML,
#Rick Ratchford r...@amazingaccuracy.com schrieb im
#Newsbeitrag news:c9ce387e92004e7b9c16ddaa2bd36...@dolphin...
#
# So modifying TmpTable, which will still be needed for other
# procedures, is not preferred. It would be great if a
#recordset could
# be derived from it instead that contains
#I was trying to figuring out if you are doing something of
#graph data analysis, I do it almost everyday in our Stock
#Trader applications...
#I never did this way (direct SQL), cause our graph series
#data sources are implement throught a common interface, that
#could be a SQL query, a
'Not using SQL directly' means you create a series data access interface
like an ISeries interface that browse in a cursor-style through your series
data, then implement it as a concrete class like DatabaseSeries that does
the SQL job for you.
Talking about scaling issues means that you could do
On 11 Jul 2009, at 2:39am, Rick Ratchford wrote:
When I read Simon's reply, I did not get the sense that he was
suggesting I
do a Rs-Loop. It appeared to me, and I could be mistaken of course,
that he
was referring to pure programming in by language (VB).
The people on this list often
Rick Ratchford r...@amazingaccuracy.com
schrieb im Newsbeitrag news:152a3111f1ab4a9891b9158580cb7...@dolphin...
Maybe I misunderstood, but the impression I got was
that I should solve this problem using my VB language
rather than dealing with the DB.
I don't understand Simons reply that way
#Simple is relative - as you write yourself - your App
#already performs faster using SQL for the right things - and
#that don't have to be only simple queries - what you
#already do with all these nice Group By queries - directly
#delivering weekly or monthly stock-data, derived from your
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have to coordinate a task list between two sites, and my only
convenient connection between the two is email. MS Access 2007 offers
an email insert and update feature, but it's not quite doing what I
need.
Is there a way to update / synchronize an
not beyond the realm of possibilities. I back up via email, a nice
protocol.
I dump tar gzip and email a small but important database to 6 people
each day via a cron job.
I don't remember exactly how but on unix boxes I have created user accounts
that receive emails automatically
and then
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Pavel Ivanov wrote:
Roger, note that OP is talking about re-entrance, not thread-safety.
He wants to know which functions can be called from signal handlers
which can be called in the middle of some other SQLite call in the
same thread. I doubt
47 matches
Mail list logo