Re: [sqlite] datetime as integer

On Mon, Mar 16, 2009 at 9:00 AM, MikeW wrote: > Timothy A. Sawyer writes: > >> >> I stand corrected on the math >> >> Bottom line is that different applications use different baseline values for > epoch (beginning of time) >> and you must know that baseline

Re: [sqlite] starting INTEGER PRIMARY KEY at 0

On Mon, Mar 16, 2009 at 8:59 AM, John Machin <sjmac...@lexicon.net> wrote: > On 17/03/2009 12:33 AM, P Kishor wrote: >> On Mon, Mar 16, 2009 at 8:31 AM, P Kishor <punk.k...@gmail.com> wrote: >>> is there a way to have a table start the INTEGER PRIMARY KEY sequence >

Re: [sqlite] starting INTEGER PRIMARY KEY at 0

On Mon, Mar 16, 2009 at 8:31 AM, P Kishor <punk.k...@gmail.com> wrote: > is there a way to have a table start the INTEGER PRIMARY KEY sequence > at 0 (or some other arbitrary number)? > > -- > Puneet Kishor > I should have added.. yes, I can do the following CREATE TABL

[sqlite] starting INTEGER PRIMARY KEY at 0

is there a way to have a table start the INTEGER PRIMARY KEY sequence at 0 (or some other arbitrary number)? -- Puneet Kishor ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] designing a db to hold repeating data

er data for all the cells lying within the box ?" Hence the R*Tree. > > Jim > > > On 3/15/09, P Kishor <punk.k...@gmail.com> wrote: >> I have a grid of 1000 x 1000 cells with their own data as well as 20 >> years of daily weather data (20 * 365 = 7300 rows) for each

[sqlite] designing a db to hold repeating data

