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
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,
On 14 Dec 2014, at 11:08am, Jean-Christophe Deschamps j...@antichoc.net 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
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
On Sun, Dec 14, 2014 at 4:40 AM, Mujtaba Ali Panjwani mapanjw...@gmail.com
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
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 mapanjw...@gmail.com
wrote:
Well, I have tried various applications like Navicat premium, SQlite
sorcerer, sqlite manager and a
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
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
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
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
10 matches
Mail list logo
