Hi all,
My project had to use Qt 3.3.8, which supports sqlite V2 only. How can I get
the source of V2?
BR
Russell
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hi,
> I'm thinking whether this is a memory leak or not sort of depends on
> your definition. If a process is designed to remain open for long
> periods of time with little activity, and it ends up taking up 1
> gigabyte of memory, that looks an awful lot like a leak to me. There
> are likely to
If the maximum memory footprint is too large, then you should arrange
to have a smaller memory footprint. For instance, you can use PRAGMA
cache_size to reduce the footprint there, use PRAGMA temp_store to
make sure you aren't storing temporary tables in memory, call
sqlite3_release_memory() to re
"Rob Richardson" <[EMAIL PROTECTED]> wrote:
> I'm thinking whether this is a memory leak or not sort of depends on
> your definition. If a process is designed to remain open for long
> periods of time with little activity, and it ends up taking up 1
> gigabyte of memory, that looks an awful lot li
I'm thinking whether this is a memory leak or not sort of depends on
your definition. If a process is designed to remain open for long
periods of time with little activity, and it ends up taking up 1
gigabyte of memory, that looks an awful lot like a leak to me. There
are likely to be at least th
Sam Carleton wrote:
> On Mon, Mar 24, 2008 at 4:11 PM, Jay A. Kreibich <[EMAIL PROTECTED]> wrote:
>
>> Try the math over:
>>
>> 24 hours * 60 minutes * 60 seconds = 86,400 seconds/day.
>>
>> 100,000 hits/day / 86,400 seconds/day = 1.1574 hits/sec (on average).
>>
>> Of course, this is on ave
My performance measurements using a modest server and a more efficient
www server than Apache gives an Sqlite capability of 30-50 hits per
second using simple SQL selects. Think of that as a reasonable upper limit.
Jay A. Kreibich wrote:
> On Mon, Mar 24, 2008 at 03:55:12PM -0400, Sam Carleton
On Mon, 24 Mar 2008 21:57:52 +0100, Gilles Ganault
<[EMAIL PROTECTED]> wrote:
> I'm having the following issue trying to access an SQLite 3.3.17
>database from PHP+PDO under FreeBSD 6.3: I can read, but can't write,
>with no error reported by PHP or /var/log/messages.
Found what it was: Even
sqlite3_open.
Mozaharul Haque wrote:
> Hi,
>
> A silly asking. I found the command to create a table but what about to
> create a database?
>
> The table would be stored in the sqlite_master table.
>
> And how do I refer (full path) to the database using application like
> Basic4ppc 6.05.
>
>
Hello
I'm having the following issue trying to access an SQLite 3.3.17
database from PHP+PDO under FreeBSD 6.3: I can read, but can't write,
with no error reported by PHP or /var/log/messages.
I've tried both Apache and Lighttpd as web server, to no avail.
Here's some information:
1. ec
On Mon, Mar 24, 2008 at 4:11 PM, Jay A. Kreibich <[EMAIL PROTECTED]> wrote:
> Try the math over:
>
> 24 hours * 60 minutes * 60 seconds = 86,400 seconds/day.
>
> 100,000 hits/day / 86,400 seconds/day = 1.1574 hits/sec (on average).
>
> Of course, this is on average. A real website gettin
On Mon, Mar 24, 2008 at 03:55:12PM -0400, Sam Carleton scratched on the wall:
> >From the web site's "Appropriate Uses for SQLite" it says that "any
> site that gets fewer than 100K hits/day should work fine with SQLite".
> I did the math and that looks to be around 69 hits a second.
Try the m
"Sam Carleton" <[EMAIL PROTECTED]> wrote:
> My application is an apache based kiosk system that displays images.
> The SQLite database is used by PHP to track user info, who is logged
> in and what they have selected. SQLite is NOT managing anything about
> the files. I have a few customers that
My application is an apache based kiosk system that displays images.
The SQLite database is used by PHP to track user info, who is logged
in and what they have selected. SQLite is NOT managing anything about
the files. I have a few customers that are running with 40 to 50
kiosks.
>From the web s
The following behavior when using LEFT OUTER JOIN with an indexed column
and literals in the ON clause is, I'm pretty sure, wrong. SQLite seems
to convert the join to an INNER JOIN in some cases.
The capture is from SQLite 3.4.2, but I get the same results with 3.5.7.
I also copied the raw SQL
Hi, Mahalakshmi,
Regarding: "..Am I doing right or it's a lengthy process.If so suggest
some other way for inserting the records?..."
I must confess I have not spent much time looking at the details of your
email, but you will want to be sure to use a single transaction to
insert many rows in yo
Sounds like the file was closed then re-opened, But the db was opened in
between assigning the db file number to STDERR.
Your app then happily used fprintf(STDERR, " blah blah blah" ); writing into
the DB file.
Solutions:
1. Don't use hard coded stderr.
2. Dont use freopen. (w
Anyone seen this ?
- My app is running happily like it has for years. Something happens..
- Result is that my logging which normally goes to a completely
different file (connected to stderr with freopen) ends up connected
to the SQLite database file, and writes all over the start of the
f
Dear All,
I have just started using the SQLite Db in my applications. My application
runs under MIPS processor. I have generated the Sqlite3.dll and Sqlite3.lib
file for the MIPS processor and it is geting compiled. When i use
Sqlit3_Open function to open a DB, it fails with the error message
SQL
I noticed other things while trying to compile under OpenBSD. First: there
is a warning:
#v+
*** Warning: linker path does not have real file for library -ltclstub85.
*** I have the capability to make that library automatically link in when
*** you link to this library. But I can only do this if
1)
SELECT rowid,Id,Name FROM MyTable ORDER BY Name;
Rowid Id Name
4 4 aaa
3 3 bbb
2 2 xxx
1 1 zzz
2)
"create table Temp as select Name from Mytable order by Name;"
RowidId Name
1 4
Hi,
I am working in 3.3.6
The table schema of my code is as follows.
"CREATE TABLE ALBUMARTIST(
AlbumArtistId INTEGER PRIMARY KEY NOT NULL,
AlbumArtistName TEXT NOT NULL COLLATE
NOCASE,UNIQUE(AlbumArtistName));"
"CREATE TABLE ARTIST(
ArtistId INTE
That work!
Thanks a lot.
Adolfo.
- Original Message -
From: <[EMAIL PROTECTED]>
To: "General Discussion of SQLite Database"
Sent: Monday, March 24, 2008 1:48 PM
Subject: Re: [sqlite] Help with sqlite3_blob_open()
> "A.J.Millan" <[EMAIL PROTECTED]> wrote:
>> Hello all:
>>
>> Using Win
"A.J.Millan" <[EMAIL PROTECTED]> wrote:
> Hello all:
>
> Using Windows XP:
>
> D:\Z\Zator5>sqlite3 zdb1
> SQLite version 3.5.4
> Enter ".help" for instructions
> sqlite> .tables
> AgEfHolder AgEfemerAgVtHolder AgVtos Usr lnk
> AgEfIDt AgPdHolder AgVtIDt Block atm
Hello all:
Using Windows XP:
D:\Z\Zator5>sqlite3 zdb1
SQLite version 3.5.4
Enter ".help" for instructions
sqlite> .tables
AgEfHolder AgEfemerAgVtHolder AgVtos Usr lnk
AgEfIDt AgPdHolder AgVtIDt Block atm prm
AgEfKlv AgPdIDt AgVtPre FreqUse
"Alexander Batyrshin" <[EMAIL PROTECTED]> wrote:
> Hello,
> Is it safe to use this algorithm:
>
> open_db
> fork()
> sql_do() // both parent and child executes sql statements
> close_db
>
> I am not familiar with locking mechanism and I am afraid that if
> parent and child will use the same DB ha
"Mozaharul Haque" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
> A silly asking. I found the command to create a table but what about
> to create a database?
Just give a file name to sqlite3_open, then create a table. If the file
didn't exist, it will be created at this point.
Igo
Hi,
I am trying to compile sqlite with a java program (basically for J2ME - MIDP
application). for this purpose I have downloaded the amalgamation version of
the code (3.5.x). But There are some problems.
1. how to mix a C/C++ code with j2me code.
2. how do i provide the java.sql.* classes
Hi,
A silly asking. I found the command to create a table but what about to
create a database?
The table would be stored in the sqlite_master table.
And how do I refer (full path) to the database using application like
Basic4ppc 6.05.
Please help.
regards,
Mozaharul Haque
___
29 matches
Mail list logo
