Re: [sqlite] Looking for sqlite3_fds.h and fds.c

2007-04-13 Thread Martin Jenkins
Huian Li wrote: I have a package which uses functions like sqlite3_get_database_file_fd() and sqlite3_get_journal_file_fd(). Supposedly sqlite3_fds.h has these two functions and fds.c defines them, but I searched both sqlite-3.3.4 and sqlite-3.3.15, and could not find anything. Does anyone know

Re: [sqlite] Optimize a query

2007-04-17 Thread Martin Jenkins
Marco Bambini wrote: This query on a small database sometimes takes more than 40 seconds: select _rowid, public_id, vote_count, status, summary, component, date(date_modified), quickfix from reports where public = 1 AND _rowid IN (select distinct r._rowid from reports r, segments s where

Re: [sqlite] Recommended wrapper for Python?

2007-04-23 Thread Martin Jenkins
Gilles Ganault wrote: At 14:40 23/04/2007 +0200, Stef Mientki wrote: I've no experience whatsover, but if I see the list, the top one is the best choice, because it'll be integrated in the standard Python. Thanks. I didn't know SQLite was part of Python 2.5. pysqlite implements Python's

Re: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14?

2007-04-30 Thread Martin Jenkins
Bennett, Patrick wrote: No comment at all? That's three users asking for this now. :( Dr Hipp usually responds pretty quickly, but sometimes he's away on business. You know, supporting the paying customers... ;) Martin

Re: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14?

2007-04-30 Thread Martin Jenkins
Bennett, Patrick wrote: I wasn't sure who maintained the binary distribution and based on the recent list activity, I assumed someone who was responsible would've already replied. As fas as I know, the dev team is Dr Hipp and Dan Kennedy (apologies if there's someone else and I missed you)

Re: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14?

2007-04-30 Thread Martin Jenkins
[EMAIL PROTECTED] wrote: Martin Jenkins <[EMAIL PROTECTED]> wrote: I agree, it is slightly odd for neither of them to reply. Why is it odd? Because you normally reply to these things, if only to say something lie "the pre-processed source for Windows is provided as a courtesy

Re: [sqlite] Multiple connections to the same database and CREATE TABLE command

2007-05-11 Thread Martin Jenkins
Vivien Malerba wrote: Hi! In a single process, I open two connections (C1 and C2) to the same database (this is actually a corner case which could happen) and the following sequence of operations fail: 1- on C1 execute "CREATE table actor (...)" => Ok 2- on C1 execute "SELECT * FROM actor" =>

Re: [sqlite] Re: Re: Order of result of a query?

2007-05-16 Thread Martin Jenkins
B V, Phanisekhar wrote: Kennedy, You are using Join that's going to take time. I need the most efficient query. Dan's one of the SQLite developers, so presumably has a rough idea of what his suggested query will be doing... ;) Martin

Re: [sqlite] Override LIKE

2007-05-16 Thread Martin Jenkins
Jonas Sandman wrote: > I am using LIKE to make a simple query for filename '%path%' and it > works well as long as I am only using ANSI characters, LIKE thinks > 'a' and 'A' are the same. When coming up on Greek characters (i.e.) > it doesn't work that well anymore. Suddenly LIKE is

Re: [sqlite] PRAGMA cache_size = 0

2007-06-15 Thread Martin Jenkins
B V, Phanisekhar wrote: What exactly happens when I change the cache_size (both increase and decrease size)? A variable is set. It seems this term is a misnomer. What are we achieving by setting this variable? [...] Will there be any memory that will be freed up when I reduce the size

Re: [sqlite] Custom Aggregation Not Working

2007-06-19 Thread Martin Jenkins
wcmadness wrote: Hey, Folks: I'm writing a financial application and MUST have exact math decimals (no floats). So, I'm using Python's decimal module. My database is Sqlite (and my language is Python with Pysqlite); Sqlite doesn't offer a non-floating point decimal type. But, it does have

Re: [sqlite] Cache invalidation after insert statements.

2007-06-20 Thread Martin Jenkins
Joe Wilson wrote: A non-volatile RAM drive is the way to go if you got the bucks. 16 Processor machine ~40Gb ram EMC storage suggests he does. ;) I worked on a project where the end client had Sun kit of this spec, and they claimed the systems cost 7 figures GBP back in 2005. Martin

