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

[Firman Wandayandi]

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 service for a personal project
using LASP (Linux, Apache, SQLite, PHP) and realized a
list of providers would probably be ideal.  A matrix
of common features would be good also (Windows, Linux,
Apache, IIS, PHP, Perl, Python, Price, etc.)


I guess for start just find the hosting companies who provide PHP5,
because it has bundled SQLite 2.1.17 on it (expect they turn off it).
Better if they provides PDO. But I develop my apps with SQLite2
backend, it's enough for me, since PDO is a PECL stuff. It's not so
hard to find the PHP5 hosting companies i think, except the local
companies in my country :-(

--
Firman Wandayandi 

Diskusi Praktisi Web:
PHP ,

JavaScript 
Teknologi Web 

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Clark Christensen]

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 CPanel or other admin tools to help you administer your 
site and your DBs.  I signed-up with Vizaweb for my condo association's site.  
They offer Linux, Apache, MySQL, PG, PHP, Perl, and a bunch of other stuff.  
Though they've expressed their openness to installing more stuff, I think if I 
were to do a DB-backed web app there, I'd probably just go with the My or PG db 
platform they offer.

 -Clark

- Original Message 
From: Louis P. Santillan <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Friday, August 25, 2006 12:33:36 PM
Subject: [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, PHP) and realized a
list of providers would probably be ideal.  A matrix
of common features would be good also (Windows, Linux,
Apache, IIS, PHP, Perl, Python, Price, etc.)

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-
To unsubscribe, send email to [EMAIL PROTECTED]
-





-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Martin Jenkins]

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

[Cesar David Rodas Maldonado]

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:


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 sqlite3.def as the current
folder.  When I ran it, I got:



sqlite3.def : fatal error LNK1136: invalid or corrupt file



What did I do wrong?



RobR, about to build the DLL from the source files

RAD-CON INC.

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

[Louis P. Santillan]

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, PHP) and realized a
list of providers would probably be ideal.  A matrix
of common features would be good also (Windows, Linux,
Apache, IIS, PHP, Perl, Python, Price, etc.)

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Rob Richardson]

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 sqlite3.def as the current
folder.  When I ran it, I got:

 

sqlite3.def : fatal error LNK1136: invalid or corrupt file

 

What did I do wrong?

 

RobR, about to build the DLL from the source files

RAD-CON INC.

Re: [sqlite] problem with application which uses sqlite

[Martin Jenkins]

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 help you with one hand and 
deflect the "off topic" police with the other. ;)


I downloaded the ktu source and it looks like configure uses a tool 
called (something like) pkg-config to find out where your sqlite lives. 
I guess this tool isn't looking in the place where you've installed 
sqlite etc.


In config.log there should be a line like PKG_CONFIG='/path/to/app' and 
in configure around line 39110 there are a couple of commands which 
search for/test the installed version of sqlite.


If you can find out what PKG_CONFIG expands to and run

$PKG_CONFIG --libs "sqlite3 >= 3.0"

you might get some info as to where it's looking and compare that with 
the location of your newly built sqlite.


The only Linux box I have handy at the moment is an SME server which 
doesn't install kde (or even gcc :( ) so I can't try this myself. Feel 
free to mail me off-list if you want, my address is in the headers.


Martin

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Martin Jenkins]

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 Windows, open a command prompt, type "set" and see if you 
have an environment variable called "HOME". If you have, put .sqliterc 
in that directory. If not, go to the control panel and find the tool 
which sets the environment variables (System|Advanced on XP), specify a 
directory there and then create the .sqliterc file. You'll probably have 
to log out/in before the variable is created in new command prompts.


When you start sqlite it will say that it has loaded commands from a 
file and print the fully qualified pathname of that file.


Martin

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] duplicate primary key

[Will Leshner]

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.

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] SQLite index Idea for DBF

