[sqlite] SQLite iOS timestamp type mapping settings must be set to float to get correct data

timestamp field that will not translate correctly with the few SQLite ODBC drivers I tried: ZTIMEENTRY 3. The field in the ZTIMEENTRY table that must have the timestamp type setting changed to float to get the data correctly: ZDATE Resepectfully, Bill Hash

Re: [sqlite] SQLite DB on external USB HD - is it safe?

I'd say that "local file system" versus "remote file system" is really more of a shorthand for the requirement that low-level operations such as locks and reads behave the way that sqlite expects them to behave. In particular, locks on remote file systems are notorious for poor behavior. If

[sqlite] new version

I have an old version of SQLite 3.8.7 for windows and downloaded the new binaries v 3.13.0 in the zip format which contained the 2 unzipped files .def and .dll . However there was nothing informing me about the installation procedure. Can someone help? Thanks

[sqlite] Missing Sanity Checks for calls to sqlite3_realloc64() in shell.c

I am attaching the patch file to this bug report... Questions, Comments, Suggestions, Complaints? :) Bill Parker (wp02855 at gmail dot com)

[sqlite] Potential for Segmentation Violation/Fault in sqlite 3.8.11.1

a NULL address location (compiled with: gcc -O2 -Wall -g memcpy.c #include #include #include int main(void) { char *buf; int x = 10; buf = malloc(80); #if 1 buf = NULL;/*force buf to point to NULL*/ #endif while (0 <-- x) printf("Value of x is:

[sqlite] diagrams a la sql server management studio

Hi,   I am looking for a diagramming tool for a sqlite database. I want functionality similar to the diagrammer in sql server management studio. Any suggestions?   Bill ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

[sqlite] I consider this a bug. Anyone else?

along with company name and version. Most Windows install packages access the version info from the resource block as a condition to install the sqlite3.dll file. Not having this data could cause an old version of the DLL to be install over top of a newer version. Thanks again, Bill Pytlovany

[sqlite] perl parameter binding by name

/INSERT INTO table (name) VALUES (:name)/; Thanks, Bill ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] double_quote(text_field)

