Re: [sqlite] Computed columns in VIEWs return NULL but should be able to be typed! Any ideas?

On 06/05/2010, at 2:51 PM, Dan Bishop wrote: > BareFeetWare wrote: >> >> I've had the same issue. In the end I had to parse my view functions in my >> own code and look for functions that give a particular type of result. So, >> for instance, round() gives an integer, round(..., 2) gives a

Re: [sqlite] Computed columns in VIEWs return NULL but should be able to be typed! Any ideas?

BareFeetWare wrote: > On 04/05/2010, at 3:14 AM, Stefan Keller wrote: > > >> But in SQLite if a view column comes from a function result or some >> computation, then the column type is NULL...!? It's not taking the >> result-type as mentioned in the manual >>

Re: [sqlite] I don't understand locking

On May 5, 2010, at 8:32 PM, myomancer wrote: > Dear Users > > I've spent hours reading various web-based documents, examined lots of > code snippets, written some code of my own, but I still patently do > not understand SQLite locks. 4th paragraph of this page (The presence of a busy...)

Re: [sqlite] Read-only tables in in-memory database?

daniel.hagl...@trafikverket.se wrote: > There seems to be lots of information in the mailing list regarding read-only > databases and locking when it comes to databases on > disk. Both locking and read-only mode seems to be functionality requiring a > file on disk. Is it even possible to have

[sqlite] Misspelling in SQLite 2

Hi again, I got another patch for SQLite in which I changed "non-existent" to "nonexistent". Maybe you're interested in this too. Sincerely, Michael Kohler diff -r fa1e1974b034 security/nss/lib/sqlite/sqlite3.c --- a/security/nss/lib/sqlite/sqlite3.cWed May 05 21:57:11 2010 +0200 +++

[sqlite] Misspelling in SQLite

Hi, I made a patch for Mozilla Firefox and I got told that Mozilla doesn't want to fix upstream bugs and that I need to send the patch to you. The attached patch is a patch against Mozilla Firefox code, but I guess it won't be that hard to convert it to a "normal" patch. Feel free to reply

[sqlite] I don't understand locking

Dear Users I've spent hours reading various web-based documents, examined lots of code snippets, written some code of my own, but I still patently do not understand SQLite locks. My misunderstanding is probably best illustrated with a concrete example written in C. #include #include #include

Re: [sqlite] A newb performance question

Hi Igor, I'm getting "0","0","TABLE first_table WITH INDEX first_table_target_field_id" "1","1","TABLE second_table USING PRIMARY KEY" "2","2","TABLE third_table USING PRIMARY KEY" ... so I presume it is then. (Is there anywhere that explains how to interpret this?) Thanks ALJ On

[sqlite] Read-only tables in in-memory database?

There seems to be lots of information in the mailing list regarding read-only databases and locking when it comes to databases on disk. Both locking and read-only mode seems to be functionality requiring a file on disk. Is it even possible to have locking or read-only mode with in-memory

Re: [sqlite] SELECT question (computing day of week the usingstrftime() function)

Please cancel my subscription to this list!! My Mail client is overwhelmed. Roger Andersson wrote: >> I need to find out how many specific weekdays (e.g., how many >> Sundays) I have in any given range of dates. >> My problem: How to use the COUNT function in combination with >> the strftime()

Re: [sqlite] Computed columns in VIEWs return NULL but should be able to be typed! Any ideas?

On 04/05/2010, at 3:14 AM, Stefan Keller wrote: > But in SQLite if a view column comes from a function result or some > computation, then the column type is NULL...!? It's not taking the > result-type as mentioned in the manual > (http://www.sqlite.org/lang_select.html) - even when I try to do

Re: [sqlite] Computed columns in VIEWs return NULL but should be able to be typed! Any ideas?

> I interpret the silence on the lis that anyone agrees that SQLite has a bug Generally silence on this list means that everybody disagrees with you and/or doesn't see enough arguments in your email to even start any discussion. When everybody agrees that SQLite has a bug you get a lot of

Re: [sqlite] Computed columns in VIEWs return NULL but should be able to be typed! Any ideas?

I interpret the silence on the lis that anyone agrees that SQLite has a bug because there seems to be no way to get VIEWS returning the column type if the column is calculated or a function. This also breaks compatibility as mentioned in http://www.sqlite.org/datatype3.html ("SQL statement that

Re: [sqlite] [server] HTTP + SQLite bundled as single EXE?

On Mon, 3 May 2010 08:57:04 -0400, Reid Thompson wrote: >http://code.google.com/p/mongoose/ Right, I got Lua and SQLite working as a CGI call. The alternative is to use the Lua-based Xavante web server and include SQLite; I'll try to get this working tomorrow. Thank you.

Re: [sqlite] [server] HTTP + SQLite bundled as single EXE?

On Mon, May 03, 2010 at 03:01:26PM +0400, Alexey Pechnikov wrote: > See http://wiki.tcl.tk/15722 Add SQLite into it - about few minuts of time. > > 2010/5/3 Gilles Ganault : > > I don't know if it'd be easier to combine existing HTTP server + > > SQLite ditto

