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

[Gilles Ganault]

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.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Reid Thompson]

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
http://code.google.com/p/mongoose/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Gilles Ganault]

On Mon, 3 May 2010 00:39:37 +0400, Alexey Pechnikov
 wrote:
>it's easy for TCL developers. You may build tclsqlite+tclhttpd+your
>tcl scripts as starpack (single executable binary). For integrate
>SQLite database into starpack use this extension:
>http://www.siftsoft.com/tclsqlitevfs.html

Thanks. It looks like it's the easiest way to pack a web server +
SQLite in one go. I don't know TCL: Is it easy to quickly write the
script that will turn POSTed queries into SQL and send them to SQLite,
before returning status/data?

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Alexey Pechnikov]

As example, on my laptop AOL Web Server+SQLite database + TCL scripts
can perform more than 1000 HTTP request per second. But AOLServer is a
solution for big projects. I am using AOLServer for projects with a
few hundreds and more of concurrent user sessions. And for many
projects SQLite is more better than PostgreSQL database (selects in
SQLitre is exteremly fast).

You can see a single-threaded performance tests of my Fossil repository here:
http://sqlite.mobigroup.ru/src/wiki?name=fossil

Single-file executable (TCL starpack) with custom socket event handler
+ tclsqlite package + database is more reasonable way. Produce
JSON/XML/etc. output is a trivial task. A few thousands of requests
per second is available by this (about 10 000 requests per second is
limit on my laptop for TCL sockets). I think you can't do this with
Apache.


2010/5/3 Sam Carleton :
> I must respectfully disagree with the statement that Apache is huge and
> complicated, but I guess it is all relative...

-- 
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Sam Carleton]

On Mon, May 3, 2010 at 6:24 AM, Simon Slavin  wrote:

>
> The problem is not in coding it -- that's relatively easy.  The problem is
> in who would use it.  I think that would be mostly people who already use
> PHP to write a backend data server.  The advantage of this is that it can be
> done using just the hugely popular and tested Apache: it already has SQLite
> built in.
>
> On the other hand, Apache is huge, complicated and hard to test.  A minimal
> kit including just HTTP and SQLite would be smaller and simpler and
> therefore more in the spirit of SQLite.
>

I must respectfully disagree with the statement that Apache is huge and
complicated, but I guess it is all relative...

I am a MicroISV that is using Apache, Axis2/C, PHP5, and SQLite for my
backend.  All three are installed with the .Net frontend that configures the
site, and the install package (minus the Microsoft Runtime that are also in
there) is about 5 megs in size.  Given all the extra features of Apache, it
is a VERY powerful system.  Learning how to configure Apache is pretty easy
for basic things, learning to write Apache modules is pretty easy too.
Granted it isn't one physical file, but it can be installed with a simply
file copy, assuming you have something to create the config file.  I have a
template of the config file as a resource of the .net program, it updates
all the paths and stuff accordingly, then starts the server.  Real straight
forward and simple, but with tons and tons of power and a VERY battle
hardened web server!

Sam
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Gilles Ganault]

On Mon, 03 May 2010 15:22:27 +0200, Michael Schlenker
 wrote:
>You could take the Tcl WUB webserver, which already implements a SQLQ
>domain from an sqlite DB and use that. Easy to wrap in single file too.
>
>See http://code.google.com/p/wub/source/browse/trunk/Domains/SqlQ.tcl

Thanks for the link.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Sylvain Pointeau]

I would probably take mysql or postgresql, to be able to use the "prepared
statements" and other facilities.
I don't see any point to implement this kind of system.

or same api as sqlite but the open is taking an url instead,
but you have to re-write the api of sqlite.
In this case, I can see the benefit of keeping the same code, but as a
workaround for some additional non planned requirements, to use a sqlite
server instead. (the code stays untouched, just use another dll, same
functions same results)

anything I missed?

Best regards,
Sylvain


On Mon, May 3, 2010 at 3:27 PM, Gilles Ganault wrote:

> On Sun, 02 May 2010 21:26:27 +0200, Gilles Ganault
>  wrote:
> >It's probably quite an easy thing to do for someone well versed in C,
> >but I haven't seen a project that would combine a web server and
> >SQLite into a single EXE.
>
> Here's a diagram:
>
> http://img222.imageshack.us/img222/6578/wwwsqliteserver.jpg
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Gilles Ganault]

On Sun, 02 May 2010 21:26:27 +0200, Gilles Ganault
 wrote:
>It's probably quite an easy thing to do for someone well versed in C,
>but I haven't seen a project that would combine a web server and
>SQLite into a single EXE.

Here's a diagram:

http://img222.imageshack.us/img222/6578/wwwsqliteserver.jpg

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Michael Schlenker]