Re: [sqlite] Capturing output from SQLlite with variables in a BASH script

2007-06-22 Thread Martin Jenkins
litenoob wrote: Hi, I'm wondering how to write a BASH script that will capture my SQLite output. I can do it for a single line with something like this: somevar=`sqlite3 dbfilename "SELECT name FROM tablename WHERE name='smith' LIMIT 1;"` However, if I want to do anything with multiple lines,

Re: [sqlite] SQLite performance for 10 Million Records

2006-06-26 Thread Martin Jenkins
Dennis Cote wrote: Joe Wilson wrote: I think some other factor is at play here. Yes there is another factor at work here. [...] I suspect there are optimizations that could be made to the memory I/O routines to speed them up, they should at least be able to run slightly faster than file

Re: [sqlite] SQLite performance for 10 Million Records

2006-06-26 Thread Martin Jenkins
Joe Wilson wrote: --- Martin Jenkins <[EMAIL PROTECTED]> wrote: For :memory: databases, long periods were observed where the VM size crept up but I/O write bytes did not, followed by periods where I/O bytes increased. If you use "PRAGMA temp_store=MEMORY" with your :memor

Re: [sqlite] i have a few Qs - sqlite3

2006-07-08 Thread Martin Jenkins
353455 453455 wrote: www.yeohhs.com/vcsqlite1.htmI doesnt seem to work for me, wrong url? >> www.yeohhs.com/vcsqlite1.htmItcovers some basics of SQLite, and the It's pretty obvious from the context and structure of that message that the URL http://www.yeohhs.com/vcsqlite1.htm got run into

Re: [sqlite] i have a few Qs - sqlite3

2006-07-08 Thread Martin Jenkins
. Learning to crawl before trying to walk or run can be a poorly understood fact of life for some novices. On Sat, 08 Jul 2006 11:23:03 +0100, Martin Jenkins wrote: You might find it useful to take a look at http://www.catb.org/~esr/faqs/smart-questions.html before asking any more questions. Use

Re: [sqlite] i have a few Qs - sqlite3

2006-07-08 Thread Martin Jenkins
353455 453455 wrote: excuse me?. do you really think this is my homework and that i want someone like him to do it for me?. I didn't earlier, but it seems obvious now because you're clearly not capable of it. Like most of the others here I learned things the hard way, by working them out for

Re: [sqlite] i have a few Qs - sqlite3

2006-07-08 Thread Martin Jenkins
Nuno Lucas wrote: Please don't feed the troll... ;)

Re: [sqlite] i have a few Qs - sqlite3

2006-07-08 Thread Martin Jenkins
Apologies to the rest of the list, but I've had one of those days. ;) mj

Re: [sqlite] SQLite String

2006-07-11 Thread Martin Jenkins
Ernesto Olmos wrote: > This is because I trasmit the database via HTTP (I encrypt the string Are you sure there won't be any endian-ness issues sending memory images between machines? I know disk based files are portable across different hardware but they're byte-swapped on read/write to disk.

Re: [sqlite] Escape issue

2006-07-11 Thread Martin Jenkins
You need to import pysqlite, not sqlite. I think the latter has been deprecated - it's certainly quite old. AIUI pysqlite is built in to Python 2.5 so you'd import sqlite3 there. PythonWin 2.4.3 (#69, Mar 29 2006, 17:35:34) [MSC v.1310 32 bit (Intel)] on win32. Portions Copyright 1994-2004

Re: [sqlite] How do you find out the names of the fields within a table?

2006-07-13 Thread Martin Jenkins
John Newby wrote: Yeah I can get the names, but I need to put them in an array, and to put them in an array I need to know the size of the array to store them in, so I need to get a count first, then store this number as the size of the array before I store the values into the array. Are you

Re: [sqlite] How do you find out the names of the fields within a table?

2006-07-13 Thread Martin Jenkins
John Newby wrote: I would still need to know how many times to go through the while > loop to add the names of the fields? John, I haven't been following this thread that closely, but (based on other wrappers I've used) I would have expected your sqlite wrapper to do one of two things: a)

Re: [sqlite] How do you find out the names of the fields within a table?