[sqlite] Sqlite in low memory devices

Well I have a port to latest version (3.6.23.1) of sqlite to palmos, and in some devices with this S.O. had only 2MB of Dynamic Heap. On this environments sqlite doesn't works pretty well, then to work I had to set the cache size (PRAGMA cache_size) for all attached database, calculating the

Re: [sqlite] Accessing SQLite from Lua?

On Wed, 05 May 2010 13:32:24 +0200, Gilles Ganault wrote: >I'd like to know how to use this from a Lua script. For Lua newbies like me who'd like to access an SQLite database through the LuaSql interface, here's how to do it: 1. In the directory where the Lua interpreter

Re: [sqlite] is it possible to query for database file name ?

On 5 May 2010, at 11:08am, yogibabu wrote: > in php I declared database object: > $pdo = new PDO('sqlite:mybase.DB3'); > > i know how to get information about engine used in this connection, which > is: > $pdo->getAttribute(PDO::ATTR_DRIVER_NAME); ---> string 'sqlite' > > But I do not know

Re: [sqlite] Implementing a CREATE_FUNCTION function

Dan Bishop wrote: > It's convenient to be able to define new functions in C. But sometimes, > it would be *more* convenient to be able to define new functions in > SQL. This could be done by registering a CREATE_FUNCTION() function; > then you could write something like: > > SELECT

Re: [sqlite] A newb performance question

Astley Le Jasper wrote: > Given the example below where 'first_table' could be huge, are sqlite > or other relational databases clever enough to do the WHERE filter > before doing the joins. I would expect SQLite to do it this way, yes. Especially if there's an index on first_table.target_field.

Re: [sqlite] is it possible to query for database file name ?

On Wed, 5 May 2010 03:08:42 -0700 (PDT), yogibabu wrote: > >in php I declared database object: >$pdo = new PDO('sqlite:mybase.DB3'); > >i know how to get information about engine used in this connection, which >is: >$pdo->getAttribute(PDO::ATTR_DRIVER_NAME); ---> string

[sqlite] Accessing SQLite from Lua?

Hello >From what I've been reading this morning, it appears that Lua offers two ways to access an SQLite database: - through the database-neutral Lua API LuaSQL - by calling the SQLite-specific luasqlite I have no preference, and would like to find the Windows binaries that I could just copy to

[sqlite] A newb performance question

Given the example below where 'first_table' could be huge, are sqlite or other relational databases clever enough to do the WHERE filter before doing the joins. SELECT * FROM first_table INNER JOIN second_table ON second_table_id = second_table.id INNER JOIN third_table ON third_table_id =

Re: [sqlite] INSERT questions

On Tue, 4 May 2010 14:22:25 +0100, "Mark Coles" wrote: >Hi there, > > trying to INSERT a new row into a table and got a few > errors which I think I've sorted, I was getting a > couple of errors that date columns for FirstCreated > and LastModified (datetime Type) may not be

Re: [sqlite] is it possible to query for database file name ?

On 5 May 2010 11:08, yogibabu wrote: > > in php I declared database object: > $pdo = new PDO('sqlite:mybase.DB3'); > > i know how to get information about engine used in this connection, which > is: > $pdo->getAttribute(PDO::ATTR_DRIVER_NAME);   ---> string 'sqlite' > > But I

Re: [sqlite] Expression tree is too large

e-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > __ Informazioni da ESET NOD32 Antivirus, versione del database delle > firme digitali 5087 (20100505) __ > > Il messaggio è stato controllato da ESET NOD32 Antivirus. > > www.nod32.it > >

Re: [sqlite] Expression tree is too large

> - Ursprüngliche Nachricht - > Von: Andrea Galeazzi > Gesendet: 05.05.10 12:14 Uhr > An: General Discussion of SQLite Database > Betreff: [sqlite] Expression tree is too large > Hi guys, I've got a DELETE statement with a lot of OR: DELETE FROM myTable WHERE id = ? OR id = ?..OR id=?

[sqlite] Expression tree is too large

Hi guys, I've got a DELETE statement with a lot of OR: DELETE FROM myTable WHERE id = ? OR id = ?..OR id=? and SQLite throws this error: Expression tree is too large. Do you know a way to avoid such problem or I just have to split the large statement into shorter ones? Cheers

[sqlite] is it possible to query for database file name ?

in php I declared database object: $pdo = new PDO('sqlite:mybase.DB3'); i know how to get information about engine used in this connection, which is: $pdo->getAttribute(PDO::ATTR_DRIVER_NAME); ---> string 'sqlite' But I do not know how to get back the actual database file name back from this

Re: [sqlite] Small change to support poor man's extended features

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 05/04/2010 09:41 PM, Aron Rubin wrote: > Most execution environments that support calling including C and > Sqlite use a stack of frames. C has a conceptual stack - the actual implementation does not require one. SQLite has no such thing - the