Re: [sqlite] Database gets locked for other processes

I know well the qt sqlite to say, maybe you aren't destroing the QSqlQuery class or simple call finish function, and the statement is openned helding the lock! Enviado via iPhone > Em 29/10/2013, às 10:51, Stephan Beal escreveu: > >> On Tue, Oct 29, 2013 at 1:52 PM,

Re: [sqlite] What languages can include SQLite statically?

't have enough RAM to run eg. Apache + mod_php. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Atenciosamente, Israel Lins Albuquerque Desenvolvimento P

Re: [sqlite] MySQL vs. SQLite

ionality. Will be possible to know whats temporary index are created? Using that information will be easy to know what indexes we need create to increase perfomance, don't giving chance to sqlite create that indexes! -- Regards/Atenciosamente, Israel Lins Albuquerque Developer/Desenvolvime

Re: [sqlite] MySQL vs. SQLite

About that future release functionality. Will be possible to know whats temporary index are created? Using that information will be easy to know what indexes we need create to increase perfomance, don't giving chance to sqlite create that indexes! -- Regards/Atenciosamente, Israel Lins

Re: [sqlite] Performance issue on view

t in op balance due to the fact that I am using an undo/redo mechanism. Regards, Stephane ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Atenciosamente, Israel Lins Alb

Re: [sqlite] Performance issue on view

.id = m.account_id) GROUP BY m.account_id HAVING payment = MAX(payment); /***/ - Mensagem original - De: "Israel Lins Albuquerque" <israel...@polibrasnet.com.br> Para: steph...@mankowski.

Re: [sqlite] Performance issue on view

t; new.payment OR (payment = new.payment AND id > new.id));; END; /***/ -- Regards/Atenciosamente, Israel Lins Albuquerque Developer/esenvolvimento Polibrás Brasil Software Ltda. __

Re: [sqlite] MySQL vs. SQLite

I asked that before because Oracle do this. It notify the developer and ask if we want to create that transient index as materialized. I didn't see this working but I know this by a friend. -- Atenciosamente/Regards, Israel Lins Albuquerque Desenvolvimento/Development Polibrás Brasil

Re: [sqlite] [BUG] Adding an index changes query result

**/ -- Atenciosamente/Regards, Israel Lins Albuquerque Desenvolvimento/Development Polibrás Brasil Software Ltda. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [BUG] Adding an index changes query result

_NONE because affinity of left expression "c2" (is a collumn) is INTEGER and rigth expression "'2'" is TEXT! ----- Mensagem original ----- De: "Israel Lins Albuquerque" <israel...@polibrasnet.com.br> Para: "General Discussion of SQLite Database" <s

[sqlite] Parametrized Queries issue (Possible bug)

one! -- Atenciosamente/Regards, Israel Lins Albuquerque Desenvolvimento/Development Polibrás Brasil Software Ltda. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Parametrized Queries issue (Possible bug)

Once more detail... Doing this... SELECT * FROM a WHERE a.a = :a AND a.b = ?1; and this... SELECT * FROM a WHERE a.a = ?1 AND a.b = :b; Will have different behavior! - Mensagem original - De: "Israel Lins Albuquerque" <israel...@polibrasnet.com.br> Par

Re: [sqlite] Parametrized Queries issue (Possible bug)

De: "Jay A. Kreibich" <j...@kreibi.ch> Para: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Enviadas: Segunda-feira, 14 de Junho de 2010 12:00:32 Assunto: Re: [sqlite] Parametrized Queries issue (Possible bug) On Mon, Jun 14, 2010 at 11:51:07A

Re: [sqlite] Parametrized Queries issue (Possible bug)

ed and numbered parameter syntax. David --- On Mon, 6/14/10, Israel Lins Albuquerque <israel...@polibrasnet.com.br> wrote: > From: Israel Lins Albuquerque <israel...@polibrasnet.com.br> > Subject: Re: [sqlite] Parametrized Queries issue (Possible bug) > To: "Gener

Re: [sqlite] Parametrized Queries issue (Possible bug)