2006-07-13 Thread Martin Jenkins
I can't see anything obviously wrong with that code, but that's probably because it's the only bit of VB I've ever looked at. :-/ You need to divide and conquer - does the combo box get filled properly if you hard code the values in fieldNames in selectFieldNames()? If so, print out the value

Re: [sqlite] "no such column" problem with multi level sub queries

2006-07-14 Thread Martin Jenkins
No doubt Igor or one of the others will be able to explain *why* your SQL fails but changing line 1 from > 1: SELECT testlog.error, to > 1: SELECT error, works with Python 2.5 using the built-in sqlite (3.3.4) on XP and with Python 2.4 and pysqlite (2.8.16) on Debian Sarge. Martin John

Re: [sqlite] Re: Memory exhaust

2006-07-14 Thread Martin Jenkins
Robert Wallner wrote: Even the smallest sql statement (like PRAGMA temp_store = 1) triggers this behaviour when using sqlite 3.3.x. I forgot to mention that I connect to a :memory: database and then attach 2 database to the connection. I've been using the apsw and pysqlite wrappers for some

Re: [sqlite] Major projects using SQLite

2006-07-14 Thread Martin Jenkins
Jon García de Salazar Bilbao wrote: Hi, Could you give examples of some major software projects using SQLite? Thanks, Jon. Solaris 10 - http://blogs.sun.com/roller/page/eric_boutilier/20050405 Martin

Re: [sqlite] This great!

2006-07-17 Thread Martin Jenkins
Hi, The subscribe/unsubscribe info you want is in the message headers: List-Id: SQLite Users Mailing List List-Post: List-Help: List-Unsubscribe: List-Subscribe: Regards, Martin

Re: [sqlite] Altering a table when field(column) names are unknown

2006-07-24 Thread Martin Jenkins
This is all good when the fields(columns) are known in advance, but how would I attempt doing this without knowing the name of the fields? You need to recast your problem into one where the field names ARE known. ;) Just issue a "pragma table_info(table_name)" as shown below in an sqlite

Re: [sqlite] locked implies exception?

2006-07-24 Thread Martin Jenkins
Jay Sprenkle wrote: what's a CRUD? I wondered that too. http://en.wikipedia.org/wiki/CRUD_(acronym) Martin

Re: [sqlite] locked implies exception?

2006-07-24 Thread Martin Jenkins
John Stanton wrote: I used to have one but I had to shoot it when it went feral. As a puppy? mj Martin Jenkins wrote: Jay Sprenkle wrote: what's a CRUD? I wondered that too. http://en.wikipedia.org/wiki/CRUD_(acronym) Martin

Re: [sqlite] sqlite3_interrupt() and threads

2006-07-25 Thread Martin Jenkins
Rob Richardson wrote: [...] Can sqlite3_interrupt() be called from a different thread than the sqlite3_step() that I want to interrupt, or is there some other mechanism I can use, or is there no way to do this? This came up a couple of weeks ago. I don't have the message here to quote but

Re: [sqlite] Reading the same table from two threads

2006-07-26 Thread Martin Jenkins
Jay Sprenkle wrote: Why are two threads reading the same data? Last != previous? I read it as penultimate vs pre-penultimate data. Martin

Re: [sqlite] memory leak

2006-07-27 Thread Martin Jenkins
mycmos wrote: > When I use cat /proc/meminfo, I found the MemFree is > decreasing. Does that means some degree memory leak to > Sqlite2.8.17? No. ;) If you run "ps -ef" or "top" you'll see a list of all of the processes running on your machine. How could you associate changes in MemFree with

Re: [sqlite] Another question about RAM

2006-07-28 Thread Martin Jenkins
Sarah wrote: >> Because uc/os-II doesn't provide malloc(), free() to manage memory, >> instead, it divides the memory into fixed-length blocks and >> provides OSMemGet() and OSMemPut() to get and put fixed-length >> memory block. >> >> In order to port SQLite, I have to wrap uc/os-II with a set

Re: [sqlite] reading BLOB - Segmentation fault

