Re: [sqlite] SQLite server

documented. I mention this because I am doing some work with Node.js which has a MySQL interface and am using XMLHTTPRequest (Ajax) in Javascript in the Browser to access the MySQL DB on the Web Server via. Node.js. --- Best regards, Neville Franks, http://www.surfulater.com http://blog.surf

Re: [sqlite] Bundling sqlite database together with exe file.

gt; execution of your program read the resource and load it in KN> an in-memory database (filename ":memory:" ) by calling KN> sqlite3_exec() on each of its statements. KN> 3- Easier: Store the database file as-is in a resource in KN> the executable and on execution of your pr

Re: [sqlite] "Using SQLite" - O'Reilly Deal of the Day

a deal it is! Thank you for posting the announcement, Jay. GS> I had just been wondering what book to start reading on my BlackBerry, GS> and now I know. GS> Thanks again, GS> Gerry GS> PS Quick review: The index looks pretty decent. :) I somehow missed Jay's post, but

Re: [sqlite] Berkeley DB adds SQL using SQLite API !!

JD> This still is a small footprint, high-performance, low overhead SQL JJD> implementation. It does what it needs to do and no more. Also from the "end user" perspective it is so much easier for them to backup or copy a single file. --- Best regards, Neville Franks, http://www.su

Re: [sqlite] Password protection?

can look at an SQLIte database with a host of browser apps or the SQLite command line tool. There is an extension you can purchase that does database encryption if you want real protection. --- Best regards, Neville Franks, http://www.surfulater.com http://blog.surfu

Re: [sqlite] sqlite compile error

