Re: [sqlite] Using SQLite for GIS Application

On Sun, Aug 23, 2009 at 01:08, Itzchak Raiskin wrote: > Hi > I want to use SQLite in a GIS application where I create a database > containing terrain data (coordinates, height). > I would like to query this database with start and end points of a line and > get a vector

Re: [sqlite] Reading pragma's results

On Mon, May 25, 2009 at 1:10 PM, João Eiras wrote: > Btw, the same happens with the command line sqlite program > > $ sqlite > SQLite version 2.8.17 These pragmas didn't exist six years ago when 2.8.17 was current. The only pragmas in that version are: default_cache_size

Re: [sqlite] [newbie] How to upgrade sqlite3 in Ubuntu?

On Sun, May 3, 2009 at 12:32 PM, scientist scientist < scientist92...@yahoo.com> wrote: > Thank you for your fast answer, but my problem still exists after I > followed your instructions. > > Firstly I removed the default sqlite3 using sudo apt-get remove sqlite3 > command. > After that I moved

Re: [sqlite] [newbie] How to upgrade sqlite3 in Ubuntu?

On Sun, May 3, 2009 at 11:37 AM, scientist scientist < scientist92...@yahoo.com> wrote: > Hi all, > My current Ubuntu version is 8.04 and it has sqlite3 3.4.2 by default. Now > I want to upgrade sqlite3 to its newest version. > I've already downloaded sqlite-amalgamation-3.6.13.tar.gz,

Re: [sqlite] DateTime Objects

On Sat, Feb 28, 2009 at 1:47 PM, jonwood wrote: > > Greetings, > > I have a SQLite table that contains a DATETIME value. However, the database > does not appear to provide enough control over how that value is formatted. > For example, I'd like a two-digit year, to

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