2006-08-02 Thread Martin Jenkins
Kiril Dzolev wrote: You're calling blobGet(), but blobGet is an unitialised variable of type "CppSQLite3Binary" (whatever that is). Doesn't your compiler warn you about that? Martin > const unsigned char* putBLOBInBinary([...]) >{ >[...] >CppSQLite3Binary blobGet; > >[...] >

Re: [sqlite] memory leak

2006-08-02 Thread Martin Jenkins
Hi, I think you're going to have to be a bit more rigorous about what you're testing if you're hoping for a fix. In your root message you posted a bit of code and said you'd found a leak in v2.8.17 of the library. Then you said the leak was present in v2.8.17 and v3.3.6 (the valgrind of 'bash'

Re: [sqlite] RE: UNICODE Support

2006-08-04 Thread Martin Jenkins
Cory Nelson wrote: I recommend using utf-16 in the database - sqlite doesn't fully support utf-8, and some things may give unexpected results if you use it. Could you expand a bit on this please? I haven't seen any bugs as such with sqlite as such but I did have a few problems storing

Re: [sqlite] problem with application which uses sqlite

2006-08-24 Thread Martin Jenkins
renato71 wrote: I am tryin to install KTU (KDE Translations Updated) and it needs sqlite. I've tried to install on Mandriva free 2006, KDE 3.2. On first try to configure KTU I got message that sqlite3 is not found. As you suggest later in your message, this sounds like a bug in the KTU

Re: [sqlite] formatting the output on the command line?

2006-08-24 Thread Martin Jenkins
John Salerno wrote: Hi everyone. Is it possible to format the output of a query differently when using the command line program? I'm thinking along the lines of MySQL, which puts rows and columns in boxes, and has the column names at the top. It's very nice and easy to read. I find the default

Re: [sqlite] formatting the output on the command line?

2006-08-24 Thread Martin Jenkins
John Salerno wrote: Thanks! Boxes aren't necessary, but it's nice to have the columns like that. I'll have to look into these options more. .h is your friend. You can set the output format to HTML etc Martin [off for a pint]

Re: [sqlite] formatting the output on the command line?

2006-08-24 Thread Martin Jenkins
John Salerno wrote: Is there any special command I need to use to get these options listed? I didn't see the particular abbreviations that you told me about. You can abbreviate the commands - enter enough to be unambiguous. SQLite version 3.3.6 Enter ".help" for instructions sqlite> .h

Re: [sqlite] formatting the output on the command line?

2006-08-25 Thread Martin Jenkins
John Salerno wrote: Well, I figured out the sqlite commands, but how would I make these settings the default each time I use the sqlite command line program? (i.e. .he on and .mo col) If you're on Linux etc, put the commands in a file called .sqliterc in your home directory. If you're on

Re: [sqlite] problem with application which uses sqlite

2006-08-25 Thread Martin Jenkins
renato71 wrote: Martin Jenkins wrote: As you suggest later in your message, this sounds like a bug in the KTU config scripts, so you're probably not going to get much joy here. Well, I am trying to solve the problem from that angle as well. Sorry if that sounded harsh, I was trying

Re: [sqlite] "Invalid or corrupt file" when building .lib file for version 3.3.7 dll

2006-08-25 Thread Martin Jenkins
Rob Richardson wrote: lib /machine:i386 sqlite3.def sqlite3.def : fatal error LNK1136: invalid or corrupt file Try lib /DEF:sqlite3.def /MACHINE:IX86 Martin - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] Connect to SQLite Through C Program

2006-08-28 Thread Martin Jenkins
Tikky wrote: Hi , I am struggling to connect SQLite database through C program. I got some code from the SQLite.org, when ever i tried to compile that c code it showing error like " Unable to include sqlite.h file". Please refer me solution. This is an FAQ: sqlite.h and sqlite3.h are generated

Re: [sqlite] how to create database in sqlite prompt

2006-08-28 Thread Martin Jenkins
Tikky wrote: Hi, unable to create database in sqlite prompt. Can U provide any specific command. See http://www.sqlite.org/sqlite.html Martin - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] Why I can't connect CVS repository?

2006-08-28 Thread Martin Jenkins
[EMAIL PROTECTED] wrote: > Where else can I get the sqlite version 3.3.5(and the version should > support to be compiled under linux)? Can't help with your CVS problem, but you should find the source you want at this link - http://www.sqlite.org/sqlite-3.3.5.tar.gz Martin

Re: [sqlite] sqlite shared-cache mode usage

2006-08-29 Thread Martin Jenkins
Ritesh Kapoor wrote: Can you - DRH or someone else provide some more background information on why locking dosen't work on NFS mounted file systems. I just tried to find out what the locking problem was but couldn't find a web page discussing it in any detail. Lots of pages saying there *was*

Re: [sqlite] sqlite shared-cache mode usage

2006-08-29 Thread Martin Jenkins
Ritesh Kapoor wrote: Can you - DRH or someone else provide some more background information on why locking dosen't work on NFS mounted file systems. There's another (old) thread at http://lists.freebsd.org/pipermail/freebsd-questions/2004-March/039412.html This one refers to a testing tool -

Re: [sqlite] Re: two questions about formatting output

2006-08-29 Thread Martin Jenkins
John Salerno wrote: So why didn't it expand for Programmer II, but it does expand for AA? AIUI, the default column width is the greater of 10 and the width of the first line of output. sqlite> .mo co sqlite> .he on sqlite> create table t(t TEXT UNIQUE); sqlite> insert into t(t)

Re: [sqlite] count(gid) takes too long

2006-08-29 Thread Martin Jenkins
Sripathi Raj wrote: Main question: Using DBD-SQLite, select count(gid) from es_src_media_info takes 130 secs. What gives? Repeatably 0.3 seconds or less here with apsw and python2.4 on Windows XP on a dual Athlon1600 with ~4 year old disks. Same sort of times in the sqlite command line shell.

Re: [sqlite] format for column names

2006-08-30 Thread Martin Jenkins
ces from C:\Documents and Settings\Martin/.sqliterc SQLite version 3.3.6 Enter ".help" for instructions sqlite> CREATE TABLE People('Name First', 'Name Last'); sqlite> insert into People values("Martin","Jenkins"); sqlite> select * from People; Name Firs

Re: [sqlite] count(gid) takes too long

2006-08-30 Thread Martin Jenkins
Sripathi Raj wrote: This is on a NFS on Windows XP Xeon - 2.8 Ghz, 1 Gig RAM and the database size is 395 MB. I'm connecting to the database from Perl. There is no discernible difference b/w Perl and sqlite shell. NFS? Hmm... You have been following the locking threads, haven't you? ;) How

