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

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 repr

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

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 argu

Re: [sqlite] Corrupting pointers to the lookaside smallacator

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 0x087fae18

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

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 typ

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

> 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 http://sqlite.org:80

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

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 techni

[sqlite] Network and concurrency

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 netwo

Re: [sqlite] Network and concurrency

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 an error code. If you

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

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 elega

Re: [sqlite] Network and concurrency

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 wrote: On 26

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

a type column to go with variant data would probably be best... how many columns do you have that are actually self-described type&data 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 valu

Re: [sqlite] Network and concurrency

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 Spe

Re: [sqlite] Implementing per-value custom types

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 point number and an

[sqlite] creating trigger to handle multiple types of insert

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 questi

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

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