On 4/19/07, Joe Wilson <[EMAIL PROTECTED]> wrote:
--- DragonK <[EMAIL PROTECTED]> wrote:
> I'm having the following problem: a sqlite database file is on an NTFS
> filesystem, in a directory with no permissions to create new files, but
only
> to modify the original
ate a dummy journal file with all but delete
permissions on it, I think that'd cause more problems, since sqlite will see
the journal there and it will try to roll it back every time I use the
database... :(
On 18/04/07, DragonK <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I'm
Hi,
I'm having the following problem: a sqlite database file is on an NTFS
filesystem, in a directory with no permissions to create new files, but only
to modify the original database. By using filemon i've noticed some access
denied errors when sqlite attempted to create the journal files.
I've
Hi,
I'm wondering if there's any free addon for sqlite which would add a
transparent encryption layer to the database... can anyone provide any
information?
Thanks!
--
...it's only a matter of time...
Hi,
I have a table containing a text field, which is UTF-8 encoded data. I want
to know if I use sqlite3_column_text16() to retrieve the contents
of the field, would the data be automatically converted to UTF-16, or would
the characters be simply "extended" to 16 bit ? The documentation didn't
h
On 2/8/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
DragonK <[EMAIL PROTECTED]> wrote:
>
> So, as I understand it, this is supported from version 3.3.8 upwards,
right?
>
Correct.
Thanks for straigthening out the issue! :)
--
D. Richard Hi
On 2/8/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
"Jay Sprenkle" <[EMAIL PROTECTED]> wrote:
> On 2/7/07, DragonK <[EMAIL PROTECTED]> wrote:
> >
> >
> > This seems to work... but I'm not sure if it should, that's why I'm
>
On 2/8/07, Dennis Cote <[EMAIL PROTECTED]> wrote:
DragonK wrote:
>
>
> Well, using transactions would be a little difficult, because I have a
> library which does something like logging to a database. Using
> transaction
> on a single insert would be useless in my o
On 2/8/07, Jay Sprenkle <[EMAIL PROTECTED]> wrote:
On 2/7/07, DragonK <[EMAIL PROTECTED]> wrote:
>
>
> This seems to work... but I'm not sure if it should, that's why I'm
> asking.
> I hope the code will show more exactly what I intend to do. Sorry for
On 2/7/07, John Stanton <[EMAIL PROTECTED]> wrote:
DragonK wrote:
> On 2/7/07, Ken <[EMAIL PROTECTED]> wrote:
>
>>
>> Try without the pragma and wrap the inserts with a begin transaction
>> and a
>> commit...
>>
>> The performance will b
.
I know, but in my case, I can't use transactions due to the architecture of
the product.
DragonK <[EMAIL PROTECTED]> wrote:
On 2/7/07, Teg wrote:
>
> Hello ohadp,
>
> Well, my experience is, particularly when it's users using it and not
> a personal pr
On 2/7/07, Teg <[EMAIL PROTECTED]> wrote:
Hello ohadp,
Well, my experience is, particularly when it's users using it and not
a personal project, that corruption happens fairly frequently when you
use this pragma. That's why I don't use it any more in my production
code.
Transactions are far sa
On 2/7/07, anis chaaba <[EMAIL PROTECTED]> wrote:
with which language are you trying to do this?
to execute the delete statement you can use transactions to ensure
atomicity.
regards,
I'm using a C++ wrapper over sqlite.
The code i'm running is the following:
SQLiteWrapper w;
On 2/7/07, Ohad Eder-Pressman <[EMAIL PROTECTED]> wrote:
i've got sqlite compiled with visual-studio, with all the default options,
didn't touch anything.
inserts are just a bit too slow for me, is there a good way to speed this
up
using some flags ?
any other flags that it would be smart to tur
Hello everybody,
I'm wondering if the following scenario would work properly:
Run a SELECT query on the database and in a loop retrieve each result;
for each retrieved result, inside the same loop, execute a DELETE statement
for the previously extracted row.
I need this in order to retrieve a l
15 matches
Mail list logo