Re: [sqlite] Using sqlite.net with Linq to create database

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

Re: [sqlite] Using sqlite.net with Linq to create database

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

Re: [sqlite] Using sqlite.net with Linq to create database

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

Re: [sqlite] SEE encryption lib and odbc

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 ? >

[sqlite] SEE encryption lib and odbc

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

[sqlite] [ANN] cubeSQL

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

Re: [sqlite] Better way to get records by IDs

"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

Re: [sqlite] Using sqlite.net with Linq to create database

> 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

Re: [sqlite] Using sqlite.net with Linq to create database

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

Re: [sqlite] Multi-threading Common Problem

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 >

Re: [sqlite] Using sqlite.net with Linq to create database

> 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

Re: [sqlite] Multi-threading Common Problem

> 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

[sqlite] Using sqlite.net with Linq to create database

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

[sqlite] Database Locked

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

Re: [sqlite] Multi-threading Common Problem

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.

Re: [sqlite] Multi-threading Common Problem

> 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

Re: [sqlite] Better way to get records by IDs

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. >

Re: [sqlite] Multi-threading Common Problem

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

Re: [sqlite] Multi-threading Common Problem

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

Re: [sqlite] Help sqlite database corruption

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

Re: [sqlite] Help sqlite database corruption

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

[sqlite] [PATCH] Won't compile on archaic OS

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

Re: [sqlite] Multi-threading Common Problem

-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