Sylvain Pointeau schrieb:
> option 1: a database server using sqlite behind the scene:
> - which language / protocole to use ?
> - which is the security model? (forget .htaccess, this is for apache /
> webserver)
> 
> option 2: web server using http
> - only SELECT statements?
> - returning JSON or whatever?
> - which protocole to use then? (there is no normalized protocole to do that)

You could take the Tcl WUB webserver, which already implements a SQLQ
domain from an sqlite DB and use that. Easy to wrap in single file too.

See http://code.google.com/p/wub/source/browse/trunk/Domains/SqlQ.tcl

Michael

-- 
Michael Schlenker
Software Architect

CONTACT Software GmbH   Tel.:   +49 (421) 20153-80
Wiener Straße 1-3   Fax:+49 (421) 20153-41
28359 Bremen
http://www.contact.de/  E-Mail: m...@contact.de

Sitz der Gesellschaft: Bremen
Geschäftsführer: Karl Heinz Zachries, Ralf Holtgrefe
Eingetragen im Handelsregister des Amtsgerichts Bremen unter HRB 13215
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Sylvain Pointeau]

option 1: a database server using sqlite behind the scene:
- which language / protocole to use ?
- which is the security model? (forget .htaccess, this is for apache /
webserver)

option 2: web server using http
- only SELECT statements?
- returning JSON or whatever?
- which protocole to use then? (there is no normalized protocole to do that)

On Mon, May 3, 2010 at 2:50 PM, Sylvain Pointeau  wrote:

> this is not clear for me.
>
> On Mon, May 3, 2010 at 2:49 PM, Gilles Ganault wrote:
>
>> On Mon, 3 May 2010 14:47:48 +0200, Sylvain Pointeau
>>  wrote:
>> >if you speak about MySQL or POSTGRESQL
>> >then you mean database server, not a web server.
>>
>> Yes. Please read the thread, starting with my original post where I
>> explain the idea.
>>
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Sylvain Pointeau]

this is not clear for me.

On Mon, May 3, 2010 at 2:49 PM, Gilles Ganault wrote:

> On Mon, 3 May 2010 14:47:48 +0200, Sylvain Pointeau
>  wrote:
> >if you speak about MySQL or POSTGRESQL
> >then you mean database server, not a web server.
>
> Yes. Please read the thread, starting with my original post where I
> explain the idea.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Gilles Ganault]

On Mon, 3 May 2010 14:47:48 +0200, Sylvain Pointeau
 wrote:
>if you speak about MySQL or POSTGRESQL
>then you mean database server, not a web server.

Yes. Please read the thread, starting with my original post where I
explain the idea.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Sylvain Pointeau]

if you speak about MySQL or POSTGRESQL
then you mean database server, not a web server.

Do you want to have a server where to connect for making your SELECT, UPDATE
DELETE, CREATE?
or do you want a webserver to just do some SELECT? (and having a XML, JSON
or whatever)

Best regards,
Sylvain


On Mon, May 3, 2010 at 2:43 PM, Gilles Ganault wrote:

> On Mon, 3 May 2010 14:41:10 +0200, Sylvain Pointeau
>  wrote:
> >How do you authenticate to your http sqlite web server?
> >is it not a security issue then?
>
> SQLite is meant for local use, so people interested in an SQLite
> server would operate on a small LAN, protected from the Net by a
> firewall.
>
> If authentication/obfuscation is needed, what about .htaccess and
> HTTPS?
>
> >is there something I didn't understand?
>
> I'd like a single EXE so it's as easy to deploy as SQLite. Otherwise,
> I'd just use MySQL or PostgreSQL.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Gilles Ganault]

On Mon, 3 May 2010 14:41:10 +0200, Sylvain Pointeau
 wrote:
>How do you authenticate to your http sqlite web server?
>is it not a security issue then?

SQLite is meant for local use, so people interested in an SQLite
server would operate on a small LAN, protected from the Net by a
firewall.

If authentication/obfuscation is needed, what about .htaccess and
HTTPS?

>is there something I didn't understand?

I'd like a single EXE so it's as easy to deploy as SQLite. Otherwise,
I'd just use MySQL or PostgreSQL.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Sylvain Pointeau]

How do you authenticate to your http sqlite web server?
is it not a security issue then?

normally you would also need a server side language, so I would say apache
is the only way to go,
and also I don't understand why you need something specific to return JSON
object.
you can do it in 3 seconds in PHP or ASP.NET.

is there something I didn't understand?

Best regards,
Sylvain


On Mon, May 3, 2010 at 1:06 PM, Gilles Ganault wrote:

> On Mon, 3 May 2010 15:01:26 +0400, Alexey Pechnikov
>  wrote:
>
> >See http://wiki.tcl.tk/15722 Add SQLite into it - about few minuts of
> time.
>
> Thanks. If no one is interested in launching a project that would
> offer a single binary and maintain it, I'll try TCL-TK.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Gilles Ganault]

