Re: [sqlite] SQLite Training

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Rich Shepard wrote: >That's very true, but it's still the best overall introduction to SQLite. The book claims to be a definitive guide, not an introduction :-) >Almost no book on a particular software application remains current. This is

Re: [sqlite] Concurrency support for multiple process

> What made you expect that? Process A has not entered the exclusive lock and so process B can obtain shared lock to read. > SQLite allows multiple readers OR a single writer to access the database simultaneously. >From the SQLite doc, as long as no transaction is pending, other process can read

[sqlite] julian qian wants to stay in touch on LinkedIn

LinkedIn General, I'd like to add you to my professional network on LinkedIn. - julian qian Confirm that you know julian qian https://www.linkedin.com/e/isd/1028285185/9hLDvOAo/ -- (c) 2010, LinkedIn Corporation ___

Re: [sqlite] Concurrency support for multiple process

nyetngoh wong wrote: > First, I've a process A that do many inserts to the database and reads back > from the database to verify. The writes are done in one DEFERRED transaction > as data are not committed yet. While the first process running, another > process B is launched to read from the

Re: [sqlite] contribution: fts3 porter stemmer enhancements to handle common european accents

>The porter stemmer, by its very nature, is not intended to work for >non-english text You should read the Snowball site about this: http://snowball.tartarus.org/ ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SQLite Training

On Wed, 27 Jan 2010, Roger Binns wrote: > The main drawback is that the book hasn't been revised since 2006 since > when the virtual machine has changed, foreign key support is present, you > can use threading freely, there is incremental Blob I/O, virtual tables > are available, VFS is

[sqlite] contribution: fts3 porter stemmer enhancements to handle common european accents

I'd like to contribute for potential inclusion, or to help out others in the community, a small set of enhancements I've made to the porter tokenizer. This implementation shares most of its code with the current porter tokenizer, as the changes are really just in the tokenizer prior to the

[sqlite] Documentation errors

___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Question about locking

Sqlite uses file locking for concurent access to databases. Is it possible to implement locking using data synchronization library liburcu (http://lttng.org/?q=node/18) on top of mmaped file? I'm sure this would be not sqlite but some other light database. RCU achieves scalability improvements by

Re: [sqlite] SQLite Training

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Simon Slavin wrote: > Excellent. I must check out a copy. You may find my review useful: http://www.rogerbinns.com/sqlitereview.html The main drawback is that the book hasn't been revised since 2006 since when the virtual machine has changed,

[sqlite] Concurrency support for multiple process

Hi, First, I've a process A that do many inserts to the database and reads back from the database to verify. The writes are done in one DEFERRED transaction as data are not committed yet. While the first process running, another process B is launched to read from the database for display

Re: [sqlite] SQLite Training

On 28 Jan 2010, at 2:04am, Roger Binns wrote: > Simon Slavin wrote: >> ... but that requires that you understand at least a bit of relational >> databases theory. > > Mike Owen's book does that well. There are 26 pages covering the relational > model before SQL is introduced. Excellent. I

Re: [sqlite] SQLite Training

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Simon Slavin wrote: > ... but that requires that you understand at least a bit of relational > databases theory. Mike Owen's book does that well. There are 26 pages covering the relational model before SQL is introduced. Roger -BEGIN PGP

Re: [sqlite] SQLite Training

On Thu, 28 Jan 2010, Simon Slavin wrote: > ... but that requires that you understand at least a bit of relational > databases theory. We've recently had questions from people who don't > understand an INDEX, or what you would want one, or how to make one which > is useful for a particular query.

Re: [sqlite] SQLite Training

On 28 Jan 2010, at 1:03am, Rich Shepard wrote: > All you need is to know SQL well ... but that requires that you understand at least a bit of relational databases theory. We've recently had questions from people who don't understand an INDEX, or what you would want one, or how to make one

Re: [sqlite] SQLite Training

On Thu, 28 Jan 2010, nyetngoh wong wrote: > I'm currently working on a project that uses SQLite and would like to know > if there is any SQLite certification available in Singapore. Do you > provide any forms of technical training or courses on using SQLite > efficiently ? All you need is to

[sqlite] SQLite Training

Hi, I'm currently working on a project that uses SQLite and would like to know if there is any SQLite certification available in Singapore. Do you provide any forms of technical training or courses on using SQLite efficiently ? Thanks ___ sqlite-users

[sqlite] Problem using sqlite in a C++/CLI .Net application

I am able to compile a C++/CLI .Net application using sqlite. But when it links it complains with some linker warnings: xxx.obj : warning LNK4248: unresolved typeref token (011D) for 'sqlite3'; image may not run xxx.obj : warning LNK4248: unresolved typeref token (011F) for

Re: [sqlite] Conditional insertion syntaxe in SQLite

Thanks for the suggestion of a temp table for storing intermediaire data, Igor. Now DELETE TRANSACTION works fine with only SQL code! Sylvain -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Tuesday,

Re: [sqlite] what are the limitations for IN() lists?

On 27 Jan 2010, at 1:28pm, Tim Romano wrote: > The question in my mind is whether the following is any more > performance-efficient than the approach above (note 2a-2e and 5a-5b): > 2. Webservice: > 1) receives the request > 2) instantiates a database connection > 2a) creates an

