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
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
/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
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 problem. What's wrong with
simply
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
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,
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
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
Nico Williams wrote, On 2/6/2012 12:44 PM:
On Mon, Feb 6, 2012 at 9:36 AM, Bill McCormickwpmccorm...@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 the data in an existing
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
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
Igor Tandetnik wrote, On 2/2/2012 10:50 AM:
Petite Abeillepetite.abei...@gmail.com 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.
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!!
___
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
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 sqlite3.h
int main(int argc, char** argv)
{
sqlite3 *db;
PRAGMA journal_mode=WAL;
...
gcc -g -Wall -lrt -I.. -I../../include -I../ini-parse
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
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 sqlite3.h
int main(int argc, char** argv)
{
sqlite3 *db;
PRAGMA journal_mode=WAL;
...
gcc
[various errors]
The PRAGMA is something you pass
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 presume you mean some
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
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
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
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
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 took
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 anything
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
Stephan Beal wrote, On 1/25/2012 11:01 AM:
On Wed, Jan 25, 2012 at 5:45 PM, Bill McCormickwpmccorm...@gmail.comwrote:
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
Stephan Beal wrote, On 1/25/2012 11:36 AM:
On Wed, Jan 25, 2012 at 6:33 PM, Bill McCormickwpmccorm...@gmail.comwrote:
http://www.sqlite.org/**capi3ref.html#sqlite3_bind_**blobhttp://www.sqlite.org/capi3ref.html#sqlite3_bind_blob
Ha! That's the full description that left me with my questions
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
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!!
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
timestamp 1092941466.
SELECT datetime(1092941466, 'unixepoch');
--David Garfield
On Tue, Jan 17, 2012 at 19:32, Bill McCormickwpmccorm...@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,
char* value
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
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 looking
Stephan Beal wrote, On 1/16/2012 12:15 PM:
On Mon, Jan 16, 2012 at 7:12 PM, Bill McCormickwpmccorm...@gmail.comwrote:
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
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
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
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!!
-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 the SQLite
Tim Streater wrote, On 1/15/2012 3:00 PM:
On 15 Jan 2012 at 20:44, Bill McCormickwpmccorm...@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 and make
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
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
: 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
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., without terminating
] 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 been considered and that there is a practical
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Bill King, Software Engineer
Qt Development Frameworks, Nokia Pty Ltd
Brisbane Office
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
pthreads on.
--
Bill King, Software Engineer
Qt Development Frameworks, Nokia Pty
, and there's a QtSql wrapper for the sqlite server
engine access in the works, or native sqlite is included in qt/s60 by
default.
--
Bill King, Software Engineer
Qt Development Frameworks, Nokia Pty Ltd
Brisbane Office
___
sqlite-users mailing list
verification.
I'll go back to lurking,
Bill
_
Hotmail: Powerful Free email with security by Microsoft.
http://clk.atdmt.com/GBL/go/171222986/direct/01
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
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.
--
Bill King, Software Engineer
Qt Development Frameworks, Nokia Pty Ltd
Brisbane Office
___
sqlite
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, and trying to
see where the code's actually failing/returning SQLITE_BUSY to you?
--
Bill King, Software Engineer
Qt Development Frameworks, Nokia
);
...
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,
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
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
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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin
overhead from conversions back
and forth between
utf8 and utf16 inside the sqlite code.
Igor Tandetnik
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Bill King
unsubscribe
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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,
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 Technology
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,
vs benefit and all that guff.
--
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-users mailing list
, 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 Brandl St, Eight Mile Plains,
QLD, Australia
-bin/mailman/listinfo/sqlite-users
--
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-users
[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?
You can always pull the old code frm CVS
]
-
--
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
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.
--
Bill Gatliff
[EMAIL
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]
-
_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
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
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]
-
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. The GUI
the problem, one may use the clear() method of the QSqlQuery.
Alain
--
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
that I wont
have to call 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 in advance for any suggestions.
- Alex
--
Bill King, Software
-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://facilitatedsystems.com/weblog
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
%' 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
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 operating system):
( 1 ) AppleScript which allows you to access (set/get) info from
almost all
this.
Thanks,
Mike
Qt usually uses an internal build of sqlite. If you recompile using the
configure switches to specify the system version rather than the qt
internal version, it should fix this. (The error is correct, the qt
version's older and incompatible with your system version).
--
Bill King
this.
Thanks,
Mike
Err, s/qt/ROR/
--
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
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:
Michael P. Soulier wrote:
Hello,
I just checked out my Rails project
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
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
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
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 = memory
but i'm still seeing
of multi-threading), so there's no way I've seen yet to compile an sql
query that i can distribute to the different handles, so every statement
gets prepared just before run. Huge performance hit. If we could even
just pre-compile once per run, and attach to a database handle afterwards...
--
Bill
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
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
, but for small, quick, portable projects, SQLite looks
like just the ticket.
-- Bill Clay
Charlotte NC
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
[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
get a write lock. One of the transactions must abort
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 highlighted with big arrows in
the information
.
--
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
this, this doesn't solve the issue. As I
mentioned earlier, I followed all the rules, the only solution to avoid
the issues he's getting was to handle read/write locking myself.
--
Bill King, Software Engineer
Trolltech, Brisbane Technology Park
26 Brandl St, Eight Mile Plains,
QLD, Australia, 4113
? One
problem I did see with all this, is that once this error occurs, there
are cascading failures (possibly because transaction left open due to
failure to commit or some other reason).
--
Bill King, Software Engineer
Trolltech, Brisbane Technology Park
26 Brandl St, Eight Mile Plains,
QLD
Joe Wilson wrote:
Hi Bill,
When you say handle read/write locking [your]self do
you mean outside of SQLite in your code or by altering
SQLite's source code?
What algorithm do you employ?
--- Bill KING [EMAIL PROTECTED] wrote:
I personally did do all this, this doesn't solve
Joe Wilson wrote:
--- Bill KING [EMAIL PROTECTED] wrote:
Outside of, and I use Qt's QReadWriteLock. -lockForRead()/lockForWrite()
http://doc.trolltech.com/4.1/qreadwritelock.html
Thanks.
Many follow-up questions... :-)
Is this for an application or for the Qt SQLite database
1 - 100 of 116 matches
Mail list logo