On Mon, 3 May 2010 15:01:26 +0400, Alexey Pechnikov
 wrote:

>See http://wiki.tcl.tk/15722 Add SQLite into it - about few minuts of time.

Thanks. If no one is interested in launching a project that would
offer a single binary and maintain it, I'll try TCL-TK.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Alexey Pechnikov]

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

-- 
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Gilles Ganault]

On Mon, 3 May 2010 11:24:49 +0100, Simon Slavin
 wrote:
>If you're going to mostly pass data for use with web applications then JSON is 
>possibly a more appropriate format

Thanks, I'll check it out.

>The problem is not in coding it -- that's relatively easy.  The problem is in 
>who would use it.

Anyone who is currently using SQLite but needs...
0. a supported (so it's updated when a new version of SQLite comes out
that might require some changes in the solution)
1. cross-platform (so the server can run on Windows, Linux, MacOS)
2. easy-to-deploy client/server alternative since it's a single binary
3. that simply listens on a TCP port instead of the headaches of
sharing a directory with SMB/CIFS
4. to safely share an SQLite database among a few concurrent clients
(otherwise, people would just use a full-fledged DMBS)
5. and uses HTTP so that no specific client-side component is required

I don't know if it'd be easier to combine existing HTTP server +
SQLite, or go from Fossil and remove things that aren't needed.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Gilles Ganault]

On Sun, 2 May 2010 20:31:15 +0100, Simon Slavin
 wrote:
>How are you seeing this ?  You send your SQL queries via HTTP and it answers 
>by replying with XML ?

XML or TAB-separated text. Using regexes, it's easy to parse data,
unless someone knows of a better way.
Besides, if there are a lot of SELECTed data, since any HTTP library
worth its salt handles GZIP, the server can zip data before sending
them over the wire.

Actually, it seems like this single-EXE SQLite server could be
achieved simply by ripping unneeded code from Dr. Hipp's other great
software, the Fossil source control management software:

www.fossil-scm.org

Ideally, the Windows version could be started either as a stand-alone
EXE or as a Service.

For those great C developers out there: What do you think of this
idea?

Thank you.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Matt Young]

Thanks, I will follow up.

On 5/2/10, Gabor Grothendieck  wrote:
> SQLite and R are already integrated through the RSQLite/DBI packages
> and even higher level facilities (which I have posted about on this
> thread) also exist.  I think that such an integration would logically
> be done by R people rather than sqlite people.
>
> In the discussion on this thread integration may mean different things
> to different people so if you are referring to specific features
> beyond what exists (such as a SQL functions written in R or stored
> procedures written in R) then you can (1) speak with the RSQLite
> package maintainer to see if he is interested in adding them or (2) if
> you are interested in contributing then also discuss it with him, or
> (3) if you are referring to specific features that make more sense in
> certain other R packages (sqldf, RODBC, RJDBC, sqliteDF) then you can
> communicate to the maintainers of those packages.
>
> On Sun, May 2, 2010 at 8:38 PM, Matt Young  wrote:
>> I want to see SQLite integrated into the R statistical package. R Project
>> http://www.gardenersown.co.uk/Education/Lectures/R/regression.htm#multiple_regression
>>
>> for example.
>>
>> R statistical is very and becoming more popular, has great plotting,
>> and wrestles data in frames that look awfully like sql tables.  R has
>> built in procedure function, can cast text around fairly powerfully
>> and so on.  It is begging for the sqlite engine.
>>
>> Like me, getting better access to government statistical table.
>>
>>
>> On 5/2/10, Gilles Ganault  wrote:
>>> Hello,
>>>
>>> It's probably quite an easy thing to do for someone well versed in C,
>>> but I haven't seen a project that would combine a web server and
>>> SQLite into a single EXE.
>>>
>>> Besides ease of deployment, this would offer a cross-platform solution
>>> that wouldn't require developing a specific client-side connector,
>>> since both hosts would speak HTTP.
>>>
>>> Would someone with enough know-how be interested in giving it a shot?
>>> Are there technical reasons why it wouldn't be a good idea?
>>>
>>> Thank you.
>>>
>>> ___
>>> sqlite-users mailing list
>>> sqlite-users@sqlite.org
>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>>
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Gabor Grothendieck]

SQLite and R are already integrated through the RSQLite/DBI packages
and even higher level facilities (which I have posted about on this
thread) also exist.  I think that such an integration would logically
be done by R people rather than sqlite people.

In the discussion on this thread integration may mean different things
to different people so if you are referring to specific features
beyond what exists (such as a SQL functions written in R or stored
procedures written in R) then you can (1) speak with the RSQLite
package maintainer to see if he is interested in adding them or (2) if
you are interested in contributing then also discuss it with him, or
(3) if you are referring to specific features that make more sense in
certain other R packages (sqldf, RODBC, RJDBC, sqliteDF) then you can
communicate to the maintainers of those packages.

