[sqlite] Name the arguments in the prototypes.

[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,
int(*xBusy)(void *pArg, int count), void *pArg);
...
SQLITE_API SQLITE_EXPERIMENTAL void *SQLITE_STDCALL sqlite3_profile(sqlite3*,
   void(*xProfile)(void*,const char*,sqlite3_uint64), void*);
versus
SQLITE_API SQLITE_EXPERIMENTAL void *SQLITE_STDCALL sqlite3_profile(sqlite3 *db,
   void(*xProfile)(void *pArg, const char *sql, sqlite3_uint64
nanoseconds), void *pArg);
...
SQLITE_API int SQLITE_STDCALL sqlite3_errcode(sqlite3 *db);
SQLITE_API int SQLITE_STDCALL sqlite3_extended_errcode(sqlite3 *db);
SQLITE_API const char *SQLITE_STDCALL sqlite3_errmsg(sqlite3*);
versus
SQLITE_API const char *SQLITE_STDCALL sqlite3_errmsg(sqlite3 *db);
...

I can give it a try and send you a patch if you want.
Regards.

[sqlite] Name the arguments in the prototypes.

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

[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 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-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] website documentation wording

[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

[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 within the shell.  Is 
there an alternative way to export, other than by using (dot) mode, or am I 
simply out of luck?

Thomas

[sqlite] website documentation wording

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

Yes, that is true. Also, there is a typo in the second line.

They just present different agreements. I believe both are
grammatically correct. However, they differ in meaning, as the first
one treats management as a single unit and the second one emphasizes
that all managers decided something.

-- 
Bernardo Sulzbach

[sqlite] Exporting

[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




> Thomas Morris 
> Sunday, December 6, 2015 11:44
> 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 within the shell. Is there an alternative way to export, 
> other than by using (dot) mode, or am I simply out of luck?
>
> Thomas
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>

[sqlite] Exporting

[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 to the (dot) commands being for use within
> the shell.  Is there an alternative way to export, other than by using (dot)
> mode, or am I simply out of luck?
>

Do you need your Java application to do this export?  Or do you just
need to get this export done, once?

If the latter, then simply move the database file to a workstation and
run the (dot)commands there using a shell.

-- 
D. Richard Hipp
drh at sqlite.org

[sqlite] Exporting

[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 Hipp  wrote:
> 
> 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 to the (dot) commands being for use within
>> the shell.  Is there an alternative way to export, other than by using (dot)
>> mode, or am I simply out of luck?
>> 
> 
> Do you need your Java application to do this export?  Or do you just
> need to get this export done, once?
> 
> If the latter, then simply move the database file to a workstation and
> run the (dot)commands there using a shell.
> 
> -- 
> D. Richard Hipp
> drh at sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Create table while a dbdatareader is open

[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 the create table 
command wants a write lock on sqlite_master.

Cheers, 
  Lars

[sqlite] Exporting

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

[sqlite] Exporting

[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 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 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.
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>