[Kees Nuyt]

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 tried to  covert the data in “db” and then
> apply different operations. 
>
> But because of the slow performance in case of converting
> data into dbf to db I changed the design and now I did
> some modifications and I am directly reading the data
> from dbf files.  
>
> So now I want to create index in “dbf” using SQLite index Idea. 
>
> Can anyone guide me how to start.

What type of database is "dbf" ?
What type of database is "db" ?

If "dbf" is dBase, FoxBase or something like that it doesn't
make much sense to have data in that database indexed by SQLite.
You'd better use the index of that given database, or speed up
the conversion process.
 
>Regards,
>
>Manzoor Ilahi
-- 
  (  Kees Nuyt
  )
c[_]

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] duplicate primary key

[Kurt Welgehausen]

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 the
> same NULL primary key.

   This is a violation of the '92 std. I believe SQLite used
   to enforce the non-nullability of primary keys. I recall
   that the question whether SQLite should enforce this
   constraint was discussed here, and I thought it was decided
   that it should.


Regards

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] sqlite3_interrupt() works

[Rob Richardson]

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?

[John Salerno]

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 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
http://www.reddawn.net/~jsprenkl/Sqlite

Cthulhu Bucks!
http://www.cthulhubucks.com

-
To unsubscribe, send email to [EMAIL PROTECTED]
-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] duplicate primary key

[Mario Frasca]

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 nice...

sqlite> create table test(f integer primary key, 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 a bit surprising; where does the autoincrement-like behaviour 
come from?  without an explicit autoincrement definition, I would expect 
something like 'ERROR:  null value in column "f" violates not-null 
constraint' (for all inserts) or at least 'SQL error: PRIMARY KEY must 
be unique' (for all inserts after the first), depending on whether we 
want to allow NULL primary keys or not.


sqlite> create table test(f char(24) primary key, 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;
|0
|0
|0

what is going on here?  I'm having three records with the same NULL 
primary key.


regards,
MF

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Unrevolved _sqlite3ExprCodeAndCache with SQLITE_OMIT_TRIGGER

[Ralf Junker]

>> 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:
>
>   make fulltest

I can do this (sidenote: many of the vtab tests fail).

I use cygwin on Win32 and run:

  sh configure
  makek fulltest

Question: Where do I introduce SQLITE_OMIT_TRIGGER? 

>A safer fix would be to remove the #ifndef SQLITE_OMIT_TRIGGER
>from around the sqlite3ExprCodeAndCache function.

Thanks, will do.

>You should also file a bug report.

Done. 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Jay Sprenkle]

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
http://www.reddawn.net/~jsprenkl/Sqlite

Cthulhu Bucks!
http://www.cthulhubucks.com

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

RE: [sqlite] Custom md5 function

[Merijn Vandenabeele]

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 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.  See:

http://www.sqlite.org/cvstrac/fileview?f=sqlite/src/test_md5.c

--
D. Richard Hipp   <[EMAIL PROTECTED]>



-
To unsubscribe, send email to [EMAIL PROTECTED]

-



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Unrevolved _sqlite3ExprCodeAndCache with SQLITE_OMIT_TRIGGER

[drh]

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, references in 
> 
>   insert.c, line 536
>   update.c, line 348 and 362
> 
> are not wrapped with #ifndef SQLITE_OMIT_TRIGGER.
> 
> I followed the suggestion quoted below (posted earlier to this list) without 
> avail.
> 
> 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:

   make fulltest

A safer fix would be to remove the #ifndef SQLITE_OMIT_TRIGGER
from around the sqlite3ExprCodeAndCache function.

You should also file a bug report.
--
D. Richard Hipp   <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Custom md5 function

[drh]

"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.  See:

http://www.sqlite.org/cvstrac/fileview?f=sqlite/src/test_md5.c

--
D. Richard Hipp   <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[drh]

"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 difference has 
> been made 
> and the footprint is still the same. 
> 
> I'm not familiar with linux. So I guess the way I edit Makefile.linux-gcc is 
> wrong. 
> My steps are as follows:
> 1.Edit Makefile.linux-gcc,add the following sentences directly into it:
>   -DSQLITE_OMIT_TRIGGER
>   -DSQLITE_OMIT_ALTERTABLE
>   -DSQLITE_OMIT_VIEW
>   -DSQLITE_OMIT_AUTHORIZATION

Should be:

  OPTS += -DSQLITE_OMIT_TRIGGER

and so forth.

>   ...
> 2.run ..>../configure
> 3.run ..>make
> 4.generate lib, run ..>ar cr libsqlite.a *.o
> 5.compare the footprint of generated sqlite.a with the one without defining 
> -DSQLITE_OMIT_* in Makefile.linux-gcc.
>   totally the same.
> 
> Any help will be appreciated..
> 
> Sarah



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Alexei Alexandrov]

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 to have an aggregated function in the select list
for non-grouped column. This is correct many-to-one mapping.

