[sqlite] ensuring uniqueness of tuples spanning across multiple tables?

Well, this case is somewhat weird. I have a number of tables like: PRAGMA foreign_keys = 1; CREATE TABLE foo-L ( key INTEGER PRIMARY KEY REFERENCES foo (key), value INTEGER NOT NULL); Which are tied to a single table, like: CREATE TABLE foo (

Re: [sqlite] ensuring uniqueness of tuples spanning across multiple tables?

On 4 Oct 2011, at 8:30am, Ivan Shmakov wrote: This structure is, obviously, could just as well be represented with, e. g.: CREATE TABLE foo ( key INTEGER PRIMARY KEY, value INTEGER NOT NULL, value-1 INTEGER, … value-N INTEGER); (I. e.,

[sqlite] System.Data.SQLite version 1.0.76.0 released

System.Data.SQLite version 1.0.76.0 is now available on the System.Data.SQLite website: http://system.data.sqlite.org/ Further information about this release can be seen at http://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the SQLite mailing list

[sqlite] [ANN] ODB C++ ORM 1.6.0 released, adds object projections

Hi, I am pleased to announce the release of ODB 1.6.0. ODB is an open-source object-relational mapping (ORM) system for C++. It allows you to persist C++ objects to a relational database without having to deal with tables, columns, or SQL and without manually writing any of the mapping code.

Re: [sqlite] ensuring uniqueness of tuples spanning across multipletables?

Ivan Shmakov i...@gray.siamics.net wrote: Well, this case is somewhat weird. I have a number of tables like: PRAGMA foreign_keys = 1; CREATE TABLE foo-L ( key INTEGER PRIMARY KEY REFERENCES foo (key), value INTEGER NOT NULL); Which are tied to a single table,

Re: [sqlite] sqlite3.OperationalError: disk I/O error

Thanks for the advice. I ran my python script using strace. It is failing under the fcntl() command. strace says that (Function not implemented). I did a search on google and found the following under the sqlite3 FAQ: SQLite uses reader/writer locks to control access to the database...But use

Re: [sqlite] Problems building/running SQLite test.exe with ICU enabled

I copied those dll files to my folder and still get the same error. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin Sent: Monday, October 03, 2011 4:14 PM To: 'General Discussion of SQLite Database' Subject:

Re: [sqlite] sqlite3.OperationalError: disk I/O error

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/04/2011 06:34 AM, Dungan, Kerry wrote: At this point, I guess my next step is to figure out how to get this fixed (any suggestions). Do not use SQLite with a networked file system. If there will only be one client so locking is not a big

Re: [sqlite] sqlite3.OperationalError: disk I/O error

Thanks for the info, my database interfaces to an application that is automatically reading/writing from/to the database, while the client side gets information from and sends information to the application through the database. There will be multiple clients. I may need to use a database like

Re: [sqlite] sqlite3.OperationalError: disk I/O error

On Tue, Oct 4, 2011 at 11:36 AM, Dungan, Kerry kdun...@hpti.com wrote: Thanks for the info, my database interfaces to an application that is automatically reading/writing from/to the database, while the client side gets information from and sends information to the application through the

[sqlite] SQLite feature request: strict quoting pragma

Upon reading Programmers are cautioned not to use the two exceptions described in the previous bullets at http://www.sqlite.org/lang_keywords.html, the goody two-shoes in me thought, I would like a pragma that disables those exceptions, i.e. a strict quoting pragma. Then I could use that pragma

Re: [sqlite] Problems building/running SQLite test.exe withICU enabled

Marc Henrickson wrote: I copied those dll files to my folder and still get the same error. Ok. At this point, the best thing to do is to run the SysInternals ProcMon tool and carefully go over the logs it generates to determine which DLL is not being found and where the system is searching

[sqlite] issue loading SQLite.Interop.dll in different folder

Hi, I'm using System.Data.SQLite in my C# application which can run on x86 and x64. All my assemblies are in a main folder or its subfolders. I set the private bin path so that all assemblies will be automatically found by .Net. Assemblies that are specific to x86 or x64 are in folders with 32

Re: [sqlite] ensuring uniqueness of tuples spanning across multipletables?

Igor Tandetnik itandet...@mvps.org writes: Ivan Shmakov i...@gray.siamics.net wrote: This structure is, obviously, could just as well be represented with, e. g.: CREATE TABLE foo ( key INTEGER PRIMARY KEY, value INTEGER NOT NULL, value-1 INTEGER, …

Re: [sqlite] issue loading SQLite.Interop.dll in different folder

RizThon wrote: All my assemblies are in a main folder or its subfolders. I set the private bin path so that all assemblies will be automatically found by .Net. Assemblies that are specific to x86 or x64 are in folders with 32 or 64 appended to their name. It looks like MainDir Database

Re: [sqlite] issue loading SQLite.Interop.dll in different folder

Unfortunately, the PrivateBinPath only applies to managed assemblies, not to native DLLs. The native DLL search mechanism built into Windows uses completely different search semantics. See: http://msdn.microsoft.com/en-us/library/ms684179%28v=VS.85%29.aspx Thanks, now I understand why it

[sqlite] How do you check if a sqlite database is open?

Does anyone know how to check if a sqlite database is open?  I know sqlite3_open method is used to open the database but is there a method to check if it is already open? Thanks, James ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] How do you check if a sqlite database is open?

On Wed, Oct 5, 2011 at 6:48 AM, James Brison rman...@yahoo.com wrote: Does anyone know how to check if a sqlite database is open? I know sqlite3_open method is used to open the database but is there a method to check if it is already open? An app cannot use an sqlite3 handle unless open has

Re: [sqlite] How do you check if a sqlite database is open?

Doesn't int rc = sqlite3_open ... open the database?   I have a situation where a detail view executes a select statement based upon a row selected from the master.  The Detail view and the Master open the database before executing their respective queries.  I am receiving a SCHEMA_ERROR, I

Re: [sqlite] How do you check if a sqlite database is open?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/04/2011 10:35 PM, James Brison wrote: I am receiving a SCHEMA_ERROR, I believe this is happening because the Master doesn't close it's connection before the Detail re-opens the db. Huh? What would lead you to believe that? In any event just

Re: [sqlite] How do you check if a sqlite database is open?

What is odd, is that I am using the prepare_v2 API.  The documentation says it should not happen but I am getting a return code 17.  I'm trying to debug this now...  Can you open a database twice without closing it? And what problems might this condition cause? Again in my log, I see the