Re: [sqlite] Using Between in SQL

2006-08-30 Thread Martin Jenkins
Roger wrote: I have a question. I trying to write a query as follows Select * From People Where Surname Between 'A%' and 'E%' Order by UPPER(Surname); Now the problem i have is that i get only the Surnames from A up to D and the E's are excluded. Can anyone help me out, i am writing a web

Re: [sqlite] Using Between in SQL

2006-08-30 Thread Martin Jenkins
Roger wrote: Thanks for the response guys but then my problem comes when i try and query a range between T and Z i tried to make it query between T to A but got no result. Anyway i will have to add a constraint in my PHP code for T to Z. I saw that coming, but you didn't ask about that bit. ;)

Re: [sqlite] Using Between in SQL

2006-08-30 Thread Martin Jenkins
Arjen Markus wrote: Well, the character after 'Z' is 'a' in the ASCII table. You could try: BETWEEN 'Z' and 'a' Not quite. It's "XYZ[\]^_`abc". Martin - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] format for column names

2006-08-30 Thread Martin Jenkins
Nikki Locke wrote: Martin Jenkins wrote: Using [] is a Microsoft thing. More portable to use double quotes... Thanks, I didn't know that. I avoid spaces in column names so I haven't actually use it in anger. JOOI, were you on CIX? Martin

Re: [sqlite] problem with auto increment of ROWID

2006-08-30 Thread Martin Jenkins
Dixon Hutchinson wrote: But I need ROWID to auto increment until the largest 64-bit integer value is used You'll never get there - 2^64 is huge. 2^31 seconds is about 68 years so even if you're getting billions of inserts/sec you'll be dead before the rowid wraps. Martin

Re: [sqlite] format for column names

2006-08-30 Thread Martin Jenkins
Nikki Locke wrote: JOOI, were you on CIX? Still am. Thought the name was familiar. I don't get on much these days. :-/ Martin - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] How to edit Makefile.linux-gcc to define those SQLITE_OMIT_*?