abase" <sqlite-users@sqlite.org> Enviadas: Segunda-feira, 14 de Junho de 2010 15:41:01 Assunto: Re: [sqlite] Parametrized Queries issue (Possible bug) On Mon, Jun 14, 2010 at 03:03:52PM -0300, Israel Lins Albuquerque scratched on the wall: > I know what you booth are are

Re: [sqlite] Parametrized Queries issue (Possible bug)

+ |+ if( pExpr->iColumn>pParse->nVar ){ |+ pParse->nVar = pExpr->iColumn; |+ } | }else{ | /* Wildcards like ":aaa", "$aaa" or "@aaa". Reuse the same variable | ** number as the prior appearance of the same name, or if the name -- Atenciosament

[sqlite] Force Database Corruption

Hello, I'm needing a corrupted database for test purpose, someone can help me? I want an database with corruption on index like: "rowid [%ld] missing from index %s" or "wrong # of entries in index %s" -- Atenciosamente/Regards, Israel Lins Albuquerque Desenvo

Re: [sqlite] alternative to UNIQUE CONSTRAINT

t; > [...] > > Oliver > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Atenciosamente/Regards, Israel Lins Albuquerque De

Re: [sqlite] Slow query

If your table doesn't have a primary key, this look like your table aren't normalized, maybe you can try broke this table in 2 tables like: Your definition: CREATE TABLE table1(id INTEGER, name VARCHAR, id2 INTEGER, name2 VARCHAR, year INTEGER); indexes : index1( name ), index2( id2 ),

Re: [sqlite] Retrieve Specific record number in one shot.

;>read row; > > > something like that. > > > > > -- > Thanks & Regards > > Piyush Verma > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin

Re: [sqlite] Ticks to unixepoch date

rg:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Atenciosamente/Regards, Israel Lins Albuquerque Desenvolvimento/Development Polibrás Brasil Software Ltda. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL script help.

lly speaking you might want to add > 'ORDER BY _rowid_' to the end of those if the order matters. > > Simon. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/s

Re: [sqlite] Fw: Re: SQlite JDBC driver - need help

ble to see view the data with their > > windows authentication. Any help is greately appreciated. > > > > Thank you in advance, > > > > Dev > > > > > > > > -- > > D. Richard Hipp > > d...@sqlite.org > > > >

[sqlite] WinCE possible bug

occur, the program makes a lot of things, including stay with prepared statements in memory, but no one are locking the file I wish I appreciate some help. Ps. I'm using the version 3.6.23.1 of sqlite library. -- Atenciosamente/Regards, Israel Lins Albuquerque Desenvolvimento

Re: [sqlite] WinCE possible bug

un "Sqlite3.exe" in WinCE. > If you run x86 platform, could you share some idea with the WinCE developer? > > Thanks > Lu > > On Fri, Sep 3, 2010 at 5:40 AM, Israel Lins Albuquerque < > israel...@polibrasnet.com.br> wrote: > > > Guys I had a proble

Re: [sqlite] WinCE possible bug

Thanks, "Zaher Dirkey"! Only, PRAGMA journal_mode = TRUNCATE solves my problem. By some way the O.S. is locking the one off the journals and the program can't delete it. -- Atenciosamente/Regards, Israel Lins Albuquerque Desenvolvimento/Development Polibrás Brasil Sof

Re: [sqlite] Question about SQLite features.

> > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- -- Atenciosamente/Regards, Israel Lins Albuquerque Desenvolvimento/Development Polibrás

[sqlite] Corrupted database with duplicated primary keys

see that, Thanks for your time! -- Atenciosamente/Regards, Israel Lins Albuquerque Desenvolvimento/Development Polibrás Brasil Software Ltda. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sql

Re: [sqlite] Corrupted database with duplicated primary keys

Due to attach limits this is the part 001 of the file! - "Israel Lins Albuquerque" <israel...@polibrasnet.com.br> escreveu: > Attached has a database corrupted. > We use the version 3.6.23.1 in wince. > > the command: > pragma integrity_check; > >

Re: [sqlite] Corrupted database with duplicated primary keys

Due to attach limits this is the part 002 of the file! - "Israel Lins Albuquerque" <israel...@polibrasnet.com.br> escreveu: > Attached has a database corrupted. > We use the version 3.6.23.1 in wince. > > the command: > pragma integrity_check; > >

Re: [sqlite] Reducing time to create indexes

is about 300MB and with indexes 600MB. > > Ill have a look at FTS as there are other benefits to using that. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users &g

[sqlite] Crash Calling sqlite3_vfs_unregister

De: "Israel Lins Albuquerque" <israel...@polibrasnet.com.br> Para: "sqlite-users-bounces" <sqlite-users-boun...@sqlite.org> Enviadas: Quarta-feira, 20 de Janeiro de 2010 16:48:52 (GMT-0200) Auto-Detected Assunto: Crash Calling sqlite3_vfs_unregister if I cal

[sqlite] Crash Calling sqlite3_vfs_unregister

ed a patch for this, see file attached. -- Israel Lins Albuquerque Desenvolvimento Polibrás Brasil Software Ltda. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] How to discover the state of a statement

for atention. -- Israel Lins Albuquerque Desenvolvimento Polibrás Brasil Software Ltda. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to discover the state of a statement

Thank you, that's work for me. -- Israel Lins Albuquerque Desenvolvimento Polibrás Brasil Software Ltda. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Memory usage – one data base versus tw o smaller ones

nswers and share what you know at http://ca.answers.yahoo.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Israel Lins Albuquerque Desenvolvimento Polibrás Bras

Re: [sqlite] One data base versus two smaller ones

er of pages to number of records accessed by user per his typical database session? Regards, Samuel - Original Message From: Jay A. Kreibich <j...@kreibi.ch> On Fri, Feb 19, 2010 at 09:39:08AM -0300, Israel Lins Albuquerque scratched on the wall: > Samuel, > &

Re: [sqlite] SQLite version 3.6.23 - date.c

mp, 0, "%Y-%m-%d", 0, currentTimeFunc), STR_FUNCTION(current_date, 0, "%Y-%m-%d %H:%M:%S", 0, currentTimeFunc), I fink this is a problem because: SELECT CURRENT_DATE will return 2010-03-10 09:34:55 SELECT CURRENT_TIMESTAMP will return 2010-03-10 Are this correct? Regard

Re: [sqlite] SQLite version 3.6.23 - date.c

e: [sqlite] SQLite version 3.6.23 - date.c On Mar 10, 2010, at 7:36 AM, Israel Lins Albuquerque wrote: > In this new version: > > > at file date.c line 1095 are changed? Why? > > previous version > STR_FUNCTION(current_date, 0, "%Y-%m-%d", 0, currentTimeFunc

Re: [sqlite] SQLite version 3.6.23 - date.c

e: [sqlite] SQLite version 3.6.23 - date.c On Mar 10, 2010, at 7:36 AM, Israel Lins Albuquerque wrote: > In this new version: > > > at file date.c line 1095 are changed? Why? > > previous version > STR_FUNCTION(current_date, 0, "%Y-%m-%d", 0, currentTimeFunc

Re: [sqlite] SQLite version 3.6.23 - date.c

My apologies everybody. I'm wrong. forget what I said. -- Atenciosamente, Israel Lins Albuquerque Desenvolvimento Polibrás Brasil Software Ltda. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

[sqlite] Why we don't have strpos function?

... -- Atenciosamente, Israel Lins Albuquerque Desenvolvimento Polibrás Brasil Software Ltda. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Why we don't have strpos function?

http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Atenciosamente, Israel Lins Albuquerque Desenvolvimento Polibrás Brasil Software Ltda. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Why we don't have strpos function?

I forgot attach... This are based in the current release 3.6.23. -- Atenciosamente, Israel Lins Albuquerque Desenvolvimento Polibrás Brasil Software Ltda. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] Why we don't have strpos function?

rFunc ), FUNCTION(substr, 3, 0, 0, substrFunc ), FUNCTION(abs, 1, 0, 0, absFunc ), /***/ - Mensagem original - De: "Israel Lins Albuquerque" <israel...@polibrasnet.com.br> Para: "General Discussion of SQL

Re: [sqlite] Why we don't have strpos function?

uarta-feira, 17 de Março de 2010 15:19:43 Assunto: Re: [sqlite] Why we don't have strpos function? On Wed, Mar 17, 2010 at 01:15:35PM -0300, Israel Lins Albuquerque scratched on the wall: > There are the patch: Which seems to assume one character equals one byte. -j -- Jay A. Kreibich

Re: [sqlite] Why we don't have strpos function?

are you right the call to strpos("áéíóú", "í") are returning 5 and not 3 I'm looking for this... -- Atenciosamente, Israel Lins Albuquerque Desenvolvimento Polibrás Brasil Software Ltda. ___ sqlite-users mailing list sql

Re: [sqlite] Why we don't have strpos function?

FUNCTION(abs, 1, 0, 0, absFunc ), /**/ -- Atenciosamente, Israel Lins Albuquerque Desenvolvimento Polibrás Brasil Software Ltda. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Why we don't have strpos function?

I have to talk with someone to add this function on the sqlite? Or this will be tested and added later? -- Atenciosamente, Israel Lins Albuquerque Desenvolvimento Polibrás Brasil Software Ltda. ___ sqlite-users mailing list sqlite-users

Re: [sqlite] SQLite 16 bits

org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Regards , Israel Lins Albuquerque Desenvolvimento Polibrás Brasil Software Ltda. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Sqlite in low memory devices

this, and now vacuum will work. I'm sending attached the path for this. -- Atenciosamente/Regards, Israel Lins Albuquerque Desenvolvimento/Development Polibrás Brasil Software Ltda. ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] data type from join multiple tables

org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Atenciosamente, Israel Lins Albuquerque Desenvolvimento Polibrás Brasil Software Ltda. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Bug on real operations

be a bug on calculation of doubles. Regards, Israel Lins Albuquerque ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug on real operations

printf("%e\n",d); > } > On both MS Visual C and gcc on a Linux system: > 0.00 > 3.55271e-015 > 3.552714e-015 > > -Original Message----- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Israel Lins > Albu

