[sqlite] Name the arguments in the prototypes.

2015-12-06 Thread gwenn
Hello, Would you mind adding argument names in function prototypes ? http://www.sqlite.org/cgi/src/artifact/1248a78548024bdc SQLITE_API int SQLITE_STDCALL sqlite3_busy_handler(sqlite3*, int(*)(void*,int), void*); versus SQLITE_API int SQLITE_STDCALL sqlite3_busy_handler(sqlite3 *db,

[sqlite] Name the arguments in the prototypes.

2015-12-06 Thread Richard Hipp
On 12/6/15, gwenn wrote: > Hello, > Would you mind adding argument names in function prototypes ? Would you mind explaining why this might be helpful? -- D. Richard Hipp drh at sqlite.org

[sqlite] Name the arguments in the prototypes.

2015-12-06 Thread gwenn
Maybe because I am lazy. I can read all the documentation attached to the function prototype. But I can quickly glean what a function does from its prototype. And it helps autocompletion. Thanks. On Sun, Dec 6, 2015 at 12:16 PM, Richard Hipp wrote: > On 12/6/15, gwenn wrote: >> Hello, >> Would

[sqlite] website documentation wording

2015-12-06 Thread Niall O'Reilly
On Fri, 04 Dec 2015 18:46:27 +, Keith Medcalf wrote: > > Intel's Management has decided -- for the imperfect tense. > Intel's Managemant have decided -- for the past perfect tense. Eh? These examples show the same tense. Niall O'Reilly

[sqlite] Exporting

2015-12-06 Thread Thomas Morris
I recently took over a Java based application that has SQLite embedded and now I need to export the database into a CSV format. Reading online, I have found that using (dot)mode csv, or any (dot) command is not possible when SQLite is embedded, simply due to the (dot) commands being for use

[sqlite] website documentation wording

2015-12-06 Thread Bernardo Sulzbach
On Sun, Dec 6, 2015 at 4:39 PM, Niall O'Reilly wrote: > On Fri, 04 Dec 2015 18:46:27 +, > Keith Medcalf wrote: >> >> Intel's Management has decided -- for the imperfect tense. >> Intel's Managemant have decided -- for the past perfect tense. > > Eh? These examples show the same tense. >

[sqlite] Exporting

2015-12-06 Thread Jeff Steinkamp
In java it is a simple matter of reading in the data using a SQL statement to fetch all the data, then using a standard Java CSVWriter class to export that data in the proper format. -- Jeff K. Steinkamp (N7YG) Tucson, AZ Scud Missile Coordinates N32.2319 W110.8477

[sqlite] Exporting

2015-12-06 Thread Richard Hipp
On 12/6/15, Thomas Morris wrote: > I recently took over a Java based application that has SQLite embedded and > now I need to export the database into a CSV format. Reading online, I have > found that using (dot)mode csv, or any (dot) command is not possible when > SQLite is embedded, simply due

[sqlite] Exporting

2015-12-06 Thread Thomas Morris
Unfortunately, the application is required. I am working on a government network and I cannot install sqlite, I can just run it through the application. I actually do not even access to use the command prompt to initialize the sqlite shell. Thomas Morris > On Dec 6, 2015, at 3:29 PM, Richard

[sqlite] Create table while a dbdatareader is open

2015-12-06 Thread Lars Fiedler
Is it possible with certain settings to have a dbdatareader iterating through rows, and at the same time create a new table? I've tried various settings - read uncommitted, wal mode, shared cache. But it looks like the open reader has a read lock on sqlite_master (not read uncommitted), and

[sqlite] Exporting

2015-12-06 Thread Simon Slavin
If you cannot run any program apart from the ones already installed then your only option is to copy the database file to another computer. - Simon > On 6 Dec 2015, at 8:35 p.m., Thomas Morris wrote: > > Unfortunately, the application is required. I am working on a government > network

[sqlite] Exporting

2015-12-06 Thread Jim Callahan
Copying the file to another computer would likely work; except if the application encrypted the data. Jim On Sun, Dec 6, 2015 at 5:22 PM, Simon Slavin wrote: > If you cannot run any program apart from the ones already installed then > your only option is to copy the database file to another