I have a grid of 1000 x 1000 cells with their own data as well as 20 years of daily weather data (20 * 365 = 7300 rows) for each contiguous group of 50 x 50 cell. CREATE TABLE cells ( cell_id INTEGER PRIMARY KEY, other cell attributes, lat, lon, met_grid_id

Re: [sqlite] LEFT INNER JOIN a second database

On Sun, Mar 15, 2009 at 2:36 PM, Derek Developer wrote: > yes the example works as expected. This is the first step in debugging this > problem which could of course turn out to be my code. But since you were > baying for something to execute... I should also say that

Re: [sqlite] table metadata

On Sun, Mar 15, 2009 at 11:56 AM, P Kishor <punk.k...@gmail.com> wrote: > I am designing a database for carbon modeling. Many of the parameters > to be stored in the db have very long names... it is kinda > inconvenient to have column names such as > 'new_live_wood_Carbon_to_new

[sqlite] table metadata

I am designing a database for carbon modeling. Many of the parameters to be stored in the db have very long names... it is kinda inconvenient to have column names such as 'new_live_wood_Carbon_to_new_total_wood_Carbon', but I hate column names such as 'nlivwdc2ntotwdc'. I may as well just call

Re: [sqlite] Merging two SQLites + leaving out duplicates?

On Fri, Mar 13, 2009 at 9:14 AM, Gilles Ganault wrote: > On Fri, 13 Mar 2009 09:52:25 -0400, "Igor Tandetnik" > wrote: > (snip) > > Thank you Igor for the help. Before I give it a shot, I need to speciy > those requirements: > 1. The tables live in

Re: [sqlite] SELECT queries and NULL value parameters

On Wed, Mar 11, 2009 at 9:14 AM, Hynes, Tom wrote: >> ... yes, this is expected. > > Can you explain that a bit more?  I certainly would not have expected it.   > Thanks. sqlite> CREATE TABLE foo (a); sqlite> INSERT INTO foo VALUES (1); sqlite> INSERT INTO foo VALUES ('ab');

Re: [sqlite] LEFT INNER JOIN a second database

On Wed, Mar 11, 2009 at 8:12 AM, Derek Developer wrote: > I have read and searched but I am not able to get the following statement to > run: > SELECT MyID, Zip FROM TableOne d LEFT OUTER JOIN DatabseTwo.sdb.TableTwo n ON > n.MyID=d.MyID WHERE d.Zip > 8 ORDER BY

Re: [sqlite] Set read-only mode

On Sat, Mar 7, 2009 at 10:59 AM, Tom Spencer wrote: > Is there a way to set the current database handle as read-only?  I'm > connecting to an SQLite3 database (actually two including an attached > database) using Perl with DBD::SQLite, which doesn't seem to implement > the

Re: [sqlite] Wiki page on Management Tools - should it explicitely state Mac OS X support?

On Tue, Mar 3, 2009 at 3:53 PM, BareFeet wrote: > Hi, > >>> on the Wiki page listing SQLite Management Tools >>> >>> , there are columns for Web, Windows, Linux and Misc. as supported >>> platforms. Since Mac OS X is a

Re: [sqlite] Slow performance with Sum function

On Tue, Mar 3, 2009 at 6:36 PM, Greg Palmer wrote: > Trainor, Chris wrote: >> After running vacuum, sum is fast on the original table.  However, >> running vacuum took a long time, so I'm not sure if that is a feasible >> solution.  Is there any way to prevent

Re: [sqlite] Installing SQLite

On Tue, Mar 3, 2009 at 9:48 AM, Dan M. Wall wrote: > > I am an experienced Windows user and application developer.  I am now > attempting to actually use a Mac!!  God forbid!! Welcome to sanity. Don't worry, you will get used to it. > > I have an SQLite database and I'm

Re: [sqlite] Wiki page on Management Tools - should it explicitely state Mac OS X support?

On Tue, Mar 3, 2009 at 1:58 AM, Jens Miltner wrote: > Hi, > > on the Wiki page listing SQLite Management Tools >  >, there are columns for Web, Windows, Linux and Misc. as supported > platforms. Since Mac OS X is a

Re: [sqlite] Performance impact for heavy accessing the database file

On Mon, Mar 2, 2009 at 9:24 PM, Eversogood wrote: > Hi, > > How is the SQLite performance when a lot number of concurrent users access > the database file? > why? what have you experienced? Puneet. ___ sqlite-users mailing list

Re: [sqlite] Is this possible?

On Sun, Mar 1, 2009 at 4:43 PM, Mike Yenco <m...@yenco.com> wrote: > > On Mar 1, 2009, at 5:18 PM, P Kishor wrote: > >> It is going to get even more complicated and soon approach Igor-level >> of complexity. So, for sanity's sake, it would probably be done better >>

Re: [sqlite] Is this possible?

On Sun, Mar 1, 2009 at 4:04 PM, Mike Yenco wrote: > > On Mar 1, 2009, at 2:15 PM, Martin Engelschalk wrote: > >> Hi Mike, >> >> Yes, this is possible, however, it is complicated. > > Hi Martin, > > Thanks for the reply.  It usually is complicated :-) > > >> select Name, case

Re: [sqlite] Is this possible?

On Sun, Mar 1, 2009 at 11:14 AM, Mike Yenco wrote: > Ok, I guess this list doesn't support image attachments.  Let's see if > I can sort of illustrate what I'm looking to do in text without > requiring 1000 words. > > Table A > blank | Group 1 | Code 1 > blank | Group 2 | Code 2 >

Re: [sqlite] Best GUI?

On Thu, Feb 26, 2009 at 4:30 PM, Daniel Kasak wrote: > On Thu, 2009-02-26 at 15:44 -0600, Alan Cohen wrote: > >> None of these really provide the kind of data entry screens I'd like to >> have; I have not had time to try OOo Base yet. > > Well then. You'll be

Re: [sqlite] problem reading in SQL file with To_Date from Oracle

On Thu, Feb 26, 2009 at 3:37 PM, anjela patnaik wrote: > Hello all, > > I'm new to sqlite3. I have data in a Oracle table with one column being a > date type. Now, I've exported this table into a sql file with insert > statements. > > Then, I ran the .read command in

Re: [sqlite] manual with sample C programs

--- > J. R. Westmoreland > E-mail: j...@jrw.org > > > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of P Kishor > Sent: Thursday, February 26, 2009 1:58 PM > To: General Discussion of SQLi

Re: [sqlite] manual with sample C programs

On Thu, Feb 26, 2009 at 2:50 PM, J. R. Westmoreland wrote: > Where do I find the source to the command-line tool. I looked but didn't see > it. > Sorry if this should be obvious. :) download the source and search for it, or, you can browse the CVS tree. Here is the link to shell.c