Re: [sqlite] what are the limitations for IN() lists?

On Wed, Jan 27, 2010 at 08:28:15AM -0500, Tim Romano scratched on the wall: > The question in my mind is whether the following is any more > performance-efficient than the approach above (note 2a-2e and 5a-5b): > 2. Webservice: > 1) receives the request > 2) instantiates a database

Re: [sqlite] how to get the type of a parameter

On Wed, Jan 27, 2010 at 01:43:36PM +, Simon Davies scratched on the wall: > 2010/1/27 gujx : > > Hi, I had a question puzzled me. How can I get the type of a parameter in a > > prepared SQL. > > > > For example, the code is: > . > . > . > > > > ? ? ? "INSERT INTO

Re: [sqlite] how to get the type of a parameter

2010/1/27 gujx : > Hi, I had a question puzzled me. How can I get the type of a parameter in a > prepared SQL. > > For example, the code is: . . . > >       "INSERT INTO [test_for_cpp] ([id], [age], [name]) VALUES (?, ?, > 'xiaowang') ; ", >       -1, >       , >       >    

Re: [sqlite] what are the limitations for IN() lists?

Thanks for the suggestion of a memory-database, Jean-Christophe. It is not something I've used so far with SQLite but I have some preliminary questions in the abstract. The typical scenario with a webservice goes like this (database connections are ephemeral, not persistent): 1. User visits

[sqlite] how to get the type of a parameter

Hi, I had a question puzzled me. How can I get the type of a parameter in a prepared SQL. For example, the code is: sqlite3 *conn; if (SQLITE_OK != sqlite3_open("testBind.db", )) { printf("can't open the database."); return ; } if(SQLITE_OK !=

[sqlite] how to get the type of a parameter

Hi, I had a question puzzled me. How can I get the type of a parameter in a prepared SQL. For example, the code is: sqlite3 *conn; if (SQLITE_OK != sqlite3_open("testBind.db", )) { printf("can't open the database."); return ; } if(SQLITE_OK !=

Re: [sqlite] Sqlite3 Optimization Question

Am 22.01.2010 um 15:01 schrieb Michael Thomason: > The only problem is that the table is very large. If I list out the > contents of the table in a text file, it is one-third the size of the > database. So, if the text file is 12 MB, the database is 32 MB. You may also want to check the

Re: [sqlite] Java and sqlite

See http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC for een Java interface of SQLite Regards On Tue, Jan 26, 2010 at 8:51 PM, Miloud B. wrote: > Hi guys, > > I want to use SQLite in Java applications, what do you advice ? Which > interface do you use ? > I found two: >