Re: [sqlite] How many AUTOINCREMENT tables are in your schema?

0 in all schemas On 21 March 2018 at 09:22, R Smith wrote: > > On 2018/03/21 11:13 AM, Paul Sanderson wrote: >> >> Actually it is totally different Chris > > > Indeed, and thank you for highlighting this. > > I'm so used to putting down CREATE TABLE t (id INTEGER PRIMARY KEY, f2, > f3,... ) and s

[sqlite] Function design question

I am using a trigger to maintain some audit information, for example updating row modification time on any insert or update. I now want to extend that mechanism to include other information from my application, for example logged in user name. I can do that by registering new functions to pass the

Re: [sqlite] PRAGMA optimize; == no busy handler?

transaction, then a separate quick write transaction could be used to update the stat tables. Theres no need for the whole operation to be atomic, right? On 5 October 2017 at 00:37, Simon Slavin wrote: > > > On 5 Oct 2017, at 12:07am, Toby Dickenson wrote: > > > How does PRAGMA o

Re: [sqlite] PRAGMA optimize; == no busy handler?

How does PRAGMA optimize or ANALYSE affect concurrency? Is there any risk that it might leave the database locked for the full duration of the scan? On 4 October 2017 at 23:29, Jens Alfke wrote: > > >> On Oct 4, 2017, at 10:30 AM, Richard Hipp wrote: >> >> The PRAGMA optimize command is our effo

[sqlite] sqlite security

Hi all, I have a question about security considerations for using sqlite. Suppose I have two processes which communicate via a shared database. One process is internet-facing, and therefore carries a risk of being compromised. The second process is running under a different uid, and has access to

Re: [sqlite] releasing EXCLUSIVE lock after writing dirty pages from the memory cache into the DB ?