Re: [sqlite] SQL error: no such function: replace

On Tue, Feb 24, 2009 at 8:13 PM, BenJones12345 wrote: > > Hi all > > I'm very much a beginner with sqlite3 and and I'm completely stumped with > using the replace function. > > What I have is a field (TheOldField) with values like: > > HM1 > HP4 > HM3 > HM2 > > and I

Re: [sqlite] Error on INSERT with SELECT Max(id) FROM ...

On Tue, Feb 24, 2009 at 6:12 PM, John Machin <sjmac...@lexicon.net> wrote: > On 25/02/2009 10:30 AM, P Kishor wrote: >> >> On Tue, Feb 24, 2009 at 5:19 PM, Leo Freitag <leofrei...@netcologne.de> >> wrote: >>> >>> Hallo, >>> >

Re: [sqlite] Error on INSERT with SELECT Max(id) FROM ...

On Tue, Feb 24, 2009 at 5:35 PM, John Machin wrote: > On 25/02/2009 10:19 AM, Leo Freitag wrote: >> Hallo, >> >> I'm trying to insert the highest value of tblName into tblZO. >> >> There fore I followed the hints in this article ... >>

Re: [sqlite] Error on INSERT with SELECT Max(id) FROM ...

On Tue, Feb 24, 2009 at 5:19 PM, Leo Freitag wrote: > > Hallo, > > I'm trying to insert the highest value of tblName into tblZO. > > There fore I followed the hints in this article ... >

Re: [sqlite] SQLite vs. Oracle (parallelized)

, and maybe it will become highly popular. We can only hope. > > > > On Tue, Feb 24, 2009 at 7:55 AM, P Kishor <punk.k...@gmail.com> wrote: >> On Tue, Feb 24, 2009 at 12:25 AM, Allan Edwards <wallanedwa...@gmail.com> >> wrote: >> .. >>> >>

Re: [sqlite] How to size and position a scrollbar within a virtual listview

On Tue, Feb 24, 2009 at 3:16 AM, Mail.sqlite wrote: > > Hi All, > I searched trough many messages and docs but did not find a solution to this > trivial looking problem. It would be really nice if someone could point me > into the right direction. > > my ToDo: > I have to

Re: [sqlite] SQLite vs. Oracle (parallelized)

On Tue, Feb 24, 2009 at 12:25 AM, Allan Edwards wrote: .. > > I have personally written a socket based server on top of the database > and it works very well.  So I have actually scaled the database myself > as I preached in this email.  Don't be a WIMP and map shares to

Re: [sqlite] Sqlite question: group by column with multiple tags?

On Tue, Feb 24, 2009 at 7:44 AM, Yuzem <naujnit...@gmail.com> wrote: > > > > P Kishor-3 wrote: >> Google for "normalizing a database" and then read up on it. It will help. >> > > Ok, thanks, thats the solution. Now there is another problem that arise.

Re: [sqlite] How to delete the rows which is the result of Select operation of another table?