On Thu, Feb 19, 2009 at 10:45 PM, His Nerdship wrote: > > Thank you Thomas, that was most helpful. > I have just found the ROWID information > (http://sqlite.org/lang_createtable.html#rowid) - this is what I was > looking > for! You have to know something exists

Re: [sqlite] Single quote, newlines and UPDATES

> > > and I did an SQL command dump of the string that I am passing to the D > SQLite wrapper and it is escaped. I am reclining on the idea that it is > the > D wrapper. I have to go to post this on the D wrapper newsgroup. > My understanding is that you can call C library functions from D. You

Re: [sqlite] Transaction?

On Wed, Dec 31, 2008 at 11:36 AM, John Hawley wrote: > the following block of code executes 2 or 3 orders of magnitude slower > than 1 think it should ( the db was opened in earlier code) > Yup, you're committing each insert to disk (a VERY slow process) rather than

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

On Mon, Dec 15, 2008 at 1:43 PM, P Kishor wrote: > 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

Re: [sqlite] About select by "=" condition to a string

On Fri, Oct 31, 2008 at 9:06 AM, yoky <[EMAIL PROTECTED]> wrote: > Hi all, >I create a table like this "create table tbl1 (ID integer primary > key, name, addr)" , >then insert a record: > "insert into tbl1 values(1, 'aa', 'bb')", > select the record: >

Re: [sqlite] Help Using RowID

On Sat, Sep 6, 2008 at 10:44 AM, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > > As a bonus, if the implementation of SQLite changes, SQL itself won't, > > so id will _still_ be a valid integer primary key, even if the > > implementation detail of rowid changes. > > I promise that INTEGER PRIMARY

Re: [sqlite] Default Column Value to Local Time

On Mon, Sep 1, 2008 at 10:29 PM, Derrell Lipman < [EMAIL PROTECTED]> wrote: > > > On Mon, Sep 1, 2008 at 10:16 PM, jonwood <[EMAIL PROTECTED]> wrote: > >> >> Okay, I give up. I've been searching for a while now. I've found a number >> of >> dis

Re: [sqlite] Default Column Value to Local Time

On Mon, Sep 1, 2008 at 10:16 PM, jonwood <[EMAIL PROTECTED]> wrote: > > Okay, I give up. I've been searching for a while now. I've found a number > of > discussions about how CURRENT_DATE returns the date in UTC, and that it can > be converted to local time. But I've yet to find one article that

Re: [sqlite] Clone SQLite databases

On Tue, Aug 5, 2008 at 10:31 AM, csabi81 <[EMAIL PROTECTED]> wrote: > > I have made the test with following results: > Useing "SELECT ALL * FROM WHERE... order by id;" on the > original > database and > "SELECT ALL * FROM order by id;" on the cloned database give me > the same results. >

Re: [sqlite] Corrupted database repairing

On Fri, Jul 25, 2008 at 5:23 AM, Alexey Pechnikov <[EMAIL PROTECTED]> wrote: > > > Database servers such as Oracle or PostgreSQL have transactions log and > > > restore log. > > > > Those logs are effectively duplicates of the data or ways of > > reconstructing the data. SQLite has a transaction

Re: [sqlite] What is quicker?

On Wed, Jun 4, 2008 at 10:01 AM, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > > Let me strongly reiterate that you look into using the new R-Tree > virtual table available for SQLite. R-Trees are specifically designed > to do exactly the kind of query you are asking to do. See > >

Re: [sqlite] Proposed incompatible changes to the SQLite VFS layer

On Fri, May 2, 2008 at 11:56 AM, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > However, as we have gained experience with the VFS, we have come to > realize that the original VFS design has some warts. In particular, > not all of the methods in the VFS interface are able to return the > errors

Re: [sqlite] selecting uncommited rows

On Thu, Apr 17, 2008 at 3:15 PM, Alex Katebi <[EMAIL PROTECTED]> wrote: > I will give a simple example: > > create table t1(name); > insert into t1('Alex'); > begin; > insert into t1 values ('Dennis'); > select * from t1; > > The above will show two rows. How can I see only the 'Dennis' row in

Re: [sqlite] sqlite with emacs (OT)

On Wed, Apr 2, 2008 at 10:30 AM, Wensui Liu <[EMAIL PROTECTED]> wrote: > good morning, all, > when i tried to use sqlite in emacs with shell mode, it doesn't work. > is there a interface for sqlite in emacs / xemacs? > I use sqlite in emacs shell mode all the time. What problem are you

Re: [sqlite] Clear screen in command line interface

On Wed, Mar 26, 2008 at 4:14 PM, Fred J. Stephens <[EMAIL PROTECTED]> wrote: > Mike McGonagle wrote: > > Hum, on the Mac (10.4.9), the terminal window can be cleared from within > the > > terminal program itself. I would imagine that other terminal programs also > > provide this. Does this

Re: [sqlite] SELECTing calls < last two weeks?

On Tue, Mar 25, 2008 at 11:02 AM, Gilles Ganault <[EMAIL PROTECTED]> wrote: > Hello > > In MySQL, I used the following to only get calls received in the last > two weeks: > > WHERE calls_date > DATE_SUB(CURRENT_DATE, INTERVAL 15 DAY) > > Is there an equivalent in SQLite, or should I

Re: [sqlite] algorithm for adding columns to a table

ou did. Thanks! Derrell > > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Derrell Lipman > Sent: terça-feira, 18 de março de 2008 11:26 > To: General Discussion of SQLite Database > Subject: [sqlite] algorithm

[sqlite] algorithm for adding columns to a table

I could use another set of eyes or three to verify that this algorithm makes sense. I have legacy sqlite2 databases for which I need a generic function to add columns to tables. This is the pseudocode for the function. Am I missing anything? In this pseudocode, the parameters are:

Re: [sqlite] How long time to index this table

On Thu, Feb 28, 2008 at 11:48 AM, Lars Aronsson <[EMAIL PROTECTED]> wrote: > Gilles Ganault wrote: > > > But then, how many people use SQLite to handle 68 milions rows > > in a table? I've got 60 million in one table, and this is with an sqlite2 database. Works just fine, BTW. Derrell

Re: [sqlite] undefined symbol: sqlite3_prepare_v2

On Wed, Feb 27, 2008 at 6:23 PM, Joanne Pham <[EMAIL PROTECTED]> wrote: > Hi all, > Thx for the response! > On different Linux server. So how to find out what is the SQLite version on > the server which has the problem. > How to find out the sqlite version using Linux commnad. Doing it with a

Re: [sqlite] undefined symbol: sqlite3_prepare_v2

On Wed, Feb 27, 2008 at 12:34 PM, Joanne Pham <[EMAIL PROTECTED]> wrote: > Hi All, > I used the sqlite3_prepare_v2 in my code and some of the servers are ok > but one of my server return an error message that "undefined symbol: > sqlite3_prepare_v2 " when the process is started and access the

Re: [sqlite] Two commands at once

On Feb 16, 2008 12:01 PM, Fred J. Stephens <[EMAIL PROTECTED]> wrote: > How can I issue 2 commands to SQLite at the same time in a shell script? > I want to temporarily change the separator for the returned data, > something like: > sqlite3 database.db ".separator " ", SELECT first,last FROM

Re: [sqlite] default values at CREATE TABLE

"Frank Pool" <[EMAIL PROTECTED]> writes: > I want to create a table with two colums: > > One ist the primary key (test_num) > and the second column sholud contain the value of the primary key (maybe as > a string) by default. > How can I define this table in sql ? > > CREATE TABLE test_table

Re: [sqlite] Problem with SQLite Pecl extension for PHP4

Brandon Eley <[EMAIL PROTECTED]> writes: > No, I can't upgrade to PHP5, yet. We're on PHP4. I was accessing sqlite 2.8.x databases with PHP4 a number of years ago. It worked fine. The page I referred you to previously _initially_ discusses the object interface for the sqlite functions. That,

Re: [sqlite] Problem with SQLite Pecl extension for PHP4

Brandon Eley <[EMAIL PROTECTED]> writes: > Thank you for this information. How would I access the 2.8.x database from > within PHP? is it even possible? Go to http://www.php.net. Type "sqlite" into the search box at the top. The page it brings you to describes the sqlite 2.8.x interface. The

Re: [sqlite] Getting a list of items on a column

"jose isaias cabrera" <[EMAIL PROTECTED]> writes: > "C.Peachment" wrote, > > >> On Sat, 5 May 2007 19:58:19 -0400, jose isaias cabrera wrote: >> >> >>>Greetings! >> >>>imagine this data content, >> >>>c1, c2, c3 >>>a, 1, 2 >>>b, 3, 4 >>>c, 5, 6 >>>a, 9, 8 >>>a, 1, 9 >>>c, 1, 3 >> >>> I would like

Re: [sqlite] Index creation on huge table will never finish.

Chris Jones <[EMAIL PROTECTED]> writes: > Derrell.Lipman wrote: >> >> Chris Jones <[EMAIL PROTECTED]> writes: >> >> I don't think that your original solution solves that problem either. You >> first posted this schema: >> >>> My schema looks as follows: >>> >>> CREATE TABLE rawfen ( fen

Re: [sqlite] Index creation on huge table will never finish.

Chris Jones <[EMAIL PROTECTED]> writes: > I don't think that solves my problem. Sure, it guarantees that the IDs are > unique, but not the strings. > > My whole goal is to be able to create a unique identifier for each string, > in such a way that I dont have the same string listed twice, with

Re: [sqlite] SQLite 2 to SQLite 3 - Varchar sizes

"Mitchell Vincent" <[EMAIL PROTECTED]> writes: > I have an old SQLite 2.8 database that shared it's schema with > PostgreSQL. One of the nifty things about PostgreSQL (that admittedly > has me spoiled) is the ability to just say "varchar" without any > length specifier. > > Specifying "varchar"

Re: [sqlite] Backing up a SQlite database

Rich Shepard <[EMAIL PROTECTED]> writes: > On Fri, 9 Feb 2007, Mikey C wrote: > >> This might be a dumb question, but is taking a backup of a live database >> simply a matter of copying the file to a backup device/drive? > > Yes. It's a regular file to your OS. As a matter of fact, you can copy

Re: [sqlite] How to specify collating sequences in an expression.

[EMAIL PROTECTED] writes: > (4) What syntax do you prefer? This seems the clearest to me, of the given choices: SELECT * FROM t1 WHERE CAST(x AS TEXT COLLATE NOCASE)='HELLO'; Derrell - To unsubscribe, send

Re: [sqlite] does select reliably return insert order?

"Kevin Dangoor" <[EMAIL PROTECTED]> writes: > I'm using sqlite as a temporary store for flattened report database > (generally just one table). This data is pulled out in chunks using > OFFSET and LIMIT. This particular setup is quite simple... just insert > all of the data, and then pull it out

Re: [sqlite] pragma for headers ( pipe or redirect a series of commands)

Bill Hernandez <[EMAIL PROTECTED]> writes: > I tried finding a pragma command for .headers on, but didn't have any luck. > > sqlite> .headers on | .mode column customers | select * from customers ; > I also tried : > > sqlite> select * from customers ; < .headers off > > and that didn't work

Re: [sqlite] attach in transaction

[EMAIL PROTECTED] writes: > The prohibition against running ATTACH within transaction > first appeared in version 3.0.1. Presumably in version 3.0.0 > you could ATTACH within a transaction. The prohibition may have appeared in 3.x but attempting an ATTACH within a transaction doesn't work with

Re: [sqlite] What's the collective term for table, view, trigger etc?

T <[EMAIL PROTECTED]> writes: > Is there a standard (or even non-standard) term that refers to the tables, > triggers, views, indexes (any others?) in a database? The collective term for all of the definitions taken together is the "schema" of the database. Derrell

Re: [sqlite] Is sqlite the right db for me?

"Steve Davis" <[EMAIL PROTECTED]> writes: > It is not a web-based app, rather browser based. Many brigades do not have > net access at their stations, they might only have someone there once a > fortnight, so it isn't viable. Also this app might also be used on a > notebook at a remote

Re: [sqlite] Check for empty table

"Scott Hess" <[EMAIL PROTECTED]> writes: > On 12/13/06, RB Smissaert <[EMAIL PROTECTED]> wrote: >> Trying to find the fastest way to determine if a table has no rows. >> >> I think this will do: >> SELECT (SELECT ROWID FROM table limit 1) IS NOT NULL; >> If a table has rows then the result should

Re: [sqlite] select from commandprompt with output to file

"RB Smissaert" <[EMAIL PROTECTED]> writes: > How would I run these 4 commands via a .bat file or via whatever means: > > cd c:\test\ReadCodes > c:\test\Program\sqlite3 c:\test\ReadCodes\ReadCode.db" > .output testfile.txt > select * from readcode where read_code glob 'G2*'; I haven't been

Re: [sqlite] Retrieving date

Lloyd <[EMAIL PROTECTED]> writes: > Hi, > I stored a unix epoch (32 bit integer) date in the sqlite data base. I > want to retrieve it in the readable date format. For that I use the > following query > > select datetime(sdate,'unixepoch') from mytab; > > It shows a formatted date, but there is

Re: [sqlite] Q about new SQLite API

[EMAIL PROTECTED] writes: > QUESTION 1: sqlite3_prepare_v2 is the merely the working name > for the new function. What should the official name be? > Some possibilities include: > > sqlite3_prepare_ex1 > sqlite3_prepare_ng > sqlite3_new_prepare > sqlite3_compile sqlite3_compile

Re: [sqlite] command-line shell handling of errors.

[EMAIL PROTECTED] writes: > So the question: Who will be adversely effected by the new > error behavior in the sqlite command-line shell? Who is > using the sqlite command-line shell in scripts in such a > way that the script will no longer work with the new > behaviors? Do I need to change

Re: [sqlite] Retrieving column data by providing column names

"Ever Green" <[EMAIL PROTECTED]> writes: > I dont think so! > > These functions would help to get the parameter names from a prepared > statement. I want to retrieve data using column headings after a > sqlite3_step. The function I pointed you at takes the parameter name and returns its index. I

Re: [sqlite] Retrieving column data by providing column names

"Ever Green" <[EMAIL PROTECTED]> writes: > I am using sqlite3_column_text16 to retrieve data. > > The problem is that sqlite3_column_text16 takes the column number as > argument. This breaks my existing code if I insert new columns in the > beginning of the column list that was specified in the

Re: [sqlite] Re: number problem with 3.2.8

"Lloyd Thomas" <[EMAIL PROTECTED]> writes: > I did try number literal >10 but mad no difference. I will rebuild the > database row as an integer. As an interim solution (prior to changing your database schema), you should be able to use your existing schema with this query: select ring_time

Re: [sqlite] Potential corruption bug in 2.8.17. Patch attached.

[EMAIL PROTECTED] writes: > [EMAIL PROTECTED] wrote: >> This was likely a typo. In its current state, it's accessing uninitialized >> memory. It looks like it's conceivable that an incorrect nextRowid could be >> later used if the uninitialized value happens to be a small integer (smaller >>

[sqlite] Potential corruption bug in 2.8.17. Patch attached.

This was likely a typo. In its current state, it's accessing uninitialized memory. It looks like it's conceivable that an incorrect nextRowid could be later used if the uninitialized value happens to be a small integer (smaller than pC->nextRowid) and the "valid" flag therefore doesn't get set

Re: [sqlite] Performance Question

Kurt Welgehausen <[EMAIL PROTECTED]> writes: > [EMAIL PROTECTED] wrote: > >> Saying NOT NULL on a PRIMARY KEY is redundant, by the way. >> -- >> D. Richard Hipp <[EMAIL PROTECTED]> > > **kaw<~/tdpsa>$ sqlite3 > Loading resources from /home/kaw/.sqliterc > SQLite version 3.3.7 > Enter ".help"

Re: [sqlite] From Windows file format to MacOSX (unsuccessfull)

Alexander Lamb <[EMAIL PROTECTED]> writes: > 1. (*) text/plain > > Well, I am afraid it didn't work. > > Somehow, the legacy_file_format info is not "sticky". > > I did: > > sqlite3 > > then in command mode: > > PRAGMA legacy_file_format=ON; > > then > > ATTACH "d:\mydb.db" AS mydb;

Re: [sqlite] "SQL Error: near 'Table': Syntax error"

"John Newby" <[EMAIL PROTECTED]> writes: > Does anyone know any reason why SQLite doesnt like tables called "Table" or > is this a standard SQL thing? It's a reserved word, so if you really, Really, REALLY want to create a table of that name (you're making it confusing to read, so you really

Re: [sqlite] Results even if no rows

"andrew gatt" <[EMAIL PROTECTED]> writes: > I'm trying to come up with an SQL statement that works under sqlite that can > return a list of rows depending if a list of ids exist. For individual > checking i'm using: > > select 1 from table where id == 1; > > which returns a 1 if there is a row

Re: [sqlite] BEGIN TRANSACTION appears to not lock database

Bud Beacham <[EMAIL PROTECTED]> writes: > In the book, SQLite (version 2.x of SQLite) by Chris Newman, he writes on > page 184 that a way to test a Tcl callback function for a locked database is > to issue a BEGIN TRANSACTION in one session and run the program in another > session. Note the

Re: [sqlite] Need sql query help

onemind <[EMAIL PROTECTED]> writes: > What technology would be best suited for this task? I just assumed that a > databse would be ideal, why do you say sql isn't suited for this and what > is? Take a look at the Controllable Regex Mutilator, CRM114, . It has

Re: [sqlite] problem with creating a table

Bijan Farhoudi <[EMAIL PROTECTED]> writes: > A. Pagaltzis wrote: >> * Bijan Farhoudi <[EMAIL PROTECTED]> [2006-06-25 16:35]: >> >>> Thanks for your answer but still I am getting an error message: >>> sqlite> create table foo(i integer, [order] integer); >>> sqlite> .sch >>> CREATE TABLE foo(i

Re: [sqlite] problem with creating a table

Bijan Farhoudi <[EMAIL PROTECTED]> writes: > I am trying to create table and I would like to name one of the columns > order, but pysqlite does not like it. I do not want to have order__ or any > thing like that. for example the following command does not work: > cur.execute('create table foo(i

Re: [sqlite] SQLite performance for 10 Million Records

"Manzoor Ilahi Tamimy" <[EMAIL PROTECTED]> writes: > Here Is The Schema For these Tables. > > CREATE TABLE HVH ( > Field1 VARCHAR(8),IDC VARCHAR(4), > Field3 VARCHAR(2),Field4 VARCHAR(4), > Field5 VARCHAR(7),Field6 VARCHAR(8), > Field7 VARCHAR(1),Field8 FLOAT); > > CREATE

Re: [sqlite] SQLite performance for 10 Million Records

Bill King <[EMAIL PROTECTED]> writes: > Manzoor Ilahi Tamimy wrote: > >> We are Using SQLite for one of our project. >> >>The Database Size is more than 500 MB. >>It contain one table and about 10 million Records. > Err, for that size, I'd recommend going something heavier, like > firebird.

Re: [sqlite] Problems with multiple threads?

"Jiri Hajek" <[EMAIL PROTECTED]> writes: > 1. Occasionally after running Sqlite3_step() I get SQLITE_CANTOPEN ('Unable > to open the database file') error. I found out that it can be fixed by > running the query again, i.e. again calling Sqlite3_Prepare(). So this isn't > a big issue, but still I

Re: [sqlite] autonum primary key

"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes: > I need help in generating a unique integer for the table's primary key. I am > more familiar with MS Access that has a data type called "Autonum" that > generates the integer. Do I need to find the last record to know what the > next number should

Re: [sqlite] Re: Check for duplicate values in database

"Anish Enos Mathew" <[EMAIL PROTECTED]> writes: > Igor, I know that it will show error when we try to insert a value which > is already there in the database when that field is a primary key. But > I want to check it out and I don't want that number to be inserted into > the database. I was

Re: [sqlite] C API Question

Anders Persson <[EMAIL PROTECTED]> writes: > I have written a wrapper around >iRes = sqlite3_get_table(db,sql); > > But only SELECT works not INSERT or UPDATE > > any ide.. missing somting The database file or the directory in which it is contained is read-only? Obviously the database

Re: [sqlite] backwards compatibility

"Michael P. Soulier" <[EMAIL PROTECTED]> writes: > Hello, > > I just got a nasty surprise. I installed an sqlite 3.3.5 .dll on windows with > pysqlite2, and I used an application to create a database file. I then scp'd > the file home to my linux box where I have sqlite 3.2.2 installed, and I got

Re: [sqlite] How can I rename a column without ALTER COLUMN Command

Roman <[EMAIL PROTECTED]> writes: > I know that ALTER TABLE -> ALTER COLUMN is not supported by sqlite3. > > I misspelled a column name, and I am curious if there is a command to change > the name from sqlite3 interface. A bit simplistic, but: echo ".dump" | \ sqlite3 database.db | \ sed

Re: [sqlite] segmentation fault error?

杰 张 <[EMAIL PROTECTED]> writes: > 1. (*) text/plain > > Hi all, > I just want to get the values of a table.The result implemented is > "Open OK! > segmentation fault ". Why did I got this result ? The following is my code: Just from a quick visual inspection, it appears that

Re: [sqlite] help with sqlite command

"Uma Venkataraman" <[EMAIL PROTECTED]> writes: > Hi Jay, > > Thanks for your reply. I am trying the command > >select * from mytable where row_id = row_id % 5 Try this instead: SELECT * FROM mytable WHERE ROWID % 5 = 0; Note that if you have an integer primary key in mytable, then ROWID

Re: [sqlite] Different column names in callback function on Linux vs. Windows

"Iulian Popescu" <[EMAIL PROTECTED]> writes: > How can I set the pragma values - is this something that can be done at > build time or is it only possible at runtime by executing the command > (before running any SELECT statements)? I don't have the sqlite3 source in front of me, but in sqlite2,

Re: [sqlite] Different column names in callback function on Linux vs. Windows

"Iulian Popescu" <[EMAIL PROTECTED]> writes: > I checked the versions and indeed the one I'm using on Windows is 3.0.8 > whether the one on Linux is 3.1.2. This being said as far as I understand > and please correct me if I'm wrong the two PRAGMA(s) are just commands you > run used to modify the

Re: [sqlite] Different column names in callback function on Linux vs. Windows

"Iulian Popescu" <[EMAIL PROTECTED]> writes: > I'm doing an application port from Windows to Linux and one of the > problems I'm facing is when executing the following statement through a call > to sqlite3_exec(): > > SELECT mytable.'mycolumn' FROM table > > The registered callback function 4th

Re: [sqlite] Problems compiling SQLite 3.3.4 on Mac OS X

Tito Ciuro <[EMAIL PROTECTED]> writes: > Hello, > > SQLite 3.3.4 > Mac OS X Tiger 10.4.5 > > After ./configure and make SQLite 3.3.4, I see that some files have > disappeared: > > os_test.c > os_test.h > os_unix.h > os_win.h > > This results in a few undefined symbols: > > sqlite3OsClose >

Re: [sqlite] DEFAULT values replace explicit NULLs?

[EMAIL PROTECTED] writes: > Is the DEFAULT value for a column suppose to replace > an explicit NULL value? Or does the DEFAULT value only > get used if no values for an insert is specified? What > is the correct SQL behavior? > > SQLite does the latter - the DEFAULT value is only used > if no

Re: [sqlite] Help!!!

"Jay Sprenkle" <[EMAIL PROTECTED]> writes: >> What I think you're really asking, though, is about the rows that are NOT >> returned because there are null values. To fix that, you're probably looking >> for LEFT OUTER JOIN: > > Huh? I thought left join and left outer join were equivalent. > >

Re: [sqlite] Help!!!

Roger <[EMAIL PROTECTED]> writes: > Select p.name||p1.name||p2.name > from people as p left join user as u as > u.uid = p.pid left joun people as p2 on > u.uid=p2.pid left join people as p3 on > u.uid=p3.pid; > > The problem is that if one of the rows does not have a value, it returns > and empty

Re: [sqlite] performance statistics

[EMAIL PROTECTED] writes: > PostgreSQL has a much better query optimizer than SQLite. > (You can do that when you have a multi-megabyte memory footprint > budget versus 250KiB for SQLite.) In your particular case, > I would guess you could get SQLite to run as fast or faster > than PostgreSQL by

Re: [sqlite] Triggers and TEMP tables: ticket #1689

[EMAIL PROTECTED] writes: > Should I remove the tests from SQLite that prevent > triggers in one database from referring to tables in > a different database? Or should I leave things as > they are and close ticket #1689 with a remark of > "works as designed". I have had use for triggers that

Re: [sqlite] :memory: and sessions with PHP

"CrazyChris" <[EMAIL PROTECTED]> writes: > Hi there, > > I have a need to create a :memory: sqlite database, but save it into the > user session (PHP) but can't see a way to access the data to save. Looking > for a sqlite version of serialize() I guess. > > Has anyone managed to do this? Is it

Re: [sqlite] Question about Regular Expression

malcom <[EMAIL PROTECTED]> writes: > Hello, > I have a sqlite column with a string. This string is composed by n > different lines separated by an \n character. Each line is composed by > : . So my final string is something like this: > > : \n > : \n > : > > Now I need to search *only* inside a

Re: [sqlite] print for debugging from triggers

"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > On Thu, Feb 09, 2006 at 09:51:44AM -0700, Dennis Cote wrote: >> >program). But this didn't work. So I wrote a simple print method that takes >> >one argument and printf it to the standard out. This works and actually >> >solves my problem. >> There

Re: [sqlite] Auto Increment?

Dennis Cote <[EMAIL PROTECTED]> writes: > Derrell, > > If you are using SQLite 3.3.0 or newer then you can do the same thing in a > more direct manner using a CHECK constraint. > > CREATE TABLE x(i INTEGER PRIMARY KEY AUTOINCREMENT CHECK(i < (1<<32))); Hehe. I'm using 2.8.16 for most of my

Re: [sqlite] Sqlite powered Web Sites

Clint Bailey <[EMAIL PROTECTED]> writes: > Can anyone point me to web sites that are powered by Sqlite? I'm curious as > to how they function as compared to a MySQL, or brand M$ powered site. How about http://sqlite.org ? Derrell

Re: [sqlite] Auto Increment?

chetana bhargav <[EMAIL PROTECTED]> writes: > Auto increment seems to return a unsigned long long is there any way for it > to make it as 32 bit, as I am depending on this feilds to generate unique > id, and i have a constraint fot the id to be 32 bit only. You'll have to add enough rows to the

Re: [sqlite] ATTACH DATABASE how-to

[EMAIL PROTECTED] writes: > The situation is: > i have two DBs - one in memory and one in the filesystem. I > need to fill some tables in the second DB from the fist DB. > So, how can I ATTACH DATABASE from memory? > (unfortunately ATTACH DATABASE ":memory:" AS mem; fails ...) You need to ATTACH

Re: [sqlite] sqlite in a shell

rahed <[EMAIL PROTECTED]> writes: > Joe Wilson <[EMAIL PROTECTED]> writes: > >> I've seen this same behavior when running a MinGW-compiled sqlite3.exe in >> the cygwin shell. It has >> something to do with the lack of flushing of information written to stdout >> (until close() anyway). >> If

Re: [sqlite] enum in SQLite

Michael Scharf <[EMAIL PROTECTED]> writes: > Jim C. Nasby wrote: >> On Thu, Jan 05, 2006 at 01:39:02PM -0600, Kurt Welgehausen wrote: >> >>> create trigger EnumTrg before insert on MainTbl for each row >>> when (select count(*) from EnumVals where val = new.EnumCol) = 0 begin >>> select

Re: [sqlite] LIMIT keyword does work in an UPDATE statement

"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > On Tue, Jan 03, 2006 at 10:15:17AM -0500, [EMAIL PROTECTED] wrote: >> test mjom <[EMAIL PROTECTED]> writes: >> >> > create table tbl1 ( id integer primary key autoincrement, ref >> > integer, sts varchar(16)); >> > insert into tbl1 (ref,sts)

Re: [sqlite] LIMIT keyword does work in an UPDATE statement

test mjom <[EMAIL PROTECTED]> writes: > create table tbl1 ( id integer primary key autoincrement, ref > integer, sts varchar(16)); > insert into tbl1 (ref,sts) values (10, 'ready' ); > insert into tbl1 (ref,sts) values (20, 'ready' ); insert into tbl1 > (ref,sts) values (30, 'ready'

Re: [sqlite] CURRENT_TIMESTAMP records / displays incorrect value?

"Murray @ PlanetThoughtful" <[EMAIL PROTECTED]> writes: > I have a column defined with DEFAULT CURRENT_TIMESTAMP in an SQLite 3.2.7 db > (on WinXP SP2, if that's important). I've noticed that the value being > stored in that column is being recorded / displayed incorrectly. For > example, it's

Re: [sqlite] Version 3.2.8 and 2.8.17

[EMAIL PROTECTED] writes: > New versions of SQLite 2 and 3 are now available on the website. > > http://www.sqlite.org/ > > These new versions contain a one-line fix to a problem that can > lead to database corruption. The problem has been in the code > for almost 4 years and has so far gone

Re: [sqlite] Re: - [sqlite] can anyone reproduce ticket# 1540 (failure to create a primary key)?

"Bogdan Ureche" <[EMAIL PROTECTED]> writes: > I am beginning to believe that maybe I was wrong in my assumption that 'if a > table has an index, that index shows in sqlite_master'. Then my problem is > now to find another way to get index information for a table. Any > suggestions? An index for

Re: [sqlite] Request for comment: Proposed SQLite API changes

Dennis Cote <[EMAIL PROTECTED]> writes: > Furthermore, I don't believe that most users are using an authorizer anyway > (but I could definitely be wrong about that). In that case all the authorizer > callbacks become no-ops don't they? PHP's use of sqlite uses an authorizer callback in the

Re: [sqlite] SQL assistance with selecting the last n records inserted

Jay Sprenkle <[EMAIL PROTECTED]> writes: > If you just want 10 records with the highest modified or created time I > think this will do it: > > select * > from tbl > order by max(created_on,modified_on) desc > limit 10 except that if modified_on is null, you won't get that record. This

Re: [sqlite] modifying insert/updat data in triggers

Mark de Vries <[EMAIL PROTECTED]> writes: > But I still don't know how to do what I want to do. Perhaps I need to > explain with a litle more detail what I mean. Consider the following > table. > > create table foo ( > value TEXT, > date_create TEXT, > date_lch TEXT > ); > > Now, whenever I

Re: [sqlite] mixing GROUP and non-GROUP columns in a query

Will Leshner <[EMAIL PROTECTED]> writes: > Say I have a table defined and populated as follows: > > CREATE TABLE test (a TEXT); > INSERT INTO test (a) VALUES ('hello'); > INSERT INTO test (a) VALUES ('hello'); > INSERT INTO test (a) VALUES ('hello'); > > And I perform the following query: > >

Re: [sqlite] Saving "Unsigned Long"s in database

Jay Sprenkle <[EMAIL PROTECTED]> writes: > On 7/12/05, Gotzon Astondoa <[EMAIL PROTECTED]> wrote: >> ... >> struct hostent *hep; >> ... >> hep=gethostbyname(DomainTxt); >> ... >> strcpy(txtIP, inet_ntoa(*((struct in_addr *)hep->h_addr_list[i]))); >>

Re: [sqlite] Possible enhancement to SQL logic

Ben Clewett <[EMAIL PROTECTED]> writes: > D. Richard Hipp wrote: >>> MySQL and PostgreSQL will use the indexes here, and therefore return the >>> result considerably faster. >>> >> Really? I would be very interested to know what >> query plan MySQL and PostgreSQL use in this example. > > It

Re: [sqlite] file db from memory db

Cornel Gazdaru <[EMAIL PROTECTED]> writes: > I try copying a table from a :memory: data base to a file data base, but > could not make it work. > Anybody has any suggestions? > Thanks > > I tried something like: > > open a data base :memory: > create table MYTABLE (...) > ... > > attach

Re: [sqlite] Error 21, "library routine called out of sequence"

Ben Clewett <[EMAIL PROTECTED]> writes: > Dear SQLite, > > I am running a sequence of inserts: > > BEGIN > INSERT INTO table ... > INSERT INTO table ... > INSERT INTO table ... > INSERT INTO table ... > INSERT INTO table ... > > I am catching the 'kill -1' signal (aka CTRL-C) and executing a

  1   2   >