2006-08-31 Thread Martin Jenkins
Sarah wrote: > And during make, I noticed that these new-added -DSQLITE_OMIT_XX did > not appeared in the command lines. Are you running the right makefile? By default makes runs "Makefile" or "makefile", so unless one of those two files includes your modified makefile or is linked to your

Re: [sqlite] SQLite Conference Tutorials

2006-08-31 Thread Martin Jenkins
[EMAIL PROTECTED] wrote: On Tuesday, October 10, there will be a full day of tutorials on SQLite covering all the latest features including: Sounds good - will there be a webcast or Google video for those of us unable to attend in person? Martin

Re: [sqlite] SQLite Conference Tutorials

2006-08-31 Thread Martin Jenkins
[EMAIL PROTECTED] wrote: > > In past years there has been audio-cast of the main conference, but > > not for the tutorials. I do not know what will be set up for this > > year. I'll talk to the organizers and let you know. Thanks. I enjoyed the Google talk, so I'm looking forward to hearing

Re: [sqlite] German umlauts (äöüß) are not displayed in sqlite - solution

2006-09-20 Thread Martin Jenkins
hin the sqlite CLI. I had to cheat slightly and paste them in as I don't have the relevant keys on my British keyboard but that shouldn't affect the actual DB. HTH Martin Jenkins - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Creating Database From File

2006-09-20 Thread Martin Jenkins
formance for a lot of data. To get round that start your own transaction. There's a csr.executemany(sql, dataset) variant which lets you insert lots of data and pretty much has to be surrounded by an explicit transaction. Note that the CLI requires a terminating semicolon but (as shown) Python's

Re: [sqlite] Creating Database From File

2006-09-20 Thread Martin Jenkins
Rich Shepard wrote: Further investigation reveals that the correct approach is to use indirection; specifically: [EMAIL PROTECTED] /data1/eikos]$ sqlite3 testing.db < feia.sql You don't *have* to use the CLI to create the database, you can do it from any language that has a binding for

Re: [sqlite] Wish to store a C structure in sqlite column

2006-09-22 Thread Martin Jenkins
Narendran wrote: > thanks a lot, > I am unable to resolve the problem for 3 days,hat's off to everyone. As far as I know, all technologies which transfer data between machines (e.g. RPC), languages (e.g. JNI) or wear the cross platform crown (e.g. SQLite) have some sort of data definition.

Re: [sqlite] Performance question

2006-09-22 Thread Martin Jenkins
Michael Wohlwend wrote: I made a database of little pictures, which includes x und y coordinates and Are x and y indexed? Martin - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] Bug in the precision of strftime function

2006-09-24 Thread Martin Jenkins
Slava Tutushkin wrote: I think, I found a bug in the strftime function. When I executed the next query: select strftime('%Y-%m-%d %H:%M:%f', julianday('2006-09-24T10:50:26.047')); it returned 2006-09-24 10:50:26.046 At the same time, I can clearly see, that julianday for that time for .046 and

Re: [sqlite] Bug in the precision of strftime function

2006-09-24 Thread Martin Jenkins
Martin Jenkins wrote: Looks like I'm getting more confused than I thought I was. :( According to http://www.hermetic.ch/cal_stud/jdn.htm a Julian Date can be a date in the Julian calendar *or* a Julian Day Number. Section 9 of that page states that "Julian day number 0 corresponds to -47

Re: [sqlite] List all views in my sqlite-database - possible?

2006-09-26 Thread Martin Jenkins
wqual wrote: Hi list, is there a way to list all views of my database? Something like the .tables-command for tables would be great. I would be glad for some hints on this issue! .schema Martin - To unsubscribe,

Re: [sqlite] SQLite under linux

2006-09-26 Thread Martin Jenkins
Lloyd wrote: After performing this section I got lots of errors. (I shall Add it at the end of mail) Either you're going to have to fix these errors BEFORE you proceed OR download the pre-built library from the site. But when I browsed through the output directory, I found the sqlite3.h

Re: [sqlite] SQLite under linux

