Re: [sqlite] Database gets locked for other processes

2013-11-02 Thread Israel Lins Albuquerque
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] Sqlite locking issue with ATTACH'ed databases

2013-07-19 Thread Israel Lins Albuquerque
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:

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

2013-06-26 Thread Israel Lins Albuquerque
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

[sqlite] Bug: on opening the same database twice

2013-06-26 Thread Israel Lins Albuquerque
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 real operations

2013-03-26 Thread Israel Lins Albuquerque
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

Re: [sqlite] Bug on real operations

2013-03-08 Thread Israel Lins Albuquerque
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

2013-03-08 Thread Israel Lins Albuquerque
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

2013-03-08 Thread Israel Lins Albuquerque
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

2013-03-08 Thread Israel Lins Albuquerque
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

2013-03-08 Thread Israel Lins Albuquerque
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

[sqlite] Bug on real operations

2013-03-08 Thread Israel Lins Albuquerque
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] Reducing time to create indexes

2010-11-24 Thread Israel Lins Albuquerque
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

Re: [sqlite] Corrupted database with duplicated primary keys

2010-11-19 Thread Israel Lins Albuquerque
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] Corrupted database with duplicated primary keys

2010-11-19 Thread Israel Lins Albuquerque
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; > >

[sqlite] Corrupted database with duplicated primary keys

2010-11-11 Thread Israel Lins Albuquerque
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] Question about SQLite features.

2010-11-10 Thread Israel Lins Albuquerque
> > > > ___ > 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

Re: [sqlite] WinCE possible bug

2010-09-08 Thread Israel Lins Albuquerque
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] WinCE possible bug

2010-09-08 Thread Israel Lins Albuquerque
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

[sqlite] WinCE possible bug

2010-09-03 Thread Israel Lins Albuquerque
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] Fw: Re: SQlite JDBC driver - need help

2010-08-26 Thread Israel Lins Albuquerque
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 > > > >

Re: [sqlite] SQL script help.

2010-08-26 Thread Israel Lins Albuquerque
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] Ticks to unixepoch date

2010-07-13 Thread Israel Lins Albuquerque
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] Retrieve Specific record number in one shot.

2010-07-09 Thread Israel Lins Albuquerque
;>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] Slow query

2010-06-30 Thread Israel Lins Albuquerque
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] alternative to UNIQUE CONSTRAINT

2010-06-28 Thread Israel Lins Albuquerque
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

[sqlite] Force Database Corruption

2010-06-24 Thread Israel Lins Albuquerque
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] Parametrized Queries issue (Possible bug)

2010-06-14 Thread Israel Lins Albuquerque
+ |+ 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

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

2010-06-14 Thread Israel Lins Albuquerque
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)

2010-06-14 Thread Israel Lins Albuquerque
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)

2010-06-14 Thread Israel Lins Albuquerque
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)

2010-06-14 Thread Israel Lins Albuquerque
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

[sqlite] Parametrized Queries issue (Possible bug)

2010-06-14 Thread Israel Lins Albuquerque
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] [BUG] Adding an index changes query result

2010-06-09 Thread Israel Lins Albuquerque
_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

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

2010-06-09 Thread Israel Lins Albuquerque
**/ -- 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] MySQL vs. SQLite

2010-06-02 Thread Israel Lins Albuquerque
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] Performance issue on view

2010-06-02 Thread Israel Lins Albuquerque
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] Performance issue on view

2010-06-02 Thread Israel Lins Albuquerque
.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

2010-06-01 Thread Israel Lins Albuquerque
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] MySQL vs. SQLite

2010-06-01 Thread Israel Lins Albuquerque
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] MySQL vs. SQLite

2010-06-01 Thread Israel Lins Albuquerque
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] What languages can include SQLite statically?

2010-06-01 Thread Israel Lins Albuquerque
'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] data type from join multiple tables

2010-05-14 Thread Israel Lins Albuquerque
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] Sqlite in low memory devices

2010-05-05 Thread Israel Lins Albuquerque
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] SQLite 16 bits

2010-03-25 Thread Israel Lins Albuquerque
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

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

2010-03-22 Thread Israel Lins Albuquerque
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] Why we don't have strpos function?

2010-03-17 Thread Israel Lins Albuquerque
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?

2010-03-17 Thread Israel Lins Albuquerque
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?

2010-03-17 Thread Israel Lins Albuquerque
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?

2010-03-17 Thread Israel Lins Albuquerque
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?

2010-03-17 Thread Israel Lins Albuquerque
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?

2010-03-17 Thread Israel Lins Albuquerque
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

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

2010-03-17 Thread Israel Lins Albuquerque
... -- 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] SQLite version 3.6.23 - date.c

2010-03-10 Thread Israel Lins Albuquerque
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

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

2010-03-10 Thread Israel Lins Albuquerque
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

2010-03-10 Thread Israel Lins Albuquerque
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

2010-03-10 Thread Israel Lins Albuquerque
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] One data base versus two smaller ones

2010-02-19 Thread Israel Lins Albuquerque
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] Memory usage – one data base versus tw o smaller ones

2010-02-19 Thread Israel Lins Albuquerque
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] How to discover the state of a statement

2010-02-05 Thread Israel Lins Albuquerque
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

[sqlite] How to discover the state of a statement

2010-02-05 Thread Israel Lins Albuquerque
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

[sqlite] Crash Calling sqlite3_vfs_unregister

2010-01-26 Thread Israel Lins Albuquerque
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] Crash Calling sqlite3_vfs_unregister

2010-01-26 Thread Israel Lins Albuquerque
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