Re: [sqlite] PRAGMA cache_size = 0

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 of

Re: [sqlite] Custom Aggregation Not Working

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 ad

Re: [sqlite] Cache invalidation after insert statements.

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

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] SQL Quick Review/Reference

Mike Owens wrote: > I've been lobbying Apress to release the book in electronic form for > free. It's currently under consideration, but I've not heard anything > back yet. > That seems a bit extreme - how about a user generated/funded index on the web somewhere? Download and print a PDF, stick

Re: [sqlite] SQL Quick Review/Reference

Mike Owens wrote: >> Mike Owens wrote: >> > I've been lobbying Apress to release the book in electronic form for >> > free. >> That seems a bit extreme > I wasn't referring to releasing the book as an exclusive solution to > the index problem, but rather for the community and SQLite in general

Re: [sqlite] SQL Quick Review/Reference

metro wrote: > is this what everybody is looking for?? > http://booksforpeople.blogspot.com/2008/03/definitive-guide-to-sqlite-free-book.html > there are other sources for free ebooks > > Laurie > It did the rounds on alt.binaries.e-book.technical last year. The buyer's email address had been

Re: [sqlite] last modified time or version of sqlite database

Near the bottom of http://sqlite.org/pragma.html you'll find: "PRAGMA [database.]user_version; PRAGMA [database.]user_version = integer ; The pragmas [...] user_version are used to set or get the [...] user-version, [which is a] 32-bit signed integers stored in the database header. [...] The us

Re: [sqlite] last modified time or version of sqlite database

Ignore this bit - cut and paste error con=apsw.Connection("aaa") con=apsw.Connection("temp") Martin

Re: [sqlite] Strange Behaviour on Solaris 8 on Sparc

Are those directories on the same disk/partition? What do the results look like if you replace "| sqlite" with "> /dev/null"? I'm not 100% sure that you're timing the sqlite part here. I think you're timing the cat, hence my earlier comments. Try "time sqlite < /export/home/ykphuah/test.sql" (un

Re: [sqlite] Unique ids over several databases or auto_increment primary or id range.

The auto increment just adds 1 to the highest value in the id column, so you if you create a table with create table db(id INTEGER PRIMARY KEY, value TEXT) your sequence of inserts will result in 1, 'first' 2, 'second' 500, 'third' 501, 'fourth' Martin - Original Message - From:

Re: [sqlite] how to recover a corrupted database?

Memtest86 is rather old now. Memtest86+ is an updated version (supports newer CPU/chipset features) and can be found at http://www.memtest.org/ HTH Martin - Original Message - From: "Jay Sprenkle" <[EMAIL PROTECTED]> To: Sent: Thursday, June 08, 2006 9:01 PM Subject: Re: [sqlite] ho

Re: [sqlite] SQLite performance for 10 Million Records

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 ba

Re: [sqlite] SQLite performance for 10 Million Records

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

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 the

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

. 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

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

Nuno Lucas wrote: Please don't feed the troll... ;)

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

Apologies to the rest of the list, but I've had one of those days. ;) mj

Re: [sqlite] SQLite String

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

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 Mar

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

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?

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?

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] How do you find out the names of the fields within a table?

John Newby wrote: Hi all, I would like to thank you all for helping me with my problems. I have managed to obtain the details from the SQLite DBMS that I required. Well done. :) Martin

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

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 Cr

Re: [sqlite] Re: Memory exhaust

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 tim

Re: [sqlite] Major projects using SQLite

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!

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

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 shell

Re: [sqlite] locked implies exception?

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

Re: [sqlite] locked implies exception?

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

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 you

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

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

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 any

Re: [sqlite] Another question about RAM

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 of

Re: [sqlite] reading BLOB - Segmentation fault

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] reading BLOB - Segmentation fault

Ignore that, I wasn't thinking C++ :( Does the CppSQLite demo work on your machine? Martin 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 unsign

Re: [sqlite] memory leak

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' p

Re: [sqlite] RE: UNICODE Support

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

Re: [sqlite] SQLite and Java

Umesh Nayak wrote: Dear all, Does SQLite work with Java? http://www.google.co.uk/search?hl=en&q=java+sqlite&btnG=Google+Search&meta= Martin ;)

Re: [sqlite] problem with application which uses sqlite

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 config

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

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 fo

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

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?

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

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

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 Win

Re: [sqlite] problem with application which uses sqlite

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 tryi

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

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

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

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?

[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

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

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

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) values("

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

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

are reserved words. C:\>sqlite3 tom Loading resources 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("Mart

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

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 lo

Re: [sqlite] Using Between in SQL

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 b

Re: [sqlite] Using Between in SQL

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

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

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 CI

Re: [sqlite] problem with auto increment of ROWID

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

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_*?

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 modifi

Re: [sqlite] SQLite Conference Tutorials

[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

[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 th

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

m from within 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

ion, pysqlite put all those inserts in individual transactions, which will kills performance 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 explici

Re: [sqlite] Creating Database From File

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 SQLit

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

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

Re: [sqlite] Performance question

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

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

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 t

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

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, sen

Re: [sqlite] SQLite under linux

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 fil

Re: [sqlite] SQLite under linux

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 w

Re: [sqlite] SQLite under linux

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

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

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

Re: [sqlite] table persistance (newbie)

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 executab

Re: [sqlite] filename limit in sqlite_open

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. ;) Ass

Re: [sqlite] new sqlite-based webserver

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

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 fin

Re: [sqlite] wxSqlite- Long Insertion time

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 takes

Re: [sqlite] new sqlite-based webserver

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

T&B 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

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 emai

Re: [sqlite] problems reading a sqlite db

[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 '3.3

Re: [sqlite] Re: Regarding sqlite3_exec

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 thre

Re: [sqlite] Re: Regarding sqlite3_exec

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

T&B 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 P

Re: [sqlite] Memory Usage

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

Re: [sqlite] SQLite and McAfee Anti-Virus

[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 thi

Re: [sqlite] SQLite and McAfee Anti-Virus

[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 lib

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

[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 PROTECTED

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

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 spl

Re: [sqlite] transaction w/ large journal fails

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

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 http://www.

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

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

[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 op

<    1   2   3   >