2006-09-26 Thread Martin Jenkins
Clay Dowling wrote: What I strongly recommend doing, rather than trying to cobble together your own solution, is to download the source and go through the build and install -exactly- as decribed in the document. Good point, but I don't think he has (or wants) Tcl, so the build isn't going to

Re: [sqlite] SQLite under linux

2006-09-26 Thread Martin Jenkins
Clay Dowling wrote: I don't have tcl installed on my systems and I've never had a problem doing the default build. I do skip "make test" because I don't have tcl installed, and because I don't modify my copies of SQLite. Do you use Makefile.linux or go the ./configure route? Martin

Re: [sqlite] SQLite under linux

2006-09-26 Thread Martin Jenkins
Clay Dowling wrote: > > ./configure, especially since I build on more platforms than are supported > > by default. OpenBSD and FreeBSD are in my mix. Like you I always ./confgure and haven't had any problems. I just built the libs on Cygwin and noticed a couple of minor nits but nothing worth

Re: [sqlite] SQLite under linux

2006-09-26 Thread Martin Jenkins
Martin Jenkins wrote: noticed a couple of minor nits 1. configure wants g++ but ISTM the build doesn't actually use it 2. "make clean" (or was it distclean?) doesn't delete sqlite3.pc There was supposed to be a 3. 3. make distclean doesn't remove the installed files from usr/local

Re: [sqlite] table persistance (newbie)

2006-10-01 Thread Martin Jenkins
George Herson wrote: > Thanks for the info, Rich Shepard and Jan Kandziora. > > 3 documention-related suggestions about this: > > It seems to me that > http://www.sqlite.org/lang_createtable.html should > mention the ramifications of not passing in a database > name when using the sqlite3

Re: [sqlite] filename limit in sqlite_open

2006-10-04 Thread Martin Jenkins
Shields, Daniel wrote: Does anyone know the maximum length of the filename passed to sqlite_open. We seem to see truncation on long file names (> 32 chars?) It's platform dependent and you didn't say which platform, so ... it'll be about whatever MAX_PATH or similar is on your platform. ;)

Re: [sqlite] new sqlite-based webserver

2006-10-09 Thread Martin Jenkins
Fred Williams wrote: What'ch got it running on, a 286? Tried three different times and got tired waiting all three times :-( Seems ok now. Quite fast even. mj - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] new sqlite-based webserver

