has a 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
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 I
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
_
I am attaching the patch file to this bug report...
Questions, Comments, Suggestions, Complaints? :)
Bill Parker (wp02855 at gmail dot com)
buf = malloc(80);
#if 1
buf = NULL;/*force buf to point to NULL*/
#endif
while (0 <-- x)
printf("Value of x is: %d\n", x);
printf("before memcpy() is called...\n");
memcpy(buf, "hello", 5);/* what happens? */
printf(&q
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
e. This is an area you could
include your URL 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
his:
$sql = qq/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
Yes, that should work.
Thanks!!
Dave Watkinson wrote, On 2/22/2012 5:33 PM:
Did you mean something like
SELECT '"'||text_field||'"' FROM table;
so that your column's data is quoted?
~~~
Dave Watkinson
On Wed, Feb 22, 2012 at 6:26 PM, Igor Tandetnik
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
htt
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, b
Nico Williams wrote, On 2/6/2012 12:44 PM:
On Mon, Feb 6, 2012 at 9: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
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
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
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!!
___
sql
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 itself.
Here is a simple example
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)
su
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 grou
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 I
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
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 pas
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 se
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 pr
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.or
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 TIME_STAM
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
S
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
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 m
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
/usr/share/perl/5.10.1/CPANPLUS/Internals/Source/SQL
Stephan Beal wrote, On 1/25/2012 11:36 AM:
On Wed, Jan 25, 2012 at 6:33 PM, Bill McCormickwrote:
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 left me with my questions in the
Stephan Beal wrote, On 1/25/2012 11:01 AM:
On Wed, Jan 25, 2012 at 5:45 PM, Bill McCormickwrote:
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(*)(void*));
It doesn
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
me given a unix timestamp 1092941466.
SELECT datetime(1092941466, 'unixepoch');
--David Garfield
On Tue, Jan 17, 2012 at 19:32, Bill McCormick wrote:
I'm trying to write a function with a sig like this:
int BindParameter(sqlite3_stmt* stmt, int sqlType, const char* pname,
c
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
17
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!!
__
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 call
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
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
Stephan Beal wrote, On 1/16/2012 12:15 PM:
On Mon, Jan 16, 2012 at 7:12 PM, Bill McCormickwrote:
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. Just
to name a few:
-
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 lookin
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 hel
Tim Streater wrote, On 1/15/2012 3:00 PM:
On 15 Jan 2012 at 20:44, Bill McCormick 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 and make
everybody happy.
Forget
From: 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 compi
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!!
_
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 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
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
ct: Re: [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 must've bee
Tandetnik
Sent: Sunday, 27 June 2010 1:21 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] sqlite3_abort()?
Bill Webster wrote:
> Sorry for not being clear enough.
>
> I meant something that released all open files, blob handles, statement
> handles etc., without terminating the pro
From: 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 We
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-
tion 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 Ki
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 dea
.org
> http://sqlite.org: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, o
7;s document and not some other sqlite database. I am having
trouble doing this schema verification.
I'll go back to lurking,
Bill
_
Hotmail: Powerful Free
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
defining 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 switch
we'll schedule it with 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 y
-1 , 0);
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
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, datetime
king about 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/
ze 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
- --
B
ise,
>> you'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 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 mail
unsubscribe
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 T
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
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, sqlite-
y may 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 Pa
; ___
> sqlite-users mailing 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
vinced it
> can 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..
>
> Mark
[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?
>>
>
any
> serious problems. 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, sen
Bs and BLOBs
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 t
not inside of the database 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]
-
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.
The
uld otherwise be the ideal solution because then I _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]
---
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
semaphor
getting unblocked? Am I missing 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]
-
;>>>> 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 upda
l sqlite3_enable_load_extension 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
CLOEXEC fcntl 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)
Fa
-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://facilitateds
ted to use J to process
results for a small task that happened to call for a database, and it
seemed easier to go with SQLite than to link to a client-server RDBMS
through ODBC. So far, that seems to be the case.
Bill
- --
Bill Harris http://fa
On Jan 18, 2007, at 12:29 PM, Bill Hernandez wrote:
if (whichChoice = "--") then -- If they select a divider line in
the popup menu, ignore the request
set validRequest to false
As I was reading through the message after I sent it I realized it
had a small bug.
Shoul
ly. I shut
down my computer about 2:30AM last night, and this morning 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 come
" &
searchField & " 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]
-
couple 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:
>&
it has no
> 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 Plai
x this. (The error is correct, 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
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 hav
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 obt
case?
>
I trust your judgement on this ;)
> --
> D. Richard Hipp <[EMAIL PROTECTED]>
>
>
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
>
>
>
--
Bill King, Software Engineer
Tr
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_sto
essing, etc even tho it's 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
e could even
just 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
when it's 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
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
t;
>> -- Darren Duncan
>
>
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
. I'm a long-time
PostgreSQL user, but for small, quick, portable projects, SQLite looks
like just the ticket.
-- Bill Clay
Charlotte NC
1 - 100 of 127 matches
Mail list logo