a dual-license - an open-source non-commercial license, or a commercial and fully supported license. (In full disclosure, I am a Senior SC supporting Berkeley at Oracle, and I get a commission on BDB sales.) Toby Ferguson -Original Message- From: Guillaume Duranceau [mailto:guillaume.dur

Re: [sqlite] SQLite Wrapper

in a C library in a very useful manner. Toby On Apr 14, 4:23 am, Andreas Henningsson wrote: > Looked at the source code. It is some parts in C also. I did not know that > is > was possible to mix java and C. > > You have using a very rare platform. Why do you use mips? > >

Re: [sqlite] SQLite Wrapper

Navaneeth - Java wrappers for SQLite3 are available from Christian Werner's site, including a JDBC wrapper. http://www.ch-werner.de/javasqlite/ This is the wrapper that is being shipped with Berkeley DB 11GR2. Toby On Apr 13, 10:17 pm, Navaneeth Sen B wrote: > Hi all, > > I woul

Re: [sqlite] Writing SQL with special characters

You can use the hex code of the non-printable character: update tableA set field1 = "line1 x'0a' line2" -Toby >Are there any docs for how to write SQL for special characters like >return and linefeed? > >On some systems (eg. http://www.wilsonmar.com/1eschars.ht

Re: [sqlite] Formatting to "Sentence case"?

Perhaps by doing an UPDATE with: set booktitle = upper(substr(booktitle,1,1)) || lower(substr(booktitle,2)) Regards, -Toby >Hello > >A column holds book titles which are all in capital letters ("MY BOOK >TITLE"), and I'd like to reformat them as "My book t

Re: [sqlite] How to get the specific row?

-- get the Nth record from the top: select * from tblname order by id asc limit N-1,1 -- get the Nth record from the bottom: select * from tblname order by id desc limit N-1,1 Regards, -Toby >Hi all >I create a table like this: >sqlite3_exec(db, "CREATE TABLE TBLNAME (ID >IN

Re: [sqlite] from access to sqlite

ORDER BY data_ora" In Access SQL you would enclose the date variables with #. dhRichClient = End of 20MB ADO desktop installations!! -Toby ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] a suggestion to write tutorial for sqlite

sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > -- Sent by Toby Roworth ([EMAIL PROTECTED]) This message is intended for the named reciepients only, and should not be forwarded without permission The conents of this message may be ©To

Re: [sqlite] a suggestion to write tutorial for sqlite

I'm sorry if this reply seems jumbled - I wrote the middle bit (about the sugested content) after the bits above and below it. Jay A. Kreibich wrote: > On Sat, Apr 19, 2008 at 05:40:45PM +0100, Toby Roworth scratched on the wall: > >> mikeobe wrote: >> >>>

Re: [sqlite] a suggestion to write tutorial for sqlite

Agreed - I had to learn from the 5 minute introduction (which I was later told was a poor way of doing it), and then by using the reference, which leaves a lot to be desired when it comes to having little knowledge of SQLite - and it's still giving me trouble now! Toby mikeobe wrote

Re: [sqlite] no VFS error

Thanks - that seems to have fixed it D. Richard Hipp wrote: > On Apr 19, 2008, at 9:19 AM, Toby Roworth wrote: > >>> What value are you passing as the 4th argument to >>> sqlite3_open_v2()? (I assume you are using sqlite3_open_v2() >>> since that seems the mo

Re: [sqlite] no VFS error

D. Richard Hipp wrote: > On Apr 19, 2008, at 7:41 AM, Toby Roworth wrote: > > >> When attempting to open a database, I am getting a "no such vfs" >> error. >> >> What is likely to be causing this - a quick search suggested that vfs >>

[sqlite] no VFS error

When attempting to open a database, I am getting a "no such vfs" error. What is likely to be causing this - a quick search suggested that vfs may stand for virtual file system - is this right? Any help would be appreciated To

Re: [sqlite] C++ API callback problem

Thanks Igor and Teg, I think I know were I was going wrong now. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] C++ API callback problem

Hello all Looking at the API reference. it would apear you can send an extra "custom" argument to the callback fro sqlite3_exec, using the 4th parameter - how does this work, and inperticular, could I pass an object through to the call back, and if so, how? Th

[sqlite] C++ api - callbacks problem

Hello all Looking at the API reference. it would apear you can send an extra "custom" argument to the callback fro sqlite3_exec, using the 4th parameter - how does this work, and inperticular, could I pass an object through to the call back, and if so, how? Th

[sqlite] C++ api - callbacks problem

Hello all Looking at the API reference. it would apear you can send an extra "custom" argument to the callback fro sqlite3_exec, using the 4th parameter - how does this work, and inperticular, could I pass an object through to the call back, and if so, how? Th

[sqlite] C++ api - callbacks problem

Hello all Looking at the API reference. it would apear you can send an extra "custom" argument to the callback fro sqlite3_exec, using the 4th parameter - how does this work, and inperticular, could I pass an object through to the call back, and if so, how? Th

Re: [sqlite] Most widely deployed?

Aristotle Pagaltzis wrote: > * Shawn Wilsher <[EMAIL PROTECTED]> [2008-02-21 20:00]: > >>> Every copy of Firefox 3 contains a copy of SQLite. >>> >> And Firefox 2 ;) >> > > Really? What is it used for? > > Regards, > Apparently it's used for storing profile information in Firefox

Re: [sqlite] Most widely deployed?

Bryan Oakley wrote: > On Feb 20, 2008 7:41 AM, Toby Roworth <[EMAIL PROTECTED]> wrote: > >> Oracle has deployment contracts in the govornments of X countries >> worldwide, each having Y department, which have Z number of databases >> each... >> &g

Re: [sqlite] Most widely deployed?

Geoff Lane wrote: > On Wed, Feb 20, 2008 at 01:41:50PM +0000, Toby Roworth wrote: > >> I'm not trying to be picky here, or start telling you that you're wrong, >> but it could be worth changing - if an oracle developer (etc) were to >> look at the page, the

[sqlite] Most widely deployed?

interesting to hear people's thoughts on the matter. Toby ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Finding table names

Sorry if I sent this twice Any help would be appreciated Toby Roworth ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Re: OCaml binding for SQLite 3

ardur/personal/45-programs/ocaml-sqlite3/ http://metamatix.org/~ocaml/ocaml_sqlite3.html I found these by typing "ocaml-sqlite3" into Google. I haven't used either. Regards, Toby.