2006-10-10 Thread Martin Jenkins
John Stanton wrote: Martin Jenkins wrote: Seems ok now. Quite fast even. It is still dead. Address 62.194.135.186 doesn't respond. Traceroute fails. Odd. It's still working here (UK). DNSStuff reports a different address though (62.104.138.84) and a traceroute from there is fine (13 hops

Re: [sqlite] wxSqlite- Long Insertion time

2006-10-10 Thread Martin Jenkins
Lloyd wrote: Where could be the problem? The insert query is executing only 1000 times. Are these inserts in 1 transaction or 1000? If the latter then it will take a long time because sqlite has to wait 1000 times for the data to be written to the disk. It's generally accepted that this

Re: [sqlite] new sqlite-based webserver

2006-10-10 Thread Martin Jenkins
Dennis Cote wrote: It's a little slow, taking about 10 seconds to load, but not too bad. About 4-5 seconds here but the wires are shorter ;) Martin - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] Error in SQLite's CSV output

2006-10-17 Thread Martin Jenkins
T wrote: 1. Is this a known bug in SQLite's csv output? Will it be fixed? SQLite is a database library and the shell is just a handy tool that happens to come with it. ISTM that the developers (should) give bugs like this a pretty low priority. 2. Is there another way to reliably get the

Re: [sqlite] new sqlite-based webserver

2006-10-20 Thread Martin Jenkins
Günter Greschenz wrote: Hi, a new version is available (0.5.1.9) on "http://greschenz.dyndns.org/gas.html;. I'd just like to confirm that I can still see your site from the UK. ;) Martin - To unsubscribe, send

Re: [sqlite] problems reading a sqlite db

2006-10-21 Thread Martin Jenkins
[EMAIL PROTECTED] wrote: As far as i can tell everything on the system is the latest version of both pysqlite and sqlite. I'm not really 100% sure how i can verify that though. In a Python(win) session, issue the following. PythonWin 2.5 [...] >>> import sqlite3 >>> sqlite3.sqlite_version

Re: [sqlite] Re: Regarding sqlite3_exec

2006-10-25 Thread Martin Jenkins
Da Martian wrote: But to return all the rows just to count them requires N calls to step. If the data set is large you only want to return a subset to start with. So you wouldnt know the count. If you dont know the count, you cant update GUI type things etc.. I haven't been following this

Re: [sqlite] Re: Regarding sqlite3_exec

2006-10-25 Thread Martin Jenkins
Da Martian wrote: Yes but google doesnt us an RDMS, its all propriatary to support there speed and huge volumes. I know, but that was my point. If they can't/don't do it (with their custom kit) then surely it's non-trivial? Martin

Re: [sqlite] Error in SQLite's CSV output

2006-10-27 Thread Martin Jenkins
T wrote: I can use a slightly modified CSV parsing handler, by just using this as the row separator (instead of just plain linefeed): ");INSERT INTO VALUES(" Neat :) Martin - To unsubscribe, send email to [EMAIL

Re: [sqlite] Memory Usage

2006-10-30 Thread Martin Jenkins
Ben Clewett wrote: If you know a good URL on Linux virtual memory and allocation, I would be extremely interested. You could try: http://virtualthreads.blogspot.com/2006/02/understanding-memory-usage-on-linux.html The next two link to pages with links to a PDF of the "gorman" book

Re: [sqlite] SQLite and McAfee Anti-Virus

2006-10-31 Thread Martin Jenkins
[EMAIL PROTECTED] wrote: > > My efforts to contact Mcafee about this problem have > > been unfruitful. McAfee aren't playing fair. :( How about putting that explanation on a page on your site with a link to the support at McAfee so they can complain directly to the real culprits? I suppose

Re: [sqlite] SQLite and McAfee Anti-Virus

2006-10-31 Thread Martin Jenkins
[EMAIL PROTECTED] wrote: Now, I just have to figure out how to get Mcafee to upgrade to the latest version of SQLite and recompile I posted a summary to Slashdot, so hopefully it won't be too hard. I hope you're not offended but I was rather annoyed that a company which is using your

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

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

Re: [sqlite] transaction w/ large journal fails

2006-11-09 Thread Martin Jenkins
Preston Z wrote: I am running into a situation where on linux (fc5 and debian3) I have a transaction that is consistently failing using sqlite 3.3.7. The same transaction completes on windows every time. Some hardware information would probably help... Martin

Re: [sqlite] Syntax Error

2006-11-19 Thread Martin Jenkins
Hi Clara, Sometimes confusion arises because SQLite can refer to both a library which implements SQL and a shell which allows command line access to that library. There's a short tutorial on using the shell at http://www.sqlite.org/sqlite.html and several on SQLite's SQL syntax at

Re: [sqlite] strange.. two db files in sync ??!!

2006-11-23 Thread Martin Jenkins
James. L wrote: hello, i just notice something strange in sqlite. i have a db file which is a copy of another one(not a symlink). Seems very unlikely to be an SQLite (or a Debian) problem, it sounds like an inadvertent hard link. What does "ls -l restaurant*" (that's minus ell not not minus

Re: [sqlite] sqllite ddb from win to linux

2006-12-13 Thread Martin Jenkins
[EMAIL PROTECTED] wrote: Use "sqlite" to read an sqlite version 2 database. Use "sqlite3" to read a version 3 database. Just a thought, but would it be worth detecting attempts to open v2 databases with sqlite3 and printing "this database appears to be version 2 and I'm version 3 so I can't

Re: [sqlite] Check for empty table

2006-12-13 Thread Martin Jenkins
Scott Hess wrote: What's wrong with "SELECT COUNT(*) FROM table;"? It scans the whole table. This is OK if the table is small (nearly) empty, but if it has a couple of million rowZzzz Martin - To unsubscribe,

Re: [sqlite] Problem with sqlite3 on CGI scripts with ANSI C

2006-12-15 Thread Martin Jenkins
Francesco Andrisani wrote: if (sqlite_open("myDB.db", )); The semicolon at the end of this line means your error_handle() will always get called. Martin - To unsubscribe, send email to [EMAIL PROTECTED]

  1   2   3   >