Re: [sqlite] Bug on real operations

printf("%e\n",d); > } > On both MS Visual C and gcc on a Linux system: > 0.00 > 3.55271e-015 > 3.552714e-015 > > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Israel Lins > A

Re: [sqlite] Bug on real operations

I know that. I don't know how postgresql handle this, may be I can check, I just charring by problem to brainstorm if sqlite may do or not what postgresql do. Em 08/03/2013, às 15:06, Israel Lins Albuquerque <israelin...@yahoo.com.br> escreveu: > But I see this as a w

Re: [sqlite] Bug on real operations

I know that very well. I don't know how postgresql handle this, may be I can check, I just charring by problem to brainstorm if sqlite may do or not what postgresql do. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Bug on real operations

Bug on real operations > > > On 8 Mar 2013, at 6:24pm, Israel Lins Albuquerque <israelin...@yahoo.com.br> > wrote: > >> I don't know how postgres handle this, may be I can check > > Postgres has special datatypes used especially to handle problems like this. &g

Re: [sqlite] Bug on real operations

As I can see my problem is solved on sqlite 4. Em 08/03/2013, às 16:35, Israel Lins Albuquerque <israelin...@yahoo.com.br> escreveu: > Thank you guys, and sort for my bad explanation about what I want. I > understand that double problems very well, > I will continue wor

[sqlite] Bug: on opening the same database twice

in: sqlite3BtreeOpen line 1788, because the shared cache uses the same structure in booth connections, and pBt->pPager->readOnly is set to 1. To workaround this I will open read write mode first, but that make readonly connection become read write. There is an know issue? Regards, -- Israe

Re: [sqlite] Bug: on opening the same database twice

of read? Thats it, thanks for patience. Regards, -- Israel Lins Albuquerque Antes de imprimir, pense em sua responsabilidade com o MEIO AMBIENTE. Em 26/06/2013, às 14:24, Israel Lins Albuquerque <israelin...@yahoo.com.br> escreveu: > I open an database twice times in same process

Re: [sqlite] Sqlite locking issue with ATTACH'ed databases

tries to write the error happens, but I can not sure about this... I just saying you are not alone. -- Israel Lins Albuquerque Antes de imprimir, pense em sua responsabilidade com o MEIO AMBIENTE. Em 18/07/2013, às 16:26, Loren Keagle <loren.kea...@braemarllc.com> escreveu: >> Date: