On 07/23/2013 01:38 AM, Philip Goetz wrote:
I have a Perl program that we have run successfully every day for
almost the past 2 years, but which crashes today with the error
message:
FATAL ERR: Can't do PRAGMA cache_size = 100: attempt to write a
readonly database
The SQLite database in
On 7/24/2013 12:34 AM, Kai Peters wrote:
Is it possible to have two (or more) autoincrement columns per table?
No, not automatically. With some work, you could simulate it using AFTER
INSERT trigger.
--
Igor Tandetnik
___
sqlite-users mailing list
Is it possible to have two (or more) autoincrement columns per table?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On 24 Jul 2013, at 12:04am, j.merr...@enlyton.com wrote:
> I do not know if SQLite has the storage behavior that e.g. PostgreSQL and MS
> SQL Server have, which is that null values take up absolutely no space.
SQLite uses a one-byte 'type' indicator, followed by some bytes for the value.
The
On Mon, Jul 22, 2013 at 2:38 PM, Philip Goetz wrote:
> I have a Perl program that we have run successfully every day for
> almost the past 2 years, but which crashes today with the error
> message:
>
> FATAL ERR: Can't do PRAGMA cache_size = 100: attempt to write a
>
On 07/23/2013 02:52 PM, Max Vlasov wrote:
> I've created a kind of triple storage base with Sqlite db as the container.
> Basically it's several tables implementing Object-Propery-Value metaphor.
> There's only one field for data so thinking about generality I assumed that
> the type for the data
I've narrowed this locking issue down to a very simply test case. It seems as
though having the same file attached multiple times with different names
prevents exclusive or immediate transactions from acquiring a lock. Deferred
transactions still seem to work fine. Try the following code:
On Tue, Jul 23, 2013 at 10:09 PM, Petite Abeille
wrote:
>
> On Jul 23, 2013, at 9:52 AM, Max Vlasov wrote:
>
> > Basically it's several tables implementing Object-Propery-Value metaphor
>
> Hurray! The Entity–attribute–value (EAV) anti-pattern!
>
>
There is a minor conflict in the online documentation.
This page: http://www.sqlite.org/fts3.html#section_2
States that: "There is not a separate SQLITE_ENABLE_FTS4 compile-time option"
and that enabling FTS3 also includes FTS4 support.
This page: http://www.sqlite.org/compile.html
States that
On Jul 23, 2013, at 9:52 AM, Max Vlasov wrote:
> Basically it's several tables implementing Object-Propery-Value metaphor
Hurray! The Entity–attribute–value (EAV) anti-pattern!
"… an EAV based approach is an anti-pattern which can lead to longer
development times, poor
Hi,
Apologies for jumping in here.
I was interested in your question as I have some development going on which
will eventually go into production on a VMWare ESXI server, which could be
either Linux or Windows.
When you say you are running sqlite3 on esxi5 do you mean that you are running
I am getting request from different process for different SQlite3 operation
to be performed. Here I want to restrict Update/Alter/Drop operation to
creator of the table but read can be done by all.
I am using sqlite3_exec() for query execution. In those scenarios can I
directly map
1 1 wrote:
> I've tried to run the latest version of sqlite3 on esxi 5.0 (VMware
> hypervisor), but unsuccessfully. Strace shows "fcntl function not
> implemended".
Apparently, VMFS does not implement file locking.
Try using the unix-dotfile VFS, or unix-none if you can guarantee that
the
On 23 Jul 2013, at 12:26pm, techi eth wrote:
> I would like to check how we can restrict SQLite3 for more
> updating/dropping (I think this two will restrict flash life) based on
> memory life.
>
> If I say my flash will support ‘N’ Thousand access over the life time.
You
I have a Perl program that we have run successfully every day for
almost the past 2 years, but which crashes today with the error
message:
FATAL ERR: Can't do PRAGMA cache_size = 100: attempt to write a
readonly database
The SQLite database in question is readonly (group and world have only
Hello.
I've tried to run the latest version of sqlite3 on esxi 5.0 (VMware
hypervisor), but unsuccessfully. Strace shows "fcntl function not implemended".
Older versions return "disk i/o errors" or "database is locked" then create
table request invoked. Do you have any ideas how to resolve
- You have another open operation or transaction which has not been
committed or finalized or in some way completed.
If I only have one connection, there can't be another uncommitted transaction?
Well there can be, which would cause a BUSY signal. Unless you've had success beginning the new
I would like to check how we can restrict SQLite3 for more
updating/dropping (I think this two will restrict flash life) based on
memory life.
If I say my flash will support ‘N’ Thousand access over the life time.
Cheers-
Techi
___
sqlite-users
Thank you all very much for your answers..
On Mon, Jul 22, 2013 at 9:07 AM, RSmith wrote:
> - You have another open operation or transaction which has not been
> committed or finalized or in some way completed.
If I only have one connection, there can't be another
On 07/23/2013 04:53 PM, Max Vlasov wrote:
On Tue, Jul 23, 2013 at 1:38 PM, Dan Kennedy wrote:
On 07/23/2013 02:52 PM, Max Vlasov wrote:
So
par adoxically probably the best type for universal field container is
REAL
(or NUMERIC) since it will accept data of any
Max Vlasov wrote:
> On Tue, Jul 23, 2013 at 1:32 PM, Clemens Ladisch wrote:
>> But REAL will sort the strings '1', '10', '2' wrong.
>
> What do you mean by "wrong"?
>
> 1, 2, 10, something
> that's what I wanted
So you actually want to sort strings as if they were numbers (if
On Tue, Jul 23, 2013 at 1:38 PM, Dan Kennedy wrote:
> On 07/23/2013 02:52 PM, Max Vlasov wrote:
>
>> So
>> par adoxically probably the best type for universal field container is
>> REAL
>> (or NUMERIC) since it will accept data of any type, but has advantage of
>>
On Tue, Jul 23, 2013 at 1:32 PM, Clemens Ladisch wrote:
>
>
> But REAL will sort the strings '1', '10', '2' wrong.
>
What do you mean by "wrong"?
The test
CREATE TABLE testtable (id integer primary key, value real);
insert into testtable (value) values ('1');
insert into
On 07/23/2013 02:52 PM, Max Vlasov wrote:
I've created a kind of triple storage base with Sqlite db as the container.
Basically it's several tables implementing Object-Propery-Value metaphor.
There's only one field for data so thinking about generality I assumed that
the type for the data field
Max Vlasov wrote:
> I've created a kind of triple storage base with Sqlite db as the container.
> Basically it's several tables implementing Object-Propery-Value metaphor.
> There's only one field for data so thinking about generality I assumed that
> the type for the data field should be TEXT of
I've created a kind of triple storage base with Sqlite db as the container.
Basically it's several tables implementing Object-Propery-Value metaphor.
There's only one field for data so thinking about generality I assumed that
the type for the data field should be TEXT of nothing since most of
26 matches
Mail list logo