On Tue, Feb 24, 2009 at 7:23 AM, Pramoda M. A wrote: > Dear All, > > > > I have to delete the rows of one table table but key is the result of > select operation of another table? > > > > Delete from table1 where ID = ( > > > Select ID from table2 where name like

Re: [sqlite] SQLite vs. Oracle (parallelized)

On Mon, Feb 23, 2009 at 9:34 PM, wrote: > Hi Billy, > >>> Are there any plans to enhance SQLite to support some of Oracle's >>> parallel processing or partitioning capabilities? > >> I realized that you're asking Richard, and not the peanut gallery, but >> I figured I might

Re: [sqlite] question on creating/populating table with varchar/clob data types

On Mon, Feb 23, 2009 at 8:01 PM, D. Richard Hipp <d...@hwaci.com> wrote: > > On Feb 23, 2009, at 3:54 PM, P Kishor wrote: > >> On Mon, Feb 23, 2009 at 2:46 PM, D. Richard Hipp <d...@hwaci.com> >> wrote: >>> >> .. >>> >>&

Re: [sqlite] UPDATE Field based on matching value in different Table

On Mon, Feb 23, 2009 at 5:34 PM, Greg Robertson wrote: > I have two tables each with two fields: > > TableA: Field1, Field2 > > TableB: Field3, Field4 > > > I would like to set Field2 in TableA to the value in Field4 in TableB > where TableA.Field3=TableB.Field4 > > Sounds

Re: [sqlite] question on creating/populating table with varchar/clob data types

On Mon, Feb 23, 2009 at 2:46 PM, D. Richard Hipp wrote: > .. > > SQLite is, in fact, a TCL extension that escaped into the wild. It is > specifically designed to integrate well with Tcl/Tk. > .. Did you ever tell that story anywhere? Would be fun to read it. -- Puneet Kishor

[sqlite] Xcode project for amalgamation

I am tinkering with (aka learning) Xcode 3.1.2, and am trying to set up an Xcode project for SQLite amalgamation. What could be simpler, no? My Xcode project is throwing errors. Could someone directly (offlist) email me their Xcode project file so I may learn from it? Many thanks, -- Puneet

Re: [sqlite] Windows XP: How Can I Get Higher CPU usage from SQLite

On Sun, Feb 22, 2009 at 2:14 PM, Fred Williams wrote: > Since the dawn of digital computers the CPU has been waiting on the I/O. > Want to go faster? Get a faster mass storage device. Then your CPU usage > will most likely jump all the way up to 9% - 14%! > > You can't

Re: [sqlite] Any concept of row number in SQLite?

On Thu, Feb 19, 2009 at 6:54 PM, His Nerdship wrote: > > Hi, > I am converting a program from Paradox (stop laughing, please) to SQLite. > Paradox has a useful feature where you can specify the actual index of a row > in the table. This is handy when the table is

Re: [sqlite] SQLite- Memory heap usage query

Didn't you ask this question 4 days ago, and it was answered? The only difference in your question this time around seems to be that you are asking for a way to reduce the db file size. You could utilize a compression library on your data... check the mail archives and also google for that

Re: [sqlite] How do I optimize a query in this situation?

On Fri, Feb 13, 2009 at 8:23 AM, He Shiming wrote: > Hi, > > I'm working on this project. It puts a lot of files into a single sqlite > database (including the actual file content, the program is designed to > store the actual content) for search. When a search command is

Re: [sqlite] using sqlite for searching

On Fri, Feb 13, 2009 at 4:36 AM, aalap shah wrote: > Hi, > > I am using sqlite3 for my search application and i want an optimized > way for retrieving values from table. I need a way in which I can > query records from the result of previous query based on next search >

Re: [sqlite] Single quote, newlines and UPDATES

On Wed, Feb 11, 2009 at 3:12 PM, jose isaias cabrera <cabr...@wrc.xerox.com> wrote: > > "P Kishor" wrote... > > >> On Wed, Feb 11, 2009 at 2:00 PM, jose isaias cabrera >> <cabr...@wrc.xerox.com> wrote: >>> >>> >>> &quo

Re: [sqlite] Single quote, newlines and UPDATES

On Wed, Feb 11, 2009 at 2:00 PM, jose isaias cabrera <cabr...@wrc.xerox.com> wrote: > > > "P Kishor" wrote... > > >> On Wed, Feb 11, 2009 at 1:48 PM, jose isaias cabrera >> <cabr...@wrc.xerox.com> wrote: >>> >>> Greetings and s

Re: [sqlite] Single quote, newlines and UPDATES

On Wed, Feb 11, 2009 at 1:48 PM, jose isaias cabrera wrote: > > Greetings and salutations... > > I am having a problem with an specific UPDATE. One of the functions of my > program is to capture all of the files in a directory so that one can search > on a file name and

Re: [sqlite] Index keywords

On Mon, Feb 9, 2009 at 9:44 AM, Vance E. Neff wrote: > Can I do the > > select last_insert_rowid(); > > to determine the new index value > After the COMMIT command? Yes, but I am not sure what you mean by the "new index value"... keep in mind, the last_insert_rowid()

[sqlite] TRIGGER to catch UPDATES without a WHERE clause

I had asked this a while back but I think my query got Warnocked. I would like to create a TRIGGER (or a CONSTRAINT) that throws an error if an UPDATE query is run *without* a WHERE clause. This would prevent accidentally mucking up the entire database, which, believe you me, I have done more

Re: [sqlite] basic problem...

On Thu, Feb 5, 2009 at 9:09 AM, vade wrote: > > Hello > > Thank you Mihai Limbasan. > For your clarification, Now I'm Preparing my Profile(cv or resume). I just > want to know where to show this sqlite3 skill. > whether in Programing skill section or database skill section or web

Re: [sqlite] drop table question ?

On Tue, Feb 3, 2009 at 10:36 AM, Brad Stiles wrote: >>> >> For my own edification, why the "order by 1" clause? >>> > >>> > To sort them in ascending order of table name, which might make >>> > old-fashioned capers like visual scrutiny a little easier. >>> >>> OK then,

Re: [sqlite] drop table question ?

On Tue, Feb 3, 2009 at 8:37 AM, Brad Stiles wrote: >>> For my own edification, why the "order by 1" clause? from the docs... http://www.sqlite.org/lang_select.html Each term of an ORDER BY expression is processed as follows: If the ORDER BY expression is a constant

Re: [sqlite] Question on the "like" item in "select"

On Mon, Feb 2, 2009 at 12:33 PM, J. R. Westmoreland wrote: > Please pardon me if this is really more SQL rather than sqlite behavior. > > > > If I have some thing like: > > SELECT . WHERE . LIKE "String" .; > > Is it going to work like: > > SELECT . WHERE . = "String" .; > > LIKE

Re: [sqlite] sqlite3_bind_int returns SQLITE_RANGE

Farzana, You can save a lot of email back-and-forth by showing your code in the first place. The very minimum information that you (that anyone) should provide when asking a code-related question is -- 1. db schema 2. code adding info about computer and operating system, plus any driver version

Re: [sqlite] How to set Username and password of SQLite Database

On Sat, Jan 31, 2009 at 3:01 AM, sumita wrote: > Hi > > I create a SQLite database and successfully connect with java but I want to > secure my database so give me suggestion how to set username and password > with my SQLite database. > > > cannot do so in the

Re: [sqlite] Foreign key support

On Fri, Jan 30, 2009 at 11:25 AM, Adam DeVita wrote: > Good day, > > If I write into the sqlite3 using the analyzer: > > create table mysns (SN int primary key, desc text); > insert into mysns (SN, desc) values (1,2); > create table t2 (mynum int, desc2 text, SN references

Re: [sqlite] help: need help in date conversion

On 1/29/09, venkat karri wrote: > Hi All, > > I have a database where date is stored in the integer format ( eg: > 1125426109) I want the output in mm/dd/ format. can any one tell me the > syntax to convert the date. http://www.sqlite.org/lang_datefunc.html You

Re: [sqlite] FTS of sqlite.org

On 1/29/09, Roger Binns <rog...@rogerbinns.com> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > > P Kishor wrote: > > Is it possible to implement a fulltext search of sqlite.org? I know I > > can use Google to search that site, but it would be ni

[sqlite] FTS of sqlite.org

Richard, (or whoever manages sqlite.org), Is it possible to implement a fulltext search of sqlite.org? I know I can use Google to search that site, but it would be nice to search the site itself using sqlite... -- Puneet Kishor ___ sqlite-users

Re: [sqlite] database encrypted

On 1/28/09, Joanne Pham wrote: > Hi all, > One of our database had problem to run the "schema". The error message below: > The question is how the database getting to this stats " Error: file is > encrypted or is not a database" > Thanks, > JP > > Below is the error

Re: [sqlite] help : sqlite database restore

person > > > who has taken this bak file is no longer with the company, so they asked > > me > > > to restore the .bak file and see the data, I dont know how its been > > created, > > > > > > > > > when u said you can directly open the

Re: [sqlite] help : sqlite database restore

On 1/27/09, venkat karri wrote: > Hi > > Iam new to sqlite, I have a database backup copy with extension > trac.db.1.bak. Now iam trying to setup sqlite 3.6.10 on my local machine and > need to import this bak file to my local database and has to view the data > in the

Re: [sqlite] Am I understanding Blobs correctly?

he same data quickly and efficiently. What you do with it is up to you. Perhaps you can store the "type of media" (or call it whatever you want to) as an attribute of the blob, and use that attribute to figure out what to do with the data once it is pulled out of the table. > >

Re: [sqlite] Am I understanding Blobs correctly?

On 1/26/09, Mike McGonagle wrote: > Hello all, > > I have never used Blobs before, and in reading some of the literature, > I am just a bit confused. From what I am understanding, I get the > impression that a Blob is no more than the binary data from a disk > file, stored

Re: [sqlite] problem with view

On 1/26/09, MEVEL Marie (PDL/ELOG PDL) wrote: > Hello. I use SQlite and i create a database since 3 week. I'm never > have problem but yesterday, i consult my database and one table doesn't > want to show it. When i want to see data to this table, the message is : >

Re: [sqlite] SQLite version 3.6.8

On Mon, Jan 12, 2009 at 10:41 PM, Jim Dodgen wrote: > I am having better luck with the amalgamation that has been created by > Audrey Tang. > My production is still on 3.4 and testing on 3.6 with the amalgamation has > been promising DBD::SQLite::Amalgamation is "nothing but a

Re: [sqlite] .dump and transactions

On Mon, Jan 12, 2009 at 4:30 AM, Thomas Jarosch wrote: > On Friday, 9. January 2009 10:34:32 Thomas Jarosch wrote: >> I run a small script every night via cron to backup a database >> using the ".dump" statement. SQlite version is 3.6.6.2 on Linux. >> >> Normally

Re: [sqlite] 600ms for simple query: How to optimize it?

On Sat, Jan 10, 2009 at 7:58 AM, Lukas Haase wrote: > D. Richard Hipp schrieb: >> On Jan 9, 2009, at 3:16 PM, Lukas Haase wrote: >>> SELECT t.topic, t.length >>> FROM printgroup AS pg1 >>> LEFT JOIN printgroup AS pg2 ON pg1.printgroup = pg2.printgroup >>> LEFT JOIN topics AS t

Re: [sqlite] SQLite with NAS storage

to a local drive before opening it. In any case, something tells me that you will get better mileage if you construct a good question for the list with enough background detail. > > > On Wed, Jan 7, 2009 at 1:31 PM, P Kishor <punk.k...@gmail.com> wrote: > > On 1/6/09, Edward J. Yoo

Re: [sqlite] SQLite with NAS storage

On 1/6/09, Edward J. Yoon wrote: > > Do you have 20 million sqlite databases? > > > Yes. Since all these databases are just files, you should stuff them into a Postgres database, then write an application that extracts the specific row from the pg database with 20 mil rows

Re: [sqlite] Parenthetical LIKE query ??

On 1/4/09, Ben Marchbanks wrote: > SELECT * FROM `pagesText` WHERE pageText LIKE ( "%muffler%" , "%clamp%" ) > > Is there a nice way to write a query using parenthetical LIKE ? afaik, there is no option for using LIKE in the manner of IN (as you are trying to do above). You

Re: [sqlite] using Mac osx to update sqlite

On 1/3/09, Mark Fraser wrote: > Jay, > > Thanks for your reply. > > > >It might make more sense to install a newer version in /usr/local > > rather than /usr. That way you can use the updated version for your > > > That is what I did. I downloaded and extracted the .bin

Re: [sqlite] fail to create table

On 12/28/08, Yuanhua wrote: > I use sqlite to create 6 tables and the second creation always fail. > for example, table names are tb1,tb2,tb3,tb4,tb5,tb6. > If I create table in the sequence tb1,tb2,tb3,tb4,tb5,tb6, creating > tb2 is in failure and other

Re: [sqlite] Trigger UPDATE based on a different row

On 12/20/08, jose isaias cabrera wrote: > > Greetings! > > Imagine these rows in a table named LSOpenJobs: > > id, PID,subject, bdate, edate, lang,job > 1, 232,2008-01-01,2008-01-10,es,trans > 2, 232,2008-01-01,2008-01-10,fr,trans > 3,

Re: [sqlite] confusing with how to to this in sqlite

On 12/20/08, Simon Davies wrote: > 2008/12/20 Rachmat Febfauza : > > > > > i have to change 'FOOD ' to 'FOOD', but the result is not that i hope. > > > > Rachmat: If what Simon says is correct (and I have no reason to doubt > > it) you

Re: [sqlite] Find out difference before and after update with cb

On 12/18/08, Daniel Schnell wrote: > Hi, > > is there a possibility to find out the difference before and after an > update of a table through the update callback ? > > I know that I can register a callback to a table for getting the rowid > of an SQLITE_UPDATE call. But

Re: [sqlite] Open the database - Creating the empty database

On 12/15/08, Joanne Pham wrote: > Hi All, > I have this problem about open the database. Here is the detail about the > problem. > > Our application have one process to create the database and another process > to open the database and creating the report. > The

Re: [sqlite] Wildcard searches, partial matches

On 12/15/08, aditya siram wrote: > Hi all, > I am trying to implement an autocompleter with a sqlite backend. Is there a > way to search the database using wildcards/regexps's without reading the > entire search space into memory? > > For example given the rows: >

Re: [sqlite] Adding data with periods

On 12/14/08, aditya siram wrote: > Thanks a lot. The issue has been fixed with: > INSERT INTO TEST_TABLE(CONTENTS) VALUES ("Hello. World!"); > Use single quotes to delimit text, not double quotes. ___ sqlite-users mailing list

Re: [sqlite] Adding data with periods

On 12/14/08, aditya siram wrote: > Hi all, > I'm having trouble adding data with period characters in it. I tries to > escape the period with a `'` but that didn' t seem to work. Here is an > example interaction: > > sqlite> create table test_table ("Contents"

Re: [sqlite] General index information

On 12/10/08, L B <[EMAIL PROTECTED]> wrote: > Hi all, > > I would like to know if there is any difference > between using 3 indexes on three different fields or > just an index which groups them, in terms of physical > size and performance. > I have seen that sqlite cannot use more than one

Re: [sqlite] data dump in sqlite

On 12/9/08, Manisha De Silva <[EMAIL PROTECTED]> wrote: > I tried this line of code to do a data dump but it doesn't seem to work > > > sqlite> .dump sqlite3 c:\spool\jsm.db gzip -c > jsm.dump.gz > BEGIN TRANSACTION; > COMMIT; > sqlite> > > You seriously need to read the docs and the help

Re: [sqlite] data dump in sqlite

On 12/9/08, Manisha De Silva <[EMAIL PROTECTED]> wrote: > I downloaded sqlite3.exe > > I typed in .databases and it doesn't show any database. Actually I have > sqlite db in C:\Program Files\Jabber Inc\Jabber XCP\var\spool and I want this > to dump the data to a text file. > > I typed in

Re: [sqlite] What is a Group By, having clause?

On 12/9/08, Christophe Leske <[EMAIL PROTECTED]> wrote: > Hi, > > can someone point me to some docs where the difference between a normal > "where"-clause and the "Group by", and "having" statements are being > explained? > Think of HAVING as being analogous to WHERE. While WHERE applies to

Re: [sqlite] data dump in sqlite

On Tue, Dec 9, 2008 at 8:59 AM, Manisha De Silva <[EMAIL PROTECTED]> wrote: > I want to do a data dump to a text file, how is it possible to do this in > SQLite? Look at the appropriately named .dump command in the sqlite3 shell. By the way, do you realize that you have a 20 word message

Re: [sqlite] newie question

On 12/8/08, Oscar Alejandro Alvarado Prieto <[EMAIL PROTECTED]> wrote: > how can I retrieve the result of a "SELECT COUNT(*) FROM atable" statemen? > thanks > > Hi Oscar, As MikeW mentioned, please use a subject line more descriptive than "newie question." Additionally, please pose a better

Re: [sqlite] easy question: using fully qualified table name

On 12/4/08, Julian Bui <[EMAIL PROTECTED]> wrote: > Hi all, > > I can't seem to use fully qualified table names (dbName.tableName). > > For instance, I create a database file inventory.db, and create a table > food. "SELECT * FROM inventory.food" does not work, nor does "SELECT * FROM >

Re: [sqlite] Struggling with datetime("now") > MAX(dtEndDate) query - Please Help

On 12/4/08, Brad Stiles <[EMAIL PROTECTED]> wrote: > > SELECT * > > FROM MyTableWithDates > > WHERE datetime("now") > MAX(dtEndDate) > > > What is it that you are actually trying to do with this query? As > formulated (even if it were syntactically correct, which I don't think > it is), you

Re: [sqlite] rtree insert performance

On 12/3/08, Oyvind Idland <[EMAIL PROTECTED]> wrote: > Hi, > > I am fiddling around with the r-tree module a bit, which works great and > gives the effect I am looking for. > > The only thing is that I wish I could speed up inserts. Populating the > rtree-index with 1 million objects > takes

Re: [sqlite] How rebuild with larger page size from command line?

On 12/2/08, Jerry Krinock <[EMAIL PROTECTED]> wrote: > > On 2008 Dec, 02, at 19:44, Thomas Briggs wrote: > > > Put both commands (the pragma and the read) into a file (e.g. > > foo.txt) and then do: > > > > sqlite3 newDatabase.sqlite '.read foo.txt' > > > Looked like a great idea, Thomas

Re: [sqlite] SQL example using date()

On 12/2/08, Greg Robertson <[EMAIL PROTECTED]> wrote: > I would like to do a date search to find records that are between two > dates. The dates are stored in the table in the format DD-MM- but > I can change that to another format but I prefer something readable > rather than an int or

Re: [sqlite] Implicit Indices on Subqueries used as "lookups" or joins ....???

On 12/2/08, Da Martian <[EMAIL PROTECTED]> wrote: > Hi > > I have continious issues with subquery performance when subqueries are used > for joins. It crops up all the time my daily work. > > If you create a derived table using a subquery and use it in a join SQLite > performance is abysmal.

Re: [sqlite] Select Limit issues

This kind of problem, in my opinion, is more suited for the application rather than SQL. Even if you get this to work, there are several issues... what happens if your dataset changes? what happens if there are not enough Whites or Blues before or after the first Red? What happens if a White or

Re: [sqlite] Select Limit issues

On 11/29/08, Webmaster <[EMAIL PROTECTED]> wrote: > I have never posed in a group before forgive me if I am out of line with my > question. > > I have a table called table1 > With three fields: Field1, Field2, Field3 > > Here is my query but I get errors. > Any help work be great Please

Re: [sqlite] Elementary arithmetic question

On 11/28/08, tom_slee <[EMAIL PROTECTED]> wrote: > > I used the Numerical python package and its types don't always behave well > with other python variables - I had to insert into sqlite by piecing > togethera literal SQL statement rather than binding the variables. So no > doubt you are

Re: [sqlite] Violating Primary key Constraint

On 11/24/08, Satish <[EMAIL PROTECTED]> wrote: > Hi All! > > > > I have created a table in sqlite.Upto my knowledge a column which is > declared as primary key will not accept null and even if I don't give any > value to that field an error occurs that violating the constraint > > For Example

Re: [sqlite] Return first row of database

On 11/24/08, Rick Pritchett <[EMAIL PROTECTED]> wrote: > I am trying to set my variable to the first row of my database how do you do that? > then delete the > row. Does any one have a good example? > What is your definition of the "first row" of your database. First, you obviously mean the

Re: [sqlite] Another set of questions

On 11/19/08, Christophe Leske <[EMAIL PROTECTED]> wrote: > > > > Why don't you just do a > > > > DELETE FROM table; > > > > and start inserting new results? (end result is the same as dropping > > and then recreating the table, but you wouldn't know). > > > > > I am worried about creeping memory

Re: [sqlite] Dropping and creating indexes

On Wed, 19 Nov 2008 06:59 + (GMT Standard Time), Hugh Gibson <[EMAIL PROTECTED]> wrote: > > An index is actually indeed associated with a table, and within that > > table with one or more columns. > > > > Hence, dropping an index doesn't require a table name. > > > I can easily write SQL

Re: [sqlite] Another set of questions

On 11/19/08, Christophe Leske <[EMAIL PROTECTED]> wrote: > > > I don't know. Have you run an experiment to see for yourself? > > > > Yes, but my results are inconclusive. would you like to share your results? If you timed two tasks, comparing their timing would be inconclusive *only* if there

<    1   2   3   4   5   6   7   8   9   10   >