--
Alexei Alexandrov

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] SQLite index Idea for DBF

[Manzoor Ilahi Tamimy]

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 operations. 

But because of the slow performance in case of converting data into dbf to db 
I changed the design and now I did some modifications and I am directly 
reading the data from dbf files.  

So now I want to create index in “dbf” using SQLite index Idea. 

Can anyone guide me how to start.
 
Regards,

Manzoor Ilahi

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Unrevolved _sqlite3ExprCodeAndCache with SQLITE_OMIT_TRIGGER

[Ralf Junker]

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 362

are not wrapped with #ifndef SQLITE_OMIT_TRIGGER.

I followed the suggestion quoted below (posted earlier to this list) without 
avail.

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

Ralf
 
>> parse.obj : error unresolved external symbol _sqlite3VtabArgExtend in 
>> function  _yy_reduce
>> parse.obj : error unresolved external symbol _sqlite3VtabArgInit in function 
>> _yy_reduce
>> parse.obj : error unresolved external symbol _sqlite3VtabBeginParse in 
>> function  _yy_reduce
>> parse.obj : error unresolved external symbol _sqlite3VtabFinishParse in 
>> function  _yy_reduce
>> 
>> These functions are declared in sqliteint.h line 1863-1866.
>> These functions are implemented in vtab.c but enclosed in:
>> #ifndef SQLITE_OMIT_VIRTUALTABLE
>> 
>> #endif
>> 
>> And of course, these functions are used in function reduce without any 
>> SQLITE_OMIT_VIRTUALTABLE check.
>> 
>
>You must be trying to use the "parse.c" source file that
>is found in sqlite-source-3_3_7.zip.  "parse.c" is not really
>source code.  It is generated code.  The source code is
>"parse.y".  The -DSQLITE_OMIT_VIRTUALTABLE=1 comes into play
>when compiling parse.y into parse.c.  So if you want to use
>-DSQLITE_OMIT_VIRTUALTABLE=1, you have to compile beginning
>back at parse.y.
>
>To do that, you will need some kind of Unix.  Make a copy of
>Makefile.gcc-linux, rename it as just "Makefile", edit the 
>setup lines at the top to suite your particular situation, 
>(for example, add lines that say "OPTS += -DSQLITE_OMIT_VIRTUALTABLE=1")
>then type "make".


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Custom md5 function

[Merijn Vandenabeele]

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


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

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

[Sarah]

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 still the same. 

I'm not familiar with linux. So I guess the way I edit Makefile.linux-gcc is 
wrong. 
My steps are as follows:
1.Edit Makefile.linux-gcc,add the following sentences directly into it:
  -DSQLITE_OMIT_TRIGGER
  -DSQLITE_OMIT_ALTERTABLE
  -DSQLITE_OMIT_VIEW
  -DSQLITE_OMIT_AUTHORIZATION
  ...
2.run ..>../configure
3.run ..>make
4.generate lib, run ..>ar cr libsqlite.a *.o
5.compare the footprint of generated sqlite.a with the one without defining 
-DSQLITE_OMIT_* in Makefile.linux-gcc.
  totally the same.

Any help will be appreciated..

Sarah