Re: [sqlite] List of web hosting providers who provide/support SQLite?

On 8/26/06, Louis P. Santillan <[EMAIL PROTECTED]> wrote: This is probably a good topic for a wiki page... Does anybody have a list (actually a matrix would be even better) of web hosting providers who have SQLite available to their customers? I decided to look for some cheap web hosting

Re: [sqlite] List of web hosting providers who provide/support SQLite?

I've been thinking about that myself. Then I started to wonder if the more common MySQL or PostgreSQL wouldn't be just as good (or better) for websites - particularly remote-hosted ones. I see there are a lot of hosting companies out there that offer the traditional LAMP stuff, as well as

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] "Invalid or corrupt file" when building .lib file for version 3.3.7 dll

I am sorry my friend... try with Dev-cpp! That's better that MS VC. What i do always is download the source and compile like part of my project or create the library. I think the first one will better for velocity but not for update. On 8/25/06, Rob Richardson <[EMAIL PROTECTED]> wrote:

[sqlite] List of web hosting providers who provide/support SQLite?

This is probably a good topic for a wiki page... Does anybody have a list (actually a matrix would be even better) of web hosting providers who have SQLite available to their customers? I decided to look for some cheap web hosting service for a personal project using LASP (Linux, Apache, SQLite,

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

Greetings! I am using MS Visual Studio 6 under the Windows XP pro operating system. I downloaded the dll for version 3.3.7. I tried to run Lib to build the .lib file for the dll. Here's the command line: lib /machine:i386 sqlite3.def This was run with the folder containing

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 trying to

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

Re: [sqlite] duplicate primary key

On 8/25/06, Mario Frasca <[EMAIL PROTECTED]> wrote: what is going on here? I'm having three records with the same NULL primary key. Well, not the same. NULL values aren't equal to anything, including another NULL value.

Re: [sqlite] SQLite index Idea for DBF

On Fri, 25 Aug 2006 13:58:09 +0600, you wrote: > Hi All, > > I want to create index in “dbf” using SQLite index idea. > > I will give a little detail of my project. > I am using SQLite for one of my project. I have dbf files > with 30 million or 50 million records. And at the first > stage I

Re: [sqlite] duplicate primary key

Mario Frasca <[EMAIL PROTECTED]> wrote: > this is a bit surprising; where does the autoincrement-like > behaviour come from? without an explicit autoincrement > definition, I would expect ... > what is going on here? I'm having three records with

[sqlite] sqlite3_interrupt() works

Greetings! After installing SQLite 3.3.7 and making sure I was passing the correct pointer to sqlite3_interrupt(), I got it to work. Rob Richardson RAD-CON INC.

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

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) John On 8/25/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote: There are a load of nice text processing programs for this sort of

[sqlite] duplicate primary key

I'm recording this behaviour: sqlite> create table test(f integer primary key autoincrement, v integer default 0); sqlite> insert into test(f) values(NULL); sqlite> insert into test(f) values(NULL); sqlite> insert into test(f) values(NULL); sqlite> select * from test; 1|0 2|0 3|0 this is very

Re: [sqlite] Unrevolved _sqlite3ExprCodeAndCache with SQLITE_OMIT_TRIGGER

>> Is it safe (or even required?) to change sqliteInt.h to >> >> #ifndef SQLITE_OMIT_TRIGGER >> void sqlite3ExprCodeAndCache(Parse*, Expr*); >> #else >> # define sqlite3ExprCodeAndCache(A,B) >> #endif >> > >The suggested change will probably fail. You can find out >by running: > >

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

There are a load of nice text processing programs for this sort of thing in Unix/Linux/BSD. Take a look at sed, ed, awk, or shell scripting. Any of them should do it without much effort. -- SqliteImporter and SqliteReplicator: Command line utilities for Sqlite

RE: [sqlite] Custom md5 function

Yes, but it's an aggregate function. I'd like to do something like md5("foo"). -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Verzonden: vrijdag 25 augustus 2006 12:37 Aan: sqlite-users@sqlite.org Onderwerp: Re: [sqlite] Custom md5 function "Merijn

Re: [sqlite] Unrevolved _sqlite3ExprCodeAndCache with SQLITE_OMIT_TRIGGER

Ralf Junker <[EMAIL PROTECTED]> wrote: > Lattest cvs sqlite version: > > If SQLITE_OMIT_TRIGGER is set, linker complains about an unresolved > _sqlite3ExprCodeAndCache symbol. > > sqlite3ExprCodeAndCache is defined in expr.c and wrapped with #ifndef > SQLITE_OMIT_TRIGGER. > > However,

Re: [sqlite] Custom md5 function

"Merijn Vandenabeele" <[EMAIL PROTECTED]> wrote: > Hi, > > Is there anybody who implemented a custom md5 function and is willing to > share his code with the public? I searched this mailinglist and googled > around a bit, but found nothing relevant. > The code is already in the source tree.

Re: [sqlite] How to edit Makefile.linux-gcc to define those SQLITE_OMIT_*?

"Sarah" <[EMAIL PROTECTED]> wrote: > Hi,all > > In order to define those SQLITE_OMIT_TRIGGER,SQLITE_OMIT_ALTERTABLE..., I > have to rebuild parse.c > from parse.y. So I took the following steps to do it under linux(Fedora 2). > > But by comparing the generated static library, I find that no

Re: [sqlite] Seems like a bug in the parser

On 8/23/06, Andrew McCollum <[EMAIL PROTECTED]> wrote: I find this feature useful, especially in queries which use aggregate functions, such as the following: SELECT sum(a) FROM tbl GROUP BY b The question should be what the compelling reason is to remove a useful feature. Of course it's OK

[sqlite] SQLite index Idea for DBF

Hi All, I want to create index in “dbf” using SQLite index idea. I will give a little detail of my project. I am using SQLite for one of my project. I have dbf files with 30 million or 50 million records. And at the first stage I tried to covert the data in “db” and then apply different

[sqlite] Unrevolved _sqlite3ExprCodeAndCache with SQLITE_OMIT_TRIGGER

Lattest cvs sqlite version: If SQLITE_OMIT_TRIGGER is set, linker complains about an unresolved _sqlite3ExprCodeAndCache symbol. sqlite3ExprCodeAndCache is defined in expr.c and wrapped with #ifndef SQLITE_OMIT_TRIGGER. However, references in insert.c, line 536 update.c, line 348 and

[sqlite] Custom md5 function

Hi, Is there anybody who implemented a custom md5 function and is willing to share his code with the public? I searched this mailinglist and googled around a bit, but found nothing relevant. Best regards, Merijn Vandenabeele

[sqlite] How to edit Makefile.linux-gcc to define those SQLITE_OMIT_*?

Hi,all In order to define those SQLITE_OMIT_TRIGGER,SQLITE_OMIT_ALTERTABLE..., I have to rebuild parse.c from parse.y. So I took the following steps to do it under linux(Fedora 2). But by comparing the generated static library, I find that no difference has been made and the footprint is