[sqlite] Announcement: mod_auth_sqlite3

2007-04-14 Thread Clay Dowling
For all of you who have been wanting to use SQLite3 to manage authentication on your Apache web servers, I have just released mod_auth_sqlite3. You may download it from http://www.lazarusid.com/download/modauthsqlite3-1.0.tar.gz The module includes both a command line and a web utility for

Re: [sqlite] DELETE row problem

2007-04-14 Thread drh
dszhang [EMAIL PROTECTED] wrote: when i delete some row in my table ... i find the sqlite will free some memory that have been free[d] previous[ly]. my question is why that thing happen and how to solve it? SQLite should never call free() on the same piece of memory twice. If it does, that

Re: [sqlite] sqlite3_rowid

2007-04-14 Thread drh
Marco Bambini [EMAIL PROTECTED] wrote: I need a way to automatically have the rowid for all queries issued by our users (without modifying the original sql queries). A lot of time for some queries (COUNT(*) for example), it is simply not possible to obtain a valid rowid, so it could just

Re: [sqlite] Need help understanding SQLITE_ERROR[1] problem

2007-04-14 Thread drh
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: In the following pseudo-code which works the first time through either Function A or Function B I get a problem when either function is executed a second time. I get the following error: SQLITE_ERROR[1] - cannot start a transaction within a

Re: [sqlite] Supporting databases larger than 2GB on FAT filesystems?

2007-04-14 Thread drh
Ludvig Strigeus [EMAIL PROTECTED] wrote: Does Sqlite support databases larger than 2GB on FAT filesystems? SQLite supports large databases just fine. It is FAT that does not support large files. If not, how hard would it be to add so it uses additional files for the pages that don't fit in

[sqlite] Fortran 95 Language Bindings

2007-04-14 Thread Gary Scott
Hi, this is my first post, so please excuse any etiquette goofs. I'm researching incorporation of SQLite into a project. It would appear relatively straightforward to develop an F95 language binding, however it is likely to be compiler specific (extensions required to adapt calling syntax to

Re: [sqlite] Re: SQLite and nested transactions

2007-04-14 Thread Raymond Hurst
I followed every one of these threads and it is really good stuff. I've done some research to realize I need to do more. I see that most of you are in the client/server world where you can ask the client various questions about the query. In my case, I am a standalone server embedded in a

Re: [sqlite] Supporting databases larger than 2GB on FAT filesystems?

2007-04-14 Thread Ludvig Strigeus
Alright thanks! I will look into that. /Ludvig On 4/14/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Ludvig Strigeus [EMAIL PROTECTED] wrote: Does Sqlite support databases larger than 2GB on FAT filesystems? SQLite supports large databases just fine. It is FAT that does not support large

Re: [sqlite] Fortran 95 Language Bindings

2007-04-14 Thread Al Danial
As you suspect, it is straightforward to make a Fortran to SQLite binding. Here's an example with Fortran 77: http://danial.org/sqlite/fortran/ I don't see why an F95 binding would need to be compiler specific. -- Al On 4/14/07, Gary Scott [EMAIL PROTECTED] wrote: Hi, this is my first post,