[sqlite] [OFF TOPIC] How to unsubscribe the mailing list?
Thanks, Cláudio Leopoldino __ Faça ligações para outros computadores com o novo Yahoo! Messenger http://br.beta.messenger.yahoo.com/
Re: [sqlite] What happens to unused space?
About the blob delection issue, i have a sugestion: - At the same blob deletion transaction, before the delection sql code, update the blob with an standard blob without relevant meaning, overwriting the original. Then an hacker will read the standard blob in the deleted blob space. Well... it have performance issues, but i didn't tests. Cláudio > > So in summary, when I delete a blob, I want it to > stay deleted, even > > from prying eyes with a hex editor - what's the > best way to do this in > > the SQLite model? > > Tricky question. > > ___ Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora! http://br.acesso.yahoo.com/
Re: [sqlite] Linux Newbie...
Bom dia, Maurício! Já estou trabalhando direitinho no Linux. Você está usando oSQLite com que propósitos? Até mais, Cláudio --- "Mauricio M. Maia" <[EMAIL PROTECTED]> escreveu: > Claudio, > > you need to execute like: > $ ./sqlite3-3.2.1.bin > > PS: If you want, send a private message to me, so I > help you *in > portuguese* :) > > Maurício. > > Claudio Bezerra Leopoldino wrote: > > Hi! > > > > I've used the windows command line SQLite utility > > without problems, but the linux version GZ file > > doesn't worked in mine tests. I extracted the file > > with gunzip, but the binary file doesn't worked. > It > > can be a very basic problem to an esxperient linux > > user, but i couldn't execute the binary file. I > got > > only "command not found". > > May someone tell me a clue to execute the SQLite > > utility in linux environment? Or a need to compile > the > > source code to use the utility? > > > > Thanks, > > > > Cláudio > > > > == > > [EMAIL PROTECTED] SQLite]$ ls -l > > total 372 > > -rwxr-xr-x 1 bezerral Afp10-GP 374132 Mai 19 > 15:22 > > sqlite3-3.2.1.bin > > [EMAIL PROTECTED] SQLite]$ > > [EMAIL PROTECTED] SQLite]$ > sqlite3-3.2.1.bin > > bash: sqlite3-3.2.1.bin: command not found > > [EMAIL PROTECTED] SQLite]$ > > [EMAIL PROTECTED] SQLite]$ > > > > > > > > > > > > > > Yahoo! Acesso Grátis - Internet rápida e grátis. > > Instale o discador agora! > http://br.acesso.yahoo.com/ > > > Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora! http://br.acesso.yahoo.com/
Re: [sqlite] Linux Newbie...
> pwd is not in your path. > try ./sqlite3-3.2.1.bin Thanks toi everybody! It worked very well!!! Cláudio > also make sure it's got the right permissions: > > chmod a+x sqlite3-3.2.1.bin > > HTH, > B > > Claudio Bezerra Leopoldino wrote: > > Hi! > > > > I've used the windows command line SQLite utility > > without problems, but the linux version GZ file > > doesn't worked in mine tests. I extracted the file > > with gunzip, but the binary file doesn't worked. > It > > can be a very basic problem to an esxperient linux > > user, but i couldn't execute the binary file. I > got > > only "command not found". > > May someone tell me a clue to execute the SQLite > > utility in linux environment? Or a need to compile > the > > source code to use the utility? > > > > Thanks, > > > > Cláudio > > > > == > > [EMAIL PROTECTED] SQLite]$ ls -l > > total 372 > > -rwxr-xr-x 1 bezerral Afp10-GP 374132 Mai 19 > 15:22 > > sqlite3-3.2.1.bin > > [EMAIL PROTECTED] SQLite]$ > > [EMAIL PROTECTED] SQLite]$ > sqlite3-3.2.1.bin > > bash: sqlite3-3.2.1.bin: command not found > > [EMAIL PROTECTED] SQLite]$ > > [EMAIL PROTECTED] SQLite]$ > > > > > > > > > > > > > > Yahoo! Acesso Grátis - Internet rápida e grátis. > > Instale o discador agora! > http://br.acesso.yahoo.com/ > > > -- > Robert Scussel > 1024D/BAF70959/0036 B19E 86CE 181D 0912 5FCC 92D8 > 1EA1 BAF7 0959 > Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora! http://br.acesso.yahoo.com/
Re: [sqlite] Proposal: limit the number of columns in a table to 2000.
Interesting issue... I thing that we may use 2048 instead 2000. It´s an number more "binary". I think that it´s sufficient to 99.99% of the possible applications. That´s a good idea. The DBase accepted 128 collumns and that is my reference. I've need more than this. In a future development this value will be editable? Cláudio Leopoldino > As currently implemented, there is no fixed limit to > the number > of columns you can put in a table in SQLite. If the > CREATE TABLE > statement will fit in memory, then SQLite will > accept it. Call > the number of columns in a table K. I am proposing > to limit the > value of K to something like 2000. > > Would this cause anyone any grief? > > Note that SQLite is optimized for a K that is small > - a few dozen > at most. There are algorithms in the parser that > run in time > O(K*K). These could be changed to O(K) but with K > small the > constant of proportionality is such that it isn't > worthwhile. > So, even though SQLite will work on a table with a > million or > more columns, it is not a practical thing to do, in > general. > > The largest value of K I have seen in the wild is in > the > low 100s. I thought that I was testing with K > values in > the thousands, but I just checked and I think the > test > scripts only go as high as K=1000 in one place. > > The reason it would be good to limit K to about 2000 > is > that if I do so there are some places where I can > increase > the run-time performance some. It would also reduce > code complexity in a few spots. > > So who out there needs a value of K larger than > 2000? > What is the largest K that anybody is using? Who > would > object if I inserted a limit on K that was in the > range > of 1000 or 2000? > -- > D. Richard Hipp <[EMAIL PROTECTED]> > > Yahoo! Mail - Com 250MB de espaço. Abra sua conta! http://mail.yahoo.com.br/
[sqlite] Beginner Problem...
I've used SQLite utility to learn about the library, but have a doubt... I need to submit sql text scripts to the utility instead of command line sql code. It´s possible? Cláudio Leopoldino ___ Yahoo! Acesso Grátis - Instale o discador do Yahoo! agora. http://br.acesso.yahoo.com/ - Internet rápida e grátis
[sqlite] SQLite for didatic purposes...
Hi, I think to use SQLite for didactical purposes but i want to start with some aditional information about the results, activities performed the possible didatic uses of sqlite. Do you have some experience using SQLite to teach about DBMS? There is some known article or book about this specific issue? Cláudio Leopoldino, Msc __ Converse com seus amigos em tempo real com o Yahoo! Messenger http://br.download.yahoo.com/messenger/
Re: [sqlite] Is there any way to enable recursive triggers?
I think that a good and simple solution is simply limit the level of recursivity. Maybe 16 nested recursive calls solve 95% of the recursive needs. Cláudio > Peter Bartholdsson wrote: > > Think the topic explains it but there any way to > enable recursive triggers? > > Aka, triggers that run as result of a change by a > trigger. > > > > Recursive triggers are on the todo list. They are a > prerequisite > for the planned implementation of foreign keys. > > One stubling block with recursive triggers is that a > recursive > trigger can result in an infinite loop. I sent out > a query a > month or so ago requesting ideas on how to detect > and deal with > infinite loops in recursive triggers. I got a few > helpful > responses. More input would be appreciated. > > Example: How should SQLite deal with this: > > CREATE TABLE ex1(a INTEGER); > INSERT INTO ex1 VALUES(1); > CREATE TRIGGER tr1 AFTER UPDATE ON ex1 BEGIN > UPDATE ex1 SET a=a+1 WHERE rowid=old.rowid; > END; > > UPDATE ex1 SET a=2 WHERE a=1; -- infinite loop > here > > > -- > D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 > > = = Sabedoria: "O FRACO PERECERÁ." Sugestão : CAI [www.cai.org.br] = ___ Yahoo! Acesso Grátis - Instale o discador do Yahoo! agora. http://br.acesso.yahoo.com/ - Internet rápida e grátis