On 2011-05-24 18:37, Ruth Ivimey-Cook wrote:
> So far the create database thing is my bugbear. It doesn't seem hard or
> bad practice to implement "create database" as a no-op (or better, an
> expunge of the current file so that the app sees an empty database).
>
> I guess a workaround could be to
Joe
Thanks for the work helping make the linq side happen!
> Ruth Ivimey-Cook wrote:
>> If I try to query database existence using Linq's "DatabaseExists" I get
>> a NotImplemented exception in the sqlite ChangeDatabase function - which
>> doesn't make sense to me.
> I have never in my life messe
On 2011-05-24 09:28, Ruth Ivimey-Cook wrote:
> Folks,
>
> Has anyone successfully used system.data.linq and system.data.sqlite
> together with the linq CreateDatabase function?
>
> When I try, I get an exception "syntax error near "DATABASE"".
>
> If I try to query database existence using Linq's "
On Tue, May 24, 2011 at 1:36 PM, Marco Turco wrote:
> Hi all,
> We are successfully using the SEE module in Sqlite.
> All runs well but we need to provide a ODBC connection to a limited number
> of users.
>
> Question: is there a Sqlite odbc driver SEE compatible ?
>
http://www.ch-werner.de/sqlit
Hi all,
We are successfully using the SEE module in Sqlite.
All runs well but we need to provide a ODBC connection to a limited number
of users.
Question: is there a Sqlite odbc driver SEE compatible ?
Thanks.
Regards,
Marco Turco
IT Business Devl Manager
Software XP LLP
__
Viadana, Italy - SQLabs announced cubeSQL a fully featured and high performance
relational database management system built on top of the sqlite database
engine. It is the ideal database server for both developers who want to convert
a single user database solution to a multiuser project and for
"BareFeetWare", on Tuesday, May 24, 2011 8:31 AM wrote...
On 23/05/2011, at 11:13 PM, jose isaias cabrera wrote:
SharedDB file is about 600 megs shared over a network drive and it's
getting
slow, but if I get the specific record ID only with the select that I
want,
it's a lot faster than ge
> Surely, the fact that SQLite doesn't permit one file having several
> databases should just mean that "CREATE DATABASE ;" is a really
> simple operation, not that it throws an exception and/or fails.
There's no such command in SQLite. So if Linq can't live without
issuing this command then i
Pavel Ivanov wrote:
>> If I try to query database existence using Linq's "DatabaseExists" I get
>> a NotImplemented exception in the sqlite ChangeDatabase function - which
>> doesn't make sense to me.
> SQLite doesn't have a notion of server containing several databases.
> That's why it makes perfe
Hello Pavel,
Thanks. This is the conclusion I was arriving at. I do use the Sqlite3
utility but only for looking at test results when the server is in an inactive
state.
Thanks,
John
--- On Tue, 5/24/11, Pavel Ivanov wrote:
> From: Pavel Ivanov
> Subject: Re: [sqlite] Multi-threading Com
> If I try to query database existence using Linq's "DatabaseExists" I get
> a NotImplemented exception in the sqlite ChangeDatabase function - which
> doesn't make sense to me.
SQLite doesn't have a notion of server containing several databases.
That's why it makes perfect sense that SQLite doesn
> I don't want per-say to remove my pthread_rwlock() but the main point of this
> discussion is I should not have to use pthread_rwlock().
I'd say pthread_rwlock and SQLite-specific mechanisms work completely
differently and you should choose depending on what you want to do. As
you saw to use SQ
Folks,
Has anyone successfully used system.data.linq and system.data.sqlite
together with the linq CreateDatabase function?
When I try, I get an exception "syntax error near "DATABASE"".
If I try to query database existence using Linq's "DatabaseExists" I get
a NotImplemented exception in the
I'm using sqlite v3 as database backend for an very small web app (some of 20
concurrent users -really serial access users-).. in Ms. Win xp (my test/develop
env.) it work perfectly...my web app can handle that load(and even more by
My JMeter Tests)...
But on my production environment (L
Hello Pavel,
I don't want per-say to remove my pthread_rwlock() but the main point of this
discussion is I should not have to use pthread_rwlock(). Others have mentioned
I should be using SQLite-specific mechanisms to achieve the same results. I am
just trying to understand how to do that. P
> I have all writes in transactions. If I deactivate my pthread_rwlock() that
> enforce the above, several writes fail with a "database locked" error (I
> assume it is returning SQLITE_BUSY).
>
> So how do I implement the equivalent of a pthread_rwlock() using SQLite
> mechinisms?
When SQLITE_
On 23/05/2011, at 11:13 PM, jose isaias cabrera wrote:
> SharedDB file is about 600 megs shared over a network drive and it's getting
> slow, but if I get the specific record ID only with the select that I want,
> it's a lot faster than getting the select with all the items in one shot.
> SQLit
On 24 May 2011, at 12:43pm, John Deal wrote:
> Sorry to be so brain-dead but I am still confused. I have multiple threads,
> each with their own DB connection.
Read
http://www.sqlite.org/threadsafe.html
If it's not clear to you please ask specific questions about what's on that
page, since
Hello Roger,
Sorry to be so brain-dead but I am still confused. I have multiple threads,
each with their own DB connection. I want to allow multiple readers accessing
the DB at the same time since nothing is changing. However, if a writes is to
take place, I want all readers to finish their
On Tue, May 24, 2011 at 5:39 AM, Singh, Manpreet wrote:
> Hello,
>
>
>
> Resending with some more finding any help would be appreciated. One of
> the tables in the database is getting corrupted.
>
http://www.sqlite.org/howtocorrupt.html
http://www.sqlite.org/lockingv3.html#how_to_corrupt
http://w
Hello,
Resending with some more finding any help would be appreciated. One of
the tables in the database is getting corrupted.
1. Sqlite>select count(*) from $table_name
..
7981508|35001|284
7981509|35002|284
7981510|35003|284
7981511|35004|284
SQL error: database disk image is malfo
See also
https://rt.cpan.org/Ticket/Display.html?id=68396
Using gcc-3.4.6 on HP-UX 10.20:
> make test
gcc -c -I. -I/opt/perl/lib/site_perl/5.14.0/PA-RISC2.0/auto/DBI -mpa-
risc-1-1 -DPERL_DONT_CREATE_GVSV -D_HPUX_SOURCE -fno-strict-aliasing -
pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/23/2011 09:12 PM, John Deal wrote:
> I guess I am lost on how to obtain a many reader or one writer mutex in
> SQLite.
You are confusing locks on the database and locks in the library on a
sqlite3 pointer. The latter is what the mutex alloc fu
23 matches
Mail list logo