wrote: On 2/22/2012 6:03 PM, Bill McCormick wrote: What is the easiest way to return a text field with double (") quotes? SELECT quote(text_field) FROM table; is close, but I'd rather have a SELECT double_quote(text_field) FROM table; I'm not sure I understand the nature of the

[sqlite] double_quote(text_field)

What is the easiest way to return a text field with double (") quotes? SELECT quote(text_field) FROM table; is close, but I'd rather have a SELECT double_quote(text_field) FROM table; Thanks!! ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] custom property db/editor

I need to develop a light-weight, custom property editor using SQLite, Perl, thttpd and HTML/CSS for building and editing recipes. I'm thinking of something like the classic "folder/tree/property sheet" interface and it will (obviously) run in a web browser I suppose I could use XML as well,

Re: [sqlite] ALTER TABLE

Nico Williams wrote, On 2/6/2012 12:44 PM: On Mon, Feb 6, 2012 at 9:36 AM, Bill McCormick<wpmccorm...@gmail.com> wrote: Is there no way to force columns added to a table with alter table to be added at certain column positions? Alternatively, if there is some way to save th

Re: [sqlite] ALTER TABLE

Gerry Snyder wrote, On 2/6/2012 9:48 AM: On 2/6/2012 8:36 AM, Bill McCormick wrote: Is there no way to force columns added to a table with alter table to be added at certain column positions? Alternatively, if there is some way to save the data in an existing table; drop the table; re-create

[sqlite] ALTER TABLE

Is there no way to force columns added to a table with alter table to be added at certain column positions? Alternatively, if there is some way to save the data in an existing table; drop the table; re-create the table with the desired schema; and then reload the data, this would be useful as

[sqlite] DBI->connect doesn't fail if no DB

In the following statement ... my $dbh = DBI->connect("dbi:SQLite:dbname=$dbfile","","") or croak $DBI::errstr; if $dbfile does not exist, it is created. I would like to croak if this happens. Is there some option for this? Thanks!! ___

Re: [sqlite] FIRST/LAST function

Igor Tandetnik wrote, On 2/2/2012 10:50 AM: Petite Abeille wrote: On Feb 2, 2012, at 5:26 PM, Igor Tandetnik wrote: ORDER BY applies to groups, not to rows within each group (is this different with Oracle?) analytic functions works in term of the result set

Re: [sqlite] FIRST/LAST function

Mr. Puneet Kishor wrote, On 2/2/2012 9:57 AM: On Feb 2, 2012, at 9:46 AM, Petite Abeille wrote: On Feb 2, 2012, at 4:37 PM, Bill McCormick wrote: Does SQLite have FIRST and LAST aggregate function? No, sadly, SQLite doesn't support any analytic functions (aka window function

[sqlite] FIRST/LAST function

Does SQLite have FIRST and LAST aggregate function? I don't see it in the docs, but I thought I might ask anyway. Or maybe someone out there knows a slick way to do this: Anyway, it would be sort of like MIN & MAX, but would return the first and last values of the requested field over a

[sqlite] Perl script to output to file

From the sqlite command line interface, the .output command will output the result of a query to a file. How can I do this from a Perl script? I'm not finding any built-in facility to do this in the Perl module. I found this (http://members.toast.net/strycher/perl/example_dbi_sql.htm), but

Re: [sqlite] PRAGMA journal_mode=WAL;

Larry Brasfield wrote, On 1/31/2012 11:36 AM: Bill McCormick wrote: > < PRAGMA journal_mode=WAL; ... So when I run an update command (to update some arbitrary record) from the sqlite3 command line, do I need to do something to do a checkpoint? By "checkpoint", I presu

Re: [sqlite] PRAGMA journal_mode=WAL;

Larry Brasfield wrote, On 1/31/2012 8:40 AM: < Either I have some incorrect version or don't understand how to use this: < < #include < < int main(int argc, char** argv) < { < sqlite3 *db; < < PRAGMA journal_mode=WAL; < < ... < < gcc [various errors] The PRAGMA is something you

Re: [sqlite] PRAGMA journal_mode=WAL;

Simon Slavin wrote, On 1/31/2012 8:34 AM: On 31 Jan 2012, at 2:32pm, Bill McCormick wrote: Where exactly to I put the PRAGMA journal_mode=WAL; line? You execute it as a SQL command, the same way you'd execute an INSERT command. You only need to do it once for the database file. The setting

[sqlite] PRAGMA journal_mode=WAL;

Where exactly to I put the PRAGMA journal_mode=WAL; line? Either I have some incorrect version or don't understand how to use this: #include int main(int argc, char** argv) { sqlite3 *db; PRAGMA journal_mode=WAL; ... gcc -g -Wall -lrt -I.. -I../../include -I../ini-parse -o prodd

Re: [sqlite] date function

Bill McCormick wrote, On 1/27/2012 12:12 PM: I have a date stored in a numeric field like this: 2012-01-27 16:47:50. I want to update the date using the date function, like this: update table set TIME_STAMP = date('TIME_STAMP', '+ 2 years'); Reference: http://www.sqlite.org/lang_datefunc.html

[sqlite] date function

I have a date stored in a numeric field like this: 2012-01-27 16:47:50. I want to update the date using the date function, like this: update table set TIME_STAMP = date('TIME_STAMP', '+ 2 years'); Reference: http://www.sqlite.org/lang_datefunc.html I also tried this: update table set

Re: [sqlite] SQLite and Perl

Darren Duncan wrote, On 1/27/2012 1:41 AM: Puneet Kishor wrote: On Jan 26, 2012, at 2:53 PM, Bill McCormick wrote: Puneet Kishor wrote, On 1/26/2012 12:02 PM: $ cpanm DBD::SQLite there is no step two Actually, that's not correct. In my case it took the following: Step 1: cpan DBI Step 2

Re: [sqlite] SQLite and Perl

Puneet Kishor wrote, On 1/26/2012 3:01 PM: On Jan 26, 2012, at 2:53 PM, Bill McCormick wrote: Puneet Kishor wrote, On 1/26/2012 12:02 PM: On Jan 26, 2012, at 11:59 AM, Bill McCormick wrote: I need to get going with Perl& SQLite and I'm wondering what I need to get off CPAN, if anyt

Re: [sqlite] SQLite and Perl

Puneet Kishor wrote, On 1/26/2012 12:02 PM: On Jan 26, 2012, at 11:59 AM, Bill McCormick wrote: I need to get going with Perl& SQLite and I'm wondering what I need to get off CPAN, if anything. $ cpanm DBD::SQLite there is no step two Actually, that's not correct. In my case it

[sqlite] SQLite and Perl

I need to get going with Perl & SQLite and I'm wondering what I need to get off CPAN, if anything. Here's what I think I have now: root@fiberio:/etc/cron.daily# locate perl | grep SQLite /usr/share/perl/5.10.1/CPANPLUS/Internals/Source/SQLite

Re: [sqlite] sqlite3_bind_text destructor

Stephan Beal wrote, On 1/25/2012 11:36 AM: On Wed, Jan 25, 2012 at 6:33 PM, Bill McCormick<wpmccorm...@gmail.com>wrote: http://www.sqlite.org/**capi3ref.html#sqlite3_bind_**blob<http://www.sqlite.org/capi3ref.html#sqlite3_bind_blob> Ha! That's the full description that lef

Re: [sqlite] sqlite3_bind_text destructor

Stephan Beal wrote, On 1/25/2012 11:01 AM: On Wed, Jan 25, 2012 at 5:45 PM, Bill McCormick<wpmccorm...@gmail.com>wrote: 2. What will be void* argument be to the destructor? 3. What void* should the destructor return? int sqlite3_bind_text(sqlite3_stmt*, int, const char*, int n, void(*

[sqlite] sqlite3_bind_text destructor

The documentation I see for the sqlite3_bind_text 5th argument (a destructor used to dispose of the BLOB or string after SQLite has finished with it) isn't clear: 1. I assume the "string" that we're talking about here is the 3rd argument (const char*) 2. What will be void* argument be to the

Re: [sqlite] Bin parameters by name - generic function

timestamp 1092941466. SELECT datetime(1092941466, 'unixepoch'); --David Garfield On Tue, Jan 17, 2012 at 19:32, Bill McCormick<wpmccorm...@gmail.com> wrote: I'm trying to write a function with a sig like this: int BindParameter(sqlite3_stmt* stmt, int sqlType, const char* pname

[sqlite] Bin parameters by name - generic function

I'm trying to write a function with a sig like this: int BindParameter(sqlite3_stmt* stmt, int sqlType, const char* pname, char* value); Somewhere before the call(s) to BindParameter, I'll have a string that looks like this: (FOO=some text value, BAR=3.141, ZIP=45, TIMESTAMP1=01/17/12

[sqlite] sqlite3_close() necessary?

What happens if my application fails to call sqlite3_close() before it exits? Does it leave the db in some unknown state or open to corruption? If I have a daemon type program, will I need to catch signals that try to close/kill the program and call sqlite3_close() before exiting? Thanks!!

Re: [sqlite] Some pieces of the puzzle are coming together

Pavel Ivanov wrote, On 1/17/2012 9:42 AM: I attempted all of the above and the call stacks do not change. That leads me to one of two conclusions: 1. The call stacks are inaccurate 2. There is some side effect which is causing malloc to be called inside of a procedure which should not be

Re: [sqlite] sql/tcl script

Simon Slavin wrote, On 1/16/2012 1:45 PM: On 16 Jan 2012, at 7:34pm, Bill McCormick wrote: Looks like pipes work as well (cat yoursql.sql|sqlite3 yourdb.db3). Also, can I safely delete the database file (yourdb.db3, using your example) if I just want to start again? It appears that I can

Re: [sqlite] sql/tcl script

Oliver Peters wrote, On 1/16/2012 1:02 PM: Am 16.01.2012 19:59, schrieb Bill McCormick: James Pearson wrote, On 1/16/2012 12:28 PM: If it's just for setting up databases, tables, etc, why not just use a sql script? Throw all your database object creation sql into a file and then execute

Re: [sqlite] sql/tcl script

Stephan Beal wrote, On 1/16/2012 12:15 PM: On Mon, Jan 16, 2012 at 7:12 PM, Bill McCormick<wpmccorm...@gmail.com>wrote: Is tcl the only scripting interface for SQLite? I'm just wondering what the options are. There are few scripting languages which don't have an sqlite3 binding

Re: [sqlite] sql/tcl script

James Pearson wrote, On 1/16/2012 12:28 PM: If it's just for setting up databases, tables, etc, why not just use a sql script? Throw all your database object creation sql into a file and then execute that file from within sqlite using the ".read FILE" command. I think this is what I'm

[sqlite] sql/tcl script

Is tcl the only scripting interface for SQLite? I'm just wondering what the options are. I'm trying to write a script to setup my database on new systems (create the db, add tables, etc.), but I don't have much experience using Tcl. My fist attempt is not going so well and I'm not finding

Re: [sqlite] makefile for c

Tim Streater wrote, On 1/15/2012 3:00 PM: On 15 Jan 2012 at 20:44, Bill McCormick<wpmccorm...@gmail.com> wrote: What is the problem with the shared lib stuff? Thanks!! Black, Michael (IS) wrote, On 1/15/2012 2:27 PM: A simple one -- and please compile sqlite3.c into your program an

Re: [sqlite] makefile for c

om: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Bill McCormick [wpmccorm...@gmail.com] Sent: Sunday, January 15, 2012 2:23 PM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] makefile for c I'm looking for an example c program makefile for compiling and linking in

[sqlite] makefile for c

I'm looking for an example c program makefile for compiling and linking in the SQLite lib to gcc compiled programs. I'm not sure which lib to include between libsqlite.so.0 and libsqlite3.so.0 and what options I should pass to gcc. Where is this documented? Thanks!!

[sqlite] Release 3.7.8 CREATE INDEX slower

I have a table of 3M rows. I add all the rows to the table, then call CREATE INDEX. Release 3.7.8 is about 40% slower than the previous release doing the CREATE INDEX. Has anyone else experienced this? ___ The contents of this e-mail

[sqlite] Read-only main database and ATTACH

a definitive answer and because my own testing using sqlite 3.6.13 did not reveal any problems, I am posting this question. Thank you for any insights. Bill ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

[sqlite] SQLite GUID in WHERE Clause

Simple question, likely to have a simple answer. I have tables in SQLite using GUID primary key columns. I am attempting to select a row based on its literal guid value in C#.Net. Here's a sample query: SELECTRole.Id, Role.Name, Role.Description, Role.Active, Role.BitMask FROM

Re: [sqlite] sqlite3_abort()?

e: [sqlite] sqlite3_abort()? -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/26/2010 07:47 PM, Bill Webster wrote: > I meant something that released all open files, blob handles, statement > handles etc., without terminating the process. > > I guess that this m

Re: [sqlite] sqlite3_abort()?

Tandetnik Sent: Sunday, 27 June 2010 1:21 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] sqlite3_abort()? Bill Webster <b...@year0.com.au> wrote: > Sorry for not being clear enough. > > I meant something that released all open files, blob handles, statement > handles etc., w

Re: [sqlite] sqlite3_abort()?

: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Roger Binns Sent: Sunday, 27 June 2010 12:40 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] sqlite3_abort()? -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/26/2010 07:29 PM, Bill Webster

[sqlite] sqlite3_abort()?

Excuse me as an extreme newbie, but it would seem useful to have a method that is guaranteed to release all resources. Perhaps it exists and I just didn't see it? Bill Webster Year0 Software that works. b...@year0.com.au ___ sqlite-users

Re: [sqlite] SQLite and Qt

should work fine to exec "PRAGMA foreign_keys = ON" > Sam > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Bill King, S

Re: [sqlite] Proposed: drop support for LinuxThreads

users > Some old embedded platforms have libc compiled with nptl to "save space", seriously tho, it's pretty much down to a matter of recompiling libc with the appropriate thread library support. Consider this a vote for removal/clarity/standardisation, as it's not a huge deal to turn

Re: [sqlite] Questions regaring SQLite support on N97

rg:8080/cgi-bin/mailman/listinfo/sqlite-users > Things are getting better, qt and qtcreator for s60's making things noticeably easier, and there's a QtSql wrapper for the sqlite server engine access in the works, or native sqlite is included in qt/s

[sqlite] Better information on how to use the sqlite list

nt and not some other sqlite database. I am having trouble doing this schema verification. I'll go back to lurking, Bill _ Hotmail: Powerful Free email with secu

[sqlite] Archive Search Engine

It would be very helpful if there was a search engine for the sqlite-user mailing list archive. My question might have already been answered, but currently using the archive I have to manually look through the threads month by month. It is like finding a needle in a haystack! Bill

Re: [sqlite] SQLite, network share, and Qt

ing SQLITE_ENABLE_LOCKING_STYLE when > you build the library. Maybe your command line tool was built with > this option but the Qt driver was not. > > > As far as I know, the Qt (compiled/included by default) library isn't compiled with these switches on. --

Re: [sqlite] SQLite, network share, and Qt

th the approx 120 other bugs against the SQL section and try to replicate. Nothing has changed significantly that would impact this in qt for a very long time now, (as well as the fact that we're performing a whole lot of autotests on a very regular basis). Have you tried opening up a debugger

[sqlite] SELECT * from ?

   sqlite3_step(stmt); ...   Any help is greatly appreciated.   Thanks, Bill ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Date Modifier '%w' Does Not Behave as INTEGER

I find that I must cast the result of a '%w' modifier to INTEGER to use it in a select. I have a table of TV programs that has title and an integer representing the show's start time as unix epoch. This does not produce any results, though I have shows beginning on Monday: select title,

Re: [sqlite] Updating a database by email

this. A Web-facing solution would be ideal, but I have policy constraints that prevent that. Bill - -- Bill Harris http://facilitatedsystems.com/weblog/ Facilitated Systems Everett, WA 98208 USA http://facilitatedsystems.com/ phone: +1

[sqlite] Updating a database by email

an sqlite database between two sites successfully using email? I could even see having a copy at both sites and periodically emailing the slave version to the master and then running a merge of some sort, but I'm not sure that would do what I need. Thoughts? Thanks, Bill - -- Bill Harris

Re: [sqlite] UTF-16 API a second class citizen?

ou'll see significant overhead from conversions back >> and forth between >> utf8 and utf16 inside the sqlite code. >> >>> Igor Tandetnik >>> > > ___ > sqlite-users mailing list > sqlite-users@sqlit

Re: [sqlite] UTF-16 API a second class citizen?

___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- Bill King, Software Engineer Qt Software, Nokia Pty Ltd Brisbane Office ___ sqlite-users mailing list s

[sqlite] unsubscribe

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

[sqlite] solaris 9 build instructions

Hello, I found & extracted the source. Now are there any build instructions for Solaris 9 anywhere? I haven't been on UNIX in a long time. Also, if there are any dependencies is there a list somewhere? Thanks, Bill Shurtleff Bill Shurtleff Sr. Software Engineer Petris Techno

[sqlite] what is the best amalgamation for a build on Solaris 9?

Hi, I want to build Sqlite on Solaris 9. What is the best amalgamation? Are there any build Makefiles for building on Solaris? Any input on this will be helpful. Thanks, Bill Shurtleff ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] undefined function sqlite_open()

Hello all, I've searched the list archive and didn't find any mention of this. Google has lots of hits, but every board posting with a resolution was left as 'resolved' with little explanation. :( I have clean install of Debian Etch with lighttpd, php5-cgi, php-sqlite3, xml_core, sqlite3,

Re: [sqlite] Performance

be another avenue to consider, but definately, reducing the number of writes to the filesystem in the first place is also something that will help those filesystems do their job even better to help extend the lifetime of the hardware. -- Bill King, Software Engineer Trolltech, Brisbane Technology Park 26 Bran

Re: [sqlite] Performance

ling list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > One thing I can highly recommend on embedded systems, especially flash based ones, is turn pragma synchronous to off. Having sqlite write every record modification to the flash, is a st

Re: [sqlite] Optimization Question for SQLite Experts

be massively optimised. > > There are so many options, each of which would require quote alot of > effort to prototype and test, I wondered what wisdom any hardened > SQlite folk could offer. What is the best approach to attack this > problem ? > > Thanks for any experience you can share..

Re: [sqlite] Next Version of SQLite

[EMAIL PROTECTED] wrote: > Bill KING <[EMAIL PROTECTED]> wrote: > >> A colleague brought up a very good point. At least for the first few >> revisions, is the old engine/code still going to be available until the >> new engine code base settles down? >> >

Re: [sqlite] Next Version of SQLite

blems. You should not underestimate the level of detail to > which we test SQLite and the thoroughness of the test suite. Not much > is likely to slip through the cracks. > > > D. Richard Hipp > [EMAIL PROTECTED] > > > > > - > > To unsubscribe, send email to [EMAIL PR

Re: [sqlite] Optimizing performance by moving large texts into a separate table

Bs in a separate table and referencing them by rowid is what I do. I've had good luck with putting large texts into their own files, and storing the file names in the tables. But that precludes searches within the texts themselves. My applications didn't need to do that. b.g. -- Bil

Re: [sqlite] Problem using POSIX semaphores and triggers to signal updates

ase manager. :) But should I change my mind, I'm gonna bookmark your email just in case! b.g. -- Bill Gatliff [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Problem using POSIX semaphores and triggers to signal updates

John Stanton wrote: Bill, You have an interesting situation, and a general one since you have data distributed across a network. I would be tempted to define a remote procedure call using TCP/IP or whatever and use that to notify database changes. Use a message passing approach

Re: [sqlite] Problem using POSIX semaphores and triggers to signal updates

_could_ use select(2) et al. Right now, though, the schemas are designed to meet the needs of the system as a whole; the GUI has to take what's left. :) b.g. -- Bill Gatliff [EMAIL PROTECTED] - To unsubscribe, send

Re: [sqlite] Problem using POSIX semaphores and triggers to signal updates

Trevor Talbot wrote: On 10/31/07, Bill Gatliff <[EMAIL PROTECTED]> wrote: I prefer not to poll for changes, because the system is performance-constrained. So instead, I'm using an AFTER UPDATE trigger in the data-generating process to launch a C function that posts to a semaphore. T

[sqlite] Problem using POSIX semaphores and triggers to signal updates

an entirely different--- and better--- way of synchronizing my GUI to the database? Thanks! b.g. -- Bill Gatliff [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] QT4 ubuntu sqlite driver problem ? (was Re: [sqlite] Weird error)

gt;>>> SQL logic error or missing database >>>>> Unable to fetch row >>>>> Err number 1. >>>>> >> > > I have found the solution in the qt4 doc : > - > The driver is locked for updates w

Re: [sqlite] Using loadable extension with Qt

on function? I understand that > I can > build my extension into sqlite similar to fts1 and fts2, but I need to > load > it dynamically so this is not an option. > > Many thanks in advance for any suggestio

[sqlite] Seeing a file handle issue with sqlite.

on the open filehandle, but I'd like to get confirmation from elsewhere/highlight it to DRH/the list to make them aware of it. -- Bill King, Software Engineer Trolltech, Brisbane Technology Park 26 Brandl St, Eight Mile Plains, QLD, Australia, 4113 Tel + 61 7 3219 9906 (x137) Fax + 61 7 3219 9938 mobile

Re: [sqlite] Database designer for SQLite

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Paul KOENIG <[EMAIL PROTECTED]> writes: > Thanks but i forgot to specify that i'm on Mac :( > Something else for me ?? Druid? http://sourceforge.net/projects/druid/ Bill - -- Bill Harris http://facilitatedsystem

Re: [sqlite] pragma for headers ( pipe or redirect a series of commands)

orning when I woke up around 8:30AM I checked the email, just in case, and I immediately saw the light when I read your message... THANKS A MILLION FOR YOUR HELP... Best regards, Bill Hernandez Plano, Texas The term AppleScript comes in two flavors (both which are free and come with the operati

[sqlite] pragma for headers ( pipe or redirect a series of commands)

mp; " LIKE '%" & searchValue & "%' order by " & sortField & " " & sortDir & ";" ... missing lines here display dialog ("QUERY : " & quote & thisQuery & quote & return & return & (do shell script "sqlite3 -column ~/desktop/TestDB.db " & quote & thisQuery & quote)) end sqlite_DoTheSearch I'd be grateful for any insights... Bill Hernandez Plano, Texas - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] unsupported file format

le of different windows boxes and > linux boxes, all sharing the same sqlite3 database file, but with > different versions of sqlite3? How does one "convert" between > versions? > > Thanks, > Mike > > On 1/16/07, Bill KING <[EMAIL PROTECTED]> wrote: >> M

Re: [sqlite] unsupported file format

problem interacting with it. I'm not sure why I'm suddenly seeing > this. > > Thanks, > Mike Err, s/qt/ROR/ -- Bill King, Software Engineer Trolltech, Brisbane Technology Park 26 Brandl St, Eight Mile Plains, QLD, Australia, 4113

Re: [sqlite] unsupported file format

rect, the qt version's older and incompatible with your system version). -- Bill King, Software Engineer Trolltech, Brisbane Technology Park 26 Brandl St, Eight Mile Plains, QLD, Australia, 4113 Tel + 61 7 3219 9906 (x137) Fax + 61 7 3219 9938 mobile: 0423 532 733

Re: [sqlite] sqlite performance, locking & threading

Roger Binns wrote: Im sorry for being so harsh, and i know im not winning any friends here, So far noone has agreed with you :-) This would be incorrect. The correct statement is "so far no one has vocally agreed with you". If people didn't agree, this whole once a month people

Re: [sqlite] sqlite performance, locking & threading

Emerson Clarke wrote: The indexing process works like this. 1.) Open a document and parse its contents. 2.) Look up records in the first database based on the contents of the document, updating records where appropriate and inserting new ones. 3.) Transforming the document based on what was

