On 2014/12/13 21:46, James K. Lowden wrote:
So the number of tools with feature X is no measure of the value of X. (Notable example: the tool should keep every query and
result in a time-sequenced transcript log, so that prior results can be re-examined and prior queries modified. Most tools
d
Jim Callahan wrote:>#26 The unique columns have non-null values (the answer
says a lot more,>but that is the essence of what I am relying on).
Right, but the question was how to count rows as quickly as possible regarding
any or all columnse.g. count(ProspectName) from Clients;
One can imagine f
Hi Simon,
A) In that sqlite_sequence table you mentioned, as an additional
column. Always up-to-date.
But sqlite_sequence isn't always created. AFAIK it only exists when one
or more table exists with an integer primary key autoincrement.
B) In the tables prepared by SQLite ANALYZE. If you
Thanks for the reply. It seems that for now I will have to change the password
of the database to nothing and then use it with any other application and then
re-encrypt it later when I am finished with it.
Thanks to all of you for helping me out.
Regards,
Mujtaba Panjwani
-Original Messag
Apologies for the noise from the empty reply. They shouldn't put "send" &
"expand quote" buttons so close together.
On Sun, Dec 14, 2014 at 4:40 AM, Mujtaba Ali Panjwani
wrote:
> Well, I have tried various applications like Navicat premium, SQlite
> sorcerer, sqlite manager and a lot others whos
On Sun, Dec 14, 2014 at 4:40 AM, Mujtaba Ali Panjwani
wrote:
> Well, I have tried various applications like Navicat premium, SQlite
> sorcerer, sqlite manager and a lot others whose names I don’t remember
> right now. Currently only sqlite sorcerer seems to be getting to some point
> but when I p
Well, I have tried various applications like Navicat premium, SQlite sorcerer,
sqlite manager and a lot others whose names I don’t remember right now.
Currently only sqlite sorcerer seems to be getting to some point but when I
provide incorrect password, it says that it is wrong password but whe
On 14 Dec 2014, at 11:08am, Jean-Christophe Deschamps wrote:
> Without using slow triggers or changing the v3 file format there is still
> another possibility which could be implemented relatively easily. All it
> would need is a new pragma (or internal function) like "pragma row_count=0/1"
>
Thanks for the reply.
Well, the goal was to password protect it so that whoever wants to view the
contents should have the password. However the apps which supports
encryption are not able to open the database even if I am providing the
correct password. Any help will be appreciated.
Regards,
Mu
At 03:14 14/12/2014, you wrote:
´¯¯¯
I take the point that the only possible improvements seem to need
alteration to the file structure or added maintenance which may use up
cycles for something that just isn't that important to DB use in
general - and I have to agree, I too have zero want for
10 matches
Mail list logo
