Re: [sqlite] creating trigger to handle multiple types of insert

2014-11-26 Thread Igor Tandetnik
On 11/26/2014 8:58 PM, Sam Carleton wrote: The question is how to make the trigger work for both cases. Experimentally, when EventNodeId is omitted from INSERT statement, new.EventNodeId == -1 in the trigger. So I think something like this should work: INSERT INTO EventNode ( EventNodeId,

[sqlite] creating trigger to handle multiple types of insert

2014-11-26 Thread Sam Carleton
There are two different types of insert that need to happen into a table, one is where the rowid (EventNodeId) is part of the actual insert, the other it is excluded so that AUTOINCREMENT will fill it in. There is an insert triggers to set the audit fields on the table during the insert. The

Re: [sqlite] Implementing per-value custom types

2014-11-26 Thread James K. Lowden
Darko, I have rather a long answer for you. I'm not confused about the difference between logical and physical types, but I am confused about what you meant and what you're hoping to accomplish. On Wed, 26 Nov 2014 03:22:03 -0800 Darko Volaric wrote: > A 64 bit floating

Re: [sqlite] Network and concurrency

2014-11-26 Thread Stephen Chrzanowski
Try? Don't use a network. It isn't safe due to file locking mechanisms (As you've noted) at the server side, not the client side. The other option is to either build a SQLite server where the local database store is, or, get MySQL/MSSQL up and running. https://www.sqlite.org/whentouse.html

Re: [sqlite] [sqlite-dev] Implementing per-value custom types

2014-11-26 Thread J Decker
a type column to go with variant data would probably be best... how many columns do you have that are actually self-described type required? could just serialize it to a blob; include type, and the value... kinda hard to select for a value that way... at least if it's a parallel type the value

Re: [sqlite] Network and concurrency

2014-11-26 Thread Mike McWhinney
I still get the crashes even after adding the pragma. My connection string looks like: public static string OMconnectionString = "URI=file:omm.db; PRAGMA busy_timeout = 15000" Is there anything else I can try? Mike On Wednesday, November 26, 2014 10:34 AM, Simon Slavin

Re: [sqlite] [sqlite-dev] Implementing per-value custom types

2014-11-26 Thread Darko Volaric
You wrote: "From the tone of your last post (if I am reading correctly) I understand that you have your mind set on finding a way that you have thought about a lot lying in your bed late at night, you have rolled it around in your head and you just "feel" this should be doable and will be so

Re: [sqlite] Network and concurrency

2014-11-26 Thread Simon Slavin
On 26 Nov 2014, at 4:20pm, Mike McWhinney wrote: > Are there any other PRAGMA or connection string > statements that can help with this concurrency issue? If you haven't set a busy timeout then SQlite won't retry when there is a network clash, it will immediately return

[sqlite] Network and concurrency

2014-11-26 Thread Mike McWhinney
Hello, I am continuing to have sporadic problems with SQLite and a WinForms application that I'm developing. The program is a Winforms app using the System.Data.SQLite class. I am running this off a network. There are a small number of users which read and write to a database stored on a

Re: [sqlite] [sqlite-dev] Implementing per-value custom types

2014-11-26 Thread RSmith
On 2014/11/26 15:58, Darko Volaric wrote: I'm not looking for confirmation of ideas, on the contrary, people seem to want to push their own ideas about a database should be used and how I'm not using it correctly, when that is irrlevent to the issue I'm discussing. Maybe more focus on the

Re: [sqlite] Infinite loop in sqlite3VdbeSorterWrite when sorting big data

2014-11-26 Thread Marcin Sobieszczanski
> Thanks for reporting this. I think it should be fixed here: > > http://www.sqlite.org/src/info/623827192532f08b Thanks for the fix! I confirm it fixes the issue I saw. Marcin ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] [sqlite-dev] Implementing per-value custom types

2014-11-26 Thread Darko Volaric
The person I replied to cross posted, not I, and I didn't realise this before I replied to his cross post and the I couldn't change it then, so maybe take that up with him. I'm not confusing anything. You, and the other posters, are confusing the representation of values and the concrete value

Re: [sqlite] Corrupting pointers to the lookaside smallacator

2014-11-26 Thread Paul
We observe very similar problem. #1 0x087ec9f7 in sqlite3VXPrintf () #2 0x087f816d in sqlite3MPrintf () #3 0x088781e5 in sqlite3VtabFinishParse () #4 0x0885190f in yy_reduce () #5 0x0884d4d8 in sqlite3Parser () #6 0x087fc0ce in sqlite3RunParser () #7 0x088aa396 in sqlite3Prepare () #8

Re: [sqlite] [sqlite-dev] Implementing per-value custom types

2014-11-26 Thread RSmith
Hi Darko, Firstly, kindly keep this to the sqlite-users forum and not on the dev forum (the devs read this too, the difference being simply that this one exists to help you, the other one is to discuss development stuff, not to help anyone). Secondly, you are confusing two things. You are

Re: [sqlite] [sqlite-dev] Implementing per-value custom types

2014-11-26 Thread Darko Volaric
That's not true. A 64 bit floating point number and an 64 bit integer can be represented by the exact same 64 bit pattern, and no-one would suggest they're the same value. You can have those two differently typed although identical bit values in the same SQLite column. The data identifying the