Re: [sqlite] is the sqlite3's C-api used in thread-safety mode ? or non-reentrant?

-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

Re: [sqlite] Updating a database by email

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

[sqlite] Updating a database by email

-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

Re: [sqlite] Is it Possible in SQL...

#>"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

Re: [sqlite] Is it Possible in SQL...

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

Re: [sqlite] Is it Possible in SQL...

"Rick Ratchford" 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

Re: [sqlite] Is it Possible in SQL...

'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

Re: [sqlite] Is it Possible in SQL...

#>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

Re: [sqlite] Is it Possible in SQL...

#>"Rick Ratchford" 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

Re: [sqlite] Is it Possible in SQL...

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,

Re: [sqlite] is the sqlite3's C-api used in thread-safety mode ? or non-reentrant?

> 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

Re: [sqlite] Is it Possible in SQL...

"Rick Ratchford" 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 >

Re: [sqlite] Is it Possible in SQL...

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

Re: [sqlite] Is it Possible in SQL...

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

Re: [sqlite] how to break subquery into 2 simply query

pierr 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);"; >>>

Re: [sqlite] how to break subquery into 2 simply query

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

Re: [sqlite] is the sqlite3's C-api used in thread-safety mode ? or non-reentrant?

-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

Re: [sqlite] sqlite3StrICmp and sqlite3StrNICmp

-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

Re: [sqlite] Is it Possible in SQL...

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

Re: [sqlite] Is it Possible in SQL...

#> #>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 #>

Re: [sqlite] Is it Possible in SQL...

#>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

Re: [sqlite] Is it Possible in SQL...

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

Re: [sqlite] Is it Possible in SQL...

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

Re: [sqlite] Is it Possible in SQL...

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

Re: [sqlite] Is it Possible in SQL...

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)

Re: [sqlite] Is it Possible in SQL...

#>-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

Re: [sqlite] Is it Possible in SQL...

Rick Ratchford 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

[sqlite] Is it Possible in SQL...

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

[sqlite] Generate an sqlite schema from a postgres dump

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

Re: [sqlite] multi-thread access to a db

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

Re: [sqlite] New Book Available

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

Re: [sqlite] New Book Available

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.

Re: [sqlite] Pros and cons of various online code sharing sites

"D. Richard Hipp" 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

Re: [sqlite] how to break subquery into 2 simply query

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

Re: [sqlite] is the sqlite3's C-api used in thread-safety mode ? or non-reentrant?

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

[sqlite] sqlite3StrICmp and sqlite3StrNICmp

Hello, In version 3.3.6 of sqlite, the functions sqlite3StrICmp and sqlite3StrNICmp were extern: /usr/local/lib>nm -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:

Re: [sqlite] New Book Available

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." >>

Re: [sqlite] Fetch whole result set to memory

-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)

Re: [sqlite] SQLITE is not working in pthread

-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.

Re: [sqlite] Fetch whole result set to memory

> > 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

Re: [sqlite] SQLITE is not working in pthread

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

Re: [sqlite] SQLITE is not working in pthread

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Pramoda M. A wrote: > This will run in thread. But here, "entered" and "entered 2"is 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

Re: [sqlite] SQLITE is not working in pthread

2009/7/10 Pramoda M. A : > > 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

Re: [sqlite] SQLITE is not working in pthread

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

Re: [sqlite] SQLITE is not working in pthread

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

[sqlite] how to break subquery into 2 simply query

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

[sqlite] SQLITE is not working in pthread

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 |