Re: [sqlite] blocking on insert

Thankyou, spot on the mark :) Now we've got it blazing fast, time to move backwards towards a reasonable mix of safety and speed. [EMAIL PROTECTED] wrote: > Bill KING <[EMAIL PROTECTED]> wrote: > >> Okay, i've got PRAGMA synchronous = OFF and PRAGMA temp_store = memor

[sqlite] blocking on insert

threaded off into a low priority thread). Thanks in advance, Bill -- Bill King, Software Engineer Trolltech, Brisbane Technology Park 26 Brandl St, Eight Mile Plains, QLD, Australia, 4113 Tel + 61 7 3219 9906 (x137) Fax + 61 7 3219 9938 mobile: 0423 532 733

Re: [sqlite] C precompiler to bytecode

st pre-compile once per run, and attach to a database handle afterwards... -- Bill King, Software Engineer Trolltech, Brisbane Technology Park 26 Brandl St, Eight Mile Plains, QLD, Australia, 4113 Tel + 61 7 3219 9906 (x137) Fax + 61 7 3219 9938 mobile: 0423 532 733

[sqlite] Moving journal storage to another location...

done/committed, have that written to the sd media? Thanks in advance, Bill. -- Bill King, Software Engineer Trolltech, Brisbane Technology Park 26 Brandl St, Eight Mile Plains, QLD, Australia, 4113 Tel + 61 7 3219 9906 (x137) Fax + 61 7 3219 9938 mobile: 0423 532 733