ler and came up with this error: GZ> [Linker error] undefined reference to `winm...@16' GZ> Can you help me? GZ> Thanks, >> Gary Zigmann, MBA >> Clinical Data Analyst >> Gifford Medical Center >> gzigm...@giffordmed.org --- Best regards, Neville Franks, http

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

ases. GG> SQLiteSpy (www.yunqa.de) is OK, but unless I missed the option, it GG> won't let me copy the output of a SELECT into the clipboard so I can GG> paste it elsewhere. GG> Are there better alternatives? GG> Thank you. --- Best regards, Neville Franks, http:/

Re: [sqlite] ANN: SQLite 3.6.16.C#

NH> This is an excellent reminder, and until this is done, I've removed access NH> to the source code and will terminate this google code project. I'll post NH> an announcement in the future when the new project is ready. NH> Also, if anyone has an ideal about what

Re: [sqlite] The SQL Guide to SQLite

| Integrity #>> Credibility #>>Applied Ecosystem Services, Inc.|Innovation #>><http://www.appl-ecosys.com> Voice: 503-667-4517 #>>Fax: 503-667-8863 #>>___

Re: [sqlite] Announce of the new "Versioning" extension

Hi Alexey, Thank you for the license change and readme. Wednesday, July 15, 2009, 7:16:44 PM, you wrote: AP> Hello! AP> On Wednesday 15 July 2009 09:56:28 Neville Franks wrote: >> Hi Alexey, >> Thank you for this extension which could be quite interesting to many >> SQ

Re: [sqlite] Announce of the new "Versioning" extension

s; AP> test key 0|test value 0|2455027.00753221|I|1 AP> test key 1|test value 1|2455027.00753347|I|2 AP> test key 2|test value 2|2455027.00753368|I|3 AP> ||2455027.00753382|D|1 AP> ||2455027.00753382|D|2 AP> ||2455027.00753382|D|3 AP> ==

Re: [sqlite] Repost: Accessing a DB while copying it causes Windows to eat virtual memory

copy the sqlite DB using Windows' own copy utility (e.g. via explorer). >>>> * At any point during the copy, I run 'strings' with the file as an >>>> argument. >>>> * I exit strings. >>>> * The copy does not re

Re: [sqlite] Accessing sqlite using javascript

t.com/posts/show/1030 The ExtJS Library also provides access to SQLite, but I have not used that part of ExtJS yet. Finally Google: "sqlite from javascript". --- Best regards, Neville Franks, http://www.surfulater.com http://blog.surfulater.com __

Re: [sqlite] How do you guys use sqlite from C++?

gt; binds and parameter substitution through the use of variable V> arguments () as well as a printf-style format string that V> clues the routine into the types of the arguments. For example: Best regards, Neville Franks, http://www.surfulater.com http://blog

Re: [sqlite] insert speeds slowing down as database size increases (newb)

e - less than 1 write per millisecond (other databases JB> have scaled well). I'm using a intel core 2 duo with 2 GB of ram and JB> an ordinary HDD. JB> ... -- Best regards, Neville Franks, http://www.surfulater.com http://blog.surfulater.com

Re: [sqlite] SQL Update while Stepping through Select results

Saturday, September 6, 2008, 10:03:00 AM, you wrote: IT> "Neville Franks" <[EMAIL PROTECTED]> wrote IT> in message news:[EMAIL PROTECTED] >> At present the clm data is a list of one or more numeric id's >> separated by either a space or comma. I need to update th

Re: [sqlite] SQL Update while Stepping through Select results

Hi Igor, Saturday, September 6, 2008, 8:27:01 AM, you wrote: IT> Neville Franks <[EMAIL PROTECTED]> wrote: >> I need to update a column in a set of rows in a table. For each row I >> need to extract the columns value, change it and update the row. >> >> My qu

[sqlite] SQL Update while Stepping through Select results

following an UPDATE. I assume so as this is a fairly basic operation. I have done a quick documentation search to no avail. Finally is there a better way to accomplish. Maybe an UPDATE with a TRIGGER using a user defined function. Thanks. -- Best regards, Neville Franks, http

Re: [sqlite] Writing double into a socket file

encapsulation. >>> >>> >>> John Elrick >>> Fenestra Technologies >>> ___ >>> sqlite-users mailing list >>> sqlite-users@sqlite.org >>> http://sqlite.org:8080/cgi-bin/mailman/lis

Re: [sqlite] Problem with sqlite overall or not?

p> return data; p> sqlite3_finalize(statement); p> } p> this does cout properly. But when I'm using it in a different place: Try moving: sqlite3_finalize(statement); return data; I would also populate set and then push that to data. And I would use one of the C

Re: [sqlite] Comparison of SQLite applications for Mac

ers mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> HW> ___ HW> sqlite-users mailing list HW> sqlite-users@sqlite.org HW> http://sqlite.org:8080/cgi-bin/mailman/l

Re: [sqlite] Populating and scrolling the Listbox using query

t;> > ___ >>> > sqlite-users mailing list >>> > sqlite-users@sqlite.org >>> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>> > >>> > >>> >>&g

Re: [sqlite] Delete inside Select+Step

t calls various other functions which call various other functions, none of which know anything about, nor do anything with the SQLite DB. So I don't see it is relevant. -- Best regards, Neville Franks, http://www.surfulater.com http://blog.surfulater.com ___

[sqlite] Delete inside Select+Step

sqlite3_step()'s will work correctly? -- Best regards, Neville Franks, http://www.surfulater.com http://blog.surfulater.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL Quick Review/Reference

Martin >>> >>> >>> ___ >>> sqlite-users mailing list >>> sqlite-users@sqlite.org >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>> &

Re: [sqlite] SQL Quick Review/Reference

I am looking for. AU> I've googled around but I thought why not ask the SQL veterans here? AU> Thanks, AU> Amit AU> ___ AU> sqlite-users mailing list AU> sqlite-users@sqlite.org AU> http://sqlite.org:8080/cgi-bin/ma

[sqlite] Use of constraints

and not proceed with the insert as required, or just handle the conflict as being acceptable vs. an exception? Seeing this is in infrequent, my feeling is that always doing a select first is a waist of time & resources. -- Best regards, Neville Franks, http://www.surfulater.com

Re: [sqlite] Help with query

Thanks Igor and Puneet, These are very different solutions, or so it appears to me. Any idea whether the join or the sub-select would be faster? In my example there is an index on tagid. Wednesday, April 9, 2008, 8:12:53 AM, you wrote: IT> Neville Franks <[EMAIL PROTECTED]> wrote:

[sqlite] Help with query

a and tagid b. The result for the example above would be: noteid -- 7 Can someone point me in the right direction. I am also interested in optimal performance here. I'm new to SQL and so far I am just doing simple select's. Thanks. -- Best regards, Neville Franks, http

Re: [sqlite] Use of two columns for a key and query on first clm.

BY. However in this specific example I would have thought the index order would be used, which is clm1+clm2 which is the same as using ORDER BY clm2. But I appreciate this isn't guaranteed. Friday, March 21, 2008, 11:41:52 AM, you wrote: JS> No, use ORDER BY JS> Neville Franks wrote: >&

[sqlite] Use of two columns for a key and query on first clm.

is in the query and it appears to match on the first row. Also my tests indicate I do get back the first matching row. But I'd like confirmation if possible. -- Best regards, Neville Franks, http://www.surfulater.com http://blog.surfulater.com ___ sqlite

Re: [sqlite] Update while stepping through a prepared query

Monday, March 17, 2008, 12:03:26 PM, you wrote: IT> "Neville Franks" <[EMAIL PROTECTED]> wrote IT> in message news:[EMAIL PROTECTED] >> Can I do an Update while stepping through a prepared query? IT> Yes, in recent enough versions of SQLite, and assuming bot

[sqlite] Update while stepping through a prepared query

where rowid=%Q;", .. ); // will the subsequent sqlite3_step() calls perform as expected? } while( sqlite3_step() == SQLITE_ROW ); - -- Best regards, Neville Franks, http://www.surfulater.com http://blog.surfulater.com ___

Re: [sqlite] Does an sqlite3_get_table() results set get updated.

Tuesday, March 11, 2008, 12:34:02 PM, you wrote: JS> Neville Franks wrote: >> Hi John, >> >> Tuesday, March 11, 2008, 11:51:57 AM, you wrote: >> >> JS> Neville Franks wrote: >> >>>>Hi John, >>>> >>>>Tues

Re: [sqlite] Basic system setup for tracing?

gt;What do you mean by tracing. Do you mean code profiling? Or easy >>navigation though the code? Or ...? ss> Just step-in; I'm studying the sqlite code and it would be easier if I could ss> see the internal in action. I can't comment on the compilers you mention, however Microsoft V

Re: [sqlite] Does an sqlite3_get_table() results set get updated.

Hi John, Tuesday, March 11, 2008, 10:18:30 AM, you wrote: JS> Neville Franks wrote: >> Tuesday, March 11, 2008, 8:48:05 AM, you wrote: >> >> JAK> On Tue, Mar 11, 2008 at 08:37:27AM +1100, Neville Franks scratched on >> the wall: >> >>>>If I use

Re: [sqlite] Basic system setup for tracing?

ng via mingw and run the ss> traditional hello world, and the sqlite used is the amalgamation. ss> Is there a straightforward way to trace sqlite, without messing around?? ss> Thanks, ss> Saverio What do you mean by tracing. Do you mean code profiling? Or easy navigation though the code? Or .

[sqlite] Does an sqlite3_get_table() results set get updated.

the changes does this also apply to an sqlite3_get_table() query that was on a VIEW? I realize I could write a sample app to try this, but would rather try and save the time. -- Best regards, Neville Franks, http://www.surfulater.com http://blog.surfulater.com

Re: [sqlite] sqlite3: handling of indices

the file causes to many "regeneration". ML> TIA, ML> Michael ML> ___ ML> sqlite-users mailing list ML> sqlite-users@sqlite.org ML> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-user

Re: [sqlite] Update fail without ERRORS

. tti> The tti> Database descriptor is the same returned from open function, and status tti> code is OK!!! tti> But table value isn't updated. tti> I don't understand tti> what's matter, and because i haven't any error message I can't debug tti> it. tti> Any suggest

Re: [sqlite] Retrieve Rownumber in sqlite

> at 1 for the first row in each partition. Which is very useful when KP> implementing paging through a large number records in Table. Is there KP> any function available in SQLite similar to this. KP> Thanks KP> -Kalyani -- Best regards, Neville Franks, http://www.surfulater.com http:

Re: [sqlite] DATETIME data type

dTimeFunctions Trying to compare dates in the format you have used would require conversion to something sensible like -MM-DD I am personally a big fan of the ISO-8601 format and use them everywhere. -- Best regards, Neville Franks, http://www.surfula

Re: [sqlite] Question on Blobs

rc = sqlite3_bind_blob(stmt, 2, data, sb.st_size, SQLITE_STATIC); >> >> if (rc != SQLITE_OK) { >> fprintf(stderr, "sqlite3_bind_blob() %s\n", sqlite3_errmsg >> (db)); >> sqlite3_finalize(stmt); >> sqlite3_close(db);

[sqlite] Keeping ROWID for INSERT OR REPLACE

ACE? If not what is the fastest way to check if a row exists, assuming the search is on a single clm which is indexed. ex. select myclm from mytable where myclm='abc'; select count(*) from mytable where myclm='abc'; add limit 1 to either of the above etc. -- Best regards, Neville Franks, h

Re: [sqlite] compiling C program to use the shared library

; Regards, NL> ~Nuno Lucas NL> ___ NL> sqlite-users mailing list NL> sqlite-users@sqlite.org NL> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users For MSVC use: c:\>lib /def:sqlite.def to create the lib file to link

Re: [sqlite] Index for Primary Key column missing?

ieb Neville Franks: >> I have created a table with a column: tag text primary key >> >> When I do: >> sqlite> .indices tags >> sqlite_autoindex_tags_1 >> >> I only see the one index which I assume is for the ROWID clm. JM> No, this is the index for yo

Re: [sqlite] The best way to handle dynamic table creation

Simon, Thanks for that. Just shows how new I am at SQL. Thursday, February 21, 2008, 9:01:22 PM, you wrote: SD> See "IF NOT EXISTS" in http://www.sqlite.org/lang_createtable.html SD> Rgds, SD> Simon SD> On 21/02/2008, Neville Franks <[EMAIL PROTECTED]> wrote

[sqlite] The best way to handle dynamic table creation

ype='table' and name=table_name; and check the result before attempting to create the table. My question is what do other folks do here? Is my solution a good one? -- Best regards, Neville Franks, http://www.surfulater.com http://blog.surfulater.com

[sqlite] Index for Primary Key column missing?

umn will have an index. So my question is where is the index for the 'tag' column? This is the complete CREATE TABLE SQL. CREATE TABLE tags ( tag text primary key, description text, date_created text DEFAULT CURRENT_TIMESTAMP, style text ) Thanks. -- Best regards, Neville Franks, h

Re: [sqlite] Is there always an index on ROWID?

red in a b-tree keyed off of the rowid, so JH> lookups based on rowid should always be fast. JH> -Jeff JH> On Wed, Feb 20, 2008 at 6:27 PM, Neville Franks <[EMAIL PROTECTED]> wrote: >> Hi, >> If I create a table with a Primary key on a TEXT clm, will there still >> b

[sqlite] Is there always an index on ROWID?

, but have been unable to find an answer to this. Thanks. -- Best regards, Neville Franks, Author of Surfulater - Your off-line Digital Reference Library Soft As It Gets Pty Ltd, http://www.surfulater.com - Download your copy now. Victoria, Australia Blog: http://blog.surfulater.com