Re: [sqlite] Any chance of exposing INTEGER PRIMARY KEY metadata? Needed by many tools

Hi Richard, Thank you for replying personally. Apologies in advance if I use the wrong terminology. I haven't looked at SQLite since the previous discussion in this thread, as I've been waiting for this needed "feature". I just have to say you treat ROWID like it's your quasimodo. A thing you

Re: [sqlite] Any chance of exposing INTEGER PRIMARY KEY metadata? Needed by many tools

On 3/5/18, Peter Halasz wrote: > The "table_ipk" pragma statement didn't seem to make it into 3.22. Is > there any reason it hasn't been merged? Lack of perceived benefit. Our goal is to support SQLite for 3 more decades. Every new feature that is added has to be

Re: [sqlite] Any chance of exposing INTEGER PRIMARY KEY metadata? Needed by many tools

The "table_ipk" pragma statement didn't seem to make it into 3.22. Is there any reason it hasn't been merged? There is still no other reasonable way for third party tools to reliably tell if a column is an "integer primary key" or just a primary key which happens to be an integer.

Re: [sqlite] Any chance of exposing INTEGER PRIMARY KEY metadata? Needed by many tools

On Tue, Nov 28, 2017 at 9:33 PM, J. King wrote: > ...*that I never thought to ask*, many of which have been helpful in > refining my application. ... > +1 that. That is the main advantage of a mailing list over a forum with filter-bubble or god forbid 'personalization'. I

Re: [sqlite] Any chance of exposing INTEGER PRIMARY KEY metadata? Needed by many tools

Please forgive the off-topicedness of this message, but I would like to second that this mailing list is incredibly edifying, and I would also like thank everyone who has both answered and asked questions in the time I've been subscribed. I've stumbled across answers here that I never thought

Re: [sqlite] Any chance of exposing INTEGER PRIMARY KEY metadata? Needed by many tools

That's terrific! Looking forward to it being in a full release. Hopefully the next tool developer to come along won't need to write a custom SQL parser, get lost in irrelevant datatype documentation, sift through op codes from an unnestable "explain" statement, compile a custom SQLite C

Re: [sqlite] Any chance of exposing INTEGER PRIMARY KEY metadata? Needed by many tools

Hey Peter. Good on you. Lobbying for sensible fixes to the public API does pay off sometimes. There's a new branch in the timeline. [Watch for a merge here: https://www.sqlite.org/src/timeline?n=50 ] https://www.sqlite.org/src/info/2494132a2b1221a4 ** PRAGMA table_ipk() ** ** If has

Re: [sqlite] Any chance of exposing INTEGER PRIMARY KEY metadata? Needed by many tools

sers-boun...@mailinglists.sqlite.org] On Behalf Of Clemens Ladisch Sent: Tuesday, November 28, 2017 3:39 AM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] Any chance of exposing INTEGER PRIMARY KEY metadata? Needed by many tools Peter Halasz wrote: > However, it's quite clear

Re: [sqlite] Any chance of exposing INTEGER PRIMARY KEY metadata? Needed by many tools

Peter Halasz wrote: > However, it's quite clear to me, as only a user of just a few of these > tools and libraries, that they would be improved greatly if they had a > direct way of querying which field in a SQLite table was acting as an alias > of ROW ID. The rowid column must have the type

Re: [sqlite] Any chance of exposing INTEGER PRIMARY KEY metadata? Needed by many tools

>Can you not deduce what you want using sqlite_sequence, as described >in section 2.6.1 of > >? This allows you to distinguish a primary key which happens to be >an integer from an |NTEGER PRIMARY KEY. No it does not. It only

Re: [sqlite] Any chance of exposing INTEGER PRIMARY KEY metadata? Needed by many tools

On 28 Nov 2017, at 12:38am, Peter Halasz wrote: > Please can SQLite developers make the ROW ID status of a field visible in > future versions? If it’s cone, the obvious place would be to add a column to Can you not

[sqlite] Any chance of exposing INTEGER PRIMARY KEY metadata? Needed by many tools

Disclaimer: I am not a developer on linq2db. Nor am I a developer on "DB Browser for SQLite", nor am I a developer of any of the other tools which help developers create SQLite databases and integrate them with their projects through UIs and APIs built on SQLite and its metadata. However, it's