[sqlite] Request: Metadata about C API constants and functions

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I am the author of a Python wrapper for SQLite. As part of my documentation build process I link function names to the relevant page in the SQLite doc. I also have to wrap all constants - eg making sure that all SQLITE_LIMIT_ ones are wrapped and poi

[sqlite] Request: Metadata about C API constants and functions

On 4/9/15, Roger Binns wrote: > These are the details of what I need: > > For each function, its name, the doc page and fragment, and ideally a > few word description of it (the title on the doc page is fine). > > For each family of constants (eg result codes, extended result codes, > run time lim

[sqlite] Request: Metadata about C API constants and functions

On 10 Apr 2015, at 1:42am, Richard Hipp wrote: > As it happens, the SQLite documentation build process already parses > out most of this and puts it into a database already. If you > check-out the documentation sources > (https://www.sqlite.org/docsrc/timeline) and successfully build the > docu

[sqlite] Request: Metadata about C API constants and functions

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 04/09/2015 05:42 PM, Richard Hipp wrote: > On 4/9/15, Roger Binns wrote: >> A JSON or XML file with that would make my life a lot easier. > > JSON/XML? Seriously? We eat our own dogfood here, thank you! > When you get the data it will be in an S

[sqlite] Request: Metadata about C API constants and functions

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 04/09/2015 06:43 PM, Simon Slavin wrote: > Hmm. We could add an output mode to the shell tool which outputs > in JSON format. And by "We" I mean someone who can write good C, > which isn't me. Get yourself a time machine, go back 6 years, and enj

[sqlite] Request: Metadata about C API constants and functions

On Fri, Apr 10, 2015 at 2:42 AM, Richard Hipp wrote: > On 4/9/15, Roger Binns wrote: > > For each function, its name... > > As it happens, the SQLite documentation build process already parses > out most of this and puts it into a database already. If you > check-out the documentation sources

[sqlite] Request: Metadata about C API constants and functions

On 4/10/15, Dominique Devienne wrote: > But that's build time. There is no way (i.e. pragma) to list registered SQL > functions at runtime. > > This is something that I've asked for before, and I'm having trouble > understanding why nobody cares. > > When you run an SQLite "shell", the host progra

[sqlite] Request: Metadata about C API constants and functions

On Fri, Apr 10, 2015 at 9:48 AM, Zsb?n Ambrus wrote: > On 4/10/15, Dominique Devienne wrote: > > But that's build time. There is no way (i.e. pragma) to list registered > SQL functions at runtime. > > Um, you're talking about SQL functions. But I think Roger asked for C > functions in the publi

[sqlite] Request: Metadata about C API constants and functions

On 2015-04-10 09:48 AM, Zsb?n Ambrus wrote: > On 4/10/15, Dominique Devienne wrote: >> But that's build time. There is no way (i.e. pragma) to list registered SQL >> functions at runtime. >> >> This is something that I've asked for before, and I'm having trouble >> understanding why nobody cares

[sqlite] Request: Metadata about C API constants and functions

On 10 Apr 2015, at 12:53pm, R.Smith wrote: > It doesn't matter, C API calls or pragma, whatever works best as long as > there is /some/ way to get to that info. Usually though, most C API calls > valuable to end users too, ends up having a pragma that can produce similar > output. I think t

[sqlite] Request: Metadata about C API constants and functions

On 2015-04-10 02:09 PM, Simon Slavin wrote: > On 10 Apr 2015, at 12:53pm, R.Smith wrote: > >> It doesn't matter, C API calls or pragma, whatever works best as long as >> there is /some/ way to get to that info. Usually though, most C API calls >> valuable to end users too, ends up having a pr

[sqlite] Request: Metadata about C API constants and functions

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 04/10/2015 12:33 AM, Dominique Devienne wrote: > But that's build time. There is no way (i.e. pragma) to list > registered SQL functions at runtime. There is a ticket for this: https://www.sqlite.org/src/tktview/5896edbe463b6a1f0f14 It was reje

[sqlite] Request: Metadata about C API constants and functions

On 4/9/15, Roger Binns wrote: > > So the URL for this SQLite database is? :-) > https://www.sqlite.org/toc.db -- D. Richard Hipp drh at sqlite.org

[sqlite] Request: Metadata about C API constants and functions

On 2015-04-10 04:11 PM, Richard Hipp wrote: > https://www.sqlite.org/toc.db Thank you Richard! Will this link always have the latest DB? This db format is preferred, but in case anyone is still interested in the webby formats, here is the DB in XML: http://sqlc.rifin.co.za/toc.xml and JSON:

[sqlite] Request: Metadata about C API constants and functions

On 10 Apr 2015, at 5:00pm, R.Smith wrote: > On 2015-04-10 04:11 PM, Richard Hipp wrote: >> https://www.sqlite.org/toc.db > > Thank you Richard! > Will this link always have the latest DB? If I may suggest ... in that database, introduce a new column which holds the version in which that call

[sqlite] Request: Metadata about C API constants and functions

Thanks, Richard I found (https://www.sqlite.org/docsrc/timeline) & https://www.sqlite.org/docsrc/artifact/5c48dd261dbe5804 very useful. Last year I was parsing 100M of XML stuff and loading it into an Sqlite database. A bit of hammering required as the XML had minor errors like missing end tags.

[sqlite] Request: Metadata about C API constants and functions

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 04/10/2015 07:11 AM, Richard Hipp wrote: > On 4/9/15, Roger Binns wrote: >> >> So the URL for this SQLite database is? :-) >> > > https://www.sqlite.org/toc.db Thank you for this. I've now updated my doc build tools, and even added some more

[sqlite] Request: Metadata about C API constants and functions

On 16 Apr 2015, at 12:31am, Roger Binns wrote: > It is a very productive time when you > get to delete code :-) See the paragraph "How do you measure programmer productivity?" half way down the page, just before the

[sqlite] Request: Metadata about C API constants and functions

On 2015-04-10 04:11 PM, Richard Hipp wrote: > https://www.sqlite.org/toc.db I download this and do the following: 164:~ simon$ sqlite3 /Users/simon/Desktop/toc.db SQLite version 3.8.5 2014-08-15 22:37:57 Enter ".help" for usage hints. sqlite> .mode column sqlite> select * from toc limit 10; sql

[sqlite] Request: Metadata about C API constants and functions

On Thu, 16 Apr 2015 00:40:28 +0100 Simon Slavin wrote: > > It is a very productive time when you > > get to delete code :-) > > "[If] we wish to count lines of code, we should not regard them as "lines produced