in the documentation: "Appropriate Uses For SQLite" it
says:
"it is often easier and quicker to load the data into
an in-memory SQLite database and use queries with
joins and ORDER BY clauses to extract the data in the
form and order needed rather than to try to code the
same operations
I understand you are supposed to open a new sqlite3 connection for
every thread that needs access, but- would it be safe to wrap access
to the database with a mutex? I've got code that needs to insert at
random times (sometimes many times per sec) and select once per sec in
another thread. The
-Original Message-
From: Jay [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 03, 2005 1:43 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Thanks!
> >I believe writing C or C++ code is harder than writing interpreted
> >code. My aim has always been to produce the best product I
On Thu, 2005-03-03 at 19:00 -0600, David Taylor-Fuller wrote:
>char* sqlStmt=sqlite3_mprintf("INSERT INTO %q
> (FileName,ArtistName,TrackNum,TrackName,AlbumName,Genre,Year) values
> (%q,%q,%q,%q,%q,%q,%q)",
> Can Someone please I beg of you explain to me why I am getting the
>
Ok I have skimmed the archives and even though people have had similar
problems there solution all point to using '' as an escape instead of
'\. However that doesnt solve my problem. I am writting a mp3player
and wanted to use sqlite as the db backend for the library. Now all
was going well untill
[EMAIL PROTECTED] wrote:
After 15 years of assembler programming, I am still to find a compiler that
makes debugging and optimizing as easy as assembler.
I can't remember the number of times that C has got me deep into memory
leaks.
Then give C++ a try.
If you need low level programming, C is a
At 11:43 AM -0800 3/3/05, Jay wrote:
One of the things the C++ experts take particular care to remind
everyone is that character arrays are evil. I thought using string
classes mostly elminated the buffer overflow problem. The string
class is heavily examined for such errors as are the
Hi,
I ran all the available tests for sqlite 3.1.0. I got a code coverage of 41%
I read that sqlite has a 90% code coverage, can someone provide the list of the
files instrumented ?
Thanks
Claire
Jay said:
> I used cgicc.
> It's good workable code, but it's a pain sometimes to understand!
Agreed. In fact I use cgic in either C or C++, since it's easy to use.
The licensing is agreeable too, since even a commercial license is very
inexpensive.
Clay
--
Lazarus Notes from Lazarus
> like try to write your own CGI parser. Libraries like cgic at
> http://www.boutell.com/cgic/ and cgicc at http://www.cgicc.org make a
> lot
> more sense than reinventing that particular wheel yourself. They
> also
> address the buffer overflow problem directly by using strings, or
> forcing
>
--- [EMAIL PROTECTED] wrote:
> Agree, C is great and thanks God we got it in our asenal of tools.
> But it
> is not pefect because of its own strengths.
> After 15 years of assembler programming, I am still to find a
> compiler that
> makes debugging and optimizing as easy as assembler.
> I
John:
Check out SQL Relay at http://sqlrelay.sourceforge.net/
It will do locks but you can lock/unlock really fast.
Regards,
[EMAIL PROTECTED]
NCCI
Boca Raton, Florida
561.893.2415
greetings / avec mes meilleures salutations / Cordialmente
mit freundlichen Grüßen / Med vänlig hälsning
Darren Duncan said:
> One caveat of languages like C and C++ is that you are opening
> yourself to several classes of potential security problems that
> interpreted languages tend not to have.
You are opening yourself to such problems only if you do something rash
like try to write your own CGI
Ok thanks for responding...
That was my understanding but I was wondering why it only returned 1 Row in
*pnRow. I've figured it out now (I think). The first row contains the column
name but does not count as a result. Hence the 1 row that is referred to in
*pnRow returned from sqlite3_get_table()
>
> can a similar argument be made for assembler?
Yes, but modern C compilers generate code that's 99% as good as
a human would write. I've tried to write better code in assembler
than the compiler does. I've managed it, but's it's pretty hard.
If you profile your code you generally find that
On Thu, 2005-03-03 at 11:06 -0800, Darren Duncan wrote:
> The main advantages of C is that you can get the smallest possible
> footprint and greatest possible speed;
>
That is not the reason CVSTrac is written in C. CVSTrac is
written in C to reduce its administration burden. You can
drop a
Richard Boyd wrote:
Hi all,
I’m trying to use sqlite3_get_table() to execute SQL commands on a
database. I’ve included a code snippet below.
The problem I’m having is that when I execute the "SELECT
MAX(time_stamp) FROM table32;” command using sqlite3_get_table() I
only get one column and 1
can a similar argument be made for assembler?
Regards,
[EMAIL PROTECTED]
NCCI
Boca Raton, Florida
561.893.2415
greetings / avec mes meilleures salutations / Cordialmente
mit freundlichen Grüßen / Med vänlig hälsning
At 7:27 AM -0800 3/3/05, Jay wrote:
I believe writing C or C++ code is harder than writing interpreted
code. My aim has always been to produce the best product I could,
not to produce it with as little effort as possible. I hope the
extra effort was worth it. I guess time will tell if I chose
> > * An event management web site for a convention.
> > * Gentoo 2004
> > * Linux 2.4 kernel
> > * AMD Duron 600mhz w/ 256 meg RAM
> > * lighttpd web server
> > * C++ cgi
> > * sqlite backend database
>
> I'm heartily glad to hear that I'm not the only poor deluded fool
> writing
> CGI apps in C
On Thu, 2005-03-03 at 08:33 -0500, Clay Dowling wrote:
> I'm heartily glad to hear that I'm not the only poor deluded fool writing
> CGI apps in C and C++.
FWIW, the CVSTrac program used for bug tracking on www.sqlite.org
is a C program that runs as CGI and uses SQLite as its database
backend.
Jay said:
> My project:
>
> * An event management web site for a convention.
> * Gentoo 2004
> * Linux 2.4 kernel
> * AMD Duron 600mhz w/ 256 meg RAM
> * lighttpd web server
> * C++ cgi
> * sqlite backend database
I'm heartily glad to hear that I'm not the only poor deluded fool writing
CGI apps
D. Richard Hipp wrote:
On Thu, 2005-03-03 at 07:30 -0500, Christopher R. Palmer wrote:
It looks to me like this test assumes that no other process currently has a
lock on this file. If any other process has any lock on this file, I
believe one or both of the locking calls will fail which will
On Thu, 2005-03-03 at 07:30 -0500, Christopher R. Palmer wrote:
> It looks to me like this test assumes that no other process currently has a
> lock on this file. If any other process has any lock on this file, I
> believe one or both of the locking calls will fail which will trick sqlite
>
I am using version 3.0.8 of sqlite.
In the course of trying to track down a strange error in my application
where I very infrequently get a database is locked error (even though my
busy timeout is set to some insanely large number, like a billion seconds),
I was looking through the code is
Hi!
Detlef Groth wrote:
Hello,
You can try my program dgSQLite. I recently added sqlite3 support:
http://goblet.molgen.mpg.de/dgSQLite3.kit
You need a tclkit runtime from:
http://www.equi4.com/pub/tk/downloads.html
in order to run it.
[...]
I've tried it for Linux (Fedora Core 3) :
Hello,
You can try my program dgSQLite. I recently added sqlite3 support:
http://goblet.molgen.mpg.de/dgSQLite3.kit
You need a tclkit runtime from:
http://www.equi4.com/pub/tk/downloads.html
in order to run it.
The old version for sqlite2 is at:
http://www.microemacs.de/tcltk_dgsqlite.html
27 matches
Mail list logo