Re: [sqlite] sqlite/js based webserver update to 0.5.2.1.g

2006-11-06 Thread hongdong
I tried several times,time out always.thanks 2006/11/6, Günter Greschenz <[EMAIL PROTECTED]>: Hi, i tried it just 10 secends ago, and it worked ?!? well sometimes i have trouble with my provider (my server is at home)... i will create a second download location (not at home) so these kinds of

Re: [sqlite] sqlite/js based webserver update to 0.5.2.1.g

2006-11-06 Thread Günter Greschenz
Hi, i'm sorry for this behaviour, i really dont know why this happens. internally (LAN at home) and here from my office it works perfectly... but however here is a second download possibility: at 1und1.de: http://www.greschenz.de/gas0521g.zip at home:

Re: [sqlite] sqlite/js based webserver update to 0.5.2.1.g

2006-11-06 Thread Martin Jenkins
[EMAIL PROTECTED] wrote: please have a look at http://greschenz.dyndns.org/gas.gsp Just to confirm that this page still works fine here. (via Zen Internet, UK) Martin - To unsubscribe, send email to [EMAIL

[sqlite] Loading a table into memory

2006-11-06 Thread chetana bhargav
Hi, I have a read only table, which is very small(Bytes of storage consumed. 1024 from the analyzer). I am wondering is there any way to load this table in memory and unload it later. ... Chetana.

Re: [sqlite] MAX SQLite Size?/ Corrupt Database

2006-11-06 Thread Martin Jenkins
viking2 wrote: I have a large (1.46 GB!) SQLite database (v2) with two tables: >[...] 1. I dumped the database into a text file, Data_full.sql= 949 MB 2. I also deleted the first table and dumped the data into another text file (Data_TB_SR.sql) which is only 532 MB. First thing I'd do is

[sqlite] Backup sqlite

2006-11-06 Thread Roger Gullhaug
Hi, I use the following code to create backup of an sqlite3 database. "BEGIN IMMEDIATE" copyDbFile(); "COMMIT" Is it safe to remove the explicit transaction here (Begin immediate) if I only have one process accessing this db? Or should I always use Begin Immediate before coping the file?

RE: [sqlite] Sqlite DB file sizes

2006-11-06 Thread Dave Gierok
How difficult would it be to change my version of Sqlite such that it uses 32-bit floats instead of doubles for REAL values in :memory: databases (or even all databases)? Could you point me in the right direction? We are in a real shortage for RAM in our game. I appologize if this is the

Re: [sqlite] Sqlite DB file sizes

2006-11-06 Thread chetana bhargav
Pls see this message. http://www.mail-archive.com/sqlite-users@sqlite.org/msg19255.html ... Chetana. - Original Message From: Dave Gierok <[EMAIL PROTECTED]> To: "sqlite-users@sqlite.org" Sent: Monday, November 6, 2006 10:10:39 PM Subject: RE: [sqlite] Sqlite

[sqlite] String --> Integer date formatting

2006-11-06 Thread Emmanuel
Hello, I am using SQLite as part of Trac (http://trac.edgewall.com/) to generate reports on our ticket system. I have normal date fields (stored as an integer, and easily manipulated with date(), strftime(), etc.) I have one extra field that contains a date but is stored as a DD/MM/

Re: [sqlite] Sqlite DB file sizes

2006-11-06 Thread chetana bhargav
Try to see the reply, at http://www.mail-archive.com/sqlite-users@sqlite.org/msg19255.html ... Chetana - Original Message From: Dave Gierok <[EMAIL PROTECTED]> To: "sqlite-users@sqlite.org" Sent: Monday, November 6, 2006 10:10:39 PM Subject: RE: [sqlite]

Re: [sqlite] String --> Integer date formatting

2006-11-06 Thread Dennis Cote
Emmanuel wrote: I have normal date fields (stored as an integer, and easily manipulated with date(), strftime(), etc.) I have one extra field that contains a date but is stored as a DD/MM/ string. I would like to calculate the number of days between the two. This would be an easy

[sqlite] OS/2 port busted?

2006-11-06 Thread drh
Check-in [3503] at http://www.sqlite.org/cvstrac/chngview?cn=3503 seems likely to have broken the OS/2 port. But since I know nothing about OS/2, I'm unable to fix it. If anyone would care to contribute a patch, I'll be glad to fold it it. I didn't test the changes that were made to the win32

[sqlite] sqlite smaller executable

2006-11-06 Thread tim
I'm trying to build the smallest possible binary, but if I use anything more than 2 or 3 Omits it will not link, and I'll get a page full of undefined references. Thanks! My source file only contains the following sqlite calls: sqlite3_open() sqlite3_exec() sqlite3_free() sqlite3_close() I

[sqlite] configure: error: unable to find a compiler for building build tools

2006-11-06 Thread tim
"configure: error: unable to find a compiler for building build tools" Anyone know of a work-around for this. using 3.3.8 and armutils cross-compiler. Thanks! - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] sqlite/js based webserver update to 0.5.2.1.g

2006-11-06 Thread hongdong
Thanks,the second works,maybe the DNS is just server in some range. 2006/11/6, Günter Greschenz <[EMAIL PROTECTED]>: Hi, i'm sorry for this behaviour, i really dont know why this happens. internally (LAN at home) and here from my office it works perfectly... but however here is a second

Re: [sqlite] Loading a table into memory

2006-11-06 Thread Jay Sprenkle
you can use a database named :memory: Is that what you were looking for? On 11/6/06, chetana bhargav <[EMAIL PROTECTED]> wrote: Hi, I have a read only table, which is very small(Bytes of storage consumed. 1024 from the analyzer). I am wondering is there any way to load this