Re: [sqlite] Major projects using SQLite

Jon García de Salazar Bilbao wrote: Hi, Could you give examples of some major software projects using SQLite? Thanks, Jon. Trolltech's qtopia mobile phone platform is using sqlite for pim, contacts, and document metainfo. http://www.trolltech.com/products/qtopia

Re: [sqlite] Compressing the DBs?

> We came across this with our filesystem metainfo system, what we ended up doing was creating a sub-table called "location". with this location it can be used either via join in the sql statement, or via a cached internal structure to recreate the path of a file. (Easy enough with a map<> or a hash<> style bucket class). No major overhead costs, but a definate savings in space. (Each directory becomes an entry in the location table, so a file is then stored as a location key value + filename). -- Bill King, Software Engineer Trolltech, Brisbane Technology Park 26 Brandl St, Eight Mile Plains, QLD, Australia, 4113 Tel + 61 7 3219 9906 (x137) Fax + 61 7 3219 9938 mobile: 0423 532 733

[sqlite] Windows binary > 3.3.6?

ime PostgreSQL user, but for small, quick, portable projects, SQLite looks like just the ticket. -- Bill Clay Charlotte NC

Re: [sqlite] SQLite performance for 10 Million Records

Manzoor Ilahi Tamimy wrote: Hello All, We are Using SQLite for one of our project. The Database Size is more than 500 MB. It contain one table and about 10 million Records. We are facing Problem in the select with single Join. The join is between a big table and a small table. The small

Re: [sqlite] Problems with multiple threads?

Jay Sprenkle wrote: > On 6/7/06, Bill KING <[EMAIL PROTECTED]> wrote: >> I understand why I'm getting the deadlock now, lazy locking, (it's >> against the logical grain of transaction/locking, but that's a whole >> other argument) . Maybe this should be

Re: [sqlite] Problems with multiple threads?

[EMAIL PROTECTED] wrote: > Bill King <[EMAIL PROTECTED]> wrote: > >> Christian Smith wrote: >> >>> If one transaction already has a read lock, and another transaction >>> has a reserved lock (trying to get a write lock), neither thread can >

  1   2   >