[sqlite] Command to create a database in sqlite

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

[sqlite] Help needed: using sqlite with j2me (MIDP)

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.*

Re: [sqlite] Command to create a database in sqlite

"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.

Re: [sqlite] Is it safe to ...

"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

[sqlite] Help with sqlite3_blob_open()

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

Re: [sqlite] Help with sqlite3_blob_open()

"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

Re: [sqlite] Help with sqlite3_blob_open()

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: >>

[sqlite] Performance of bulk insertion

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

[sqlite] Rowid After Sorting

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

[sqlite] SQLITE3_OPEN returns SQLITE_NOMEM

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

[sqlite] fprintf(stderr,...) wrote over my database.........

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

Re: [sqlite] fprintf(stderr,...) wrote over my database.........

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.

Re: [sqlite] Performance of bulk insertion

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

[sqlite] Issue with LEFT JOIN, index, and literal in ON clause

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

[sqlite] performance under load

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

Re: [sqlite] performance under load

"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

Re: [sqlite] performance under load

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

Re: [sqlite] performance under load

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

[sqlite] [FreeBSD] Can read but can't write?

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.

Re: [sqlite] Command to create a database in sqlite

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. >

Re: [sqlite] [FreeBSD] Can read but can't write?

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:

Re: [sqlite] performance under load

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

Re: [sqlite] performance under load

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

Re: [sqlite] Major memory leak

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

[sqlite] Lit

"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

Re: [sqlite] Major memory leak

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: [sqlite] Major memory leak

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

[sqlite] how can I find source of sqlite V 2.x

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