On Sun, May 2, 2010 at 8:38 PM, Matt Young  wrote:
> I want to see SQLite integrated into the R statistical package. R Project
> http://www.gardenersown.co.uk/Education/Lectures/R/regression.htm#multiple_regression
>
> for example.
>
> R statistical is very and becoming more popular, has great plotting,
> and wrestles data in frames that look awfully like sql tables.  R has
> built in procedure function, can cast text around fairly powerfully
> and so on.  It is begging for the sqlite engine.
>
> Like me, getting better access to government statistical table.
>
>
> On 5/2/10, Gilles Ganault  wrote:
>> Hello,
>>
>> It's probably quite an easy thing to do for someone well versed in C,
>> but I haven't seen a project that would combine a web server and
>> SQLite into a single EXE.
>>
>> Besides ease of deployment, this would offer a cross-platform solution
>> that wouldn't require developing a specific client-side connector,
>> since both hosts would speak HTTP.
>>
>> Would someone with enough know-how be interested in giving it a shot?
>> Are there technical reasons why it wouldn't be a good idea?
>>
>> Thank you.
>>
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Simon Slavin]

On 3 May 2010, at 1:38am, Matt Young wrote:

> I want to see SQLite integrated into the R statistical package.

You have our permission.  Go ahead.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Matt Young]

I want to see SQLite integrated into the R statistical package. R Project
http://www.gardenersown.co.uk/Education/Lectures/R/regression.htm#multiple_regression

for example.

R statistical is very and becoming more popular, has great plotting,
and wrestles data in frames that look awfully like sql tables.  R has
built in procedure function, can cast text around fairly powerfully
and so on.  It is begging for the sqlite engine.

Like me, getting better access to government statistical table.


On 5/2/10, Gilles Ganault  wrote:
> Hello,
>
> It's probably quite an easy thing to do for someone well versed in C,
> but I haven't seen a project that would combine a web server and
> SQLite into a single EXE.
>
> Besides ease of deployment, this would offer a cross-platform solution
> that wouldn't require developing a specific client-side connector,
> since both hosts would speak HTTP.
>
> Would someone with enough know-how be interested in giving it a shot?
> Are there technical reasons why it wouldn't be a good idea?
>
> Thank you.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Kees Nuyt]

On Sun, 02 May 2010 21:26:27 +0200, Gilles Ganault
 wrote:

>Hello,
>
>It's probably quite an easy thing to do for someone well versed in C,
>but I haven't seen a project that would combine a web server and
>SQLite into a single EXE.

It may not be what you mean, but you should have a look at
fossil (also by drh):
http://www.fossil-scm.org/index.html/doc/tip/www/index.wiki
-- 
  (  Kees Nuyt
  )
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Alexey Pechnikov]

it's easy for TCL developers. You may build tclsqlite+tclhttpd+your
tcl scripts as starpack (single executable binary). For integrate
SQLite database into starpack use this extension:
http://www.siftsoft.com/tclsqlitevfs.html

This is work fine on linux/windows and some other platforms.

-- 
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[g...@greschenz.de]

hi,
 
i did this some years ago:
1) sqlite
2) spidermonkey
3) my own http server
if you are interested, i have to search my old code...
 
bye, gg
 

Gilles Ganault  hat am 2. Mai 2010 um 21:26 geschrieben:

> Hello,
>
> It's probably quite an easy thing to do for someone well versed in C,
> but I haven't seen a project that would combine a web server and
> SQLite into a single EXE.
>
> Besides ease of deployment, this would offer a cross-platform solution
> that wouldn't require developing a specific client-side connector,
> since both hosts would speak HTTP.
>
> Would someone with enough know-how be interested in giving it a shot?
> Are there technical reasons why it wouldn't be a good idea?
>
> Thank you.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Simon Slavin]

On 2 May 2010, at 8:26pm, Gilles Ganault wrote:

> It's probably quite an easy thing to do for someone well versed in C,
> but I haven't seen a project that would combine a web server and
> SQLite into a single EXE.
> 
> Besides ease of deployment, this would offer a cross-platform solution
> that wouldn't require developing a specific client-side connector,
> since both hosts would speak HTTP.

How are you seeing this ?  You send your SQL queries via HTTP and it answers by 
replying with XML ?

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Gilles Ganault]

Hello,

It's probably quite an easy thing to do for someone well versed in C,
but I haven't seen a project that would combine a web server and
SQLite into a single EXE.

Besides ease of deployment, this would offer a cross-platform solution
that wouldn't require developing a specific client-side connector,
since both hosts would speak HTTP.

Would someone with enough know-how be interested in giving it a shot?
Are there technical reasons why it wouldn't be a good idea?

Thank you.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users